I've seen quite a few posts in here about people encountering an error when trying to login to Horde via webmail and getting a SessionHandler error. If you are getting this and the other suggested fixes here are not working do the following:
First check to see what socket file mysql is using. If you have a my.cnf file under /etc then you can check there. You can also connect to mysql and issue the following command:
mysql> show variables like 'socket';
If it is using anything other than /tmp/mysql.sock then you can override the socket that Horde tries to use by doing the following:
cd /usr/local/cpanel/base/horde/config
vi conf.php
Change the following two lines from:
$conf['sql']['hostspec'] = 'localhost';
$conf['sessionhandler']['params']['hostspec'] = 'localhost';
to:
$conf['sql']['hostspec'] = 'localhost:/var/lib/mysql/mysql.sock';
$conf['sessionhandler']['params']['hostspec'] = 'localhost:/var/lib/mysql/mysql.sock';
Obviously substitute the "/var/lib/mysql/mysql.sock" part to the correct path to your socket file.
This solved our issues. If anyone else knows of another fix for this please post here and let us know.
First check to see what socket file mysql is using. If you have a my.cnf file under /etc then you can check there. You can also connect to mysql and issue the following command:
mysql> show variables like 'socket';
If it is using anything other than /tmp/mysql.sock then you can override the socket that Horde tries to use by doing the following:
cd /usr/local/cpanel/base/horde/config
vi conf.php
Change the following two lines from:
$conf['sql']['hostspec'] = 'localhost';
$conf['sessionhandler']['params']['hostspec'] = 'localhost';
to:
$conf['sql']['hostspec'] = 'localhost:/var/lib/mysql/mysql.sock';
$conf['sessionhandler']['params']['hostspec'] = 'localhost:/var/lib/mysql/mysql.sock';
Obviously substitute the "/var/lib/mysql/mysql.sock" part to the correct path to your socket file.
This solved our issues. If anyone else knows of another fix for this please post here and let us know.
