[horde] mysql session handler P.S. P.S.

Kevin Conley kevinconley at northwestern.edu
Fri Feb 23 14:36:11 PST 2007

I tried to print out the mysql_error and mysql_errno but they were both blank.

But i did print out the query string being sent to mysql causing the error and 
here it is:

REPLACE INTO horde_sessionhandler (session_id, session_data, 
session_lastmodified) VALUES ('', '', 1172269840)

Seems session_id and session_data are empty.

Also, am getting a seg fault in the apache log:

[Fri Feb 23 16:30:41 2007] [notice] child pid 20700 exit signal Segmentation 
fault (11)

Anybody have any insights into this?
Does any have any problems running HORDE on PHP5?

Does anybody think it is a good ideas to run a production system on PHP5?
I am using RHEL with:
apache 2.0.55
mySQL 5.0.18
PHP 5.1.2
HORDE 3.1.3
IMP 4.1.3
TURBA 2.1.3

I have it working great with default PHP session handler. However whenever i try
to switch to the mySQL based sessionhandler i get an error. I am already using
mySQL as the pref handler and they are on the same maching using socket based

Any ideas on why this is happening?

Here is the error:

Feb 23 14:58:07 HORDE [error] [imp] Error writing session data [on line 144 of

This seems to be the code throwing the error:

         $query = sprintf('REPLACE INTO %s (session_id, session_data,
session_lastmodified)' .
                          ' VALUES (%s, %s, %s)',

         $result = @mysql_query($query, $this->_db);
         if (empty($this->_params['rowlocking'])) {
             @mysql_query('UNLOCK TABLES ' . $this->_params['table'], $this->_db);
         if (!$result) {
             @mysql_query('ROLLBACK', $this->_db);
             Horde::logMessage('Error writing session data', __FILE__, __LINE__,
             return false;

Kevin Conley	
Technology Support Services
Northwestern University

More information about the horde mailing list