Re: Still Cannot Log In

[Ye Chuah <..hidden..>]

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             127.0.0.1/32            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        127.0.0.1/32            md5
#host    replication     postgres        ::1/128                 md5

On Sun, Oct 21, 2012 at 3:33 AM, Robert James Clay <..hidden..> wrote:
> On Sat, 2012-10-20 at 09:47 -0400, lrspares45 wrote:
>
>> Completely uninstalled everything.
>>
>> Reinstalled everything (from deb package 1.3.17)
>
>    From where?  On what OS?
>
>
>
> Jame
>
>
>
> ------------------------------------------------------------------------------
> Everyone hates slow websites. So do we.
> Make your web apps faster with AppDynamics
> Download AppDynamics Lite for free today:
> http://p.sf.net/sfu/appdyn_sfd2d_oct
> _______________________________________________
> Ledger-smb-users mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users