[mythtv-users] Remote frontend access denied

[Don Brett]

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?

Don

*From the logs:*

*Excerpts from remote box: (/var/log/mythtv/mythfrontend.log)*
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)

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

*Excerpts from fe/be box:**(/var/log/mysql/error.log)*
2019-11-20T17:49:34.057263Z 544 [Note] Access denied for user 
'mythtv'@'jax' (using password: YES)
2019-11-20T18:00:01.606694Z 545 [Note] Got an error reading 
communication packets
2019-11-21T00:01:41.387690Z 721 [Note] Got an error reading 
communication packets
2019-11-21T00:15:52.630339Z 156 [Note] Aborted connection 156 to db: 
'mythconverg' user: 'mythtv' host: 'localhost' (Got timeout reading 
communication packets)


*Things I've checked:**
**
**/home/don/don.my.cnf*
secure_file_priv=/var/lib/mysql

*/home/don/.mythtv/config.xml (same as it was before rebuild)*
<LocalHostName>my-unique-identifier-goes-here</LocalHostName>
   <Database>
     <PingHost>1</PingHost>
     <Host>localhost</Host>
     <UserName>mythtv</UserName>
     <Password>mythtv</Password>
     <DatabaseName>mythconverg</DatabaseName>
     <Port>3306</Port>
   </Database>

*/home/mythtv/.mythtv/config.xml (symlinked to /etc/mythtv/config.xml)*
<Configuration>
   <Database>
     <PingHost>1</PingHost>
     <Host>localhost</Host>
     <UserName>mythtv</UserName>
     <Password>mythtv</Password>
     <DatabaseName>mythconverg</DatabaseName>
     <Port>3306</Port>
   </Database>

*/etc/mysql/mysql.conf.d/mysqld.cnf*
# removed 11/17/2019
#bind-address           = 127.0.0.1

# trying this 11/18/2019...didn't help
#bind-address           = 0.0.0.0

*/etc/mysql/mysql.conf.d/mythtv.cnf*
[mysqld]
#bind-address=::
max_connections=100
#sql_mode=NO_ENGINE_SUBSTITUTION


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20191120/0f623c0e/attachment.htm>