On Thu, Aug 18, 2011 at 07:37, Jehan-Guillaume (ioguix) de Rorthais <ioguix@xxxxxxx> wrote: > On 18/08/2011 13:54, Tom Browder wrote: >> On Thu, Aug 18, 2011 at 05:40, (ioguix) de Rorthais <ioguix@xxxxxxx> wrote: >>> On 18/08/2011 01:20, Tom Browder wrote: ... >>>> However, I cannot successfully login with phppgadmin on the remote host. >>>> >>>> I always get "login failed" whether I use myuser or postgres. >>> >>> Do you have errors in your postgresql log files about this connections >>> attempts ? >> >> No, only some sql errors from an early user creation. > You should have some FATAL or ERROR entries about your attempts to > connect. That means phpPgAdmin doesn't even reach PostgreSQL. ... >>> Please, show us your full pg_hba.conf (without comments and public IP >>> address). >> >> My pg_hba.conf: >> >> local all all md5 >> host all all 127.0.0.1/32 md5 >> host all all ::1/128 md5 >> host all admin xx.xxx.xxx.xx/32 md5 >> host all postgres xx.xxx.xxx.xx/32 md5 > > sounds good. > That means that you did set a password to user postgres ? did you try to > login with the following commands using your own system user (not postgres): > > psql postgres postgres That exact command works. (Note that I am logged in via ssh onto the remote postgresql host as my normal system user 'tom'.) > psql -h 127.0.0.1 postgres myuser That exact command works. > first one use unix socket, second one inet. Is there a possibility my postgresql.conf file needs changing to get good logging? I originally changed no defaults and my system postgresql start file puts all info into "server.log" in $PGDATA. This morning I changed one line in that conf file (and then did a reload): #logging_collector = off # Enable capturing of stderr and csvlog logging_collector = on # Enable capturing of stderr and csvlog I also checked /var/log/auth.log and see no evidence of login attempts from my two postgres users except vial local logins. Thanks, Jehan-Guillaume. -Tom -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
