Re: Where to troubleshoot phpPgAdmin login issues?

> On Nov 28, 2017, at 12:06 PM, Robert Gordon <rgordon(at)onetechbeyond(dot)com> wrote:
>
> 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?

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 phpPgAdmin to 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