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

http://www.zoneminder.com/wiki/index.php/Documentation#Filtering_Events
%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

    Janice's computer crashes

    The first crash was DRIVER_IRQL_NOT_LESS_OR_EQUAL which resulted in a STOP 0x000000D1. The
    error was in VIDEOPRT.SYS. Search turns up nothing specific, but an upgrade of video drivers may be the answer.
    The second crash was a STOP 0x0000008E in WIN32K.SYS. Search turns up this: http://support.microsoft.com/kb/834450
    The third crash is DRIVER_IRQL_NOT_LESS_OR_EQUAL which resulted in a STOP 0x0000000A
    The fourth crash is again DRIVER_IRQL_NOT_LESS_OR_EQUAL which resulted in a STOP 0x000000D1 VIDEOPRT.SYS.
    Another STOP 0x0000008E!!!

    Spill Checker

    I have a spelling checker
    It came with my PC.
    It plane lee marks four my revue
    Miss steaks aye can knot sea.

    Eye ran this poem threw it,
    Your sure reel glad two no.
    Its vary polished in it's weigh,
    My checker tolled me sew.

    A checker is a bless sing,
    It freeze yew lodes of thyme.
    It helps me right awl stiles two reed,
    And aides me when aye rime.

    To rite with care is quite a feet
    Of witch won should be proud.
    And wee mussed dew the best wee can,
    Sew flaws are knot aloud.

    And now bee cause my spelling
    Is checked with such grate flare,