[mythtv-users] 0.28 upgrade issue frontend connection

[Douglas Peale]

On 07/16/2016 09:23 PM, Mark Perkins wrote:
>
>> -----Original Message-----
>> From: Douglas Peale [mailto:Douglas_Peale at comcast.net]
>> Sent: Sunday, 17 July 2016 12:49 PM
>> To: Mark Perkins <perkins1724 at hotmail.com>; Discussion about MythTV
>> <mythtv-users at mythtv.org>
>> Subject: Re: [mythtv-users] 0.28 upgrade issue frontend connection
>>
>> $ mysql -uroot -pb0RhwvPj -e "show grants for 'mythtv'@'%'"
>> mysql: [Warning] Using a password on the command line interface can be
>> insecure.
>> +---------------------------------------------------------+
>> | Grants for mythtv@%                                     |
>> +---------------------------------------------------------+
>> | GRANT USAGE ON *.* TO 'mythtv'@'%'                      |
>> | GRANT ALL PRIVILEGES ON `mythconverg`.* TO 'mythtv'@'%' |
>> +---------------------------------------------------------+
>>
>>
> Douglas by the book that should be fine so lets leave as is for now and try a few other things. Lets confirm passwords are correct. Run the following command to re-update password for mythtv user in mysql:
>
> mysql -uroot -p -e "set password for 'mythtv'@'%'='your_desired_mythtv_password'"
>
> Where your_desired_mythtv_password should be the same as that in your config.xml file (normally stored in ~/.mythtv of the user running your backend but I am not particularly familiar with Mint). Now lets see if we can access from the machine hosting your backend (assuming your mysql server is on your backend):
>
> mysql -umythtv -pyour_desired_mythtv_password -e "select * from mythconverg.settings where value='BackendServerIP'"
>
> If that fails lets check what is listening on port 3306 by running this command on the backend as the root user:
>
> netstat -peanut | grep 3306
>
> Have you checked for bind_address values in your mysql config files? I don't know what their location will be in Mint but at a start you are probably looking for my.cnf and/or mythtv.cnf. Try /etc/mysql/mysql.cnf and /etc/mysql/mysql.conf.d/mythtv.cnf. If nothing at those locations try:
>
> find /etc -name my.cnf
>
> In the first instance we should be able to see what mysql is binding to from the netstat command above anyway.

The password was the first thing I fixed in the process of restoring the database.

$ 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 |
+-----------------+--------------+------------+

$ 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       -              

$ 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 "::"?


-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 819 bytes
Desc: OpenPGP digital signature
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20160716/34e1e7ff/attachment.sig>