dd-wrt fix for NAT loopback

Go to Administration > Commands
Put the following code in the Commands window:

insmod ipt_mark
insmod xt_mark
iptables -t mangle -A PREROUTING -i ! `get_wanface` -d `nvram get wan_ipaddr` -j MARK --set-mark 0xd001
iptables -t nat -A POSTROUTING -m mark --mark 0xd001 -j MASQUERADE

Click [Save Firewall]

SheevaPlug recovery, preparation and wview install

Format and setup the SD card:
dd if=Kingston-4G-NewIT-v1.0-debian-squeeze.img of=/dev/sdg bs=1024k

See if it's OK (fdisk -l /dev/sdg)

Now try to boot the plug.

ssh into it root@xxx.xxx.xxx.xxx

Edit /etc/hostname to change the host name.
Edit /etc/hosts to change which host name is localhost.
Check that /etc/network/interfaces is correct (eth0 gets its address via DHCP)
Change the password by running passwd

Set the date!

$ sudo apt-get update

wview data recovery

This page shows how I edited my wview archive database to patch in data values that were NULL when my Vpro2 sensors battery went dead in the middle of the night.

Become root.
Stop wview!

root@wview:~# sudo /usr/bin/service wview stop
Shutting down wview daemons...

Make a backup of the database

root@wview:~# cd /usr/local/var/wview/archive # /var/lib/wview/archive if installed using apt
root@wview:~# sqlite3 wview-archive.sdb .dump | sqlite3 archive-backup.sdb
root@wview:~# mv archive_backup.sdb /tmp

zoneminder email variables

%EI% Id of the event
%EN% Name of the event
%EC% Cause of the event
%ED% Event description
%ET% Time of the event
%EL% Length of the event
%EF% Number of frames in the event
%EFA% Number of alarm frames in the event
%EST% Total score of the event
%ESA% Average score of the event
%ESM% Maximum score of the event
%EP% Path to the event
%EPS% Path to the event stream
%EPI% Path to the event images

Blue Diamonds potential songs

Here are some ideas for songs to add to our repertoire:

  • Aerosmith, Dulcimer Stomp (The Other Side)
  • U2, Angel of Harlem (fits after Cantaloupe Island)
  • **Tower of Power's version of "Since You've Been Gone" (that was also done by Aretha Franklin
  • Glenn Frey, The Heat is On
  • Huey Lewis and the News: It's All Right
  • *Percy Sledge version of "Spooky"
  • Unchain my Heart, done by Ray Charles and Joe Cocker
  • Feelin' All Right, Joe Cocker
  • Mr. Big Stuff, Jean Knight
  • Let's Stay Together, Al Green (nice ballad)
  • MAC addresses

    ? 10:00:41:20:00:32
    ranchero 40:61:86:e9:81:d6
    fairlane 00:16:E6:D6:84:86
    jetfire 04:4B:80:80:80:03
    wview 00:50:43:01:C7:D3
    ionian 00:10:C6:80:5D:26
    valiant 00:18:E7:17:DC:F0
    Hornet 00:1A:92:7C:0C:1C
    dorian 00:0D:4B:05:02:36
    tempest 48:5B:39:02:5D:F9
    spyder 00:24:23:18:13:BD