[Bug 63141] Re: PHP (cli) exits with a segfault if pg_connect() called.

[Russell Smith]

I have marked all the moodle reports as duplicates of this bug.  They
exhibit the same symptoms as each other.

The workaround for the pg_connect generic bug is to disable the ssl
connection.  Manually altering the moodle connect string in connection
library to disable ssl also removes the segmentation fault in the moodle
cron run.

The very simple patch I used to test moodle is at the bottom.  This is a
workaround for the moodle problem if you don't need to use SSL for your
moodle db connections.  You could also disable ssl connections at the
postgresql end by;

1. ssl = false in postgresql.conf
2. alter pg_hba.conf to only have a hostnossl entry for the moodle user.

2 is a better option as it doesn't disable all instances of ssl on the
server.  It also will be faster for moodle as negotiating SSL is slow.

Overall the underlying problem is exactly the same, hence they are all
duplicates.

--- adodb-postgres64.inc.php.orig	2008-11-04 20:26:31.000000000 +1100
+++ adodb-postgres64.inc.php	2008-11-04 20:19:02.000000000 +1100
@@ -668,6 +668,7 @@
 		   		if ($user) $str .= " user=".$user;
 		   		if ($pwd)  $str .= " password=".$pwd;
 				if ($db)   $str .= " dbname=".$db;
+				$str .= " sslmode=disable";
 		}
 
 		//if ($user) $linea = "user=$user host=$linea password=$pwd dbname=$db port=5432";

-- 
PHP (cli) exits with a segfault if pg_connect() called.
https://bugs.launchpad.net/bugs/63141
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to php5 in ubuntu.