User:Trogod/System0Upgrade12042

From MythTV Official Wiki
< User:Trogod
Revision as of 19:32, 1 March 2014 by Trogod (talk | contribs) (Back to Wired Ethernet)

Jump to: navigation, search

On 5 April 2013 (Friday) I tried to allow Ubuntu's Update Manager to do some updates, but it failed in the middle and left my system unusable. When I tried to reboot, I got a kernel panic :( I decided that it was easier to upgrade fresh than to repair what I had. Unfortunately, that means accepting potential losses due to a stale backup!

download iso

I downloaded =mythbuntu-12.04.2-desktop-amd64.iso= and burned it to a DVD using Mac OS X's Disk Utility

jfs

$ sudo parted -l
Model: ATA SAMSUNG HD204UI (scsi)
Disk /dev/sda: 2000GB
Sector size (logical/physical): 512B/512B
Partition Table: gpt

Number  Start   End     Size    File system  Name  Flags
 1      1049kB  2000GB  2000GB  jfs


Model: ATA SAMSUNG SP0822N (scsi)
Disk /dev/sdb: 80.1GB
Sector size (logical/physical): 512B/512B
Partition Table: msdos

Number  Start   End     Size    Type     File system     Flags
 1      32.3kB  1287MB  1287MB  primary  ext2            boot
 2      1287MB  10.3GB  9052MB  primary  linux-swap(v1)
 3      10.3GB  26.5GB  16.1GB  primary  ext3
 4      26.5GB  47.9GB  21.5GB  primary  ext3

$ time sudo fsck.jfs -f /dev/sda1
fsck.jfs version 1.1.15, 04-Mar-2011
processing started: 4/7/2013 1:09:29
The current device is:  /dev/sda1
Block size in bytes:  4096
Filesystem size in blocks:  488378368
**Phase 0 - Replay Journal Log
**Phase 1 - Check Blocks, Files/Directories, and  Directory Entries
**Phase 2 - Count links
Incorrect link counts have been detected. Will correct.
**Phase 3 - Duplicate Block Rescan and Directory Connectedness
**Phase 4 - Report Problems
File system object DF419904 is linked as: /backups/weekly/home/troy/.mythtv/themecache/Mythbuntu.1920.1080
cannot repair the data format error(s) in this directory.
cannot repair DF419904.  Will release.
File system object DF682890 is linked as: /backups/past-weekly/home/troy/.mythtv/themecache/Mythbuntu.1920.1080
cannot repair the data format error(s) in this directory.
cannot repair DF682890.  Will release.
File system object DF751736 is linked as: /backups/daily/home/troy/.mythtv/themecache/Mythbuntu.1920.1080
cannot repair the data format error(s) in this directory.
cannot repair DF751736.  Will release.
**Phase 5 - Check Connectivity
**Phase 6 - Perform Approved Corrections
3 directories reconnected to /lost+found/.
8863 files reconnected to /lost+found/.
**Phase 7 - Rebuild File/Directory Allocation Maps
**Phase 8 - Rebuild Disk Allocation Maps
1953513472 kilobytes total disk space.
   386331 kilobytes in 176239 directories.
1900126741 kilobytes in 1105010 user files.
   100196 kilobytes in extended attributes
  1192154 kilobytes reserved for system use.
 52480712 kilobytes are available for use.
Filesystem is clean.
|........
real	5m24.350s
user	0m5.988s
sys	0m4.488s


HDHomeRun Networking

before any changes:

$ cat /etc/network/interfaces 
auto lo
iface lo inet loopback

$ ifconfig -a
eth0      Link encap:Ethernet  HWaddr 00:24:1d:1d:8d:24  
          inet6 addr: fe80::224:1dff:fe1d:8d24/64 Scope:Link
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:21 errors:0 dropped:0 overruns:0 frame:0
          TX packets:500 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000 
          RX bytes:7182 (7.1 KB)  TX bytes:109644 (109.6 KB)

lo        Link encap:Local Loopback  
          inet addr:127.0.0.1  Mask:255.0.0.0
          inet6 addr: ::1/128 Scope:Host
          UP LOOPBACK RUNNING  MTU:16436  Metric:1
          RX packets:1844 errors:0 dropped:0 overruns:0 frame:0
          TX packets:1844 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:0 
          RX bytes:163739 (163.7 KB)  TX bytes:163739 (163.7 KB)

wlan0     Link encap:Ethernet  HWaddr 00:0d:0a:00:1e:df  
          inet addr:192.168.1.55  Bcast:192.168.1.255  Mask:255.255.255.0
          inet6 addr: fe80::20d:aff:fe00:1edf/64 Scope:Link
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:7956 errors:0 dropped:0 overruns:0 frame:0
          TX packets:6489 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000 
          RX bytes:6665698 (6.6 MB)  TX bytes:957533 (957.5 KB)

I re-implemented what I previously did

$ diff --unified=6 interfaces-orig interfaces
--- interfaces-orig	2013-04-06 21:35:40.000000000 -0700
+++ interfaces	2013-04-07 01:16:30.000000000 -0700
@@ -1,3 +1,8 @@
 auto lo
 iface lo inet loopback
 
