Problem of address book in Horde

[CesarV]

When I try to access the address book, appears an error /turba/addressbooks/index.php Was not found on the current server. How can I fix the problem.

Thanks.

 

[dcwds]

I am running into same issue. Plesk has really went downhill since Parallels took over.

 

[IgorG]

Make sure that you have correctly upgraded all horde related packages like psa-turba, psa-khronolith, psa-imp, psa-horde, psa-mimp, psa-mnemo, psa-passwd, psa-ingo.
Try to remove/add horde webmail with webmailmng.

 

[dcwds]

/usr/local/psa/admin/bin/webmailmng --remove --name=horde

doesn't return anything and install doesnt either.

I also tried yum remove psa-horde which works and then I reinstalled using plesk updater and i can get to horde just fine yet address books still have issues

 

[dcwds]

I am also noticing SQL issues.

Apr 16 00:22:13 HORDE [error] [turba] DB Error: no such field: SELECT object_id, owner_id, object_type, object_members, object_uid, object_firstname, object_lastname, object_middlenames, object_nameprefix, object_namesuffix, object_alias, object_bday, object_homestreet, object_homepob, object_homecity, object_homeprovince, object_homepostalcode, object_homecountry, object_workstreet, object_workpob, object_workcity, object_workprovince, object_workpostalcode, object_workcountry, object_tz, object_email, object_homephone, object_workphone, object_cellphone, object_fax, object_pager, object_title, object_role, object_company, object_category, object_notes, object_url, object_freebusyurl, object_pgppublickey, object_smimepublickey FROM turba_objects WHERE (object_type = 'Group' AND owner_id = '[email protected]') [nativecode=1054 ** Unknown column 'object_firstname' in 'field list'] [pid 13575 on line 79 of "/usr/share/psa-horde/turba/lib/base.php"]

 

[IgorG]

Seems horde webmail was not correctly upgraded. Try to remove mentioned packages and then install horde back with autoinstaller.

 

[dcwds]

I can handle removing but could you provide some example for autoinstaller, never really used it..

Running: yum remove psa-horde

Removing:
psa-horde noarch 3.3.6-cos5.build95100410.11 installed 20 M
Removing for dependencies:
psa-imp noarch 4.3.6-cos5.build95100410.11 installed 12 M
psa-ingo noarch 1.2.3-cos5.build95100410.11 installed 5.0 M
psa-kronolith noarch 2.3.3-cos5.build95100410.11 installed 6.1 M
psa-mimp noarch 1.1.3-cos5.build95100410.11 installed 2.7 M
psa-mnemo noarch 2.2.3-cos5.build95100410.11 installed 4.0 M
psa-passwd noarch 3.1.2-cos5.build95100410.11 installed 3.7 M
psa-turba noarch 2.3.3-cos5.build95100410.11 installed 5.5 M

 

[IgorG]

Just run /usr/local/psa/admin/sbin/autoinstaller and select horde there.

 

[Brujo]

just to confirm, the psa-horde.log blows up on my centos box since the upgrade.

Apr 17 07:16:19 HORDE [error] [kronolith] DB Error: no such field: SELECT event_id, event_uid, event_description, event_location, event_private, event_status, event_attendees, event_keywords, event_title, event_category, event_recurcount, event_recurtype, event_recurenddate, event_recurinterval, event_recurdays, event_start, event_end, event_alarm, event_modified, event_exceptions, event_creator_id FROM kronolith_events WHERE calendar_id = '[email protected]' AND event_alarm > 0 AND ((event_end >= '2010-04-17 00:00:00') OR (event_recurenddate >= '2010-04-17 00:00:00' AND event_recurtype <> 0)) [nativecode=1054 ** Unknown column 'event_private' in 'field list'] [pid 3176 on line 323 of "/usr/share/psa-horde/kronolith/lib/Driver/sql.php"]
Apr 17 07:16:19 HORDE [error] [turba] DB Error: no such field: SELECT object_id, owner_id, object_type, object_members, object_uid, object_firstname, object_lastname, object_middlenames, object_nameprefix, object_namesuffix, object_alias, object_bday, object_homestreet, object_homepob, object_homecity, object_homeprovince, object_homepostalcode, object_homecountry, object_workstreet, object_workpob, object_workcity, object_workprovince, object_workpostalcode, object_workcountry, object_tz, object_email, object_homephone, object_workphone, object_cellphone, object_fax, object_pager, object_title, object_role, object_company, object_category, object_notes, object_url, object_freebusyurl, object_pgppublickey, object_smimepublickey FROM turba_objects WHERE (object_type = 'Group' AND owner_id = '[email protected]') [nativecode=1054 ** Unknown column 'object_firstname' in 'field list'] [pid 3176 on line 173 of "/usr/share/psa-horde/turba/lib/Driver/sql.php"]

