Control Web Panel

WebPanel => E-Mail => Topic started by: comput86 on October 06, 2021, 11:57:03 AM

Title: Roundcube: Unable to connect to the database!
Post by: comput86 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?

Title: Re: Roundcube: Unable to connect to the database!
Post by: rustylh on October 06, 2021, 12:02:54 PM

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

Have no idea how to fix.

Title: Re: Roundcube: Unable to connect to the database!
Post by: waydenie on October 06, 2021, 12:12:49 PM

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

Title: Re: Roundcube: Unable to connect to the database!
Post by: comput86 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?

Title: Re: Roundcube: Unable to connect to the database!
Post by: waydenie 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.

Title: Re: Roundcube: Unable to connect to the database!
Post by: waydenie 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.

Title: Re: Roundcube: Unable to connect to the database!
Post by: rocha 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.

Title: Re: Roundcube: Unable to connect to the database!
Post by: studio4host 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


Title: Re: Roundcube: Unable to connect to the database!
Post by: rocha on October 06, 2021, 07:02:14 PM

Still with error.

Quote from: studio4host 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


Title: Re: Roundcube: Unable to connect to the database!
Post by: JohnG on October 22, 2021, 04:48:50 PM

try it

Code: [Select]

sh /scripts/mail_roundcube_update