Debian Bug report logs - #523421
php5-pgsql: PHP5 fails to connect to SSL based PostgreSQL servers, but only in apache2

Toggle useless messages

Message #5 received at submit@bugs.debian.org (full text, mbox, reply):

From: Patrick Cole <z@amused.net>

To: Debian Bug Tracking System <submit@bugs.debian.org>

Subject: php5-pgsql: PHP5 fails to connect to SSL based PostgreSQL servers, but only in apache2

Date: Fri, 10 Apr 2009 17:31:39 +1000

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@starfury][/var/www/htroot/test] $ php5 test.php
[z@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 2.6.8.1 (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

Message #10 received at 523421@bugs.debian.org (full text, mbox, reply):

From: Patrick Cole <z@amused.net>

To: 523421@bugs.debian.org

Subject: Update

Date: Fri, 10 Apr 2009 23:46:12 +1000

We can close this one.

After doing a dist-upgrade, the problem has magically disappeared.




-- 
Patrick Cole
Email  z@amused.net
Phone  0410626630

Message #15 received at 523421-done@bugs.debian.org (full text, mbox, reply):

From: Ondřej Surý <ondrej@sury.org>

To: 523421-done@bugs.debian.org

Subject: #523421: php5-pgsql: PHP5 fails to connect to SSL based PostgreSQL servers, but only in apache2

Date: Fri, 8 Jan 2010 17:44:18 +0100

Version: 5.2.6.dfsg.1-1+lenny4

> We can close this one.
>
> After doing a dist-upgrade, the problem has magically disappeared.

-- 
Ondřej Surý <ondrej@sury.org>
http://blog.rfc1925.org/

Send a report that this bug log contains spam.