How to fix this issue ??

Brujo

 

[Brujo]

BTW the DB error exists for Calendar & Addressbook, before I try to remove psa-horde and reinstall via autoinstaller - will be the existing addressbook entrys also be removed? does this means all users Addressbooks entrys are gone ? or just the packages are replaced and the DB upgraded?

During the upgrade from 9.3 -> 9.5 there was nothing about wrong installation for horde


I checked with phpmyadmin the horde DB and the table turba_objects fields are

object_id
owner_id
object_type
object_uid
object_members
object_name
object_alias
object_email
object_homeaddress
object_workaddress
object_homephone
object_workphone
object_cellphone
object_fax
object_title
object_company
object_notes
object_pgppublickey
object_smimepublickey
object_freebusyurl

so this means the table wasnt updated since the sql statement has fields like object_firstname and others like object_middlenames, object_nameprefix, object_namesuffix.

Please advise the neccessary steps to get the update done without loosing Adressbook and Calendar entrys

Brujo

 

[Brujo]

I did yum remove psa-horde and installed horde webmail again via cli autoinstaller - No problem during installation but still the same issue - the tables are not updated.

As I found the only script to upgrade for example the turba table to match the new sql statement is /usr/share/psa-horde/turba/scripts/upgrades/2.1_to_2.2_sql_schema.php

see: http://www.horde.org/turba/docs/?f=UPGRADING.html

@IgorG - it seems your solution dosnt help, any suggestion ?

Brujo

 

[Farsus]

Got the same problems with horde after opgrading from 9.3 to 9.51

got the same errors in log file as others s;-)
cant create adress books

existing adress books missing

customers very unhappy with it

have try remove and install again that did not solved the problem

Please fast fix for this our instruction what todo so whe dont lose existing customers adressboks !!!!!!!

 

[CesarV]

Farsus, a quick solution. Remove the psa-turba-2.3.3 with the command rpm -e --nodeps psa-turba-2.3.3
Install psa-turba-2.1.7, which comes in Plesk 9.3.0. This will solve even a new version.

Regards.

 

[Farsus]

Farsus, a quick solution. Remove the psa-turba-2.3.3 with the command rpm -e --nodeps psa-turba-2.3.3
Install psa-turba-2.1.7, which comes in Plesk 9.3.0. This will solve even a new version.

Regards.

Thank you very very much CesarV

That infact solved the problem with the missing adress books for the moment



I sallud you for this

Farsus

 

[IgorG]

Guys, I have submitted request to developers regarding this problem.

 

[webjfg]

i have the same problem.
i'm running centos 5

 

[Ross Annetts]

CesarV's suggestion worked for me to, but now there is no scrolling up/down on the address book page if you have a lot of address. did you guys have the same problem?

 

[InsikL]

In Ubuntu 8.04 there seems to be a version mismatch between Turba and Horde causing the problem when clicking on "My Addressbook". The version that needs to be included is Turba 2.3.3 but the version installed with Plesk 9.5.1 is Turba 2.1.7 which has a different file and directory structure causing the reason for the 404 file not found error.

 

[IgorG]

In Ubuntu 8.04 there seems to be a version mismatch between Turba and Horde causing the problem when clicking on "My Addressbook". The version that needs to be included is Turba 2.3.3 but the version installed with Plesk 9.5.1 is Turba 2.1.7 which has a different file and directory structure causing the reason for the 404 file not found error.

It is 2.3.3 version - http://autoinstall.plesk.com/PSA_9....ba_2.3.3-ubuntu8.04.build95100409.18_i386.deb

 

[InsikL]

It is 2.3.3 version - http://autoinstall.plesk.com/PSA_9....ba_2.3.3-ubuntu8.04.build95100409.18_i386.deb

