PostgreSQL 7.3 and SuSE 8.1 problem

On Wed, 22 Jan 2003, Andrei Verovski wrote:

Hi,

I have problem with SuSE Linux 8.1 and PostgreSQL 7.3 (all SuSE built
packages).

PostgreSQL server (which is launched via "rcpostgesql start") refuses
connections from localhost (to any database), whenever I am trying to
connect with phpPgAdmin or pgaccess with message "blah blah blah...
refused connection" as user "postgres" and no password (or password of
UNIX user "postgres").

Did you turn on the tcpip_socket configuration option in postgresql.conf?

Hi,

On Wed, Jan 22, 2003 at 05:42:55PM +0200, Andrei Verovski wrote:

PostgreSQL server (which is launched via "rcpostgesql start") refuses
connections from localhost (to any database), whenever I am trying to
connect with phpPgAdmin or pgaccess with message "blah blah blah...
refused connection" as user "postgres" and no password (or password of
UNIX user "postgres").

However, I can connect with psql command-line utility as user
"postgres", AND with Webmin (without any additional logon parameters
except root/password at the beginning). This is quite strange.

I have checked PostgreSQL config files (hba.conf), and enabled all
connections from localhost and local network (192.168.*.*) with "trust"
parameter.

localhost is on the 127.0.0.0/8 network.

Also, I have changed password for UNIX user "postgres" as "abc", but
anyway, it did not worked from PHP and pgaccess.

The unix password has no connction to the postgres password.

Hope this helps,
-tb
--
Thomas Beutin tb@laokoon.IN-Berlin.DE
Beam me up, Scotty. There is no intelligent live down in Redmond.