+auto eth0
+iface eth0 inet static
+address 169.254.1.5
+netmask 255.255.0.0
+
$ sudo /etc/init.d/networking restart
 * Running /etc/init.d/networking restart is deprecated because it may not enable again some interfaces
 * Reconfiguring network interfaces...                                          ssh stop/waiting
ssh start/running, process 3573
                                                                         [ OK ]
$ ifconfig -a
eth0      Link encap:Ethernet  HWaddr 00:24:1d:1d:8d:24  
          inet6 addr: fe80::224:1dff:fe1d:8d24/64 Scope:Link
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:25 errors:0 dropped:0 overruns:0 frame:0
          TX packets:618 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000 
          RX bytes:8550 (8.5 KB)  TX bytes:135664 (135.6 KB)

lo        Link encap:Local Loopback  
          inet addr:127.0.0.1  Mask:255.0.0.0
          inet6 addr: ::1/128 Scope:Host
          UP LOOPBACK RUNNING  MTU:16436  Metric:1
          RX packets:2091 errors:0 dropped:0 overruns:0 frame:0
          TX packets:2091 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:0 
          RX bytes:182995 (182.9 KB)  TX bytes:182995 (182.9 KB)

wlan0     Link encap:Ethernet  HWaddr 00:0d:0a:00:1e:df  
          inet addr:192.168.1.55  Bcast:192.168.1.255  Mask:255.255.255.0
          inet6 addr: fe80::20d:aff:fe00:1edf/64 Scope:Link
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:8541 errors:0 dropped:0 overruns:0 frame:0
          TX packets:6944 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000 
          RX bytes:6753659 (6.7 MB)  TX bytes:1028865 (1.0 MB)

$ hdhomerun_config discover
no devices found

Well, that didn't work like I hoped it would! This will take a little more work :(


mount /storage

re-implemented my previous change...

$ diff --unified=2 /etc/fstab-orig /etc/fstab
--- /etc/fstab-orig	2013-04-06 22:23:50.000000000 -0700
+++ /etc/fstab	2013-04-07 01:24:36.000000000 -0700
@@ -15,2 +15,5 @@
 # swap was on /dev/sda2 during installation
 UUID=25f8fb9e-d2f9-4297-a7ec-7dbff4729eb0 none            swap    sw              0       0
+# manually added 7 April 2013 by TDG
+UUID=d70970b0-e22c-47ae-a9e0-5d9c637aa073  /storage       jfs     defaults        0       2 
+ 

and then rebooted and now I can see =/storage= yay!

HDHomeRun redeemed

after the reboot for /storage, I check on my HDHomeRun

$ hdhomerun_config discover
hdhomerun device 10172423 found at 169.254.108.179

so that's working, too. nice! :)

$ ifconfig -a
eth0      Link encap:Ethernet  HWaddr 00:24:1d:1d:8d:24  
          inet addr:169.254.1.5  Bcast:169.254.255.255  Mask:255.255.0.0
          inet6 addr: fe80::224:1dff:fe1d:8d24/64 Scope:Link
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:47118 errors:0 dropped:0 overruns:0 frame:0
          TX packets:1217 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000 
          RX bytes:63841396 (63.8 MB)  TX bytes:125775 (125.7 KB)

lo        Link encap:Local Loopback  
          inet addr:127.0.0.1  Mask:255.0.0.0
          inet6 addr: ::1/128 Scope:Host
          UP LOOPBACK RUNNING  MTU:16436  Metric:1
          RX packets:9223 errors:0 dropped:0 overruns:0 frame:0
          TX packets:9223 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:0 
          RX bytes:4164295 (4.1 MB)  TX bytes:4164295 (4.1 MB)

wlan0     Link encap:Ethernet  HWaddr 00:0d:0a:00:1e:df  
          inet addr:192.168.1.55  Bcast:192.168.1.255  Mask:255.255.255.0
          inet6 addr: fe80::20d:aff:fe00:1edf/64 Scope:Link
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:4936 errors:0 dropped:0 overruns:0 frame:0
          TX packets:3609 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000 
          RX bytes:4474566 (4.4 MB)  TX bytes:445048 (445.0 KB)

my home directory

$ cd /storage/backups/daily/home/xxx/
$ ls -F
Desktop/          foo/              mythconverg_backup.pl*   ralink.txt
Documents/        lirc-bak2.tar.gz  mythconverg_restore.pl*  Templates/
Downloads/        lirc-bak.tar.gz   Pictures/                Videos/
find_orphans.py*  Music/            Public/
$ cp -pr lirc-bak* find_orphans.py mythconverg_* ralink.txt ~/.

I discovered that a different backup seems to have a better record

$ cd /home
$ tar cvzf /tmp/xxx-newhome.tar.gz xxx/
$ pushd /storage/backups/weekly/home/xxx/
$ cp -pr lirc-bak* find_orphans.py mythconverg_* play* r* transcode.txt bin ~/.
$ cp -pr .lirc .lirc2 .lircrc .mythtv/ ~/.
$ cp -pr dev ~/.

restore database

$ cp -pr /storage/backups/daily/home/xxx/.mythtv/backuprc ~/.mythtv/.
$ ls -aF ~/.mythtv/
./   3rdParty/  Cache-mythfrontend-myth-bob/  config.xml  mysql.txt@   themes/
../  backuprc   channels/                     lircrc@     themecache/  tmp/

