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

• Partition a new disk in stable, my development box:

  =>        34  5860533101  ada1  GPT  (2.7T)
            34           6        - free -  (3.0K)
            40         128     1  freebsd-boot  (64K)
           168   136314880     2  freebsd-ufs  (65G)
     136315048    20971520     3  freebsd-swap  (10G)
     157286568  5703246560     4  freebsd-ufs  (2.7T)
    5860533128           7        - free -  (3.5K)
  

  Partition 2 is the root file system, including /usr, /home and /var. Partition 4 is /spool, where the images go.

• Copy stable's root file system to /dev/ada1p2 using dd.
• In principle, move the disk to a new machine. In practice, it was stable that got a new machine, so this disk stayed in the same physical machine (Lenovo ThinkCentre) as /dev/ada0.
• Reboot and reconfigure:
  • Name server: create A and PTR records for tiwi.
  • rc.conf: change name to tiwi, IP address accordingly.
  • /etc/fstab:
    /dev/ada0p2             /                       ufs     rw              1 1
    /dev/ada0p3             none                    swap    sw      0       0
    /dev/ada0p4             /spool              ufs     rw              1 1
    
  • /etc/gettytab:

    
    +# autogrog - automatically log in as user 'grog'
    +#
    +
    +autogrog|al.9600:\
    +       :al=grog:tc=std.9600:
    
  • /etc/ttys:
    -ttyv0  "/usr/libexec/getty Pc"         cons25  on  secure
    +# Log in as user 'grog' by default.  See the entry in /etc/gettytab
    +# for details.
    +ttyv0  "/usr/libexec/getty autogrog" cons25  on  secure
     # Virtual terminals
    -ttyv1  "/usr/libexec/getty Pc"         cons25  on  secure
    +# This one is root on ttyv1 to monitor the shutdown request
    +ttyv1  "/usr/libexec/getty autologin" cons25  on  secure
    


=== root@tiwi (/dev/pts/0) /etc 11 -> mkdir /spool
=== root@tiwi (/dev/pts/0) /etc 12 -> newfs -L Videos -U -a 64 -e 2048 -g 2097152 -h 64 -i 2097152 -m 1 ada0p4
=== root@tiwi (/dev/pts/0) /etc 13 -> mount /spool


rsync -lKavP --delete-after /spool /tiwi/spool
• On teevee:
  
  === root@teevee (/dev/pts/4) ~ 12 -> cd /spool
=== root@teevee (/dev/pts/4) /spool 13 -> for i in *; do rsync -lKavP --delete-after $i /tiwi/spool/; done
  
  z option isn't worth it, since it doesn't compress much, but uses a lot of CPU time.
• Rename /etc/weekly/310-locate to /etc/daily/310-locate

Greg's environment

• Add symlinks .fvwm, .xinitrc backdrops to /eureka/home/grog.

Multimedia software

mplayer

Adapt patches. Pain.

lirc

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

MythTV

Removes installed MySQL 5.5, installs 5.6.

Try again as grog

https://www.mythtv.org/wiki/Troubleshooting:Mythbackend_will_not_start_after_upgrade_0.26_Time_Zone_error

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:

MythWeb

https://www.mythtv.org/wiki/MythTV-HOWTO#MythWeb /usr/local/www/mythweb/INSTALL

