Handling Roundcube Database Error on DirectAdmin

Step 1: SSH into VPS or Server as root

Step 2: Check the Roundcube log

Check the log by following the link below:

tail /var/www/html/roundcube/logs/errror.log

In case the error log appears as below, you need to reinstall Roundcube
DB Error: SQLSTATE[HY000] [1045] Access denied for user ‘da_roundcube’@’localhost’ (using password: YES) in /var/www/html/roundcubemail-1.4.8/program/lib/Roundcube/rcube_db.php on line 175 (GET /roundcube/)
Step 3: Reinstall Roundcube
Please run the commands below one by one
cat /usr/local/directadmin/conf/mysql.conf
mysql -u da_admin -p
DROP DATABASE da_roundcube;
quit
cd /usr/local/directadmin/custombuild
./build roundcube

Note:

1. Open and display the content of the mysql.conf file (this time the screen will show the user/pass of the Mysql admin user on Directadmin)
2. Login to Mysql admin (according to information in command 1)
3. Delete Database da_roundcube and exit
4. Move to custombuild folder
5. Run the command rebuild roundcube

After the rebuid process is complete, check Roundcube’s webmail again via the following link: http://IPserver/roundcube

Good luck !

Linh BKNS