asked on

phpPgAdmin 4.1.3 (PHP 4.4.4) not working with postgres 8.2.4

Hi,

My hosting company has recently upgraded my postgres database to 8.2.4 and the upgrade worked perfectly except I can no longer login to the database using phpPgAdmin. I'm in a shared server environment and they upgraded to phpPgAdmin 4.1.3 (PHP 4.4.4) to make sure it wasn't a problem with an older version of phpPgAdmin.

I am still able to login via psql and via my jdbc connection in my java webapp with my main username and password and a database specific useraname and password, so we can't figure out what the problem is. They have contacted the developers of phpPgAdmin, but haven't received any answer.

gheist

You have to review phpinfo() and phppgadmin settings if they point to correct postgreswl server - i.e localhost or 127.0.0.1 or ::1, not hostname or host IP address.
What was previous version?

courtenayt

ASKER

Thanks so much for your help!

Here is the response from my host company:

The PhpPGAdmin settings are the same as were defined in the previous PhpPgAdmin config.inc.php file. I have found that Postgres 8.2.4 has a new function called CONNECT which I am not sure if it is causing a problem with the PhpPGAdmin setting. What specifically were they wanting us to review in the phpinfo page?

The previous version was 4.0.1

ASKER CERTIFIED SOLUTION

gheist

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

courtenayt

ASKER

I've sent your response to my host company along with some other ideas, but haven't heard back from them yet. I'll let you know as soon as I know more.

Thanks,
Courtenay

courtenayt

ASKER

My host compnay was able to resolve the problem. The said: " I ended up rebuilding the actual postgres install, phppgadmin, and all of the php plugins to support postgres connections. "

gheist

Problem was seen on phpinfo()