<div dir="ltr"><br><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Aug 31, 2016 at 9:00 PM, Jack McGee <span dir="ltr"><<a target="_blank" href="mailto:jack@greendesk.net">jack@greendesk.net</a>></span> wrote:<br><blockquote style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex" class="gmail_quote">
<div bgcolor="#FFFFFF">
<blockquote type="cite">
<div lang="x-unicode"><span class="gmail-">
<div>On 08/31/2016 08:35 PM, Joseph Fry
wrote:<br>
</div>
</span><blockquote type="cite"><span class="gmail-">
<p dir="ltr">You have no password set for the MythTV MySQL
acct. You need to update your config.xml accordingly.</p>
<br>
</span><div class="gmail_quote"><span class="gmail-">
<div dir="ltr">On Wed, Aug 31, 2016, 8:43 PM Jack McGee <<a target="_blank" href="mailto:jack@greendesk.net">jack@greendesk.net</a>>
wrote:<br>
</div>
</span><span class="gmail-"><blockquote style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex" class="gmail_quote"><br>
I do not see that. I see:<br>
<br>
<br>
mysql> SHOW GRANTS FOR mythtv;<br>
+-----------------------------<wbr>----------------------------+<br>
| Grants for mythtv@%
|<br>
+-----------------------------<wbr>----------------------------+<br>
| GRANT USAGE ON *.* TO 'mythtv'@'%'
|<br>
| GRANT ALL PRIVILEGES ON `mythconverg`.* TO 'mythtv'@'%'
|<br>
+-----------------------------<wbr>----------------------------+<br>
2 rows in set (0.00 sec)<br>
<br>
______________________________<wbr>_________________</blockquote>
</span></div>
</blockquote>
<br>
<br>
Here is revised config.xml<br>
<br>
<a target="_blank" href="mailto:mythuser@mythuser-ZBOX-ID84:%7E/.mythtv$">mythuser@mythuser-ZBOX-ID84:~/<wbr>.mythtv$</a>
cat config.xml<span class="gmail-"><br>
<Configuration><br>
<Database><br>
<PingHost>1</PingHost><br>
<Host>192.168.0.105</Host><br>
<UserName>mythtv</UserName><br></span>
<Password></Password><span class="gmail-"><br>
<DatabaseName>mythconverg</<wbr>DatabaseName><br>
<Port>3306</Port><br>
</Database><br>
<WakeOnLAN><br>
<Enabled>0</Enabled><br>
<SQLReconnectWaitTime>0</<wbr>SQLReconnectWaitTime><br>
<SQLConnectRetry>5</<wbr>SQLConnectRetry><br>
<Command>echo 'WOLsqlServerCommand not
set'</Command><br>
</WakeOnLAN><br>
</Configuration><br>
<br></span>
mythfrontend log after that change:<br>
</div>
</blockquote>
<br>
<blockquote type="cite">
<div lang="x-unicode"> Aug 31 20:47:51
mythuser-ZBOX-ID84 mythfrontend.real: mythfrontend[3444]: I
thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup
Interrupt handler<br>
(snip)<br>
Aug 31 20:47:51 mythuser-ZBOX-ID84 mythfrontend.real:
mythfrontend[3444]: N thread_unknown mythdirs.cpp:194
(InitializeMythDirs) Using configuration directory =
/home/mythuser/.mythtv<br>
Aug 31 20:47:51 mythuser-ZBOX-ID84 mythfrontend.real:
mythfrontend[3444]: I Logger logging.cpp:313 (run) Added logging
to the console<br>
Aug 31 20:47:51 mythuser-ZBOX-ID84 mythfrontend.real:
mythfrontend[3444]: I CoreContext mythcorecontext.cpp:266 (Init)
Assumed character encoding: en_US.UTF-8<br>
Aug 31 20:47:51 mythuser-ZBOX-ID84 mythfrontend.real:
mythfrontend[3444]: E CoreContext mythdbparams.cpp:49 (IsValid)
DBPassword is not set in config.xml<br>
Aug 31 20:47:51 mythuser-ZBOX-ID84 mythfrontend.real:
mythfrontend[3444]: E CoreContext mythdbparams.cpp:39 (IsValid)
DBHostName is not set in config.xml<br>
Aug 31 20:47:51 mythuser-ZBOX-ID84 mythfrontend.real:
mythfrontend[3444]: N CoreContext mythcontext.cpp:505
(LoadDatabaseSettings) Empty LocalHostName.<br>
Aug 31 20:47:51 mythuser-ZBOX-ID84 mythfrontend.real:
mythfrontend[3444]: I CoreContext mythcontext.cpp:513
(LoadDatabaseSettings) Using localhost value of
mythuser-ZBOX-ID84<br>
Aug 31 20:47:51 mythuser-ZBOX-ID84 mythfrontend.real:
mythfrontend[3444]: E CoreContext mythdbcon.cpp:229
(OpenDatabase) [DBManager0] Unable to connect to database!<br>
Aug 31 20:47:51 mythuser-ZBOX-ID84 mythfrontend.real:
mythfrontend[3444]: 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>
Aug 31 20:47:55 mythuser-ZBOX-ID84 mythfrontend.real:
mythfrontend[3444]: I SendMessage mythcorecontext.cpp:436
(ConnectCommandSocket) MythCoreContext::<wbr>ConnectCommandSocket():
Connecting to backend server: localhost:6543 (try 1 of 1)<br>
Aug 31 20:47:55 mythuser-ZBOX-ID84 mythfrontend.real:
mythfrontend[3444]: E SendMessage mythcorecontext.cpp:979
(GetBackendServerIP) MythCoreContext::<wbr>GetBackendServerIP(): No
address defined for host: localhost<br>
Aug 31 20:47:55 mythuser-ZBOX-ID84 mythfrontend.real:
mythfrontend[3444]: E MythSocketThread(-1) mythsocket.cpp:729
(ConnectToHostReal) MythSocket(7f2ea4004a60:-1): Failed to
connect to (<a target="_blank" href="http://127.0.0.1:6543">127.0.0.1:6543</a>) Connection refused<br>
Aug 31 20:47:55 mythuser-ZBOX-ID84 mythfrontend.real:
mythfrontend[3444]: 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>
(snip)<br>
Aug 31 20:47:59 mythuser-ZBOX-ID84 mythfrontend.real:
mythfrontend[3444]: I CoreContext mythtranslation.cpp:73 (load)
Loading en_us translation for module mythfrontend<br>
Aug 31 20:47:59 mythuser-ZBOX-ID84 mythfrontend.real:
mythfrontend[3444]: I SendMessage mythcorecontext.cpp:436
(ConnectCommandSocket) MythCoreContext::<wbr>ConnectCommandSocket():
Connecting to backend server: localhost:6543 (try 1 of 1)<br>
Aug 31 20:47:59 mythuser-ZBOX-ID84 mythfrontend.real:
mythfrontend[3444]: E SendMessage mythcorecontext.cpp:979
(GetBackendServerIP) MythCoreContext::<wbr>GetBackendServerIP(): No
address defined for host: localhost<br>
Aug 31 20:47:59 mythuser-ZBOX-ID84 mythfrontend.real:
mythfrontend[3444]: E MythSocketThread(-1) mythsocket.cpp:729
(ConnectToHostReal) MythSocket(7f2e3000aad0:-1): Failed to
connect to (<a target="_blank" href="http://127.0.0.1:6543">127.0.0.1:6543</a>) Connection refused<br>
Aug 31 20:47:59 mythuser-ZBOX-ID84 mythfrontend.real:
mythfrontend[3444]: 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>
<br>
</div>
</blockquote><br></div></blockquote><div><br></div><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><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>If you are using mariadb, then I don't know how you set it. Once you set it you will need to restart mysqld.<br><br></div><div>Hopefully that is the issue.<br><br></div><div>Bill <br></div></div></div></div>