Re: [imp] attachments larger than 100 KB are corrupted

2013-05-22 Thread Andy Dorman

On 05/22/2013 10:06 AM, Cooper Self wrote:

On 05/22/2013 03:35 AM, Jan Schneider wrote:


Zitat von Cooper Self coo...@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.


--
Andy Dorman
--
imp mailing list
Frequently Asked Questions: http://wiki.horde.org/FAQ
To unsubscribe, mail: imp-unsubscr...@lists.horde.org


Re: [imp] attachments larger than 100 KB are corrupted

2013-05-22 Thread Cooper Self

On 05/22/2013 09:08 AM, Michael M Slusarz wrote:

Quoting Andy Dorman ador...@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 coo...@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 [slus...@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

--
imp mailing list
Frequently Asked Questions: http://wiki.horde.org/FAQ
To unsubscribe, mail: imp-unsubscr...@lists.horde.org


Re: [imp] attachments larger than 100 KB are corrupted

2013-05-22 Thread Michael M Slusarz

Quoting Cooper Self coo...@goldrush.com:


On 05/22/2013 09:08 AM, Michael M Slusarz wrote:

Quoting Andy Dorman ador...@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 coo...@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 [slus...@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 [slus...@horde.org]

--
imp mailing list
Frequently Asked Questions: http://wiki.horde.org/FAQ
To unsubscribe, mail: imp-unsubscr...@lists.horde.org