tv - MythTV listings machine

guest os: FreeBSD/amd64

cpu: 2

memory size 1536 MB (was: 1024 MB)

storage: file - 6 GB

tmux commands: ls - list session, attach - t ,

tmux keys: ctrl-B command key, ctrl-b i information, ctrl-b t time, ctrl-b d detach,

back to virtual machines page.

History

This machine was originally named bhyve_bvm3.

Work log

2021-05-20: tv - set up a crontab entry for running mythfilldatabase

tingo@tv$ crontab -l
LANG=en_US.UTF-8
58 06 * * * /usr/local/bin/mythfilldatabase --refresh 0-25

ok.

2020-06-21: bvm3 - it gets renamed to 'tv' as I switch to vm-bhyve

root@kg-vm3# l -dF bvm3
bvm3/
root@kg-vm3# mv bvm3 tv
root@kg-vm3# ls -dF tv
tv/

add config file

root@kg-vm3# more tv/tv.conf
loader="bhyveload"
cpu="2"
memory="1536M"
network0_type="virtio-net"
network0_switch="public"
disk0_type="virtio-blk"
disk0_name="guest-bvm3.img"

and it works

root@kg-vm3# vm list
NAME  DATASTORE  LOADER     CPU  MEMORY  VNC  AUTOSTART  STATE
tv    default    bhyveload  2    1536M   -    No         Running (9278)
wiki  default    bhyveload  2    1024M   -    No         Running (8672)

ok

2019-08-06: bvm3 - pkg - upgrade

Aug  6 20:34:38 tv pkg: pkg upgraded: 1.8.7_1 -> 1.10.5_5
Aug  6 20:36:00 tv pkg: ca_root_nss upgraded: 3.26 -> 3.40

ok.

2017-04-21: bvm3 - mythfilldatabase - I still run this manually, like so

