<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<blockquote
cite="mid:0b33e0ee-2612-442f-05bd-1913e3961c34@greendesk.net"
type="cite">
<div class="moz-text-html" lang="x-unicode">
<meta content="text/html; charset=utf-8"
http-equiv="Content-Type">
<div class="moz-cite-prefix">On 08/31/2016 08:35 PM, Joseph Fry
wrote:<br>
</div>
<blockquote
cite="mid:CAAJE3SvrbMn-r7KB26reMwaBr7R9h5xS8z3nYdpH02Mhrg1JJQ@mail.gmail.com"
type="cite">
<p dir="ltr">You have no password set for the MythTV MySQL
acct. You need to update your config.xml accordingly.</p>
<br>
<div class="gmail_quote">
<div dir="ltr">On Wed, Aug 31, 2016, 8:43 PM Jack McGee <<a
moz-do-not-send="true" href="mailto:jack@greendesk.net">jack@greendesk.net</a>>
wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex"><br>
I do not see that. I see:<br>
<br>
<br>
mysql> SHOW GRANTS FOR mythtv;<br>
+---------------------------------------------------------+<br>
| Grants for mythtv@%
|<br>
+---------------------------------------------------------+<br>
| GRANT USAGE ON *.* TO 'mythtv'@'%'
|<br>
| GRANT ALL PRIVILEGES ON `mythconverg`.* TO 'mythtv'@'%'
|<br>
+---------------------------------------------------------+<br>
2 rows in set (0.00 sec)<br>
<br>
_______________________________________________</blockquote>
</div>
</blockquote>
<br>
<br>
Here is revised config.xml<br>
<br>
<a moz-do-not-send="true" class="moz-txt-link-abbreviated"
href="mailto:mythuser@mythuser-ZBOX-ID84:%7E/.mythtv$">mythuser@mythuser-ZBOX-ID84:~/.mythtv$</a>
cat config.xml<br>
<Configuration><br>
<Database><br>
<PingHost>1</PingHost><br>
<Host>192.168.0.105</Host><br>
<UserName>mythtv</UserName><br>
<Password></Password><br>
<DatabaseName>mythconverg</DatabaseName><br>
<Port>3306</Port><br>
</Database><br>
<WakeOnLAN><br>
<Enabled>0</Enabled><br>
<SQLReconnectWaitTime>0</SQLReconnectWaitTime><br>
<SQLConnectRetry>5</SQLConnectRetry><br>
<Command>echo 'WOLsqlServerCommand not
set'</Command><br>
</WakeOnLAN><br>
</Configuration><br>
<br>
mythfrontend log after that change:<br>
</div>
</blockquote>
<br>
<blockquote
cite="mid:0b33e0ee-2612-442f-05bd-1913e3961c34@greendesk.net"
type="cite">
<div class="moz-text-html" 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::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::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 (127.0.0.1:6543) 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::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::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 (127.0.0.1:6543) 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>
<p><br>
</p>
</body>
</html>