[mythtv-users] Frontend can't connect to database

[Stephen Worthington]

On Wed, 8 Apr 2020 22:18:40 -0500, you wrote:

>So a long time mythtv user on Fedora and Fedora packager >10 years, and the
>maintainer of MythtTV on RPM Fusion... so it pains me to ask for help in
>this case but I'm stumped.
>
>I have no idea if this has anything to do with the upgrade from v30 to v31
>but I doubt it.
>
>I'm trying to run mythfrontend on my desktop to test performance after
>changing my GPU from Nvidia to AMD but I can't seem to connect to the
>database.
>
>A couple of months ago I upgraded my router (to a Ubiquity UGS) which
>changed the default IP network from 192.168.0.x to 192.168.1.x, and I've
>been correcting all sorts of crap since then, e.g. nfs exports... Blah...
>
>However, after the inital problem connecting to the database on my combined
>FE/BE I thought of this and installed phpMyAdmin there and updated all the
>records to 192.168.1.%. When that didn't work I just changed them to "%"
>since everthing on my home network is behind a firewall.
>
>No dice.
>
>What's strange is that connecting directly through mysql works:
>
>$ mysql -hcalvin -umythtv -p mythconverg
>Enter password:
>Reading table information for completion of table and column names
>You can turn off this feature to get a quicker startup with -A
>
>Welcome to the MariaDB monitor.  Commands end with ; or \g.
>Your MariaDB connection id is 451
>Server version: 10.3.22-MariaDB MariaDB Server
>
>Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
>
>Type 'help;' or '\h' for help. Type '\c' to clear the current input
>statement.
>
>MariaDB [mythconverg]>
>
>--- no problem ---
>
>But when I run mythfrontend:
>
>2020-04-08 22:01:16.207896 N [16368/16368] thread_unknown
>mythdirs.cpp:203:InitializeMythDirs  Using runtime prefix = /usr
>2020-04-08 22:01:16.207904 N [16368/16368] thread_unknown
>mythdirs.cpp:204:InitializeMythDirs  Using configuration directory =
>/home/richard/.mythtv
>...
>mythcontext.cpp:885:TestDBconnection  Start up testing connections. DB
>127.0.0.1, BE , attempt 0, status dbAwake, Delay: 2000
>2020-04-08 22:01:19.108658 I [16368/16368] CoreContext
>mythcontext.cpp:885:TestDBconnection  Start up testing connections. DB
>127.0.0.1, BE , attempt 1, status dbAwake, Delay: 2000
>2020-04-08 22:01:24.113804 I [16368/16368] CoreContext
>mythcontext.cpp:885:TestDBconnection  Start up testing connections. DB
>127.0.0.1, BE , attempt 2, status dbAwake, Delay: 2000
>
>Why in the love of god is it trying to connect to 127.0.0.1 when the
>configuration directory is correct and config.xml quite plainly points to
>the backend?
>
>$ cat .mythtv/config.xml
><Configuration>
>  <LocalHostName>my-unique-identifier-goes-here</LocalHostName>
>  <Database>
>    <PingHost>1</PingHost>
>    <Host>calvin</Host>
>    <UserName>mythtv</UserName>
>    <Password>mythtv</Password>
>    <DatabaseName>mythconverg</DatabaseName>
>    <Port>3306</Port>
>  </Database>
>...
>
>What obvious thing have I missed?
>
>Thanks,
>Richard

Where is the definition of the name "calvin"?  Do you run your own DNS
server?  Is it in /etc/hosts?  What is it set to?