[php-maint] Bug#523421: php5-pgsql: PHP5 fails to connect to SSL based PostgreSQL servers, but only in apache2

Patrick Cole z at amused.net
Fri Apr 10 07:31:39 UTC 2009

Package: php5-pgsql
Version: 5.2.6.dfsg.1-1+lenny2
Severity: normal

When attempting to execute the following script via apache2 (http://www.linearg.com/test/test.php)
the following error occurs.  This happened after upgrading php5 to lenny.

Warning: pg_connect() [function.pg-connect]: Unable to connect to PostgreSQL server: could not create SSL context: no SSL error reported in /var/www/htroot/test/test.php on line 3

All the script does is a pg_connect() - nothing else.  The actual database connection itself
is fine, this seems to be some underlying problem since upgrading.

If I run the same script in php5 (cli) it works fine:

[z at starfury][/var/www/htroot/test] $ php5 test.php
[z at starfury][/var/www/htroot/test] $                        

I'm not really sure how to go about debugging this one.  Some direction would be great.

-- System Information:
Debian Release: 3.0
  APT prefers oldstable
  APT policy: (500, 'oldstable'), (500, 'stable')
Architecture: i386 (i686)

Kernel: Linux (SMP w/2 CPU cores)
Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968)
Shell: /bin/sh linked to /bin/bash

Versions of packages php5-pgsql depends on:
ii  libapache2-mod-php 5.2.6.dfsg.1-1+lenny2 server-side, HTML-embedded scripti
ii  libc6              2.7-18                GNU C Library: Shared libraries
ii  libpq5             8.3.6-1               PostgreSQL C client library
ii  php5-cgi [phpapi-2 5.2.6.dfsg.1-1+lenny2 server-side, HTML-embedded scripti
ii  php5-cli [phpapi-2 5.2.6.dfsg.1-1+lenny2 command-line interpreter for the p
ii  php5-common        5.2.6.dfsg.1-1+lenny2 Common files for packages built fr

php5-pgsql recommends no packages.

php5-pgsql suggests no packages.

-- no debconf information

More information about the pkg-php-maint mailing list