Topic: Zarafa Problems

[compsos]

This is not an SME bug, just raising it here as a reference for other users.
FYI
If you get emails that can not be deleted or blank entries when the inbox says there are x number of unread emails or emails that will not delete etc check the /var/log/zarafa/server.log. If it has entries containing

SQL Failed: Duplicate entry '26080-........

You are not alone as there is a fair bit of activity on the Zarafa forums but so far no solutions. All the reports seem to involve the tag value of 26080 in the indexproperties table when it combines with the val_binary value to create a unique key. The MYSQL tools like check and repair report all is OK. Does anyone know of a test that can report on the combined key of the tag, val_binary (considering the last is a varbinary type in a innodb system)?

[Mjohnson]

I have, regrettably, given up on zarafa as production ready software hosted on SME.  In all fairness, the warning is clear on the SME Zarafa Wiki.  Very promising package but not ready for prime time.

I really liked Zarafa but have neither the time nor talent to bet the farm on it for work.  I have moved the company's email system off SME to a commercially hosted solution.  Version upgrade 6.30.6 killed it for me.  SME remains our file and backup server of choice, just not for email.

Sorry to shang-hi your post. 

MJ

[compsos]

Hi MJ
 All is OK until the DB is not quite right. The upgrade from 6.30.6 was a relocation on the webaccess directory. But this is not the only package that has done this lately (ie) asterisk.

But the lack of checking referential integrity is a worry. From what I can see the DB has no table joins so it is up to the code to link the tables.