Roundcube: Unable to connect to the database!

[comput86]

Hello, today I just woke up and get DATABASE ERROR: CONNECTION FAILED! Unable to connect to the database! Please contact your server-administrator.
I checked logs and found this lines:

Code Select Expand

[06-Oct-2021 11:01:38 +0000]: <k7jndjf7> DB Error: [1146] Table 'roundcube.carddav_addressbooks' doesn't exist (SQL Query: SELECT * FROM carddav_addressbooks WHERE ((`user_id` = '8'))) in /usr/local/cwpsrv/var/services/roundcube/program/lib/Roundcube/rcube_db.php on line 543 (GET /roundcube/?_task=mail&_mbox=INBOX)
[06-Oct-2021 11:01:38 +0000]: <k7jndjf7> DB Error: [1146] Table 'roundcube.carddav_addressbooks' doesn't exist (GET /roundcube/?_task=mail&_mbox=INBOX)
[06-Oct-2021 11:01:41 +0000]: <k7jndjf7> DB Error: [1146] Table 'roundcube.carddav_addressbooks' doesn't exist (SQL Query: SELECT * FROM carddav_addressbooks WHERE ((`user_id` = '8'))) in /usr/local/cwpsrv/var/services/roundcube/program/lib/Roundcube/rcube_db.php on line 543 (GET /roundcube/?_task=mail&_mbox=INBOX)
[06-Oct-2021 11:01:41 +0000]: <k7jndjf7> DB Error: [1146] Table 'roundcube.carddav_addressbooks' doesn't exist (GET /roundcube/?_task=mail&_mbox=INBOX)
[06-Oct-2021 11:01:56 +0000]: <k7jndjf7> DB Error: [1146] Table 'roundcube.carddav_addressbooks' doesn't exist (SQL Query: SELECT * FROM carddav_addressbooks WHERE ((`user_id` = '8'))) in /usr/local/cwpsrv/var/services/roundcube/program/lib/Roundcube/rcube_db.php on line 543 (GET /roundcube/)
[06-Oct-2021 11:01:56 +0000]: <k7jndjf7> DB Error: [1146] Table 'roundcube.carddav_addressbooks' doesn't exist (GET /roundcube/)
[06-Oct-2021 11:01:58 +0000]: <k7jndjf7> DB Error: [1146] Table 'roundcube.carddav_addressbooks' doesn't exist (SQL Query: SELECT * FROM carddav_addressbooks WHERE ((`user_id` = '8'))) in /usr/local/cwpsrv/var/services/roundcube/program/lib/Roundcube/rcube_db.php on line 543 (GET /roundcube/)

What actually happened and how to fix it?

[rustylh]

I am having the same issue " DATABASE ERROR: CONNECTION FAILED! "

Have no idea how to fix.

[waydenie]

Same issues here... Was there an update pushed out?

[comput86]

I don't know what actually it was, but after a little research I found this: https://github.com/mstilkerich/rcmcarddav/issues/106#issuecomment-113430383
I'm logged out from Roundcube then logged in again, and now it works! 

OFFTOPIC: Is there any way to completely stop mystic that pretty often happens with CWP?

[waydenie]

Thanks, logging back in works... The skin has changed, does anyone know the old skin name and new? Sorry, not sure about your mystic question.

[waydenie]

Found it.. looks like it's now set to "Elastic" skin, seems that it used to be "Larry"?

It's in Settings\Preferences\User Interface\Interface skin ; if you're looking for it.

[rocha]

Same error! roundcube only show this message.

DATABASE ERROR: CONNECTION FAILED!
Unable to connect to the database!
Please contact your server-administrator.

[studio4host]

try to run

Code Select Expand

/scripts/mail_roundcube_update
curl -sS 'http://static.cdn-cwp.com/files/mail/mysql.initial.calender.sql'|mysql --defaults-extra-file=/root/.my.cnf roundcube
curl -sS 'http://static.cdn-cwp.com/files/mail/mysql.initial.tasklist.sql'|mysql --defaults-extra-file=/root/.my.cnf roundcube


[rocha]

Still with error.

try to run

Code Select Expand

/scripts/mail_roundcube_update
curl -sS 'http://static.cdn-cwp.com/files/mail/mysql.initial.calender.sql'|mysql --defaults-extra-file=/root/.my.cnf roundcube
curl -sS 'http://static.cdn-cwp.com/files/mail/mysql.initial.tasklist.sql'|mysql --defaults-extra-file=/root/.my.cnf roundcube


[JohnG]

try it

Code Select Expand

sh /scripts/mail_roundcube_update