On Wed, Aug 17, 2011 at 19:14, Craig Ringer <ringerc@xxxxxxxxxxxxx> wrote: > On 18/08/2011 7:20 AM, Tom Browder wrote: >> >> I have installed postgresql 9.0.4 from source on aUbuntu 10.04 LTS >> 64-bit remote host. >> >> I have installed phppgadmin, Apache2, and other required programs and >> libraries via the Ubuntu package manager. >> >> I have successfully created the user posgtres, executed initdb >> successfully, and can execute pqsql to connect to template1, all while >> logged in via ssh onto the remote host >> >> I have set postgresql to listen on all. >> >> 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. > > Given the config you showed, that *should* work. Did you restart apache > after altering your phppgadmin config? Yes, I did. > It's usually best to have phppgadmin (or whatever) connect to 127.0.0.1 for > localhost, rather than the public IP address anyway. I'd recommend letting > phppgadmin connect to localhost (127.0.0.1/32) and setting that to md5 auth > in pg_hba.conf . I've just done that and that doesn't help. > Most web-based database apps don't work well with "ident" authentication > because they're all running under the apache or www-data user, so you'll > need to add a like for the database(s) and user(s) of interest that > specifies md5 auth. For example, if your admin app uses the "postgres" user > and you want it to access all databases: > > host all postgres 127.0.0.1/32 md5 > > (or the "local" clause instead if your app uses a unix socket). I have set both. I have an admin user now and neither are allowed to login: "login failed" Best, -Tom -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
