On 9/11/07, Joseph <[EMAIL PROTECTED]> wrote:
>
> I'm trying to create dataset and I'm getting an error:
> LedgerSMB/User.pm:386
> FATAL: password authentication failed for user "postgres"
>
> It seems like password for "postgres" is not recognized, even though it
> is correct.
>
> I think there is a conflict. The system I'm trying to install LedgerSMB
> runs SQL-Ledger as well, so when I was creating user:
> createuser --createdb -U postgres --pwprompt --encrypted ledgersmb
>
> file: pg_hba.conf was:
> local all all trust
> # IPv4 local connections:
> host all all 127.0.0.1/32 trust
>
> and password for user "postgres" worked; after
> $ psql -U ledgersmb -d ledgersmb
> ledgersmb=> UPDATE users_conf SET password = md5('MYPASSWORD') WHERE id =
> 1;
>
> This worked as well, next in order to login I had to change file:
> pg_hba.conf to:
> local all all md5
> # IPv4 local connections:
> host all all 127.0.0.1/32 md5
>
> at this point I can login but I can not create "dataset"
> I think the password for "postgres" is getting encrypted where as
> originally it was set unencrypted.
change the auth types back to trust for a moment.
Then log in as postgres
run the following command:
ALTER USER postgres WITH PASSWORD '[secret]';
Then change the auth types back to md5 (note that any change to the
pg_hba.conf requires restarting PostgreSQL.
Best Wishes,
Chris Travers
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Ledger-smb-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
