[imp] Custom Session Handler error

[Andrew Morgan]

On Thu, 27 Mar 2003, Frank Niedermann wrote:

> Hi,
>
> I get some errors while setting the Custom Session Handler to
> $conf['sessionhandler']['type'] = 'mysql';.
>
> These are the additional configuration settings:
> $conf['sessionhandler']['params'] = array();
> $conf['sessionhandler']['params']['phptype'] = 'mysql';
> $conf['sessionhandler']['params']['hostspec'] = 'localhost';
> $conf['sessionhandler']['params']['username'] = 'horde';
> $conf['sessionhandler']['params']['password'] = 'secret_password';
> $conf['sessionhandler']['params']['database'] = 'horde';
>
> While trying to log into IMP as user, horde.log shows this:
>
> Mar 27 21:19:32 HORDE [error] [imp] Error retrieving session data
>   (id = 9efc14a560fe614735874ff245c54ebe) [on line 110 of
>   "/home/www/htdocs/secure/horde/lib/SessionHandler/mysql.php"]
> Mar 27 21:19:42 HORDE [notice] [imp] Login success for fbn at iws1.fnet
>   [192.168.1.99] to {imap.iws1.fnet:143} [on line 83 of
>   "/home/www/htdocs/secure/horde/imp/redirect.php"]
> Mar 27 21:19:42 HORDE [error] [imp] Error retrieving session data
>   (id = 9efc14a560fe614735874ff245c54ebe) [on line 110 of
>   "/home/www/htdocs/secure/horde/lib/SessionHandler/mysql.php"]
>
> The user is not able to login ("wrong user or password ...").
> What's the problem with this, do I have to create additional
> sql-tables on the database? The connect seems to work because
> if I change the user/password I get another error-message.
>
> With Custon Session Handler = none the user is able to login.

Here is my config:

$conf['sessionhandler']['type'] = 'mysql';
$conf['sessionhandler']['params'] = array();
$conf['sessionhandler']['params']['phptype'] = 'mysql';
$conf['sessionhandler']['params']['hostspec'] = 'mydbserver';
$conf['sessionhandler']['params']['username'] = 'hordemgr';
$conf['sessionhandler']['params']['password'] = '******';
$conf['sessionhandler']['params']['database'] = 'horde';
$conf['sessionhandler']['params']['table'] = 'horde_sessionhandler';

Looks to me like you haven't defined the table it should use to store
sessions.  If that's the case, then you probably also haven't ran
horde/scripts/db/sessionhandler.sql to create the necessary table in your
database.  Have a look at the script before you run it though to make sure
the grant is to the correct database user on your system.

	Andy