[GENERAL] connection fails

[paula]

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


---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] connection fails

[Nick Fankhauser]

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

 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED]]On Behalf Of
 [EMAIL PROTECTED]
 Sent: Friday, September 21, 2001 2:25 PM
 To: [EMAIL PROTECTED]
 Subject: [GENERAL] 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


 ---(end of broadcast)---
 TIP 4: Don't 'kill -9' the postmaster



---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])