My mistake, I was looking at my other Plesk 9.2.3 server, but regardless, the directory structure for Turba on Plesk 9.5.1 is totally different then the version at the Horde site, there's file and directories that are missing in your installed version. Most notably the 'addressbooks' directory.

/usr/share/psa-horde/turba$ ll
total 82
-rw-r--r-- 1 root root 2911 Apr 9 07:15 add.php
-rw-r--r-- 1 root root 1315 Apr 9 07:15 browse.php
lrwxrwxrwx 1 root root 28 Apr 21 23:51 config -> /etc/psa-webmail/horde/turba
-rw-r--r-- 1 root root 4684 Apr 9 07:15 contact.php
-rw-r--r-- 1 root root 19090 Apr 9 07:15 data.php
-rw-r--r-- 1 root root 1576 Apr 9 07:15 delete.php
-rw-r--r-- 1 root root 1554 Apr 9 07:15 deletefile.php
lrwxrwxrwx 1 root root 24 Apr 21 23:51 docs -> /usr/share/doc/psa-turba
-rw-r--r-- 1 root root 3215 Apr 9 07:15 edit.php
-rw-r--r-- 1 root root 1303 Apr 9 07:15 index.php
drwxr-xr-x 10 root root 576 Apr 21 23:51 lib
drwxr-xr-x 41 root root 1016 Apr 21 23:51 locale
-rw-r--r-- 1 root root 3050 Apr 9 07:15 minisearch.php
drwxr-xr-x 5 root root 336 Apr 21 23:51 scripts
-rw-r--r-- 1 root root 7715 Apr 9 07:15 search.php
drwxr-xr-x 7 root root 304 Apr 21 23:51 templates
-rw-r--r-- 1 root root 6290 Apr 9 07:15 test.php
drwxr-xr-x 8 root root 248 Apr 21 23:51 themes
-rw-r--r-- 1 root root 1621 Apr 9 07:15 vcard.php
-rw-r--r-- 1 root root 3265 Apr 9 07:15 view.php

turba-h3-2.3.3$ ll
total 128
-rw-r--r-- 1 insik staff 2911 2009-01-06 10:27 add.php
drwxr-xr-x 2 insik staff 4096 2009-12-15 16:52 addressbooks
-rw-r--r-- 1 insik staff 1315 2009-01-06 10:27 browse.php
drwxr-xr-x 2 insik staff 4096 2009-12-15 16:52 config
-rw-r--r-- 1 insik staff 4684 2009-01-06 10:27 contact.php
-rw-r--r-- 1 insik staff 19090 2009-01-06 10:27 data.php
-rw-r--r-- 1 insik staff 1554 2009-01-06 10:27 deletefile.php
-rw-r--r-- 1 insik staff 1576 2009-01-06 10:27 delete.php
drwxr-xr-x 3 insik staff 4096 2009-12-15 16:52 docs
-rw-r--r-- 1 insik staff 3215 2009-01-06 10:27 edit.php
-rw-r--r-- 1 insik staff 1303 2009-01-06 10:27 index.php
drwxr-xr-x 3 insik staff 4096 2009-12-15 16:52 js
drwxr-xr-x 10 insik staff 4096 2009-12-15 16:52 lib
-rw-r--r-- 1 insik staff 2281 2009-01-06 10:27 LICENSE
drwxr-xr-x 41 insik staff 4096 2009-12-15 16:52 locale
-rw-r--r-- 1 insik staff 3050 2009-01-06 10:27 minisearch.php
drwxr-xr-x 2 insik staff 4096 2009-12-15 16:52 po
-rw-r--r-- 1 insik staff 2417 2007-12-20 09:34 README
drwxr-xr-x 5 insik staff 4096 2009-12-15 16:52 scripts
-rw-r--r-- 1 insik staff 7715 2009-01-06 10:27 search.php
drwxr-xr-x 7 insik staff 4096 2009-12-15 16:52 templates
-rw-r--r-- 1 insik staff 6290 2009-03-25 19:06 test.php
drwxr-xr-x 7 insik staff 4096 2009-12-15 16:52 themes
-rw-r--r-- 1 insik staff 1621 2009-01-06 10:27 vcard.php
-rw-r--r-- 1 insik staff 3265 2009-01-06 10:27 view.php