looking for latest and greatest database.

$ ls -Ftl /storage/backups/myth/ | head
total 2954044
-rw-r--r-- 1 root root        0 Apr  5 07:53 mythconverg-20130405075321.sql
-rw-r--r-- 1 root root        0 Apr  4 08:05 mythconverg-20130404080512.sql
-rw-r--r-- 1 root root        0 Apr  3 07:42 mythconverg-20130403074241.sql
-rw-r--r-- 1 root root        0 Apr  2 07:54 mythconverg-20130402075403.sql
-rw-r--r-- 1 root root        0 Apr  1 07:47 mythconverg-20130401074728.sql
-rw-r--r-- 1 root root        0 Mar 31 08:14 mythconverg-090-13.sql
-rw-r--r-- 1 root root        0 Mar 31 08:07 mythconverg-20130331080755.sql
-rw-r--r-- 1 root root        0 Mar 30 08:02 mythconverg-20130330080241.sql
-rw-r--r-- 1 root root        0 Mar 29 07:57 mythconverg-20130329075744.sql
$ ls -Ftl /storage/backups/myth/ | grep -A 3 -B 3 03210
-rw-r--r-- 1 root root        0 Mar 24 07:54 mythconverg-20130324075428.sql
-rw-r--r-- 1 root root        0 Mar 23 07:49 mythconverg-20130323074944.sql
-rw-r--r-- 1 root root        0 Mar 22 07:29 mythconverg-20130322072925.sql
-rw-r--r-- 1 root root 29810417 Mar 21 08:00 mythconverg-1299-20130321075954.sql.gz
-rw-r--r-- 1 root root 29707861 Mar 20 07:44 mythconverg-1299-20130320074341.sql.gz
-rw-r--r-- 1 root root 29566161 Mar 19 08:08 mythconverg-1299-20130319080738.sql.gz
-rw-r--r-- 1 root root 29147474 Mar 18 07:42 mythconverg-1299-20130318074211.sql.gz

