cd /usr/local/cpanel/base
rm -rf roundcube*
mysql mysql>drop database roundcube;

cd /usr/local/cpanel/base
wget http://easynews.dl.sourceforge.net/sourceforge/roundcubemail/roundcubemail-0.1beta2.1.tar.gz
tar -zxvf roundcubemail-0.1beta2.1.tar.gz
mv -f roundcubemail-0.1beta2 roundcube
cd roundcube
chmod -R 777 temp
chmod -R 777 logs

mysql>CREATE DATABASE roundcube;
mysql>use roundcube;
mysql>source SQL/mysql.initial.sql;
mysql>>quit

cd config
mv db.inc.php.dist db.inc.php
mv main.inc.php.dist main.inc.php

vi db.inc.php
$rcmail_config[‘db_dsnw’] = ‘mysql://roundcube:pass@localhost/roundcubemail’;
vi main.inc.php
$rcmail_config[‘localhost’] = “localhost”;

cd /usr/local/cpanel/base/roundcube/skins/default/images/
cp roundcube_logo.png /usr/local/cpanel/base/frontend/x/images/roundcube_logo.png
cp roundcube_logo.png /usr/local/cpanel/base/webmail/x/images/roundcube_logo.png
wget http://www.yourserverguide.com/Files/HGpatch-roundcube-1.0BETA2.1
patch -p0 < HGpatch-roundcube-1.0BETA2.1

grep db_dsnw /usr/local/cpanel/base/3rdparty/roundcube/config/db.inc.php

mysql> update user set Password = PASSWORD(‘good_password’) where User = ’roundcube’;

Fix.

mysql_upgrade -h localhost

cd /var/lib/mysql
mv roundcube /tmp

mysql> drop database roundcube;
ERROR 1008 (HY000): Can’t drop database ’roundcube’; database doesn’t exist
mysql> create database roundcube;

mysqldump -d dbname table > table.sql

/var/cpanel/roundcube/errors /var/cpanel/roundcube/sendmail

If you have this error after mysql restore jobs.
Fix.

mysql_install_db –-user=mysql –ldata=/var/lib/mysql
service mysql start

cat /usr/local/ispconfig/server/lib/mysql_clientdb.conf

UPDATE sys_user SET passwort = md5('YourNewPassword') WHERE username = 'admin';
FLUSH PRIVILEGES;
quit;

You can find it there:

cat /usr/local/ispconfig/server/lib/mysql_clientdb.conf

Fix.

In WHM’s Tweak Settings, change the setting “Cookie IP validation” from Strict to Loose.