----- Original Message ----- 
From: "Chris Travers" <[EMAIL PROTECTED]>
To: <[email protected]>
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 <[EMAIL PROTECTED]> 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
> [email protected]
> 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


-------------------------------------------------------------------------
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

Reply via email to