[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

conflict ? password authentication failed for user "postgres"



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