9.5.2 horde attachmnet problem

[Ray Lightning]

I have 2 servers, with PPP 9.5.2, both upgraded from 9.3.0 (debian lenny - i386 & amd64)
On both - webmail horde is not sending attachents! All looks fine, no errors in logs, mail sent, but recipient gets email without attachments - just text.

if I rollback to horde components from 9.3.0. - it is still not working!

Only rollback to components from 9.2.3 works again:

horde_3.1.7
imp_4.1.6
ingo_1.1.5
kronolith_2.1.8
mimp_1.0.2
mnemo_2.1.2
passwd_3.0.1
turba_2.1.7


I seen this situation at first server, and after upgrade - on second.
Is this fixed somehow?

sorry for my bad english :-(

 

[IgorG]

Is this problem related only with sending emails via webmail or you have the same problem with direct sending emails via this mail server? Do you have Qmail or Postfix MTA there?

 

[Ray Lightning]

This problem exists only if I use webmail, and only horde. AtMail works OK.
MTA - postfix

 

[IgorG]

Do you have any related error messages in /var/log/psa-horde/psa-horde.log ?

 

[Ray Lightning]

Do you have any related error messages in /var/log/psa-horde/psa-horde.log ?

I see this strange things (real addresses replaced by [email protected]):

Jun 25 20:04:06 HORDE [error] [turba] DB Error: no such field: SELECT object_id, owner_id, object_type, object_members, object_uid, object_name, object_email, object_alias, object_homeaddress, object_workaddress, object_homephone, object_workphone, object_cellphone, object_fax, object_title, object_company, object_notes, object_pgppublickey, object_smimepublickey, object_freebusyurl FROM turba_objects WHERE (owner_id = '[email protected]' AND (LOWER(object_email) LIKE LOWER('%[email protected]%'))) [nativecode=1054 ** Unknown column 'object_name' in 'field list'] [on line 131 of "/usr/share/psa-horde/turba/lib/Driver/sql.php"]

But this messages appeared not the same time of sending mail with attachments

 

[IgorG]

Seems you have not correctly upgraded horde packages there. This problem caused by old version of psa-turba installed on the source. Horde 2.2 dropped columns 'object_name', 'object_homeaddress', 'object_workaddress' in horde.turba_objects table.
Try to remove all horde packages and install all back with autoinstaller.

 

[Ray Lightning]

I have installed horde "complect", by installer and by aptitude, after purging it and without purge (purge = debian way clean of package config), and nothing changes...
And I have identical problem on two servers, upgraded consequently.

Now, with 9.2.3 version of horde packages, all works (but i see error, with wrong columns in DB), but with 9.5.2 version it is not working (problem of loosing attachments)... Is this can work in 9.5.2 only after clean install?

 

[Michael neese]

Do you have any php modules disabled for security reasons...possibly affecting mail functions...check your php.ini for modules that are enabled or disabled...

 

[DraganM]

problem related to older eaccelerator

After a bunch of research it looks like this is usually related to and older eaccelerator module installed on the system (only our servers using php4/centos4 were experiencing this issue)

The fix:

In the logs I saw this when uploading an attachment in horde:
PHP Fatal error: Can't load Horde/Serialize.php, open_basedir restriction. in /usr/share/psa-horde/lib/Horde/SessionObjects.php on line 134,

Change the php require Horde/Serialize.php line on line 134 to include the full path eg: /usr/share/psa-horde/lib/Horde/Serialize.php and it should fix the error.

 

[IgorG]

Check it too - http://kb.odin.com/en/969