A while back I thought it would be a good idea to implement face detection in Gallery2, based on a similar feature in Facebook. I downloaded the OpenCV computer vision toolkit and ran the facedetect sample app against a collection of 60 photos from my gallery, some with no faces, others with a single face, still others with multiple faces, faces in profile, etc. No matter which training file I used, the face detection was horribly unreliable.

I just upgraded the Gallery install on bonzo to 2.2 RC1, which has some cool new features like dynamic albums, and (supposedly) performance improvements. It seems to have worked fine.

A while back I had some problems with MySQL running out of space on /var. Today I found out my Gallery2 was down, responding to all requests with “An error has occurred while interacting with the database.”

In the config.php file in the gallery2 install folder, there’s a line that sets the debug mode. By default it’s:

$gallery->setDebug(false);

For debugging I changed it to:

$gallery->setDebug('buffered'); 

and reloaded the Gallery main page. That displays a shitload of debug messages at the end of the page. In my case, I saw the familiar MySQL message about a table being corrupted. This time, it was g2_CacheMap. I did a quick repair table g2_CacheMap in mysql, and voila!, Gallery is back up.

I recently kicked up the upload_max_filesize parameter to 16MB so I could upload big 7MP images. However, now I’ve taken to shooting incriminating video with my Z750, which gets into the hundreds of megabytes. So, how big is too big? I’m going to try 500MB.

In /usr/local/etc/php.ini:

; Maximum allowed size for uploaded files.
upload_max_filesize = 512M

Let’s see what happens…

UPDATE: Nothing happened. The latest beta of Gallery Remote seems to not care for enormous video files; it just hangs at ‘Preparing to upload…’ indefinitely.

When I upload large files to Gallery (meaning roughly > 2MB) from Gallery Remote I get an upload error. Upon checking @/var/log/httpd-error.log@, I see: bq. @PHP Warning: POST Content-Length of 8503267 bytes exceeds the limit of 8388608 bytes@ In @/usr/local/etc/php.ini@ there's this line:

  ; Maximum size of POST data that PHP will accept.
  post_max_size = 8M

8M seems plenty, but apparently there's a helluva lot of overhead associated with uploading an image. I'll double it, to 16M:

  ; Maximum size of POST data that PHP will accept.
  post_max_size = 16M

I installed the new Gallery Remote 1.5 on Prospertine, so I could upload some pictures. When I was researching the upgrade to Gallery 2 that Gallery Remote 1.5 was alot faster if you install the latest ImageMagick on the client, so it can pre-process some of the image stuff.