<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<blockquote
cite="mid:04cf584d-4188-d570-f309-3d58a7208700@greendesk.net"
type="cite">
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
<div class="moz-cite-prefix">On 08/31/2016 09:53 PM, Ozzy Lash
wrote:<br>
</div>
<blockquote
cite="mid:CAM4zO3rxzJv1PzRMJeJo5EvnHx1E0gpyg1W12RUvde9G-tp0uw@mail.gmail.com"
type="cite">
<div dir="ltr"><br>
<div class="gmail_extra"><br>
<div class="gmail_quote"><br>
<div>You may want to take a step back and look at your
mysql configuration on the backend. From your netstat
output, it doesn't look to me like it is listening for
connections from remote hosts, only from the local
host. <br>
<br>
</div>
<div>One way to test this out is to go to the frontend and
do a<br>
<br>
</div>
<div>mysql -h 192.168.0.105 -u mythtv mythconverg<br>
<br>
</div>
<div>(since you have no password set on the db, if you did
have a password you would need to use the -p option)<br>
</div>
</div>
</div>
</div>
</blockquote>
<br>
<br>
mythuser@mythuser-ZBOX-ID84:/var/log/mythtv$ mysql -h
192.168.0.105 -u mythtv mythconverg<br>
ERROR 1045 (28000): Access denied for user
'mythtv'@'192.168.0.163' (using password: NO)<br>
<br>
<blockquote
cite="mid:CAM4zO3rxzJv1PzRMJeJo5EvnHx1E0gpyg1W12RUvde9G-tp0uw@mail.gmail.com"
type="cite">
<div dir="ltr">
<div class="gmail_extra">
<div class="gmail_quote">
<div><br>
</div>
<div>If you can't connect from the frontend then that is
(at least one) problem. For mysql, the way to get it to
listen for connections from remote hosts was to set in
either my.conf in the /etc/mysql directory, or in a file
in the /etc/mysql/conf.d directory:<br>
<br>
</div>
<div>[mysqld]<br>
</div>
<div>bind-address = 192.168.0.105<br>
<br>
</div>
</div>
</div>
</div>
</blockquote>
</blockquote>
<br>
It did not have that line, so I added it:<br>
<br>
<blockquote
cite="mid:04cf584d-4188-d570-f309-3d58a7208700@greendesk.net"
type="cite">
<blockquote
cite="mid:CAM4zO3rxzJv1PzRMJeJo5EvnHx1E0gpyg1W12RUvde9G-tp0uw@mail.gmail.com"
type="cite">
<div dir="ltr">
<div class="gmail_extra">
<div class="gmail_quote">
<div> </div>
</div>
</div>
</div>
</blockquote>
mythuser@amethi:/etc/mysql$ cat my.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 moz-do-not-send="true" 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>
#<br>
# * IMPORTANT: Additional settings that can override those from
this file!<br>
# The files must end with '.cnf', otherwise they'll be ignored.<br>
#<br>
<br>
!includedir /etc/mysql/conf.d/<br>
!includedir /etc/mysql/mysql.conf.d/<br>
<br>
[mysqld]<br>
bind-address = 192.168.0.105<br>
</blockquote>
<br>
<br>
<br>
<blockquote
cite="mid:04cf584d-4188-d570-f309-3d58a7208700@greendesk.net"
type="cite">mythuser@amethi:/etc/mysql$ sudo service mysql restart<br>
<br>
<br>
</blockquote>
complete frontend log:<br>
<a class="moz-txt-link-freetext" href="https://app.box.com/s/kk7y2k39arkcirn86efrl03y8k30kb22">https://app.box.com/s/kk7y2k39arkcirn86efrl03y8k30kb22</a><br>
<br>
Sep 1 05:51:39 mythuser-ZBOX-ID84 mythfrontend.real:
mythfrontend[5364]: N thread_unknown mythdirs.cpp:192
(InitializeMythDirs) Using runtime prefix = /usr<br>
Sep 1 05:51:39 mythuser-ZBOX-ID84 mythfrontend.real:
mythfrontend[5364]: N thread_unknown mythdirs.cpp:194
(InitializeMythDirs) Using configuration directory =
/home/mythuser/.mythtv<br>
Sep 1 05:51:39 mythuser-ZBOX-ID84 mythfrontend.real:
mythfrontend[5364]: I Logger logging.cpp:313 (run) Added logging to
the console<br>
Sep 1 05:51:39 mythuser-ZBOX-ID84 mythfrontend.real:
mythfrontend[5364]: I CoreContext mythcorecontext.cpp:266 (Init)
Assumed character encoding: en_US.UTF-8<br>
Sep 1 05:51:39 mythuser-ZBOX-ID84 mythfrontend.real:
mythfrontend[5364]: E CoreContext mythdbparams.cpp:49 (IsValid)
DBPassword is not set in config.xml<br>
Sep 1 05:51:39 mythuser-ZBOX-ID84 mythfrontend.real:
mythfrontend[5364]: E CoreContext mythdbparams.cpp:39 (IsValid)
DBHostName is not set in config.xml<br>
Sep 1 05:51:39 mythuser-ZBOX-ID84 mythfrontend.real:
mythfrontend[5364]: N CoreContext mythcontext.cpp:505
(LoadDatabaseSettings) Empty LocalHostName.<br>
Sep 1 05:51:39 mythuser-ZBOX-ID84 mythfrontend.real:
mythfrontend[5364]: I CoreContext mythcontext.cpp:513
(LoadDatabaseSettings) Using localhost value of mythuser-ZBOX-ID84<br>
Sep 1 05:51:39 mythuser-ZBOX-ID84 mythfrontend.real:
mythfrontend[5364]: E CoreContext mythdbcon.cpp:229 (OpenDatabase)
[DBManager0] Unable to connect to database!<br>
Sep 1 05:51:39 mythuser-ZBOX-ID84 mythfrontend.real:
mythfrontend[5364]: E CoreContext mythdbcon.cpp:230 (OpenDatabase)
Driver error was [1/2002]:#012QMYSQL: Unable to connect#012Database
error was:#012Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2)<br>
SNIP<br>
<br>
Sep 1 05:51:43 mythuser-ZBOX-ID84 mythfrontend.real:
mythfrontend[5364]: I SendMessage mythcorecontext.cpp:436
(ConnectCommandSocket) MythCoreContext::ConnectCommandSocket():
Connecting to backend server: localhost:6543 (try 1 of 1)<br>
Sep 1 05:51:43 mythuser-ZBOX-ID84 mythfrontend.real:
mythfrontend[5364]: E SendMessage mythcorecontext.cpp:979
(GetBackendServerIP) MythCoreContext::GetBackendServerIP(): No
address defined for host: localhost<br>
Sep 1 05:51:43 mythuser-ZBOX-ID84 mythfrontend.real:
mythfrontend[5364]: N CoreContext mythcorecontext.cpp:1670
(InitLocale) Setting QT default locale to en_US<br>
Sep 1 05:51:43 mythuser-ZBOX-ID84 mythfrontend.real:
mythfrontend[5364]: E MythSocketThread(-1) mythsocket.cpp:729
(ConnectToHostReal) MythSocket(7fe154004a80:-1): Failed to connect
to (127.0.0.1:6543) Connection refused<br>
Sep 1 05:51:43 mythuser-ZBOX-ID84 mythfrontend.real:
mythfrontend[5364]: E SendMessage mythcorecontext.cpp:506
(ConnectCommandSocket) Connection to master server timed
out.#012#011#011#011Either the server is down or the master server
settings#012#011#011#011in mythtv-settings does not contain the
proper IP address<br>
Sep 1 05:51:43 mythuser-ZBOX-ID84 mythfrontend.real:
mythfrontend[5364]: I SendMessage mythcorecontext.cpp:436
(ConnectCommandSocket) MythCoreContext::ConnectCommandSocket():
Connecting to backend server: localhost:6543 (try 1 of 1)<br>
Sep 1 05:51:43 mythuser-ZBOX-ID84 mythfrontend.real:
mythfrontend[5364]: E SendMessage mythcorecontext.cpp:979
(GetBackendServerIP) MythCoreContext::GetBackendServerIP(): No
address defined for host: localhost<br>
Sep 1 05:51:43 mythuser-ZBOX-ID84 mythfrontend.real:
mythfrontend[5364]: E MythSocketThread(-1) mythsocket.cpp:729
(ConnectToHostReal) MythSocket(7fe154004810:-1): Failed to connect
to (127.0.0.1:6543) Connection refused<br>
Sep 1 05:51:43 mythuser-ZBOX-ID84 mythfrontend.real:
mythfrontend[5364]: E SendMessage mythcorecontext.cpp:506
(ConnectCommandSocket) Connection to master server timed
out.#012#011#011#011Either the server is down or the master server
settings#012#011#011#011in mythtv-settings does not contain the
proper IP address<br>
Sep 1 05:51:43 mythuser-ZBOX-ID84 mythfrontend.real:
mythfrontend[5364]: I SendMessage mythcorecontext.cpp:436
(ConnectCommandSocket) MythCoreContext::ConnectCommandSocket():
Connecting to backend server: localhost:6543 (try 1 of 1)<br>
repeats many times.<br>
SNIP<br>
<br>
Sep 1 05:51:47 mythuser-ZBOX-ID84 mythfrontend.real:
mythfrontend[5364]: E MythSocketThread(-1) mythsocket.cpp:729
(ConnectToHostReal) MythSocket(7fe144002b80:-1): Failed to connect
to (127.0.0.1:6543) Connection refused<br>
Sep 1 05:51:47 mythuser-ZBOX-ID84 mythfrontend.real:
mythfrontend[5364]: E SendMessage mythcorecontext.cpp:506
(ConnectCommandSocket) Connection to master server timed
out.#012#011#011#011Either the server is down or the master server
settings#012#011#011#011in mythtv-settings does not contain the
proper IP address<br>
<br>
</body>
</html>