webmail login issue

[mojamoi]

After logiing into domain/webmail

I get the follwoing error and no access to emails



Warning: fsockopen() [function.fsockopen]: unable to connect to localhost:143 (Connection timed out) in /usr/local/cpanel/base/3rdparty/squirrelmail/plugins/login_auth/functions.php on line 129

 

[cPanelMichael]

Hello

Check to see if local connections are possible to port 143 by running the following command on your server:

telnet localhost 143

Let us know the output.

Thank you.

 

[mojamoi]

/etc/init.d]# telnet localhost 143
Trying ::1...
telnet: connect to address ::1: Connection refused
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
* OK [CAPABILITY IMAP4rev1 LITERAL+ SASL-IR LOGIN-REFERRALS ID ENABLE STARTTLS AUTH=PLAIN AUTH=LOGIN] Dovecot ready.

 

[cPanelMichael]

Could you verify if the other webmail applications are having the same issue, or if it's isolated to Squirrelmail? Also, try restarting your mail server:

/scripts/restartsrv_dovecot

Thank you.

 

[mojamoi]

i get the login to roudcube

but on entering login details i get error
Connection to storage server failed.


but mysql shows a running status
p]# service mysql status
SUCCESS! MySQL running (665931)

 

[cPanelMichael]

Check the Roundcube error log in the following directory:

/var/cpanel/roundcube/log/

Do you notice any specific entries during the failed login attempt?

Thank you.

 

[mojamoi]

[/var/cpanel/roundcube/log]# tail -f errors
[24-Jan-2014 20:48:00 +0200]: IMAP Error: Login failed for [email protected] from 100.190.180.40. Could not connect to localhost:143: Die Wartezeit für die Verbindung ist abgelaufen in /usr/local/cpanel/base/3rdparty/roundcube/program/include/rcube_imap.php on line 191 (POST /cpsess3119826763/3rdparty/roundcube/index.php?_task=login&_action=login)

 

[cPanelMichael]

Could you open a support ticket using the link in my signature so we can take a closer look? You can post the ticket number here so we can update this thread with the outcome.

Thank you.

 

[mojamoi]

hello

is the support free or paid

- - - Updated - - -

posted request id 4481887

 

[mojamoi]

[email protected] [~]# mysql -e 'drop database roundcube'
[email protected] [~]# /usr/local/cpanel/bin/update-roundcube --force
Roundcube update from 0.8.5.cp3 to 0.8.5.cp3 in progress.
Roundcube will be locked out during this process.
Updating RoundCube (using cPanel version)
info [update-roundcube] Applied patch '0001-Apply-default-values-for-cPanel-webmail-

environment.patch'
patching file config/db.inc.php.dist
patching file config/main.inc.php.dist
patching file index.php
patching file program/include/rcube_imap.php
patching file program/include/rcube_imap_generic.php
info [update-roundcube] Applied patch '0002-append-INBOX.-to-avoid-UID-COPY-Unknown-

namespace-er.patch'
patching file config/main.inc.php.dist
info [update-roundcube] Applied patch '0003-User-can-select-a-different-skin-when-its-

choice-is-.patch'
patching file program/include/rcube_template.php
info [update-roundcube] Successfully applied 3 patches
INFO - Applied cPanel patches (if any) to Roundcube source.
Cleaning old Roundcube data archives
ERROR 1194 (HY000) at line 1: Table 'user' is marked as crashed and should be repaired
Successful creation of roundcube cp_schema_version table
Successfully saved version 0.8.5 to cp_schema_version table
Schema update to 0.8.5 was successful
[email protected] [~]#

- - - Updated - - -

Now please what can i do for this error?ERROR 1194 (HY000) at line 1: Table 'user' is marked as crashed and should be repaired

 

[Sreejit]

You can enter mysql prompt and try to repair the table

#mysql roundcube
mysql> repair table user;

 

[mojamoi]

through whm i get
Repair a MySQL Database

Repairing roundcube

roundcube.cache
note : The storage engine for the table doesn't support repair
roundcube.cache_index
note : The storage engine for the table doesn't support repair
roundcube.cache_messages
note : The storage engine for the table doesn't support repair
roundcube.cache_thread
note : The storage engine for the table doesn't support repair
roundcube.contactgroupmembers
note : The storage engine for the table doesn't support repair
roundcube.contactgroups
note : The storage engine for the table doesn't support repair
roundcube.contacts
note : The storage engine for the table doesn't support repair
roundcube.cp_schema_version OK
roundcube.dictionary
note : The storage engine for the table doesn't support repair
roundcube.identities
note : The storage engine for the table doesn't support repair
roundcube.searches
note : The storage engine for the table doesn't support repair
roundcube.session
note : The storage engine for the table doesn't support repair
roundcube.users
note : The storage engine for the table doesn't support repair
Done.

 

[mojamoi]

mysql> repair table users;
+-----------------+--------+----------+---------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+-----------------+--------+----------+---------------------------------------------------------+
| roundcube.users | repair | note | The storage engine for the table doesn't support repair |
+-----------------+--------+----------+---------------------------------------------------------+
1 row in set (0.00 sec)

mysql>

 

[cPanelMichael]

You could try stopping MySQL and using myisamchk to check/repair the /var/lib/mysql/roundcube/user.MYI table. However, per the ticket, it looks like you have completely reinstalled Roundcube.

Thank you.