• Changelog
• Debian-Howto
• Debian-Howto-Lenny
• EnableFriendlyUserUrls
• OpenSUSE-Howto
• Phpfspot
• Screenshots

Changelog¶

• Version 1.7
  • feature, F-Spot photo versioning, #67, #76
  • bug, display warning when requesting invalid image size, #74
  • bug, fix error logging to file, #80
  • bug, get_random_tag_photo() now takes care of show_tags parameter, 81
  • bug, get newer PDO style working with phpfspot, #109
  • bug, avoid some notice messages, #179
  • devel, make calendar layer better readable, #78
  • devel, add option to control photo path-substitution, #180

• Version 1.6
  • bug, sort-by rates if all photos of the library are displayed works now.
  • bug, phpfspot used the image files last modification date instead of F-Spot's
    recorded date when no EXIF data were available. Now it displays the same time as
    F-Spot does.
  • feature, date-input appears now as one field instead of seperates for year, month
    and day.
  • feature, make sort-order pre-configurable in phpfspot_cfg.php

• Version 1.5
  • feature, user-friendly URL's (with Apache's mod_rewrite).
  • feature, display tag-selection with preview-icons in photo index.
  • feature, support for Nikon's NEF RAW photo format (via dcraw and ImageMagick).
  • feature, auto-scroll in photo index if thumbnails are out of sight.
  • feature, support F-Spot's rating values.
  • bug, if tag added to hide-tags, don't show up in photo-details box (single-photo).
  • bug, if tag added to hide-tags, don't allow adding to selected-tags list.
  • bug, if tag added to hide-tags, random-photo needs to take care of it.
  • bug, auto-completition seemed not to work on all browser's caused by an   in
    a JavaScript URL.
  • bug, file-name-search can now be combined with any other search and will no longer
    produce SQL errors.

• Version 1.4
  • feature, support PNG image format.
  • feature, auto-completion for tag-search.
  • feature, lightbox2 for photo preview out of the photo index.
  • feature, a bit more color for tag-cloud.
  • bug, SQlite temporary directory can now be set in phpfspot_cfg.php
  • bug, modify AJAX-loading notification. Standard HTML_AJAX is getting overlayed.

• Version 1.3
  • bug, fixed auto-rotation when EXIF Orientation header is set.
  • bug, fixed incorrect time-range when using external-url to enter phpfspot.
  • bug, display also photos which have no tags. * bug, sometimes photos where displayed several times.
  • bug, fixed image handling which were slender enough, but too high.
  • bug, fix for PDO sqlite when trying to fetch one single row (contributed by
  • bug, fix for incorrect SQL query (contributed by Arun Persaud).
  • bug, fixed window-movement when switching between photo index & photo
  • feature, removed much of HTML tables to speed up GUI & CSS cleanup
  • feature, key navigation (next/prev photo, photo index, reset all).
  • feature, gen_thumbs.php has a new overwrite-thumbnails option.
  • feature, max. thumb height can now be changed in config settings.
    Arun Persaud).
  • feature, new sort order which will group photos by tag-names (alphabetical).
  • feature, simplified config file by moving config-check out to the main class file.
  • feature, script to search for duplicated photos via comparing MD5 hash sums.
  • feature, search for filename's and through photo descriptions.
  • feature, zooming
  • feature, new icon's from the Nuovo icon set.

• Version 1.2
  • Show only user-definied tags and pictures (contributed by Arun Persaud).
  • handling introduced database layout of F-Spot 0.4.x
  • cleaning up code to avoid PHP warning messages on E_ALL

• Version 1.1
  • new thumbnail directory strcuture inspired by GIT's directory structure (contributed by Arun Persaud).
  • support for RSS feed (v2.0)
  • support for PHP5's PDO (PHP Data Objects) to access sqlite3 database (contributed by Arun Persaud).
  • additional configurable options
    - Path to smarty
    - Path to store thumbnails

• Version 1.0

Initial release

Debian GNU/Linux (etch) - phpfspot Install Howto¶

1. Install the necessary requirements

sudo apt-get install sqlite3 
sudo apt-get install apache2 
sudo apt-get install php5-cli libapache2-mod-php5 php5-sqlite3 php5-gd php-pear smarty
sudo /etc/init.d/apache2 restart

