<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body>
I had a working 18.04 Ubuntu-Mate box that worked fine; after a
self-induced catastrophic error, I ended up rebuilding it (fe/be box
with one remote frontend). The rebuild also works pretty well, but
I haven't gotten the remote front-end working yet. I haven't made
any changes to the remote, but I'm getting database connection
errors. Tried lots of things, but no luck. Any suggestions on what
to look for? <br>
<br>
Don<br>
<br>
<b>From the logs:</b><br>
<br>
<b>Excerpts from remote box: (/var/log/mythtv/mythfrontend.log)</b><br>
Nov 20 12:49:34 jax mythfrontend.real: mythfrontend[2459]: E
CoreContext mythdbcon.cpp:239 (OpenDatabase) Driver error was
[1/1045]:#012QMYSQL: Unable to connect#012Database error
was:#012Access denied for user 'mythtv'@'jax' (using password: YES)<br>
<br>
Nov 20 12:49:34 jax mythfrontend.real: mythfrontend[2459]: E
CoreContext mythdb.cpp:646 (GetSettingOnHost) Database not open
while trying to load setting: backendserverport<br>
<br>
<b>Excerpts from fe/be box:</b><b> (/var/log/mysql/error.log)</b><br>
2019-11-20T17:49:34.057263Z 544 [Note] Access denied for user
'mythtv'@'jax' (using password: YES)<br>
2019-11-20T18:00:01.606694Z 545 [Note] Got an error reading
communication packets<br>
2019-11-21T00:01:41.387690Z 721 [Note] Got an error reading
communication packets<br>
2019-11-21T00:15:52.630339Z 156 [Note] Aborted connection 156 to db:
'mythconverg' user: 'mythtv' host: 'localhost' (Got timeout reading
communication packets)<br>
<br>
<br>
<b>Things I've checked:</b><b><br>
</b><b><br>
</b><b>/home/don/don.my.cnf</b><br>
secure_file_priv=/var/lib/mysql<br>
<br>
<b>/home/don/.mythtv/config.xml (same as it was before rebuild)</b><br>
<LocalHostName>my-unique-identifier-goes-here</LocalHostName><br>
<Database><br>
<PingHost>1</PingHost><br>
<Host>localhost</Host><br>
<UserName>mythtv</UserName><br>
<Password>mythtv</Password><br>
<DatabaseName>mythconverg</DatabaseName><br>
<Port>3306</Port><br>
</Database><br>
<br>
<b>/home/mythtv/.mythtv/config.xml (symlinked to
/etc/mythtv/config.xml)</b><br>
<Configuration><br>
<Database><br>
<PingHost>1</PingHost><br>
<Host>localhost</Host><br>
<UserName>mythtv</UserName><br>
<Password>mythtv</Password><br>
<DatabaseName>mythconverg</DatabaseName><br>
<Port>3306</Port><br>
</Database><br>
<br>
<b>/etc/mysql/mysql.conf.d/mysqld.cnf</b><br>
# removed 11/17/2019<br>
#bind-address = 127.0.0.1<br>
<br>
# trying this 11/18/2019...didn't help<br>
#bind-address = 0.0.0.0<br>
<br>
<b>/etc/mysql/mysql.conf.d/mythtv.cnf</b><br>
[mysqld]<br>
#bind-address=::<br>
max_connections=100<br>
#sql_mode=NO_ENGINE_SUBSTITUTION<br>
<br>
<br>
</body>
</html>