[horde] Undefined variables in MySQL Session handler (Horde 3.1.1)

Wed May 10 05:58:21 PDT 2006

Hello,

After installing Horde 3.1.1, I cannot anymore establish a session.

The new MySQL tables for 3.11 and 3.1 are in place; cf. infra.

scripts/upgrades/move_history_out_of_datatree.php said:
> Done. Migrated 19 objects.
> PHP Notice:  Undefined index:  rowlocking
> in /opt/test-webmail/horde/lib/Horde/SessionHandler/mysql.php
> on line 140 
> Notice: Undefined index:  rowlocking
> in /opt/test-webmail/horde/lib/Horde/SessionHandler/mysql.php
> on line 140

So, there is an undefined variable named $this->_params['rowlocking'].

When I try to login to Horde (via HTTPS), with an unknown user-id,
or with a wrong password, the PHP error log says:
> [10-May-2006 13:05:56] PHP Notice:  Undefined index:  rowlocking
>     in /opt/test-webmail/horde/lib/Horde/SessionHandler/mysql.php
>     on line 139

When I try to login to Horde with my correct user-id and password,
I am back to the empty login-screen (with no error message), after
a second or so, and the PHP error log says:
> [10-Mai-2006 13:10:10] PHP Notice:  Undefined index:  password_expiration
>    in /opt/test-webmail/horde/lib/Horde/Auth/ldap.php
>    on line 252
> [10-May-2006 13:10:11] PHP Notice:  Undefined index:  rowlocking
>    in /opt/test-webmail/horde/lib/Horde/SessionHandler/mysql.php
>    on line 139
> [10-May-2006 13:10:11] PHP Notice:  Undefined index:  rowlocking
>    in /opt/test-webmail/horde/lib/Horde/SessionHandler/mysql.php
>    on line 139
> [10-May-2006 13:10:11] PHP Notice:  Undefined index:  rowlocking
>    in /opt/test-webmail/horde/lib/Horde/SessionHandler/mysql.php
>    on line 139

There is no entry in the MySQL error log.

So, we have another undefined variable named
$this->_params['password_expiration']; and no horde session can be
established.

The identification line of that source file:
> $Horde: framework/SessionHandler/SessionHandler/mysql.php,
>         v 1.16.12.13 2006/03/25 00:19:42 jan Exp $

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

Where are these variables supposed to be set?
What can I do to get Horde working?
In case there is a problem with my configuration,
I'll append a copy of my horde/config/conf.php
file.

Best wishes,
   Otto Stolz

------------ Particulars from MySQL ---------------
> show table status\G;
...
>            Name: horde_histories
>          Engine: MyISAM
>         Version: 9
>      Row_format: Dynamic
>            Rows: 33
>  Avg_row_length: 127
>     Data_length: 4220
> Max_data_length: 4294967295
>    Index_length: 6144
>       Data_free: 0
>  Auto_increment: NULL
>     Create_time: 2006-05-09 19:11:38
>     Update_time: 2006-05-10 12:44:13
>      Check_time: 2006-05-09 19:11:38
>       Collation: latin1_swedish_ci
>        Checksum: NULL
>  Create_options: 
>         Comment: 
...
>            Name: horde_sessionhandler
>          Engine: InnoDB
>         Version: 9
>      Row_format: Dynamic
>            Rows: 15
>  Avg_row_length: 1092
>     Data_length: 16384
> Max_data_length: NULL
>    Index_length: 0
>       Data_free: 0
>  Auto_increment: NULL
>     Create_time: 2006-05-09 14:44:11
>     Update_time: NULL
>      Check_time: NULL
>       Collation: latin1_swedish_ci
>        Checksum: NULL
>  Create_options: 
>         Comment: InnoDB free: 4096 kB

> describe horde_users;
> +---------------------------+--------------+------+-----+---------+
> | Field                     | Type         | Null | Key | Default | 
> +---------------------------+--------------+------+-----+---------+
> | user_uid                  | varchar(255) |      | PRI |         |
> | user_pass                 | varchar(32)  |      |     |         |
> | user_soft_expiration_date | int(11)      | YES  |     | NULL    |
> | user_hard_expiration_date | int(11)      | YES  |     | NULL    |
> +---------------------------+--------------+------+-----+---------+

> describe horde_histories;
> +----------------+--------------+------+-----+---------+-------+
> | Field          | Type         | Null | Key | Default | Extra |
> +----------------+--------------+------+-----+---------+-------+
> | history_id     | bigint(20)   |      | PRI | 0       |       |
> | object_uid     | varchar(255) |      | MUL |         |       |
> | history_action | varchar(32)  |      | MUL |         |       |
> | history_ts     | bigint(20)   |      | MUL | 0       |       |
> | history_desc   | text         | YES  |     | NULL    |       |
> | history_who    | varchar(255) | YES  |     | NULL    |       |
> | history_extra  | text         | YES  |     | NULL    |       |
> +----------------+--------------+------+-----+---------+-------+

