[horde] Undefined variables in MySQL Session handler (Horde 3.1.1)
Daniel Herrero Martínez
dherrero at unav.es
Wed May 10 09:51:31 PDT 2006
Otto Stolz escribió:
> 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'].
>
you have to include this into your conf.php -->
$conf['sessionhandler']['params']['rowlocking'] = true;
This is because the table horde_sessionhandler has changed its type from
MyISAM to InnoDB, and now
supports row locking (MyISAM only supports table locking).
> 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. */
>
>
>
--
Daniel Herrero Martínez
-------------------------
Universidad de Navarra
Servicios Informáticos
- Área de sistemas -
Tel: 948 425600 Ext.2809
http://www.unav.es/SI
More information about the horde
mailing list