[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Problems with upgrade from 1.2.x to current version





On Tue, Jan 31, 2012 at 8:39 AM, Linda Ursin <..hidden..> wrote:
It's the default configuration. I haven't touched it. What should be there that isn't?

Now that I have had a chance to sleep on this just a little....
 
Basically you have two options.

1)  I suspect you are missing a database port assignment in your ledgersmb.conf.   If you add that in, it will fix the problem.

2)  You could also grant all users md5 access to the database in question.  This would not be sufficient to use the setup.pl to create new databases though.

What's happening is that the first rule here requires the postgres user on all local connections to be logged in to the operating system as the postgres operating system user.  In 1.2 this is not a problem.  In 1.3, this is, because you have to have a superuser that creates/manages the databases, and by default that's postgres.

Your PostgreSQL configuration is set up with basically two rule sets.  The first, for local UNIX socket connections is:

If user is postgres, ask OS what user the individual is logged in as, and if not postgres, deny.
If user and db are ledgersmb, ask for password
otherwise ask OS what user the individual is logged in as and require that it matches the requested db user.

The second rule set, for TCP/IP connections is much more simple:

Always ask for a password.

It seems to me that the easiest answer here is to correct the ledgersmb.conf.  It might be worth attaching or pasting it inline on the reply to this email and we can talk about the best way to set this up.

 

Linda

~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~

Linda Ursin
Heksebua

Adresse:                      Tlf:     (+47) 402 40 767
Solvang                        www:     http://heksebua.com
7288 Soknedal              E-post:  ..hidden..

Org: NO 995 578 107


On Tue, Jan 31, 2012 at 4:13 PM, Chris Travers <..hidden..> wrote:


On Tue, Jan 31, 2012 at 7:01 AM, Linda Ursin <..hidden..> wrote:
How is that possible when I haven't changed it? ( I changed it back to default after trying trust)

1.3 handles things a bit differently, security-wise, so it isn't entirely surprising that some configurations that worked with 1.2 are not working with 1.3.
 

This is what it looks like:

-----
# Database administrative login by UNIX sockets
local   all         postgres                          ident 
 
local   ledgersmb       ledgersmb               md5


Try changing hte above two lines to:
local        ledgersmb        all                 md5
local        all                    postgres       md5 


# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD

# "local" is for Unix domain socket connections only
local   all         all                               ident. 
# IPv4 local connections:
host    all         all         127.0.0.1/32          md5



# IPv6 local connections:
host    all         all         ::1/128               md5

-----

The rest is commented out.

Linda


~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~

Linda Ursin
Heksebua

Adresse:                      Tlf:     (+47) 402 40 767
Solvang                        www:     http://heksebua.com
7288 Soknedal              E-post:  ..hidden..

Org: NO 995 578 107


On Tue, Jan 31, 2012 at 3:53 PM, Chris Travers <..hidden..> wrote:


On Tue, Jan 31, 2012 at 6:26 AM, Linda Ursin <..hidden..> wrote:
[Tue Jan 31 15:42:15 2012] [error] [client 193.69.154.79] DBI connect('dbname=template1','postgres',...) failed: FATAL:  Ident authentication failed for user "postgres" at LedgerSMB.pm line 982, referer: http://lur.aitel.hist.no/ledgersmb/setup.pl

You have a bad line in your pg_hba.conf

Best Wishes,
Chris Travers
 


~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~

Linda Ursin
Heksebua

Adresse:                      Tlf:     (+47) 402 40 767
Solvang                        www:     http://heksebua.com
7288 Soknedal              E-post:  ..hidden..

Org: NO 995 578 107


On Tue, Jan 31, 2012 at 3:22 PM, Chris Travers <..hidden..> wrote:


On Tue, Jan 31, 2012 at 6:10 AM, Linda Ursin <..hidden..> wrote:
ALTER USER "postgres" WITH VALID UNTIL '2013-11-09'; didn't help, even if the command worked.

If I was still using the old ledgersmb confiuration for apache, my installation would be available through http://..../regnskap/
but it isn't, it's aat http://......./ledgersmb/

 Ok, so ruling that out.....

can you check your httpd error logs and see what it prints when it gives the auth dialog?

Best Wishes,
Chris Travers  

------------------------------------------------------------------------------
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users



------------------------------------------------------------------------------
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users



------------------------------------------------------------------------------
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users



------------------------------------------------------------------------------
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users



------------------------------------------------------------------------------
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users



------------------------------------------------------------------------------
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users