<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class=""><br class="">
<div><br class=""><blockquote type="cite" class=""><div class="">On Jan 16, 2018, at 10:18 PM, James Abernathy <<a href="mailto:jfabernathy@gmail.com" class="">jfabernathy@gmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><br class="Apple-interchange-newline"><br class=""><blockquote type="cite" class=""><div class="">On Jan 16, 2018, at 9:59 PM, Mitchell Gore <<a href="mailto:mitchell.gore@gmail.com" class="">mitchell.gore@gmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div dir="ltr" class="">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.<div class=""><br class=""></div><div class="">I dont understand why this wont work:</div><div class=""><br class=""></div><div class=""><div class="">mitchell@mythtv:/etc/mysql/mysql.conf.d$ cat /home/mitchell/.mythtv/config.xml</div><div class=""><Configuration></div><div class=""> <LocalHostName>mythtv</LocalHostName></div><div class=""> <Database></div><div class=""> <PingHost>1</PingHost></div><div class=""> <Host>127.0.0.1</Host></div><div class=""> <UserName>mythtv</UserName></div><div class=""> <Password>******</Password></div><div class=""> <DatabaseName>mythconverg</DatabaseName></div><div class=""> <Port>3306</Port></div><div class=""> </Database></div><div class=""> <WakeOnLAN></div><div class=""> <Enabled>0</Enabled></div><div class=""> <SQLReconnectWaitTime>0</SQLReconnectWaitTime></div><div class=""> <SQLConnectRetry>5</SQLConnectRetry></div><div class=""> <Command>echo 'WOLsqlServerCommand not set'</Command></div><div class=""> </WakeOnLAN></div><div class=""></Configuration></div></div><div class=""><div class="">mitchell@mythtv:/etc/mysql/mysql.conf.d$ cat mythtv.cnf</div><div class="">[mysqld]</div><div class="">bind-address=0.0.0.0</div><div class="">max_connections=100</div></div><div class=""><br class=""></div><div class=""><br class=""></div><div class="">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?</div></div></div></blockquote><blockquote type="cite" class=""><div class=""><div dir="ltr" class=""><div class=""><br class=""></div><div class=""><br class=""></div></div></div></blockquote><div class=""><br class=""></div>With v29 of mythtv mysql switched to mariadb and the location of the bind-address=:: has changed. So what got installed is overridden.</div><div style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><br class=""></div><div style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class="">From my install directions blog:</div><div style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><p class="MsoListParagraph" style="text-indent: -0.5in;">1.<span class="" style="font-stretch: normal; font-size: 7pt; line-height: normal; font-family: "Times New Roman";"> </span>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.</p><div class="">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. </div><div class=""><br class=""></div><div class="">Jim A</div><div class=""><br class=""></div></div></div></blockquote><div><br class=""></div>Forgot to point to the wiki:</div><div><br class=""></div><div><a href="https://www.mythtv.org/wiki/Database_Setup" class="">https://www.mythtv.org/wiki/Database_Setup</a></div><div><br class=""></div><div>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 ::</div><div><br class=""></div><div>Jim A</div><div><br class=""><blockquote type="cite" class=""><div class=""><div style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><blockquote type="cite" class=""><div class=""><div class="gmail_extra"><div class="gmail_quote">On Tue, Jan 16, 2018 at 6:14 PM, Mitchell Gore<span class="Apple-converted-space"> </span><span dir="ltr" class=""><<a href="mailto:mitchell.gore@gmail.com" target="_blank" class="">mitchell.gore@gmail.com</a>></span><span class="Apple-converted-space"> </span>wrote:<br class=""><blockquote class="gmail_quote" style="margin: 0px 0px 0px 0.8ex; border-left-width: 1px; border-left-style: solid; border-left-color: rgb(204, 204, 204); padding-left: 1ex;"><div dir="ltr" class="">any other ideas on troubleshooting sql access?</div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br class=""><div class="gmail_quote">On Tue, Jan 16, 2018 at 9:36 AM, Jim Abernathy<span class="Apple-converted-space"> </span><span dir="ltr" class=""><<a href="mailto:jfabernathy@outlook.com" target="_blank" class="">jfabernathy@outlook.com</a>></span><span class="Apple-converted-space"> </span>wrote:<br class=""><blockquote class="gmail_quote" style="margin: 0px 0px 0px 0.8ex; border-left-width: 1px; border-left-style: solid; border-left-color: rgb(204, 204, 204); padding-left: 1ex;"><div text="#000000" bgcolor="#FFFFFF" class=""><div class=""><div class="m_-7312868332547574111h5"><p class=""><br class=""></p><br class=""><div class="m_-7312868332547574111m_6424421716992154615moz-cite-prefix">On 01/16/2018 09:39 AM, Mitchell Gore wrote:<br class=""></div><blockquote type="cite" class=""><div dir="ltr" class="">Hello,<div class=""><br class=""></div><div class="">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:</div><div class=""><br class=""></div><div class=""><div class="">Setting up mysql-server-5.7 (5.7.20-0ubuntu0.16.04.1) ...</div><div class="">Renaming removed key_buffer and myisam-recover options (if present)</div><div class="">ERROR: Unable to start MySQL server:</div><div class="">2018-01-16T00:28:57.390552Z 0 [ERROR] unknown variable 'table_cache=128'</div><div class="">2018-01-16T00:28:57.392762Z 0 [ERROR] Aborting</div><div class="">Please take a look at<span class="Apple-converted-space"> </span><a href="https://wiki.debian.org/Teams/MySQL/FAQ" target="_blank" class="">https://wiki.debian.org/Teams/<wbr class="">MySQL/FAQ</a><span class="Apple-converted-space"> </span>for tips on fixing common upgrade issues.</div><div class="">Once the problem is resolved, run apt-get --fix-broken install to retry.</div><div class="">dpkg: error processing package mysql-server-5.7 (--configure):</div><div class=""> subprocess installed post-installation script returned error exit status 1</div><div class="">dpkg: dependency problems prevent configuration of mysql-server:</div><div class=""> mysql-server depends on mysql-server-5.7; however:</div><div class=""> Package mysql-server-5.7 is not configured yet.</div><div class=""><br class=""></div><div class="">dpkg: error processing package mysql-server (--configure):</div><div class=""> dependency problems - leaving unconfigured</div><div class="">Errors were encountered while processing:</div><div class=""> mysql-server-5.7</div><div class=""> mysql-server</div></div><div class=""><br class=""></div><div class="">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.</div><div class=""><br class=""></div><div class="">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.</div><div class=""><br class=""></div><div class="">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?</div><div class=""><br class=""></div><div class="">Thanks,</div><div class="">Mitchell</div></div></blockquote><br class=""></div></div>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.<br class=""><br class="">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.<br class=""><br class="">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.<span class="Apple-converted-space"> </span><a class="m_-7312868332547574111m_6424421716992154615moz-txt-link-freetext" href="http://mythtvinstall.blogspot.com/2018/01/creating-combined-mythtv-headless.html" target="_blank">http://mythtvinstall.blogspot.<wbr class="">com/2018/01/creating-combined-<wbr class="">mythtv-headless.html</a><br class=""><br class="">Jim A<span class=""><br class=""><br class=""><blockquote type="cite" class=""><br class=""><fieldset class="m_-7312868332547574111m_6424421716992154615mimeAttachmentHeader"></fieldset><br class=""><pre class="">______________________________<wbr class="">_________________
mythtv-users mailing list
<a class="m_-7312868332547574111m_6424421716992154615moz-txt-link-abbreviated" href="mailto:mythtv-users@mythtv.org" target="_blank">mythtv-users@mythtv.org</a>
<a class="m_-7312868332547574111m_6424421716992154615moz-txt-link-freetext" href="http://lists.mythtv.org/mailman/listinfo/mythtv-users" target="_blank">http://lists.mythtv.org/mailma<wbr class="">n/listinfo/mythtv-users</a>
<a class="m_-7312868332547574111m_6424421716992154615moz-txt-link-freetext" href="http://wiki.mythtv.org/Mailing_List_etiquette" target="_blank">http://wiki.mythtv.org/Mailing<wbr class="">_List_etiquette</a>
MythTV Forums: <a class="m_-7312868332547574111m_6424421716992154615moz-txt-link-freetext" href="https://forum.mythtv.org/" target="_blank">https://forum.mythtv.org</a>
</pre></blockquote><br class=""></span></div><br class="">______________________________<wbr class="">_________________<br class="">mythtv-users mailing list<br class=""><a href="mailto:mythtv-users@mythtv.org" target="_blank" class="">mythtv-users@mythtv.org</a><br class=""><a href="http://lists.mythtv.org/mailman/listinfo/mythtv-users" rel="noreferrer" target="_blank" class="">http://lists.mythtv.org/mailma<wbr class="">n/listinfo/mythtv-users</a><br class=""><a href="http://wiki.mythtv.org/Mailing_List_etiquette" rel="noreferrer" target="_blank" class="">http://wiki.mythtv.org/Mailing<wbr class="">_List_etiquette</a><br class="">MythTV Forums:<span class="Apple-converted-space"> </span><a href="https://forum.mythtv.org/" rel="noreferrer" target="_blank" class="">https://forum.mythtv.org</a><br class=""><br class=""></blockquote></div><br class=""></div></div></div></blockquote></div><br class=""></div>_______________________________________________<br class="">mythtv-users mailing list<br class=""><a href="mailto:mythtv-users@mythtv.org" class="">mythtv-users@mythtv.org</a><br class=""><a href="http://lists.mythtv.org/mailman/listinfo/mythtv-users" class="">http://lists.mythtv.org/mailman/listinfo/mythtv-users</a><br class="">http://wiki.mythtv.org/Mailing_List_etiquette<br class="">MythTV Forums: https://forum.mythtv.org</div></blockquote></div></div></blockquote></div><br class=""></body></html>