mojamoi

Well-Known Member
Jul 23, 2007
186
0
66
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

Administrator
Staff member
Apr 11, 2011
47,913
2,201
363
Hello :)

Check to see if local connections are possible to port 143 by running the following command on your server:
Code:
telnet localhost 143
Let us know the output.

Thank you.
 

mojamoi

Well-Known Member
Jul 23, 2007
186
0
66
/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

Administrator
Staff member
Apr 11, 2011
47,913
2,201
363
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:

Code:
/scripts/restartsrv_dovecot
Thank you.
 

mojamoi

Well-Known Member
Jul 23, 2007
186
0
66
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

Administrator
Staff member
Apr 11, 2011
47,913
2,201
363
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

Well-Known Member
Jul 23, 2007
186
0
66
[/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

Administrator
Staff member
Apr 11, 2011
47,913
2,201
363
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

Well-Known Member
Jul 23, 2007
186
0
66
hello

is the support free or paid

- - - Updated - - -

posted request id 4481887
 

mojamoi

Well-Known Member
Jul 23, 2007
186
0
66
[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
 

mojamoi

Well-Known Member
Jul 23, 2007
186
0
66
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

Well-Known Member
Jul 23, 2007
186
0
66
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

Administrator
Staff member
Apr 11, 2011
47,913
2,201
363
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.