<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">On 07/16/2016 11:09 PM, Mark Perkins
wrote:<br>
</div>
<blockquote
cite="mid:SG2PR03MB1903E3A2CFEF9EE691751058B7350@SG2PR03MB1903.apcprd03.prod.outlook.com"
type="cite">
<blockquote type="cite">
<pre wrap="">The password was the first thing I fixed in the process of restoring the
database.
</pre>
</blockquote>
<pre wrap="">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.
</pre>
<blockquote type="cite">
<pre wrap="">$ 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 |
+-----------------+--------------+------------+
</pre>
</blockquote>
<pre wrap="">This is good, means connected ok and shows that expecting backend on 192.168.63.3
</pre>
<blockquote type="cite">
<pre wrap="">$ 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 -
</pre>
</blockquote>
<pre wrap="">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.
</pre>
<blockquote type="cite">
<pre wrap="">$ 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
# <a class="moz-txt-link-freetext" href="http://dev.mysql.com/doc/mysql/en/server-system-variables.html">http://dev.mysql.com/doc/mysql/en/server-system-variables.html</a>
#
# * 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 "::"?
</pre>
</blockquote>
<pre wrap="">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'"
_______________________________________________
mythtv-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a>
<a class="moz-txt-link-freetext" href="http://lists.mythtv.org/mailman/listinfo/mythtv-users">http://lists.mythtv.org/mailman/listinfo/mythtv-users</a>
<a class="moz-txt-link-freetext" href="http://wiki.mythtv.org/Mailing_List_etiquette">http://wiki.mythtv.org/Mailing_List_etiquette</a>
MythTV Forums: <a class="moz-txt-link-freetext" href="https://forum.mythtv.org">https://forum.mythtv.org</a>
</pre>
</blockquote>
<p>$ sudo netstat -peanut | grep 3306<br>
[sudo] password for dpeale: <br>
tcp 0 0 127.0.0.1:3306
0.0.0.0:* LISTEN 123 18287
1429/mysqld <br>
</p>
<p>This is a single computer mythTV setup, so external access is not
expected.</p>
<p>The IP address of this computer is 192.168.63.3 so for this
machine, it should work the same as 127.0.0.1 or localhost.</p>
<p>$ ls /etc/mysql/conf.d<br>
mysql.cnf mysqldump.cnf mythtv.cnf<br>
</p>
<p>$ ls /etc/mysql/mysql.conf.d/<br>
mysqld.cnf mysqld_safe_syslog.cnf mythtv.cnf</p>
<p>$ cat /etc/mysql/conf.d/mysql.cnf<br>
[mysql]<br>
</p>
<p>$ cat /etc/mysql/conf.d/mysqldump.cnf <br>
[mysqldump]<br>
quick<br>
quote-names<br>
max_allowed_packet = 16M<br>
</p>
<p>$ cat /etc/mysql/conf.d/mythtv.cnf <br>
[mysqld]<br>
#bind-address=::<br>
max_connections=100<br>
<br>
</p>
<p>$ cat /etc/mysql/mysql.conf.d/mysqld.cnf <br>
#<br>
# The MySQL database server configuration file.<br>
#<br>
# You can copy this to one of:<br>
# - "/etc/mysql/my.cnf" to set global options,<br>
# - "~/.my.cnf" to set user-specific options.<br>
# <br>
# One can use all long options that the program supports.<br>
# Run program with --help to get a list of available options and
with<br>
# --print-defaults to see which it would actually understand and
use.<br>
#<br>
# For explanations see<br>
# <a class="moz-txt-link-freetext"
href="http://dev.mysql.com/doc/mysql/en/server-system-variables.html">http://dev.mysql.com/doc/mysql/en/server-system-variables.html</a><br>
<br>
# This will be passed to all mysql clients<br>
# It has been reported that passwords should be enclosed with
ticks/quotes<br>
# escpecially if they contain "#" chars...<br>
# Remember to edit /etc/mysql/debian.cnf when changing the socket
location.<br>
<br>
# Here is entries for some specific programs<br>
# The following values assume you have at least 32M ram<br>
<br>
[mysqld_safe]<br>
socket = /var/run/mysqld/mysqld.sock<br>
nice = 0<br>
<br>
[mysqld]<br>
#<br>
# * Basic Settings<br>
#<br>
user = mysql<br>
pid-file = /var/run/mysqld/mysqld.pid<br>
socket = /var/run/mysqld/mysqld.sock<br>
port = 3306<br>
basedir = /usr<br>
datadir = /var/lib/mysql<br>
tmpdir = /tmp<br>
lc-messages-dir = /usr/share/mysql<br>
skip-external-locking<br>
#<br>
# Instead of skip-networking the default is now to listen only on<br>
# localhost which is more compatible and is not less secure.<br>
bind-address = 127.0.0.1<br>
#<br>
# * Fine Tuning<br>
#<br>
key_buffer_size = 16M<br>
max_allowed_packet = 16M<br>
thread_stack = 192K<br>
thread_cache_size = 8<br>
# This replaces the startup script and checks MyISAM tables if
needed<br>
# the first time they are touched<br>
myisam-recover-options = BACKUP<br>
#max_connections = 100<br>
#table_cache = 64<br>
#thread_concurrency = 10<br>
#<br>
# * Query Cache Configuration<br>
#<br>
query_cache_limit = 1M<br>
query_cache_size = 16M<br>
#<br>
# * Logging and Replication<br>
#<br>
# Both location gets rotated by the cronjob.<br>
# Be aware that this log type is a performance killer.<br>
# As of 5.1 you can enable the log at runtime!<br>
#general_log_file = /var/log/mysql/mysql.log<br>
#general_log = 1<br>
#<br>
# Error log - should be very few entries.<br>
#<br>
log_error = /var/log/mysql/error.log<br>
#<br>
# Here you can see queries with especially long duration<br>
#log_slow_queries = /var/log/mysql/mysql-slow.log<br>
#long_query_time = 2<br>
#log-queries-not-using-indexes<br>
#<br>
# The following can be used as easy to replay backup logs or for
replication.<br>
# note: if you are setting up a replication slave, see
README.Debian about<br>
# other settings you may need to change.<br>
#server-id = 1<br>
#log_bin = /var/log/mysql/mysql-bin.log<br>
expire_logs_days = 10<br>
max_binlog_size = 100M<br>
#binlog_do_db = include_database_name<br>
#binlog_ignore_db = include_database_name<br>
#<br>
# * InnoDB<br>
#<br>
# InnoDB is enabled by default with a 10MB datafile in
/var/lib/mysql/.<br>
# Read the manual for more InnoDB related options. There are many!<br>
#<br>
# * Security Features<br>
#<br>
# Read the manual, too, if you want chroot!<br>
# chroot = /var/lib/mysql/<br>
#<br>
# For generating SSL certificates I recommend the OpenSSL GUI
"tinyca".<br>
#<br>
# ssl-ca=/etc/mysql/cacert.pem<br>
# ssl-cert=/etc/mysql/server-cert.pem<br>
# ssl-key=/etc/mysql/server-key.pem<br>
</p>
<p>$ cat /etc/mysql/mysql.conf.d/mysqld_safe_syslog.cnf <br>
[mysqld_safe]<br>
syslog<br>
</p>
<p>The mythv.cnf in mysql.conf.d is a link to the one in conf.d<br>
</p>
<p>Edited mythtv.cnf and rebooted.<br>
</p>
<p>$ sudo netstat -peanut | grep 3306<br>
[sudo] password for dpeale: <br>
tcp 0 0 0.0.0.0:3306
0.0.0.0:* LISTEN 123 23660
1479/mysqld <br>
</p>
<p>$ mysql -umythtv -pb0RhwvPj -e "select * from
mythconverg.settings where value='BackendServerIP'"<br>
mysql: [Warning] Using a password on the command line interface
can be insecure.<br>
+-----------------+--------------+------------+<br>
| value | data | hostname |<br>
+-----------------+--------------+------------+<br>
| BackendServerIP | 192.168.63.3 | Compromise |<br>
| BackendServerIP | 192.168.63.3 | Compromise |<br>
+-----------------+--------------+------------+</p>
<p>$ mysql -h192.168.63.3 -umythtv -pb0RhwvPj -e "select * from
mythconverg.settings where value='BackendServerIP'"<br>
mysql: [Warning] Using a password on the command line interface
can be insecure.<br>
ERROR 1045 (28000): Access denied for user 'mythtv'@'192.168.63.3'
(using password: YES)<br>
</p>
<p><br>
</p>
<p>I need to get some sleep. I'll resume this in the morning.<br>
</p>
</body>
</html>