<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body>
<p>I updated to 2:31.0+fixes.202003271742.f496eb1~ubuntu18.04.1 this
morning and I'm still getting the error on setting up
mythtv-database. Otherwise the system continues to work fine
recording and playing TV programs and updating the EPG. <br>
</p>
<p>I can login to mysql with:</p>
<p><font face="Courier New, Courier, monospace">sudo mysql
--defaults-extra-file=/etc/mysql/debian.cnf</font></p>
<p><font face="Courier New, Courier, monospace">jim@mythbuntu:~$
sudo mysql --defaults-extra-file=/etc/mysql/debian.cnf<br>
Welcome to the MariaDB monitor. Commands end with ; or \g.<br>
Your MariaDB connection id is 918<br>
Server version: 10.0.36-MariaDB-0ubuntu0.16.04.1 Ubuntu 16.04<br>
<br>
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and
others.<br>
<br>
Type 'help;' or '\h' for help. Type '\c' to clear the current
input statement.<br>
<br>
MariaDB [(none)]> quit<br>
Bye</font><br>
<br>
</p>
<p>and the contents of /etc/mysql/debian.cnf is:</p>
<p><font face="Courier New, Courier, monospace"># Automatically
generated for Debian scripts. DO NOT TOUCH!<br>
[client]<br>
host = localhost<br>
user = root<br>
password = <br>
socket = /var/run/mysqld/mysqld.sock<br>
[mysql_upgrade]<br>
host = localhost<br>
user = root<br>
password = <br>
socket = /var/run/mysqld/mysqld.sock<br>
basedir = /usr</font><br>
</p>
<p>Any help would be appreciated, but keep in mind, I'm no expert on
mysql syntax.</p>
<p>The backend in on Ubuntu Server 18.04.4 and is up to date.</p>
<p>jim@mythbuntu:~$ lsb_release -a<br>
No LSB modules are available.<br>
Distributor ID: Ubuntu<br>
Description: Ubuntu 18.04.4 LTS<br>
Release: 18.04<br>
Codename: bionic<br>
<br>
</p>
<p>Kernel:</p>
<p>Linux mythbuntu 4.15.0-88202002241620-generic
#0+mediatree+hauppauge-Ubuntu SMP Thu Feb 27 01:05:48 UTC 2020
x86_64 x86_64 x86_64 GNU/Linux<br>
</p>
<p>Console log below:<br>
</p>
<p>jim@mythbuntu:~$ sudo apt update<br>
[sudo] password for jim: <br>
Hit:1 <a class="moz-txt-link-freetext" href="http://us.archive.ubuntu.com/ubuntu">http://us.archive.ubuntu.com/ubuntu</a> bionic InRelease<br>
Get:2 <a class="moz-txt-link-freetext" href="http://security.ubuntu.com/ubuntu">http://security.ubuntu.com/ubuntu</a> bionic-security InRelease
[88.7 kB]<br>
Get:3 <a class="moz-txt-link-freetext" href="http://us.archive.ubuntu.com/ubuntu">http://us.archive.ubuntu.com/ubuntu</a> bionic-updates InRelease
[88.7 kB] <br>
Hit:4
<a class="moz-txt-link-freetext" href="http://ppa.launchpad.net/b-rad/kernel+mediatree+hauppauge/ubuntu">http://ppa.launchpad.net/b-rad/kernel+mediatree+hauppauge/ubuntu</a>
bionic InRelease<br>
Get:5 <a class="moz-txt-link-freetext" href="http://us.archive.ubuntu.com/ubuntu">http://us.archive.ubuntu.com/ubuntu</a> bionic-backports
InRelease [74.6 kB]<br>
Get:6 <a class="moz-txt-link-freetext" href="http://ppa.launchpad.net/mythbuntu/31/ubuntu">http://ppa.launchpad.net/mythbuntu/31/ubuntu</a> bionic
InRelease [15.4 kB] <br>
Get:7 <a class="moz-txt-link-freetext" href="http://ppa.launchpad.net/mythbuntu/31/ubuntu">http://ppa.launchpad.net/mythbuntu/31/ubuntu</a> bionic/main
i386 Packages [7,048 B]<br>
Get:8 <a class="moz-txt-link-freetext" href="http://ppa.launchpad.net/mythbuntu/31/ubuntu">http://ppa.launchpad.net/mythbuntu/31/ubuntu</a> bionic/main
amd64 Packages [7,032 B]<br>
Fetched 281 kB in 2s (163 kB/s) <br>
Reading package lists... Done<br>
Building dependency tree <br>
Reading state information... Done<br>
19 packages can be upgraded. Run 'apt list --upgradable' to see
them.<br>
jim@mythbuntu:~$ sudo apt upgrade<br>
Reading package lists... Done<br>
Building dependency tree <br>
Reading state information... Done<br>
Calculating upgrade... Done<br>
The following packages will be upgraded:<br>
libmyth libmyth-python libmythtv-perl mytharchive mythbrowser
mythgame mythmusic mythnews mythplugins mythtv mythtv-backend<br>
mythtv-common mythtv-database mythtv-dbg mythtv-frontend
mythtv-transcode-utils mythweather mythweb php-mythtv<br>
19 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.<br>
Need to get 219 MB of archives.<br>
After this operation, 0 B of additional disk space will be used.<br>
Do you want to continue? [Y/n] y<br>
Get:1 <a class="moz-txt-link-freetext" href="http://ppa.launchpad.net/mythbuntu/31/ubuntu">http://ppa.launchpad.net/mythbuntu/31/ubuntu</a> bionic/main
amd64 libmyth amd64
2:31.0+fixes.202003271742.f496eb1~ubuntu18.04.1 [12.8 MB]<br>
Get:2 <a class="moz-txt-link-freetext" href="http://ppa.launchpad.net/mythbuntu/31/ubuntu">http://ppa.launchpad.net/mythbuntu/31/ubuntu</a> bionic/main
amd64 mythtv-common amd64
2:31.0+fixes.202003271742.f496eb1~ubuntu18.04.1 [21.8 MB]<br>
Get:3 <a class="moz-txt-link-freetext" href="http://ppa.launchpad.net/mythbuntu/31/ubuntu">http://ppa.launchpad.net/mythbuntu/31/ubuntu</a> bionic/main
amd64 libmyth-python all
2:31.0+fixes.202003271742.f496eb1~ubuntu18.04.1 [192 kB]<br>
Get:4 <a class="moz-txt-link-freetext" href="http://ppa.launchpad.net/mythbuntu/31/ubuntu">http://ppa.launchpad.net/mythbuntu/31/ubuntu</a> bionic/main
amd64 libmythtv-perl all
2:31.0+fixes.202003271742.f496eb1~ubuntu18.04.1 [95.4 kB]<br>
Get:5 <a class="moz-txt-link-freetext" href="http://ppa.launchpad.net/mythbuntu/31/ubuntu">http://ppa.launchpad.net/mythbuntu/31/ubuntu</a> bionic/main
amd64 mythtv-transcode-utils amd64
2:31.0+fixes.202003271742.f496eb1~ubuntu18.04.1 [242 kB]<br>
Get:6 <a class="moz-txt-link-freetext" href="http://ppa.launchpad.net/mythbuntu/31/ubuntu">http://ppa.launchpad.net/mythbuntu/31/ubuntu</a> bionic/main
amd64 mythtv-dbg amd64
2:31.0+fixes.202003271742.f496eb1~ubuntu18.04.1 [166 MB]<br>
Get:7 <a class="moz-txt-link-freetext" href="http://ppa.launchpad.net/mythbuntu/31/ubuntu">http://ppa.launchpad.net/mythbuntu/31/ubuntu</a> bionic/main
amd64 mythtv-backend amd64
2:31.0+fixes.202003271742.f496eb1~ubuntu18.04.1 [1,147 kB]<br>
Get:8 <a class="moz-txt-link-freetext" href="http://ppa.launchpad.net/mythbuntu/31/ubuntu">http://ppa.launchpad.net/mythbuntu/31/ubuntu</a> bionic/main
amd64 mythtv-frontend amd64
2:31.0+fixes.202003271742.f496eb1~ubuntu18.04.1 [1,156 kB]<br>
Get:9 <a class="moz-txt-link-freetext" href="http://ppa.launchpad.net/mythbuntu/31/ubuntu">http://ppa.launchpad.net/mythbuntu/31/ubuntu</a> bionic/main
amd64 mytharchive amd64
2:31.0+fixes.202003271742.f496eb1~ubuntu18.04.1 [12.5 MB]<br>
Get:10 <a class="moz-txt-link-freetext" href="http://ppa.launchpad.net/mythbuntu/31/ubuntu">http://ppa.launchpad.net/mythbuntu/31/ubuntu</a> bionic/main
amd64 mythbrowser amd64
2:31.0+fixes.202003271742.f496eb1~ubuntu18.04.1 [159 kB]<br>
Get:11 <a class="moz-txt-link-freetext" href="http://ppa.launchpad.net/mythbuntu/31/ubuntu">http://ppa.launchpad.net/mythbuntu/31/ubuntu</a> bionic/main
amd64 mythgame amd64
2:31.0+fixes.202003271742.f496eb1~ubuntu18.04.1 [208 kB]<br>
Get:12 <a class="moz-txt-link-freetext" href="http://ppa.launchpad.net/mythbuntu/31/ubuntu">http://ppa.launchpad.net/mythbuntu/31/ubuntu</a> bionic/main
amd64 mythmusic amd64
2:31.0+fixes.202003271742.f496eb1~ubuntu18.04.1 [1,142 kB]<br>
Get:13 <a class="moz-txt-link-freetext" href="http://ppa.launchpad.net/mythbuntu/31/ubuntu">http://ppa.launchpad.net/mythbuntu/31/ubuntu</a> bionic/main
amd64 mythnews amd64
2:31.0+fixes.202003271742.f496eb1~ubuntu18.04.1 [168 kB]<br>
Get:14 <a class="moz-txt-link-freetext" href="http://ppa.launchpad.net/mythbuntu/31/ubuntu">http://ppa.launchpad.net/mythbuntu/31/ubuntu</a> bionic/main
amd64 mythweather amd64
2:31.0+fixes.202003271742.f496eb1~ubuntu18.04.1 [849 kB]<br>
Get:15 <a class="moz-txt-link-freetext" href="http://ppa.launchpad.net/mythbuntu/31/ubuntu">http://ppa.launchpad.net/mythbuntu/31/ubuntu</a> bionic/main
amd64 php-mythtv all
2:31.0+fixes.202003271742.f496eb1~ubuntu18.04.1 [86.2 kB]<br>
Get:16 <a class="moz-txt-link-freetext" href="http://ppa.launchpad.net/mythbuntu/31/ubuntu">http://ppa.launchpad.net/mythbuntu/31/ubuntu</a> bionic/main
amd64 mythweb all 2:31.0+fixes.202003271742.f496eb1~ubuntu18.04.1
[1,043 kB]<br>
Get:17 <a class="moz-txt-link-freetext" href="http://ppa.launchpad.net/mythbuntu/31/ubuntu">http://ppa.launchpad.net/mythbuntu/31/ubuntu</a> bionic/main
amd64 mythplugins all
2:31.0+fixes.202003271742.f496eb1~ubuntu18.04.1 [76.5 kB]<br>
Get:18 <a class="moz-txt-link-freetext" href="http://ppa.launchpad.net/mythbuntu/31/ubuntu">http://ppa.launchpad.net/mythbuntu/31/ubuntu</a> bionic/main
amd64 mythtv-database all
2:31.0+fixes.202003271742.f496eb1~ubuntu18.04.1 [80.7 kB]<br>
Get:19 <a class="moz-txt-link-freetext" href="http://ppa.launchpad.net/mythbuntu/31/ubuntu">http://ppa.launchpad.net/mythbuntu/31/ubuntu</a> bionic/main
amd64 mythtv all 2:31.0+fixes.202003271742.f496eb1~ubuntu18.04.1
[78.6 kB]<br>
Fetched 219 MB in 22s (10.2
MB/s)
<br>
Preconfiguring packages ...<br>
(Reading database ... 185087 files and directories currently
installed.)<br>
Preparing to unpack
.../00-libmyth_2%3a31.0+fixes.202003271742.f496eb1~ubuntu18.04.1_amd64.deb
...<br>
Unpacking libmyth
(2:31.0+fixes.202003271742.f496eb1~ubuntu18.04.1) over
(2:31.0+fixes.202003231432.9579662~ubuntu18.04.1) ...<br>
Preparing to unpack
.../01-mythtv-common_2%3a31.0+fixes.202003271742.f496eb1~ubuntu18.04.1_amd64.deb
...<br>
Unpacking mythtv-common
(2:31.0+fixes.202003271742.f496eb1~ubuntu18.04.1) over
(2:31.0+fixes.202003231432.9579662~ubuntu18.04.1) ...<br>
Preparing to unpack
.../02-libmyth-python_2%3a31.0+fixes.202003271742.f496eb1~ubuntu18.04.1_all.deb
...<br>
Unpacking libmyth-python
(2:31.0+fixes.202003271742.f496eb1~ubuntu18.04.1) over
(2:31.0+fixes.202003231432.9579662~ubuntu18.04.1) ...<br>
Preparing to unpack
.../03-libmythtv-perl_2%3a31.0+fixes.202003271742.f496eb1~ubuntu18.04.1_all.deb
...<br>
Unpacking libmythtv-perl
(2:31.0+fixes.202003271742.f496eb1~ubuntu18.04.1) over
(2:31.0+fixes.202003231432.9579662~ubuntu18.04.1) ...<br>
Preparing to unpack
.../04-mythtv-transcode-utils_2%3a31.0+fixes.202003271742.f496eb1~ubuntu18.04.1_amd64.deb
...<br>
Unpacking mythtv-transcode-utils
(2:31.0+fixes.202003271742.f496eb1~ubuntu18.04.1) over
(2:31.0+fixes.202003231432.9579662~ubuntu18.04.1) ...<br>
Preparing to unpack
.../05-mythtv-dbg_2%3a31.0+fixes.202003271742.f496eb1~ubuntu18.04.1_amd64.deb
...<br>
Unpacking mythtv-dbg
(2:31.0+fixes.202003271742.f496eb1~ubuntu18.04.1) over
(2:31.0+fixes.202003231432.9579662~ubuntu18.04.1) ...<br>
Preparing to unpack
.../06-mythtv-backend_2%3a31.0+fixes.202003271742.f496eb1~ubuntu18.04.1_amd64.deb
...<br>
Unpacking mythtv-backend
(2:31.0+fixes.202003271742.f496eb1~ubuntu18.04.1) over
(2:31.0+fixes.202003231432.9579662~ubuntu18.04.1) ...<br>
Preparing to unpack
.../07-mythtv-frontend_2%3a31.0+fixes.202003271742.f496eb1~ubuntu18.04.1_amd64.deb
...<br>
Unpacking mythtv-frontend
(2:31.0+fixes.202003271742.f496eb1~ubuntu18.04.1) over
(2:31.0+fixes.202003231432.9579662~ubuntu18.04.1) ...<br>
Preparing to unpack
.../08-mytharchive_2%3a31.0+fixes.202003271742.f496eb1~ubuntu18.04.1_amd64.deb
...<br>
Unpacking mytharchive
(2:31.0+fixes.202003271742.f496eb1~ubuntu18.04.1) over
(2:31.0+fixes.202003231432.9579662~ubuntu18.04.1) ...<br>
Preparing to unpack
.../09-mythbrowser_2%3a31.0+fixes.202003271742.f496eb1~ubuntu18.04.1_amd64.deb
...<br>
Unpacking mythbrowser
(2:31.0+fixes.202003271742.f496eb1~ubuntu18.04.1) over
(2:31.0+fixes.202003231432.9579662~ubuntu18.04.1) ...<br>
Preparing to unpack
.../10-mythgame_2%3a31.0+fixes.202003271742.f496eb1~ubuntu18.04.1_amd64.deb
...<br>
Unpacking mythgame
(2:31.0+fixes.202003271742.f496eb1~ubuntu18.04.1) over
(2:31.0+fixes.202003231432.9579662~ubuntu18.04.1) ...<br>
Preparing to unpack
.../11-mythmusic_2%3a31.0+fixes.202003271742.f496eb1~ubuntu18.04.1_amd64.deb
...<br>
Unpacking mythmusic
(2:31.0+fixes.202003271742.f496eb1~ubuntu18.04.1) over
(2:31.0+fixes.202003231432.9579662~ubuntu18.04.1) ...<br>
Preparing to unpack
.../12-mythnews_2%3a31.0+fixes.202003271742.f496eb1~ubuntu18.04.1_amd64.deb
...<br>
Unpacking mythnews
(2:31.0+fixes.202003271742.f496eb1~ubuntu18.04.1) over
(2:31.0+fixes.202003231432.9579662~ubuntu18.04.1) ...<br>
Preparing to unpack
.../13-mythweather_2%3a31.0+fixes.202003271742.f496eb1~ubuntu18.04.1_amd64.deb
...<br>
Unpacking mythweather
(2:31.0+fixes.202003271742.f496eb1~ubuntu18.04.1) over
(2:31.0+fixes.202003231432.9579662~ubuntu18.04.1) ...<br>
Preparing to unpack
.../14-php-mythtv_2%3a31.0+fixes.202003271742.f496eb1~ubuntu18.04.1_all.deb
...<br>
Unpacking php-mythtv
(2:31.0+fixes.202003271742.f496eb1~ubuntu18.04.1) over
(2:31.0+fixes.202003231432.9579662~ubuntu18.04.1) ...<br>
Preparing to unpack
.../15-mythweb_2%3a31.0+fixes.202003271742.f496eb1~ubuntu18.04.1_all.deb
...<br>
Unpacking mythweb
(2:31.0+fixes.202003271742.f496eb1~ubuntu18.04.1) over
(2:31.0+fixes.202003231432.9579662~ubuntu18.04.1) ...<br>
Preparing to unpack
.../16-mythplugins_2%3a31.0+fixes.202003271742.f496eb1~ubuntu18.04.1_all.deb
...<br>
Unpacking mythplugins
(2:31.0+fixes.202003271742.f496eb1~ubuntu18.04.1) over
(2:31.0+fixes.202003231432.9579662~ubuntu18.04.1) ...<br>
Preparing to unpack
.../17-mythtv-database_2%3a31.0+fixes.202003271742.f496eb1~ubuntu18.04.1_all.deb
...<br>
Unpacking mythtv-database
(2:31.0+fixes.202003271742.f496eb1~ubuntu18.04.1) over
(2:31.0+fixes.202003231432.9579662~ubuntu18.04.1) ...<br>
Preparing to unpack
.../18-mythtv_2%3a31.0+fixes.202003271742.f496eb1~ubuntu18.04.1_all.deb
...<br>
Unpacking mythtv (2:31.0+fixes.202003271742.f496eb1~ubuntu18.04.1)
over (2:31.0+fixes.202003231432.9579662~ubuntu18.04.1) ...<br>
Setting up libmyth
(2:31.0+fixes.202003271742.f496eb1~ubuntu18.04.1) ...<br>
Setting up php-mythtv
(2:31.0+fixes.202003271742.f496eb1~ubuntu18.04.1) ...<br>
Setting up mythtv-common
(2:31.0+fixes.202003271742.f496eb1~ubuntu18.04.1) ...<br>
Setting up mythweb
(2:31.0+fixes.202003271742.f496eb1~ubuntu18.04.1) ...<br>
Setting up mythtv-transcode-utils
(2:31.0+fixes.202003271742.f496eb1~ubuntu18.04.1) ...<br>
Setting up libmyth-python
(2:31.0+fixes.202003271742.f496eb1~ubuntu18.04.1) ...<br>
Setting up libmythtv-perl
(2:31.0+fixes.202003271742.f496eb1~ubuntu18.04.1) ...<br>
Setting up mythtv-database
(2:31.0+fixes.202003271742.f496eb1~ubuntu18.04.1) ...<br>
Failed to create or modify database (incorrect admin
username/password?)<br>
Try:<br>
sudo dpkg-reconfigure mythtv-database<br>
Setting up mythtv-backend
(2:31.0+fixes.202003271742.f496eb1~ubuntu18.04.1) ...<br>
Setting up mythtv-frontend
(2:31.0+fixes.202003271742.f496eb1~ubuntu18.04.1) ...<br>
Setting up mythmusic
(2:31.0+fixes.202003271742.f496eb1~ubuntu18.04.1) ...<br>
Setting up mythtv
(2:31.0+fixes.202003271742.f496eb1~ubuntu18.04.1) ...<br>
Setting up mythtv-dbg
(2:31.0+fixes.202003271742.f496eb1~ubuntu18.04.1) ...<br>
Setting up mythnews
(2:31.0+fixes.202003271742.f496eb1~ubuntu18.04.1) ...<br>
Setting up mythgame
(2:31.0+fixes.202003271742.f496eb1~ubuntu18.04.1) ...<br>
Setting up mythweather
(2:31.0+fixes.202003271742.f496eb1~ubuntu18.04.1) ...<br>
Setting up mytharchive
(2:31.0+fixes.202003271742.f496eb1~ubuntu18.04.1) ...<br>
Setting up mythbrowser
(2:31.0+fixes.202003271742.f496eb1~ubuntu18.04.1) ...<br>
Setting up mythplugins
(2:31.0+fixes.202003271742.f496eb1~ubuntu18.04.1) ...<br>
Processing triggers for ureadahead (0.100.0-21) ...<br>
ureadahead will be reprofiled on next reboot<br>
Processing triggers for libc-bin (2.27-3ubuntu1) ...<br>
Processing triggers for systemd (237-3ubuntu10.39) ...<br>
Processing triggers for man-db (2.8.3-2ubuntu0.1) ...<br>
Processing triggers for rsyslog (8.32.0-1ubuntu4) ...<br>
Processing triggers for mime-support (3.60ubuntu1) ...<br>
jim@mythbuntu:~$</p>
<p>Jim A</p>
<p><br>
</p>
</body>
</html>