How to fix RoundCube’s error: DATABASE ERROR: CONNECTION FAILED!

Mysql server and InnoDB engine must to be running!

Check mysql connection:

cat /usr/local/cpanel/base/3rdparty/roundcube/config/ |grep mysql:
$config['db_dsnw'] = 'mysql://roundcube:[email protected](/var/lib/mysql/mysql.sock)/roundcube';
mysql -u roundcube -p
show tables;

All tables should be in place:

| Tables_in_roundcube |
| cache               |
| cache_index         |
| cache_messages      |
| cache_shared        |
| cache_thread        |
| contactgroupmembers |
| contactgroups       |
| contacts            |
| cp_schema_version   |
| dictionary          |
| identities          |
| searches            |
| session             |
| system              |
| users               |
15 rows in set (0.00 sec)

Cpanel keeps roundcube backups here:


Go ahead and drop broken database

mysqladmin drop roundcube

Rebuild roundcube using the following two commands:

rpm -e --nodeps cpanel-roundcubemail

/usr/local/cpanel/scripts/check_cpanel_rpms --fix

Database roundcube should be recreated automatically.
Read the rest

How to update server’s time

I did it on OpenVZ server and it works like a charm

rm -fv /etc/localtime
ln -s /usr/share/zoneinfo/GMT /etc/localtime
ln -s /usr/share/zoneinfo/CST6CDT /etc/localtime

Note the sym link may not work, so just copy file physically

Set date and sync it on hardware

date 081209312016
hwclock --systohc

The syntax is `date MMDDhhmmYYYY`.… Read the rest