Page 1 of 1

phpPgAdmin

Posted: Wed Jan 12, 2011 1:20 pm
by SeanFromIT
The VMware notes says phpPgAdmin should be installed on the image but I can't find it. There's phpMyAdmin but no phpPgAdmin?

Re: phpPgAdmin

Posted: Wed Jan 12, 2011 1:42 pm
by tonyyarusso
Perhaps it was installed by default in an earlier version and removed later without updating the notes, or put in the notes but then not actually added ever. In any case, a 'yum install phpPgAdmin' will get it for you.

Re: phpPgAdmin

Posted: Wed Jan 12, 2011 3:13 pm
by SeanFromIT
After successful install, trying root/nagiosxi results in "Login disallowed for security reasons."

What all needs to be changed in /usr/share/phpPgAdmin/conf/config.inc.php to allow connections to the Nagios XI PostgreSQL DB's?

Re: phpPgAdmin

Posted: Thu Jan 13, 2011 10:17 am
by mguthrie
I haven't used phpPgAdmin before, but I grabbed this from their faq page:
Q: For some users I get a "Login disallowed for security" message.

A: Logins via phpPgAdmin with no password or certain usernames (pgsql, postgres, root, administrator) are denied by default. Before changing this behaviour (setting $conf['extra_login_security'] to false in the config.inc.php file) please read the PostgreSQL documentation about client authentication and understand how to change PostgreSQL's pg_hba.conf to enable passworded local connections.
http://phppgadmin.sourceforge.net/?page=faq

Re: phpPgAdmin

Posted: Thu Jan 13, 2011 10:20 am
by tonyyarusso
From the PhpPgAdmin FAQ:
Q: For some users I get a "Login disallowed for security" message.

A: Logins via phpPgAdmin with no password or certain usernames (pgsql, postgres, root, administrator) are denied by default. Before changing this behaviour (setting $conf['extra_login_security'] to false in the config.inc.php file) please read the PostgreSQL documentation about client authentication and understand how to change PostgreSQL's pg_hba.conf to enable passworded local connections.

Re: phpPgAdmin

Posted: Thu Jan 13, 2011 10:21 am
by tonyyarusso
Ha, simultaneous reply fun :P

Re: phpPgAdmin

Posted: Thu Jan 20, 2011 4:03 pm
by SeanFromIT
FYI: Default username is postgres, default password is nagiosxi.

Re: phpPgAdmin

Posted: Mon Jan 24, 2011 11:35 am
by mguthrie
Thanks for posting this, I was having to hunt for this as well.