[PHP-DEV] PHP 4.0 Bug #7381: Connect to postgres -> weirdness From: mdagosta <email protected>
Date: 10/21/00

From: mdagosta <email protected>
Operating system: OpenBSD
PHP version: 4.0.3pl1
PHP Bug Type: PostgreSQL related
Bug description: Connect to postgres -&gt; weirdness

Environment
-----------
PHP 4.0.3pl1, PHP 4.0.2 (tried both)
OpenBSD 2.7
Apache 1.3.12 (that ships with OpenBSD 2.7) (with SSL)
Postgres 7.0.2

Browsing from:
Windows 2000
Internet Explorer 5.0
Netscape Communicator 4.75

Script that breaks apache or php.
---------------------------------
<html>
<head><title>PHP/Apache Bails</title></head>
<body>

Test<br>
<?php $conn = dbConnect("dbname=test"); ?>
After Test<br>

</body>
</html>

php.ini
-------
I just copied php.ini-dist to php.ini (it's unmodified)

./configure
-----------
'./configure' '--prefix=/usr/local/php' '--with-apxs' '--without-mysql' '--with-pgsql=/usr/local/pgsql'

Other Info
----------
In postgres, I set all the permissions for the web browser to be able to connect to the database.

Symptoms
--------
Both netscape and microsoft browsers say the page is unavailable. Sometimes IE says that "something strange happened" with no useful error message and serves up a blank page.

PHP works fine without the pg_pconnect().

Workaround
----------
Install apache-1.3.14 from scratch
Install php from scratch as a static module (not DSO)
You'll be able to connect to the database no problem.

Why's it a problem? I haven't been able to get SSL and PHP to run at the same time on any setup besides the apache that ships with OpenBSD, but then the database doesn't work. 

-- 
Edit Bug report at: http://bugs.php.net/?id=7381&edit=1

-- 
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: php-dev-unsubscribe <email protected>
For additional commands, e-mail: php-dev-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>