English 中文(简体)
PhpPgAdmin asks enter login and password
原标题:

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

Left side menu (Servers->PostgreSQL) not connected.

System

  • CentOS 5
  • PHP Version 5.1.6
  • PostgreSQL8.3.11

thank you,

G. Padmanabhan.

最佳回答

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

  • Browser does not accept cookies
  • PHP cannot store session data because the session save path does not exist, is not writable or no space is left
问题回答

This is most likely a permissions / ownership issue for the session save path for php. This happened to me when I changed the User and Group in httpd.conf (apache) to a different username. The php sessions files must have their group id s changed at the same time. For Fedora, modify the group as below (substituting the group name of apache httpd):

sudo chgrp NEWUSER /var/lib/php/*

Restart httpd after making this change.

If this change does not work for your configuration, check your apache error logs (/var/log/httpd/error_log) for more information- they will give you the location of the session.save_path that needs your attention. For example:

Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/var/lib/php/session)

I ran into this issues and found the problem I was having. I have a limited user to a specific database. If you open the other databases in the tree view and it says "Error Loading Database" then you don t have permission to those. It will then ask you every time you click on something to login to get access to those databases. Close them and it should be fine.





相关问题
摘录数据

我如何将Excel板的数据输入我的Django应用? I m将PosgreSQL数据库作为数据库。

Postgres dump of only parts of tables for a dev snapshot

On production our database is a few hundred gigabytes in size. For development and testing, we need to create snapshots of this database that are functionally equivalent, but which are only 10 or 20 ...

How to join attributes in sql select statement?

I want to join few attributes in select statement as one for example select id, (name + + surname + + age) as info from users this doesn t work, how to do it? I m using postgreSQL.

What text encoding to use?

I need to setup my PostgreSQL DB s text encoding to handle non-American English characters that you d find showing up in languages such as German, Spanish, and French. What character encoding should ...

SQL LIKE condition to check for integer?

I am using a set of SQL LIKE conditions to go through the alphabet and list all items beginning with the appropriate letter, e.g. to get all books where the title starts with the letter "A": SELECT * ...

热门标签