[imp] Re: Could not connect to database for SQL SessionHandler

[Josh Trutwin]

On Sun, 13 Mar 2005 19:44:02 -0700
RYAN vAN GINNEKEN <luck at computerking.ca> wrote:

> I use freebsd 4.10 and mysql version 4.1 and am having trouble with
> the  following error
> 
> Mar 13 19:19:53 HORDE [emergency] [horde] Could not connect to
> database  for SQL SessionHandler. [on line 252 of 
> "/usr/local/www/horde/lib/Horde/SessionHandler/mysql.php"]
> 
> Can someone help me here is the link to my test.php
> 
> http://canmail.org/horde/test.php
> 
> and my imp
> /imp/config/servers.php
> $servers['imap'] = array(
>     'name' => 'IMAP Server',
> //  'server' => 'imap.tokyo.computerking.ca',
>     'server' => 'localhost',
>     'hordeauth' => false,
>     'protocol' => 'imap/notls',
>     'port' => 143,
>     'folders' => '',
>     'namespace' => '',
>     'maildomain' => 'computerking.ca',
> //  'smtphost' => 'mail1.computerking.ca',
>     'smtphost' => 'localhost',
>     'smtpport' => 25,\

This part of your config is unrelated to the session error above -
this is actually telling horde/imp how to connect to your IMAP server.
 For the session / MySQL part, check config/horde.php for these lines:

$conf['sessionhandler']['type'] = 'mysql';

AND:

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

Josh