phpPgAdmin

[SeanFromIT]

The VMware notes says phpPgAdmin should be installed on the image but I can't find it. There's phpMyAdmin but no phpPgAdmin?

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

[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?

[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

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

[tonyyarusso]

Ha, simultaneous reply fun

[SeanFromIT]

FYI: Default username is postgres, default password is nagiosxi.

[mguthrie]

Thanks for posting this, I was having to hunt for this as well.