Обсуждение: Where to troubleshoot phpPgAdmin login issues?

I am getting "Login failed" errors when attempting to log into phpPgAdmin as user 'postgres'. In what file path would I find the relevant log files, to try and identify why the login is being rejected? OS: CentOS 7 PostgreSQL: 9.6.6 pg_hba.conf settings for access: # TYPE DATABASE USER ADDRESS METHOD # "local" is for Unix domain socket connections only local all all peer # IPv4 local connections: #host all all 127.0.0.1/32 ident #host all all 127.0.0.1/32 md5 host all all 192.168.101.1/32 md5 # IPv6 local connections: #host all all ::1/128 ident 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 ident #host replication postgres ::1/128 ident

> On Nov 28, 2017, at 12:06 PM, Robert Gordon <rgordon@onetechbeyond.com> wrote:
>
> I am getting “Login failed” errors when attempting to log into phpPgAdmin as user ‘postgres’.   In what file path
wouldI find the relevant log files, to try and identify why the login is being rejected? 

Probably /var/lib/pgsql/data/pg_log or somewhere like that, if there's nothing obvious in /var/log.

You're not allowing connections from IPv4 localhost, though, and that's where I'd expect a sensibly configured
phpPgAdminto be trying to connect from (assuming it's on the same machine as the database). 

Cheers, Steve

>
> OS: CentOS 7
> PostgreSQL: 9.6.6
> pg_hba.conf settings for access:
> # TYPE  DATABASE        USER            ADDRESS                 METHOD
>
> # "local" is for Unix domain socket connections only
> local   all             all                                     peer
> # IPv4 local connections:
> #host    all             all             127.0.0.1/32            ident
> #host   all             all             127.0.0.1/32            md5
> host    all             all             192.168.101.1/32           md5
> # IPv6 local connections:
> #host    all             all             ::1/128                 ident
> 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            ident
> #host    replication     postgres        ::1/128                 ident