On 18/08/2011 15:37, Tom Browder wrote: > 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. make sure you can connect to the "$conf['servers'][0]['defaultdb']" using myuser: psql -h 127.0.0.1 template1 myuser Then, it should work with the following line in your "conf/config.inc.php" using user myuser: $conf['servers'][0]['host'] = '127.0.0.1'; > >> 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 with * log_destination = 'stderr' * logging_collector = on You will find your log file in the folder defined in "log_directory" with name set in parameter "log_filename". > > 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
