[horde] Horde 3.1.1 MySQL session handler does not handle sessions

[Otto Stolz]

Hello,

after upgrading my Horde test installation to 3.1.1,
I experience the following weird symptoms:
- <https://webmailtest.rz.uni-konstanz.de/horde/test.php> works OK,
   the session counter works as described in horde/docs/INSTALL;
- but when I try to log in via
   <https://webmailtest.rz.uni-konstanz.de/horde/login.php>
   I am back to a blank login screen after a couple of seconds;
- when I use the preliminary configuration from horde/config/conf.php.dist,
   I can log in as Administrator;
- but as soon as I have configured Horde (via the HTML interface),
   I cannot login (as descriebd supra).

The Horde log says:
> May 09 15:22:23 Horde3test [notice] [horde] Login success
>     for Otto.Stolz at uni-konstanz.de [134.34.1.44]
>     to Horde [on line 90 of "/opt/test-webmail/horde/login.php"]

But the PHP error log says:
> [09-Mai-2006 15:22:22] PHP Notice:  Undefined index:
>     password_expiration in /opt/test-webmail/horde/lib/Horde/Auth/ldap.php
>     on line 252
> [09-May-2006 15:22:23] PHP Notice:  Undefined index:
>     rowlocking in /opt/test-webmail/horde/lib/Horde/SessionHandler/mysql.php
>     on line 139
> [09-May-2006 15:22:23] PHP Notice:  Undefined index:
>     rowlocking in /opt/test-webmail/horde/lib/Horde/SessionHandler/mysql.php
>     on line 139
> [09-May-2006 15:22:23] PHP Notice:  Undefined index:
>     rowlocking in /opt/test-webmail/horde/lib/Horde/SessionHandler/mysql.php
>     on line 139

I have altered the engine of the sessionhandler table, as described in
horde/docs/UPGRADING. Mysql "show table status" reveals:
> | Name                      | Engine | Version | Row_format | Rows   | ...
> +---------------------------+--------+---------+------------+--------+ ...
> | horde_sessionhandler      | InnoDB |       9 | Dynamic    |      7 | 
(The engines of all other tables is MyISAM.)

My environment:
- Horde 3.1.1
- PHP 4.4.2
- Apache/1.3.34 (Unix) mod_ssl/2.8.25 OpenSSL/0.9.7e PHP/4.4.2
- MySQL 4.1.16-log
- SunOS 5.9
- Firefox 1.0.7

Excerpt from horde/config/conf.php:
> // $Horde: horde/config/conf.xml,v 1.74.2.14 2005/08/23 17:14:42 mrubinsk Exp $
> $conf['debug_level'] = E_ALL;
> $conf['use_ssl'] = 1;
> $conf['server']['name'] = $_SERVER['SERVER_NAME'];
> $conf['server']['port'] = 443;
> $conf['session']['name'] = 'Horde3test';
> $conf['session']['cache_limiter'] = 'nocache';
> $conf['session']['timeout'] = 0;
> $conf['sql']['persistent'] = false;
> $conf['sql']['hostspec'] = 'localhost';
> $conf['sql']['username'] = 'horde3test';
> $conf['sql']['socket'] = '/var/run/mysql/sock';
> $conf['sql']['protocol'] = 'unix';
> $conf['sql']['database'] = 'horde3test';
> $conf['sql']['charset'] = 'utf-8';
> $conf['auth']['checkip'] = true;
> $conf['auth']['params']['hostspec'] = 'cartero.rz.uni-konstanz.de';
> $conf['auth']['params']['basedn'] = 'ou=people,o=universitaet konstanz,c=de';
> $conf['auth']['params']['version'] = '3';
> $conf['auth']['params']['uid'] = 'mail';
> $conf['auth']['params']['objectclass'] = array('(objectclass=*)');
> $conf['auth']['params']['filter_type'] = 'objectclass';
> $conf['auth']['driver'] = 'ldap';
> $conf['sessionhandler']['params']['persistent'] = false;
> $conf['sessionhandler']['params']['socket'] = '/var/run/mysql/sock';
> $conf['sessionhandler']['params']['protocol'] = 'unix';
> $conf['sessionhandler']['params']['hostspec'] = 'localhost';
> $conf['sessionhandler']['params']['username'] = 'horde3test';
> $conf['sessionhandler']['params']['database'] = 'horde3test';
> $conf['sessionhandler']['params']['table'] = 'horde_sessionhandler';
> $conf['sessionhandler']['type'] = 'mysql';
> $conf['menu']['always'] = false;
> $conf['hooks']['username'] = false;
> $conf['hooks']['preauthenticate'] = false;
> $conf['hooks']['postauthenticate'] = false;
> $conf['hooks']['authldap'] = false;

How can I get Horde usable, again?

Thanks for any hints.
Best wishes,
   Otto Stolz