Greg's setting up a TV computer
Greg's diary
Greg's home page
HOWTO index
Google
Work in progress
Work in progress

This page is a log of what I did to migrate my two multimedia computers into a single one, starting in earnest in January 2016. Hopefully it'll help me in the future.

Background as of 13 January 2016:

I've been using computers to record and play back TV programmes since 2006, and gradually it works relatively well. But at the time I had to use Linux to run the tuner side of things, using computers called ceeveear and cvr2, and playing them on a FreeBSD computer with names like teevee and tv2. Software rots, and in particular my installation of MythTV is no longer compatible with the latest version shepherd, so I need to update.

In the meantime FreeBSD can handle TV tuners, so the intention is to replace the current boxes teevee and cvr2 with a single box that I'm calling tiwi. At present I'm just writing down what I'm doing.

13 January 2016

Greg's environment

Multimedia software

mplayer

Adapt patches. Pain.

lirc

Install port, run lircd. irw doesn't respond.

MythTV

Removes installed MySQL 5.5, installs 5.6.

mysql -uroot -p < /usr/local/share/mythtv/database/mc.sql
=== root@tiwi (/dev/pts/0) /spool/Cooking 64 -> mysql -uroot -p < /usr/local/share/mythtv/database/mc.sql
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
=== root@tiwi (/dev/pts/0) /spool/Cooking 66 -> mysql -uroot < /usr/local/share/mythtv/database/mc.sql
=== root@tiwi (/dev/pts/0) /spool/Cooking 67 -> mythtv-setup
2016-01-13 15:55:41.520619 I  Setup Interrupt handler
2016-01-13 15:55:41.520983 I  Setup Terminated handler
2016-01-13 15:55:41.521017 I  Setup Segmentation fault handler
2016-01-13 15:55:41.521048 I  Setup Abort trap handler
2016-01-13 15:55:41.521081 I  Setup Bus error handler
2016-01-13 15:55:41.521100 I  Setup Floating point exception handler
2016-01-13 15:55:41.521121 I  Setup Illegal instruction handler
2016-01-13 15:55:41.521152 I  Setup Unknown signal: 65 handler
2016-01-13 15:55:41.521565 C  mythtv-setup version:  [5a5e1cd] www.mythtv.org
2016-01-13 15:55:41.521588 C  Qt version: compile: 4.8.7, runtime: 4.8.7
2016-01-13 15:55:41.521597 N  Enabled verbose msgs:  general
2016-01-13 15:55:41.521644 N  Setting Log Level to LOG_INFO
2016-01-13 15:55:41.522600 N  Using runtime prefix = /usr/local
2016-01-13 15:55:41.522643 N  Using configuration directory = /root/.mythtv
2016-01-13 15:55:41.522828 I  Added logging to the console
2016-01-13 15:55:41.523292 I  Assumed character encoding:
2016-01-13 15:55:41.523343 W  This application expects to be running a locale that specifies a UTF-8 codeset, and many features may behave improperly with your current language settings. Please set the LC_ALL or LC_CTYPE, and LANG variable(s) in the environment in which this program is executed to include a UTF-8 codeset (such as 'en_US.UTF-8').
2016-01-13 15:55:41.538039 E  DBHostName is not set in config.xml
2016-01-13 15:55:41.538066 E  DBHostName is not set in config.xml
2016-01-13 15:55:41.538155 N  Empty LocalHostName.
2016-01-13 15:55:41.538232 I  Using localhost value of tiwi.lemis.com
2016-01-13 15:55:41.754542 I  Starting mythlogserver
2016-01-13 15:55:41.755027 I  Starting process manager
2016-01-13 15:55:41.755262 I  Starting process signal handler
2016-01-13 15:55:41.755544 I  Starting IO manager (write)
2016-01-13 15:55:41.755942 I  Starting IO manager (read)
2016-01-13 15:55:41.823001 N  Desktop video mode: 2560x1440 59.951 Hz
2016-01-13 15:55:42.074354 E  LIRC: Failed to connect to Unix socket '/var/run/lirc/lircd'
                        eno: No such file or directory (2)
