[mythtv-users] Mythtv database requirements??

[Stephen Worthington]

On Sun, 29 Mar 2020 20:31:25 -0400, you wrote:

>On Sun, Mar 29, 2020 at 10:44 AM James Abernathy <jfabernathy at gmail.com>
>wrote:
>
>>
>>
>> On Sun, Mar 29, 2020 at 9:29 AM Stephen Worthington <
>> stephen_agent at jsw.gen.nz> wrote:
>>
>>> On Sun, 29 Mar 2020 07:21:17 -0400, you wrote:
>>>
>>> >So I know mythtv uses MySQL which has supposedly transitioned to mariadb
>>> >over time, but it's basically the same mysql commands. I think???
>>> >
>>> >So to compare what I have on 2 systems I found some puzzling results, at
>>> >least to me.
>>> >
>>> >_System 1_ is Xubuntu 18.04.4 installed recently and mythtv v31
>>> >installed today.
>>> >
>>> >It has mysql-client-5.7, mysql-client-core-5.7, mysql-server-5.7,
>>> >mysql-server-core-5.7 installed.
>>> >
>>> >if has no packages by the name mariadb, or maria installed.
>>> >
>>> >_System 2_ is an Ubuntu 18.04 Server which started on mythtv 29, moved
>>> >to 30, and not 31.
>>> >
>>> >It does NOT have mysql-client-5.7, mysql-client-core-5.7,
>>> >mysql-server-5.7, mysql-server-core-5.7 installed.
>>> >
>>> >It has mysql-common installed.
>>> >
>>> >It has mariadb-client-10.0, mariadb-client-core-10.0,
>>> >mariadb-server-10.0, mariadb-server-core-10.0, and mariadb-common
>>> installed.
>>> >
>>> >Not sure why I see the difference and wonder if this is the reason some
>>> >of the database scripts that run during mythtv updates fail for syntax
>>> >reasons??
>>> >
>>> >Jim A
>>>
>>> Unless something has changed recently, Ubuntu installs MySQL by
>>> default, so when you install MythTV, it sees MySQL present and is
>>> happy.  If you install MythTV on a Ubuntu system with neither MySQL
>>> nor MariaDB installed, the MythTV packages specify MySQL first, so
>>> MySQL gets installed.  So the only way you get MythTV running with
>>> MariaDB on Ubuntu is if you have manually chosen to either install
>>> MariaDB before you installed MythTV (recommended), or have later
>>> installed MariaDB which will automatically uninstall MySQL.  If you do
>>> the latter, you normally get a message that the database versions are
>>> out of step and MariaDB is unable to convert the mythconverg database.
>>> So you have to reinstall MySQL, do a backup of mythconverg, install
>>> MariaDB again, create a new mythconverg database and set up its access
>>> credentials, then restore your backed up copy of mythconverg.  A very
>>> tedious process I have done more than once, hence why I recommend
>>> installing MariaDB before installing MythTV if at all possible.
>>>
>>> When MariaDB is installed, mysql-common remains installed as there are
>>> other packages that require it.  It only really creates a three config
>>> files under /etc/mysql plus documentation files and /usr/share/lintian
>>> files, so it is not a worry.
>>>
>>> My first thought is to wait for Bill to come up with a solution for
>> updating a system with the mariadb version that Ubuntu 18.04 uses. I plan
>> on staying on Ubuntu 18.04 LTS until 2023 unless the Covid-19 kills me
>> first.
>>
>> BTW, I can't remember how mariadb got installed because none of my install
>> instructions have that written down.
>>
>> However, I'm a guy who likes to stay on standard software so I don't get
>> caught by normal assumptions.  All my mythtv databases, backups and
>> recordings, etc are on a set of 2 RAID mirrors, i.e. 4 drives. I've read
>> that If you create a new Xubuntu 18.04 install and it will see the 2 RAID
>> mirrors and know how to use them. I'd just have to add the mounts in
>> /etc/fstab.  Then I could restore the backed up mythconverg and go from
>> there.
>>
>> Obviously, I have both RAIDs backed up to external e-SATA drive so if the
>> shit hits the fan I can rebuild.  I even have a clonezilla image of my boot
>> drive /dev/sda.
>>
>> Thoughts on doing this to get back to standard??
>> Jim A
>>
>
>I just went through this exercise.  As part of my social distancing, I just
>migrated my MythTV backend from a physical EL6 machine to an Ubuntu 18 LTS
>VM on Unraid.  The EL6 machine was running MariaDB, yet when I built the
>Ubuntu machine, as Stephen stated, the package manager dragged in MySQL 5.7
>I think, rather than MariaDB 10, which is what I was expecting to see.
>Anyway, when I tried to import the mythconverg dump file from the old
>machine, it failed on the points Bill made.
>
>To get around this, did the following on the new VM:  1) uninstall mythtv,
>2) uninstall mysql, 3) install mariadb, then 4) reinstall mythtv.
>
>Relatively easy process.  After that, the mythconverg dump file was
>successfully imported and all is well with the world.

Except if you actually want MariaDB, as I do.  When Oracle took over
MySQL they switched it from using the readline library to editline, as
readline prevented them from making the changes they wanted to the
license so they could monetarise MySQL.  Which completely broke the
way I use the command line history in the MySQL command line programs.
Since I use the command line a lot, I switched to MariaDB which still
uses the readline library.  The general trend in Linux distros now is
to install MariaDB by default, as it is more open source friendly.
Fedora and Fedora based distros did that years ago.  Ubuntu, for some
reason, has not made that change.  Or maybe they have in versions >
18.04 and I have not noticed because I have not tried them yet.

I would really prefer that the MythTV packages caught up with this
also and listed MariaDB first, so that if no database is already
installed, MariaDB got installed.