<div dir="ltr">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><br></div><div>I dont understand why this wont work:</div><div><br></div><div><div>mitchell@mythtv:/etc/mysql/mysql.conf.d$ cat /home/mitchell/.mythtv/config.xml</div><div><Configuration></div><div> <LocalHostName>mythtv</LocalHostName></div><div> <Database></div><div> <PingHost>1</PingHost></div><div> <Host>127.0.0.1</Host></div><div> <UserName>mythtv</UserName></div><div> <Password>******</Password></div><div> <DatabaseName>mythconverg</DatabaseName></div><div> <Port>3306</Port></div><div> </Database></div><div> <WakeOnLAN></div><div> <Enabled>0</Enabled></div><div> <SQLReconnectWaitTime>0</SQLReconnectWaitTime></div><div> <SQLConnectRetry>5</SQLConnectRetry></div><div> <Command>echo 'WOLsqlServerCommand not set'</Command></div><div> </WakeOnLAN></div><div></Configuration></div></div><div><div>mitchell@mythtv:/etc/mysql/mysql.conf.d$ cat mythtv.cnf</div><div>[mysqld]</div><div>bind-address=0.0.0.0</div><div>max_connections=100</div></div><div><br></div><div><br></div><div>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><br></div><div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Jan 16, 2018 at 6:14 PM, Mitchell Gore <span dir="ltr"><<a href="mailto:mitchell.gore@gmail.com" target="_blank">mitchell.gore@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">any other ideas on troubleshooting sql access?</div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Jan 16, 2018 at 9:36 AM, Jim Abernathy <span dir="ltr"><<a href="mailto:jfabernathy@outlook.com" target="_blank">jfabernathy@outlook.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF"><div><div class="m_-7312868332547574111h5">
<p><br>
</p>
<br>
<div class="m_-7312868332547574111m_6424421716992154615moz-cite-prefix">On 01/16/2018 09:39 AM, Mitchell Gore wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">Hello,
<div><br>
</div>
<div>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><br>
</div>
<div>
<div>Setting up mysql-server-5.7 (5.7.20-0ubuntu0.16.04.1) ...</div>
<div>Renaming removed key_buffer and myisam-recover options (if present)</div>
<div>ERROR: Unable to start MySQL server:</div>
<div>2018-01-16T00:28:57.390552Z 0 [ERROR] unknown variable 'table_cache=128'</div>
<div>2018-01-16T00:28:57.392762Z 0 [ERROR] Aborting</div>
<div>Please take a look at <a href="https://wiki.debian.org/Teams/MySQL/FAQ" target="_blank">
https://wiki.debian.org/Teams/<wbr>MySQL/FAQ</a> for tips on fixing common upgrade issues.</div>
<div>Once the problem is resolved, run apt-get --fix-broken install to retry.</div>
<div>dpkg: error processing package mysql-server-5.7 (--configure):</div>
<div> subprocess installed post-installation script returned error exit status 1</div>
<div>dpkg: dependency problems prevent configuration of mysql-server:</div>
<div> mysql-server depends on mysql-server-5.7; however:</div>
<div> Package mysql-server-5.7 is not configured yet.</div>
<div><br>
</div>
<div>dpkg: error processing package mysql-server (--configure):</div>
<div> dependency problems - leaving unconfigured</div>
<div>Errors were encountered while processing:</div>
<div> mysql-server-5.7</div>
<div> mysql-server</div>
</div>
<div><br>
</div>
<div>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><br>
</div>
<div>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><br>
</div>
<div>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><br>
</div>
<div>Thanks,</div>
<div>Mitchell</div>
</div>
</blockquote>
<br></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>
<br>
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>
<br>
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.
<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>com/2018/01/creating-combined-<wbr>mythtv-headless.html</a><br>
<br>
Jim A<span><br>
<br>
<blockquote type="cite">
<br>
<fieldset class="m_-7312868332547574111m_6424421716992154615mimeAttachmentHeader"></fieldset> <br>
<pre>______________________________<wbr>_________________
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>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>_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>
</span></div>
<br>______________________________<wbr>_________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org" target="_blank">mythtv-users@mythtv.org</a><br>
<a href="http://lists.mythtv.org/mailman/listinfo/mythtv-users" rel="noreferrer" target="_blank">http://lists.mythtv.org/mailma<wbr>n/listinfo/mythtv-users</a><br>
<a href="http://wiki.mythtv.org/Mailing_List_etiquette" rel="noreferrer" target="_blank">http://wiki.mythtv.org/Mailing<wbr>_List_etiquette</a><br>
MythTV Forums: <a href="https://forum.mythtv.org" rel="noreferrer" target="_blank">https://forum.mythtv.org</a><br>
<br></blockquote></div><br></div>
</div></div></blockquote></div><br></div>