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

[Jason Clifton]

I have  no idea why thats happening but I am running horde on php  
5.2.0 with memcache session handler with no problems...

Quoting Kevin Conley <kevinconley at northwestern.edu>:

> 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
> connection.
>
> 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
> "/var/www/html/horde/lib/Horde/SessionHandler/mysql.php"]
>
> This seems to be the code throwing the error:
>
>         $query = sprintf('REPLACE INTO %s (session_id, session_data,
> session_lastmodified)' .
>                          ' VALUES (%s, %s, %s)',
>                          $this->_params['table'],
>                          $this->_quote($id),
>                          $this->_quote($session_data),
>                          time());
>
>         $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__,
> PEAR_LOG_ERR);
>             return false;
>         }
>
> -- 
> Kevin Conley
> Technology Support Services
> Northwestern University
> 847-491-4086
>
>
> -- 
> Horde mailing list - Join the hunt: http://horde.org/bounties/#horde
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: horde-unsubscribe at lists.horde.org



-- 
Jason Clifton
City Diesel
www.citydiesel.net