[horde] Memory size problem with file manager

[Wolfgang Rauchholz]

  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
 

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.
>
> --
> 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
> --
> Horde mailing list
> Frequently Asked Questions: http://horde.org/faq/To unsubscribe,  
> mail: horde-unsubscribe at lists.horde.org
-- 
Wolfgang