[horde] Memory size problem with file manager

Fri Mar 10 16:41:04 UTC 2017

  Quoting Wolfgang Rauchholz <wp.rauchholz at wo-lar.com>:

> Quoting Vilius Sumskas/LNK <vilius at lnk.lt>:
>
>> Hi,
>>
>>> From: Wolfgang Rauchholz <wp.rauchholz at wo-lar.com>
>>> To: horde at lists.horde.org
>>> Date: 2017.02.27 16:34
>>> Subject: Re: [horde] Memory size problem with file manager
>>> Sent by: "horde" <horde-bounces at lists.horde.org>
>>>
>>>   Not working. Let's go step by step.
>>> I can upload small files. The size of the file that triggers the
>>> error is 1,3MB.
>>> I am changing parameters on tab 'Virtual File Storage Settings' in
>>> Horde confguration. The error message is create irrespective of
>>> whether I set it to 'Files on the local system' or 'No SQL database'.
>>>
>>> What I find strage is that in /var/log/messages it says
>>> 'max_allowed_packet', I set in /etc/my.cnf: max_allowed_packet=1024M
>>>
>>> Feb 27 15:08:14 home HORDE: [gollem] SQL QUERY FAILED: Got a
>>> packet bigger than 'max_allowed_packet' bytes  #012#011INSERT
>>> INTO `horde_vfs` (`vfs_type`, `vfs_path`,
>>> `vfs_name`,#012#011  `vfs_modified`, `vfs_owner`, `vfs_data`) VALUES
>>> (1,#012#011
>>>
>>> Can it be that the problem is omething else?
>>> I run under
>>> CENTOS7, mariadb-5.5.52-1.el7.x86_64, httpd-2.4.
>>> 6-45.el7.centos.x86_64, php-5.4.16-42.el7.x86_64
>>
>> Please don't top post. It is very hard to follow the discussion.
>>
>> Are you changing global VFS settings or VFS settings in Gollem? The last
>> time I tried Gollem it had a separate configuration. I could be wrong
>> though because it was years ago.
>>
>>> Wolfgang
>>>
>>> Quoting Ralf Lang <lang at b1-systems.de>:
>>>
>>> Hi Wolfgang,
>>>
>>> On 27.02.2017 11:23, Wolfgang Rauchholz wrote:
>>> There muust be something I don't uunderstand. I went to the
>>> configuraiton of Horde and set Virutal File system to 'No'.
>>> I continue getting the error message:
>>>
>>> Feb 27 11:20:50 home HORDE: [gollem] SQL QUERY FAILED: Got a packet
>>> bigger than 'max_allowed_packet' bytes  #012#011INSERT INTO
>>
>> `horde_vfs`
>>> (`vfs_type`, `vfs_path`, `vfs_name`,#012#011  `vfs_modified`,
>>> `vfs_owner`, `vfs_data`) VALUES (1,#012#011  'home/Administrator',
>>> 'Expenses 2017 01.pdf', 1488190850,#012#011  'Administrator',
>>
>> '%PDF-1.4
>>> %âãÏÓ 10 0 obj <</Parent 15 0#012#011  R/Type/Page/Contents[125 0
>>> R]/Resources<</XObject<</Im1 126 0#012#011
>>> R>>/ProcSet[/PDF/ImageC]>>/MediaBox[0 0 578.16 824.40]>> endobj 11
>>> 0#012#011  obj <</Parent 127 0 R/Type/Page/Contents[128 0#012#011
>>> R]/Resources<</XObject<</Im1 129 0#012#011
>>> R>>/ProcSet[/PDF/ImageC]>>/MediaBox[0 0 578.16 824.40]>> endobj 125
>>> 0#012#011  obj <</Length 45>>stream q 578.16 0 0 824.40 0 0 cm /Im1
>>
>> Do
>>> Q#012#011  endstream endobj 126 0 obj#012#011
>>> <</Type/XObject/Subtype/Image/ColorSpace/DeviceRGB/Width#012#011
>>> 1205/BitsPerComponent 8/Length 187191/Height#012#011
>>> 1718/Filter/DCTDecode>>stream ÿØÿà
>>> Feb 27 11:20:50 home HORDE: [gollem] SQL QUERY FAILED: MySQL server
>>
>> has
>>> gone away
>>>
>>> Wolfgang
>>>
>>> Quoting Jan Schneider <jan at horde.org>:
>>>
>>> Zitat von Wolfgang Rauchholz <wp.rauchholz at wo-lar.com>:
>>>
>>> Thank you Hendrik.
>>> This solved one of my problems. Thank you.
>>>
>>> I still get message: A fatal error has occurred QUERY FAILED: MySQL
>>> server has gone away SELECT alarm_id, a.......
>>>
>>> I looked in the log files and got this error: Feb 25 10:59:31 home
>>> HORDE: [gollem] SQL QUERY FAILED: Got a packet bigger than
>>> 'max_allowed_packet' bytes  #012#011INSERT INTO `horde_vfs`
>>> (`vfs_type`, `vfs_path`,
>>>
>>> I successive steps, I set max_allowed_packet=1024M in
>>
>> /etc/mysql.cnf
>>> and restarted the server. Problem still presists.
>>>
>>> Don't use a SQL vFS backend.
>>>
>>> Jan advised to use a vfs backend other than Sql. He did not advise
>>> not to use Vfs backends at all.
>>
>> --
>> Vilius
>> --
>> Horde mailing list
>> Frequently Asked Questions: http://horde.org/faq/To unsubscribe,  
>> mail: horde-unsubscribe at lists.horde.org

Finally some time to do more testing...
It does not matter how I set parameter in 'Cnfiguration > Virtual File  
Storage', I always get the same error message as atatched in file.
It is obvious that the error has something to do with the filesize; I  
can uplaod a small file. the 1,3MB files gets the error message.
  The parameters are set as follows:
my.cnf: max_allowed_packet=1024M
  php.ini:memory_limit = 1024M

-- 
Wolfgang
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: error.txt
URL: <https://lists.horde.org/archives/horde/attachments/20170310/145e7bb2/attachment.txt>