tingo@tv$ mythfilldatabase --refresh 0-20
2017-04-21 18:27:43.594557 C  mythfilldatabase version: tag: v0.27.5 [ad97d24] www.mythtv.org
2017-04-21 18:27:43.595350 C  Qt version: compile: 4.8.7, runtime: 4.8.7
2017-04-21 18:27:43.595471 N  Enabled verbose msgs:  general
2017-04-21 18:27:43.595688 N  Setting Log Level to LOG_INFO
2017-04-21 18:27:43.615923 I  Added logging to the console
2017-04-21 18:27:43.621261 I  Setup Interrupt handler
2017-04-21 18:27:43.621446 I  Setup Terminated handler
2017-04-21 18:27:43.621610 I  Setup Segmentation fault handler
2017-04-21 18:27:43.621710 I  Setup Abort trap handler
2017-04-21 18:27:43.621837 I  Setup Bus error handler
2017-04-21 18:27:43.621970 I  Setup Floating point exception handler
2017-04-21 18:27:43.622206 I  Setup Illegal instruction handler
2017-04-21 18:27:43.622369 I  Setup Unknown signal: 65 handler
2017-04-21 18:27:43.622832 N  Using runtime prefix = /usr/local
2017-04-21 18:27:43.623015 N  Using configuration directory = /home/tingo/.mythtv
2017-04-21 18:27:43.624407 I  Assumed character encoding:
2017-04-21 18:27:43.624655 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').
2017-04-21 18:27:43.628696 N  Empty LocalHostName.
2017-04-21 18:27:43.628924 I  Using localhost value of tv.kg4.no
2017-04-21 18:27:43.748826 N  Setting QT default locale to en_US
2017-04-21 18:27:43.749732 I  Current locale en_US
2017-04-21 18:27:43.750861 N  Reading locale defaults from /usr/local/share/mythtv//locales/en_us.xml
2017-04-21 18:27:43.754687 I  New Client:  (#1)
2017-04-21 18:27:43.826901 I  Loading en_us translation for module mythfrontend
2017-04-21 18:27:43.849147 I  Current MythTV Schema Version (DBSchemaVer): 1317
2017-04-21 18:27:43.888299 I  MythCoreContext: Connecting to backend server: 10.1.150.41:6543 (try 1 of 1)
2017-04-21 18:27:43.904516 I  Using protocol version 77
2017-04-21 18:27:43.909875 I  Opening blocking connection to master backend
2017-04-21 18:27:45.541332 I  Updating source #1 (Get-TV) with grabber tv_grab_no_gfeed
2017-04-21 18:27:45.544707 I  Found 35 channels for source 1 which use grabber
2017-04-21 18:27:45.547974 I  Starting process manager
2017-04-21 18:27:45.548894 I  Starting IO manager (read)
2017-04-21 18:27:45.561990 I  Starting IO manager (write)
2017-04-21 18:27:45.564539 I  Starting process signal handler
2017-04-21 18:27:48.953404 I  Grabber has capabilities: baseline manualconfig tkconfig apiconfig cache
2017-04-21 18:27:48.954363 I 
2017-04-21 18:27:48.954482 I  Checking day @ offset 0, date: Fri Apr 21 2017
2017-04-21 18:27:48.954576 I  Data Refresh needed because of user request
2017-04-21 18:27:48.954643 N  Refreshing data for Fri Apr 21 2017
2017-04-21 18:27:48.958755 I  XMLTV config file is: /home/tingo/.mythtv/Get-TV.xmltv
2017-04-21 18:28:24.126369 I  Updated programs: 290 Unchanged programs: 912
[...]
2017-04-21 18:47:37.973256 I  Checking day @ offset 20, date: Thu May 11 2017
2017-04-21 18:47:37.973358 I  Data Refresh needed because of user request
2017-04-21 18:47:37.973430 N  Refreshing data for Thu May 11 2017
2017-04-21 18:47:37.978315 I  XMLTV config file is: /home/tingo/.mythtv/Get-TV.xmltv
2017-04-21 18:48:37.664799 I  Updated programs: 900 Unchanged programs: 0
2017-04-21 18:48:40.498361 N  Data fetching complete.
2017-04-21 18:48:40.498588 I  Adjusting program database end times.
2017-04-21 18:48:40.501200 I      0 replacements made
2017-04-21 18:48:40.501268 I  Marking generic episodes.
2017-04-21 18:48:47.423769 I      Found 1647
2017-04-21 18:48:47.423874 I  Extending non-unique programids with multiple parts.
2017-04-21 18:48:48.284826 I      Found 0
2017-04-21 18:48:48.284936 I  Fixing missing original airdates.
2017-04-21 18:48:50.125608 I      Found 0 with programids
2017-04-21 18:48:50.919837 I      Found 0 without programids
2017-04-21 18:48:50.919955 I  Marking repeats.
2017-04-21 18:48:57.592407 I      Found 0
2017-04-21 18:48:57.592552 I  Unmarking new episode rebroadcast repeats.
2017-04-21 18:48:57.596116 I      Found 0
2017-04-21 18:49:06.687883 I  Marking episode first showings.
2017-04-21 18:49:20.934579 I      Found 17962
2017-04-21 18:49:20.934690 I  Marking episode last showings.
2017-04-21 18:49:36.826189 I      Found 17959
2017-04-21 18:49:36.835298 I 
===============================================================
| Attempting to contact the master backend for rescheduling.  |
| If the master is not running, rescheduling will happen when |
| the master backend is restarted.                            |
===============================================================
2017-04-21 18:49:36.847303 N  mythfilldatabase run complete.
2017-04-21 18:49:36.854739 I  Waiting for threads to exit.

ok.

2016-11-08: bvm3 - mythfilldatabase I ran mythtv-setup -w -geometry 1600x970 and changed from 'mythfilldatabase' to '/usr/local/bin/mythtfilldatabase' in General settings. We shall see if that makes mythfilldatabase run automatically.

2016-10-18: bvm3 - mythfilldatabase - running it manually as root doing 'mythfilldatabase' works. So why doesn't it work from within mythbackend?

2016-10-16: bvm3 - mythtv / mythweb - channel icons: they are supposed to be in ~/.mythtv/channels, but root has none:

root@tv# ll .mythtv/channels
total 8
drwxr-xr-x  2 root  wheel  512 Oct  2 01:57 ./
drwxr-xr-x  8 root  wheel  512 Oct 16 14:03 ../

so copy from my user:

root@tv# cp -pv /home/tingo/.mythtv/channels/* ~/.mythtv/channels/
/home/tingo/.mythtv/channels/bliss.tv2.no.png -> /root/.mythtv/channels/bliss.tv2.no.png
/home/tingo/.mythtv/channels/cnn.com.png -> /root/.mythtv/channels/cnn.com.png
/home/tingo/.mythtv/channels/cnn_international_lam.png -> /root/.mythtv/channels/cnn_international_lam.png
/home/tingo/.mythtv/channels/comedycentral.no.png -> /root/.mythtv/channels/comedycentral.no.png
/home/tingo/.mythtv/channels/discovery.no.png -> /root/.mythtv/channels/discovery.no.png
/home/tingo/.mythtv/channels/discovery_global_us.png -> /root/.mythtv/channels/discovery_global_us.png
/home/tingo/.mythtv/channels/disney_channel_global_hd.png -> /root/.mythtv/channels/disney_channel_global_hd.png
/home/tingo/.mythtv/channels/disneychannel.no.png -> /root/.mythtv/channels/disneychannel.no.png
/home/tingo/.mythtv/channels/en.tlc.discovery.no.png -> /root/.mythtv/channels/en.tlc.discovery.no.png
/home/tingo/.mythtv/channels/euronews.com.png -> /root/.mythtv/channels/euronews.com.png
/home/tingo/.mythtv/channels/europe.cnbc.com.png -> /root/.mythtv/channels/europe.cnbc.com.png
/home/tingo/.mythtv/channels/fem.no.png -> /root/.mythtv/channels/fem.no.png
/home/tingo/.mythtv/channels/fem_no.png -> /root/.mythtv/channels/fem_no.png
/home/tingo/.mythtv/channels/fox.fi.png -> /root/.mythtv/channels/fox.fi.png
/home/tingo/.mythtv/channels/fox_global.png -> /root/.mythtv/channels/fox_global.png
/home/tingo/.mythtv/channels/foxtv.no.png -> /root/.mythtv/channels/foxtv.no.png
/home/tingo/.mythtv/channels/humor.tv2.no.png -> /root/.mythtv/channels/humor.tv2.no.png
/home/tingo/.mythtv/channels/max.no.png -> /root/.mythtv/channels/max.no.png
/home/tingo/.mythtv/channels/max_no.png -> /root/.mythtv/channels/max_no.png
/home/tingo/.mythtv/channels/motorstv.com.png -> /root/.mythtv/channels/motorstv.com.png
/home/tingo/.mythtv/channels/natgeo.no.png -> /root/.mythtv/channels/natgeo.no.png
/home/tingo/.mythtv/channels/news.tv2.no.png -> /root/.mythtv/channels/news.tv2.no.png
/home/tingo/.mythtv/channels/nickelodeon.no.png -> /root/.mythtv/channels/nickelodeon.no.png
/home/tingo/.mythtv/channels/no.bbcentertainment.no.png -> /root/.mythtv/channels/no.bbcentertainment.no.png
/home/tingo/.mythtv/channels/no.tcmeurope.com.png -> /root/.mythtv/channels/no.tcmeurope.com.png
/home/tingo/.mythtv/channels/nrk1.nrk.no.png -> /root/.mythtv/channels/nrk1.nrk.no.png
/home/tingo/.mythtv/channels/nrk1.png -> /root/.mythtv/channels/nrk1.png
/home/tingo/.mythtv/channels/nrk2.nrk.no.png -> /root/.mythtv/channels/nrk2.nrk.no.png
/home/tingo/.mythtv/channels/nrk2.png -> /root/.mythtv/channels/nrk2.png
/home/tingo/.mythtv/channels/nrk3.nrk.no.png -> /root/.mythtv/channels/nrk3.nrk.no.png
/home/tingo/.mythtv/channels/nrk3super.nrk.no.png -> /root/.mythtv/channels/nrk3super.nrk.no.png
/home/tingo/.mythtv/channels/svt1hd.svt.se.png -> /root/.mythtv/channels/svt1hd.svt.se.png
/home/tingo/.mythtv/channels/svt2hd.svt.se.png -> /root/.mythtv/channels/svt2hd.svt.se.png
/home/tingo/.mythtv/channels/tcm_global.png -> /root/.mythtv/channels/tcm_global.png
/home/tingo/.mythtv/channels/tlc.discovery.no.png -> /root/.mythtv/channels/tlc.discovery.no.png
/home/tingo/.mythtv/channels/tlc_us.png -> /root/.mythtv/channels/tlc_us.png
/home/tingo/.mythtv/channels/tnt-tv.no.png -> /root/.mythtv/channels/tnt-tv.no.png
/home/tingo/.mythtv/channels/travelchanneltv.eu.png -> /root/.mythtv/channels/travelchanneltv.eu.png
/home/tingo/.mythtv/channels/tv2.no.png -> /root/.mythtv/channels/tv2.no.png
/home/tingo/.mythtv/channels/tv2_no.png -> /root/.mythtv/channels/tv2_no.png
/home/tingo/.mythtv/channels/tv2_nyhets_kanalen_no.png -> /root/.mythtv/channels/tv2_nyhets_kanalen_no.png
/home/tingo/.mythtv/channels/tv2_zebra.png -> /root/.mythtv/channels/tv2_zebra.png
/home/tingo/.mythtv/channels/tv3.no.png -> /root/.mythtv/channels/tv3.no.png
/home/tingo/.mythtv/channels/tv4.se.png -> /root/.mythtv/channels/tv4.se.png
/home/tingo/.mythtv/channels/tv4_hd.png -> /root/.mythtv/channels/tv4_hd.png
/home/tingo/.mythtv/channels/tv6norge.no.png -> /root/.mythtv/channels/tv6norge.no.png
/home/tingo/.mythtv/channels/tvnorge.no.png -> /root/.mythtv/channels/tvnorge.no.png
/home/tingo/.mythtv/channels/vh1.no.png -> /root/.mythtv/channels/vh1.no.png
/home/tingo/.mythtv/channels/vh1_hd.png -> /root/.mythtv/channels/vh1_hd.png
/home/tingo/.mythtv/channels/viasat4.no.png -> /root/.mythtv/channels/viasat4.no.png
/home/tingo/.mythtv/channels/viasat_tv3_no.png -> /root/.mythtv/channels/viasat_tv3_no.png
/home/tingo/.mythtv/channels/viasat_tv4_no.png -> /root/.mythtv/channels/viasat_tv4_no.png
/home/tingo/.mythtv/channels/viasat_tv6_se.png -> /root/.mythtv/channels/viasat_tv6_se.png
/home/tingo/.mythtv/channels/vox_no.png -> /root/.mythtv/channels/vox_no.png
/home/tingo/.mythtv/channels/voxtv.no.png -> /root/.mythtv/channels/voxtv.no.png
/home/tingo/.mythtv/channels/xd.disneychannel.no.png -> /root/.mythtv/channels/xd.disneychannel.no.png
/home/tingo/.mythtv/channels/zebra.tv2.no.png -> /root/.mythtv/channels/zebra.tv2.no.png

fix ownership

root@tv# chown root ~/.mythtv/channels/*

ok, that worked. Nice.

2016-10-16: bvm3 - mythfilldatabase - it is setup to run in mythtv-setup, but didn't according to the status page. Since mythbackend runs as root, it probably needs config files. Fix that.

root@tv# cp -pv /home/tingo/.xmltv/tv_grab_no_gfeed.conf ~/.xmltv/
/home/tingo/.xmltv/tv_grab_no_gfeed.conf -> /root/.xmltv/tv_grab_no_gfeed.conf
root@tv# chown root /root/.xmltv/tv_grab_no_gfeed.conf
root@tv# ln -s /root/.xmltv/tv_grab_no_gfeed.conf ~/.mythtv/Get-TV.xmltv

perhaps that is enough.

2016-10-16: bvm3 - I'm going to run mythtv-setup again to change a few settings, and get this when I do 'ssh -X tv':

tingo@kg-core1$ ssh -X tv
Password for tingo@tv.kg4.no:
Warning: untrusted X11 forwarding setup failed: xauth key data not generated
Warning: No xauth data; using fake authentication data for X11 forwarding.
Last login: Sat Oct  8 11:50:39 2016 from kg-core1.kg4.no
FreeBSD 10.3-RELEASE-p7 (GENERIC) #0: Thu Aug 11 18:38:15 UTC 2016

that's ... interesting. Try mythv-setup:

tingo@tv$ mythtv-setup -w -geometry 1600x970

yes, that works.

In Settings, General, I changed: Local backend, IPv4 address: 127.0.0.1 -> 10.1.150.41 (it doesn't allow me to enter a hostname ('tv') here) Master backend, IP address: 127.0.0.1 -> 'tv' (here I can enter at hostname). Then I just used Next until I could Finish, then Escape to exit.

Restart mythbackend:

root@tv# service mythbackend restart
Stopping mythbackend.
Waiting for PIDS: 718.
Starting mythbackend.

verify that mythbackend now listens on external ip address:

root@tv# sockstat -4l | grep myth
root     mythbacken 27226 26 tcp4   10.1.150.41:6544      *:*
root     mythbacken 27226 27 tcp4   127.0.0.1:6544        *:*
root     mythbacken 27226 30 udp4   *:6549                *:*
root     mythbacken 27226 32 udp4   239.255.255.250:1900  *:*
root     mythbacken 27226 33 udp4   *:*                   *:*
root     mythbacken 27226 41 tcp4   10.1.150.41:6543      *:*
root     mythbacken 27226 42 tcp4   127.0.0.1:6543        *:*

it does. And now I can connect to http://tv:6544/ for the status page (and more) - nice.

2016-10-02: bvm3 - memory - 1024 MB was to small, so I changed it to 1.5 GB:

root@kg-vm3# sysrc bhyve_bvm3_memsize
bhyve_bvm3_memsize: 1536

ok.

stop the machine:

root@kg-vm3# service bhyve stop bvm3

verify:

root@kg-vm3# service bhyve status
===> bhyve profile: bvm1
bhyve_bvm1 is running.
===> bhyve profile: bvm2
bhyve_bvm2 is running.
===> bhyve profile: bvm3
bhyve_bvm3 is not running.

but

root@kg-vm3# echo "bhyve vms:";ls -l /dev/vmm
bhyve vms:
total 0
crw-------  1 root  wheel  0x55 Sep 30 14:23 bhyve_bvm1
crw-------  1 root  wheel  0x5c Sep 30 14:23 bhyve_bvm2
crw-------  1 root  wheel  0x60 Sep 30 23:13 bhyve_bvm3

hmm... tmux also says only two sessions

root@kg-vm3# tmux ls
bhyve_bvm1: 1 windows (created Fri Sep 30 14:23:23 2016) [80x23]
bhyve_bvm2: 1 windows (created Fri Sep 30 14:23:23 2016) [80x23]

ok, start the machine again:

root@kg-vm3# service bhyve start bvm3
Starting bhyve.
root@kg-vm3# service bhyve status
===> bhyve profile: bvm1
bhyve_bvm1 is running.
===> bhyve profile: bvm2
bhyve_bvm2 is running.
===> bhyve profile: bvm3
bhyve_bvm3 is running.

ok, looks better now:

root@kg-vm3# echo "bhyve vms:";ls -l /dev/vmm
bhyve vms:
total 0
crw-------  1 root  wheel  0x55 Sep 30 14:23 bhyve_bvm1
crw-------  1 root  wheel  0x5c Sep 30 14:23 bhyve_bvm2
crw-------  1 root  wheel  0x61 Oct  2 11:09 bhyve_bvm3
root@kg-vm3# tmux ls
bhyve_bvm1: 1 windows (created Fri Sep 30 14:23:23 2016) [80x23]
bhyve_bvm2: 1 windows (created Fri Sep 30 14:23:23 2016) [80x23]
bhyve_bvm3: 1 windows (created Sun Oct  2 11:09:50 2016) [117x62]

ok.

2016-10-01: bvm3 - pkg - install mod_php56 too. It works better that way

root@tv# pkg install mod_php56
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:
    mod_php56: 5.6.26

Number of packages to be installed: 1

The process will require 4 MiB more space.
1 MiB to be downloaded.

Proceed with this action? [y/N]: y
Fetching mod_php56-5.6.26.txz: 100%    1 MiB   1.1MB/s    00:01   
Checking integrity... done (0 conflicting)
[1/1] Installing mod_php56-5.6.26...
[1/1] Extracting mod_php56-5.6.26: 100%
[activating module 'php5' in /usr/local/etc/apache24/httpd.conf]
Message from mod_php56-5.6.26:
***************************************************************

Make sure index.php is part of your DirectoryIndex.

You should add the following to your Apache configuration file:

<FilesMatch "\.php$">
    SetHandler application/x-httpd-php
</FilesMatch>
<FilesMatch "\.phps$">
    SetHandler application/x-httpd-php-source
</FilesMatch>

***************************************************************

ok.

2016-10-01: bvm3 - set up mythweb:

root@tv# cp -pv /usr/local/www/mythweb/mythweb.conf.apache /usr/local/etc/apache24/Includes/mythweb.conf
/usr/local/www/mythweb/mythweb.conf.apache -> /usr/local/etc/apache24/Includes/mythweb.conf

and then fix the errors that crop up.

2016-10-01: bvm3 - pkg - install mythweb:

root@tv# pkg install mythplugin-mythweb
Updating FreeBSD repository catalogue...
FreeBSD repository is up-to-date.
All repositories are up-to-date.
The following 9 package(s) will be affected (of 0 checked):

New packages to be INSTALLED:
    mythplugin-mythweb: 0.27.5
    apache24: 2.4.23_1
    apr: 1.5.2.1.5.4_1
    db5: 5.3.28_4
    php56-session: 5.6.26
    php56: 5.6.26
    php56-json: 5.6.26
    php56-mysql: 5.6.26
    php56-posix: 5.6.26

Number of packages to be installed: 9

The process will require 96 MiB more space.
20 MiB to be downloaded.

Proceed with this action? [y/N]: y
[...]
Message from apache24-2.4.23_1:
To run apache www server from startup, add apache24_enable="yes"
in your /etc/rc.conf. Extra options can be found in startup script.

Your hostname must be resolvable using at least 1 mechanism in
/etc/nsswitch.conf typically DNS or /etc/hosts or apache might
have issues starting depending on the modules you are using.

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

- apache24 default build changed from static MPM to modular MPM
- more modules are now enabled per default in the port
- icons and error pages moved from WWWDIR to DATADIR

   If build with modular MPM and no MPM is activated in
   httpd.conf, then mpm_prefork will be activated as default
   MPM in etc/apache24/modules.d to keep compatibility with
   existing php/perl/python modules!

Please compare the existing httpd.conf with httpd.conf.sample
and merge missing modules/instructions into httpd.conf!

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
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

ok.

2016-10-01: bvm3 - mythtv-setup - it requires Xorg to run. So do a ssh -X tv from another host to enable X forwarding, then start mythtv-setup like this

$ mythtv-setup -w -geometry 1200x950

ok.

2016-10-01: bvm3 - try mythbackend again:

root@tv# mythbackend
2016-10-01 19:31:02.357624 C  mythbackend version: tag: v0.27.5 [ad97d24] www.mythtv.org
2016-10-01 19:31:02.358594 C  Qt version: compile: 4.8.7, runtime: 4.8.7
2016-10-01 19:31:02.358730 N  Enabled verbose msgs:  general
2016-10-01 19:31:02.358984 N  Setting Log Level to LOG_INFO
2016-10-01 19:31:02.383356 I  Added logging to the console
2016-10-01 19:31:02.389598 I  Setup Interrupt handler
2016-10-01 19:31:02.389795 I  Setup Terminated handler
2016-10-01 19:31:02.389993 I  Setup Segmentation fault handler
2016-10-01 19:31:02.390201 I  Setup Abort trap handler
2016-10-01 19:31:02.390335 I  Setup Bus error handler
2016-10-01 19:31:02.390489 I  Setup Floating point exception handler
2016-10-01 19:31:02.390653 I  Setup Illegal instruction handler
2016-10-01 19:31:02.390840 I  Setup Unknown signal: 65 handler
2016-10-01 19:31:02.391526 N  Using runtime prefix = /usr/local
2016-10-01 19:31:02.391735 N  Using configuration directory = /root/.mythtv
2016-10-01 19:31:02.395295 I  Assumed character encoding:
2016-10-01 19:31:02.395584 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-10-01 19:31:02.400500 E  DBHostName is not set in config.xml
2016-10-01 19:31:02.400776 E  DBHostName is not set in config.xml
2016-10-01 19:31:02.401280 N  Empty LocalHostName.
2016-10-01 19:31:02.401525 I  Using localhost value of tv.kg4.no
2016-10-01 19:31:02.537608 N  Setting QT default locale to en_US
2016-10-01 19:31:02.540395 I  New Client:  (#1)
2016-10-01 19:31:02.542722 I  Current locale en_US
2016-10-01 19:31:02.543989 N  Reading locale defaults from /usr/local/share/mythtv//locales/en_us.xml
2016-10-01 19:31:02.548969 E  SaveSettingOnHost('Country') - No database yet
2016-10-01 19:31:02.549700 E  SaveSettingOnHost('FreqTable') - No database yet
2016-10-01 19:31:02.549813 E  SaveSettingOnHost('ISO639Language0') - No database yet
2016-10-01 19:31:02.549933 E  SaveSettingOnHost('ISO639Language1') - No database yet
2016-10-01 19:31:02.550028 E  SaveSettingOnHost('Language') - No database yet
2016-10-01 19:31:02.550462 E  SaveSettingOnHost('TVFormat') - No database yet
2016-10-01 19:31:02.550581 E  SaveSettingOnHost('VbiFormat') - No database yet
2016-10-01 19:31:02.551065 E  SaveSettingOnHost('DateFormat') - No database yet
2016-10-01 19:31:02.551306 E  SaveSettingOnHost('MythArchiveDateFormat') - No database yet
2016-10-01 19:31:02.551447 E  SaveSettingOnHost('MythArchiveTimeFormat') - No database yet
2016-10-01 19:31:02.551558 E  SaveSettingOnHost('MythArchiveVideoFormat') - No database yet
2016-10-01 19:31:02.551686 E  SaveSettingOnHost('ShortDateFormat') - No database yet
2016-10-01 19:31:02.551796 E  SaveSettingOnHost('TimeFormat') - No database yet
2016-10-01 19:31:02.585263 E  Error preparing query: SELECT data FROM settings WHERE value = :VALUE AND hostname = :HOSTNAME
2016-10-01 19:31:02.585481 E  Driver error was [2/1146]:
QMYSQL3: Unable to prepare statement
Database error was:
Table 'mythconverg.settings' doesn't exist

2016-10-01 19:31:02.590193 E  Error preparing query: SELECT data FROM settings WHERE value = :VALUE AND hostname = :HOSTNAME
2016-10-01 19:31:02.590352 E  Driver error was [2/1146]:
QMYSQL3: Unable to prepare statement
Database error was:
Table 'mythconverg.settings' doesn't exist

2016-10-01 19:31:02.593827 I  No current database version?
2016-10-01 19:31:02.595961 I  Database appears to be empty/new!
2016-10-01 19:31:02.597338 W  Not allowed to upgrade the database.
2016-10-01 19:31:02.614282 N  Inserting MythTV initial database information.
2016-10-01 19:31:02.614513 C  Upgrading to MythTV schema version 1307
2016-10-01 19:31:03.490920 C  Upgrading to MythTV schema version 1308
2016-10-01 19:31:03.507803 C  Upgrading to MythTV schema version 1309
2016-10-01 19:31:03.522724 C  Upgrading to MythTV schema version 1310
2016-10-01 19:31:03.528068 C  Upgrading to MythTV schema version 1311
2016-10-01 19:31:03.546291 C  Upgrading to MythTV schema version 1312
2016-10-01 19:31:03.556907 C  Upgrading to MythTV schema version 1313
2016-10-01 19:31:03.575452 C  Upgrading to MythTV schema version 1314
2016-10-01 19:31:03.589429 C  Upgrading to MythTV schema version 1315
2016-10-01 19:31:03.595915 C  Upgrading to MythTV schema version 1316
2016-10-01 19:31:03.637333 C  Upgrading to MythTV schema version 1317
No setting found for this machine's BackendServerIP.
Please run setup on this machine and modify the first page
of the general settings.
2016-10-01 19:31:03.767708 I  Database schema upgrade complete.
2016-10-01 19:31:03.780428 I  Loading en_us translation for module mythfrontend
2016-10-01 19:31:03.820943 E  No address defined for host: localhost
2016-10-01 19:31:03.829661 E  MythSocket(812d09600:-1): Failed to connect to (127.0.0.1:6543) Connection refused
2016-10-01 19:31:03.841962 E  No address defined for host: tv.kg4.no

more troubles.

2016-10-01: bvm3 - pkg - install qt4-script:

root@tv# pkg install qt4-script
Updating FreeBSD repository catalogue...
FreeBSD repository is up-to-date.
All repositories are up-to-date.
Updating database digests format: 100%
The following 144 package(s) will be affected (of 0 checked):

New packages to be INSTALLED:
    qt4-script: 4.8.7
    libedit: 3.1.20150325_2,1
    p5-xmltv: 0.5.67
    p5-IO-Compress: 2.069
    p5-Compress-Raw-Bzip2: 2.069
    p5-Compress-Raw-Zlib: 2.069
    p5-TimeDate: 2.30_2,1
    p5-DateTime: 1.28
    p5-Try-Tiny: 0.24
    p5-DateTime-TimeZone: 2.00
    p5-List-AllUtils: 0.10
    p5-List-SomeUtils: 0.52
    p5-List-SomeUtils-XS: 0.52
    p5-Module-Implementation: 0.09_1
    p5-Module-Runtime: 0.014_1
    p5-Exporter-Tiny: 0.042_1
    p5-Class-Singleton: 1.5_1
    p5-Params-Validate: 1.24
    p5-DateTime-Locale: 1.05
    p5-Dist-CheckConflicts: 0.11_1
    p5-Scalar-List-Utils: 1.45,1
    p5-SOAP-Lite: 1.20
    p5-IO-SessionData: 1.03_1
    p5-IO-Socket-SSL: 2.029
    p5-Net-SSLeay: 1.74
    p5-IO-Socket-IP: 0.37
    p5-Socket: 2.021
    p5-Mozilla-CA: 20160104
    p5-Task-Weaken: 1.04_1
    p5-URI: 1.71
    p5-LWP-Protocol-https: 6.06_1
    p5-Net-HTTP: 6.09
    p5-Class-Inspector: 1.28_1
    p5-libwww: 6.15
    p5-HTTP-Negotiate: 6.01_1
    p5-HTTP-Message: 6.11
    p5-Encode-Locale: 1.05
    p5-IO-HTML: 1.001_1
    p5-HTTP-Date: 6.02_1
    p5-LWP-MediaTypes: 6.02_1
    p5-HTTP-Daemon: 6.01_1
    p5-WWW-RobotRules: 6.02_1
    p5-HTTP-Cookies: 6.01_1
    p5-HTML-Parser: 3.72
    p5-HTML-Tagset: 3.20_1
    p5-Authen-NTLM: 1.09_1
    p5-Digest-HMAC: 1.03_1
    p5-File-Listing: 6.04_1
    p5-MIME-Tools: 5.507,2
    p5-Mail-Tools: 2.14
    p5-Convert-BinHex: 1.125
    p5-XML-Parser: 2.44
    p5-XML-Parser-Lite: 0.721
    p5-Unicode-String: 2.09_1
    p5-HTTP-Cache-Transparent: 1.1_1
    p5-HTML-TableExtract: 2.13
    p5-HTML-Element-Extended: 1.18_1
    p5-HTML-Tree: 5.03_1
    p5-Term-ProgressBar: 2.17
    p5-Term-ReadKey: 2.32_1
    p5-Class-MethodMaker: 2.24
    p5-Archive-Zip: 1.57
    p5-XML-LibXML: 2.0126,1
    p5-XML-NamespaceSupport: 1.11_1
    p5-XML-SAX: 0.99_2
    p5-XML-SAX-Base: 1.08_1
    p5-Unicode-UTF8simple: 1.06_1
    p5-Data-Dumper: 2.154_1
    p5-CGI: 4.31
    p5-XML-Twig: 3.49
    p5-Tie-IxHash: 1.23_1
    p5-Text-Iconv: 1.7_2
    p5-XML-XPath: 1.37
    p5-Tk-TableMatrix: 1.23_7
    p5-Tk: 804.033_1
    libXft: 2.3.2_1
    jpeg-turbo: 1.4.2
    p5-IO-stringy: 2.111
    p5-Date-Manip: 6.53
    p5-PerlIO-gzip: 0.19
    p5-WWW-Mechanize: 1.75
    p5-HTML-Form: 6.03_1
    p5-HTTP-Server-Simple: 0.51
    p5-Parse-RecDescent: 1.967.009_2
    p5-Lingua-EN-Numbers-Ordinate: 1.04
    p5-XML-Writer: 0.625_1
    p5-File-Slurp: 9999.19_1
    ja-p5-Text-Kakasi: 2.04_3
    ja-kakasi: 2.3.5_2
    p5-JSON: 2.90_1
    p5-DateTime-Format-Strptime: 1.68,1
    p5-Package-DeprecationManager: 0.15
    p5-Params-Util: 1.07_2
    p5-Package-Stash: 0.37_1
    p5-Package-Stash-XS: 0.28_1
    p5-Sub-Install: 0.928_1
    p5-Lingua-Preferred: 0.2.4_1
    p5-Log-TraceMessages: 1.4_1
    p5-HTML-FromText: 2.07_1
    p5-Email-Find: 0.10_1
    p5-Email-Valid: 1.192_1
    p5-Net-DNS: 1.06_2,1
    p5-Net-Domain-TLD: 1.74
    qt4-network: 4.8.7
    py27-urlgrabber: 3.9.1_3
    py27-pycurl: 7.21.5
    curl: 7.50.3
    p5-LWP-UserAgent-Determined: 1.07_1
    p5-Net-UPnP: 1.4.3
    p5-DBD-mysql: 4.033_1
    mysql56-client: 5.6.33
    libvdpau: 1.1.1
    qt4-mysql-plugin: 4.8.7_1
    qt4-sql: 4.8.7
    qt4-l10n: 4.8.7
    p5-HTTP-Request-Params: 1.02
    p5-Email-MIME-ContentType: 1.01.7_1
    p5-Class-Accessor: 0.34_1
    p5-Email-MIME: 1.937
    p5-MIME-Types: 2.13
    p5-Email-MessageID: 1.406
    p5-Email-Address: 1.90.8
    p5-Email-Simple: 2.210
    p5-Email-Date-Format: 1.005
    p5-Email-MIME-Encodings: 1.315_1
    p5-MIME-Base64: 3.15
    py27-MySQLdb: 1.2.5
    p5-IO-Socket-INET6: 2.72_1
    p5-Socket6: 0.27
    taglib: 1.10
    qt4-imageformats: 4.8.7
    libmng: 1.0.10_2
    lcms: 1.19_6,1
    tiff: 4.0.6_2
    jbigkit: 2.1_1
    qt4-svg: 4.8.7
    qt4-xml: 4.8.7
    wget: 1.18
    qt4-webkit: 4.8.7
    gstreamer-plugins: 0.10.36_6,3
    orc: 0.4.25
    gstreamer: 0.10.36_4
    qt4-declarative: 4.8.7
    qt4-xmlpatterns: 4.8.7

Number of packages to be installed: 144

The process will require 210 MiB more space.
32 MiB to be downloaded.

Proceed with this action? [y/N]: y
[...]
Checking integrity... done (2 conflicting)
  - mysql56-client-5.6.33 conflicts with mysql55-client-5.5.51 on /usr/local/bin/msql2mysql
  - mysql56-client-5.6.33 conflicts with mysql55-client-5.5.51 on /usr/local/bin/msql2mysql
Checking integrity... done (0 conflicting)
Conflicts with the existing packages have been found.
One more solver iteration is needed to resolve them.
The following 146 package(s) will be affected (of 0 checked):

Installed packages to be REMOVED:
    mysql55-server-5.5.51
    mysql55-client-5.5.51

New packages to be INSTALLED:
    p5-Socket: 2.021
    p5-TimeDate: 2.30_2,1
    p5-Try-Tiny: 0.24
    p5-Module-Runtime: 0.014_1
    p5-IO-Socket-IP: 0.37
    p5-Digest-HMAC: 1.03_1
    p5-List-SomeUtils-XS: 0.52
    p5-Module-Implementation: 0.09_1
    p5-Exporter-Tiny: 0.042_1
    p5-Mail-Tools: 2.14
    p5-Net-DNS: 1.06_2,1
    p5-Net-Domain-TLD: 1.74
    p5-List-SomeUtils: 0.52
    p5-Net-SSLeay: 1.74
    p5-Mozilla-CA: 20160104
    p5-URI: 1.71
    p5-Encode-Locale: 1.05
    p5-IO-HTML: 1.001_1
    p5-HTTP-Date: 6.02_1
    p5-LWP-MediaTypes: 6.02_1
    p5-HTML-Tagset: 3.20_1
    p5-Email-Valid: 1.192_1
    p5-List-AllUtils: 0.10
    p5-Class-Singleton: 1.5_1
    p5-Params-Validate: 1.24
    p5-Dist-CheckConflicts: 0.11_1
    p5-Scalar-List-Utils: 1.45,1
    p5-IO-Socket-SSL: 2.029
    p5-HTTP-Message: 6.11
    p5-HTML-Parser: 3.72
    jpeg-turbo: 1.4.2
    p5-Package-Stash-XS: 0.28_1
    p5-Email-Find: 0.10_1
    jbigkit: 2.1_1
    p5-DateTime-TimeZone: 2.00
    p5-DateTime-Locale: 1.05
    p5-Net-HTTP: 6.09
    p5-HTTP-Negotiate: 6.01_1
    p5-HTTP-Daemon: 6.01_1
    p5-WWW-RobotRules: 6.02_1
    p5-HTTP-Cookies: 6.01_1
    p5-Authen-NTLM: 1.09_1
    p5-File-Listing: 6.04_1
    p5-Convert-BinHex: 1.125
    p5-XML-Parser: 2.44
    p5-HTML-Tree: 5.03_1
    p5-XML-NamespaceSupport: 1.11_1
    p5-XML-SAX-Base: 1.08_1
    libXft: 2.3.2_1
    p5-Params-Util: 1.07_2
    p5-Package-Stash: 0.37_1
    p5-Sub-Install: 0.928_1
    p5-HTML-FromText: 2.07_1
    qt4-network: 4.8.7
    p5-Email-Address: 1.90.8
    p5-Email-Date-Format: 1.005
    p5-MIME-Base64: 3.15
    tiff: 4.0.6_2
    qt4-script: 4.8.7
    libedit: 3.1.20150325_2,1
    p5-Compress-Raw-Bzip2: 2.069
    p5-Compress-Raw-Zlib: 2.069
    p5-DateTime: 1.28
    p5-IO-SessionData: 1.03_1
    p5-Task-Weaken: 1.04_1
    p5-LWP-Protocol-https: 6.06_1
    p5-Class-Inspector: 1.28_1
    p5-libwww: 6.15
    p5-MIME-Tools: 5.507,2
    p5-XML-Parser-Lite: 0.721
    p5-HTML-Element-Extended: 1.18_1
    p5-Term-ReadKey: 2.32_1
    p5-Class-MethodMaker: 2.24
    p5-XML-SAX: 0.99_2
    p5-CGI: 4.31
    p5-Tie-IxHash: 1.23_1
    p5-Text-Iconv: 1.7_2
    p5-XML-XPath: 1.37
    p5-Tk: 804.033_1
    p5-HTML-Form: 6.03_1
    p5-HTTP-Server-Simple: 0.51
    ja-kakasi: 2.3.5_2
    p5-Package-DeprecationManager: 0.15
    p5-Log-TraceMessages: 1.4_1
    curl: 7.50.3
    qt4-sql: 4.8.7
    p5-Email-MIME-ContentType: 1.01.7_1
    p5-MIME-Types: 2.13
    p5-Email-MessageID: 1.406
    p5-Email-Simple: 2.210
    p5-Email-MIME-Encodings: 1.315_1
    lcms: 1.19_6,1
    qt4-svg: 4.8.7
    qt4-xml: 4.8.7
    orc: 0.4.25
    gstreamer: 0.10.36_4
    qt4-xmlpatterns: 4.8.7
    p5-IO-Compress: 2.069
    p5-SOAP-Lite: 1.20
    p5-Unicode-String: 2.09_1
    p5-HTTP-Cache-Transparent: 1.1_1
    p5-HTML-TableExtract: 2.13
    p5-Term-ProgressBar: 2.17
    p5-Archive-Zip: 1.57
    p5-XML-LibXML: 2.0126,1
    p5-Unicode-UTF8simple: 1.06_1
    p5-Data-Dumper: 2.154_1
    p5-XML-Twig: 3.49
    p5-Tk-TableMatrix: 1.23_7
    p5-IO-stringy: 2.111
    p5-Date-Manip: 6.53
    p5-PerlIO-gzip: 0.19
    p5-WWW-Mechanize: 1.75
    p5-Parse-RecDescent: 1.967.009_2
    p5-Lingua-EN-Numbers-Ordinate: 1.04
    p5-XML-Writer: 0.625_1
    p5-File-Slurp: 9999.19_1
    ja-p5-Text-Kakasi: 2.04_3
    p5-JSON: 2.90_1
    p5-DateTime-Format-Strptime: 1.68,1
    p5-Lingua-Preferred: 0.2.4_1
    py27-pycurl: 7.21.5
    mysql56-client: 5.6.33
    p5-Class-Accessor: 0.34_1
    p5-Email-MIME: 1.937
    p5-Socket6: 0.27
    libmng: 1.0.10_2
    gstreamer-plugins: 0.10.36_6,3
    qt4-declarative: 4.8.7
    p5-xmltv: 0.5.67
    py27-urlgrabber: 3.9.1_3
    p5-LWP-UserAgent-Determined: 1.07_1
    p5-Net-UPnP: 1.4.3
    p5-DBD-mysql: 4.033_1
    libvdpau: 1.1.1
    qt4-mysql-plugin: 4.8.7_1
    qt4-l10n: 4.8.7
    p5-HTTP-Request-Params: 1.02
    py27-MySQLdb: 1.2.5
    p5-IO-Socket-INET6: 2.72_1
    taglib: 1.10
    qt4-imageformats: 4.8.7
    wget: 1.18
    qt4-webkit: 4.8.7

Number of packages to be removed: 2
Number of packages to be installed: 144

The process will require 106 MiB more space.

Proceed with this action? [y/N]: y
Message from qt4-sql-4.8.7:
======================================================================

To enable Qt database support, install the database plugin ports. The
following plugin ports are available:
 - databases/qt4-ibase-plugin        InterBase/Firebird
 - databases/qt4-mysql-plugin        MySQL
 - databases/qt4-odbc-plugin        Open Database Connectivity
 - databases/qt4-pgsql-plugin        PostgreSQL
 - databases/qt4-sqlite-plugin        SQLite 2
 - databases/qt4-sqlite3-plugin        SQLite 3

======================================================================
Message from mysql56-client-5.6.33:
* * * * * * * * * * * * * * * * * * * * * * * *

Please be aware the database client is vulnerable
to CVE-2015-3152 - SSL Downgrade aka "BACKRONYM".
You may find more information at the following URL:

http://www.vuxml.org/freebsd/36bd352d-299b-11e5-86ff-14dae9d210b8.html

Although this database client is not listed as
"affected", it is vulnerable and will not be
receiving a patch. Please take note of this when
deploying this software.

* * * * * * * * * * * * * * * * * * * * * * * *

So I get to redo the the database steps again - great. Not.

root@tv# pkg info my*
mysql56-client-5.6.33
mythtv-0.27.5.20150616_1

it has MySQL client installed, but not server.

root@tv# pkg install mysql56-server
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.33

Number of packages to be installed: 1

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.33.txz: 100%    8 MiB   4.3MB/s    00:02   
Checking integrity... done (0 conflicting)
[1/1] Installing mysql56-server-5.6.33...
===> Creating groups.
Using existing group 'mysql'.
===> Creating users
Using existing user 'mysql'.
[1/1] Extracting mysql56-server-5.6.33: 100%
Message from mysql56-server-5.6.33:
************************************************************************

Remember to run mysql_upgrade the first time you start the MySQL server
after an upgrade from an earlier version.

************************************************************************

ok. Check if the databases are there

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| mythconverg        |
| performance_schema |
| test               |
+--------------------+
5 rows in set (0.00 sec)

yep - good.

2016-10-01: bvm3 - try mythbackend again:

root@tv# mythbackend
Shared object "libQtScript.so.4" not found, required by "mythbackend"

more missing packages?

root@tv# pkg search qt4-script
py27-qt4-script-4.11.4,1       Python bindings for the Qt4 toolkit, QtScript module
py27-qt4-scripttools-4.11.4,1  Python bindings for the Qt4 toolkit, QtScriptTools module
qt4-script-4.8.7               Qt scripting module
qt4-scripttools-4.8.7          Qt Script additional components

we have a package at least.

2016-10-01: bvm3 - ports - install: bvm3 - ports - install audio/lame port:

root@tv# cd /usr/ports/audio/lame
root@tv# make install
[...]
====> Compressing man pages (compress-man)
===>  Installing for lame-3.99.5_3
===>  Checking if lame already installed
===>   Registering installation for lame-3.99.5_3
Installing lame-3.99.5_3...

ok.

2016-09-30: bvm3 - ports - install a ports tree, via portsnap fetch; portsnap extract.

2016-09-30: bvm3 - pkg - check for 'lame' package.

looks like we don't have a lame package

root@tv# pkg search lame
blame-1.3.1                    Display last modification for each line in an RCS file
flamerobin-0.9.2_5             GUI administration tool for firebird database
glame-2.0.1_27                 Powerful, fast, stable, and easily extensible sound editor for GNOME
gstreamer-plugins-lame-0.10.19_1,3 Gstreamer mp3 encode plugin
gstreamer-plugins-twolame-0.10.19_1,3 Gstreamer High-quality free MP2 encoder plugin
gstreamer1-plugins-lame-1.8.0  GStreamer High-quality free mp3 encode plugin
gstreamer1-plugins-twolame-1.8.0 GStreamer High-quality free MP2 encoder plugin
libflame-r7421_5               FLAME dense linear algebra library
libquicktime-lame-1.2.4_5      library for reading and writing quicktime files
mctoolame-decoder-0.1.a_2      MPEG Layer II audio decoder with multi-channel support
mctoolame-encoder-0.1.a_1      MPEG Layer II audio encoder with multi-channel support
rubygem-flamegraph-0.1.0       Flamegraph support for arbitrary ruby apps
toolame-0.2l_1                 Optimized mpeg 1/2 layer 2 audio encoder
twolame-0.3.13_4               MPEG Audio Layer 2 encoder
wmflame-0.60_3                 Dockapp that shows the load average as a flame

crap. Oh well.

2016-09-30: bvm3 - let mythbackend set up the database:

root@tv# which mythbackend
/usr/local/bin/mythbackend
root@tv# mythbackend
Shared object "libmp3lame.so.0" not found, required by "mythbackend"

aha, that didn't work 2016-09-30: bvm3 - add mythtv database:

root@tv# mysql -uroot -p < /usr/local/share/mythtv/database/mc.sql
Enter password:

did it work?

root@tv# mysql -u root -p mythconverg
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 5.5.51 Source distribution

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

looks ok. set up timezone tables

root@tv# mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql
Enter password:
Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.

Hmm...

2016-09-30: bvm3 - configure mysql:

root@tv# service mysql-server onestart
Starting mysql.
root@tv# mysqladmin -u root password newpassword

which sets a password on the root user in MySQL.

2016-09-30: bvm3 - pkg - install mythtv and mythplugin-mythweb: mythtv

root@tv# pkg install mythtv
Updating FreeBSD repository catalogue...
FreeBSD repository is up-to-date.
All repositories are up-to-date.
Updating database digests format: 100%
pkg: mythtv has a missing dependency: lame
The following 98 package(s) will be affected (of 0 checked):

New packages to be INSTALLED:
    mythtv: 0.27.5.20150616_1
    libxml2: 2.9.4
    p5-DBI: 1.636
    perl5: 5.20.3_15
    py27-lxml: 3.6.0
    libxslt: 1.1.29
    libgcrypt: 1.7.3
    libgpg-error: 1.23
    indexinfo: 0.2.4
    gettext-runtime: 0.19.8.1
    python27: 2.7.12
    libffi: 3.2.1
    py27-setuptools27: 20.0
    qt4-opengl: 4.8.7
    libGL: 11.2.2
    libXfixes: 5.0.1_3
    xproto: 7.0.28
    fixesproto: 5.0
    libX11: 1.6.3,1
    libXdmcp: 1.1.2
    libxcb: 1.11.1
    libpthread-stubs: 0.3_6
    libXau: 1.0.8_3
    kbproto: 1.0.7
    dri2proto: 2.8
    libXdamage: 1.1.4_3
    damageproto: 1.2.1
    libdevq: 0.0.2_1
    libXxf86vm: 1.1.4_1
    xf86vidmodeproto: 2.3.1
    libXext: 1.3.3_1,1
    xextproto: 7.3.0
    expat: 2.1.1_2
    libdrm: 2.4.66,1
    libpciaccess: 0.13.4
    pciids: 20160621
    libxshmfence: 1.2
    libglapi: 11.2.2
    libXvMC: 1.0.9
    libXv: 1.0.10_3,1
    videoproto: 2.3.2
    qt4-corelib: 4.8.7_2
    glib: 2.46.2
    libiconv: 1.14_9
    pcre: 8.39
    icu: 55.1
    qt4-gui: 4.8.7_1
    encodings: 1.0.4_3,1
    font-util: 1.3.1
    libXt: 1.1.5,1
    libSM: 1.2.2_3,1
    libICE: 1.0.9_1,1
    xdg-utils: 1.1.1
    hicolor-icon-theme: 0.15
    xset: 1.2.3_1
    libXfontcache: 1.0.5_3
    fontcacheproto: 0.1.3
    libXmu: 1.1.2_3,1
    xprop: 1.2.2
    libXrender: 0.9.9
    renderproto: 0.11.1
    libXcursor: 1.1.14_3
    png: 1.6.21
    libXinerama: 1.1.3_3,1
    xineramaproto: 1.2.1
    xorg-fonts-truetype: 7.7_1
    font-misc-meltho: 1.0.3_3
    mkfontdir: 1.0.7
    mkfontscale: 1.1.2
    freetype2: 2.6.3
    libfontenc: 1.1.3
    fontconfig: 2.12.1,1
    font-bh-ttf: 1.0.3_3
    font-misc-ethiopic: 1.0.3_3
    dejavu: 2.35
    cups: 2.1.4
    avahi-app: 0.6.31_5
    gnome_subr: 1.0
    dbus-glib: 0.104
    dbus: 1.8.20
    gobject-introspection: 1.46.0
    python2: 2_3
    gdbm: 1.12
    libdaemon: 0.14_1
    gnutls: 3.4.15
    nettle: 3.2
    gmp: 5.1.3_3
    ca_root_nss: 3.26
    libtasn1: 4.8
    trousers: 0.3.13
    tpm-emulator: 0.7.4_1
    p11-kit: 0.23.2
    libidn: 1.33_1
    libpaper: 1.1.24.4
    libXi: 1.7.6,1
    inputproto: 2.3.1
    libXrandr: 1.5.0
    randrproto: 1.5.0

Number of packages to be installed: 98

The process will require 607 MiB more space.
127 MiB to be downloaded.

Proceed with this action? [y/N]: y
[...]
Message from perl5-5.20.3_15:
The /usr/bin/perl symlink has been removed starting with Perl 5.20.
For shebangs, you should either use:

#!/usr/local/bin/perl

or

#!/usr/bin/env perl

The first one will only work if you have a /usr/local/bin/perl,
the second will work as long as perl is in PATH.
Message from python27-2.7.12:
===========================================================================

Note that some standard Python modules are provided as separate ports
as they require additional dependencies. They are available as:

bsddb           databases/py-bsddb
gdbm            databases/py-gdbm
sqlite3         databases/py-sqlite3
tkinter         x11-toolkits/py-tkinter

===========================================================================
Message from ca_root_nss-3.26:
********************************* WARNING *********************************

FreeBSD does not, and can not warrant that the certification authorities
whose certificates are included in this package have in any way been
audited for trustworthiness or RFC 3647 compliance.

Assessment and verification of trust is the complete responsibility of the
system administrator.

*********************************** NOTE **********************************

This package installs symlinks to support root certificates discovery by
default for software that uses OpenSSL.

This enables SSL Certificate Verification by client software without manual
intervention.

If you prefer to do this manually, replace the following symlinks with
either an empty file or your site-local certificate bundle.

  * /etc/ssl/cert.pem
  * /usr/local/etc/ssl/cert.pem
  * /usr/local/openssl/cert.pem

***************************************************************************
Message from trousers-0.3.13:
To run tcsd automatically, add the following line to /etc/rc.conf:

tcsd_enable="YES"

You might want to edit /usr/local/etc/tcsd.conf to reflect your setup.

If you want to use tcsd with software TPM emulator, use the following
configuration in /etc/rc.conf:

tcsd_enable="YES"
tcsd_mode="emulator"
tpmd_enable="YES"

To use TPM, add your_account to '_tss' group like following:

# pw groupadd _tss -m your_account
Message from dejavu-2.35:
Make sure that the freetype module is loaded.  If it is not, add the following
line to the "Modules" section of your X Windows configuration file:

    Load "freetype"

Add the following line to the "Files" section of X Windows configuration file:

    FontPath "/usr/local/share/fonts/dejavu/"

Note: your X Windows configuration file is typically /etc/X11/XF86Config
if you are using XFree86, and /etc/X11/xorg.conf if you are using X.Org.
Message from qt4-corelib-4.8.7_2:
======================================================================

Qt 4 can be built with optional support for:
 - Common UNIX Printing System (CUPS) (enabled by default)
 - Network Audio System (NAS)
 - Qt style that renders using GTK (QGTKSTYLE)

In order to enable them, you have to add
    QT4_OPTIONS=    CUPS NAS QGTKSTYLE
to your /etc/make.conf and compile devel/qt4-corelib and
x11-toolkits/qt4-gui ports.

Attention! Whenever you change the QT4_OPTIONS both
devel/qt4-corelib and x11-toolkits/qt4-gui ports must be rebuilt!

======================================================================
Message from mythtv-0.27.5.20150616_1:
**********

MythTV has now been installed, but it still needs to be configured.

1.  To create the database, use the following command:

    mysql -uroot -p < /usr/local/share/mythtv/database/mc.sql

2.  Next, run mythtv-setup.

See http://www.mythtv.org/docs/ for more information.

**********

ok. Hmm, why didn't it install mysql-server?

root@tv# pkg info mythtv | head -20
mythtv-0.27.5.20150616_1
Name           : mythtv
Version        : 0.27.5.20150616_1
Installed on   : Fri Sep 30 23:25:14 2016 CEST
Origin         : multimedia/mythtv
Architecture   : freebsd:10:x86:64
Prefix         : /usr/local
Categories     : multimedia
Licenses       :
Maintainer     : decke@FreeBSD.org
WWW            : http://www.mythtv.org
Comment        : MythTV is a homebrew PVR project
Options        :
    BINDINGS       : on
    LIRC           : off
    MYSQL          : off
    OPENGL         : on
    VDPAU          : on
Shared Libs required:
    libQtGui.so.4

aha. Install it:

root@tv# pkg install mysql55-server
Updating FreeBSD repository catalogue...
FreeBSD repository is up-to-date.
All repositories are up-to-date.
The following 2 package(s) will be affected (of 0 checked):

New packages to be INSTALLED:
    mysql55-server: 5.5.51
    mysql55-client: 5.5.51

Number of packages to be installed: 2

The process will require 104 MiB more space.
8 MiB to be downloaded.

Proceed with this action? [y/N]: y
Fetching mysql55-server-5.5.51.txz: 100%    6 MiB 609.9kB/s    00:11   
Fetching mysql55-client-5.5.51.txz: 100%    2 MiB 555.3kB/s    00:03   
Checking integrity... done (0 conflicting)
[1/2] Installing mysql55-client-5.5.51...
[1/2] Extracting mysql55-client-5.5.51: 100%
[2/2] Installing mysql55-server-5.5.51...
===> Creating groups.
Creating group 'mysql' with gid '88'.
===> Creating users
Creating user 'mysql' with uid '88'.
[2/2] Extracting mysql55-server-5.5.51: 100%
Message from mysql55-client-5.5.51:
* * * * * * * * * * * * * * * * * * * * * * * *

Please be aware the database client is vulnerable
to CVE-2015-3152 - SSL Downgrade aka "BACKRONYM".
You may find more information at the following URL:

http://www.vuxml.org/freebsd/36bd352d-299b-11e5-86ff-14dae9d210b8.html

Although this database client is not listed as
"affected", it is vulnerable and will not be
receiving a patch. Please take note of this when
deploying this software.

* * * * * * * * * * * * * * * * * * * * * * * *
Message from mysql55-server-5.5.51:
************************************************************************

Remember to run mysql_upgrade the first time you start the MySQL server
after an upgrade from an earlier version.

************************************************************************

ok.

2016-09-30: bvm3 - what MythTV packages do we have?

root@tv# pkg search mythtv
mythtv-0.27.5.20150616_1       MythTV is a homebrew PVR project
mythtv-frontend-0.27.5.20150616_1 MythTV is a homebrew PVR project
root@tv# pkg search mythweb
mythplugin-mythweb-0.27.5      Frontend for scheduling and managing recordings on your MythTV Box

ok.

2016-09-30: bvm3 - install pkg and update a repository.

root@tv# pkg
The package management tool is not yet installed on your system.
Do you want to fetch and install it now? [y/N]: y
Bootstrapping pkg from pkg+http://pkg.FreeBSD.org/FreeBSD:10:amd64/quarterly, please wait...
Verifying signature with trusted certificate pkg.freebsd.org.2013102301... done
Installing pkg-1.8.7_1...
Extracting pkg-1.8.7_1: 100%
pkg: not enough arguments
Usage: pkg [-v] [-d] [-l] [-N] [-j <jail name or id>|-c <chroot path>|-r <rootdir>] [-C <configuration file>] [-R <repo config dir>] [-o var=value] [-4|-6] <command> [<args>]

For more information on available commands and options see 'pkg help'.

update repository

root@tv# pkg update
Updating FreeBSD repository catalogue...
Fetching meta.txz: 100%    944 B   0.9kB/s    00:01   
Fetching packagesite.txz: 100%    5 MiB   1.9MB/s    00:03   
Processing entries: 100%
FreeBSD repository update completed. 25371 packages processed.

ok.

2016-09-30: bvm3 - after a reboot, the machine now runs FreeBSD 10.3-release-p9.

tingo@tv$ freebsd-version -ku
10.3-RELEASE-p7
10.3-RELEASE-p9
tingo@tv$ uname -a
FreeBSD tv.kg4.no 10.3-RELEASE-p7 FreeBSD 10.3-RELEASE-p7 #0: Thu Aug 11 18:38:15 UTC 2016     root@amd64-builder.daemonology.net:/usr/obj/usr/src/sys/GENERIC  amd64

ok.

2016-09-30: bvm3 - freebsd-update. fetch

root@tv# freebsd-update fetch
src component not installed, skipped
Looking up update.FreeBSD.org mirrors... 4 mirrors found.
Fetching public key from update6.freebsd.org... done.
Fetching metadata signature for 10.3-RELEASE from update6.freebsd.org... done.
Fetching metadata index... done.
Fetching 2 metadata files... done.
Inspecting system... done.
Preparing to download files... done.
Fetching 79 patches.....10....20....30....40....50....60....70.... done.
Applying patches... done.
The following files will be updated as part of updating to 10.3-RELEASE-p9:
/bin/freebsd-version
/boot/boot1.efi
/boot/boot1.efifat
/boot/kernel/hv_storvsc.ko
/boot/kernel/hv_storvsc.ko.symbols
/boot/kernel/hv_vmbus.ko
/boot/kernel/hv_vmbus.ko.symbols
/boot/kernel/kernel
/boot/kernel/kernel.symbols
/boot/kernel/linux.ko
/boot/kernel/linux.ko.symbols
/boot/kernel/linux64.ko
/boot/kernel/linux64.ko.symbols
/boot/kernel/zfs.ko
/boot/kernel/zfs.ko.symbols
/etc/mail/freebsd.cf
/etc/mail/freebsd.submit.cf
/etc/mail/sendmail.cf
/etc/mail/submit.cf
/lib/libc.so.7
/lib/libcrypto.so.7
/rescue/[
/rescue/atmconfig
/rescue/badsect
/rescue/bsdlabel
/rescue/bunzip2
/rescue/bzcat
/rescue/bzip2
/rescue/camcontrol
/rescue/cat
/rescue/ccdconfig
/rescue/chflags
/rescue/chgrp
/rescue/chio
/rescue/chmod
/rescue/chown
/rescue/chroot
/rescue/clri
/rescue/cp
/rescue/csh
/rescue/date
/rescue/dd
/rescue/devfs
/rescue/df
/rescue/dhclient
/rescue/disklabel
/rescue/dmesg
/rescue/dump
/rescue/dumpfs
/rescue/dumpon
/rescue/echo
/rescue/ed
/rescue/ex
/rescue/expr
/rescue/fastboot
/rescue/fasthalt
/rescue/fdisk
/rescue/fsck
/rescue/fsck_4.2bsd
/rescue/fsck_ffs
/rescue/fsck_msdosfs
/rescue/fsck_ufs
/rescue/fsdb
/rescue/fsirand
/rescue/gbde
/rescue/geom
/rescue/getfacl
/rescue/glabel
/rescue/gpart
/rescue/groups
/rescue/gunzip
/rescue/gzcat
/rescue/gzip
/rescue/halt
/rescue/head
/rescue/hostname
/rescue/id
/rescue/ifconfig
/rescue/init
/rescue/ipf
/rescue/iscsictl
/rescue/iscsid
/rescue/kenv
/rescue/kill
/rescue/kldconfig
/rescue/kldload
/rescue/kldstat
/rescue/kldunload
/rescue/ldconfig
/rescue/less
/rescue/link
/rescue/ln
/rescue/ls
/rescue/lzcat
/rescue/lzma
/rescue/md5
/rescue/mdconfig
/rescue/mdmfs
/rescue/mkdir
/rescue/mknod
/rescue/more
/rescue/mount
/rescue/mount_cd9660
/rescue/mount_msdosfs
/rescue/mount_nfs
/rescue/mount_nullfs
/rescue/mount_udf
/rescue/mount_unionfs
/rescue/mt
/rescue/mv
/rescue/nc
/rescue/newfs
/rescue/newfs_msdos
/rescue/nos-tun
/rescue/pgrep
/rescue/ping
/rescue/ping6
/rescue/pkill
/rescue/ps
/rescue/pwd
/rescue/rcorder
/rescue/rcp
/rescue/rdump
/rescue/realpath
/rescue/reboot
/rescue/red
/rescue/rescue
/rescue/restore
/rescue/rm
/rescue/rmdir
/rescue/route
/rescue/routed
/rescue/rrestore
/rescue/rtquery
/rescue/rtsol
/rescue/savecore
/rescue/sed
/rescue/setfacl
/rescue/sh
/rescue/sleep
/rescue/spppcontrol
/rescue/stty
/rescue/swapon
/rescue/sync
/rescue/sysctl
/rescue/tail
/rescue/tar
/rescue/tcsh
/rescue/tee
/rescue/test
/rescue/tunefs
/rescue/umount
/rescue/unlink
/rescue/unlzma
/rescue/unxz
/rescue/vi
/rescue/whoami
/rescue/xz
/rescue/xzcat
/rescue/zcat
/rescue/zdb
/rescue/zfs
/rescue/zpool
/sbin/dhclient
/sbin/init
/usr/bin/ar
/usr/bin/bsdcpio
/usr/bin/bspatch
/usr/bin/c++
/usr/bin/cc
/usr/bin/clang
/usr/bin/clang++
/usr/bin/clang-cpp
/usr/bin/cpp
/usr/bin/ntpq
/usr/bin/openssl
/usr/bin/ranlib
/usr/include/archive.h
/usr/include/openssl/ssl.h
/usr/lib/libarchive.a
/usr/lib/libarchive.so.6
/usr/lib/libarchive_p.a
/usr/lib/libbsnmp.so.6
/usr/lib/libc.a
/usr/lib/libc_p.a
/usr/lib/libc_pic.a
/usr/lib/libcrypto.a
/usr/lib/libcrypto_p.a
/usr/lib/libmp.so.7
/usr/lib/libssl.a
/usr/lib/libssl.so.7
/usr/lib/libssl_p.a
/usr/lib/private/libssh.so.5
/usr/sbin/amd
/usr/sbin/freebsd-update
/usr/sbin/hostapd
/usr/sbin/ntp-keygen
/usr/sbin/ntpd
/usr/sbin/ntpdate
/usr/sbin/ntpdc
/usr/sbin/ntptime
/usr/sbin/sntp
/usr/sbin/wpa_supplicant
/usr/share/doc/ntp/authentic.html
/usr/share/doc/ntp/miscopt.html
/usr/share/doc/ntp/monopt.html
/usr/share/doc/ntp/ntp-keygen.html
/usr/share/doc/ntp/ntp.conf.html
/usr/share/doc/ntp/ntp.keys.html
/usr/share/doc/ntp/ntpsnmpd.html
/usr/share/doc/ntp/xleave.html
/usr/share/man/man1/bsdcpio.1.gz
/usr/share/man/man1/cpio.1.gz
/usr/share/man/man3/archive_write_data_block.3.gz
/usr/share/man/man3/archive_write_disk.3.gz
/usr/share/man/man3/archive_write_disk_new.3.gz
/usr/share/man/man3/archive_write_disk_set_group_lookup.3.gz
/usr/share/man/man3/archive_write_disk_set_options.3.gz
/usr/share/man/man3/archive_write_disk_set_skip_file.3.gz
/usr/share/man/man3/archive_write_disk_set_standard_lookup.3.gz
/usr/share/man/man3/archive_write_disk_set_user_lookup.3.gz
/usr/share/man/man5/ntp.conf.5.gz
/usr/share/man/man5/ntp.keys.5.gz
/usr/share/man/man8/ntp-keygen.8.gz
/usr/share/man/man8/ntpd.8.gz
/usr/share/man/man8/ntpdc.8.gz
/usr/share/man/man8/ntpq.8.gz
/usr/share/man/man8/sntp.8.gz
/var/db/etcupdate/current/etc/mail/freebsd.cf
/var/db/etcupdate/current/etc/mail/freebsd.submit.cf
/var/db/etcupdate/current/etc/mail/sendmail.cf
/var/db/etcupdate/current/etc/mail/submit.cf
/var/db/mergemaster.mtree

install

root@tv# freebsd-update install
src component not installed, skipped
Installing updates... done.

ok.

2016-09-30: bvm3 - login via ssh:

tingo@kg-core1$ ssh tv
Password for tingo@tv.kg4.no:
Last login: Fri Sep 30 22:50:53 2016 from kg-core1.kg4.no
FreeBSD 10.3-RELEASE (GENERIC) #0 r297264: Fri Mar 25 02:10:02 UTC 2016

Welcome to FreeBSD!

*************************
*            *
*    tv.kg4.no    *
*            *
*************************

tingo@tv$

disk layout:

tingo@tv$ swapinfo -h;df -h
Device          1K-blocks     Used    Avail Capacity
/dev/vtbd0p3      1047552       0B     1.0G     0%
Filesystem      Size    Used   Avail Capacity  Mounted on
/dev/vtbd0p2    4.8G    851M    3.6G    19%    /
devfs           1.0K    1.0K      0B   100%    /dev

ok.

2016-09-30: bvm3 - bhyve - set up a new machine bvm3 (2 cpu, 1024M, 6 G) that will be used for a MythTV machine (only to get listings). It will use tap2 interface. create a directory for it:

root@kg-vm3# cd /zs/vms
root@kg-vm3# mkdir bvm3

make file for a virtual disk drive

root@kg-vm3# truncate -s 6G bvm3/guest-bvm3.img
root@kg-vm3# ll -h bvm3
total 104
drwxr-xr-x  2 root  wheel   512B Sep 30 22:10 ./
drwxr-xr-x  5 root  wheel   512B Sep 30 22:08 ../
-rw-r--r--  1 root  wheel   6.0G Sep 30 22:10 guest-bvm3.img

looks good.

Then install it:

root@kg-vm3# sh /usr/share/examples/bhyve/vmrun.sh -c 2 -t tap2 -d /zs/vms/bvm3/guest-bvm3.img -i -I /zs/tingo/dl/bsd/FreeBSD-10.3-RELEASE-amd64-disc1.iso bhyve_bvm3

this starts the boot, xterm terminal, Norwegian keymap, name the machine tv.kg4.no, unselect games, lib32, ports tree. Guided disk setup, entire disk, gpt, I modify it so that I get a 5 G freebsd-ufs and a 1G freebsd-swap. Install continues. Network configuration DHCP, services sshd, ntpd, dumpdev. I fix /etc/dhclient.conf so that the machine will ask for a static ip, and that finishes the install. On exit, it reboots, just select "reboot" from the boot menu.

I add bvm3 to /etc/rc.conf.local, which looks like this afterwards:

root@kg-vm3# more /etc/rc.conf.local
# bhyve - configuration for virtual machines
bhyve_profiles="bvm1 bvm2 bvm3"
bhyve_bvm1_tapdev="tap0"
bhyve_bvm1_diskdev="/zs/vms/vm1/guest-vm1.img"
bhyve_bvm1_ncpu="2"

bhyve_bvm2_tapdev="tap1"
bhyve_bvm2_diskdev="/zs/vms/bvm2/guest-bvm2.img"
bhyve_bvm2_ncpu="2"
bhyve_bvm2_memsize="1024"

bhyve_bvm3_tapdev="tap2"
bhyve_bvm3_diskdev="/zs/vms/bvm3/guest-bvm3.img"
bhyve_bvm3_ncpu="2"
bhyve_bvm3_memsize="1024"

then I start the bvm3 machine:

root@kg-vm3# service bhyve status
===> bhyve profile: bvm1
bhyve_bvm1 is running.
===> bhyve profile: bvm2
bhyve_bvm2 is running.
===> bhyve profile: bvm3
bhyve_bvm3 is not running.
root@kg-vm3# service bhyve start bvm3
Starting bhyve.
root@kg-vm3# service bhyve status
===> bhyve profile: bvm1
bhyve_bvm1 is running.
===> bhyve profile: bvm2
bhyve_bvm2 is running.
===> bhyve profile: bvm3
bhyve_bvm3 is running.

ok.