[mythtv-users] One step forward, two steps back - Frontends not woring properly
Damian
myth at surr.co.uk
Sat Apr 30 00:14:35 UTC 2016
On 30/04/2016 00:26, Mark Perkins wrote:
>> On 29/04/2016 23:13, Damian wrote:
>>
>>> On 29/04/2016 23:09, Thomas Mashos wrote:
>>>
> ...snip...
>>> On your backend, is mysql listening on the right addresses?
>>> --
>>> Thomas Mashos
>> Hi Thomas,
>>
>> I can log in with ...
>> mysql -u mythtv -p -h 192.168.0.2
>>
>> Does that answer your question? If it doesn't, I'm afraid I don't understand the question well enough. Is there a command that I should run to test it?
>>
>> Thanks,
>> Damian
> To check whether mysql is listening on the right address run this command as root user
> netstat -tulpn | grep 3306
Hi Mark,
Here's the output from that:
$ netstat -tulpn | grep 3306
(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
tcp6 0 0 :::3306 :::* LISTEN -
and with sudo ...
sudo netstat -tulpn | grep 3306
tcp6 0 0 :::3306 :::* LISTEN 819/mysqld
I'm guessing, from your comments regarding IP addresses, that this isn't
right? There are no ip addresses there.
Should I post the output of ifcongig, or would that be a stupid security
risk to post publicly?
> And post results. If it returns the proper IP address (assuming your machine has been given a proper IP address) of your machine it should be ok but if it returns 127.0.0.1 then it is only listening on the local machine. In which case find your mysqld.cnf file probably /etc/mysql/mysql.conf.d/mysqld.cnf and comment out the line that says bind-address = 127.0.0.1. Recent thread here - http://www.gossamer-threads.com/lists/mythtv/users/58782
That line is already commented out in that file.
> If it returns nothing then mysql is probably not running. Check its running
> systemctl status mysql
$ systemctl status mysql
● mysql.service - MySQL Community Server
Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor
preset: enabled)
Active: active (running) since Fri 2016-04-29 23:03:24 BST; 2h 3min ago
Process: 820 ExecStartPost=/usr/share/mysql/mysql-systemd-start post
(code=exited, status=0/SUCCESS)
Process: 802 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre
(code=exited, status=0/SUCCESS)
Main PID: 819 (mysqld)
Tasks: 48 (limit: 512)
CGroup: /system.slice/mysql.service
└─819 /usr/sbin/mysqld
Apr 29 23:03:04 gingerserver systemd[1]: Starting MySQL Community Server...
Apr 29 23:03:24 gingerserver systemd[1]: Started MySQL Community Server.
> I think, I don’t run Mythbuntu.
>
> I'm going to guess based on recent posts that it's not running and has errors like:
> [ERROR] unknown variable 'table_cache=128'
>
> In which case edit /etc/mysql/conf.d/mythtv-tweaks.cnf and replace the line
> table_cache=128
>
> with
> table_open_cache=128
>
> or else just comment out the line entirely. Info here - https://bugs.launchpad.net/mythbuntu/+bug/1575864
I came across that one earlier. That's already hashed out.
What's next? :-)
Thanks,
Damian
More information about the mythtv-users
mailing list