phppgadmin can't login,need help!

rushboy

in /etc/make.conf

[php]USE="X gtk gnome tcltk ssl postgresql unixODBC php apache apache2"
CFLAGS="-O3 -march=i686 -funroll-loops -pipe"[/php]


about my postgresql
in /etc/conf.d/postgresql

[php]GOPTS="-i -N 1024 -B 2048"[/php]

and in postgresql.conf,I set

[php]tcpip_socket = true
port = 5432[/php]

in  pg_hba.conf,I added
[php]host    all         postgres    192.168.1.49      255.255.255.0     md5[/php]

and I have changed postgres' passwd by
[php]ALTER USER postgres PASSWORD '123456';[/php]

I have done all of above,but the phppgadmin can't login yet.

Login disallowed


I missed sth?

the phppgadmin version is 3.2.1
:help

Debentoo Gao

这个东东我还没有登录成功过，以前我也发过帖子，但很快就沉下去了。我现在就用postgres登录控制台，psql -d xxx（数据库名）这样来操作。而且我发现emerge的phppgadmin的conf目录里竟然没有任何配置文件？

rushboy

phppgadmin disallows logins by default administrative users such as the postgres user.

so I did sth below.

[php]create user rks with password '********';
alter user rks createuser createdb;


host    all         rks         192.168.1.49      255.255.255.0     md5[/php]

now it works well~

Debentoo Gao

是吗？待会我也去试试看;)

Debentoo Gao

最初由 rushboy 发表
so I did sth below.

[php]create user rks with password '********';
alter user rks createuser createdb;


host    all         rks         192.168.1.49      255.255.255.0     md5[/php]

now it works well~

rushboy

nano -w /your-path/pgadmin/conf/config.inc.php

$conf['extra_login_security'] = false;

Debentoo Gao

已经搞定了;)