#17831 [Opn->Fbk]: PostgreSQL support broken

ID: 17831 Updated by: iliaa@php.net Reported By: dirk.mueller@uni-kl.de -Status: Open +Status: Feedback Bug Type: Apache2 related Operating System: Solaris 7 PHP Version: 4.2.1 Assigned To: yohgaki New Comment: 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 Previous Comments: ------------------------------------------------------------------------ [2002-08-17 12:36:33] 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-06-20 20:26:14] dirk.mueller@uni-kl.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-06-19 22:57:17] yohgaki@php.net Could you also try lastest snap? http://snaps.php.net/ ------------------------------------------------------------------------ [2002-06-19 22:53:47] 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 06:51:26] dirk.mueller@uni-kl.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 ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=17831&edit=1