<div dir="ltr">OK,<div><br></div><div>I think I know what happened. Since this is mythbuntu, at some point while troubleshooting I used the 'mythbuntu control center' and enabled 'mysql performance tweaks' - I guess that adds a file called "mythtv-tweaks.cnf" in the /etc/mysql/conf.d directory, and that file contains the line 'table_cache = 128' which is no longer correct.</div><div><br></div><div>I am thinking that's a bug in mythbuntu control center? </div><div><br></div><div>Anyway, renaming that file so it no longer has a .cnf extension allows mysql to come up properly and as of my last reboot, both it and mythbackend were there waiting for me. </div><div><br></div><div>I was also having a audio configuration issue, I guess my mainboard audio decided now was a good time to fizzle out, but luckily I had an old system with an even older soundcard that I was able to put in my server and after finding and downloading it's firmware, got that up and running.</div><div><br></div><div>I think I am doing OK now.... will let this go for a few days and see how it goes and then set my frontend to launch automatically again and we should be back to normal.</div><div><br></div><div>Keeping my fingers crossed!</div><div><br></div><div>George</div></div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature">-- George</div></div>
<br><div class="gmail_quote">On Sun, May 8, 2016 at 12:51 PM, George Bingham <span dir="ltr"><<a href="mailto:georgeb1962@gmail.com" target="_blank">georgeb1962@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">Hey Bill, <div><br></div><div>I think you can see my reply to Richard where I list the mysql service file.</div><div><br></div><div>My run files are different than yours, not sure why:</div><div><br></div><div><div><font size="1"><i> ls -ld /run/mysqld /run/mysqld/*</i></font></div><div><font size="1"><i>drwxr-xr-x 2 mysql mysql 100 May 7 17:17 /run/mysqld</i></font></div><div><font size="1"><i>-rw-r----- 1 mysql mysql 5 May 7 17:17 /run/mysqld/mysqld.pid</i></font></div><div><font size="1"><i>srwxrwxrwx 1 mysql mysql 0 May 7 17:17 /run/mysqld/mysqld.sock</i></font></div><div><font size="1"><i>-rw------- 1 mysql mysql 5 May 7 17:17 /run/mysqld/mysqld.sock.lock</i></font></div></div><div><br></div><div>Owner and group are mysql. </div><span class="HOEnZb"><font color="#888888"><div><br></div></font></span></div><div class="gmail_extra"><span class="HOEnZb"><font color="#888888"><br clear="all"><div><div>-- George</div></div></font></span><div><div class="h5">
<br><div class="gmail_quote">On Sun, May 8, 2016 at 9:26 AM, Bill Meek <span dir="ltr"><<a href="mailto:keemllib@gmail.com" target="_blank">keemllib@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span>On 05/07/2016 09:48 PM, George Bingham wrote:<br>
...<br></span><span>
> I *think* have have it using a proper ipv6 address, however, booting up I<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
still see problems.<br>
</blockquote>
<br></span>
Likely ::1<br>
<br>
...<span><br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
I am not sure why, but mysql is refusing connections because although it is<br>
"up" it's socket address isn't there yet.<br>
</blockquote>
<br></span>
I see this, noting the mysql owner and root user:<br>
<br>
$ ls -ld /run/mysqld /run/mysqld/*<br>
drwxr-xr-x 2 mysql root 80 May 8 07:02 /run/mysqld<br>
-rw-rw---- 1 mysql root 5 May 8 07:02 /run/mysqld/mysqld.pid<br>
srwxrwxrwx 1 mysql root 0 May 8 07:02 /run/mysqld/mysqld.sock<br>
<br>
I may have deleted too many old emails on this thread, but don't see the<br>
.service file you're using to start mysql. How 'bout doing this:<br>
<br>
systemctl cat mysql<then type the tab character twice><br>
<br>
That will give you a list of the (or all) .service files in use. Please<br>
select and pastebin a copy of each file.<br>
<br>
...<span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Are you happy with having to restart the backend at the tail end of the<br>
boot process or have you found a way to make it all just "work".<br>
</blockquote>
<br></span>
Mine just work, so I'm happy.<div><div><br>
<br>
-- <br>
Bill<br>
_______________________________________________<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/mailman/listinfo/mythtv-users</a><br>
<a href="http://wiki.mythtv.org/Mailing_List_etiquette" rel="noreferrer" target="_blank">http://wiki.mythtv.org/Mailing_List_etiquette</a><br>
MythTV Forums: <a href="https://forum.mythtv.org" rel="noreferrer" target="_blank">https://forum.mythtv.org</a><br>
</div></div></blockquote></div><br></div></div></div>
</blockquote></div><br></div>