How to solve Horde login issue?

[its_fine]

Hello,

When we try to login Horde is not able to login.

We did try below step.
1) repaired horde database
2) /scripts/fullhordereset
but still not resolved

Please any have solution.

Thanks in advance

Its_fine

[thewebhosting]

Is there any error message are you receiving while login to Horde Mail?

[linux7802]

The login problem is one of the most common problem is Horde.Refer following steps to resolve your issue

/scripts/fullhordereset

But as you mentioned that you have been already run above script due to that you need to refer second solution for your issue

Repair a Database (Database name : horde)

root#mysql
mysql>use horde;
mysql>repair table horde_sessionhandler;
mysql>\q

Then on shell prompt run commands

touch /var/cpanel/usecpphp
/scripts/fullhordereset

[its_fine]

Hello,

Thank you for your reply.
I did try wiht provided solution.

But still issue not resloved

When I got below error.

----------------------------------
mysql> repair table horde_sessionhandler;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 2410
Current database: horde

+----------------------------+--------+----------+---------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+----------------------------+--------+----------+---------------------------------------------------------+
| horde.horde_sessionhandler | repair | note | The storage engine for the table doesn't support repair |
+----------------------------+--------+----------+---------------------------------------------------------+
1 row in set (0.44 sec)

please let us know what can I do now?

Thanks

Its_fine

[thewebhosting]

It seems that INNODb table 'horde.horde_sessionhandler' is corrupted. You would need to repair this table.

[anton_latvia]

"The storage engine for the table doesn't support repair" is a normal error message - INNODB does not support "repair" and does repairing more or less automatically during mysql restarts.

To reset password for roundcube look in :
/usr/local/cpanel/base/3rdparty/roundcube/config/db.inc.php
(line $rcmail_config['db_dsnw']) and then set correct password for user "roundcube" in MySQL (e.g. use phpMyAdmin), reload privileges.

For Horde look in /usr/local/cpanel/base/horde/config/conf.php and do similar steps for mysql user "horde".

Anton.

[sankvas]

Hi,

what is the output of --> ls -al /var/cpanel/userhomes/cpanelhorde

Please do check the folder /var/cpanel/userhomes/cpanelhorde and the ownership of that files.

"grep ^cpanel /etc/passwd" should give the following
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
cpanel:x:32001:32001::/usr/local/cpanel:/bin/false
cpanelhorde:x:32003:32005::/var/cpanel/userhomes/cpanelhorde:/usr/local/cpanel/bin/noshell
cpanelphpmyadmin:x:32004:32006::/var/cpanel/userhomes/cpanelphpmyadmin:/usr/local/cpanel/bin/noshell
cpanelphppgadmin:x:32005:32007::/var/cpanel/userhomes/cpanelphppgadmin:/usr/local/cpanel/bin/noshell
cpanelroundcube:x:32006:32008::/var/cpanel/userhomes/cpanelroundcube:/usr/local/cpanel/bin/noshell
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~



Change the ownership of files and folders under /var/cpanel/userhomes/cpanelhorde to cpanelhorde. That should fix the issue for you

[cPanelDavidG]

I have moved this thread from the cPanel Newbies section to the Mail section.

[cPanelDon]

Please do check the folder /var/cpanel/userhomes/cpanelhorde and the ownership of that files.

Expanding upon what sankvas has suggested, please check to ensure the following directory exists:
/var/cpanel/userhomes/cpanelhorde/sessions

The following commands will accomplish the task:

Checking if the directory exists (and display access permissions and ownership):

# stat /var/cpanel/userhomes/cpanelhorde/sessions

Creating the directory structure, if missing:

# mkdir -pv /var/cpanel/userhomes/cpanelhorde/sessions

Applying correct ownership:

# chown -v cpanelhorde:cpanelhorde /var/cpanel/userhomes/cpanelhorde/sessions

[cuongvttt]

For Horde
/usr/local/cpanel/bin/update-horde --force

For SquirrelMail
/usr/local/cpanel/bin/update-squirrelmail --force

For Roundcube
/usr/local/cpanel/bin/update-roundcube --force


Enjoy it