• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • Support for BIND DNS has been removed from Plesk for Windows due to security and maintenance risks.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS.

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