Service currently not available!

sreeninair

Well-Known Member
Dec 23, 2013
100
0
16
cPanel Access Level
Root Administrator
Hello Guys,

I amusing remote mysql server form my server. While taking roundcube in am gettingthe following error In browser.

========================
SERVICE CURRENTLY NOT AVAILABLE!

Error No. [800]
========================

I have executed '/usr/local/cpanel/bin/update-roundcube --force' , getting the following error

==============================


INFO - Applied cPanel patches (if any) to Roundcube source.
Archiving current Roundcube data to /var/cpanel/roundcube/roundcube.backup.sql.1393149302
Roundcube DB successfully archived
-rw------- 1 root root 10588 Feb 23 04:55 /var/cpanel/roundcube/roundcube.backup.sql.1393149302
Cleaning old Roundcube data archives
Removing old backup: roundcube.backup.sql.1393146076
ERROR 1133 (42000) at line 1: Can't find any matching row in the user table
DBI connect('database=roundcube;host=192.111.135.210','roundcube',...) failed: Access denied for user 'roundcube'@'206.220.172.170' (using password: YES) at /usr/local/cpanel/Cpanel/Email/RoundCube/DBI.pm line 543
Can't call method "prepare" on an undefined value at /usr/local/cpanel/Cpanel/Email/RoundCube/DBI.pm line 128.
=======================



I have given privilege for roundcube user in remote mysql server and main server ip still same error.

===================
in remote server

GRANT ALL PRIVILEGES ON *.* TO 'roundcube'@'IP' IDENTIFIED BY 'xyz' WITH GRANT OPTION;

the password was taken from
/usr/local/cpanel/base/3rdparty/roundcube/config/db.inc.php

=====================

please help!!!


Thanks
Sreeni
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,880
2,268
463
Hello :)

Check to make sure the password for the roundcube user on the remote MySQL server matches what's stored in /var/cpanel/roundcubepass:

Code:
cat /var/cpanel/roundcubepass && echo
Thank you.
 

sreeninair

Well-Known Member
Dec 23, 2013
100
0
16
cPanel Access Level
Root Administrator
Hello Michael ,

Thank you very much.

The password was wrong. I have given the password specified in '/var/cpanel/roundcubepass' in remote mysql server, Dropped roundcube table and executed roundcube update script.

#cat /var/cpanel/roundcubepass && echo
[Removed Actual Password]

#mysql -e 'drop database roundcube'

#/usr/local/cpanel/bin/update-roundcube --force


Thanks
Sreeni
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,880
2,268
463
To confirm, did that resolve the issue?

Thank you.