2016-01-13 15:55:42.074453 I  UDPListener: Enabling
2016-01-13 15:55:42.170446 I  Added logging to mythlogserver at TCP:35327
2016-01-13 15:55:42.241863 I  Binding to UDP 127.0.0.1:0
2016-01-13 15:55:42.257448 E  Failed binding to UDP [fe80::221:86ff:fe21:ab7e%em0]:0 - Error 9: The address is not available
2016-01-13 15:55:42.257524 E  Address [fe80::221:86ff:fe21:ab7e%em0] no longer exists - ignoring
2016-01-13 15:55:42.257661 I  Binding to UDP [::1]:0
2016-01-13 15:55:42.257752 I  Binding to UDP [fe80::1%lo0]:0
2016-01-13 15:55:42.272025 I  Using Frameless Window
2016-01-13 15:55:42.272192 I  Using Full Screen Window
2016-01-13 15:55:42.347618 I  Using the Qt painter
2016-01-13 15:55:42.831255 N  Setting QT default locale to en_AU
2016-01-13 15:55:44.027674 W  MythCookieJar::load() failed to open file for reading: /root/.mythtv/MythBrowser/cookiejar.txt
2016-01-13 15:55:44.122182 I  MythUIWebBrowser: Loading css from - file:///usr/local/share/mythtv/themes/default/htmls/mythbrowser.css
2016-01-13 15:55:44.127877 E  MythUIWebBrowser: failed to find our parent screen
2016-01-13 15:55:44.138732 I  MythUIWebBrowser: enabling plugins
2016-01-13 15:55:44.777673 I  System Locale (en_AU), Country (AU), Language (en)
2016-01-13 15:55:59.691102 I  Loading en_us translation for module mythfrontend
2016-01-13 15:55:59.733761 N  Setting QT default locale to en_AU
2016-01-13 15:55:59.733806 I  Current locale en_AU
2016-01-13 15:55:59.734033 E  No locale defaults file for en_AU, skipping
2016-01-13 15:55:59.835611 I  ScreenSaverX11Private: DPMS is active.
2016-01-13 15:55:59.875532 E  Error preparing query: SELECT DISTINCT dirname FROM storagegroup WHERE groupname = :GROUP AND hostname = :HOSTNAME
2016-01-13 15:55:59.875576 E  Driver error was [2/1146]:
QMYSQL3: Unable to prepare statement
Database error was:
Table 'mythconverg.storagegroup' doesn't exist

2016-01-13 15:55:59.876316 E  DB Error (StorageGroup::StorageGroup()):
Query was:
SELECT DISTINCT dirname FROM storagegroup WHERE groupname = :GROUP AND hostname = :HOSTNAME
Bindings were:
:GROUP="Themes", :HOSTNAME="tiwi.lemis.com"
Driver error was [2/1064]:
QMYSQL: Unable to execute query
Database error was:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':GROUP AND hostname = :HOSTNAME' at line 1

2016-01-13 15:55:59.877334 N  Inserting MythTV initial database information.
2016-01-13 15:55:59.877368 C  Upgrading to MythTV schema version 1307
2016-01-13 15:56:00.236935 I  Loading en_us translation for module mythfrontend
2016-01-13 15:56:00.237586 E  LIRC: Failed to connect to Unix socket '/var/run/lirc/lircd'
                        eno: No such file or directory (2)
