[horde] Memory size problem with file manager

[Vilius Sumskas/LNK]

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