[imp] attachments larger than 100 KB are corrupted

[Michael M Slusarz]

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]