[mythtv-users] One step forward, two steps back - Frontends not woring properly

[Vincent McIntyre]

On Sat, Apr 30, 2016 at 04:32:53PM +0100, Damian wrote:
> > 
> > What this shows is mysql is listening on ipv6 but not ipv4.
> > First check your /sbin/ifconfig output. Should be safe to post it here,
> > it's on an unroutable network. If there is an interface with an IP
> > address that is not in 192.168.0.0/24, leave that out.
> 
> Thanks Vincent. Here you go ...
> 
> $ /sbin/ifconfig
> enp2s0    Link encap:Ethernet  HWaddr 00:9c:02:97:55:54
>           inet addr:192.168.0.2  Bcast:192.168.0.255  Mask:255.255.255.0
>           inet6 addr: fe80::3b9c:8e34:fb44:2847/64 Scope:Link
>           UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
>           RX packets:3488095 errors:0 dropped:0 overruns:0 frame:0
>           TX packets:5707203 errors:0 dropped:0 overruns:0 carrier:0
>           collisions:0 txqueuelen:1000
>           RX bytes:1009176206 (1.0 GB)  TX bytes:8235960424 (8.2 GB)
>           Interrupt:18
> 
> lo        Link encap:Local Loopback
>           inet addr:127.0.0.1  Mask:255.0.0.0
>           inet6 addr: ::1/128 Scope:Host
>           UP LOOPBACK RUNNING  MTU:65536  Metric:1
>           RX packets:2377579 errors:0 dropped:0 overruns:0 frame:0
>           TX packets:2377579 errors:0 dropped:0 overruns:0 carrier:0
>           collisions:0 txqueuelen:1
>           RX bytes:373000387 (373.0 MB)  TX bytes:373000387 (373.0 MB)
 
Interesting. There is an IPv4 interface but the name is unusual,
I was expecting it to be called eth0 not enp2s0.
Nonetheless it seems you have a working interface with a IPv4 address
and from what you say below it is responding to other hosts.

For clarity, are there other network interfaces that you have left out?

> > 
> > Is your network configured by network-manager or /etc/network/interfaces?
> > 
> 
> I'm not sure what you mean by this. I set up static IP's on my router if
> that helps.
> 

On an ubuntu system you can tell the machine how you want the network
interfaces set up by editing the file /etc/network/interfaces.
However I think the default is for 'network-manager' to look after all
the network settings, through a GUI interface. You can mix and match too,
if you set up an interface with /etc/network/interfaces,
network-manager will not try to configure that interface.

> > Other checks to try on the backend, please report pass/fail
> > a) ping 192.168.0.2
> >     is it pinging (pass) or not responding
> >     eg 4 bytes from 192.168.0.2 icmp_seq=1 ttl=64 time=0.021 ms
> 
> Pass from the box itself and from the windows machine I'm connecting to it
> with via SSH. I can't check the remote frontends at the moment, but I've
> checked 192.168.0.2/mythweb with both of them before, and that was working
> fine.

So this means your IPv4 address is working and some services are
listening on that address, but not mysql.

> > c) repeat a) & b) from one of the frontends
> >    If a & b pass but c fails, could be a firewall but there are other
> >    possible issues.
> >    Please post the ip address of the machine you tested from too.
> > 
> > Vince
> > 
> I'll do this from the frontends as soon as I can.
 
Ok.

My next suggestion would be posting the mysql config files.
This incantation should do the trick
  cd /etc/mysql
  sudo find . -type f -name "*.cnf" \
              -exec egrep -Hv '^(\s*#|$)' {} \; | grep -v debian.cnf

This will print out just the active lines in the config files.
The last bit suppresses the content of debian.cnf (it has a password).

Vince