[horde] Memory size problem with file manager

[Ralf Lang]

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.


-- 
Ralf Lang
Linux Consultant / Developer
Tel.: +49-170-6381563
Mail: lang at b1-systems.de
B1 Systems GmbH
Osterfeldstraße 7 / 85088 Vohburg / http://www.b1-systems.de
GF: Ralph Dehner / Unternehmenssitz: Vohburg / AG: Ingolstadt,HRB 3537