[horde] MySQL session handler problems with Horde 2.2

Ethan Weinstein lists at stinkfoot.org
Wed Jan 22 10:52:56 PST 2003


I installed horde 2.2, and am attempting to use the mysql session
handler.  I'm getting these errors while trying to login:

Jan 22 11:55:42 spicymeatball HORDE[1966]: [horde] SQL Query by
SessionHandler_mysql::read(): query = "SELECT session_data FROM
mysql_sessionhandler WHERE session_id =
f36fabe85b2e0c576b6b6943fcc06276" [on line 96 of
"/usr/local/apache2/htdocs/horde2/lib/SessionHandler/mysql.php"]
Jan 22 11:55:42 spicymeatball HORDE[1966]: [horde] Error retrieving
session data (id = f36fabe85b2e0c576b6b6943fcc06276) [on line 104 of
"/usr/local/apache2/htdocs/horde2/lib/SessionHandler/mysql.php"]
Jan 22 11:55:42 spicymeatball \177ÿêx\177ÿê|[1966]: [horde] SQL Query by
SessionHandler_mysql::write(): query = "REPLACE INTO
mysql_sessionhandler (session_id, session_data, session_lastmodified)
VALUES (f36fabe85b2e0c576b6b6943fcc06276,
prefs_cache|a:1:{s:7:\"_filled\";a:0:{}}hordeMessageStacks|a:1:{s:6:\"status\";a:0:{}},
1043254542)" [on line 124 of
"/usr/local/apache2/htdocs/horde2/lib/SessionHandler/mysql.php"]
Jan 22 11:55:42 spicymeatball \177ÿêx\177ÿê|[1966]: [horde] Error
writing session data [on line 128 of
"/usr/local/apache2/htdocs/horde2/lib/SessionHandler/mysql.php"]

The mysql_sessionhandler table does exist within the horde db, the
permissions and username+password are definately correct..  Here's what
I have in horde.php:

$conf['sessionhandler']['type'] = 'mysql';

// Database or other drivers might require configuration parameters
// here.
$conf['sessionhandler']['params'] = array();
$conf['sessionhandler']['params']['phptype'] = 'mysql';
$conf['sessionhandler']['params']['hostspec'] = 'localhost';
$conf['sessionhandler']['params']['username'] = 'horde';
$conf['sessionhandler']['params']['password'] = 'password_deleted';
$conf['sessionhandler']['params']['database'] = 'horde2';
$conf['sessionhandler']['params']['table'] = 'mysql_sessionhandler';

What gives?  and what's with the bizarre syslog messages
"\177ÿêx\177ÿê|[1966]:" ?? Did I forget a param?

I was using a custom mysql sessionhandler with horde 2.1 and it worked
quite well.

thanks,


Ethan Weinstein




More information about the horde mailing list