[horde] Memory size problem with file manager

Fri Mar 3 14:59:45 UTC 2017

Hi,

"horde" <horde-bounces at lists.horde.org> wrote on 2017.03.03 16:21:15:

> From: Wolfgang Rauchholz <wp.rauchholz at wo-lar.com>
> To: horde at lists.horde.org
> Date: 2017.03.03 16:21
> Subject: Re: [horde] Memory size problem with file manager
> Sent by: "horde" <horde-bounces at lists.horde.org>
> 
>   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
> >
> > I am changing global VFS in Horde. In Gollem, the 
> > parameter  $conf[backend][backend_list] is set to 
> > NONE. $conf[foldercache][use_cache] is set to no
> > --
> > Wolfgang
> > --
> > Horde mailing list
> > Frequently Asked Questions: http://horde.org/faq/To unsubscribe, 
> > mail: horde-unsubscribe at lists.horde.org
> >
> >  
> 
> Still trying to find a solution for my problem. Is there anybody out 
> there who ran into the same issue and can help me?

You need to find out why in your setup changing settings does nothing to 
the actual configuration used. Maybe it has something to do with caching?

Start changing other, more extreme, parameters, like database password, 
and see if these changed are actually applied.

-- 
   Vilius