sudo pear upgrade-all (be careful! perhaps other applications on your server don't like newer pear package versions)
sudo pear install "channel://pear.php.net/Calendar-0.5.3" 
sudo pear install "channel://pear.php.net/HTML_AJAX-0.5.2" 
sudo pear install Date

2. Extract the phpfspot tarball below the webservers document root (defaults to /var/www)

cd /var/www
sudo tar zxf /home/admin/phpfspot-x.x.tar.gz
sudo ln -s phpfspot-x.x phpfspot
cd phpfspot

3. Configure phpfspot

sudo cp -a phpfspot_cfg.php.dist phpfspot_cfg.php
sudoedit phpfspot_cfg.php -> read the comments

4. Create database directory and set some permissions

sudo mkdir /var/www/f-spot-dbs
sudo chown www-data.root /var/www/f-spot-dbs
sudo chown www-data.root /var/www/phpfspot/thumbs /var/www/phpfspot/templates_c

5. Copy F-Spot photo directory to the webserver

scp -r ~/Photos someuser@somehost:/var/www/
sudo chgrp www-data /var/www/Photos

6. Copy F-Spot sqlite database to the webserver

scp ~/.gnome2/f-spot/photos.db someuser@somehost:/var/www/f-spot-dbs/

7. Pre-create thumbnails

cd /var/www/phpfspot
"./gen_thumbs.php" or "php gen_thumbs.php" 

Hopefully all works now.

PHP5 ImageMagick Support via PECL module:

sudo aptitude install libgraphicsmagick1-dev libmagick9-dev
sudo pecl install imagic

extension=imagick.so

Debian GNU/Linux (Lenny) - phpfspot Install Howto¶

1. Install the necessary requirements

sudo apt-get install sqlite3 
sudo apt-get install apache2 
sudo apt-get install php5-cli libapache2-mod-php5 php5-gd php5-sqlite php-pear smarty
sudo /etc/init.d/apache2 restart

sudo pear upgrade-all (be careful! perhaps other applications on your server don't like newer pear package versions)
sudo pear install Calendar (if package still in beta state, use "sudo pear install channel://pear.php.net/Calendar-0.x.x" - replace the version pear points out)
sudo pear install HTML_AJAX (if package still in beta state, use "sudo pear install channel://pear.php.net/HTML_AJAX-0.x.x" - replace the version pear points out)
sudo pear install Date

2. Extract the phpfspot tarball below the webservers document root (defaults to /var/www)

cd /var/www
sudo tar zxf /home/admin/phpfspot-x.x.tar.gz
sudo ln -s phpfspot-x.x phpfspot
cd phpfspot

3. Configure phpfspot

sudo cp -a phpfspot_cfg.php.dist phpfspot_cfg.php
sudoedit phpfspot_cfg.php -> read the comments

4. Create database directory and set some permissions

sudo mkdir /var/www/f-spot-dbs
sudo chown www-data.root /var/www/f-spot-dbs
sudo chown www-data.root /var/www/phpfspot/thumbs /var/www/phpfspot/templates_c

5. Copy F-Spot photo directory to the webserver

scp -r ~/Photos someuser@somehost:/var/www/
sudo chgrp www-data /var/www/Photos

6. Copy F-Spot sqlite database to the webserver

scp ~/.gnome2/f-spot/photos.db someuser@somehost:/var/www/f-spot-dbs/

7. Pre-create thumbnails

cd /var/www/phpfspot
"./gen_thumbs.php" or "php gen_thumbs.php" 

Hopefully all works now.

PHP5 ImageMagick Support via PECL module:

sudo aptitude install libgraphicsmagick1-dev libmagick9-dev
sudo pecl install imagic

extension=imagick.so

EnableFriendlyUserUrls¶

Supporting user-friendly URL's¶

If you want to share links to photos or tags, you can use more beautiful links instead of "index.php?blabla". All you need is your Apache webserver supporting mod_rewrite. Look around in the web - there a plenty enough howto's around, howto enable it.

1. Add the following to your Apache configuration (mod_rewrite module need to be loaded). Also addept here the path to your phpfspot installation.

RewriteEngine On
RewriteRule ^/photoview/(.*)$ /var/www/phpfspot/index.php/$1
RewriteRule ^/photo/(.*)$ /var/www/phpfspot/index.php/$1
RewriteRule ^/tag/(.*)$ /var/www/phpfspot/index.php/$1

2. in phpfspot_cfg.php, set the parameter $user_friendly_url to "true"
3. now you can address phpfspot like this

• display single-photo view, latest version

/photoview/{id-of-photo}

• display photo in original width, latest photo version

/photo/{id-of-photo}

• display photo in requested width, latest photo version

/photo/{id-of-photo}/{width}

• display photo in requested width for requested photo version

/photo/{id-of-photo}/{width}/{version-id}

• photo-index of the specified tag (id) - a specific page can be selected by {page}

/tag/{id}/{page}

OpenSuse 10.3 - phpfspot Install Howto¶

I followed and 'translated' the Debian Install Howto (http://oss.netshadow.at/wiki/phpfspot/Debian-Howto), but given the differences between distributions, things are just a little bit otherwise arranged. There is also a very detailed manual in http://www.linux.com/feature/133156 (Bringing your photos from F-Spot to the web, by Ben Martin). He mentions Ubuntu and OpenSuse.
The basic setup is always the same, however.

Install the necessary requirements¶

Assuming you are about to place phpfspot on a working site with apache2
The first point is to install the following prerequisites and dependencies:

1. php5
2. apache2
3. python

2.Yast (install Packman-repo before)

1. php5-gd
2. php-pear

3.from php.net

1. libapache2-mod-php5
2. php5-sqlite3
3. php5-cli
4. smarty

After this, you do

1. rcapache2 restart
2. pear upgrade-all
3. pear install "channel://pear.php.net/Calendar-0.5.3"
4. pear install "channel://pear.php.net/HTML_AJAX-0.5.2"
5. pear install Date

2. Extract the phpfspot tarball below the webservers document root (defaults to /srv/www/htdocs)¶

cd /var/www
tar zxf /home/admin/phpfspot-x.x.tar.gz
ln -s phpfspot-x.x phpfspot
cd phpfspot

3. Configure phpfspot¶

cp -a phpfspot_cfg.php.dist phpfspot_cfg.php
edit (with kwrite or gedit or vi,...) phpfspot_cfg.php -> read the comments

4. Create database directory and set some permissions¶

mkdir /var/www/f-spot-dbs
chown wwwrun.root /var/www/f-spot-dbs
sudo chown wwwrun.root /var/www/phpfspot/thumbs /var/www/phpfspot/templates_c

5. Copy F-Spot photo directory to the webserver¶

scp -r ~/Photos someuser@somehost:/var/www/
sudo chown -R .www /var/www/Photos

6. Copy F-Spot sqlite database to the webserver¶

scp ~/.gnome2/f-spot/photos.db someuser@somehost:/var/www/f-spot-dbs/

7. Pre-create thumbnails¶

cd /var/www/phpfspot
"./gen_thumbs.php" or "php gen_thumbs.php"

This is necessary, because otherwise phpfspot will take a long time presenting the thumbnails.

Synchronizing the photo files¶

The main problem for me was to synchronize the photo databases with F-Spot, especially because phpfspot resides on a different site than the computer with F-spot. The best way to do this was using rsync, with maintaining the permissions of the target files (with the --chmod switch --chmod=Dg+ws,Fg+wr).

phpfspot¶

• phpfspot
• Download
• Features
• Demo and Screenshots
• Requirements
• Get involved
• Mailinglist
• Reviews
• Users
• I want to get the lastest development trunk!
• Some tips
• Links
• Installation
• Debian
• OpenSuSE
• Further configuration hints

phpfspot brings you F-Spot album online. The PHP-based application handles the sqlite3 database of F-Spot and displays tags, EXIF informations (for JPEG photo's), ...

Download¶

The current stable release is 1.7 (Changelog). See Files if you want to download it.

Features¶

• publish your F-Spot photo collection in the web
• AJAX-based web-interface
• Tag-Cloud
• RSS XML export
• auto-rotation based on EXIF Orientation header in the photo
• Slideshow
• Works well with Firefox, Safari, Epiphany, Opera and IE
• Support of Nikon's NEF format (via dcraw)

Demo and Screenshots¶

A simple Demo-installation with some wallpapers from kdelook.org can be found at:

http://oss.netshadow.at/phpfspot/

Screenshots has some pictures of a running phpfspot installation.

Requirements¶

• apache2
• php5
  o gd2-extension2
  o sqlite3-extensions [or also as PDO driver]
  o PEAR module Calendar
  o PEAR module HTML_AJAX (version >= 0.5.6 suggested which supports Opera)
• sqlite3

Get involved¶

Mailinglist¶

Installation issues, ideas, feature requests, ... post to the mailing list which can be found at

phpfspot@netshadow.at

Do not forget! Before posting to this list you need to subscribe either via sending an empty email to phpfspot-subscribe@netshadow.at or visit https://admin.netshadow.at/mailman/listinfo/phpfspot/.

Reviews¶

• http://lefant.net/logposts/2007-07-22---phpfspot/ by Fabian
• http://www.linux.com/feature/133156 by Ben Martin

Users¶

• http://images.netshadow.at/
• http://gallery.lefant.net/

I want to get the lastest development trunk!¶

You can check it out of the GIT repository via:

git clone http://git.netshadow.at/phpfspot.git/

Some tips¶

• Convert NEF (Nikon RAW format) to JPEG with EXIF meta-data - http://www.howtofixcomputers.com/forums/digital-photo/my-humble-contribution-wrapper-script-dcraw-linux-4360.html

Links¶

• roundup - issue tracking until 21st of June 2008.
• freshmeat.net project page
• PennAve - similar implementation with python written by Patrick Wagstrom

Installation¶

A general install description is bundled with each release - see INSTALL file.

Debian¶

phpfspot was develeoped under Debian GNU/Linux.

• Debian-Howto for Etch by Fabian
• Debian-Howto-Lenny for Lenny by Unki

OpenSuSE¶

see this OpenSUSE-Howto

Further configuration hints¶

phpfspot supports EnableFriendlyUserUrls.

Screenshots¶