[horde] large session entries in horde_sessionhandler

[liam hoekenga]

Since we upgraded to Horde 3.0.4 / IMP 4.0.3 / Ingo 1.0.1 / Turba 2.0.2 a couple
weeks back, the mysql server we're using as a backend has been sad.  We're using
the shared session support, and our horde_sessionhandler is getting some very
large data stored in it (100mb strings).

Our innodb logs are complaining, and replication is sad.

What else could be the cause?  The cache system is set to store items in the
file system, but our session data also seems to contain files (this is messy):

a:0:{}s:22:"_contentTypeParameters";a:2:{s:7:"charset";s:8:"us-ascii";s:8:"boundary";s:20:"B_3179668417_6493612";}s:6:"_parts";a:3:{i:1;R:89;i:2;R:113;i:3;R:190;}s:12:"_information";a:1:{s:2:"id";b:0;}s:5:"_cids";a:0:{}s:7:"_mimeid";i:0;s:4:"_eol";s:1:"\n";s:6:"_flags";a:3:{s:7:"setType";b:1;s:11:"contentsSet";b:1;s:18:"lastTransferDecode";s:4:"7bit";}s:6:"_idmap";a:0:{}s:9:"_boundary";
s:14:"=_1nmkoebghwtc";s:6:"_bytes";i:0;s:10:"_contentid";N;}s:5:"_conf";
a:0:{}}s:25:"=_1nv5f66zxzes
text/plain";O:21:"imp_mime_viewer_plain":3:{s:9:"mime_part";O:9:"mime_part":20:{s:5:"_type";s:9:"multipart";s:8:"_subtype";s:11:"appledouble";s:9:"_contents";s:616500:"^M\n--B_3179668238_6476275^M\nContent-type:
application/applefile; name="Jseaweed-s.jpg"^M\nContent-transfer-encoding:
base64^M\nContent-disposition:
attachment^M\n^M\nAAUWBwACAAAAAAAAAAAAAAAAAAAAAAAAAAMAAAAJAAAAPgAAACAAAAADAAAAXgAAAA4AAAAC^M\n

Does the message currently getting viewed (including attachments) get stored in
the session data?

I've attached our conf file.  (our auth driver, cosign, is a modified version of
the auto drive, setting the user name to $_SERVER['REMOTE_USER']).


<?php
/* CONFIG START. DO NOT CHANGE ANYTHING IN OR AFTER THIS LINE. */
// $Horde: horde/config/conf.xml,v 1.74.2.5 2005/03/22 11:40:14 jan Exp $
$conf['debug_level'] = E_NOTICE;
$conf['max_exec_time'] = 0;
$conf['use_ssl'] = 2;
$conf['server']['name'] = $_SERVER['SERVER_NAME'];
$conf['server']['port'] = $_SERVER['SERVER_PORT'];
$conf['compress_pages'] = true;
$conf['umask'] = 077;
$conf['session']['name'] = 'Horde';
$conf['session']['cache_limiter'] = 'nocache';
$conf['session']['timeout'] = 0;
$conf['cookie']['domain'] = $_SERVER['SERVER_NAME'];
$conf['cookie']['path'] = '/horde';
$conf['sql']['persistent'] = false;
$conf['sql']['hostspec'] = '***';
$conf['sql']['username'] = 'horde';
$conf['sql']['password'] = '***';
$conf['sql']['port'] = 3306;
$conf['sql']['protocol'] = 'tcp';
$conf['sql']['database'] = 'horde';
$conf['sql']['charset'] = 'iso-8859-1';
$conf['sql']['phptype'] = 'mysql';
$conf['auth']['admins'] = array('liamr', 'clunis', 'wes');
$conf['auth']['checkip'] = true;
$conf['auth']['driver'] = 'cosign';
$conf['signup']['allow'] = false;
$conf['signup']['approve'] = true;
$conf['signup']['preprocess'] = false;
$conf['signup']['queue'] = false;
$conf['log']['priority'] = PEAR_LOG_NOTICE;
$conf['log']['ident'] = 'HORDE';
$conf['log']['params'] = array();
$conf['log']['name'] = '/tmp/horde.log';
$conf['log']['params']['append'] = true;
$conf['log']['type'] = 'file';
$conf['log']['enabled'] = true;
$conf['log_accesskeys'] = false;
$conf['prefs']['params']['driverconfig'] = 'horde';
$conf['prefs']['driver'] = 'sql';
$conf['datatree']['params']['driverconfig'] = 'horde';
$conf['datatree']['driver'] = 'sql';
$conf['group']['driver'] = 'datatree';
$conf['cache']['default_lifetime'] = 1800;
$conf['cache']['params']['dir'] = Horde::getTempDir();
$conf['cache']['driver'] = 'file';
$conf['token']['driver'] = 'none';
$conf['mailer']['params']['sendmail_path'] = '/usr/sbin/sendmail';
$conf['mailer']['params']['sendmail_args'] = '-oi';
$conf['mailer']['type'] = 'sendmail';
$conf['vfs']['params']['driverconfig'] = 'horde';
$conf['vfs']['type'] = 'sql';
$conf['sessionhandler']['params']['persistent'] = false;
$conf['sessionhandler']['params']['port'] = 3306;
$conf['sessionhandler']['params']['protocol'] = 'tcp';
$conf['sessionhandler']['params']['hostspec'] = '***';
$conf['sessionhandler']['params']['username'] = 'horde';
$conf['sessionhandler']['params']['password'] = '***';
$conf['sessionhandler']['params']['database'] = 'sessions';
$conf['sessionhandler']['type'] = 'mysql';
$conf['geoip']['datafile'] = '/etc/GeoIP.dat';
$conf['problems']['email'] = 'webmaster at umich.edu';
$conf['menu']['always'] = false;
$conf['menu']['links']['help'] = 'all';
$conf['menu']['links']['options'] = 'all';
$conf['menu']['links']['problem'] = 'never';
$conf['menu']['links']['login'] = 'never';
$conf['menu']['links']['logout'] = 'authenticated';
$conf['hooks']['username'] = false;
$conf['hooks']['preauthenticate'] = false;
$conf['hooks']['postauthenticate'] = false;
$conf['hooks']['authldap'] = false;
$conf['weatherdotcom']['partner_id'] = '';
$conf['weatherdotcom']['license_key'] = '';
$conf['kolab']['enabled'] = false;
/* CONFIG END. DO NOT CHANGE ANYTHING IN OR BEFORE THIS LINE. */
?>