Mythtv fails on update setting up mythtv and mythtv-database (29.1+fixes20180603.git1777cc4425-dmo1)

Situation: I was getting the following error message on updating the mythtv package from https://www.deb-multimedia.org testing/main amd6.

Setting up mythtv-database (29.1+fixes20180603.git1777cc4425-dmo1) …
Failed to connect to database: Access denied for user
‘root’@’chadchenault.com’ (using password: NO) at -e line 5, <> line 1.

dpkg: dependency problems prevent configuration of mythtv:
mythtv depends on mythtv-database (>= 29.1+fixes20180821.gite5fc66e822-dmo1); however:
Package mythtv-database is not configured yet.

dpkg: error processing package mythtv (–configure):
dependency problems – leaving unconfigured

Background: Updates started to fail in June 2018 and after several months of internet searching, I could not find a solution. My system isSystem:
Linux server 4.17.0-1-amd64 #1 SMP Debian 4.17.8-1 (2018-07-20) x86_64 GNU/Linux
Distributor ID: Debian
Description:    Debian GNU/Linux testing (buster)
Release:        testing
Codename:       buster

Assessment: Contacted the package maintainer Christian Marillat at deb-multimedia.org for help after internet searches yielded no results.

Recommendation: Christian Marillat was kind enough to reply the next day with the suggestion to reconfigure the mythtv-database package. This will allow you to put in your database settings in the package before the software update. My update was failing because my mythtv database setting for the root user did not have a password. I entered the following command:

dpkg-reconfigure --force mythtv-database

You get the following question asking for the password for the root user of mysql/mariadb:

"This information will be used to create a database and user for MythTV. Unless you have explicitly changed the password on the MySQL server, leave this blank.

The password for the MySQL administrator account 'root':

 

It is very important to enter the password despite what prompt telling you to leave it blank. This is because if you do not store your password in plain text configuration files for security, dpkg will not find your root password. Possible places to store the root password are:

/etc/mysql/[debian.cnf, my.cnf, mariadb.cnf]

I prefer not store the password in plain text configuration files and thus will always have to enter the root mysql password when dpkg configures mythtv-database.

After configuration, you can run the upgrade:

apt upgrade

The mythtv-backend server usually crashes and does not restart when the upgrade fails with no password. You will have to restart the mythtv-backend server with the following commands:

systemctl restart mythtv-backend
systemctl status mythtv-backend

I would like to aknowledge Christian Marillat from http://deb-multimedia.org/ for his assistance and providing the mythtv package. He is doing a wonderful service.

keywords: debian, mythtv, mythtv-common, mythtv-database, mysql, mariadb