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

[Myke Place]

If you're really intending to use MySQL-based sessions (which you
probably don't want), you need to create the table horde_sessionhandler. 
>From what I understand, SQL sessions are quite slow. It's more likely
that what you really want are PHP file-based sessions which are both
faster and easier to setup.

Also, you may have just posted your SQL password to a few thousand
people, so you might want to change that. ;)

-mp

* RYAN vAN GINNEKEN (luck at computerking.ca) [050313 21:40] spake thusly:
> 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
> >  
> >
> 
> -- 
> IMP mailing list - Join the hunt: http://horde.org/bounties/#imp
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: imp-unsubscribe at lists.horde.org
>