Control Web Panel

WebPanel => CentOS-WebPanel Bugs => Topic started by: adrianofnatal on March 18, 2024, 06:35:05 PM

Title: Problem installing PostgreSQL and phpPgAdmin
Post by: adrianofnatal 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!