On Wednesday 09 July 2008 09:05:44 am john wrote: > Drewc, > > [EMAIL PROTECTED]:/etc/postgresql/8.2/main$ sudo cat pg_hba.conf > [sudo] password for cj: > # Database administrative login by UNIX sockets > local all postgres ident sameuser
This is your problem. You've set it to ident sameuser for the user postgres. Since the process that's trying to connect is running apache's User setting, this will fail. Your best option is to give the postgres user a password and take that line out. Cheers, Chris > > # TYPE DATABASE USER CIDR-ADDRESS METHOD > # "local" is for Unix domain socket connections only > > #local all all ident sameuser > local all all md5 > > # IPv4 local connections: > host all all 127.0.0.1/32 md5 > > # IPv6 local connections: > host all all ::1/128 md5 > > ----- Original Message ----- > From: "Drew Crampsie" <[EMAIL PROTECTED]> > To: <[email protected]> > Sent: Tuesday, July 08, 2008 10:09 PM > Subject: Re: [Ledger-smb-users] Admin.pl problems > > > Hello all, > > > > I'm not a ledger-smb developer but: > > > > 2008/7/8 john <[EMAIL PROTECTED]>: > > [snip] > > > >> 2008-07-08 16:02:36 CDT LOG: incomplete startup packet > >> 2008-07-08 16:05:15 CDT FATAL: password authentication failed for user > >> "postgres" > >> 2008-07-08 16:05:15 CDT FATAL: password authentication failed for user > >> "postgres" > > > > This makes me think the password option is not enabled for the > > 'postgres' user on this database in your pg_hba.conf. > > > > Forgive me if i'm wrong, but i see this a lot as i support a number of > > postgres users :). > > > > Cheers, > > > > drewc > > > > ------------------------------------------------------------------------- > > Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW! > > Studies have shown that voting for your favorite open source project, > > along with a healthy diet, reduces your potential for chronic lameness > > and boredom. Vote Now at http://www.sourceforge.net/community/cca08 > > _______________________________________________ > > Ledger-smb-users mailing list > > [email protected] > > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users > > ------------------------------------------------------------------------- > Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW! > Studies have shown that voting for your favorite open source project, > along with a healthy diet, reduces your potential for chronic lameness > and boredom. Vote Now at http://www.sourceforge.net/community/cca08 > _______________________________________________ > Ledger-smb-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users ------------------------------------------------------------------------- Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW! Studies have shown that voting for your favorite open source project, along with a healthy diet, reduces your potential for chronic lameness and boredom. Vote Now at http://www.sourceforge.net/community/cca08 _______________________________________________ Ledger-smb-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
