• 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

Upgrade to 7.5.4 broke addressbook (horde/turba) in webmail

  • Thread starter fredrik.haglund
  • Start date
F

fredrik.haglund

Guest
During upgrade of plesk from 7.5.2 to 7.5.4 the psa-horde module was upgraded to a newer version. This or adding the module "Additional Horde (webmail) components for Plesk" broke the addressbook (turba). It was no longer possible to see content or add new content anymore.

The file /usr/share/psa-horde/turba/config/sources.php was replaced with a newer one during upgrade. The configuration in sources.php does not match the existing table turba_objects in mysql horde database. New columns has been added but it appears that the plesk setup did not upgrade the tables.

To fix this I run the upgrade script for turba:
/usr/share/psa-horde/turba/scripts/upgrades/1.2_to_2.0.sql

ALTER TABLE turba_objects ADD COLUMN object_uid VARCHAR(255);
ALTER TABLE turba_objects ADD COLUMN object_freebusyurl VARCHAR(255);
ALTER TABLE turba_objects ADD COLUMN object_smimepublickey TEXT;
ALTER TABLE turba_objects ADD COLUMN object_pgppublickey TEXT;

Kind regards,
Fredrik Haglund
 
Back
Top