Last Thursday’s Greater New Hampshire Linux Users Group topic was “SELinux for Dummies” by Red Hat’s Dan Walsh. I took some notes but had to leave at 9pm and they were still going strong. See http://nozell.dyndns.org/wiki/index.php/SELinuxForDummies
Archive for July, 2006
It has been almost 24 hours that email has been down at the hosting company netnation.com — the tech support guy said they are using some in-house mail package (CSR?) and it should be fixed by *tomorrow*! Ugh.
Yesterday the Audubon Society/NH hosted a Dragonfly walking tour of Amherst’s Ponemah Bog. There are a ton of dragonflies (which eat all the pest insects) as well as carnivorous plants like the pitcher and sundew plants.
Next weekend (22-Jul-2006) they are having another dragonfly walk (10am) and this time I’m going to drag some of the kids along. Be sure to wear shoes you don’t mind getting soaked.
For directions to Ponemah Bog (amazingly close to 101A), see ASNH Ponemah Bog Sanctuary
Here is the complete photoset: Dragonfly Walk @ Ponemah Bog (Amherst, NH)
I’ve been using f-spot since it showed up in Ubuntu/Breezy and have been keeping all my photos in a directory structure like this:
But sometimes I’ve forgotten to unclick the “Copy file to the Photos folder” box in the photos import dialog and end up with photos under ~/Photos/. Recently I checked and found there were almost a gigabytes worth of photos under there.
So this is what I did to move them to under /PHOTOS/Photos/ and keep all the tags and metadata correct.
- Back up /home and /PHOTOS to an external USB. I love rsnapshot.
$ rsnapshot daily
- make an extra backup of the f-spot database
$ cp ~/.gnome2/f-spot/photos.db photos-backup.db
- Start poking around the f-spot database and updating it.
$ sqlite3 ~/.gnome2/f-spot/photos.db
sqlite> .schema photos
CREATE TABLE photos ( id INTEGER PRIMARY KEY NOT NULL,
time INTEGER NOT NULL,
directory_path STRING NOT NULL,
name STRING NOT NULL,
description TEXT NOT NULL,
default_version_id INTEGER NOT NULL
- See how many photos are in ~/Photos…
sqlite> select count(*) from photos where directory_path like '/home/marc/Photos/%';
- Take a look at a few of them to see the path names…
sqlite> select directory_path from photos where directory_path like '/home/marc/Photos/%' limit 0,10;
- Update the pathname to my prefered one. I’ve added an ‘a’ to the end just so I won’t overwrite an existing directory.
sqlite> update photos set directory_path = "/PHOTOS/Photos/2006.06.22a" where directory_path = "/home/marc/Photos/2006/6/22";
- Make the directory and move the files to the new location…
mv -v /home/marc/Photos/2006/6/22/HPIM117* /PHOTOS/Photos/2006.06.22a
Repeat for each directory. I did it all within emacs’ shell so cut-n-paste made it a snap.