RoundCube is giving a DATABASE ERROR: CONNECTION FAILED! Unable to connect to the database! after an automatic upgrade from 84.x to 86.x last night.
My current server:
/etc/redhat-release:CentOS release 6.10 (Final)
/usr/local/cpanel/version:11.86.0.8
/var/cpanel/envtype:standard
CPANEL=release
mariadb 10.3.22
exim 4.93-2
imap 2.3.8
Restarted exim but did not change anything.
/var/cpanel/roundcube/log/errors:
[04-Mar-2020 09:31:04 America/Miami] PHP Warning: file_get_contents(/usr/local/cpanel/base/3rdparty/roundcube/plugins/carddav/dbinit/mysql.sql): failed to open stream: No such file or directory in /usr/local/cpanel/base/3rdparty/roundcube/plugins/carddav/carddav.php on line 54
[04-Mar-2020 09:31:04 -0400]: <3967603f> DB Error: [1146] Table 'roundcube.carddav_addressbooks' doesn't exist (SQL Query: SELECT * FROM carddav_addressbooks WHERE user_id='180' AND presetname is not null) in /usr/local/cpanel/base/3rdparty/roundcube/program/lib/Roundcube/rcube_db.php on line 543 (GET /cpsess0429168017/3rdparty/roundcube/index.php?login=1&post_login=....)
Current installed packages: Apache 2.4, PHP 5.6, PHP 7.1, PHP 7.2, and PHP 7.3
On strange update was part of this update (update to a lower version?):
[2020-03-04 02:32:14 -0400] info [update-roundcube-db] Roundcube update from 1.3.8-16.cp1184 to 1.3.8-13.cp1186 in progress.
[2020-03-04 02:32:14 -0400] info [update-roundcube-db] Roundcube updated to 1.3.8-13.cp1186
Found some more in /var/cpanel/roundcube/log/carddav:
[04-Mar-2020 07:41:52 -0400]: <883552e1> Can't find migration: /dbinit/mysql.sql
I do not see the table 'carddav_addressbooks' in the current DB, I only see 'carddav_migrations'.
I can find a mysql.sql file in /usr/local/cpanel/base/3rdparty/roundcube/plugins/carddav/dbmigrations/0000-dbinit/ and in that file the missing tables are created.
So I guess somewhere in the update an absolute path (/dbinit/mysql.sql) was used instead of the correct one.
Any idea how to get the RoundCube DB connected again?
Thanks!
My current server:
/etc/redhat-release:CentOS release 6.10 (Final)
/usr/local/cpanel/version:11.86.0.8
/var/cpanel/envtype:standard
CPANEL=release
mariadb 10.3.22
exim 4.93-2
imap 2.3.8
Restarted exim but did not change anything.
/var/cpanel/roundcube/log/errors:
[04-Mar-2020 09:31:04 America/Miami] PHP Warning: file_get_contents(/usr/local/cpanel/base/3rdparty/roundcube/plugins/carddav/dbinit/mysql.sql): failed to open stream: No such file or directory in /usr/local/cpanel/base/3rdparty/roundcube/plugins/carddav/carddav.php on line 54
[04-Mar-2020 09:31:04 -0400]: <3967603f> DB Error: [1146] Table 'roundcube.carddav_addressbooks' doesn't exist (SQL Query: SELECT * FROM carddav_addressbooks WHERE user_id='180' AND presetname is not null) in /usr/local/cpanel/base/3rdparty/roundcube/program/lib/Roundcube/rcube_db.php on line 543 (GET /cpsess0429168017/3rdparty/roundcube/index.php?login=1&post_login=....)
Current installed packages: Apache 2.4, PHP 5.6, PHP 7.1, PHP 7.2, and PHP 7.3
On strange update was part of this update (update to a lower version?):
[2020-03-04 02:32:14 -0400] info [update-roundcube-db] Roundcube update from 1.3.8-16.cp1184 to 1.3.8-13.cp1186 in progress.
[2020-03-04 02:32:14 -0400] info [update-roundcube-db] Roundcube updated to 1.3.8-13.cp1186
Found some more in /var/cpanel/roundcube/log/carddav:
[04-Mar-2020 07:41:52 -0400]: <883552e1> Can't find migration: /dbinit/mysql.sql
I do not see the table 'carddav_addressbooks' in the current DB, I only see 'carddav_migrations'.
I can find a mysql.sql file in /usr/local/cpanel/base/3rdparty/roundcube/plugins/carddav/dbmigrations/0000-dbinit/ and in that file the missing tables are created.
So I guess somewhere in the update an absolute path (/dbinit/mysql.sql) was used instead of the correct one.
Any idea how to get the RoundCube DB connected again?
Thanks!
Last edited: