> 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