[mythtv-users] Backend can't connect (it was all working fine!) - mysql strangeness

[Damian]

On 10/04/2016 22:09, Doug Lytle wrote:
> Damian wrote:
>> 2016-04-10 20:33:39 21635 [ERROR] /usr/sbin/mysqld: unknown variable 
>> 'table_cache=128'
>> 2016-04-10 20:33:39 21635 [ERROR] Aborting 
>
> You have table_cache in your my.cnf and your version of mysql doesn't 
> support it.
>
> You could remark that statement out with a # in front of it, save it 
> and restart mysql
>
> It's located (On my system) in /etc/mysql
>
> Doug
Hi Doug,

Here's the contents of my files:

locate my.cnf
/etc/alternatives/my.cnf
/etc/mysql/my.cnf
/etc/mysql/my.cnf.fallback
/var/lib/dpkg/alternatives/my.cnf

The contents of /etc/mysql/my.cnf:

#
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" to set user-specific options.
#
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html

#
# * IMPORTANT: Additional settings that can override those from this file!
#   The files must end with '.cnf', otherwise they'll be ignored.
#

!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mysql.conf.d/



The contents of /etc/mysql/conf.d/

mysql.cnf  mysqldump.cnf  mythtv.cnf  mythtv.cnf~  mythtv-tweaks.cnf

Most of those were fine, but myth-tweaks.cnf:

[mysqld]
# The following values were partly taken from:
# http://www.gossamer-threads.com/lists/mythtv/users/90942#90942
# key_buffer = 48M
# max_allowed_packet = 8M
table_cache = 128
sort_buffer_size = 48M
net_buffer_length = 8M
# thread_cache_size = 4
query_cache_type = 1
query_cache_size = 32M
# don't do binary logs for mythconverg
binlog_ignore_db = mythconverg

so I '#'ed out the table_cache line and saved the  file.

The contents of /etc/mysql/mysql.conf.d/

mysqld.cnf  mysqld_safe_syslog.cnf  mythtv.cnf

None of them had the table-cache entry.

I rebboted, and not only is the backend now running, but it's also fixed 
VNC! I can now log into that without having to SSH in first to manually 
start the x11vnc server.

Doug, you are a star!

I'm not sure where that mythtv-tweaks.cnf file came from (I assume it's 
a Mythbuntu thing), but that 1 line caused a big problem!

As it's a clean install, I was close to wiping the drive and starting 
again. Hopefully I wont need to do that now.

Thanks again Doug!

Cheers,
Damian