[horde] Could not connect to database for SQL SessionHandler

[Wang, Yu]

Try to comment out the $conf['sessionhandler'] lines to let horde use php sessionhandler.

--Yu Wang

Information Technology Services
University of North Florida
(904) 620-2820



-----Original Message-----
From: horde-bounces at lists.horde.org
[mailto:horde-bounces at lists.horde.org]On Behalf Of Peter Horst
Sent: Wednesday, March 17, 2004 11:21 PM
To: horde at lists.horde.org
Subject: [horde] Could not connect to database for SQL SessionHandler


I'm trying to set up Horde/IMP for the first time. When I try to access
login.php, I get the error "Could not connect to database for SQL
SessionHandler" [line 270 of [...]/lib/SessionHandler/mysql.php]

MySQL is running and I can connect to 'horde' as 'horde'. The tables
'horde_prefs' and 'horde_sessionhandler' exist. Can someone throw out a
couple of things to check? I think these settings in
$HORDE/config/horde.php might be relevant:

$conf['prefs']['driver'] = 'sql';
$conf['prefs']['params'] = array();
$conf['prefs']['params']['phptype'] = 'mysql';
$conf['prefs']['params']['hostspec'] = 'localhost';
$conf['prefs']['params']['protocol'] = 'unix';
$conf['prefs']['params']['username'] = 'horde';
$conf['prefs']['params']['password'] = 'password';
$conf['prefs']['params']['database'] = 'horde';
$conf['prefs']['params']['table'] = 'horde_prefs';

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

Thanks much,

Peter

-- 
If I ever get real rich, I hope I'm not real mean to poor people, like I
am now. 
 -- Jack Handey
-- 
Horde mailing list - Join the hunt: http://horde.org/bounties/#horde
Frequently Asked Questions: http://horde.org/faq/
To unsubscribe, mail: horde-unsubscribe at lists.horde.org