Re: Admin.pl problems

[Christopher Murtagh <..hidden..>]

On Wednesday 09 July 2008 09:05:44 am john wrote:
> Drewc,
>
> ..hidden..:/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" <..hidden..>
> To: <..hidden..>
> 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 <..hidden..>:
> > [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
> > ..hidden..
> > 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
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users