php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #17831 PostgreSQL support broken
Submitted: 2002-06-19 06:51 UTC Modified: 2002-10-24 01:00 UTC
Votes:2
Avg. Score:4.0 ± 1.0
Reproduced:1 of 1 (100.0%)
Same Version:0 (0.0%)
Same OS:0 (0.0%)
From: dirk dot mueller at uni-kl dot de Assigned: yohgaki (profile)
Status: No Feedback Package: Apache2 related
PHP Version: 4.2.1 OS: Solaris 7
Private report: No CVE-ID: None
 [2002-06-19 06:51 UTC] dirk dot mueller at uni-kl dot de
when using PHP with Apache2, all calls to pg_connect() 
fail immediately without any apparent reason.  
 
The PHP error message is "Could not connect to remote 
host: No such file or directory".  
 
an example call that fails is:  
 
$dbh = pg_connect("host=1.2.3.4 user=name dbname=db 
password=pw") 
 
 
The very same PHP works fine with Apache 1.3 and this php 
version.  
 
Support for PgSQL is compiled in 
 

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2002-06-19 22:53 UTC] yohgaki@php.net
The test scripts works with Linux/PostgreSQL/Apache2 except pg_last_notice().

Could you check PostgreSQL server error logs to see what is going on?


 [2002-06-19 22:57 UTC] yohgaki@php.net
Could you also try lastest snap?

http://snaps.php.net/
 [2002-06-20 20:26 UTC] dirk dot mueller at uni-kl dot de
With the latest STABLE snap  (which doesn't compile out of 
the box with current apache 2 btw) it works, but only 
sometimes. continuous reload of the same page sometimes 
shows you a successful connect, but also sometimes a 
failure. ratio is about 70% failure and 30% success.  
 
the postgres server log doesn't say anything in the case 
of a failure, it seems it doesn't even come that far.  
however, I don't have full debug logging enabled, will try 
that later, as well as a latest (non STABLE) snap.
 [2002-08-17 12:36 UTC] aaron@php.net
Although I haven't tried running PostgreSQL under Solaris,
it works great for me under Linux 2.2. Perhaps you
need to try a newer version of Postgres?
 [2002-10-08 22:49 UTC] iliaa@php.net
Please try using this CVS snapshot:

  http://snaps.php.net/php4-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php4-win32-latest.zip

Using the snapshot I cannot replicate the problem on Linux 2.4
 [2002-10-24 01:00 UTC] php-bugs at lists dot php dot net
No feedback was provided for this bug for over 2 weeks, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Sat Dec 21 15:01:29 2024 UTC