[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 315
  • Last Modified:

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.
0
courtenayt
Asked:
courtenayt
  • 3
  • 3
1 Solution
 
gheistCommented:
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?
0
 
courtenaytAuthor Commented:
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
0
 
gheistCommented:
You have to look if PHP or PhpPgAdmin connects to socket where postgresql server listens. CONNECT function does not change the way server works.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
courtenaytAuthor Commented:
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
0
 
courtenaytAuthor Commented:
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. "
0
 
gheistCommented:
Problem was seen on phpinfo()
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now