[mythtv-users] .29 won't connect to backend

[Stephen Worthington]

On Tue, 16 Oct 2018 06:32:33 -0500, you wrote:

>On 10/15/2018 09:25 PM, Stephen Worthington wrote:
>> On Mon, 15 Oct 2018 20:01:15 -0500, you wrote:
>> 
>>> On 10/15/2018 07:10 PM, Mark Perkins wrote:
>>>>
>>>>
>>>> On 16 October 2018 10:33:46 am Jack McGee <jack at greendesk.net> wrote:
>>>>
>>>>> On 10/15/2018 02:04 PM, Jack McGee wrote:
>>>>>> I upgraded a 16.04 frontend and 16.04 backend from .28 to .29.
>
>> 
>> It is not connecting to the database.  Are you running MariaDB or
>> MySQL?  Is mysqld running?  What do these commands show:
>> 
>> sudo netstat -alnp | grep 3306
>> sudo ps -ef | grep mysql
>> sudo systemctl status mysql
>
>mythuser at amethi:/var/log/mythtv$ sudo netstat -alnp | grep 3306
>[sudo] password for mythuser:
>tcp        0      0 192.168.1.105:3306      0.0.0.0:* 
>LISTEN      1189/mysqld

This looks like it may be the problem.  MySQL is only listening on one
IP address, 192.168.1.105, which I presume is the IP address of the
Ethernet card.  So trying to connect on localhost is not going to
work.  You either need to change the "localhost" in all your
config.xml files to "192.168.1.105", or you need to change the
"bind-address=" settings in your MySQL config.  The latter is the
better option, unless this PC has multiple Ethernet cards.  So go to
/etc/mysql and do this command:

grep -r "bind-address" *

Make sure you have only one that is not commented out, and change it
to:

bind-address=*

>mythuser at amethi:/var/log/mythtv$ sudo ps -ef | grep mysql
>mysql     1189     1  0 Oct15 ?        00:01:04 /usr/sbin/mysqld
>mythuser 15960  4038  0 06:28 pts/2    00:00:00 grep --color=auto mysql
>
>
>mythuser at amethi:/var/log/mythtv$ sudo systemctl status mysql
>? mysql.service - MySQL Community Server
>    Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor 
>preset: enabled)
>    Active: active (running) since Mon 2018-10-15 19:54:28 CDT; 10h ago
>   Process: 1191 ExecStartPost=/usr/share/mysql/mysql-systemd-start post 
>(code=exited, status=0/SUCCESS)
>   Process: 1165 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre 
>(code=exited, status=0/SUCCESS)
>  Main PID: 1189 (mysqld)
>    CGroup: /system.slice/mysql.service
>            ??1189 /usr/sbin/mysqld
>
>Oct 15 19:54:27 amethi systemd[1]: Starting MySQL Community Server...
>Oct 15 19:54:28 amethi systemd[1]: Started MySQL Community Server.
>
>I am not sure if I am running Mariadb or Mysql.  This has always run 
>Mysql so I assume it still is.

You are running MySQL - the "MySQL Community Server" above gives that
away.