[Solved] Remote frontend won't connect to DB

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

Moderator: Forum Moderators

Post Reply
gpw928
Junior
Posts: 51
Joined: Tue Feb 12, 2019 5:59 am
Location: Rural NSW
Australia

[Solved] Remote frontend won't connect to DB

Post by gpw928 »

Hi,

I am building new MythTV server, local frontend, and remote frontend with Debian 10.3 and MythTV patch 30.

I have compiled the MythTV code from source and created the Debian packages without problems, by following the instructions in the Wiki.

I have installed the MythTV server, with local frontend, without problems. It's working very well.

I have installed the frontend package on a separate Debian 10 client, on the local subnet.

It does not work. When I start the frontend, there is a simple graphic indicating that the connection to the backend database is timing out and failing.

I must admit that I am surprised that so many people have this problem (and I still can't figure out what's wrong).

The server is on host mith (192.168.1.28):

Code: Select all

[mith.636] # systemctl -l status mythtv-backend
● mythtv-backend.service - MythTV Backend
   Loaded: loaded (/lib/systemd/system/mythtv-backend.service; enabled; vendor p
   Active: active (running) since Mon 2020-03-09 09:21:37 AEDT; 1h 46min ago
     Docs: https://www.mythtv.org/wiki/Mythbackend
 Main PID: 864 (mythbackend)
    Tasks: 40 (limit: 2303)
   Memory: 99.1M
   CGroup: /system.slice/mythtv-backend.service
           └─864 /usr/bin/mythbackend --quiet --syslog local7
I have modified the mysql configuration to listen on all interfaces:

Code: Select all

[mith.645] # cat /etc/mysql/mariadb.conf.d/99-mythserver.cnf
# Phil was here.  Sun  8 Mar 16:36:05 AEDT 2020
# localhost doesn't work for remote front ends.
# Last so it over-rides everything else.
[mysqld]
bind-address		= 0.0.0.0
I have applied the password fix recommended in the wiki:

Code: Select all

https://www.mythtv.org/wiki/Mythfrontend

On the server (mith)...

Choose password as the one shown for mythconverg in the backend setup
/home/phil/.mythtv/config.xml
currently 'iL5dW3RI'.

mysql -u root -p mysql
mysql> grant all on mythconverg.* to 'mythtv'@'%' identified by 'iL5dW3RI';
mysql> flush privileges;
mysql> exit;
The database server is running:

Code: Select all

[mith.637] # systemctl -l status mysql         
● mariadb.service - MariaDB 10.3.22 database server
   Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: 
   Active: active (running) since Mon 2020-03-09 09:21:37 AEDT; 1h 46min ago
     Docs: man:mysqld(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 622 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run
  Process: 630 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_
  Process: 636 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR=
  Process: 857 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START
  Process: 859 ExecStartPost=/etc/mysql/debian-start (code=exited, status=0/SUCC
 Main PID: 708 (mysqld)
   Status: "Taking your SQL requests now..."
    Tasks: 46 (limit: 2303)
   Memory: 131.0M
   CGroup: /system.slice/mariadb.service
           └─708 /usr/sbin/mysqld
The database server is listening on all interfaces:

Code: Select all

[mith.626] # lsof -i TCP:3306
COMMAND PID  USER   FD   TYPE DEVICE SIZE/OFF NODE NAME
mysqld  708 mysql   20u  IPv4  22286      0t0  TCP *:mysql (LISTEN)
The remote frontend is on host fable (192.168.1.29).

Code: Select all

[fable.407] $ cd ~/.mythtv
[fable.408] $ pwd
/home/phil/.mythtv
[fable.409] $ cat config.xml
<Configuration>
  <LocalHostName>my-unique-identifier-goes-here</LocalHostName>
  <Database>
    <PingHost>1</PingHost>
    <Host>mith</Host>
    <UserName>mythtv</UserName>
    <Password>iL5dW3RI</Password>
    <DatabaseName>mythconverg</DatabaseName>
    <Port>3306</Port>
  </Database>
  <WakeOnLAN>
    <Enabled>0</Enabled>
    <SQLReconnectWaitTime>0</SQLReconnectWaitTime>
    <SQLConnectRetry>5</SQLConnectRetry>
    <Command>echo 'WOLsqlServerCommand not set'</Command>
  </WakeOnLAN>
  <UPnP>
    <MythFrontend>
      <DefaultBackend>
        <USN>uuid:29d5f242-d3c3-4180-9d37-2947b42cd0a0::urn:schemas-mythtv-org:device:MasterMediaServer:1</USN>
      </DefaultBackend>
    </MythFrontend>
  </UPnP>
</Configuration>
Why settle for one configuration file, when you can have two?

Code: Select all

[fable.436] # cat /etc/mythtv/config.xml
<Configuration>
  <Database>
    <PingHost>1</PingHost>
    <Host>192.168.1.28</Host>
    <UserName>mythtv</UserName>
    <Password>iL5dW3RI</Password>
    <DatabaseName>mythconverg</DatabaseName>
    <Port>3306</Port>
  </Database>
  <WakeOnLAN>
    <Enabled>0</Enabled>
    <SQLReconnectWaitTime>0</SQLReconnectWaitTime>
    <SQLConnectRetry>5</SQLConnectRetry>
    <Command>echo 'WOLsqlServerCommand not set'</Command>
  </WakeOnLAN>
</Configuration>
I can connect to the database from the commandline using the same parameters configured in the config.xml:

Code: Select all

[fable.410] $ mysql --host=mith --user mythtv --password mythconverg
Enter password: iL5dW3RI
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 168
Server version: 10.3.22-MariaDB-0+deb10u1 Debian 10

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]>
However, the MythTV client on the remote frontend won't connect to the database server. When I start the frontend, I get a graphic titled "MythTV Startup Status".

For reasons I don't understand, the default address for the database server is "127.0.0.1" (I thought I had changed that in the config file).

In any event, I changed it to 192.168.1.28 (host mith), using the "SETUP" button, and continued.

I got "Waiting for database to start", and a progress bar.

Then, eventually, "Database failed to start".

Here is the initial front end log (before I used the "SETUP" button to change the hostname of the database server from 127.0.0.1 to 192.168.1.28:

Code: Select all

[fable.425] # cat /var/log/mythtv/mythfrontend.log
Mar  9 11:52:24 fable mythfrontend.real: mythfrontend[2243]: I SendMessage mythcorecontext.cpp:451 (ConnectCommandSocket) MythCoreContext::ConnectCommandSocket(): Connecting to backend server: 127.0.0.1:6543 (try 1 of 1)
Mar  9 11:52:24 fable mythfrontend.real: mythfrontend[2243]: E MythSocketThread(-1) mythsocket.cpp:697 (ConnectToHostReal) MythSocket(7fb2e8029550:-1): Failed to connect to (127.0.0.1:6543) Connection refused
Mar  9 11:52:24 fable mythfrontend.real: mythfrontend[2243]: E SendMessage mythcorecontext.cpp:521 (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
Mar  9 11:52:27 fable mythfrontend.real: mythfrontend[2243]: A CoreContext mythcontext.cpp:514 (FindDatabase) Cannot connect to backend
Mar  9 11:52:27 fable mythfrontend.real: mythfrontend[2243]: E CoreContext main.cpp:1963 (main) Failed to init MythContext, exiting.
Mar  9 11:52:27 fable mythfrontend.real: mythfrontend[2243]: I CoreContext mythrender_opengl2.cpp:913 (DeleteOpenGLResources) OpenGL2: Deleting OpenGL Resources
Mar  9 11:52:27 fable mythfrontend.real: mythfrontend[2243]: I CoreContext mythrender_opengl.cpp:1303 (DeleteOpenGLResources) OpenGL: Deleting OpenGL Resources
Mar  9 11:52:27 fable mythfrontend.real: mythfrontend[2243]: I CoreContext AirPlay/mythraopdevice.cpp:71 (Cleanup) RAOP Device: Cleaning up.
Mar  9 11:52:27 fable mythfrontend.real: mythfrontend[2243]: I CoreContext AirPlay/mythairplayserver.cpp:386 (Cleanup) AirPlay: Cleaning up.
Mar  9 11:52:27 fable mythfrontend.real: mythfrontend[2243]: I CoreContext mythcontext.cpp:1672 (~MythContext) Waiting for threads to exit.
Mar  9 11:52:28 fable mythfrontend.real: mythfrontend[2287]: I thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup Interrupt handler
Mar  9 11:52:28 fable mythfrontend.real: mythfrontend[2287]: I thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup Terminated handler
Mar  9 11:52:28 fable mythfrontend.real: mythfrontend[2287]: I thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup Segmentation fault handler
Mar  9 11:52:28 fable mythfrontend.real: mythfrontend[2287]: I thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup Aborted handler
Mar  9 11:52:28 fable mythfrontend.real: mythfrontend[2287]: I thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup Bus error handler
Mar  9 11:52:28 fable mythfrontend.real: mythfrontend[2287]: I thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup Floating point exception handler
Mar  9 11:52:28 fable mythfrontend.real: mythfrontend[2287]: I thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup Illegal instruction handler
Mar  9 11:52:28 fable mythfrontend.real: mythfrontend[2287]: I thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup Real-time signal 0 handler
Mar  9 11:52:28 fable mythfrontend.real: mythfrontend[2287]: I thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup User defined signal 1 handler
Mar  9 11:52:28 fable mythfrontend.real: mythfrontend[2287]: I thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup User defined signal 2 handler
Mar  9 11:52:28 fable mythfrontend.real: mythfrontend[2287]: I thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup Hangup handler
Mar  9 11:52:28 fable mythfrontend.real: mythfrontend[2287]: C thread_unknown mythcommandlineparser.cpp:2607 (ConfigureLogging) mythfrontend version: fixes/30 [v30.0-85-gab250d6ccf-dirty] www.mythtv.org
Mar  9 11:52:28 fable mythfrontend.real: mythfrontend[2287]: C thread_unknown mythcommandlineparser.cpp:2609 (ConfigureLogging) Qt version: compile: 5.11.3, runtime: 5.11.3
Mar  9 11:52:28 fable mythfrontend.real: mythfrontend[2287]: N thread_unknown mythcommandlineparser.cpp:2611 (ConfigureLogging) Enabled verbose msgs:  general
Mar  9 11:52:28 fable mythfrontend.real: mythfrontend[2287]: N thread_unknown logging.cpp:734 (logStart) Setting Log Level to LOG_INFO
Mar  9 11:52:28 fable mythfrontend.real: mythfrontend[2287]: N thread_unknown mythdirs.cpp:203 (InitializeMythDirs) Using runtime prefix = /usr
Mar  9 11:52:28 fable mythfrontend.real: mythfrontend[2287]: I Logger logging.cpp:296 (run) Added logging to the console
Mar  9 11:52:28 fable mythfrontend.real: mythfrontend[2287]: N thread_unknown mythdirs.cpp:205 (InitializeMythDirs) Using configuration directory = /home/phil/.mythtv
Mar  9 11:52:28 fable mythfrontend.real: mythfrontend[2287]: I CoreContext mythcorecontext.cpp:272 (Init) Assumed character encoding: en_AU.UTF-8
Mar  9 11:52:28 fable mythfrontend.real: mythfrontend[2287]: I LogForward loggingserver.cpp:246 (SyslogLogger) Added syslogging
Mar  9 11:52:28 fable mythfrontend.real: mythfrontend[2287]: I CoreContext mythtranslation.cpp:64 (load) Loading en_us translation for module mythfrontend
Mar  9 11:52:28 fable mythfrontend.real: mythfrontend[2287]: I CoreContext mythcontext.cpp:641 (LoadDatabaseSettings) Empty LocalHostName. This is typical.
Mar  9 11:52:28 fable mythfrontend.real: mythfrontend[2287]: I CoreContext mythcontext.cpp:650 (LoadDatabaseSettings) Using a profile name of: 'fable' (Usually the same as this host's name.)
Mar  9 11:52:28 fable mythfrontend.real: mythfrontend[2287]: I CoreContext mythcontext.cpp:1271 (DefaultUPnP) UPNP Search up to 2 secs
Mar  9 11:52:29 fable mythfrontend.real: mythfrontend[2287]: I CoreContext mythcontext.cpp:1294 (DefaultUPnP) UPNP Search up to 1 secs
Mar  9 11:52:29 fable mythfrontend.real: mythfrontend[2287]: I CoreContext mythcontext.cpp:1294 (DefaultUPnP) UPNP Search up to 1 secs
Mar  9 11:52:31 fable mythfrontend.real: mythfrontend[2287]: I CoreContext mythcontext.cpp:900 (TestDBconnection) Start up testing connections. DB 127.0.0.1, BE , attempt 0, status dbAwake, Delay: 2000
Mar  9 11:52:32 fable mythfrontend.real: mythfrontend[2287]: I CoreContext mythcontext.cpp:900 (TestDBconnection) Start up testing connections. DB 127.0.0.1, BE , attempt 1, status dbAwake, Delay: 2000
Mar  9 11:52:37 fable mythfrontend.real: mythfrontend[2287]: I CoreContext mythcontext.cpp:900 (TestDBconnection) Start up testing connections. DB 127.0.0.1, BE , attempt 2, status dbAwake, Delay: 2000
Mar  9 11:52:37 fable mythfrontend.real: mythfrontend[2287]: I CoreContext screensaver-dbus.cpp:63 (ScreenSaverDBusPrivate) ScreenSaverDBus: Created for DBus service: org.freedesktop.ScreenSaver
Mar  9 11:52:37 fable mythfrontend.real: mythfrontend[2287]: I CoreContext screensaver-dbus.cpp:63 (ScreenSaverDBusPrivate) ScreenSaverDBus: Created for DBus service: org.gnome.SessionManager
Mar  9 11:52:37 fable mythfrontend.real: mythfrontend[2287]: I SystemSignalManager mythsystemunix.cpp:509 (run) Starting process signal handler
Mar  9 11:52:37 fable mythfrontend.real: mythfrontend[2287]: I SystemManager mythsystemunix.cpp:276 (run) Starting process manager
Mar  9 11:52:37 fable mythfrontend.real: mythfrontend[2287]: I SystemIOHandlerR mythsystemunix.cpp:92 (run) Starting IO manager (read)
Mar  9 11:52:37 fable mythfrontend.real: mythfrontend[2287]: I SystemIOHandlerW mythsystemunix.cpp:92 (run) Starting IO manager (write)
Mar  9 11:52:37 fable mythfrontend.real: mythfrontend[2287]: I CoreContext screensaver-x11.cpp:80 (ScreenSaverX11Private) ScreenSaverX11Private: DPMS is active.
Mar  9 11:52:37 fable mythfrontend.real: mythfrontend[2287]: N CoreContext DisplayRes.cpp:64 (Initialize) Desktop video mode: 1920x1080 60.000 Hz
Mar  9 11:52:37 fable mythfrontend.real: mythfrontend[2287]: E CoreContext mythdb.cpp:181 (DBError) DB Error (StorageGroup::StorageGroup()):#012Query was:#012#012Driver error was [1/]:#012Driver not loaded#012Database error was:#012Driver not loaded
Mar  9 11:52:37 fable mythfrontend.real: mythfrontend[2287]: W CoreContext mythuihelper.cpp:1176 (FindThemeDir) MythUIHelper: No theme dir: '/usr/share/mythtv/themes/Mythbuntu'
Mar  9 11:52:37 fable mythfrontend.real: mythfrontend[2287]: W CoreContext mythuihelper.cpp:1195 (FindThemeDir) MythUIHelper: No default theme dir: '/usr/share/mythtv/themes/Mythbuntu'
Mar  9 11:52:37 fable mythfrontend.real: mythfrontend[2287]: E CoreContext mythuihelper.cpp:1204 (FindThemeDir) MythUIHelper: Could not find theme: Mythbuntu - Switching to MythCenter-wide
Mar  9 11:52:37 fable mythfrontend.real: mythfrontend[2287]: E CoreContext lirc.cpp:207 (Init) LIRC: Failed to connect to Unix socket '/var/run/lirc/lircd'#012#011#011#011eno: No such file or directory (2)
Mar  9 11:52:37 fable mythfrontend.real: mythfrontend[2287]: I CoreContext jsmenu.cpp:153 (ReadConfig) No joystick configuration found, not enabling joystick control
Mar  9 11:52:37 fable mythfrontend.real: mythfrontend[2287]: E CoreContext cecadapter.cpp:163 (Open) CECAdapter: Failed to find any CEC devices.
Mar  9 11:52:37 fable mythfrontend.real: mythfrontend[2287]: I CoreContext cecadapter.cpp:237 (Close) CECAdapter: Closing down CEC.
Mar  9 11:52:37 fable mythfrontend.real: mythfrontend[2287]: I CoreContext mythudplistener.cpp:32 (Enable) UDPListener: Enabling
Mar  9 11:52:37 fable mythfrontend.real: mythfrontend[2287]: I CoreContext serverpool.cpp:539 (bind) Binding to UDP 0.0.0.0:0
Mar  9 11:52:37 fable mythfrontend.real: mythfrontend[2287]: I CoreContext serverpool.cpp:539 (bind) Binding to UDP [::]:0
Mar  9 11:52:37 fable mythfrontend.real: mythfrontend[2287]: I CoreContext mythmainwindow.cpp:987 (Init) Using Frameless Window
Mar  9 11:52:37 fable mythfrontend.real: mythfrontend[2287]: I CoreContext mythmainwindow.cpp:998 (Init) Using Full Screen Window
Mar  9 11:52:38 fable mythfrontend.real: mythfrontend[2287]: I CoreContext mythmainwindow.cpp:1025 (Init) UI Screen Resolution: 1920 x 1080
Mar  9 11:52:38 fable mythfrontend.real: mythfrontend[2287]: W CoreContext mythrender_opengl.cpp:105 (Create) OpenGL: Could not determine whether Sync to VBlank is enabled.
Mar  9 11:52:38 fable mythfrontend.real: mythfrontend[2287]: I CoreContext mythrender_opengl.cpp:156 (Create) Trying the OpenGL 2.0 render
Mar  9 11:52:38 fable mythfrontend.real: mythfrontend[2287]: I CoreContext mythpainter_ogl.cpp:27 (MythOpenGLPainter) OpenGL painter using existing OpenGL context.
Mar  9 11:52:38 fable mythfrontend.real: mythfrontend[2287]: I CoreContext mythrender_opengl2.cpp:253 (InitFeatures) OpenGL2: GLSL supported
Mar  9 11:52:38 fable mythfrontend.real: mythfrontend[2287]: I CoreContext mythrender_opengl.cpp:1187 (InitFeatures) OpenGL: OpenGL vendor  : nouveau
Mar  9 11:52:38 fable mythfrontend.real: mythfrontend[2287]: I CoreContext mythrender_opengl.cpp:1189 (InitFeatures) OpenGL: OpenGL renderer: NVC1
Mar  9 11:52:38 fable mythfrontend.real: mythfrontend[2287]: I CoreContext mythrender_opengl.cpp:1191 (InitFeatures) OpenGL: OpenGL version : 4.3 (Compatibility Profile) Mesa 18.3.6
Mar  9 11:52:38 fable mythfrontend.real: mythfrontend[2287]: I CoreContext mythrender_opengl.cpp:1193 (InitFeatures) OpenGL: Max texture size: 16384 x 16384
Mar  9 11:52:38 fable mythfrontend.real: mythfrontend[2287]: I CoreContext mythrender_opengl.cpp:1195 (InitFeatures) OpenGL: Max texture units: 8
Mar  9 11:52:38 fable mythfrontend.real: mythfrontend[2287]: I CoreContext mythrender_opengl.cpp:1197 (InitFeatures) OpenGL: Direct rendering: Yes
Mar  9 11:52:38 fable mythfrontend.real: mythfrontend[2287]: I CoreContext mythrender_opengl.cpp:1199 (InitFeatures) OpenGL: Extensions Supported: 3e1b
Mar  9 11:52:38 fable mythfrontend.real: mythfrontend[2287]: I CoreContext mythrender_opengl.cpp:1206 (InitFeatures) OpenGL: PixelBufferObject support available
Mar  9 11:52:38 fable mythfrontend.real: mythfrontend[2287]: I CoreContext mythrender_opengl.cpp:228 (Init) OpenGL: Initialised MythRenderOpenGL
Mar  9 11:52:38 fable mythfrontend.real: mythfrontend[2287]: I CoreContext mythuihelper.cpp:933 (PruneCacheDir) MythUIHelper: Pruning cache directory: /home/phil/.mythtv/cache/remotecache
Mar  9 11:52:38 fable mythfrontend.real: mythfrontend[2287]: I CoreContext mythuihelper.cpp:989 (PruneCacheDir) MythUIHelper: Kept 0 files, deleted 0 files, stat error on 0 files
Mar  9 11:52:38 fable mythfrontend.real: mythfrontend[2287]: I CoreContext mythuihelper.cpp:933 (PruneCacheDir) MythUIHelper: Pruning cache directory: /home/phil/.mythtv/cache/thumbnails
Mar  9 11:52:38 fable mythfrontend.real: mythfrontend[2287]: I CoreContext mythuihelper.cpp:989 (PruneCacheDir) MythUIHelper: Kept 0 files, deleted 0 files, stat error on 0 files
Mar  9 11:52:38 fable mythfrontend.real: mythfrontend[2287]: E CoreContext mythfontproperties.cpp:442 (ParseFromXml) MythFontProperties: Failed to load 'Droid Sans', got 'DejaVu Sans' instead#012#011#011#011Location: /usr/share/mythtv/themes/MythCenter-wide/base.xml @ 6#012#011#011#011Name: 'basesmall'#011Type: 'fontdef'
Mar  9 11:52:38 fable mythfrontend.real: mythfrontend[2287]: E CoreContext mythfontproperties.cpp:442 (ParseFromXml) MythFontProperties: Failed to load 'Droid Sans', got 'DejaVu Sans' instead#012#011#011#011Location: /usr/share/mythtv/themes/MythCenter-wide/base.xml @ 12#012#011#011#011Name: 'basesmaller'#011Type: 'fontdef'
Mar  9 11:52:38 fable mythfrontend.real: mythfrontend[2287]: E CoreContext mythfontproperties.cpp:442 (ParseFromXml) MythFontProperties: Failed to load 'Droid Sans', got 'DejaVu Sans' instead#012#011#011#011Location: /usr/share/mythtv/themes/MythCenter-wide/base.xml @ 16#012#011#011#011Name: 'basesmallbold'#011Type: 'fontdef'
Mar  9 11:52:38 fable mythfrontend.real: mythfrontend[2287]: E CoreContext mythfontproperties.cpp:442 (ParseFromXml) MythFontProperties: Failed to load 'Droid Sans', got 'DejaVu Sans' instead#012#011#011#011Location: /usr/share/mythtv/themes/MythCenter-wide/base.xml @ 20#012#011#011#011Name: 'small'#011Type: 'fontdef'
Mar  9 11:52:38 fable mythfrontend.real: mythfrontend[2287]: E CoreContext mythfontproperties.cpp:442 (ParseFromXml) MythFontProperties: Failed to load 'Droid Sans', got 'DejaVu Sans' instead#012#011#011#011Location: /usr/share/mythtv/themes/MythCenter-wide/base.xml @ 56#012#011#011#011Name: 'basesmall_normal_selected'#011Type: 'fontdef'
Mar  9 11:52:38 fable mythfrontend.real: mythfrontend[2287]: E CoreContext mythfontproperties.cpp:442 (ParseFromXml) MythFontProperties: Failed to load 'Droid Sans', got 'DejaVu Sans' instead#012#011#011#011Location: /usr/share/mythtv/themes/MythCenter-wide/base.xml @ 59#012#011#011#011Name: 'basesmall_normal'#011Type: 'fontdef'
Mar  9 11:52:38 fable mythfrontend.real: mythfrontend[2287]: E CoreContext mythfontproperties.cpp:442 (ParseFromXml) MythFontProperties: Failed to load 'Droid Sans', got 'DejaVu Sans' instead#012#011#011#011Location: /usr/share/mythtv/themes/MythCenter-wide/base.xml @ 62#012#011#011#011Name: 'basesmall_normal_inactive'#011Type: 'fontdef'
Mar  9 11:52:38 fable mythfrontend.real: mythfrontend[2287]: E CoreContext mythfontproperties.cpp:442 (ParseFromXml) MythFontProperties: Failed to load 'Droid Sans', got 'DejaVu Sans' instead#012#011#011#011Location: /usr/share/mythtv/themes/MythCenter-wide/base.xml @ 65#012#011#011#011Name: 'basesmall_warning_selected'#011Type: 'fontdef'
Mar  9 11:52:38 fable mythfrontend.real: mythfrontend[2287]: E CoreContext mythfontproperties.cpp:442 (ParseFromXml) MythFontProperties: Failed to load 'Droid Sans', got 'DejaVu Sans' instead#012#011#011#011Location: /usr/share/mythtv/themes/MythCenter-wide/base.xml @ 68#012#011#011#011Name: 'basesmall_warning'#011Type: 'fontdef'
Mar  9 11:52:38 fable mythfrontend.real: mythfrontend[2287]: E CoreContext mythfontproperties.cpp:442 (ParseFromXml) MythFontProperties: Failed to load 'Droid Sans', got 'DejaVu Sans' instead#012#011#011#011Location: /usr/share/mythtv/themes/MythCenter-wide/base.xml @ 71#012#011#011#011Name: 'basesmall_favourite_selected'#011Type: 'fontdef'
Mar  9 11:52:38 fable mythfrontend.real: mythfrontend[2287]: E CoreContext mythfontproperties.cpp:442 (ParseFromXml) MythFontProperties: Failed to load 'Droid Sans', got 'DejaVu Sans' instead#012#011#011#011Location: /usr/share/mythtv/themes/MythCenter-wide/base.xml @ 74#012#011#011#011Name: 'basesmall_favourite'#011Type: 'fontdef'
Mar  9 11:52:38 fable mythfrontend.real: mythfrontend[2287]: E CoreContext mythfontproperties.cpp:442 (ParseFromXml) MythFontProperties: Failed to load 'Droid Sans', got 'DejaVu Sans' instead#012#011#011#011Location: /usr/share/mythtv/themes/MythCenter-wide/base.xml @ 77#012#011#011#011Name: 'basesmall_favourite_unavailable'#011Type: 'fontdef'
Mar  9 11:52:38 fable mythfrontend.real: mythfrontend[2287]: E CoreContext mythfontproperties.cpp:442 (ParseFromXml) MythFontProperties: Failed to load 'Droid Sans', got 'DejaVu Sans' instead#012#011#011#011Location: /usr/share/mythtv/themes/MythCenter-wide/base.xml @ 80#012#011#011#011Name: 'basesmall_error_selected'#011Type: 'fontdef'
Mar  9 11:52:38 fable mythfrontend.real: mythfrontend[2287]: E CoreContext mythfontproperties.cpp:442 (ParseFromXml) MythFontProperties: Failed to load 'Droid Sans', got 'DejaVu Sans' instead#012#011#011#011Location: /usr/share/mythtv/themes/MythCenter-wide/base.xml @ 83#012#011#011#011Name: 'basesmall_error'#011Type: 'fontdef'
Mar  9 11:52:38 fable mythfrontend.real: mythfrontend[2287]: E CoreContext mythfontproperties.cpp:442 (ParseFromXml) MythFontProperties: Failed to load 'Droid Sans', got 'DejaVu Sans' instead#012#011#011#011Location: /usr/share/mythtv/themes/MythCenter-wide/base.xml @ 86#012#011#011#011Name: 'basesmall_disabled_selected'#011Type: 'fontdef'
Mar  9 11:52:38 fable mythfrontend.real: mythfrontend[2287]: E CoreContext mythfontproperties.cpp:442 (ParseFromXml) MythFontProperties: Failed to load 'Droid Sans', got 'DejaVu Sans' instead#012#011#011#011Location: /usr/share/mythtv/themes/MythCenter-wide/base.xml @ 89#012#011#011#011Name: 'basesmall_disabled'#011Type: 'fontdef'
Mar  9 11:52:38 fable mythfrontend.real: mythfrontend[2287]: E CoreContext mythfontproperties.cpp:442 (ParseFromXml) MythFontProperties: Failed to load 'Droid Sans', got 'DejaVu Sans' instead#012#011#011#011Location: /usr/share/mythtv/themes/MythCenter-wide/base.xml @ 92#012#011#011#011Name: 'basesmall_running_selected'#011Type: 'fontdef'
Mar  9 11:52:38 fable mythfrontend.real: mythfrontend[2287]: E CoreContext mythfontproperties.cpp:442 (ParseFromXml) MythFontProperties: Failed to load 'Droid Sans', got 'DejaVu Sans' instead#012#011#011#011Location: /usr/share/mythtv/themes/MythCenter-wide/base.xml @ 95#012#011#011#011Name: 'basesmall_running'#011Type: 'fontdef'
Mar  9 11:52:38 fable mythfrontend.real: mythfrontend[2287]: E CoreContext mythfontproperties.cpp:442 (ParseFromXml) MythFontProperties: Failed to load 'Droid Sans', got 'DejaVu Sans' instead#012#011#011#011Location: /usr/share/mythtv/themes/MythCenter-wide/base.xml @ 98#012#011#011#011Name: 'basesmall_textedit'#011Type: 'fontdef'
Mar  9 11:52:38 fable mythfrontend.real: mythfrontend[2287]: E CoreContext mythfontproperties.cpp:442 (ParseFromXml) MythFontProperties: Failed to load 'Droid Sans', got 'DejaVu Sans' instead#012#011#011#011Location: /usr/share/mythtv/themes/MythCenter-wide/base.xml @ 101#012#011#011#011Name: 'basesmall_normal_button'#011Type: 'fontdef'
Mar  9 11:52:38 fable mythfrontend.real: mythfrontend[2287]: E CoreContext mythfontproperties.cpp:442 (ParseFromXml) MythFontProperties: Failed to load 'Droid Sans', got 'DejaVu Sans' instead#012#011#011#011Location: /usr/share/mythtv/themes/MythCenter-wide/base.xml @ 104#012#011#011#011Name: 'basesmall_selected_button'#011Type: 'fontdef'
Mar  9 11:52:38 fable mythfrontend.real: mythfrontend[2287]: E CoreContext mythfontproperties.cpp:442 (ParseFromXml) MythFontProperties: Failed to load 'Droid Sans', got 'DejaVu Sans' instead#012#011#011#011Location: /usr/share/mythtv/themes/MythCenter-wide/base.xml @ 107#012#011#011#011Name: 'basesmall_disabled_button'#011Type: 'fontdef'
Mar  9 11:52:38 fable mythfrontend.real: mythfrontend[2287]: E CoreContext mythfontproperties.cpp:442 (ParseFromXml) MythFontProperties: Failed to load 'Droid Sans', got 'DejaVu Sans' instead#012#011#011#011Location: /usr/share/mythtv/themes/MythCenter-wide/base.xml @ 134#012#011#011#011Name: 'baseguide'#011Type: 'fontdef'
Mar  9 11:52:38 fable mythfrontend.real: mythfrontend[2287]: E CoreContext mythfontproperties.cpp:442 (ParseFromXml) MythFontProperties: Failed to load 'Droid Sans', got 'DejaVu Sans' instead#012#011#011#011Location: /usr/share/mythtv/themes/MythCenter-wide/base.xml @ 1166#012#011#011#011Name: 'medium'#011Type: 'fontdef'
Mar  9 11:52:38 fable mythfrontend.real: mythfrontend[2287]: E CoreContext mythfontproperties.cpp:442 (ParseFromXml) MythFontProperties: Failed to load 'Droid Sans', got 'DejaVu Sans' instead#012#011#011#011Location: /usr/share/mythtv/themes/default-wide/base.xml @ 32#012#011#011#011Name: 'basesmallgrey'#011Type: 'fontdef'
Mar  9 11:52:38 fable mythfrontend.real: mythfrontend[2287]: E CoreContext mythfontproperties.cpp:442 (ParseFromXml) MythFontProperties: Failed to load 'Droid Sans', got 'DejaVu Sans' instead#012#011#011#011Location: /usr/share/mythtv/themes/default-wide/base.xml @ 36#012#011#011#011Name: 'basesmallpurple'#011Type: 'fontdef'
Mar  9 11:52:38 fable mythfrontend.real: mythfrontend[2287]: E CoreContext mythfontproperties.cpp:442 (ParseFromXml) MythFontProperties: Failed to load 'Droid Sans', got 'DejaVu Sans' instead#012#011#011#011Location: /usr/share/mythtv/themes/default-wide/base.xml @ 40#012#011#011#011Name: 'basesmallblack'#011Type: 'fontdef'
Mar  9 11:52:38 fable mythfrontend.real: mythfrontend[2287]: E CoreContext mythfontproperties.cpp:442 (ParseFromXml) MythFontProperties: Failed to load 'Droid Sans', got 'DejaVu Sans' instead#012#011#011#011Location: /usr/share/mythtv/themes/default-wide/base.xml @ 44#012#011#011#011Name: 'basesmallyellow'#011Type: 'fontdef'
Mar  9 11:52:38 fable mythfrontend.real: mythfrontend[2287]: E CoreContext mythfontproperties.cpp:442 (ParseFromXml) MythFontProperties: Failed to load 'Droid Sans', got 'DejaVu Sans' instead#012#011#011#011Location: /usr/share/mythtv/themes/default-wide/base.xml @ 48#012#011#011#011Name: 'basesmallgreen'#011Type: 'fontdef'
Mar  9 11:52:38 fable mythfrontend.real: mythfrontend[2287]: E CoreContext mythfontproperties.cpp:442 (ParseFromXml) MythFontProperties: Failed to load 'Droid Sans', got 'DejaVu Sans' instead#012#011#011#011Location: /usr/share/mythtv/themes/default-wide/base.xml @ 52#012#011#011#011Name: 'basesmallblue'#011Type: 'fontdef'
Mar  9 11:52:38 fable mythfrontend.real: mythfrontend[2287]: E CoreContext mythfontproperties.cpp:442 (ParseFromXml) MythFontProperties: Failed to load 'Droid Sans', got 'DejaVu Sans' instead#012#011#011#011Location: /usr/share/mythtv/themes/default-wide/base.xml @ 56#012#011#011#011Name: 'basesmallred'#011Type: 'fontdef'
Mar  9 11:52:38 fable mythfrontend.real: mythfrontend[2287]: E CoreContext mythfontproperties.cpp:442 (ParseFromXml) MythFontProperties: Failed to load 'Droid Sans', got 'DejaVu Sans' instead#012#011#011#011Location: /usr/share/mythtv/themes/default/base.xml @ 11#012#011#011#011Name: 'basetiny'#011Type: 'fontdef'
Mar  9 11:52:38 fable mythfrontend.real: mythfrontend[2287]: E CoreContext mythfontproperties.cpp:442 (ParseFromXml) MythFontProperties: Failed to load 'Droid Sans', got 'DejaVu Sans' instead#012#011#011#011Location: /usr/share/mythtv/themes/default/base.xml @ 36#012#011#011#011Name: 'basetinyred'#011Type: 'fontdef'
Mar  9 11:52:38 fable mythfrontend.real: mythfrontend[2287]: E CoreContext mythfontproperties.cpp:442 (ParseFromXml) MythFontProperties: Failed to load 'Droid Sans', got 'DejaVu Sans' instead#012#011#011#011Location: /usr/share/mythtv/themes/default/base.xml @ 736#012#011#011#011Name: 'gallerytext'#011Type: 'fontdef'
Mar  9 11:52:43 fable mythfrontend.real: mythfrontend[2287]: I CoreContext mythcontext.cpp:900 (TestDBconnection) Start up testing connections. DB 127.0.0.1, BE , attempt 3, status dbAwake, Delay: 2000
Mar  9 11:52:43 fable mythfrontend.real: mythfrontend[2287]: I CoreContext mythcontext.cpp:1023 (TestDBconnection) Start up failure. host 127.0.0.1, status dbAwakeFail
Mar  9 11:52:43 fable mythfrontend.real: mythfrontend[2287]: E CoreContext mythdbcon.cpp:238 (OpenDatabase) [DBManager0] Unable to connect to database!
Mar  9 11:52:43 fable mythfrontend.real: mythfrontend[2287]: E CoreContext mythdbcon.cpp:239 (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)
Here is the rest of the log after I changed 127.0.0.1 to 192.168.1.28:

Code: Select all

Mar  9 11:53:07 fable mythfrontend.real: mythfrontend[2287]: I CoreContext mythcontext.cpp:900 (TestDBconnection) Start up testing connections. DB 192.168.1.28, BE , attempt 0, status dbAwake, Delay: 2000
Mar  9 11:53:09 fable mythfrontend.real: mythfrontend[2287]: I CoreContext mythcontext.cpp:900 (TestDBconnection) Start up testing connections. DB 192.168.1.28, BE 127.0.0.1, attempt 1, status beAwake, Delay: 2000
Mar  9 11:53:09 fable mythfrontend.real: mythfrontend[2287]: I SendMessage mythcorecontext.cpp:451 (ConnectCommandSocket) MythCoreContext::ConnectCommandSocket(): Connecting to backend server: 127.0.0.1:6543 (try 1 of 1)
Mar  9 11:53:09 fable mythfrontend.real: mythfrontend[2287]: E MythSocketThread(-1) mythsocket.cpp:697 (ConnectToHostReal) MythSocket(7f187c0209a0:-1): Failed to connect to (127.0.0.1:6543) Connection refused
Mar  9 11:53:09 fable mythfrontend.real: mythfrontend[2287]: E SendMessage mythcorecontext.cpp:521 (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
Mar  9 11:53:14 fable mythfrontend.real: mythfrontend[2287]: I CoreContext mythcontext.cpp:900 (TestDBconnection) Start up testing connections. DB 192.168.1.28, BE 127.0.0.1, attempt 2, status beAwake, Delay: 2000
Mar  9 11:53:19 fable mythfrontend.real: mythfrontend[2287]: I CoreContext mythcontext.cpp:900 (TestDBconnection) Start up testing connections. DB 192.168.1.28, BE 127.0.0.1, attempt 3, status beAwake, Delay: 2000
Mar  9 11:53:24 fable mythfrontend.real: mythfrontend[2287]: I CoreContext mythcontext.cpp:900 (TestDBconnection) Start up testing connections. DB 192.168.1.28, BE 127.0.0.1, attempt 4, status beAwake, Delay: 2000
Mar  9 11:53:29 fable mythfrontend.real: mythfrontend[2287]: I CoreContext mythcontext.cpp:900 (TestDBconnection) Start up testing connections. DB 192.168.1.28, BE 127.0.0.1, attempt 5, status beAwake, Delay: 2000
Mar  9 11:53:34 fable mythfrontend.real: mythfrontend[2287]: I CoreContext mythcontext.cpp:900 (TestDBconnection) Start up testing connections. DB 192.168.1.28, BE 127.0.0.1, attempt 6, status beAwake, Delay: 2000
Mar  9 11:53:39 fable mythfrontend.real: mythfrontend[2287]: I CoreContext mythcontext.cpp:900 (TestDBconnection) Start up testing connections. DB 192.168.1.28, BE 127.0.0.1, attempt 7, status beAwake, Delay: 2000
Mar  9 11:53:45 fable mythfrontend.real: mythfrontend[2287]: I CoreContext mythcontext.cpp:900 (TestDBconnection) Start up testing connections. DB 192.168.1.28, BE 127.0.0.1, attempt 8, status beAwake, Delay: 2000
Mar  9 11:53:50 fable mythfrontend.real: mythfrontend[2287]: I CoreContext mythcontext.cpp:900 (TestDBconnection) Start up testing connections. DB 192.168.1.28, BE 127.0.0.1, attempt 9, status beAwake, Delay: 2000
Mar  9 11:53:55 fable mythfrontend.real: mythfrontend[2287]: I CoreContext mythcontext.cpp:900 (TestDBconnection) Start up testing connections. DB 192.168.1.28, BE 127.0.0.1, attempt 10, status beAwake, Delay: 2000
Mar  9 11:54:00 fable mythfrontend.real: mythfrontend[2287]: I CoreContext mythcontext.cpp:1023 (TestDBconnection) Start up failure. host 192.168.1.28, status beAwakeFail
Mar  9 11:54:00 fable mythfrontend.real: mythfrontend[2287]: I SendMessage mythcorecontext.cpp:451 (ConnectCommandSocket) MythCoreContext::ConnectCommandSocket(): Connecting to backend server: 127.0.0.1:6543 (try 1 of 1)
Mar  9 11:54:00 fable mythfrontend.real: mythfrontend[2287]: E MythSocketThread(-1) mythsocket.cpp:697 (ConnectToHostReal) MythSocket(7f1870012970:-1): Failed to connect to (127.0.0.1:6543) Connection refused
Mar  9 11:54:00 fable mythfrontend.real: mythfrontend[2287]: E SendMessage mythcorecontext.cpp:521 (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
What does "DB 192.168.1.28, BE 127.0.0.1" mean?

I'd be grateful if anyone can spot what's wrong.
Last edited by gpw928 on Mon Mar 09, 2020 7:39 pm, edited 1 time in total.
User avatar
bill6502
Developer
Posts: 2307
Joined: Fri Feb 07, 2014 5:28 pm
United States of America

Re: Remote frontend won't connect to DB

Post by bill6502 »

Hi,

DB is the IP/hostname of the database server, as defined in config.xml. The file being used appears in the log
like this: ...Using configuration directory = /home/phil/.mythtv. [/etc/mythtv/config.xml is used by some to link to
from ~mythtv/.mythtv/config.xml and ~/.mythtv/config.xml you don't have to use it]

BE is mythbackend and you proved it's running with systemctl status. Look at the backend log to see where it's
listening.

It's not clear to me where you 'changed 127.0.0.1 to 192.168.1.28'. config.xml exists to tell the FE or BE where
the database is and how to login to it.

The backend settings in mythtv-setup define where the backend listens. A 127..... address would be for a combined
FE/BE with no remotes.
gpw928
Junior
Posts: 51
Joined: Tue Feb 12, 2019 5:59 am
Location: Rural NSW
Australia

Re: Remote frontend won't connect to DB

Post by gpw928 »

Thank you for your response.

To summarise the situation:
  • The MythTV backend server is 192.168.1.28 (hostname mith). It also runs the mysql server, and a local MythTV frontend.
  • There is a second (remote) MythTV frontend is installed 192.168.1.29 (hostname fable).
The MythTV backend server, and the mysql server, and the local MythTV frontend all on 192.168.1.28 work perfectly well with each other.

The remote MythTV frontend on 192.168.1.29 (hostname fable) does not work. I have not progressed to the MythTV setup screen on the remote frontend. I can't get that far...

On the remote frontend, a screen titled "MythTV Startup Status" presents when the MythTV frontend is started. Maybe this screen only presents on remote frontends, or when the database server can't be reached? There are some buttons at the bottom of the screen, and one of them is "SETUP" which I used to interactively change the IP address of the database server from 127.0.0.1 to 192.168.1.28. I have no idea why 127.0.0.1 was being used, as it does not appear in any of the config.xml files (as identified by "find / -name config.xml").

The remote frontend logs shown above initially have "DB 127.0.0.1, BE , attempt...". Then after I changed the IP address of the database server from 127.0.0.1 to 192.168.1.28, they show "DB 192.168.1.28, BE 127.0.0.1, attempt...".

It seems to me that the default configuration for a MythTV frontend is that the mysql server is 127.0.0.1 and that the IP address of the MythTV backend server is undefined (presumably it's the same as the mysql server). When the IP address of the mysql server is changed to 192.168.1.28, the IP address of the MythTV backend server changes to an explicit 127.0.0.1. I expect that would all work where the MythTV frontend and backend were on the same host... But mine are not. 127.0.0.1 is not appropriate for DB, nor is it appropriate for BE.

So, my first question is why is the remote MythTV frontend specifically ignoring the database "Host" directive for the mysql server in ~/.mythtv/config.xml?

Secondly, do I need to explicitly define the IP address of the MythTV backend server on a remote MythTV frontend. If so, how?
MikeB2013
Senior
Posts: 519
Joined: Mon Jul 25, 2016 4:16 pm
Great Britain

Re: Remote frontend won't connect to DB

Post by MikeB2013 »

The defaults assume a combined mythtv frontend/backend configuration with no remote mythtv frontends.

You have already told mysql to use bind address 0.0.0.0 which is needed. There are some settings in mythbackend that also need to be setup to allow a remote mythtv frontend to connect.

On the mythbackend machine check using mythtv-setup
1. General->Host Address Backend Setup:
Security PIN (required) is set to 0000
Primary IP address /DNS name is set to the real ip address e.g. 192.168.7.148 and not 127.0.0.1, use the drop down to select the real ip address and then restart mythtv-backend.

Security PIN (required) being set to 0000 should allow remote frontends to connect to mythtv backend (it will search via upnp, so an initial config.xml file is not required on the mythtv frontend machine). An initial config.xml is normally only needed if upnp does not work for some reason. Sometimes you will see a Cannot connect to database screen, which has a Search button, clicking on this will usually automatically find the remote mythtv backend.

Just in case, for others who see this thread, for mythtv fixes/30 you need to stop mythbackend before running mythtv-setup as follows:
sudo systemctl stop mythtv-backend
mythtv-setup
sudo systemctl start mythtv-backend
gpw928
Junior
Posts: 51
Joined: Tue Feb 12, 2019 5:59 am
Location: Rural NSW
Australia

Re: Remote frontend won't connect to DB

Post by gpw928 »

On the backend setup, I had the PIN set to 0000, but the Primary IP was set to 127.0.0.1. After I changed this to 192.168.1.28, the remote frontend started working (and stopped displaying the "MythTV Startup Status" screen which I expect is only seen when things go wrong).

Thank you Mike. The issue is resolved Much appreciated.
User avatar
Steve Goodey
Moderator
Posts: 219
Joined: Fri Feb 07, 2014 6:30 pm
Location: Colchester, England
Great Britain

Re: Remote frontend won't connect to DB

Post by Steve Goodey »

Hello,

If you're happy with the fix could you possibly added [Solved] to the subject line in the first post?

Ta.
Don't forget the Wiki.
gpw928
Junior
Posts: 51
Joined: Tue Feb 12, 2019 5:59 am
Location: Rural NSW
Australia

Re: [Solved] Remote frontend won't connect to DB

Post by gpw928 »

For those who follow I have summarised the setup below.

I have disabled all proxies on all MythTV hosts (I usually set them in environment variables pointing at the local squid server when I login).

The new MythTV Master Backend server is 192.168.1.28.

The mysql bind address = 0.0.0.0 (all interfaces). This is configured by creating the file /etc/mysql/mariadb.conf.d/99-mythserver.cnf:

Code: Select all

[mysqld]
bind-address = 0.0.0.0
The backend mythtv-setup general Setup has:

Code: Select all

Security PIN: 0000
Allow connections from all subnets: Yes
Listen on all IP addresses: Yes
Primary IP Address/DNS name: 192.168.1.28
This server is the Master Backend: Yes 
The local frontend is configured with the database on "localhost". It works.

The remote frontend (192.168.1.35) is configured with the database on "192.168.1.28". It works.
mitchd123
Newcomer
Posts: 7
Joined: Wed Apr 03, 2019 8:44 pm
United States of America

Re: [Solved] Remote frontend won't connect to DB

Post by mitchd123 »

I had the same/similar problem after upgrading.

I had to edit mythtv.cnf to correct the bind-address from 127.0.0.1 to my ipaddress.

My version was located in /etc/mysql/conf.d
Post Reply