2016-01-13 15:56:00.237607 I  UDPListener: Enabling
2016-01-13 15:56:00.238126 I  Binding to UDP 127.0.0.1:0
2016-01-13 15:56:00.238219 E  Failed binding to UDP [fe80::221:86ff:fe21:ab7e%em0]:0 - Error 9: The address is not available
2016-01-13 15:56:00.238276 E  Address [fe80::221:86ff:fe21:ab7e%em0] no longer exists - ignoring
2016-01-13 15:56:00.238390 I  Binding to UDP [::1]:0
2016-01-13 15:56:00.238472 I  Binding to UDP [fe80::1%lo0]:0
2016-01-13 15:56:00.278209 I  Using Frameless Window
2016-01-13 15:56:00.278248 I  Using Full Screen Window
2016-01-13 15:56:00.280966 I  Using the Qt painter
2016-01-13 15:56:00.731827 I  MythUIWebBrowser: Loading css from - file:///usr/local/share/mythtv/themes/default/htmls/mythbrowser.css
2016-01-13 15:56:00.749322 E  MythUIWebBrowser: failed to find our parent screen
2016-01-13 15:56:00.750290 I  MythUIWebBrowser: enabling plugins
2016-01-13 15:56:01.597322 I  System Locale (en_AU), Country (AU), Language (en)
2016-01-13 15:56:12.996409 I  Loading en_gb translation for module mythfrontend
2016-01-13 15:56:13.009021 I  Using Frameless Window
2016-01-13 15:56:13.009034 I  Using Full Screen Window
2016-01-13 15:56:13.011237 I  Using the Qt painter
2016-01-13 15:56:13.241579 I  MythUIWebBrowser: Loading css from - file:///usr/local/share/mythtv/themes/default/htmls/mythbrowser.css
2016-01-13 15:56:13.241968 E  MythUIWebBrowser: failed to find our parent screen
2016-01-13 15:56:13.242068 I  MythUIWebBrowser: enabling plugins
2016-01-13 15:56:13.332937 W  MythPainter: 17 images not yet de-allocated.
=== root@tiwi (/dev/pts/0) /spool/Cooking 68 -> mythtv-setup
2016-01-13 15:56:20.200709 I  Setup Interrupt handler
2016-01-13 15:56:20.201030 I  Setup Terminated handler
2016-01-13 15:56:20.201064 I  Setup Segmentation fault handler
2016-01-13 15:56:20.201088 I  Setup Abort trap handler
2016-01-13 15:56:20.201107 I  Setup Bus error handler
2016-01-13 15:56:20.201125 I  Setup Floating point exception handler
2016-01-13 15:56:20.201146 I  Setup Illegal instruction handler
2016-01-13 15:56:20.201172 I  Setup Unknown signal: 65 handler
2016-01-13 15:56:20.201529 C  mythtv-setup version:  [5a5e1cd] www.mythtv.org
2016-01-13 15:56:20.201548 C  Qt version: compile: 4.8.7, runtime: 4.8.7
2016-01-13 15:56:20.201557 N  Enabled verbose msgs:  general
2016-01-13 15:56:20.201596 N  Setting Log Level to LOG_INFO
2016-01-13 15:56:20.202448 N  Using runtime prefix = /usr/local
2016-01-13 15:56:20.202489 N  Using configuration directory = /root/.mythtv
2016-01-13 15:56:20.202731 I  Added logging to the console
2016-01-13 15:56:20.202915 I  Assumed character encoding:
2016-01-13 15:56:20.202963 W  This application expects to be running a locale that specifies a UTF-8 codeset, and many features may behave improperly with your current language settings. Please set the LC_ALL or LC_CTYPE, and LANG variable(s) in the environment in which this program is executed to include a UTF-8 codeset (such as 'en_US.UTF-8').
2016-01-13 15:56:20.204596 N  Empty LocalHostName.
2016-01-13 15:56:20.204670 I  Using localhost value of tiwi.lemis.com
2016-01-13 15:56:20.239506 N  Setting QT default locale to en_AU
2016-01-13 15:56:20.239731 I  Current locale en_AU
2016-01-13 15:56:20.240077 E  No locale defaults file for en_AU, skipping
2016-01-13 15:56:20.241387 I  Starting process manager
2016-01-13 15:56:20.242515 I  Starting IO manager (write)
2016-01-13 15:56:20.242691 I  Starting IO manager (read)
2016-01-13 15:56:20.242772 I  Starting process signal handler
2016-01-13 15:56:20.349939 I  ScreenSaverX11Private: DPMS is active.
2016-01-13 15:56:20.393195 N  Desktop video mode: 2560x1440 59.951 Hz
2016-01-13 15:56:20.453395 I  Added logging to mythlogserver at TCP:35327
2016-01-13 15:56:20.619585 I  Loading en_gb translation for module mythfrontend
2016-01-13 15:56:20.621012 E  LIRC: Failed to connect to Unix socket '/var/run/lirc/lircd'
                        eno: No such file or directory (2)
