connection fails
Hello,
I\'m trying to connect using an extremely simple php script:
$conn = pg_Connect(\"host=localhost dbname=db name user=postgres password=postgres\");
if ($conn) { echo \"ok\"; }
else { echo \"failed\"; }
I get this error message:
Warning: Unable to connect to PostgreSQL server: connectDBStart() -- connect() failed: Connection refused Is the postmaster running (with -i) at \'localhost\' and accepting connections on TCP/IP port 5432? in /var/www/sts.twcable.com/launch_plan/test/c.php on line 3
failed
I also tried to work from the command line and get similar error messages.
The weird thing is that phpPgAdmin is working fine and this script works:
$database = pg_Connect (\"dbname=dbname\");
pg_exec ($database, \"begin\");
$oid = pg_locreate ($database);
echo (\"$oid\\n\");
$handle = pg_loopen ($database, $oid, \"w\");
echo (\"$handle\\n\");
pg_lowrite ($handle, \"gaga\");
pg_loclose ($handle);
pg_exec ($database, \"commit\");
[script coming from php.net]
Any ideas??
thnx!
/paula
----------------------------------------------------------------
:: www.nervemail.net :: free access to POP3 accounts
I'm not a PHP-er, but I notice that a difference between the script that
works & the one that doesn't is the "host=... portion. Could it be that
phpPgAdmin & the script that works do *not* use tcpip to connect & while the
failing script does?
If so, the message you got also contains the answer- you need to turn the
tcpip_socket on in the .conf file, or change the first script to not specify
a host.
-Nick
Show quoted text
-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of
paula@cyberlazarus.net
Sent: Friday, September 21, 2001 2:25 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] connection failsHello,
I\'m trying to connect using an extremely simple php script:
$conn = pg_Connect(\"host=localhost dbname=db name user=postgres
password=postgres\");if ($conn) { echo \"ok\"; }
else { echo \"failed\"; }I get this error message:
Warning: Unable to connect to PostgreSQL server: connectDBStart()
-- connect() failed: Connection refused Is the postmaster running
(with -i) at \'localhost\' and accepting connections on TCP/IP
port 5432? in /var/www/sts.twcable.com/launch_plan/test/c.php on line 3
failedI also tried to work from the command line and get similar error messages.
The weird thing is that phpPgAdmin is working fine and this script works:$database = pg_Connect (\"dbname=dbname\");
pg_exec ($database, \"begin\");
$oid = pg_locreate ($database);
echo (\"$oid\\n\");
$handle = pg_loopen ($database, $oid, \"w\");
echo (\"$handle\\n\");
pg_lowrite ($handle, \"gaga\");
pg_loclose ($handle);
pg_exec ($database, \"commit\");[script coming from php.net]
Any ideas??
thnx!
/paula----------------------------------------------------------------
:: www.nervemail.net :: free access to POP3 accounts---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
Postgres already gave you the first idea:
failed: Connection refused Is the postmaster running (with -i) at
\'localhost\' and accepting connections on TCP/IP port 5432? in
/var/www/sts.twcable.com/launch_plan/test/c.php on line 3
failed
Since you are using TCP to connect, have you verified that postmaster is
actually listening and on the expected port? It doesn't by default--by
default it uses a unix domain socket. You have to specify TCP using the -i
option.
Keary Suska
Esoteritech, Inc.
"Leveraging Open Source for a better Internet"
Show quoted text
From: paula@cyberlazarus.net
Reply-To: paula@cyberlazarus.net
Date: 21 Sep 2001 19:25:25 -0000
To: pgsql-general@postgresql.org
Subject: [GENERAL] connection failsHello,
I\'m trying to connect using an extremely simple php script:
$conn = pg_Connect(\"host=localhost dbname=db name user=postgres
password=postgres\");if ($conn) { echo \"ok\"; }
else { echo \"failed\"; }I get this error message:
Warning: Unable to connect to PostgreSQL server: connectDBStart() -- connect()
I also tried to work from the command line and get similar error messages.
The weird thing is that phpPgAdmin is working fine and this script works:$database = pg_Connect (\"dbname=dbname\");
pg_exec ($database, \"begin\");
$oid = pg_locreate ($database);
echo (\"$oid\\n\");
$handle = pg_loopen ($database, $oid, \"w\");
echo (\"$handle\\n\");
pg_lowrite ($handle, \"gaga\");
pg_loclose ($handle);
pg_exec ($database, \"commit\");[script coming from php.net]
Any ideas??
thnx!
/paula----------------------------------------------------------------
:: www.nervemail.net :: free access to POP3 accounts---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
I'm not a PHP-er, but I notice that a difference between the script that
works & the one that doesn't is the "host=... portion. Could it be that
phpPgAdmin & the script that works do *not* use tcpip to connect & while
the
failing script does?
If so, the message you got also contains the answer- you need to turn the
tcpip_socket on in the .conf file, or change the first script to not
specify
a host.
You may also have to modify pg_hba.conf (in addition to postgresql.conf).
See the comments in the file for details, but you need a line something
like:
host all 172.16.0.0 255.255.0.0 password
where 172.16.0.0 is replaced by the appropriate network and 255.255.0.0 by
the appropriate netmask.
Hope this helps,
Joe
You may be able to get away without this if localhost is the only host
involved- I'm pretty sure the default pg_hba.conf file already has localhost
set up in it. (I'm sure it does in the Debian package, and would guess this
is true of the others.)
You may also have to modify pg_hba.conf (in addition to postgresql.conf).
See the comments in the file for details, but you need a line something
like:host all 172.16.0.0 255.255.0.0 password
where 172.16.0.0 is replaced by the appropriate network and 255.255.0.0 by
the appropriate netmask.
-Nick