[mythtv-users] Upgrade Ubuntu 14 to 16 LTS and errors with MYSQL
James Abernathy
jfabernathy at gmail.com
Wed Jan 17 03:36:45 UTC 2018
> On Jan 16, 2018, at 10:18 PM, James Abernathy <jfabernathy at gmail.com> wrote:
>
>
>
>> On Jan 16, 2018, at 9:59 PM, Mitchell Gore <mitchell.gore at gmail.com <mailto:mitchell.gore at gmail.com>> wrote:
>>
>> doing more troubleshooting. What i have found out is this is 100% related to MySQL network options. if change my config.xml file to 127.0.0.1 mythtv can connect to the database. The issue there is my remote frontends dont connect.
>>
>> I dont understand why this wont work:
>>
>> mitchell at mythtv:/etc/mysql/mysql.conf.d$ cat /home/mitchell/.mythtv/config.xml
>> <Configuration>
>> <LocalHostName>mythtv</LocalHostName>
>> <Database>
>> <PingHost>1</PingHost>
>> <Host>127.0.0.1</Host>
>> <UserName>mythtv</UserName>
>> <Password>******</Password>
>> <DatabaseName>mythconverg</DatabaseName>
>> <Port>3306</Port>
>> </Database>
>> <WakeOnLAN>
>> <Enabled>0</Enabled>
>> <SQLReconnectWaitTime>0</SQLReconnectWaitTime>
>> <SQLConnectRetry>5</SQLConnectRetry>
>> <Command>echo 'WOLsqlServerCommand not set'</Command>
>> </WakeOnLAN>
>> </Configuration>
>> mitchell at mythtv:/etc/mysql/mysql.conf.d$ cat mythtv.cnf
>> [mysqld]
>> bind-address=0.0.0.0
>> max_connections=100
>>
>>
>> but when i change the host entry to the IP in config.xml to the sql/mythtvbackend IP it fails to connect. Doesn't setting the bind address to all 0's allow connections from any system?
>>
>>
>
> With v29 of mythtv mysql switched to mariadb and the location of the bind-address=:: has changed. So what got installed is overridden.
>
> From my install directions blog:
> 1. Before you build a remote v29 mythtv-frontend, you need to fix a mysql or rather mariadb issue to allow remote frontends. Move the mythtv.cnf file from /etc/mysql/conf.d to /etc/mysql/mariadb.conf.d. Then edit mythtv.cnf and make sure it has a “bind-address=::” that isn’t commented out. You need to override the bind-address=127.0.0.1 statement is a file setup by the install.
>
> There is an explanation on the wiki about the search order for the options. Since /etc/mysql/mariadb.conf.d is searched last you need you cnf file there. And it need to be alphabetically last.
>
> Jim A
>
Forgot to point to the wiki:
https://www.mythtv.org/wiki/Database_Setup <https://www.mythtv.org/wiki/Database_Setup>
You want to pay attention to the bottom of the page. Also If you research mariadb doc you’ll see they use bind-address=:: instead of 0.0.0.0. I used ::
Jim A
>> On Tue, Jan 16, 2018 at 6:14 PM, Mitchell Gore <mitchell.gore at gmail.com <mailto:mitchell.gore at gmail.com>> wrote:
>> any other ideas on troubleshooting sql access?
>>
>> On Tue, Jan 16, 2018 at 9:36 AM, Jim Abernathy <jfabernathy at outlook.com <mailto:jfabernathy at outlook.com>> wrote:
>>
>>
>>
>> On 01/16/2018 09:39 AM, Mitchell Gore wrote:
>>> Hello,
>>>
>>> initially i wanted to just upgrade MythTV .28 to .29. After enabling the .29 repo i was getting dependency errors around libmyth. I ended up doing a Ubuntu release upgrade to 16.04 LTS. That was all going well until i ran into upgraded MySQL to 5.7 and got the table_cache=128 error from the mythtv-tweaks.cnf file. I got this error:
>>>
>>> Setting up mysql-server-5.7 (5.7.20-0ubuntu0.16.04.1) ...
>>> Renaming removed key_buffer and myisam-recover options (if present)
>>> ERROR: Unable to start MySQL server:
>>> 2018-01-16T00:28:57.390552Z 0 [ERROR] unknown variable 'table_cache=128'
>>> 2018-01-16T00:28:57.392762Z 0 [ERROR] Aborting
>>> Please take a look at https://wiki.debian.org/Teams/MySQL/FAQ <https://wiki.debian.org/Teams/MySQL/FAQ> for tips on fixing common upgrade issues.
>>> Once the problem is resolved, run apt-get --fix-broken install to retry.
>>> dpkg: error processing package mysql-server-5.7 (--configure):
>>> subprocess installed post-installation script returned error exit status 1
>>> dpkg: dependency problems prevent configuration of mysql-server:
>>> mysql-server depends on mysql-server-5.7; however:
>>> Package mysql-server-5.7 is not configured yet.
>>>
>>> dpkg: error processing package mysql-server (--configure):
>>> dependency problems - leaving unconfigured
>>> Errors were encountered while processing:
>>> mysql-server-5.7
>>> mysql-server
>>>
>>> I cleared that line from the file and reran the sudo apt-get upgrade and all seamed okay. I was able to upgrade to .29 without issue.
>>>
>>> The problems began when i went to upgrade the database by running mythbackend from command line. For some reason mythbackend was unable to log into the database. I am able to log into MySQL as root and my MythTV user using the password in /etc/mythtv/config.xml. The database is still there as well.
>>>
>>> I have tried downgrading MythTV to .28 and still get the same errors. I have also removed MySQL and reinstalled. At this point i am lost. Any ideas?
>>>
>>> Thanks,
>>> Mitchell
>>
>> I also have had problems with the upgrading process. I never could get the upgrade from .27 to .28. So I just backed up all recordings and the database and completely started over and restored the recording and database. Had no problems after that.
>>
>> I tried to upgrade in place from 16.04 mythtv .28 to v29, but again too many errors. So I again backed up all the recordings to a NAS and backed up the database. I created a new Ubuntu 16.04 system and went straight to v29 of mythtv. Restored the recordings and database and all is well.
>>
>> That's the only process that I've had work for me. If you are interested I documented what I did recently so I'd have it somewhere to reference if I had to do it all again due to failed hardware or something. http://mythtvinstall.blogspot.com/2018/01/creating-combined-mythtv-headless.html <http://mythtvinstall.blogspot.com/2018/01/creating-combined-mythtv-headless.html>
>>
>> Jim A
>>
>>>
>>>
>>> _______________________________________________
>>> mythtv-users mailing list
>>> mythtv-users at mythtv.org <mailto:mythtv-users at mythtv.org>
>>> http://lists.mythtv.org/mailman/listinfo/mythtv-users <http://lists.mythtv.org/mailman/listinfo/mythtv-users>
>>> http://wiki.mythtv.org/Mailing_List_etiquette <http://wiki.mythtv.org/Mailing_List_etiquette>
>>> MythTV Forums: https://forum.mythtv.org <https://forum.mythtv.org/>
>>
>>
>> _______________________________________________
>> mythtv-users mailing list
>> mythtv-users at mythtv.org <mailto:mythtv-users at mythtv.org>
>> http://lists.mythtv.org/mailman/listinfo/mythtv-users <http://lists.mythtv.org/mailman/listinfo/mythtv-users>
>> http://wiki.mythtv.org/Mailing_List_etiquette <http://wiki.mythtv.org/Mailing_List_etiquette>
>> MythTV Forums: https://forum.mythtv.org <https://forum.mythtv.org/>
>>
>>
>>
>> _______________________________________________
>> mythtv-users mailing list
>> mythtv-users at mythtv.org <mailto: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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20180116/3ada33d3/attachment.html>
More information about the mythtv-users
mailing list