Could you take a look at web server error log? 
Do you have anything related? (segfault, etc)

Could you run iPlanet under gdb? (to see if it is exting or segfaulting)

Do you quote connection string?
Do you get any error message from pg_connect? 
Do you have multiple libpq? (find / -name "libpq*")

Do you have the same problem with snapshot?
http://snaps.php.net/

Attach *complete* script even if it is a few lines next time.

I've also tried using the current CVS (01/26/2002) with no luck. The are no multiple copies of libpq, it's a new system.

I haven't tried running iPlanet under gdb yet, that'll be something to try tommorow.

In the mean time, here's the error from the logs:

[29/Jan/2002:22:50:18] info (14848): for host b-39-117-res1.mts.net trying to POST /members.php, PHP_log_message reports: PHP Warning:  Unable to connect to PostgreSQL server:  connectDBStart() -- connect() failed: No such file or directory
        Is the postmaster running (with -i) at 'db1'
        and accepting connections on TCP/IP port 5432?
 in /usr/local/etc/httpd/htdocs/cardp.ca/members.php on line 100

No other errors appear and the server keeps on running.

The source of the script (sans-HTML) calling the database follows:


<?

	$db = pg_connect("host='db1' user='cardp' dbname='cardp'");
	if(!$db) {
		echo "\nAn error occured connecting to the database.\n";
		exit;
	}

	if($alpha=="Show All") {
	$query = "SELECT last_name, first_name, address1, address2, address3,
					city, province, country, postal_code, email 
				FROM members WHERE active = TRUE ORDER BY last_name";
	} else {
	$query = "SELECT last_name, first_name, address1, address2, address3,
					city, province, country, postal_code, email 
				FROM members WHERE active = TRUE AND last_name LIKE '$alpha%' ORDER BY last_name";
	}

	$result = pg_exec($db, $query);
	if(!$result) {
		echo "An error occured executing the query.\n";
		exit;
	}

	$numFields = pg_numfields($result);
	$numRows = pg_numrows($result);

	if($numRows > 0) {
		for ($rowCount=0; $rowCount < $numRows; $rowCount++) {
			$row = pg_fetch_array($result, $rowCount);
			if($rowCount % 2) {
				print("<tr>\n");
			} else {
				print("<tr class=\"shade\">\n");
			}
			print("<td align=left valign=top width=200>");
			print("<B>" . $row["last_name"] . ", " . $row["first_name"] . "</B></td>\n");
			print("<td align=left valign=top width=200>");
			if($row["address1"]) {
				print($row["address1"] . "<br>\n");
			}
			if($row["address2"]) {
				print($row["address2"] . "<br>\n");
			}
			if($row["address3"]) {
				print($row["address3"] . "<br>\n");
			}
			print($row["city"] . ", " . $row["province"]);
			if($row["postal_code"]) {
				print(" " . $row["postal_code"] . "<br>\n");
			}
			if($row["country"] != "Canada") {
				print($row["country"] . "<br>\n");
			}
			if($row["email"]) {
				print("<a href=\"mailto:" . $row["email"] . "\">" . $row["email"] . "</a>\n");
			}
			print("</td>\n</tr>\n");
		}
		if(!($numRows % 2)) {
			print("<tr><td colspan=2 class=\"shade\">&nbsp;</td></tr>\n");
		}
	} else {
		print("<tr><td align=center valign=middle colspan=2>\n");
		print("<h2>Sorry</h2>\n");
		print("<B>There were no results that matched your query.</B>\n");
		print("<P>Please make another selection.</P>\n");
		print("</td></tr>\n");
	}

?>

- DR

This is not a bug but usual result with your configuration.
Read manual. It's explained :)

It's in the manual? Could you please be a little more specific? I've gone through the manual and cannot find anything regarding these results from this configuration.

I've managed to get this to work on a linux system using the same configuration without encountering the same problem. However, this is not an option within our current production environment.

As per your last question, yes. PostgreSQL is running with the -i option. Connections are successful from other systems (at least the 5 others I tried), but not using server parsed php. They are only successfull when using php from the comand line, using psql, or using perl.

- DR