[mythtv-users] Mythbuntu change from MySQL to MariaDB?

Fri Aug 26 11:29:14 UTC 2016


On 08/25/2016 12:03 PM, Stephen Worthington wrote:
> On Thu, 25 Aug 2016 11:16:40 -0400, you wrote:
>
>>
>> On 08/25/2016 10:16 AM, Stephen Worthington wrote:
>>> On Thu, 25 Aug 2016 05:33:28 -0400, you wrote:
>>>
>>>> On 08/24/2016 10:41 PM, Stephen Worthington wrote:
>>>>> On Wed, 24 Aug 2016 17:16:22 -0400, you wrote:
>>>>>
>>>>>> On 08/24/2016 04:59 PM, nospam312 wrote:
>>>>>>> On 22 August 2016 at 12:08, Jim Abernathy <jfabernathy at outlook.com
>>>>>>> <mailto:jfabernathy at outlook.com>> wrote:
>>>>>>>
>>>>>>>
>>>>>>>        http://www.mythbuntu.org/downloads
>>>>>>>        <http://www.mythbuntu.org/downloads>
>>>>>>>
>>>>>>>
>>>>>>> Thanks for your replies but I do not know if you are trying to wind me
>>>>>>> up or not.
>>>>>>>
>>>>>>> I can see no reference to a MariaDB version on that page just the
>>>>>>> standard Mythbuntu download?
>>>>>>>
>>>>>>> Can you help with a specific download for the ISO with MariaDB used
>>>>>>> instead of MySQL?
>>>>>>>
>>>>>>> To get a clean install would be worth the effort instead a more than
>>>>>>> perfect removal of MySQL and then install of MariaDB.
>>>>>>>
>>>>>> I'm not smart enough to know MySQL from MariaDB.  I just downloaded
>>>>>> mythbuntu from the download site, burn it to a CDROM or USB key and
>>>>>> install it.  The database always takes care of itself.  I only rebuild
>>>>>> when I have all my recordings archived to a NAS and my database is
>>>>>> basically empty.  I rebuild it before the fall TV season starts.  So now
>>>>>> I'm committed to Mythbuntu 14.04.4 until next year because of issues I'm
>>>>>> having with 16.04.  I can get 16.04 working except for 2 issues that are
>>>>>> not DB related.  Just related to my TV and A/V receiver.  There is also
>>>>>> a bug with mythtranscode that has not been fixed so I'm staying on
>>>>>> mythtv 0.27
>>>>>>
>>>>>> So even though I've tested a lot on 0.28, and 16.04, I still have no
>>>>>> idea why you are worried about MySQL vs. MariaDB.  I still use mysql
>>>>>> commands on 16.04.  So I'm unaware of any changes in that area.
>>>>>>
>>>>>> I have to mottoes to live by.
>>>>>> 1.  if it ain't broke don't fix it and
>>>>>> 2.  You can't drink all day if you don't start in the morning.
>>>>>>
>>>>>> Jim A
>>>>> I am converting to using MariaDB in 16.04 due to MySQL changing from
>>>>> using the readline library to editline.  Editline does not work for me
>>>>> in bringing back SQL commands from history, which I find extremely
>>>>> aggravating since readline works very well and I use the history all
>>>>> the time.  Apparently Oracle do not want readline's GPL or LGPL
>>>>> licensing as part of MySQL, so they switched to editline because its
>>>>> licensing is more what they want.  I find that a problem also, as it
>>>>> may indicate that Oracle are trying to make MySQL proprietary somehow
>>>>> instead of freeware.
>>>>>
>>>>> MariaDB is extremely compatible with MySQL and it is actually hard to
>>>>> tell which one is installed without looking hard.  The MariaDB
>>>>> packages directly replace the MySQL ones (using the same executable
>>>>> names) and provide all the same commands and services.  The only
>>>>> difference that I found that I had to deal with was that MariaDB has
>>>>> some config files that belong to it only and are separate from the
>>>>> normal MySQL config files.  Doing that, combined with how the MythTV
>>>>> packages do their MySQL config and how I had overridden some default
>>>>> settings in the MythTV MySQL config did not work with MariaDB as the
>>>>> config files ended up being loaded in a different order, so my
>>>>> overrides were not being loaded last.  That resulted in the IP address
>>>>> for accessing the database not being set to my MythTV box's external
>>>>> IP address and it was defaulting to localhost.  It was easy enough to
>>>>> fix once I worked out what was happening.
>>>>> ___
>>>> So If you do a standard Mythbuntu 16.04 install from CDROM, which
>>>> database are you using?
>>>>
>>>> MCC still has a MySQL section
>>>>
>>>> Jim A
>>> The default install uses MySQL.  You have to install MariaDB yourself
>>> after installing Ubuntu.  That will uninstall MySQL and install
>>> MariaDB in place of it.  MCC should not be able to tell the difference
>>> - MariaDB is almost indistinguishable from MySQL to any program that
>>> is using a MySQL database.
>> Ok, I got it, but why would someone know to uninstall MySQL and install
>> MariaDB?  If Ubuntu uses MySQL by default and Mythtv still works with
>> it, why would you change?
>>
>> Jim A
> As I said - I need the readline library.  MySQL now uses editline,
> which does not work for me.
Can I assume that if I'm only using this computer to run mythbuntu, 
mostly as the backend for the house that I do not need to worry about 
whatever readline library is and the differences between MySQL and MariaDB??

> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://lists.mythtv.org/mailman/listinfo/mythtv-users
> http://wiki.mythtv.org/Mailing_List_etiquette
> MythTV Forums: https://forum.mythtv.org