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. >> 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 >> 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
