Author Topic: Roundcube: Unable to connect to the database!  (Read 6495 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
Roundcube: Unable to connect to the database!
« on: October 06, 2021, 11:57:03 AM »
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]
[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?

Offline
*
Re: Roundcube: Unable to connect to the database!
« Reply #1 on: October 06, 2021, 12:02:54 PM »
I am having the same issue " DATABASE ERROR: CONNECTION FAILED! "

Have no idea how to fix.

Offline
*
Re: Roundcube: Unable to connect to the database!
« Reply #2 on: October 06, 2021, 12:12:49 PM »
Same issues here... Was there an update pushed out?

Offline
*
Re: Roundcube: Unable to connect to the database!
« Reply #3 on: October 06, 2021, 12:28:12 PM »
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?

Offline
*
Re: Roundcube: Unable to connect to the database!
« Reply #4 on: October 06, 2021, 12:43:54 PM »
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.

Offline
*
Re: Roundcube: Unable to connect to the database!
« Reply #5 on: October 06, 2021, 12:47:52 PM »
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.

Offline
*
Re: Roundcube: Unable to connect to the database!
« Reply #6 on: October 06, 2021, 06:35:27 PM »
Same error! roundcube only show this message.

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

Offline
*
Re: Roundcube: Unable to connect to the database!
« Reply #7 on: October 06, 2021, 06:47:02 PM »
try to run
Code: [Select]
/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
VPS & Dedicated server provider with included FREE Managed support for CWP.
http://www.studio4host.com/

*** Don't allow that your server or website is down, choose hosting provider with included expert managed support for your CWP.

Offline
*
Re: Roundcube: Unable to connect to the database!
« Reply #8 on: October 06, 2021, 07:02:14 PM »
Still with error.

try to run
Code: [Select]
/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

Offline
*
Re: Roundcube: Unable to connect to the database!
« Reply #9 on: October 22, 2021, 04:48:50 PM »
try it
Code: [Select]
sh /scripts/mail_roundcube_update