[mythtv-users] mythweb unable to connect after upgrade to 028

[Stephen Worthington]

On Sun, 8 May 2016 17:58:23 -0500, you wrote:

>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.
>
>I am thinking that's a bug in mythbuntu control center?
>
>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.

Yes, it is a bug in Mythbuntu Control Center, but you probably do need
the tweaks in that file, so it would be better to fix the table_cache
option.  These days, it should read:

  table_open_cache = 128

The table_cache spelling of this option was accepted in mysql versions
long after the official change of spelling, but MCC never caught up
with that and in 16.04 the new mysql version finally stopped accepting
the old spelling.  I would recommend to anyone reading this post who
is still using the table_cache option in older versions of Mythbuntu
to change it now so they do not get caught out when they upgrade.