<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<div class="moz-cite-prefix">On 24/07/2020 09:32, Jim Abernathy
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:bc449dd1-8a6b-9902-10d3-8cfa88acb435@gmail.com">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<p><br>
</p>
<div class="moz-cite-prefix">On 7/23/20 11:42 PM, Stephen
Worthington wrote:<br>
</div>
<blockquote type="cite"
cite="mid:aplkhfpvt7d7ekvoj7sr648dasvbt215rs@4ax.com">
<pre class="moz-quote-pre" wrap="">On Thu, 23 Jul 2020 13:27:50 -0700, you wrote:
</pre>
<blockquote type="cite">
<pre class="moz-quote-pre" wrap="">Is there any "preferred" or most stable Ubuntu version for the latest
MythTV? It seems like many people are running 18.04, but there are 19.10
and 20.04 versions as well. Other things being equal I would go to the
latest, but in the past I have seen people having problems running Myth on
the latest releases.
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap="">There is a problem with the latest MariaDB versions which you get in
Ubuntu 20.04. So if you want to use MariaDB, stick with 18.04 for the
moment. If you are using lirc, the packages are broken on 18.04 and
20.04, but I have fix scripts on my web server for both now. I do not
have scripts for the non-LTS Ubuntus. You can not do an upgrade from
LTS to 20.04 yet - the 20.4.1 release which allows that is still a few
days away.
</pre>
</blockquote>
<p>Stephen,</p>
<p>I'm glad you posted these comments. I've been wondering about
the Ubuntu 20.04 issue with MariaDB. I'm following the bug
report (<a
href="https://bugs.launchpad.net/ubuntu/+source/mysql-8.0/+bug/1877504"
moz-do-not-send="true">https://bugs.launchpad.net/ubuntu/+source/mysql-8.0/+bug/1877504</a>)
but no update lately.</p>
<p>From my experimenting I believe that if I have to move to
Ubuntu 20.04 before there is a fix, my only choice would be to
back everything up create a new Ubuntu 20.04 system and NOT
install MariDB before I install Mythtv v31 and proceed with
MySQL 8. I have been able to restore a daily backup from MariaDB
to a new MySQL system using:</p>
<p> </p>
<p class="western" style="margin-left: 0.5in; margin-bottom: 0in;
line-height: 100%"> <font face="Courier, serif"><font
style="font-size: 10pt" size="2">/usr/share/mythtv/mythconverg_restore.pl
--drop_database --create_database --filename /full path to
directory/mythconverg-1214-20080626150513.sql.gz</font></font></p>
<p class="western" style="margin-left: 0.5in; margin-bottom: 0in;
line-height: 100%"><font face="Courier, serif"><font
style="font-size: 10pt" size="2"><br>
</font></font></p>
<p>
<style type="text/css">
p { margin-bottom: 0.1in; direction: ltr; color: #000000; line-height: 115%; text-align: left; orphans: 2; widows: 2 }
p.western { font-family: "Cambria", serif; font-size: 12pt; so-language: en-US }
p.cjk { font-family: "ＭＳ 明朝"; font-size: 12pt; so-language: en-US }
p.ctl { font-family: ; font-size: 12pt; so-language: ar-SA }
a:link { color: #0000ff }</style></p>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
mythtv-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a>
<a class="moz-txt-link-freetext" href="http://lists.mythtv.org/mailman/listinfo/mythtv-users">http://lists.mythtv.org/mailman/listinfo/mythtv-users</a>
<a class="moz-txt-link-freetext" href="http://wiki.mythtv.org/Mailing_List_etiquette">http://wiki.mythtv.org/Mailing_List_etiquette</a>
MythTV Forums: <a class="moz-txt-link-freetext" href="https://forum.mythtv.org">https://forum.mythtv.org</a>
</pre>
</blockquote>
<p>I run mariadb without any issues on ubuntu 20.04 by <br>
</p>
<p>Downgrade: libmysqlclient21:amd64 (8.0.20-0ubuntu0.19.10.1,
8.0.19-0ubuntu5)</p>
<p>Synaptic will do this using force version.</p>
<p>Locking this in Synaptic wouldn't work for me so :-<br>
</p>
<p> </p>
<p>sudo
apt-mark hold libmysqlclient21</p>
<p>
<style type="text/css">
p { margin-bottom: 0.21cm; background: transparent }
a:visited { color: #800000; so-language: zxx; text-decoration: underline }
a:link { color: #000080; so-language: zxx; text-decoration: underline }</style></p>
</body>
</html>