Chris on April 8th, 2007

My root filesystem died on my MythTV server while I was sick last week. After spending a good bit of time trying to recover the data, I lost my database and mythtv build.

Document I followed to get MythTV Installed and ivtv modules working using this document. This document has the package repository used: http://packman.iu-bremen.de/suse/10.2.

This command worked to get the ivtv driver to load:
sudo rpm -Uhv http://jarpack.com/suse/noarch/ivtv-firmware-0.1-1.noarch.rpm

ivtv-fb loaded without issues. It took a bit of googling to find a ivtv driver for xorg. Here it is:

http://www.hellion.org.uk/ivtv/debian/ivtvdev_drv.so~i386

LIRC was the next issue. Here is a bug with LIRC in SuSE 10.2 that prevents /dev/lirc and /dev/lirc0 from being created.
I compiled up the source and was able to copy just the kernel module to fix it.
cp drivers/lirc_i2c/lirc_i2c.ko /lib/modules/2.6.18.2-34-default/updates/lirc_i2c

Chris on January 27th, 2007

Wow, MythTV is a pain in the ass to build. Luckly I found a site that had OpenSuSE 10.2 rpms. That made it easier. I still had to copy over my config files from the old MythTV build.

http://packman.iu-bremen.de/suse/10.2

I had to manually alter the recording tables to copy the data from the old system to the new database.

The following query was used to compare settings from the old settings table and the new settings table:
select mythconverg.settings.value, mythconverg.settings.data, mythOLD.settings.data from mythconverg.settings, mythOLD.settings WHERE mythconverg.settings.value=mythOLD.settings.value AND mythconverg.settings.data != mythOLD.settings.data INTO OUTFILE '/tmp/setting.diff';