On 18/08/2011 13:54, Tom Browder wrote: > On Thu, Aug 18, 2011 at 05:40, (ioguix) de Rorthais <ioguix@xxxxxxx> wrote: >> Hello, >> On 18/08/2011 01:20, Tom Browder wrote: > ... >>> I have these lines in my pg_hba.conf file: >>> >>> host all myuser <a remote host IP>/32 md5 >>> host all postgres <a remote host IP>/32 md5 >>> >>> 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. >>> I have made these changes in /etc/phppgadmin files: >>> >>> apache.conf: >>> >>> config.inc.php: >>> $conf['servers'][0]['desc'] = 'mars-postgresql'; >>> $conf['servers'][0]['host'] = 'local host ip address...'; >>> //$conf['extra_login_security'] = true; >>> $conf['extra_login_security'] = false; >> >> What do you mean by 'local host ip address...' ? 127.0.0.1 ? > > No, I had put in the actual server IP address but have changed and > tried '', and 'localhost'--none have worked. > >> 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 psql -h 127.0.0.1 postgres myuser first one use unix socket, second one inet. >>> I have asked this of the phppgadmin group but I think it may be my >>> postgresql setup. > >> Looks like I missed it...where ? > > Oops, I never sent the message, sorry, my mistake. > > 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
