• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

Question Roundcube carddav plugin - missing carddav_addressbooks

proton23

Basic Pleskian
Hello!

Question is: What am I doing wrong?

I'm trying to install carddav plugin to roundcube.
I tried "via git" and "via tarball" versions from roundcube/carddav - Roundcube Webmail Plugin Repository

But after enabling the plugin when I try to login I get a page with:
HTML:
DATABASE ERROR: CONNECTION FAILED!
Unable to connect to the database!
Please contact your server-administrator.
/var/log/plesk-roundcube/errors tells me this:
Code:
/usr/share/psa-roundcube/program/lib/Roundcube/rcube_db.php on line 539 (GET /?_task=mail&_reply_uid=11646&_mbox=INBOX&_action=compose)
[25-Mar-2018 19:08:54 +0000]: <tjmfhf9p> DB Error: [1146] Table 'roundcubemail.carddav_addressbooks' doesn't exist (GET /?_task=mail&_reply_uid=11646&_mbox=INBOX&_action=compose)

I also tried to execute the sql-scripte myself like for caldav (https://support.plesk.com/hc/en-us/articles/115002812813-How-to-install-kolab-calendar-plugin-for-RoundCube- )
but this results in
Code:
# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -uadmin roundcubemail < /usr/share/psa-roundcube/plugins/carddav/dbmigrations/0000-dbinit/mysql.sql
ERROR 1215 (HY000) at line 2: Cannot add foreign key constraint
This thread
Table 'roundcubemail.carddav_addressbooks' doesn't exist (GET /) doesn't exist · Issue #189 · blind-coder/rcmcarddav
seems to think it's an plesk issue and that's why I'm here.

I'm a little bit stuck and every help is highly appreaciated.

Best regards
 
Last edited:
Finally I managed to make it work.
Running those sql-scripts manually required to remove 'TABLE_PREFIX' in every of them.

Don't know why it has not been replaced and executed on first login but now it works.

Best regards
 
Back
Top