[horde] large session entries in horde_sessionhandler

liam hoekenga liamr at umich.edu
Tue May 17 13:37:45 PDT 2005


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. */
?>


More information about the horde mailing list