Frontend Unable to connect to Backend.

Have a MythTV related problem? Ask for help from other MythTV users here.

Moderator: Forum Moderators

Post Reply
mapota
Newcomer
Posts: 5
Joined: Fri Oct 30, 2020 12:28 am
Australia

Frontend Unable to connect to Backend.

Post by mapota »

Hi All,

I have checked the numerous post here about this but none have helped.

I have a backend running on 192.168.178.66 I also have a remote frontend (Nvidia shield) running on 192.168.178.77 the Shield connects fine to the Backend.
I also had a remote Xubuntu frontend running on 192.168.178.88 it was connecting fine to the backend but had some other issues so I decided to rebuild it. It is on the same IP address as the old build .i.e 192.168.178.88.

Now I cannot get it to connect to the database.

I have checked that config.xml in /home/andrew/.mythtv/config.xml has the correct information. The frontend log states it is using this file

Code: Select all

Jul 26 14:48:20 lounge-fe mythfrontend.real: mythfrontend[1301]: N thread_unknown mythdirs.cpp:204 (InitializeMythDirs) Using configuration directory = /home/andrew/.mythtv
Further down in the logs I get

Code: Select all

Jul 26 14:48:20 lounge-fe mythfrontend.real: mythfrontend[1301]: I LogForward loggingserver.cpp:248 (SyslogLogger) Added syslogging
Jul 26 14:48:21 lounge-fe mythfrontend.real: mythfrontend[1301]: E CoreContext mythdbcon.cpp:235 (OpenDatabase) [DBManager0] Unable to connect to database!
Jul 26 14:48:21 lounge-fe mythfrontend.real: mythfrontend[1301]: E CoreContext mythdbcon.cpp:236 (OpenDatabase) Driver error was [1/1045]:#012QMYSQL: Unable to connect#012Database error was:#012Access denied for user 'mythtv'@'lounge-fe.fritz.box' (using password: YES)
Jul 26 14:48:22 lounge-fe mythfrontend.real: mythfrontend[1301]: I CoreContext mythcontext.cpp:885 (TestDBconnection) Start up testing connections. DB 192.168.178.66, BE , attempt 1, status dbStarted, Delay: 2000
Jul 26 14:48:22 lounge-fe mythfrontend.real: mythfrontend[1301]: E CoreContext mythdbcon.cpp:235 (OpenDatabase) [DBManager1] Unable to connect to database!
Jul 26 14:48:22 lounge-fe mythfrontend.real: mythfrontend[1301]: E CoreContext mythdbcon.cpp:236 (OpenDatabase) Driver error was [1/1045]:#012QMYSQL: Unable to connect#012Database error was:#012Access denied for user 'mythtv'@'lounge-fe.fritz.box' (using password: YES)
Jul 26 14:48:27 lounge-fe mythfrontend.real: mythfrontend[1301]: I CoreContext mythcontext.cpp:885 (TestDBconnection) Start up testing connections. DB 192.168.178.66, BE , attempt 2, status dbStarted, Delay: 2000
I am unsure why the user is 'mythtv'@'lounge-fe.fritz.box'

The DNS server, my fritz router does have the name of 192.168.178.88 as "lounge-fe", and I suspect that is where it is coming from.

Is it the source of my issues though?

If I try to connect directly from command line I get the same error.

Code: Select all

andrew@lounge-fe:~$ mysql -u mythtv -h 192.168.178.66 -pit4lVclk
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1045 (28000): Access denied for user 'mythtv'@'lounge-fe.fritz.box' (using password: YES)
Post Reply