2016-01-13 15:56:20.621100 I  UDPListener: Enabling
2016-01-13 15:56:20.625029 I  Binding to UDP 127.0.0.1:0
2016-01-13 15:56:20.625260 E  Failed binding to UDP [fe80::221:86ff:fe21:ab7e%em0]:0 - Error 9: The address is not available
2016-01-13 15:56:20.625318 E  Address [fe80::221:86ff:fe21:ab7e%em0] no longer exists - ignoring
2016-01-13 15:56:20.625444 I  Binding to UDP [::1]:0
2016-01-13 15:56:20.625529 I  Binding to UDP [fe80::1%lo0]:0
2016-01-13 15:56:20.655612 I  Using Frameless Window
2016-01-13 15:56:20.655815 I  Using Full Screen Window
2016-01-13 15:56:20.665015 I  Using the Qt painter
2016-01-13 15:56:21.135268 I  MythUIWebBrowser: Loading css from - file:///usr/local/share/mythtv/themes/default/htmls/mythbrowser.css
2016-01-13 15:56:21.135980 E  MythUIWebBrowser: failed to find our parent screen
2016-01-13 15:56:21.138018 I  MythUIWebBrowser: enabling plugins
2016-01-13 15:56:21.310174 E  MySQL time zone support is missing.  Please install it and try again.  See 'mysql_tzinfo_to_sql' for assistance.
=== root@tiwi (/dev/pts/0) /spool/Cooking 69 ->


Try again as grog

=== grog@tiwi (/dev/pts/1) ~ 13 -> mythtv-setup
2016-01-14 17:56:57.074142 I  Setup Interrupt handler
2016-01-14 17:56:57.074477 I  Setup Terminated handler
2016-01-14 17:56:57.074512 I  Setup Segmentation fault handler
2016-01-14 17:56:57.074543 I  Setup Abort trap handler
2016-01-14 17:56:57.074562 I  Setup Bus error handler
2016-01-14 17:56:57.074581 I  Setup Floating point exception handler
2016-01-14 17:56:57.074607 I  Setup Illegal instruction handler
2016-01-14 17:56:57.074631 I  Setup Unknown signal: 65 handler
2016-01-14 17:56:57.075010 C  mythtv-setup version:  [5a5e1cd] www.mythtv.org
2016-01-14 17:56:57.075030 C  Qt version: compile: 4.8.7, runtime: 4.8.7
2016-01-14 17:56:57.075038 N  Enabled verbose msgs:  general
2016-01-14 17:56:57.075079 N  Setting Log Level to LOG_INFO
2016-01-14 17:56:57.086139 N  Using runtime prefix = /usr/local
2016-01-14 17:56:57.086188 N  Using configuration directory = /home/grog/.mythtv
2016-01-14 17:56:57.086445 I  Added logging to the console
2016-01-14 17:56:57.086630 I  Assumed character encoding:
2016-01-14 17:56:57.086678 W  This application expects to be running a locale that specifies a UTF-8 codeset, and many features may behave improperly with your current language settings. Please set the LC_ALL or LC_CTYPE, and LANG variable(s) in the environment in which this program is executed to include a UTF-8 codeset (such as 'en_US.UTF-8').
2016-01-14 17:56:57.144882 N  Empty LocalHostName.
2016-01-14 17:56:57.145012 I  Using localhost value of tiwi.lemis.com
2016-01-14 17:56:57.362138 I  Starting mythlogserver
2016-01-14 17:56:57.388616 I  Starting process manager
2016-01-14 17:56:57.388802 I  Starting IO manager (read)
2016-01-14 17:56:57.388980 I  Starting process signal handler
2016-01-14 17:56:57.389122 I  Starting IO manager (write)
2016-01-14 17:56:58.993892 N  Setting QT default locale to en_AU
2016-01-14 17:56:58.994046 I  Current locale en_AU
2016-01-14 17:56:59.010508 E  No locale defaults file for en_AU, skipping
2016-01-14 17:56:59.143084 I  Added logging to mythlogserver at TCP:35327
2016-01-14 17:56:59.164968 I  ScreenSaverX11Private: DPMS is active.
2016-01-14 17:56:59.521100 N  Desktop video mode: 2560x1440 59.951 Hz
2016-01-14 17:56:59.928408 I  Loading en_gb translation for module mythfrontend
2016-01-14 17:56:59.942671 E  LIRC: Failed to connect to Unix socket '/var/run/lirc/lircd'
                        eno: No such file or directory (2)
