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’;
- BROWSE / IN Linux
- « Obtener información de un certificado SSL
- » Argument list too long
COMENTARIOS / UN COMENTARIO
Alex 07 Dec 2008 a las 7:56 pmIn 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.
COMENTA
