[mythtv-users] 0.28 upgrade issue frontend connection

[Mark Perkins]

> The password was the first thing I fixed in the process of restoring the
> database.
> 
Yes, I saw that but mysql can have a different password per host and iirc from a quick read of the forums you used a host value of localhost. But, doesn't matter because next bit shows that your password is working.

> $ mysql -umythtv -pb0RhwvPj -e "select * from mythconverg.settings where
> value='BackendServerIP'"
> mysql: [Warning] Using a password on the command line interface can be
> insecure.
> +-----------------+--------------+------------+
> | value           | data         | hostname   |
> +-----------------+--------------+------------+
> | BackendServerIP | 192.168.63.3 | Compromise | BackendServerIP |
> | 192.168.63.3 | Compromise |
> +-----------------+--------------+------------+
> 
This is good, means connected ok and shows that expecting backend on 192.168.63.3

> $ netstat -peanut | 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.)
> tcp        0      0 127.0.0.1:3306          0.0.0.0:*               LISTEN      123        18287       -
> 
Need to run netstat as root. I don’t know Mint but I assume something like:

sudo netstat -peanut | grep 3306

But at face value I think that mysql is binding to 127.0.0.1 ie localhost only. So remote connections won't work. If you only want to run a local mythfrontend you could try changing the ip address in your config.xml file to be 127.0.0.1 and restart backend and start frontend and see if that works. If you are looking to connect remote frontend(s) then see below.

> $ cat /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/
> 
> $ cat /etc/mysql/mysql.conf.d/mythtv.cnf
> [mysqld]
> #bind-address=::
> max_connections=100
> 
> 
> 
> Should that bind-address be something other that "::"?
> 
That bind-address is commented out so won't apply. But I note with interest it is an IPv6 format. I must admit I have disabled IPv6 on my boxes to dodge any potential complication that might cause. However shouldn’t necessarily be a problem.

First lets see if there are any other cnf files for mysql. Execute the following two commands:

ls /etc/mysql/conf.d/
ls /etc/mysql/mysql.conf.d/

If there are any other files in those two directories cat them and post so we can have a quick look. If /etc/mysql/mysql.conf.d/mythtv.cnf is the only file then uncomment the bind-address line by deleting the # at the front and change the :: address to be 0.0.0.0 (binds to everything, can tighten it up later once things are working).

Restart mysql. I have no idea if Mint runs systemd or not, try as root user:
systemctl restart mysqld

Or else try:
service mysqld restart

Or worst case just reboot.

Then re-run:
sudo netstat -peanut | grep 3306

And we can compare to previous run.

Check if this works:
mysql -umythtv -pb0RhwvPj -e "select * from mythconverg.settings where value='BackendServerIP'"

If it still does try this:
mysql -h192.168.63.3 -umythtv -pb0RhwvPj -e "select * from mythconverg.settings where value='BackendServerIP'"