2016-01-14 17:56:59.942769 I  UDPListener: Enabling
2016-01-14 17:56:59.960092 I  Binding to UDP 127.0.0.1:0
2016-01-14 17:56:59.960679 E  Failed binding to UDP [fe80::221:86ff:fe21:ab7e%em0]:0 - Error 9: The address is not available
2016-01-14 17:56:59.960747 E  Address [fe80::221:86ff:fe21:ab7e%em0] no longer exists - ignoring
2016-01-14 17:56:59.960880 I  Binding to UDP [::1]:0
2016-01-14 17:56:59.960964 I  Binding to UDP [fe80::1%lo0]:0
2016-01-14 17:57:00.062796 I  Using Frameless Window
2016-01-14 17:57:00.062986 I  Using Full Screen Window
2016-01-14 17:57:00.098028 I  Using the Qt painter
2016-01-14 17:57:02.262846 I  MythUIWebBrowser: Loading css from - file:///usr/local/share/mythtv/themes/default/htmls/mythbrowser.css
2016-01-14 17:57:02.321639 E  MythUIWebBrowser: failed to find our parent screen
2016-01-14 17:57:02.357816 I  MythUIWebBrowser: enabling plugins
2016-01-14 17:57:02.863181 E  MySQL time zone support is missing.  Please install it and try again.  See 'mysql_tzinfo_to_sql' for assistance.
https://www.mythtv.org/wiki/Troubleshooting:Mythbackend_will_not_start_after_upgrade_0.26_Time_Zone_error
=== grog@tiwi (/dev/pts/1) ~ 14 -> mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -uroot mysql
Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.

Setting up MythTV

Host address setup: use real IPV4 address, PIN is 6545.

Locale settings? For the sake of it, TV format PAL, VBI format none, Chennel frequency australia

Misc settings, EIT settings: nothing obvious to change.

Shutdown/wakeup: Defer until later.

Storage directories: Position on Default, press Return (doesn't respond to mouse click). Enter the name of a directory that must exist before you exit.

Apache

Get rid of this silly version-dependent naming. In particular:

 #
-DocumentRoot "/usr/local/www/apache24/data"
-<Directory "/usr/local/www/apache24/data">
+DocumentRoot "/usr/local/www/data"
+<Directory "/usr/local/www/data">

MythWeb

https://www.mythtv.org/wiki/MythTV-HOWTO#MythWeb /usr/local/www/mythweb/INSTALL vi /var/www/html/mythweb.conf.apache mv /var/www/html/mythweb.conf.apache /etc/httpd/conf.d/mythweb.conf /etc/init.d/httpd restart

To do

To do: get rid of this silly xterm icon.

Temp for diary

Looking through the mythtv-setup errors:


Greg's home page Greg's diary Greg's photos Copyright

Valid XHTML 1.0!

$Id: skel.php,v 1.7 2014/02/16 02:49:28 grog Exp grog $