Bug #17831 Updated: PostgreSQL support broken

ID: 17831 Updated by: dirk.mueller@uni-kl.de Reported By: dirk.mueller@uni-kl.de -Status: Feedback +Status: Open Bug Type: Apache2 related Operating System: Solaris 7 PHP Version: 4.2.1 Assigned To: yohgaki New Comment: 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. Previous Comments: ------------------------------------------------------------------------ [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