[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
conflict ? password authentication failed for user "postgres"
- Subject: conflict ? password authentication failed for user "postgres"
- From: Joseph <..hidden..>
- Date: Tue, 11 Sep 2007 17:39:52 -0600
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.
Is it the case? How to go about it?
In addition with pg_hba.conf set to "md5" I can not log into SQL-Ledger.
Do I have to createuser without "-encrypted" and password without "md5"?
--
#Joseph