Author Topic: Problem installing PostgreSQL and phpPgAdmin  (Read 571 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
Problem installing PostgreSQL and phpPgAdmin
« on: March 18, 2024, 06:35:05 PM »
Hi!

Im using CWPPro and having some trouble with PostgreSQL and phpPgAdmin.
The installation of PostgreSQL database server was fine using root panel. I can create databases and users.
When I install phpPgAdmin using command /script/install_phpPgAdmin the command runs fine, no errors, but when I click in phpPgAdmin a PHP error occured telling me that I does'n have PHP module enabled.
I tried to enable module but with no success.

I found a site with another installing method that worked:
https://www.alphagnu.com/topic/321-how-to-enable-pgadmin/

But when I try to login in database, does not work. Always show "Login Failed" and this database log:
2024-03-18 17:54:23.515 GMT [523] LOG:  provided user name (XXXXX) and authenticated user name (cwpsvc) do not match
2024-03-18 17:54:23.515 GMT [523] FATAL:  Peer authentication failed for user "XXXXX"
2024-03-18 17:54:23.515 GMT [523] DETAIL:  Connection matched pg_hba.conf line 84: "local   all             all                                     peer"

Is this a bug?
I have to change some configuration file?

Thanks!