[horde] Ansel - Some Images stay grey

Mon Mar 5 22:44:03 UTC 2012

Quoting Andreas Mauser <andreas at mauser.info>:

> Hi,
>
> ----- Nachricht von Michael J Rubinsky <mrubinsk at horde.org> ---------
>   Datum: Mon, 05 Mar 2012 14:00:23 -0500
>     Von: Michael J Rubinsky <mrubinsk at horde.org>
> Betreff: Re: [horde] Ansel - Some Images stay grey
>      An: horde at lists.horde.org
>
>
>> Quoting Andreas Mauser <andreas at mauser.info>:
>>
>>> Hi,
>>>
>>> ----- Nachricht von Michael J Rubinsky <mrubinsk at horde.org> ---------
>>> Datum: Mon, 05 Mar 2012 13:40:46 -0500
>>>   Von: Michael J Rubinsky <mrubinsk at horde.org>
>>> Betreff: Re: [horde] Ansel - Some Images stay grey
>>>    An: horde at lists.horde.org
>>>
>>>
>>>> Quoting Andreas Mauser <andreas at mauser.info>:
>>>>
>>>>> Hi,
>>>>>
>>>>> ----- Nachricht von Michael J Rubinsky <mrubinsk at horde.org> ---------
>>>>> Datum: Mon, 05 Mar 2012 12:57:00 -0500
>>>>> Von: Michael J Rubinsky <mrubinsk at horde.org>
>>>>> Betreff: Re: [horde] Ansel - Some Images stay grey
>>>>>  An: horde at lists.horde.org
>>>>>
>>>>>
>>>>>> Quoting Andreas Mauser <andreas at mauser.info>:
>>>>>>
>>>>>>> Hi,
>>>>>>>
>>>>>>>
>>>>>>> ----- Nachricht von Michael J Rubinsky <mrubinsk at horde.org> ---------
>>>>>>> Datum: Mon, 05 Mar 2012 10:04:01 -0500
>>>>>>> Von: Michael J Rubinsky <mrubinsk at horde.org>
>>>>>>> Betreff: Re: [horde] Ansel - Some Images stay grey
>>>>>>> An: horde at lists.horde.org
>>>>>>>
>>>>>>>
>>>>>>>> Quoting Andreas Mauser <andreas at mauser.info>:
>>>>>>>>
>>>>>>>>> Hi,
>>>>>>>>>
>>>>>>>>> ----- Nachricht von Andreas Mauser <andreas at mauser.info> ---------
>>>>>>>>> Datum: Fri, 02 Mar 2012 15:53:40 +0100
>>>>>>>>> Von: Andreas Mauser <andreas at mauser.info>
>>>>>>>>> Betreff: Re: [horde] Ansel - Some Images stay grey
>>>>>>>>> An: horde at lists.horde.org
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>> Hi
>>>>>>>>>> ----- Nachricht von Michael J Rubinsky <mrubinsk at horde.org>  
>>>>>>>>>> ---------
>>>>>>>>>> Datum: Fri, 02 Mar 2012 09:17:32 -0500
>>>>>>>>>> Von: Michael J Rubinsky <mrubinsk at horde.org>
>>>>>>>>>> Betreff: Re: [horde] Ansel - Some Images stay grey
>>>>>>>>>> An: horde at lists.horde.org
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>> Quoting Andreas Mauser <andreas at mauser.info>:
>>>>>>>>>>>
>>>>>>>>>>>> Hi
>>>>>>>>>>>> ----- Nachricht von Andreas Mauser <andreas at mauser.info> ---------
>>>>>>>>>>>> Datum: Fri, 02 Mar 2012 13:06:18 +0100
>>>>>>>>>>>> Von: Andreas Mauser <andreas at mauser.info>
>>>>>>>>>>>> Betreff: [horde] Ansel - Some Images stay grey
>>>>>>>>>>>> An: horde at lists.horde.org
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>> Hi,
>>>>>>>>>>>>>
>>>>>>>>>>>>> I just installed Ansel and uploaded some Pictures in JPG format.
>>>>>>>>>>>>>
>>>>>>>>>>>>> Some of them work flawlessly, but some of them stay just  
>>>>>>>>>>>>> grey. Looks as its not fully uploaded and/or processed.
>>>>>>>>>>>>>
>>>>>>>>>>>>> I tried the Ajax uploader and the normal one.
>>>>>>>>>>>>> I tried with and without thumbnails.
>>>>>>>>>>>>>
>>>>>>>>>>>>> Is it up to the image format?
>>>>>>>>>>>>>
>>>>>>>>>>>> I found out that when I scale the image I want to upload  
>>>>>>>>>>>> to a smaller scale then more of the picture gets uploaded.
>>>>>>>>>>>>
>>>>>>>>>>>> Max_Upload and max_filesize is at 200MB
>>>>>>>>>>>
>>>>>>>>>>> Either the picture is larger than this, or maybe you are  
>>>>>>>>>>> hitting against PHP's memory_limit.
>>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> In /etc/php5/apache2/php.ini the memory_limit is at 200M
>>>>>>>>>> and in /etc/php5/cli/php.ini it is set to -1 which means no limit
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>> I found out the following when I want to add an image to Ansel:
>>>>>>>>>
>>>>>>>>> Mar  2 19:36:59 webster HORDE: [ansel] PHP ERROR: Undefined  
>>>>>>>>> variable: page [pid 2124 on line 261 of  
>>>>>>>>> "/var/www/mauser.info/mailoffice/ansel/lib/View/Upload.php"]
>>>>>>>>
>>>>>>>> Not relevant to the problem, but should still be fixed.
>>>>>>>>
>>>>>>>>> Mar  2 19:36:59 webster HORDE: [ansel] PHP ERROR:  
>>>>>>>>> unlink(/tmp/vfsNLUMvc): Datei oder Verzeichnis nicht  
>>>>>>>>> gefunden [pid 2124 on line 1 of  
>>>>>>>>> "/var/www/mauser.info/mailoffice/pear/php/Horde/Vfs/Base.php(196) :  
>>>>>>>>> runtime-created function"]
>>>>>>>>
>>>>>>>> What type of VFS backend are you using?
>>>>>>>
>>>>>>> It shows SQL Database and below Horde defaults.
>>>>>>
>>>>>> My guess is that the image is too large for the database  
>>>>>> storage, or the max packet size of the DB server. Try changing  
>>>>>> to a file based VFS and see if that helps.
>>>>>
>>>>>
>>>>> OK. I can now confirm that it looks like the bug you mentioned.
>>>>>
>>>>> I set to file based VFS and I can upload to the PHP max_upload  
>>>>> size w/o any problem.
>>>>>
>>>>> So I will go on use the file based VFS until your next release.
>>>>
>>>> This probably has nothing to do with the bug, but rather an issue  
>>>> with your database configuration.
>>>>
>>>
>>> Oh, thats the worst I wanted to hear :(
>>>
>>> What do you suggest in that case? I want for my own good-feeling  
>>> have a good-working and OK installation of H4.
>>
>> For starters, storing all the image data for an application like  
>> Ansel in a SQL datbase is going to be *horribly* ineffecient.  
>> Unless you have a good reason why you can't use a filebased VFS, I  
>> would reconsider.
>
> May I ask at last how you mean 'horribly inefficient'?
> Do you mean it that the images uploaded should be considered to be  
> small, or at least not to large so that they grow the DB into  
> enternity?
>
> Because when I think about it for longer I feel that file based  
> storage for Ansel only is a good choice indeed.
>
> But as I set to file based VFS I have seen all the images in Ansel  
> has been gone, I think because the path has changed out of my Horde  
> DB to a directory in my filesystem (which I created)
>
> Is there a way, if one changes the VFS, that the content of whats  
> already in the database can be moved to the new VFS storage?
>
> What else did I loose as I set the VFS to file based? I didnt find anything..

I apologize. I didn't realize this was running on a produciton system.  
  If you only changed the VFS driver for Ansel (by chaging this in  
Ansel's configuration), then you didn't loose anything from any other  
application. If you changed all of Horde (by changing the VFS in  
Horde's configuration) than it's possible other things may be  
temporarily "lost". IMP *can* use the VFS for storing attachments  
(though this depends on your configuration), Whups uses it to store  
attachements to tickets, Wicked uses it to store attachements to  
pages, and Turba uses it to store arbitrary files attached to  
contacts. If this is the case, they are not gone, it's just that Horde  
cannot find them since you told it to look on the filesystem in place  
of the database.

You can switch the driver back to Sql globally and, if you desire,  
change it only for Ansel.

As far as getting back images from the database if you want to stay  
with file-based VFS, IIRC there was a script for moving files between  
different VFS backends. I don't remember off hand if it was part of  
the Horde package or the Horde_Vfs package, and I'm not in front of  
the code at the moment to check.

-- 
mike

The Horde Project (www.horde.org)
mrubinsk at horde.org
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 6096 bytes
Desc: S/MIME Cryptographic Signature
URL: <http://lists.horde.org/archives/horde/attachments/20120305/ef1627f4/attachment.bin>