All geek questions in one place

PhpPgAdmin asks for a username and password

I installed PhpPgAdmin on CentOS. Each time you select an object (database, table, schema, ..), PhpPgAdmin asks me to enter my login and password.

The left menu (Servers → PostgreSQL) is not connected.

System

  • CentOS 5
  • PHP Version 5.1.6
  • PostgreSQL8.3.11

Thank you,

G. Padmanabhan.

+4
source share
3 answers

Your problem sounds like the session is lost. Possible sources of problems:

  • The browser does not accept cookies.
  • PHP cannot store session data because the session save path does not exist, is not writable, or there is no space left.
+6
source

This is most likely a permission / access issue for the session save path for php. This happened to me when I changed User and Group in httpd.conf (apache) to a different username. Php session files must have their group id at the same time. For Fedora, change the group as shown below (replacing the apache httpd group name):

sudo chgrp NEWUSER /var/lib/php/*

Reboot httpd after making the changes.

If this change does not work for your configuration, check your apache error logs (/ var / log / httpd / error_log) for more information - they will provide you with the session.save_path address that you will need. For instance:

Unknown: Failed to write session data (files). Make sure the current session.save_path settings are correct (/ var / lib / php / session)

+1
source

I ran into these problems and found a problem that I encountered. I have a limited user for a specific database. If you open other databases in a tree view and it says "Database loading failed", then you do not have permission to do so. He will then ask you every time you click on something to log in to access these databases. Close them, and everything should be fine.

0
source

Source: https://habr.com/ru/post/1341072/

More articles:


All Articles