[imp] attachments larger than 100 KB are corrupted

[Michael M Slusarz]

Quoting Cooper Self <cooper at goldrush.com>:

> On 05/22/2013 09:08 AM, Michael M Slusarz wrote:
>> Quoting Andy Dorman <adorman at ironicdesign.com>:
>>
>>> On 05/22/2013 10:06 AM, Cooper Self wrote:
>>>> On 05/22/2013 03:35 AM, Jan Schneider wrote:
>>>>>
>>>>> Zitat von Cooper Self <cooper at goldrush.com>:
>>>>>
>>>>>> Hello,
>>>>>>
>>>>>> I recently brought a new server online running Groupware 5.0.4 and
>>>>>> Imp 6.0.4 I have come across a strange issue. Any attachments over
>>>>>> 100 KB are corrupted. I am not seeing any errors on the server.
>>>>>> Larger files around a 1MB stall while uploading. I've check my
>>>>>> php.ini and my upload_max_filesize is 25MB post_max_size is 50MB and
>>>>>> memory_limit in 128MB. I'm not sure what else to check at this point.
>>>>>> any help would be greatly appreciated
>>>>>
>>>>> Where do you store attachments? If in VFS, which backend do you use?
>>>>
>>>> Thank you for the response.
>>>>
>>>> I am using VFS and the backend is MySQL/PDO
>>>>
>>>
>>> FWIW, we are testing the same Groupware/Imp versions using the  
>>> local FS for the VFS backend and not having any difficulties with  
>>> large (1MB+) attachments.
>>
>> I would use another VFS backend.
>>
>> As has been stated multiple times on the lists the last few months,  
>> SQL databases ARE NOT a good idea for storing any sort of binary  
>> data.  This is partially because of the inherent historical design  
>> of RDBMS, but primarily because configuration simply is a crapshoot  
>> across various DBs.
>>
>> You will be MUCH better served using a different backend for things  
>> like VFS and Caching than SQL.  This is a major reason why we have  
>> added support for a NoSql backend - MongoDB - in Horde 5.1 since  
>> this kind of db HAS been designed precisely to hold this kind of  
>> binary blob-ish data.
>>
>> michael
>>
>> ___________________________________
>> Michael Slusarz [slusarz at horde.org]
>>
> I disable VFS for composition and attachments are uploading  
> correctly now. Thank you all for your help.

You don't want to *disable* VFS.  You will lose, for example, the  
ability to restore drafts saved when a session expires.

I suggested you change the VFS backend.  I.e. using the filesystem driver.

michael

___________________________________
Michael Slusarz [slusarz at horde.org]