<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p><br>
</p>
<p> </p>
<p style="margin-bottom: 0in; line-height: 100%">Hi Stephen!</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">Firstly, <b>thank
you</b>! Secondly, ran into some problems. Comments in-line with
your instructions so you can see (or at least try to figure out
<g>)
my thought processes and what I did. Your instructions are
outdented, mine (“BJM”) are indented and in a rectangle, or at
least at this point they are – the original is written using
LibreOffice and copied to be posted to the Forum.</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<pre class="western" style="margin-bottom: 0.2in"><font face="moz-fixed"><font style="font-size: 12pt" size="3">To bring up a new MythTV system on Ubuntu 18.04, I recommend not using MySQL but switching the
database to MariaDB before installing the MythTV packages. MySQL now has several problems that
you need to overcome before it will work properly with MythTV, but I think MariaDB, as installed from
the packages, is more compatible. So what you do is first choose which variant of Ubuntu you want
to install. Xubuntu is the closest to what Mythbuntu used to be, so I would suggest using that as the
base system, but ordinary Ubuntu and Lubuntu also work. Install that, then before you do anything
else (including running apt update and apt upgrade) install the MariaDB client and server packages.
That will uninstall the MySQL packages, and install MariaDB as a direct and fully compatible
replacement. If you already have MythTV installed, due to the dependencies of the MythTV packages,
they will be uninstalled also. </font></font></pre>
<dl>
<dd>
<table width="618" cellspacing="0" cellpadding="4">
<colgroup><col width="608"> </colgroup><tbody>
<tr>
<td style="border: 1px solid #000000; padding: 0.04in"
width="608" valign="top">
<p><font face="moz-fixed"><font style="font-size: 12pt"
size="3">BJM Notes:</font></font></p>
<p><font face="moz-fixed"><font style="font-size: 12pt"
size="3">Already have Ubuntu 18.04 installed; have
done several updates/upgrades.</font></font></p>
<p><br>
</p>
<p><font face="moz-fixed"><font style="font-size: 12pt"
size="3">Per Terminal with mariadb ==> not
installed, use:</font></font></p>
<p><font face="moz-fixed"><font style="font-size: 12pt"
size="3">sudo apt install mariadb-client-core-10.1
<== core only, so</font></font></p>
<p><font face="moz-fixed"><font style="font-size: 12pt"
size="3">sudo apt install mariadb-server (per
Googling)</font></font></p>
<p><br>
</p>
<p><font face="moz-fixed"><font style="font-size: 12pt"
size="3">Install of mariadb indicated mysql old
data to /var/lib/mysql.*</font></font></p>
<p> <font face="moz-fixed"><font style="font-size:
12pt" size="3">no such file found </font></font>
</p>
<p> <font face="moz-fixed"><font style="font-size:
12pt" size="3">Did find various mysql files –
should these be manually removed?</font></font></p>
<p><br>
</p>
</td>
</tr>
</tbody>
</table>
</dd>
</dl>
<pre class="western" style="margin-bottom: 0.2in"><font face="moz-fixed"><font style="font-size: 12pt" size="3"><span lang="en-US">Now do "apt update" and "apt upgrade" to update all the packages to the latest versions. </span></font></font>
<font face="moz-fixed"><font style="font-size: 12pt" size="3"><span lang="en-US">Then install the MythTV-fixes repository, and install the latest MythTV v30 packages from there.</span></font></font></pre>
<dl>
<dd>
<table width="615" cellspacing="0" cellpadding="4">
<colgroup><col width="605"> </colgroup><tbody>
<tr>
<td style="border: 1px solid #000000; padding: 0.04in"
width="605" valign="top">
<p>“<font face="Liberation Mono, monospace"><font
style="font-size: 12pt" size="3"><font
face="moz-fixed"><span lang="en-US">install the
MythTV-fixes repository” </span></font><font
face="moz-fixed"><span lang="en-US">==></span></font></font></font></p>
<p> <font face="Liberation Mono, monospace"><font
style="font-size: 12pt" size="3"><font
face="moz-fixed"><span lang="en-US"><span
style="background: #fff200">??</span></span></font><font
face="moz-fixed"><span lang="en-US"> </span></font><font
face="moz-fixed"><span lang="en-US">sudo
add-apt-respository ppa:mythbuntu/30</span></font></font></font></p>
<p> <font face="Liberation Mono, monospace"><font
style="font-size: 12pt" size="3"><font
face="moz-fixed"><span lang="en-US">Appears to
be</span></font></font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 12pt" size="3"><font
face="moz-fixed"><span lang="en-US"><br>
</span></font></font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 12pt" size="3"><font
face="moz-fixed"><span lang="en-US">C</span></font><font
face="moz-fixed"><span lang="en-US">hecking this
noted a potential problem:</span></font></font></font></p>
<p> <font face="Liberation Mono, monospace"><font
style="font-size: 12pt" size="3"><font
face="moz-fixed"><span lang="en-US">Installation
of MythTV with </span></font><font
face="moz-fixed"><span lang="en-US"><b>sudo
apt-get install mythtv</b></span></font><font
face="moz-fixed"><span lang="en-US"> </span></font></font></font>
</p>
<p> <font face="Liberation Mono, monospace"><font
style="font-size: 12pt" size="3"><font
face="moz-fixed"><span lang="en-US"><a
href="https://www.mythtv.org/wiki/Installing_MythTV_on_Ubuntu">https://www.mythtv.org/wiki/Installing_MythTV_on_Ubuntu</a>
==></span></font></font></font></p>
<p> <font face="Liberation Mono, monospace"><font
style="font-size: 12pt" size="3"><font
face="moz-fixed"><span lang="en-US">Install
Software section:</span></font></font></font></p>
<p> <font face="moz-fixed"><span lang="en-US">The
packages do the following: </span></font> </p>
<ul>
<li>
<p style="margin-bottom: 0in">Install mythtv
software and all prerequisites. </p>
</li>
<li>
<p style="margin-bottom: 0in">Install MySQL database
software. <=== </p>
</li>
<li>
<p>Create a MySQL database user for MythTV</p>
</li>
</ul>
<p>Yup: says installed MySQL.</p>
</td>
</tr>
</tbody>
</table>
</dd>
</dl>
<pre class="western"><font face="moz-fixed"><font style="font-size: 12pt" size="3"><span lang="en-US">Now set the root password:</span></font></font>
<font face="moz-fixed"><font style="font-size: 12pt" size="3"><span lang="en-US"><b>sudo passwd </b></span></font></font></pre>
<dl>
<dd>
<table width="611" cellspacing="0" cellpadding="4">
<colgroup><col width="601"> </colgroup><tbody>
<tr>
<td style="border: 1px solid #000000; padding: 0.04in"
width="601" valign="top">
<p> <font face="moz-fixed"><font style="font-size:
12pt" size="3">(my standard)</font></font></p>
</td>
</tr>
</tbody>
</table>
</dd>
</dl>
<pre class="western">
<font face="moz-fixed"><font style="font-size: 12pt" size="3"><span lang="en-US">This is necessary to allow root access to the mysql command. Pick a good password and do not forget it.</span></font></font>
<font style="font-size: 12pt" size="3"><span style="background: #fff200">- - - Skipped this section</span></font>
<font face="moz-fixed"><font style="font-size: 12pt" size="3"><span lang="en-US"> At this point, if you want to be using LIRC for your remote control, download my fix for its broken package
from my web server and run it:</span></font></font>
<a href="http://www.jsw.gen.nz/mythtv/lirc-ubuntu-18.04-install.sh"><font face="moz-fixed"><font style="font-size: 12pt" size="3"><span lang="en-US"> http://www.jsw.gen.nz/mythtv/lirc-ubuntu-18.04-install.sh</span></font></font></a>
<font face="moz-fixed"><font style="font-size: 12pt" size="3"><span lang="en-US"> That will install the LIRC package and run all the fixes needed to make it work and able to be configured
using its new Python config programs.</span></font></font>
<font face="moz-fixed"><font style="font-size: 12pt" size="3"><span lang="en-US"><span style="background: #fff200">- - - end skipped section</span></span></font></font>
<font face="moz-fixed"><font style="font-size: 12pt" size="3"><span lang="en-US">Now look at the <b>/etc/mythtv/config.xml</b> file. Change the password there if you want to, and then set the
same password in MariaDB:</span></font></font>
<font face="moz-fixed"><font style="font-size: 12pt" size="3"><span lang="en-US"><b>sudo su</b></span></font></font>
<font face="moz-fixed"><font style="font-size: 12pt" size="3"><span lang="en-US"><b>mysql</b></span></font></font>
</pre>
<dl>
<dd>
<table width="618" cellspacing="0" cellpadding="4">
<colgroup><col width="608"> </colgroup><tbody>
<tr>
<td style="border: 1px solid #000000; padding: 0.04in"
width="608" valign="top">
<p><font face="moz-fixed"><font style="font-size: 12pt"
size="3">ERROR 2002 (HY000): Can’t connect to
local MySQL server through socket
‘var/run/mysqld/mysqld.sock’ (2 “No such file or
directory”)</font></font></p>
</td>
</tr>
</tbody>
</table>
</dd>
</dl>
<pre class="western"><font face="moz-fixed"><font style="font-size: 12pt" size="3"><b>grant all on mythconverg.* to mythtv@"%" identified by "<password>";</b></font></font>
</pre>
<p style="margin-bottom: 0in; line-height: 100%">
(BJM) I stopped at this point as received the response indicating
‘command grant not found’. At that point was in a ‘deeper’
Terminal command level – root@Backend-3 vs. barry-@Backend-3. At
the ‘<a href="mailto:barry@Backend-3">barry@Backend-3</a>’ prompt
checked ‘grant –help’: not found. Guessing ‘grant’ is a
MySQL command but not loading because of the socket error.</p>
<p style="margin-bottom: 0in; line-height: 100%">LIS, checked a
couple things then stopped at this point to ask for help. BTW, the
/etc/mythtv/config.xml file contained the same random password as
(my) yesterday. Thought that a hare odd as when uninstalled MySQL
previously (before asking for help) the new install of MythTV
changed
the original password (of install #1). Just in case that bit of
trivia is significant.</p>
<p style="margin-bottom: 0in; line-height: 100%">Thanks for the
assistance!</p>
<p style="margin-bottom: 0in; line-height: 100%">Barry </p>
<p>
<style type="text/css">td p { margin-bottom: 0in; }pre.cjk { font-family: "Courier New", monospace; }p { margin-bottom: 0.1in; line-height: 115%; }a:link { }</style></p>
<p><br>
</p>
<p><br>
</p>
</body>
</html>