[imp] Occassinal Problem with attachment not arriving.

[Tobias Drewry]

Quoting Jan Schneider <jan at horde.org>:

> Zitat von tdrewry at bu.edu:
>
>> [Configuration]
>> We are running:
>> - Horde: 3.0.8 patched to 3.1 security updates.
>> - IMP:   4.0.4
>> - Ingo:  1.0.2
>> - Turba: 2.0.5
>>
>> This is running on PHP 4.3.9 and Apache 1.3.26 (internal build).
>> Additionally we are using MySQL for session and vfs handling.
>> All of this is then running under Solaris 5.8 and duplicated across 4
>> servers sharing Horde (zend encoded) file access via an AFS location. A
>> single (separate) server handles the MySQL connections for all four
>> back ends.
>>
>> Within php, magic.mime is correctly pathed.
>>
>> The Horde vfs is configured for SQL as such:
>>
>> $conf['sql']['persistent'] = false;
>> $conf['sql']['hostspec'] = $_SERVER['XXXX'];
>> $conf['sql']['username'] = $_SERVER['XXXX'];
>> $conf['sql']['password'] = $_SERVER['XXXX'];
>> $conf['sql']['port'] = 3306;
>> $conf['sql']['protocol'] = 'tcp';
>> $conf['sql']['database'] = $_SERVER['XXXX'];
>> $conf['sql']['charset'] = 'iso-8859-1';
>> $conf['sql']['phptype'] = 'mysql';
>> <snip>
>> $conf['vfs']['params']['driverconfig'] = 'horde';
>> $conf['vfs']['type'] = 'sql';
>>
>> <where $_SERVER['XXXX'] is a server variable related to the field
>> it is referenced by.>
>>
>> IMP is configured to use the Horde vfs:
>> $conf['compose']['use_vfs'] = true;
>>
>> [Problem]
>> The specific problem which we are encountering is, on occassion, when a
>> client attachs files to an email message, staying well within the 2 MB
>> cap we impose, then clicks the "Send Message" button, the message
>> appears to send correctly, only to arrive on the other side without the
>> attachments.
>>
>> The logs show no sign of errors related to MySQL or VFS.
>>
>> My suspiciion is that his is in some way related to the server
>> switching but since it appears that the client does retain their
>> sessionID, I can't figure out how or why it would cause VFS access
>> to mismatch or be ignored.
>
> Have you been able to trace whether the file ever ended up in the VFS
> backend? I.e. did it get lost somehow, or has it simply not been sent
> with the message and still sits in the VFS?
>
> Jan.

I have traced the email and I've added syslog calls into the compose
context to trace the addition of the attachments.  What I see is the 
attachment created, and when I perform a query on the DB with the VFS 
id, the attachment is truely there.  And when the message is sent,
the file from VFS is cleaned out, but the attachment still does not 
arrive on the recipients end.

-----------------------------------------------------------------------
Tobias Drewry                                              617-353-8282
Analyst/Consultant III                                   tdrewry at bu.edu
Boston University                              Central Consulting Group
-----------------------------------------------------------------------