[horde] Ansel - Some Images stay grey

[Andreas Mauser]

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..

>
> That being said, if you want to continue down this road - for  
> starters you could check the schema for the Vfs tables in the  
> database. I would also check for things like maximum allowable  
> packet size in the database server's configuration. Check the  
> database documentation for further information.

I know a sql guy and will ask him to show me that tomorrow. Will  
report results to you then.

Andreas