mythtv-database creates incomplete database

For discussion of topics specific to MythTV on linux
Post Reply
dfdario
Newcomer
Posts: 3
Joined: Thu Jun 05, 2014 7:01 am
Italy

mythtv-database creates incomplete database

Post by dfdario » Tue Jan 23, 2018 9:44 am

System: Debian stretch
Repositories other than std: http://www.deb-multimedia.org/ stretch main non-free
http://www.deb-multimedia.org/ stretch-backports main
Command: apt-get install mythtv mythplugins mythweb
Mythtv version: 29+fixes20171021.git83b32140f0-dmo1~bpo9+1

Upon fresh install not all tables in mythtconverge database are created. In alphabetical order last created table is 'recordfilter'.
To solve the problem I have to perform the following commands as root:
mysql mysql -uroot -e "DROP DATABASE IF EXISTS mythconverg;"
mysql mysql -uroot -e "CREATE DATABASE IF NOT EXISTS mythconverg;"
mysql mysql -uroot -e "ALTER DATABASE mythconverg DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;"
mythtv-setup

Sometime 'mythtv-setup' needs to be run twice.

then to avoid playback test get stuck it needs to run as root the following:
mysql mysql -uroot -e "USE mythconverg; INSERT INTO storagegroup (groupname,hostname,dirname) VALUES ('Temp','${LUSER}','/var/lib/mythtv/.mythtv/tmp/');"
and create /var/lib/mythtv/.mythtv/tmp/ if it does not exist

Post Reply