Unable to log in to Roundcube due to database corruption

Symptoms

Roundcube loads a login screen, and there is a "Login Failed" error.

The following is logged to the Roundcube error log:

CONFIG_TEXT: [16-Jul-2025 21:18:09 -0500]: <33865325> DB Error: [1] no such table: session (SQL Query: INSERT INTO "session" ("sess_id", "vars", "ip", "changed") VALUES ('33865325beda2c4-4b7', 'bGFuZ3VhZpseW1jMnNJWiI7', '203.0.113.2', datetime('now'))) in /usr/local/cpanel/base/3rdparty/roundcube/program/lib/Roundcube/rcube_db.php on line 543 (GET /cpsess/3rdparty/roundcube/index.php?login=1&post_login=4137309665)

Cause 

The Roundcube SQLite database is corrupted.

Resolution

Roundcube data is stored in the following folder, where $user is the cPanel user, and $domain is the domain that contains the email address you are working with: 

CONFIG_TEXT: /home/$user/etc/$domain/

To restore to a previous version, either from the automatic copies made or from a backup:

1. Access the server via SSH as the root user and navigate to the folder described above.

2. Rename the  database file to get it out of the way without deleting it, where $email_user is the address that has a corrupt database:

   # mv $email_user.rcube.db{,.$( date +%Y%m%d )} -v

   Note: If you want to use or create a new database from this point, you can log in to Webmail, and a new database will be created. If you opt for a new database, restoration is not necessary.

3. If a backup exists, it will be listed alongside this backup with timestamps like this:

   CONFIG_TEXT: -rw------- 1 user user 512000 Jan 21 19:52 emailuser.rcube.db
   -rw------- 1 user user 466944 Jul 31 2024 emailuser.rcube.db.1722461863
   -rw------- 1 user user 491520 Oct 31 22:36 emailuser.rcube.db.1730428585

4. Rename one of the backup files to $email_user.rcube.db to replace the old database:

   # mv $email_user.rcube.db.$timestamp  $email_user.rcube.db -v

5. Log in to Roundcube normally.