From: Tom Browder <tom.browder@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Unable to login with phppgadmin on a remote host
Date: Wed, 17 Aug 2011 18:20:00 -0500
Message-ID: <CAFMGiz9DWRU4uYNTT3-y6GLYmPZ+DfATWhtEycfWX6aat6HZ9g@mail.gmail.com> (raw)
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" whether I use myuser or postgres.
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;
I have asked this of the phppgadmin group but I think it may be my
postgresql setup.
Any help is appreciated.
Best regards,
-Tom
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tom.browder@gmail.com
Subject: Re: Unable to login with phppgadmin on a remote host
In-Reply-To: <CAFMGiz9DWRU4uYNTT3-y6GLYmPZ+DfATWhtEycfWX6aat6HZ9g@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox