Re: Admin.pl problems

["john" <..hidden..>]

----- Original Message ----- 
From: "Chris Travers" <..hidden..>
To: <..hidden..>
Sent: Tuesday, July 08, 2008 1:45 PM
Subject: Re: [Ledger-smb-users] Admin.pl problems


> On Tue, Jul 8, 2008 at 11:37 AM, john <..hidden..> wrote:
> > Greetings all,
> >
> > how do I correct:
> >
> > Error!
> >
> > LedgerSMB/User.pm.387
> > FATAL:password authentication failed for user "postgres"
>
> This is when you are creating a database?
>
> If you know the password for the postgres account, you enter it in the
> superuser password box.
>
> If you have not set it, you can log in via psql (assuming local
> connections are set to trust auth) and:
>
> ALTER USER postgres WITH PASSWORD '[secret]';
>
> Best Wishes,
> Chris Travers
>
> -------------------------------------------------------------------------
> 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

Chris,

Altering the postgres account dosen't have any effect.
I used:
sudo su postgres
psql
then your sql code. Psql responds with ALTER ROLE.
I then entered the postgres pw in the ledgersmb Accounting / Database 
Administration page
and enter a dataset name and select US General.

John