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

[RYAN vAN GINNEKEN]

Ok i have checked my /usr/local/www/horde/config/conf.php (could not 
find the horde.php file you speak of) file for the lines you sent to me 
and they were all there including one exstra that i commented out.about 
protocol.  Also i changed the password for the database i am pretty sure 
i changed it to the one below as i followed the instructions on how to 
install mysql script and they recommended that i change it to something 
other than horde.  Now i get a different errors (shown below) I think 
this is progress right??

$conf['sessionhandler']['type'] = 'mysql';
$conf['sessionhandler']['params'] = array();
$conf['sessionhandler']['params']['phptype'] = 'mysql';
$conf['sessionhandler']['params']['hostspec'] = 'localhost';
$conf['sessionhandler']['params']['username'] = 'horde';
$conf['sessionhandler']['params']['password'] = '22vu22';
$conf['sessionhandler']['params']['database'] = 'horde';
$conf['sessionhandler']['params']['table'] = 'horde_sessionhandler';
$conf['sessionhandler']['params']['persistent'] = false;
//$conf['sessionhandler']['params']['protocol'] = 'unix';

Mar 13 21:15:49 HORDE [debug] [horde] SQL Query by 
SessionHandler_mysql::read(): query = "SELECT session_data FROM 
horde_sessionhandler WHERE session_id = 
'd12ce4e060e6583e04573ae1ad086b51' AND session_lastmodified > 
1110772309" [on line 107 of 
"/usr/local/www/horde/lib/Horde/SessionHandler/mysql.php"]
Mar 13 21:15:50 HORDE [error] [horde] Error retrieving session data (id 
= d12ce4e060e6583e04573ae1ad086b51) [on line 112 of 
"/usr/local/www/horde/lib/Horde/SessionHandler/mysql.php"]
Mar 13 21:15:50 HORDE [emergency] [horde] DB Error: connect failed:  
[nativecode=Table 'horde.horde_sessionhandler' doesn't exist] ** Array 
[on line 1273 of "/usr/local/www/horde/lib/Horde/DataTree/sql.php"]
Mar 13 21:15:50 HORDE [error] [horde] Error writing session data [on 
line 137 of "/usr/local/www/horde/lib/Horde/SessionHandler/mysql.php"]


Josh Trutwin wrote:

>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
>  
>