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

Re: Still Cannot Log In



Can you paste the log output of Apache and postgres?

On Mon, Oct 22, 2012 at 8:11 PM,  <..hidden..> wrote:
>
>
>
> -----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             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
>
>
>
> Thanks for that,no joy though :-(
>
>
>
> Cheers
>
> Richard
>
>
>
>
>
>
> ------------------------------------------------------------------------------
> 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
>