• Install doesn't put anything in /usr/local/www/data/
  ===========
  3.0 Experts
  ===========
  
  If you are not an expert, please skip to section 4.0.  Experts, the
  following commands should be enough for you to figure out what's going on:
  
      cp -r mythweb/* /var/www/html/
  

  This, of course, is useless if you don't know where the files are. In fact, for no good reason they've been installed in /usr/local/www/mythweb. But in fact, it's also unnecessary. This is where the port wants it put.

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:

• 2016-01-14 13:05:26.100068 E  Unable to connect to database!
  2016-01-14 13:05:26.100131 E  Driver error was [1/2002]:
  QMYSQL: Unable to connect
  Database error was:
  Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
  
  

  MythTV wants to upgrade your database, for the TV schema, from 1307 to 1317.

  Backup in /tmp (mythconverg-1307-DAT.sql.gz)

  === grog@tiwi (/dev/pts/1) ~ 15 -> mythtv-setup
  2016-01-14 18:32:33.449037 I  Setup Interrupt handler
  2016-01-14 18:32:33.449369 I  Setup Terminated handler
  2016-01-14 18:32:33.449408 I  Setup Segmentation fault handler
  2016-01-14 18:32:33.449431 I  Setup Abort trap handler
  2016-01-14 18:32:33.449449 I  Setup Bus error handler
  2016-01-14 18:32:33.449467 I  Setup Floating point exception handler
  2016-01-14 18:32:33.449487 I  Setup Illegal instruction handler
  2016-01-14 18:32:33.449512 I  Setup Unknown signal: 65 handler
  2016-01-14 18:32:33.449886 C  mythtv-setup version:  [5a5e1cd] www.mythtv.org
  2016-01-14 18:32:33.449906 C  Qt version: compile: 4.8.7, runtime: 4.8.7
  2016-01-14 18:32:33.449914 N  Enabled verbose msgs:  general
  2016-01-14 18:32:33.449955 N  Setting Log Level to LOG_INFO
  2016-01-14 18:32:33.451073 I  Added logging to the console
  2016-01-14 18:32:33.475038 N  Using runtime prefix = /usr/local
  2016-01-14 18:32:33.475087 N  Using configuration directory = /home/grog/.mythtv
  2016-01-14 18:32:33.497045 I  Assumed character encoding:
  2016-01-14 18:32:33.497107 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 18:32:33.610365 N  Empty LocalHostName.
  2016-01-14 18:32:33.610455 I  Using localhost value of tiwi.lemis.com
  2016-01-14 18:32:33.837202 I  Starting mythlogserver
  2016-01-14 18:32:33.877182 I  Starting process manager
  2016-01-14 18:32:33.877507 I  Starting process signal handler
  2016-01-14 18:32:33.877572 I  Starting IO manager (write)
  2016-01-14 18:32:33.877658 I  Starting IO manager (read)
  2016-01-14 18:32:34.027621 N  Setting QT default locale to en_AU
  2016-01-14 18:32:34.027756 I  Current locale en_AU
  2016-01-14 18:32:34.027985 E  No locale defaults file for en_AU, skipping
  2016-01-14 18:32:34.113921 I  ScreenSaverX11Private: DPMS is active.
  2016-01-14 18:32:34.189529 I  Added logging to mythlogserver at TCP:35327
  2016-01-14 18:32:34.553190 N  Desktop video mode: 2560x1440 59.951 Hz
  2016-01-14 18:32:34.912340 I  Loading en_gb translation for module mythfrontend
  2016-01-14 18:32:34.920674 E  LIRC: Failed to connect to Unix socket '/var/run/lirc/lircd'
                          eno: No such file or directory (2)
  2016-01-14 18:32:34.921145 I  UDPListener: Enabling
  2016-01-14 18:32:34.951863 I  Binding to UDP 127.0.0.1:0
  2016-01-14 18:32:34.956326 E  Failed binding to UDP [fe80::221:86ff:fe21:ab7e%em0]:0 - Error 9: The address is not available
  2016-01-14 18:32:34.956402 E  Address [fe80::221:86ff:fe21:ab7e%em0] no longer exists - ignoring
  2016-01-14 18:32:34.956567 I  Binding to UDP [::1]:0
  2016-01-14 18:32:34.956654 I  Binding to UDP [fe80::1%lo0]:0
  2016-01-14 18:32:35.011712 I  Using Frameless Window
  2016-01-14 18:32:35.020238 I  Using Full Screen Window
  2016-01-14 18:32:35.056717 I  Using the Qt painter
  2016-01-14 18:32:36.949174 I  MythUIWebBrowser: Loading css from - file:///usr/local/share/mythtv/themes/default/htmls/mythbrowser.css
  2016-01-14 18:32:36.975670 E  MythUIWebBrowser: failed to find our parent screen
  2016-01-14 18:32:36.977477 I  MythUIWebBrowser: enabling plugins
  2016-01-14 18:32:37.314682 I  Current MythTV Schema Version (DBSchemaVer): 1307
  2016-01-14 18:32:37.345570 E  SG(DB Backups): Unable to find any Storage Group Directories.  Using hardcoded default value of '/mnt/store'
  2016-01-14 18:32:37.358313 E  SG(DB Backups): FindNextDirMostFree: '/mnt/store' does not exist!
  2016-01-14 18:32:37.389795 E  Backing up database with script: '/usr/local/share/mythtv/mythconverg_backup.pl'
  2016-01-14 18:32:40.456234 C  Database Backup complete.
  2016-01-14 18:32:40.459827 C  Backed up database to file: '/tmp/mythconverg-1307-20160114073237.sql.gz'
  2016-01-14 18:34:10.388376 C  Upgrading to MythTV schema version 1308
  2016-01-14 18:34:10.468153 C  Upgrading to MythTV schema version 1309
  2016-01-14 18:34:10.489291 C  Upgrading to MythTV schema version 1310
  2016-01-14 18:34:10.489870 C  Upgrading to MythTV schema version 1311
  2016-01-14 18:34:10.572466 C  Upgrading to MythTV schema version 1312
  2016-01-14 18:34:10.573349 C  Upgrading to MythTV schema version 1313
  2016-01-14 18:34:10.602028 C  Upgrading to MythTV schema version 1314
  2016-01-14 18:34:10.602882 C  Upgrading to MythTV schema version 1315
  2016-01-14 18:34:10.603341 C  Upgrading to MythTV schema version 1316
  2016-01-14 18:34:10.640176 C  Upgrading to MythTV schema version 1317
  2016-01-14 18:34:10.789752 I  Database schema upgrade complete.
  
  This one wasn't there yesterday. It seems that the package installation removed MySQL 5.5, both client and server, but only reinstalled the client. Reinstall server.
  <code><font color="blue">=== root@tiwi (/dev/pts/2)</font> <font color="red">/home/grog</font> <font color="blue">9</font> -&gt; <b><tt>pkg install mysql56-server</tt></b></code>
  Updating FreeBSD repository catalogue...
  FreeBSD repository is up-to-date.
  All repositories are up-to-date.
  The following 1 package(s) will be affected (of 0 checked):
  
  New packages to be INSTALLED:
          mysql56-server: 5.6.27
  
  The process will require 84 MiB more space.
  8 MiB to be downloaded.
  
  Proceed with this action? [y/N]: y
  Fetching mysql56-server-5.6.27.txz: 100%    8 MiB 499.5kB/s    00:17
  Checking integrity... done (0 conflicting)
  [1/1] Installing mysql56-server-5.6.27...
  ===> Creating users and/or groups.
  Using existing group 'mysql'.
  Using existing user 'mysql'.
  [1/1] Extracting mysql56-server-5.6.27: 100%
  Message from mysql56-server-5.6.27:
  ************************************************************************
  
  Remember to run mysql_upgrade the first time you start the MySQL server
  after an upgrade from an earlier version.
  
  ************************************************************************
  <code><font color="blue">=== root@tiwi (/dev/pts/2)</font> <font color="red">/home/grog</font> <font color="blue">10</font> -&gt; <b><tt>mysql_upgrade </tt></b></code>
  Looking for 'mysql' as: mysql
  Looking for 'mysqlcheck' as: mysqlcheck
  FATAL ERROR: Upgrade failed
  

  Need to start server first.

• Errors due to not running locally?
  2016-01-13 15:56:21.135980 E  MythUIWebBrowser: failed to find our parent screen
  

  Configure X. No change.

• 
  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
  Where's config.xml? There doesn't seem to be one.
• 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
  This comes directly behind the previous one. Is this treated as the same name or a different one?
• Duplicate?
  
  [1/1] Installing mysql56-server-5.6.27...
  ===> Creating users and/or groups.
  Using existing group 'mysql'.
  Using existing user 'mysql'.
  [1/1] Extracting mysql56-server-5.6.27: 100%
  Message from mysql56-server-5.6.27:
  ************************************************************************
  
  Remember to run mysql_upgrade the first time you start the MySQL server
  after an upgrade from an earlier version.
  
  ************************************************************************
  === root@tiwi (/dev/pts/2) /home/grog 10 -> mysql_upgrade
  Looking for 'mysql' as: mysql
  Looking for 'mysqlcheck' as: mysqlcheck
  FATAL ERROR: Upgrade failed
  
  
  Needs to be running first.
  
  
  === root@tiwi (/dev/pts/2) /home/grog 15 -> mythtv-setup
  2016-01-14 13:34:36.438365 I  Setup Interrupt handler
  2016-01-14 13:34:36.438744 I  Setup Terminated handler
  2016-01-14 13:34:36.438785 I  Setup Segmentation fault handler
  2016-01-14 13:34:36.438813 I  Setup Abort trap handler
  2016-01-14 13:34:36.438833 I  Setup Bus error handler
  2016-01-14 13:34:36.438851 I  Setup Floating point exception handler
  2016-01-14 13:34:36.438871 I  Setup Illegal instruction handler
  2016-01-14 13:34:36.438896 I  Setup Unknown signal: 65 handler
  2016-01-14 13:34:36.450840 C  mythtv-setup version:  [5a5e1cd] www.mythtv.org
  2016-01-14 13:34:36.450862 C  Qt version: compile: 4.8.7, runtime: 4.8.7
  2016-01-14 13:34:36.450871 N  Enabled verbose msgs:  general
  2016-01-14 13:34:36.450912 N  Setting Log Level to LOG_INFO
  2016-01-14 13:34:36.460448 I  Added logging to the console
  2016-01-14 13:34:36.488243 N  Using runtime prefix = /usr/local
  2016-01-14 13:34:36.488289 N  Using configuration directory = /root/.mythtv
  2016-01-14 13:34:36.512876 I  Assumed character encoding:
  2016-01-14 13:34:36.512928 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 13:34:36.765758 N  Empty LocalHostName.
  2016-01-14 13:34:36.765899 I  Using localhost value of tiwi.lemis.com
  2016-01-14 13:34:36.924758 I  Starting mythlogserver
  2016-01-14 13:34:36.939118 I  Starting process manager
  2016-01-14 13:34:36.939330 I  Starting process signal handler
  2016-01-14 13:34:36.939670 I  Starting IO manager (read)
  2016-01-14 13:34:36.939892 I  Starting IO manager (write)
  2016-01-14 13:34:36.999450 N  Setting QT default locale to en_AU
  2016-01-14 13:34:36.999594 I  Current locale en_AU
  2016-01-14 13:34:37.041614 E  No locale defaults file for en_AU, skipping
  2016-01-14 13:34:37.169305 I  ScreenSaverX11Private: DPMS is active.
  2016-01-14 13:34:37.378751 N  Desktop video mode: 2560x1440 59.951 Hz
  2016-01-14 13:34:37.562760 I  Added logging to mythlogserver at TCP:35327
  2016-01-14 13:34:37.891468 I  Loading en_gb translation for module mythfrontend
  2016-01-14 13:34:37.914812 E  LIRC: Failed to connect to Unix socket '/var/run/lirc/lircd'
                          eno: No such file or directory (2)
  2016-01-14 13:34:37.916759 I  UDPListener: Enabling
  2016-01-14 13:34:37.948796 I  Binding to UDP 127.0.0.1:0
  2016-01-14 13:34:37.953348 E  Failed binding to UDP [fe80::221:86ff:fe21:ab7e%em0]:0 - Error 9: The address is not available
  2016-01-14 13:34:37.953421 E  Address [fe80::221:86ff:fe21:ab7e%em0] no longer exists - ignoring
  2016-01-14 13:34:37.953570 I  Binding to UDP [::1]:0
  2016-01-14 13:34:37.953667 I  Binding to UDP [fe80::1%lo0]:0
  2016-01-14 13:34:38.018530 I  Using Frameless Window
  2016-01-14 13:34:38.020007 I  Using Full Screen Window
  2016-01-14 13:34:38.053763 I  Using the Qt painter
  2016-01-14 13:34:39.875395 I  MythUIWebBrowser: Loading css from - file:///usr/local/share/mythtv/themes/default/htmls/mythbrowser.css
  2016-01-14 13:34:39.892620 E  MythUIWebBrowser: failed to find our parent screen
  2016-01-14 13:34:39.894514 I  MythUIWebBrowser: enabling plugins
  2016-01-14 13:34:40.010403 E  MySQL time zone support is missing.  Please install it and try again.  See 'mysql_tzinfo_to_sql' for assistance.
  
  
  
  === root@tiwi (/dev/pts/2) /home/grog 29 -> pkg install mythplugin-mythweb
  Updating FreeBSD repository catalogue...
  Fetching meta.txz: 100%    944 B   0.9kB/s    00:01
  Fetching packagesite.txz: 100%    5 MiB 397.0kB/s    00:14
  Processing entries: 100%
  FreeBSD repository update completed. 24761 packages processed.
  The following 6 package(s) will be affected (of 0 checked):
  
  New packages to be INSTALLED:
          mythplugin-mythweb: 0.27.5
          php56-session: 5.6.17
          php56: 5.6.17
          php56-json: 5.6.17
          php56-mysql: 5.6.17
          php56-posix: 5.6.17
  
  The process will require 20 MiB more space.
  3 MiB to be downloaded.
  
  Proceed with this action? [y/N]: y
  Fetching mythplugin-mythweb-0.27.5.txz: 100%  977 KiB 142.9kB/s    00:07
  Fetching php56-session-5.6.17.txz: 100%   30 KiB  30.5kB/s    00:01
  Fetching php56-5.6.17.txz: 100%    2 MiB 201.0kB/s    00:10
  Fetching php56-json-5.6.17.txz: 100%   16 KiB  16.5kB/s    00:01
  Fetching php56-mysql-5.6.17.txz: 100%   17 KiB  17.5kB/s    00:01
  Fetching php56-posix-5.6.17.txz: 100%   11 KiB  10.9kB/s    00:01
  Checking integrity... done (1 conflicting)
  Checking integrity... done (0 conflicting)
  Conflicts with the existing packages have been found.
  One more solver iteration is needed to resolve them.
  The following 8 package(s) will be affected (of 0 checked):
  
  Installed packages to be REMOVED:
          mod_php5-5.4.45,1
          php5-5.4.45
  
  New packages to be INSTALLED:
          php56: 5.6.17
          php56-session: 5.6.17
          php56-json: 5.6.17
          php56-mysql: 5.6.17
          php56-posix: 5.6.17
          mythplugin-mythweb: 0.27.5
  
  The process will require 2 MiB more space.
  
  Proceed with this action? [y/N]:
  Message from mythplugin-mythweb-0.27.5:
  mythweb has been installed into:
  
      /usr/local/www/mythweb
  
  You need to configure mythweb now according to the instructions in
  
      /usr/local/www/mythweb/INSTALL
  
  For lighttpd you should have a look at the MythTV Wiki
  
      http://www.mythtv.org/wiki/MythWeb_on_Lighttpd