From: | Tom Browder <tom(dot)browder(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Unable to login to a remote host running postgresql via phppgadmin |
Date: | 2011-08-17 11:03:12 |
Message-ID: | CAFMGiz9urDrdA_PLZmm+XW2TkqT8ifHmk=bc_2=O+FjGdgPY6Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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.
I always get "login failed".
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;
Any help is appreciated.
Best regards,
-Tom
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Ribe | 2011-08-17 14:32:23 | Re: Using Postgresql as application server |
Previous Message | Sim Zacks | 2011-08-17 07:05:12 | Re: Using Postgresql as application server |