[imp] attachments larger than 100 KB are corrupted

[Cooper Self]

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.

-- 


Cooper Self

Network Operations Specialist

Gold Rush Internet LLC

Mother Lode Internet LLC

Hub3 Networks