Fixing a Corrupted RoundCube / SQLite Database -- "Oops... something went wrong!" Print

"Oops... something went wrong!" RoudCube or Webmail does not log in.

Here is a step-by-step guide on how to Fix a Corrupted RoundCube SQLite Database

1. Navigating to the Directory:

   a.   Start by locating the directory:

   /home/<cpanel_user>/etc/<domain>/

2. Restoring from Backups:

   First, we will try to restore the file from a cPanel-generated backup

   a.To do this Rename or Move the Database File:

   • Rename the below file

     <email_user>.rcube.db

     to

     <email_user>.rcube.db.bak

   • Alternatively, you can move it out of the folder for safekeeping.

   b. Selecting a Backup Version:

   • Identify the most recent backup copy by examining the timestamp on files named

   <email_user>.rcube.db.<number_stamp>

   • Choose the latest one.

   c. Applying the Backup:

   • Rename the chosen backup file to

     <email_user>.rcube.db

   d. Testing:

   • Attempt to access RoundCube again to ensure the issue is resolved.

3. OR Better yet, Starting RoundCube from the beginning:

   If the issue has not been fixed, alternatively we can start Roundcube to start from the beginning by following the below steps

   a.To do this Rename or Move the Database File:

   • Rename the below file

     <email_user>.rcube.db

     to

     <email_user>.rcube.db.bak

   • Alternatively, you can move it out of the folder for safekeeping.

   b. Server Owners //Restarting PHP-FPM (For Servers Using cPanel with PHP-FPM):

   • If your server employs PHP-FPM for the cPanel service, execute the following commands to restart it:
     bash

     /scripts/restartsrv_cpanel_php_fpm --stop
     /scripts/restartsrv_cpanel_php_fpm --start
     

   c. Testing:

   • Try accessing RoundCube again to see if the issue has been resolved.
4. Logging in:
   • Access your account either through cPanel or

     https://www.domain.com:2096

     select Webmail or RoundCube. Your account should now function properly.