phppgadmin problems

[QurazyQuisp]

I'm currently having problems with phppgadmin.

I can create delete modify databases via cpanel, however, when I try to use phppgadmin, under servers PostgreSQL has a red x next to it. I try to login with both root and postgres and it says that the users are not allowed for security reasons.

This is very frustrating, as it renders postgresql basically useless. (I haven't had much luck with pgadmin either)

Does anyone have any idea what I can do?

 

[SoftDux]

hey, have you been able to get this sorted out?

 

[Danks]

My fix was editing /var/lib/pgsql/data/pg_hba.conf and moving the last two lines

local   all             all     md5
host    all             all     127.0.0.1 255.255.255.255       md5

above the commented line

# "local" is for Unix domain socket connections only

then restarting with /scripts/restartsrv_postgres

 

[Sabaote]

Thanks Danks..

it really worked

 

[chaitanya]

PhpPgAdmin root login access

PostgraceSqlPhpPgAdmin login failed root not able to login
====================================
If you are keep getting "login failed".error while accessing the PhpPgAdmin you have to follow the setp below

1.Edit vi /var/lib/pgsql/data/pg_hba.conf like below:

local all all md5
host all all 127.0.0.1 255.255.255.0 md5
~
~3
2. Save this & restart the PostgraceSql using
/etc/init.d/postgresql restart
=============================================================

By default the root access is denied on PhpPgAdmin. If you want it enable it all you need to do is login as root change
it to False as given below

#$conf['extra_login_security'] = true;
$conf['extra_login_security'] = false;

Note: You need to have root access on your Server

 

[jba_21]

My fix was editing /var/lib/pgsql/data/pg_hba.conf and moving the last two lines

local   all             all     md5
host    all             all     127.0.0.1 255.255.255.255       md5

above the commented line

# "local" is for Unix domain socket connections only

then restarting with /scripts/restartsrv_postgres

Thanks! it works.