[horde] Memory size problem with file manager

Sat Mar 11 12:17:07 UTC 2017

Hi,

>   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

I've ment you should try changing other parameters, not only VFS. You need 
start looking why changing Horde configuration doesn't affect the 
installation itself. No one can help you with this. This is something 
related to your system only.

You should also start debugging why changing MySQL configuration doesn't 
affect MySQL behaviour. Maybe you are changing the wrong configuration 
file (or configuration file on the wrong server), or maybe you are putting 
parameters into incorrect section. That needs investigation. You can try 
to do a big SQL query manually on the server. 

-- 
   Vilius