Symptoms
Can't access your email account in Roundcube and a yellow-colored pop-up states that the Login failed:
Description
The error occurs because the database is corrupted:
[16-Jul-2021 21:18:09 -0500]: <33865325> DB Error: [1] no such table: session (SQL Query: INSERT INTO "session" ("sess_id", "vars", "ip", "changed") VALUES ('33865325beda2c40e5aa2f961254e4b7', 'bGFuZ3VhZ2V8czo1OiJlbl9VUyI7dGVtcHxiOjE7cmVxdWVzdF90b2tlbnxzOjMyOiJsb09LWDdhWDZlbE05RDJkV1FadkJ1dHpseW1jMnNJWiI7', '184.94.197.2', datetime('now'))) in /usr/local/cpanel/base/3rdparty/roundcube/program/lib/Roundcube/rcube_db.php on line 543 (GET /cpsess4937760539/3rdparty/roundcube/index.php?login=1&post_login=41373092539665)
In some cases, the active database is missing all tables:
drwxr-xr-x 2 cPanelUser cPanelUser 4096 Jul 16 20:22 john
-rw------- 1 cPanelUser cPanelUser 81920 Feb 5 15:31 john.rcube.db
-rw------- 1 cPanelUser cPanelUser 0 Jan 15 2021 john.rcube.db.1610698654
lrwxrwxrwx 1 cPanelUser cPanelUser 31 Jan 15 2021 john.rcube.db.latest -> john.rcube.db.1610698654
Workaround
This issue can be solved by performing the procedure mentioned in the following article: How-To Fix A Corrupted RoundCube SQLite Database.