> describe horde_tokens;
> +-----------------+-------------+------+-----+---------+-------+
> | Field           | Type        | Null | Key | Default | Extra |
> +-----------------+-------------+------+-----+---------+-------+
> | token_address   | varchar(8)  |      | PRI |         |       |
> | token_id        | varchar(32) |      | PRI |         |       |
> | token_timestamp | bigint(20)  |      |     | 0       |       |
> +-----------------+-------------+------+-----+---------+-------+

> describe horde_vfs;
> +--------------+--------------+------+-----+---------+-------+
> | Field        | Type         | Null | Key | Default | Extra |
> +--------------+--------------+------+-----+---------+-------+
> | vfs_id       | bigint(20)   |      | PRI | 0       |       |
> | vfs_type     | smallint(6)  |      |     | 0       |       |
> | vfs_path     | varchar(255) |      | MUL |         |       |
> | vfs_name     | varchar(255) |      | MUL |         |       |
> | vfs_modified | bigint(20)   |      |     | 0       |       |
> | vfs_owner    | varchar(255) |      |     |         |       |
> | vfs_data     | longblob     | YES  |     | NULL    |       |
> +--------------+--------------+------+-----+---------+-------+

--------- horde/config/conf.php -------------
<?php
/* CONFIG START. DO NOT CHANGE ANYTHING IN OR AFTER THIS LINE. */
// $Horde: horde/config/conf.xml,v 1.74.2.14 2005/08/23 17:14:42 mrubinsk Exp $
$conf['debug_level'] = E_ALL;
$conf['max_exec_time'] = 0;
$conf['use_ssl'] = 1;
$conf['server']['name'] = $_SERVER['SERVER_NAME'];
$conf['server']['port'] = 443;
$conf['compress_pages'] = true;
$conf['umask'] = 077;
$conf['session']['name'] = 'Horde3test';
$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'] = 'localhost';
$conf['sql']['username'] = 'horde3test';
$conf['sql']['password'] = ...;
$conf['sql']['socket'] = '/var/run/mysql/sock';
$conf['sql']['protocol'] = 'unix';
$conf['sql']['database'] = 'horde3test';
$conf['sql']['charset'] = 'utf-8';
$conf['sql']['phptype'] = 'mysql';
$conf['auth']['admins'] = array('Otto.Stolz at uni-konstanz.de');
$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['signup']['allow'] = false;
$conf['signup']['approve'] = true;
$conf['signup']['preprocess'] = false;
$conf['signup']['queue'] = false;
$conf['log']['priority'] = PEAR_LOG_NOTICE;
$conf['log']['ident'] = 'Horde3test';
$conf['log']['params'] = array();
$conf['log']['name'] = '/var/adm/httpd/test-webmail-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']['params']['prefix'] = 'h3test';
$conf['cache']['driver'] = 'file';
$conf['token']['driver'] = 'none';
$conf['mailer']['params']['sendmail_path'] = '/opt/test-webmail/sendmail';
$conf['mailer']['params']['sendmail_args'] = '-oi';
$conf['mailer']['type'] = 'sendmail';
$conf['vfs']['params']['vfsroot'] = '/tmp';
$conf['vfs']['type'] = 'file';
$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']['password'] = ...;
$conf['sessionhandler']['params']['database'] = 'horde3test';
$conf['sessionhandler']['params']['table'] = 'horde_sessionhandler';
$conf['sessionhandler']['type'] = 'mysql';
$conf['mime']['magic_db'] = '/etc/magic';
$conf['problems']['email'] = 'webmail-admin at uni-konstanz.de';
$conf['menu']['always'] = false;
$conf['menu']['links']['help'] = 'all';
$conf['menu']['links']['options'] = 'authenticated';
$conf['menu']['links']['problem'] = 'authenticated';
$conf['menu']['links']['login'] = 'all';
$conf['menu']['links']['logout'] = 'authenticated';
$conf['logo']['image'] = 'http://webmailtest.rz.uni-konstanz.de/img/unilogo_inv.gif';
$conf['logo']['link'] = 'http://www.uni-konstanz.de/';
$conf['hooks']['username'] = false;
$conf['hooks']['preauthenticate'] = false;
$conf['hooks']['postauthenticate'] = false;
$conf['hooks']['authldap'] = false;
$conf['kolab']['enabled'] = false;
$conf['imsp']['enabled'] = false;
/* CONFIG END. DO NOT CHANGE ANYTHING IN OR BEFORE THIS LINE. */