Could not connect to database for SQL SessionHandler

When you try to login in Horde you see this error:

A fatal error has occurred
Could not connect to database for SQL SessionHandler.
Details have been logged for the administrator.

There are some different reasons that causes this error. This is a checklist to solve the problem.


First, check the /etc/my.cnf and remove skip-innodb if its in there.

Second, repair Horde database

mysqlcheck --auto-repair horde

Third, enter mysql and check what socket file is using mysql:

# mysql
mysql> show variables like 'socket';

You must see something like this:

socket /var/lib/mysql/mysql.sock

Edit the config file:

vi /usr/local/cpanel/base/horde/config/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’;


COMENTARIOS / UN COMENTARIO

In this situation advise use this tool because it is very good also it has free status as far as i know-mssql repair,tool
can help with this problem and retrieve the data, that was considered to be lost,mwill extract housekeeping data from the source database and preview the data, that can be recovered,this tool is a good solution to recover data from corrupted databases in MS SQL Server format,restore databases represent files, like any other documents, they can be easily corrupted by viruses, all sorts of malware, hard drive failures, file system errors, incorrect user actions, etc,supports both data extraction to your hard drive as scripts in SQL format and data export directly to a database in MS SQL Server format.

Alex 07 Dec 2008 a las 7:56 pm

COMENTA

Tags disponibles: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Return to Top