Mayur's BLOG: Horde Webmail Fatal Error

Horde Webmail Fatal Error

Posted by Mayur's BLOG

If you are receiving the following error code while Horde webmail login.

Error::

Code:

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

Solution::

NOTE: You can fix it only if you have a root user privileges which means this will be helpful for VPS , Semi-dedicated Servers and Dedicated servers.

1. Check the Horde webmail configuration file

Code:

#vi /usr/local/cpanel/base/horde/config/conf.php

2. You can find the following entry in the conf.php

Code:

$conf['sql']['hostspec'] = 'localhost';
$conf['sql']['username'] = 'horde';
$conf['sql']['password'] = '';
$conf['sql']['protocol'] = 'tcp';
$conf['sql']['database'] = 'horde';

3. Try to connect the database horde using the following method
#mysql -uhorde -p

You should obtain the Error.

Code:

"ERROR 1045 (28000): Access denied for user
'horde'@'localhost' (using password: YES)"

4. Grant the privilege to the database using the mysql command prompt

Code:

#mysql> grant all privileges on horde.* to horde@localhost identified by '';

You can now login into the Horde Webmail now..!!!

Second solution is that, You can also try checking configuration file /etc/my.cnf and remove skip-innodb if its in there. Restart mysql service to ensure that the error has been fixed and Horde Webmail login works..

Another solution is to repair the table named "SessionHandler" in Horde Database from mysql command Prompt as follows.

Code:

#mysql
#mysql> use horde;
#mysql> repair table horde_sessionhandler;

These Fixes must fix your Horde webmail login problem..

Enjoy

Mayur's BLOG

Horde Webmail Fatal Error

0 comments:

Blog Archive

My Blog List