[horde] Session overflow

Claude Tompers claude.tompers at restena.lu
Mon Feb 18 10:13:41 UTC 2013

On 02/17/2013 07:22 AM, Michael M Slusarz wrote:
> Quoting Claude Tompers <claude.tompers at restena.lu>:
>> Hello,
>> We just found some powerusers in our horde system with Session data in
>> MySQL bigger than 64k (max size of type blob) causing horde to crash and
>> log them out.
>> MySQL cuts the serialized session object after 64k so when Horde reads
>> it again, it is not valid anymore.
>> We changed the SessionHandler.Session_Data column in the horde database
>> to mediumblob (16M) and the problem disappeared immediately.
>> Is this a known issue ?
> Yes - in fact, it is expressly mentioned in the main horde
> configuration file (horde/config/conf.xml).
My conf.xml only mentions the horde_prefs table, not the SessionHandler.
Are there other tables that can have the same issue ?
>> I suppose we are not the only ones with such
>> power users.
>> Shouldn't Horde log warnings of such overflows from MySQL ?
> IIRC, there is no warning (at least there used to not be).  MySQL
> silently discards all data over 64 KB.
I talked to my colleague who said that it is possible that MySQL does
not only send a warning, but a fatal error in these conditions.
He pointed me to the following document :
Would this be possible to do in Horde or are there other restrictions ?

kind regards,
> michael
> ___________________________________
> Michael Slusarz [slusarz at horde.org]

Claude Tompers
Ingénieur réseau et système
Fondation RESTENA - Réseau Téléinformatique de l'Education Nationale et de la Recherche
6, rue Richard Coudenhove-Kalergi
L-1359 Luxembourg

Tel: +352 424409 1
Fax: +352 422473

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 263 bytes
Desc: OpenPGP digital signature
URL: <http://lists.horde.org/archives/horde/attachments/20130218/1411027f/attachment.bin>

More information about the horde mailing list