×

hi all, I’ve a problem during configuration of PostgreSQL with
phppgadmin, below you find the steps that I made to install it.

the problem is that when I login via phppgadmin with user “tommaso” and
password “pippo” tell me -> “Login Failed” but if in a shell I login
with the command: ‘$ psql -U tommaso template1’ ask me for password and
I enter without problem.

Debian Testing, version: PostgreSQL 7.5.12 e phppgadmin 3.5.6-1

…………………………..

My step for installation:

1. Modify the conf: /etc/postgresql/pg_hba.conf
local all trust
host all 127.0.0.1 255.0.0.0 trust

2. Add a temp user
# su – postgres
# createuser tmpuser

3. Login and add a real user with password
# psql -U tmpuser template1
and
CREATE USER tommaso WITH PASSWORD ‘pippo’ CREATEDB CREATEUSER;

4. Modify again the conf: /etc/postgresql/pg_hba.conf
local all password
host all 127.0.0.1 255.0.0.0 password

5. try login (with success in a shell)

…………………………………

my /etc/phppgadmin/apache.conf

Alias /phppgadmin /usr/share/phppgadmin/

Options +FollowSymLinks
AllowOverride None

order deny,allow
deny from all
allow from 127.0.0.0/255.0.0.0
allow from 192.168.77.0/255.255.255.0
# allow from all


php_flag magic_quotes_gpc Off
php_flag track_vars On
php_flag register_globals On
php_value include_path .

#
# AllowOverride All
#

#
#
# AllowOverride All
#