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

Re: Still Cannot Log In

-----Original Message-----
From: Ye Chuah <..hidden..>
To: ledger-smb-users <..hidden..>
Sent: Sat, 20 Oct 2012 19:05
Subject: Re: [Ledger-smb-users] Still Cannot Log In

In pg_hba.conf you should see some config like this.

temporarily change all values of peer to md5

my guess is the reason you cannot log in is that pg is trying peer
authentication. this will not work as the user is the web server user
(something like www-data or nobody)

changing the type to md5 will change the auth method to username/password

# Database administrative login by Unix domain socket
local   all             postgres                                peer

# TYPE  DATABASE        USER            ADDRESS                 METHOD

# "local" is for Unix domain socket connections only
local   all             all                                     md5
# IPv4 local connections:
host    all             all               md5
# IPv6 local connections:
host    all             all             ::1/128                 md5
# Allow replication connections from localhost, by a user with the
# replication privilege.
#local   replication     postgres                                peer
#host    replication     postgres            md5
#host    replication     postgres        ::1/128                 md5

Thanks for that,no joy though :-(