so, my last good backup appears to be Mar 21!!! :(

$ sudo gunzip /storage/backups/myth/mythconverg-1299-20130321075954.sql.gz
$ ./mythconverg_restore.pl --drop_database --create_database --filename mythconverg-1299-20130321075954.sql

Successfully restored backup.
$ /usr/share/doc/mythtv-backend/contrib/maintenance/optimize_mythdb.pl 
Repaired/Optimized: `mythconverg`.`archiveitems`
Analyzed: `mythconverg`.`archiveitems`
Repaired/Optimized: `mythconverg`.`callsignnetworkmap`
Analyzed: `mythconverg`.`callsignnetworkmap`
Repaired/Optimized: `mythconverg`.`capturecard`
Analyzed: `mythconverg`.`capturecard`
Repaired/Optimized: `mythconverg`.`cardinput`
Analyzed: `mythconverg`.`cardinput`
Repaired/Optimized: `mythconverg`.`channel`
Analyzed: `mythconverg`.`channel`
Repaired/Optimized: `mythconverg`.`channelgroup`
Analyzed: `mythconverg`.`channelgroup`
Repaired/Optimized: `mythconverg`.`channelgroupnames`
Analyzed: `mythconverg`.`channelgroupnames`
Repaired/Optimized: `mythconverg`.`channelscan`
Analyzed: `mythconverg`.`channelscan`
Repaired/Optimized: `mythconverg`.`channelscan_channel`
Analyzed: `mythconverg`.`channelscan_channel`
Repaired/Optimized: `mythconverg`.`channelscan_dtv_multiplex`
Analyzed: `mythconverg`.`channelscan_dtv_multiplex`
Repaired/Optimized: `mythconverg`.`codecparams`
Analyzed: `mythconverg`.`codecparams`
Repaired/Optimized: `mythconverg`.`credits`
Analyzed: `mythconverg`.`credits`
Repaired/Optimized: `mythconverg`.`customexample`
Analyzed: `mythconverg`.`customexample`
Repaired/Optimized: `mythconverg`.`diseqc_config`
Analyzed: `mythconverg`.`diseqc_config`
Repaired/Optimized: `mythconverg`.`diseqc_tree`
Analyzed: `mythconverg`.`diseqc_tree`
Repaired/Optimized: `mythconverg`.`displayprofilegroups`
Analyzed: `mythconverg`.`displayprofilegroups`
Repaired/Optimized: `mythconverg`.`displayprofiles`
Analyzed: `mythconverg`.`displayprofiles`
Repaired/Optimized: `mythconverg`.`dtv_multiplex`
Analyzed: `mythconverg`.`dtv_multiplex`
Repaired/Optimized: `mythconverg`.`dtv_privatetypes`
Analyzed: `mythconverg`.`dtv_privatetypes`
Repaired/Optimized: `mythconverg`.`dvdbookmark`
Analyzed: `mythconverg`.`dvdbookmark`
Repaired/Optimized: `mythconverg`.`dvdinput`
Analyzed: `mythconverg`.`dvdinput`
Repaired/Optimized: `mythconverg`.`dvdtranscode`
Analyzed: `mythconverg`.`dvdtranscode`
Repaired/Optimized: `mythconverg`.`eit_cache`
Analyzed: `mythconverg`.`eit_cache`
Repaired/Optimized: `mythconverg`.`filemarkup`
Analyzed: `mythconverg`.`filemarkup`
Repaired/Optimized: `mythconverg`.`gallerymetadata`
Analyzed: `mythconverg`.`gallerymetadata`
Repaired/Optimized: `mythconverg`.`gamemetadata`
Analyzed: `mythconverg`.`gamemetadata`
Repaired/Optimized: `mythconverg`.`gameplayers`
Analyzed: `mythconverg`.`gameplayers`
Repaired/Optimized: `mythconverg`.`housekeeping`
Analyzed: `mythconverg`.`housekeeping`
Repaired/Optimized: `mythconverg`.`inputgroup`
Analyzed: `mythconverg`.`inputgroup`
Repaired/Optimized: `mythconverg`.`internetcontent`
Analyzed: `mythconverg`.`internetcontent`
Repaired/Optimized: `mythconverg`.`internetcontentarticles`
Analyzed: `mythconverg`.`internetcontentarticles`
Repaired/Optimized: `mythconverg`.`inuseprograms`
Analyzed: `mythconverg`.`inuseprograms`
Repaired/Optimized: `mythconverg`.`jobqueue`
Analyzed: `mythconverg`.`jobqueue`
Repaired/Optimized: `mythconverg`.`jumppoints`
Analyzed: `mythconverg`.`jumppoints`
Repaired/Optimized: `mythconverg`.`keybindings`
Analyzed: `mythconverg`.`keybindings`
Repaired/Optimized: `mythconverg`.`keyword`
Analyzed: `mythconverg`.`keyword`
Repaired/Optimized: `mythconverg`.`livestream`
Analyzed: `mythconverg`.`livestream`
Repaired/Optimized: `mythconverg`.`logging`
Analyzed: `mythconverg`.`logging`
Repaired/Optimized: `mythconverg`.`movies_movies`
Analyzed: `mythconverg`.`movies_movies`
Repaired/Optimized: `mythconverg`.`movies_showtimes`
Analyzed: `mythconverg`.`movies_showtimes`
Repaired/Optimized: `mythconverg`.`movies_theaters`
Analyzed: `mythconverg`.`movies_theaters`
Repaired/Optimized: `mythconverg`.`music_albumart`
Analyzed: `mythconverg`.`music_albumart`
Repaired/Optimized: `mythconverg`.`music_albums`
Analyzed: `mythconverg`.`music_albums`
Repaired/Optimized: `mythconverg`.`music_artists`
Analyzed: `mythconverg`.`music_artists`
Repaired/Optimized: `mythconverg`.`music_directories`
Analyzed: `mythconverg`.`music_directories`
Repaired/Optimized: `mythconverg`.`music_genres`
Analyzed: `mythconverg`.`music_genres`
Repaired/Optimized: `mythconverg`.`music_playlists`
Analyzed: `mythconverg`.`music_playlists`
Repaired/Optimized: `mythconverg`.`music_smartplaylist_categories`
Analyzed: `mythconverg`.`music_smartplaylist_categories`
Repaired/Optimized: `mythconverg`.`music_smartplaylist_items`
Analyzed: `mythconverg`.`music_smartplaylist_items`
Repaired/Optimized: `mythconverg`.`music_smartplaylists`
Analyzed: `mythconverg`.`music_smartplaylists`
Repaired/Optimized: `mythconverg`.`music_songs`
Analyzed: `mythconverg`.`music_songs`
Repaired/Optimized: `mythconverg`.`music_stats`
Analyzed: `mythconverg`.`music_stats`
Repaired/Optimized: `mythconverg`.`mythlog`
Analyzed: `mythconverg`.`mythlog`
Repaired/Optimized: `mythconverg`.`mythnettv_archive`
Analyzed: `mythconverg`.`mythnettv_archive`
Repaired/Optimized: `mythconverg`.`mythnettv_category`
Analyzed: `mythconverg`.`mythnettv_category`
Repaired/Optimized: `mythconverg`.`mythnettv_group`
Analyzed: `mythconverg`.`mythnettv_group`
Repaired/Optimized: `mythconverg`.`mythnettv_log`
Analyzed: `mythconverg`.`mythnettv_log`
Repaired/Optimized: `mythconverg`.`mythnettv_programs`
Analyzed: `mythconverg`.`mythnettv_programs`
Repaired/Optimized: `mythconverg`.`mythnettv_proxies`
Analyzed: `mythconverg`.`mythnettv_proxies`
Repaired/Optimized: `mythconverg`.`mythnettv_proxy_usage`
Analyzed: `mythconverg`.`mythnettv_proxy_usage`
Repaired/Optimized: `mythconverg`.`mythnettv_settings`
Analyzed: `mythconverg`.`mythnettv_settings`
Repaired/Optimized: `mythconverg`.`mythnettv_subscriptions`
Analyzed: `mythconverg`.`mythnettv_subscriptions`
Repaired/Optimized: `mythconverg`.`mythweb_sessions`
Analyzed: `mythconverg`.`mythweb_sessions`
Repaired/Optimized: `mythconverg`.`networkiconmap`
Analyzed: `mythconverg`.`networkiconmap`
Repaired/Optimized: `mythconverg`.`oldfind`
Analyzed: `mythconverg`.`oldfind`
Repaired/Optimized: `mythconverg`.`oldprogram`
Analyzed: `mythconverg`.`oldprogram`
Repaired/Optimized: `mythconverg`.`oldrecorded`
Analyzed: `mythconverg`.`oldrecorded`
Repaired/Optimized: `mythconverg`.`people`
Analyzed: `mythconverg`.`people`
Repaired/Optimized: `mythconverg`.`phonecallhistory`
Analyzed: `mythconverg`.`phonecallhistory`
Repaired/Optimized: `mythconverg`.`phonedirectory`
Analyzed: `mythconverg`.`phonedirectory`
Repaired/Optimized: `mythconverg`.`pidcache`
Analyzed: `mythconverg`.`pidcache`
Repaired/Optimized: `mythconverg`.`playgroup`
Analyzed: `mythconverg`.`playgroup`
Repaired/Optimized: `mythconverg`.`powerpriority`
Analyzed: `mythconverg`.`powerpriority`
Repaired/Optimized: `mythconverg`.`profilegroups`
Analyzed: `mythconverg`.`profilegroups`
Repaired/Optimized: `mythconverg`.`program`
Analyzed: `mythconverg`.`program`
Repaired/Optimized: `mythconverg`.`programgenres`
Analyzed: `mythconverg`.`programgenres`
Repaired/Optimized: `mythconverg`.`programrating`
Analyzed: `mythconverg`.`programrating`
Repaired/Optimized: `mythconverg`.`recgrouppassword`
Analyzed: `mythconverg`.`recgrouppassword`
Repaired/Optimized: `mythconverg`.`record`
Analyzed: `mythconverg`.`record`
Repaired/Optimized: `mythconverg`.`record_tmp`
Analyzed: `mythconverg`.`record_tmp`
Repaired/Optimized: `mythconverg`.`recorded`
Analyzed: `mythconverg`.`recorded`
Repaired/Optimized: `mythconverg`.`recordedartwork`
Analyzed: `mythconverg`.`recordedartwork`
Repaired/Optimized: `mythconverg`.`recordedcredits`
Analyzed: `mythconverg`.`recordedcredits`
Repaired/Optimized: `mythconverg`.`recordedfile`
Analyzed: `mythconverg`.`recordedfile`
Repaired/Optimized: `mythconverg`.`recordedmarkup`
Analyzed: `mythconverg`.`recordedmarkup`
Repaired/Optimized: `mythconverg`.`recordedprogram`
Analyzed: `mythconverg`.`recordedprogram`
Repaired/Optimized: `mythconverg`.`recordedrating`
Analyzed: `mythconverg`.`recordedrating`
Repaired/Optimized: `mythconverg`.`recordedseek`
Analyzed: `mythconverg`.`recordedseek`
Repaired/Optimized: `mythconverg`.`recordfilter`
Analyzed: `mythconverg`.`recordfilter`
Repaired/Optimized: `mythconverg`.`recordingprofiles`
Analyzed: `mythconverg`.`recordingprofiles`
Repaired/Optimized: `mythconverg`.`recordmatch`
Analyzed: `mythconverg`.`recordmatch`
Repaired/Optimized: `mythconverg`.`romdb`
Analyzed: `mythconverg`.`romdb`
Repaired/Optimized: `mythconverg`.`schemalock`
Analyzed: `mythconverg`.`schemalock`
Repaired/Optimized: `mythconverg`.`settings`
Analyzed: `mythconverg`.`settings`
Repaired/Optimized: `mythconverg`.`storagegroup`
Analyzed: `mythconverg`.`storagegroup`
Repaired/Optimized: `mythconverg`.`tvchain`
Analyzed: `mythconverg`.`tvchain`
Repaired/Optimized: `mythconverg`.`tvosdmenu`
Analyzed: `mythconverg`.`tvosdmenu`
Repaired/Optimized: `mythconverg`.`upnpmedia`
Analyzed: `mythconverg`.`upnpmedia`
Repaired/Optimized: `mythconverg`.`videocast`
Analyzed: `mythconverg`.`videocast`
Repaired/Optimized: `mythconverg`.`videocategory`
Analyzed: `mythconverg`.`videocategory`
Repaired/Optimized: `mythconverg`.`videocollection`
Analyzed: `mythconverg`.`videocollection`
Repaired/Optimized: `mythconverg`.`videocountry`
Analyzed: `mythconverg`.`videocountry`
Repaired/Optimized: `mythconverg`.`videogenre`
Analyzed: `mythconverg`.`videogenre`
Repaired/Optimized: `mythconverg`.`videometadata`
Analyzed: `mythconverg`.`videometadata`
Repaired/Optimized: `mythconverg`.`videometadatacast`
Analyzed: `mythconverg`.`videometadatacast`
Repaired/Optimized: `mythconverg`.`videometadatacountry`
Analyzed: `mythconverg`.`videometadatacountry`
Repaired/Optimized: `mythconverg`.`videometadatagenre`
Analyzed: `mythconverg`.`videometadatagenre`
Repaired/Optimized: `mythconverg`.`videopathinfo`
Analyzed: `mythconverg`.`videopathinfo`
Repaired/Optimized: `mythconverg`.`videosource`
Analyzed: `mythconverg`.`videosource`
Repaired/Optimized: `mythconverg`.`videotypes`
Analyzed: `mythconverg`.`videotypes`
Repaired/Optimized: `mythconverg`.`weatherdatalayout`
Analyzed: `mythconverg`.`weatherdatalayout`
Repaired/Optimized: `mythconverg`.`weatherscreens`
Analyzed: `mythconverg`.`weatherscreens`
Repaired/Optimized: `mythconverg`.`weathersourcesettings`
Analyzed: `mythconverg`.`weathersourcesettings`
Repaired/Optimized: `mythconverg`.`websites`
Analyzed: `mythconverg`.`websites`

$ sudo service mythtv-backend stop
mythtv-backend stop/waiting
$ sudo service mythtv-backend start
mythtv-backend start/running, process 3027

lircd

restoring my home directory restored the lircd configuration files

Adding irexec per https://help.ubuntu.com/community/LIRC#irexec. I went to Applications -> Settings -> Session and Startup -> Application Autostart. I added an entry for "irexec -d"

I also unchecked the entry for "Update Notifier"

$ cat /proc/bus/input/devices
[SNIP]
I: Bus=0003 Vendor=1784 Product=0011 Version=0100
N: Name="Media Center Ed. eHome Infrared Remote Transceiver (1784:0011)"
P: Phys=usb-0000:00:06.0-2
S: Sysfs=/devices/pci0000:00/0000:00:06.0/usb4/4-2/4-2:1.0/rc/rc0/input3
U: Uniq=
H: Handlers=kbd event3 
B: PROP=0
B: EV=100013
B: KEY=fff 0 200108fc32e 237605100000000 0 700158000 419200004001 8e968000000000 10000000
B: MSC=10
[SNIP]
$  diff --unified=3 /etc/lirc/hardware.conf /storage/backups/daily/etc/lirc/hardware.conf 
--- /etc/lirc/hardware.conf	2013-04-06 22:33:50.000000000 -0700
+++ /storage/backups/daily/etc/lirc/hardware.conf	2012-10-23 00:28:09.000000000 -0700
@@ -2,11 +2,12 @@
 #
 #Chosen Remote Control
 REMOTE="Windows Media Center Transceivers/Remotes (all)"
-REMOTE_MODULES="lirc_dev mceusb"
+REMOTE="Media Center Ed. eHome Infrared Remote Transceiver (1784:0011)"
+REMOTE_MODULES="mceusb"
 REMOTE_DRIVER=""
 REMOTE_DEVICE="/dev/lirc0"
 REMOTE_SOCKET=""
-REMOTE_LIRCD_CONF="mceusb/lircd.conf.mceusb"
+REMOTE_LIRCD_CONF=""
 REMOTE_LIRCD_ARGS=""
 
 #Chosen IR Transmitter
$ sudo cp  /etc/lirc/hardware.conf  /etc/lirc/hardware.conf-orig
$ sudo cp -pr /storage/backups/daily/etc/lirc/hardware.conf  /etc/lirc/hardware.conf

That's all I did the first time through and my remote didn't work. Then I rediscovered =/etc/lirc/lircd.conf= and realized I needed to copy over my old file:

~/.mythtv$ pushd /etc/lirc
/etc/lirc$ ls
hardware.conf      hardware.conf-orig  lircd.conf.dpkg-old
hardware.conf.old  lircd.conf          lircmd.conf
/etc/lirc$ sudo cp -pr lircd.conf lircd.conf-orig
/etc/lirc$ sudo cp -pr /storage/backups/daily/etc/lirc/lircd.conf .
/etc/lirc$ sudo /etc/init.d/lirc restart
 * Stopping remote control daemon(s): LIRC                               [ OK ] 
 * Loading LIRC modules                                                  [ OK ] 
 * Starting remote control daemon(s) : LIRC                              [ OK ] 
/etc/lirc$ irw
0000000000366133 00 SELECT CHARTER_ATLAS4_0877
0000000000366133 01 SELECT CHARTER_ATLAS4_0877

and it seems to be working, again!!

Samba

$ diff --unified=4 /etc/samba/smb.conf /storage/backups/daily/etc/samba/smb.conf
--- /etc/samba/smb.conf	2013-04-06 22:33:44.000000000 -0700
+++ /storage/backups/daily/etc/samba/smb.conf	2012-10-22 23:36:44.000000000 -0700
@@ -9,9 +9,9 @@
 security = share
 
 [recordings]
 comment = TV Recordings
-path = /var/lib/mythtv/recordings
+path = /storage/mythtv/recordings
 public = yes
 writable = no
 create mask = 0777
 directory mask = 0777
@@ -19,9 +19,9 @@
 force group = nogroup
 
 [videos]
 comment = Videos
-path = /var/lib/mythtv/videos
+path = /storage/mythtv/videos
 public = yes
 writable = yes
 create mask = 0660
 directory mask = 0770
@@ -29,9 +29,9 @@
 force group = mythtv
 
 [music]
 comment = Music
-path = /var/lib/mythtv/music
+path = /storage/mythtv/music
 public = yes
 writable = yes
 create mask = 0660
 directory mask = 0770
@@ -39,9 +39,9 @@
 force group = mythtv
 
 [pictures]
 comment = Pictures
-path = /var/lib/mythtv/pictures
+path = /storage/mythtv/pictures
 public = yes
 writable = yes
 create mask = 0660
 directory mask = 0770
$ sudo cp -pr /etc/samba/smb.conf /etc/samba/smb.conf-orig
$ sudo cp -pr /storage/backups/daily/etc/samba/smb.conf /etc/samba/smb.conf

backups restore 1

$ sudo find . -size 0 -type f -ls -exec rm '{}' \;
946676    0 -rw-r--r--   1 root     root            0 Mar 24 08:00 ./mythconverg-083-13.sql
946684    0 -rw-r--r--   1 root     root            0 Mar 31 08:14 ./mythconverg-090-13.sql
946640    0 -rw-r--r--   1 root     root            0 Mar 22 07:29 ./mythconverg-20130322072925.sql
946652    0 -rw-r--r--   1 root     root            0 Mar 23 07:49 ./mythconverg-20130323074944.sql
946675    0 -rw-r--r--   1 root     root            0 Mar 24 07:54 ./mythconverg-20130324075428.sql
946677    0 -rw-r--r--   1 root     root            0 Mar 25 08:08 ./mythconverg-20130325080803.sql
946678    0 -rw-r--r--   1 root     root            0 Mar 26 07:51 ./mythconverg-20130326075138.sql
946679    0 -rw-r--r--   1 root     root            0 Mar 27 08:03 ./mythconverg-20130327080347.sql
946680    0 -rw-r--r--   1 root     root            0 Mar 28 08:02 ./mythconverg-20130328080203.sql
946681    0 -rw-r--r--   1 root     root            0 Mar 29 07:57 ./mythconverg-20130329075744.sql
946682    0 -rw-r--r--   1 root     root            0 Mar 30 08:02 ./mythconverg-20130330080241.sql
946683    0 -rw-r--r--   1 root     root            0 Mar 31 08:07 ./mythconverg-20130331080755.sql
946685    0 -rw-r--r--   1 root     root            0 Apr  1 07:47 ./mythconverg-20130401074728.sql
946686    0 -rw-r--r--   1 root     root            0 Apr  2 07:54 ./mythconverg-20130402075403.sql
946687    0 -rw-r--r--   1 root     root            0 Apr  3 07:42 ./mythconverg-20130403074241.sql
946848    0 -rw-r--r--   1 root     root            0 Apr  4 08:05 ./mythconverg-20130404080512.sql
946851    0 -rw-r--r--   1 root     root            0 Apr  5 07:53 ./mythconverg-20130405075321.sql

I added the optimize script to my backup

$ diff --unified=4 /storage/backups/daily/etc/cron.daily/mythconverg-backup /etc/cron.daily/mythconverg-backup
--- /storage/backups/daily/etc/cron.daily/mythconverg-backup	2011-05-29 01:23:59.000000000 -0700
+++ /etc/cron.daily/mythconverg-backup	2013-04-09 01:18:12.000000000 -0700
@@ -1,10 +1,15 @@
 #!/bin/sh
 ###### optimize_mythdb.sh
-
-OPT_MYTHDB='/home/troy/mythconverg_backup.pl --directory /storage/backups/myth/ --rotate 20'
 LOG='/var/log/mythtv/mythconverg_backup.log'
 
+OPT_MYTHDB='/usr/share/doc/mythtv-backend/contrib/maintenance/optimize_mythdb.pl'
+
 echo "Started ${OPT_MYTHDB} on `date`" >> ${LOG}
 ${OPT_MYTHDB} >> ${LOG}
 echo "Finished ${OPT_MYTHDB} on `date`" >> ${LOG} 
 
+OPT_MYTHDB='/home/troy/mythconverg_backup.pl --directory /storage/backups/myth/ --rotate 20'
+
+echo "Started ${OPT_MYTHDB} on `date`" >> ${LOG}
+${OPT_MYTHDB} >> ${LOG}
+echo "Finished ${OPT_MYTHDB} on `date`" >> ${LOG}
$ diff --unified=4 /storage/backups/daily/etc/cron.weekly/mythconverg-backup /etc/cron.weekly/mythconverg-backup
--- /storage/backups/daily/etc/cron.weekly/mythconverg-backup	2011-05-29 01:24:51.000000000 -0700
+++ /etc/cron.weekly/mythconverg-backup	2013-04-09 01:22:18.000000000 -0700
@@ -1,11 +1,18 @@
 #!/bin/sh
 ###### optimize_mythdb.sh
 
 nametag=`date +%j-%y`
-OPT_MYTHDB='/home/troy/mythconverg_backup.pl --directory /storage/backups/myth/ --filename mythconverg-'$nametag'.sql --rotate -1'
 LOG='/var/log/mythtv/mythconverg_backup.log'
 
+OPT_MYTHDB='/usr/share/doc/mythtv-backend/contrib/maintenance/optimize_mythdb.pl'
+
+echo "Started ${OPT_MYTHDB} on `date`" >> ${LOG}
+${OPT_MYTHDB} >> ${LOG}
+echo "Finished ${OPT_MYTHDB} on `date`" >> ${LOG} 
+
+OPT_MYTHDB='/home/troy/mythconverg_backup.pl --directory /storage/backups/myth/ --filename mythconverg-'$nametag'.sql --rotate -1'
+
 echo "Started ${OPT_MYTHDB} on `date`" >> ${LOG}
 ${OPT_MYTHDB} >> ${LOG}
 echo "Finished ${OPT_MYTHDB} on `date`" >> ${LOG} 
 

at this point, I rebooted to let changes take effect

extra software

  • sudo apt-get install rcs

Back to Wired Ethernet

My wifi card hasn't ever performed well. It seems like as soon I use it, it drops my connection. So, I'm going back to wired ethernet.

I need to change my configuration:

it was this way

$ sudo ifconfig -a
eth0      Link encap:Ethernet  HWaddr 00:24:1d:1d:8d:24  
          inet addr:169.254.1.5  Bcast:169.254.255.255  Mask:255.255.0.0
          inet6 addr: fe80::224:1dff:fe1d:8d24/64 Scope:Link
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:139125221 errors:0 dropped:0 overruns:0 frame:0
          TX packets:3312300 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000 
          RX bytes:188562184411 (188.5 GB)  TX bytes:325395429 (325.3 MB)

eth1      Link encap:Ethernet  HWaddr 10:fe:ed:07:bb:6c  
          inet6 addr: fe80::12fe:edff:fe07:bb6c/64 Scope:Link
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:16662 errors:0 dropped:0 overruns:0 frame:0
          TX packets:163143 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000 
          RX bytes:8911334 (8.9 MB)  TX bytes:45298503 (45.2 MB)

lo        Link encap:Local Loopback  
          inet addr:127.0.0.1  Mask:255.0.0.0
          inet6 addr: ::1/128 Scope:Host
          UP LOOPBACK RUNNING  MTU:16436  Metric:1
          RX packets:669738 errors:0 dropped:0 overruns:0 frame:0
          TX packets:669738 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:0 
          RX bytes:252747156 (252.7 MB)  TX bytes:252747156 (252.7 MB)

wlan0     Link encap:Ethernet  HWaddr 00:0d:0a:00:1e:df  
          inet addr:192.168.1.55  Bcast:192.168.1.255  Mask:255.255.255.0
          inet6 addr: fe80::20d:aff:fe00:1edf/64 Scope:Link
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:790863 errors:0 dropped:0 overruns:0 frame:0
          TX packets:532965 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000 
          RX bytes:186785857 (186.7 MB)  TX bytes:91105115 (91.1 MB)

now it looks like this

$ sudo ifconfig -a
eth0      Link encap:Ethernet  HWaddr 00:24:1d:1d:8d:24  
          inet addr:169.254.1.5  Bcast:169.254.255.255  Mask:255.255.0.0
          inet6 addr: fe80::224:1dff:fe1d:8d24/64 Scope:Link
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:151912471 errors:0 dropped:0 overruns:0 frame:0
          TX packets:3529212 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000 
          RX bytes:205947043708 (205.9 GB)  TX bytes:346409918 (346.4 MB)

eth1      Link encap:Ethernet  HWaddr 10:fe:ed:07:bb:6c  
          inet addr:192.168.1.113  Bcast:192.168.1.255  Mask:255.255.255.0
          inet6 addr: fe80::12fe:edff:fe07:bb6c/64 Scope:Link
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:17573 errors:0 dropped:0 overruns:0 frame:0
          TX packets:166495 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000 
          RX bytes:9187504 (9.1 MB)  TX bytes:46195413 (46.1 MB)

lo        Link encap:Local Loopback  
          inet addr:127.0.0.1  Mask:255.0.0.0
          inet6 addr: ::1/128 Scope:Host
          UP LOOPBACK RUNNING  MTU:16436  Metric:1
          RX packets:694451 errors:0 dropped:0 overruns:0 frame:0
          TX packets:694451 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:0 
          RX bytes:273051587 (273.0 MB)  TX bytes:273051587 (273.0 MB)

wlan0     Link encap:Ethernet  HWaddr 00:0d:0a:00:1e:df  
          inet addr:192.168.1.55  Bcast:192.168.1.255  Mask:255.255.255.0
          inet6 addr: fe80::20d:aff:fe00:1edf/64 Scope:Link
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:804307 errors:0 dropped:0 overruns:0 frame:0
          TX packets:542392 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000 
          RX bytes:188744171 (188.7 MB)  TX bytes:92722146 (92.7 MB)

I have installed a Gigabit PCI Express adapter, TP-LINK TG-3468. I used NetworkManager to turn off "Connect Automatically" from my Wi-Fi connection and turned on "Connect Automatically" for "Wired connection 1". Now I have a direct, wired ethernet connection between my myth box and my HDHomeRun on eth0. I have my wired internet ethernet connection on eth1. Finally, I have my unused Wi-Fi ethernet connection on wlan0. I think this is going to work... 1-Mar-2014