19
You may have experienced this issue that the Horde doesn’t login to the mailbox and on clicking the Login button, the page just refreshes and continue to load the same login page. The most possible reason is that the Horde session table is corrupt. I will explain step by step that how we can check and fix this session table issue.
First of all, we will check the horde database to see if any table is corrupt or not using mysqlcheck utility. You can use WHM to check the Horde database:
root@ScHoLaR [~] > mysqlcheck horde
horde.horde_datatree OK
horde.horde_datatree_attributes OK
horde.horde_datatree_seq OK
horde.horde_histories OK
horde.horde_histories_seq OK
horde.horde_prefs OK
horde.horde_sessionhandler
error : Can’t find file: ‘horde_sessionhandler.MYI’ (errno: 2)
horde.horde_tokens OK
horde.horde_users OK
horde.horde_vfs OK
horde.jonah_channels OK
horde.jonah_stories OK
horde.kronolith_events OK
horde.kronolith_storage OK
horde.mnemo_memos OK
horde.nag_tasks OK
horde.turba_objects OK
If you have noticed that the table “horde.horde_sessionhandler” is corrupt. The horde_sessionhandler table needs recreated. This will void all currently ctive sessions. The following SQL will recreate the table after login to MySQL prompt:
USE horde;
DROP TABLE horde_sessionhandler;
CREATE TABLE horde_sessionhandler (
session_id VARCHAR(32) NOT NULL,
session_lastmodified INT NOT NULL,
session_data LONGBLOB,
PRIMARY KEY (session_id)
) ENGINE = InnoDB;
This can be executed via mysqladmin, or the mysql client. If mysqladmin, you need to pipe it to the command.
Alternatively, if you have backups of the system databases, you can opt to restore the horde_sessionhandler.MYI file from backup.
Reference: cPanel Bugzilla entry
