Trouble restoring database to a new machine

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

Moderator: Forum Moderators

Post Reply
pinnerite
Senior
Posts: 256
Joined: Mon Apr 07, 2014 2:34 pm
Great Britain

Trouble restoring database to a new machine

Post by pinnerite »

I have been struggling to restore an sql backup file taken from a Mint 20.04 system,
to a Mint 20.2 system. The structure of both drives is identical.

However I cannot get the backend to start. It cannot connect to the server.

I had previously run mysql -uroot -p < /usr/share/mythtv/sql/mc.sql

This is config.xml from ~/.mythtv

[quote]<Configuration>
<Database>
<PingHost>1</PingHost>
<Host>192.168.1.4</Host>
<UserName>mythtv</UserName>
<Password>mythtv</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>
<UDN>
<MediaRenderer>87254a3c-0e6b-4ec9-8b98-b75609fe5d1a</MediaRenderer>
</UDN>
</UPnP>
<LocalHostName>albury.asandco</LocalHostName>
</Configuration>
[/quote]

When I run:

./mythconverg_restore.pl --directory /home/mythtv/DB_Backups --filename mythconverg-1361-20210921134155.sql.gz

from either the $ or # prompts I get "Failed Can't connect to MySQL server on '192.168.1.4:3308' at ./mythtconverg_restore.pl line 933."

Unable to connect to database.
database: mythconverg
host: 192.168.1.4
username: mythtv
password: mythtv

These are the correct credentials

blm-ubunet
Senior
Posts: 265
Joined: Sun Jun 15, 2014 1:08 am
Cambodia

Re: Trouble restoring database to a new machine

Post by blm-ubunet »

But can you connect to db server directly with those same credentials?
pinnerite
Senior
Posts: 256
Joined: Mon Apr 07, 2014 2:34 pm
Great Britain

Re: Trouble restoring database to a new machine

Post by pinnerite »

I don't think so. I have had to leave this problem because I had several others that cannot yet be fixed, so I am back to the Mint 20.4 system for the foreseeable future.

Thank you for trying to help.
pinnerite
Senior
Posts: 256
Joined: Mon Apr 07, 2014 2:34 pm
Great Britain

Re: Trouble restoring database to a new machine

Post by pinnerite »

I am back to Mint 20.2

This is the result of running mythconverg.pl from /home/mythtv which holds both the backup and restore .pl files and the backedc up sql.gz

/usr/bin/perl is installed

/home/mythtv$ ./mythconverg_restore.pl --drop_database --create_database --directory /home/mythtv --filename mythconverg-1361-20211002114405.sql.gz

./mythconverg_restore.pl: line 1: 1#!/usr/bin/perl: No such file or directory
./mythconverg_restore.pl: line 2: 2#: command not found
./mythconverg_restore.pl: line 3: 3#: command not found
./mythconverg_restore.pl: line 4: 4#: command not found
./mythconverg_restore.pl: line 5: 5#: command not found
./mythconverg_restore.pl: line 6: 6#: command not found
./mythconverg_restore.pl: line 7: 7#: command not found
./mythconverg_restore.pl: line 8: 8#: command not found
./mythconverg_restore.pl: line 9: 9: command not found
./mythconverg_restore.pl: line 10: 10#: command not found
./mythconverg_restore.pl: line 11: 11: command not found
./mythconverg_restore.pl: line 12: 12: command not found
./mythconverg_restore.pl: line 13: 13: command not found
./mythconverg_restore.pl: line 14: 14#: command not found
./mythconverg_restore.pl: line 15: 15: command not found
./mythconverg_restore.pl: line 16: 16: command not found
./mythconverg_restore.pl: line 17: 17: command not found
./mythconverg_restore.pl: line 153: syntax error near unexpected token `)'
./mythconverg_restore.pl: line 153: ` 153(You may leave out the --directory argument if you've specified the directory in the ~/.mythtv/backuprc.)'

I do not have ~./.mythtv/backuprc
Can anyone help.
User avatar
bill6502
Developer
Posts: 2307
Joined: Fri Feb 07, 2014 5:28 pm
United States of America

Re: Trouble restoring database to a new machine

Post by bill6502 »

Is the 1st line of ./mythconverg_restore.pl exactly: #!/usr/bin/perl
(no leading characters before the #)?

From the above, it looks like there are leading line numbers. That means
that the shebang won't work and the shell interpreter is treating all lines
like shell commands.
pinnerite
Senior
Posts: 256
Joined: Mon Apr 07, 2014 2:34 pm
Great Britain

Re: Trouble restoring database to a new machine

Post by pinnerite »

This is a copy and paste from mythconverg_restore.pl

1#!/usr/bin/perl -w

So, I copied and pasted a fresh copy of the script from github.
To my delight it ran trouble free.

Thanks for the prompt.
pinnerite
Senior
Posts: 256
Joined: Mon Apr 07, 2014 2:34 pm
Great Britain

Re: Trouble restoring database to a new machine

Post by pinnerite »

Ah! I cannot get the backend to start.

This is a vanilla Mint 20.2 installation except that all my data partitions, inherited from Mint 20.04 remained intact. So /home/mythtv and ~/.mythtv were untouched.

i did not initialise MySQL in any way before running mythconverg_restore.pl assuming that it would do its stuff.

I set hostname to the machine's static address of 192.168.1.4 as I always do.

$ systemctl start mythtv-backend followed by;
$ systemctl status mythtv-backend

tells me the system is active (running) with no nasty comments.

When I run mythtv-setup I get "Waiting for database to start".

When I select Setup I read "MythTV could not connect to the database. All my settings are correct.
The Custom identifier is unchecked as is the Enable database server wakeup.

I am attaching the last section of the three logs:

mythtv-setup
Oct 3 15:53:31 albury mythtv-setup.real: mythtv-setup[4689]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Interrupt handler
Oct 3 15:53:31 albury mythtv-setup.real: mythtv-setup[4689]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Terminated handler
Oct 3 15:53:31 albury mythtv-setup.real: mythtv-setup[4689]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Segmentation fault handler
Oct 3 15:53:31 albury mythtv-setup.real: mythtv-setup[4689]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Aborted handler
Oct 3 15:53:31 albury mythtv-setup.real: mythtv-setup[4689]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Bus error handler
Oct 3 15:53:31 albury mythtv-setup.real: mythtv-setup[4689]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Floating point exception handler
Oct 3 15:53:31 albury mythtv-setup.real: mythtv-setup[4689]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Illegal instruction handler
Oct 3 15:53:31 albury mythtv-setup.real: mythtv-setup[4689]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Real-time signal 0 handler
Oct 3 15:53:31 albury mythtv-setup.real: mythtv-setup[4689]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Hangup handler
Oct 3 15:53:31 albury mythtv-setup.real: mythtv-setup[4689]: C thread_unknown mythcommandlineparser.cpp:2602 (ConfigureLogging) mythtv-setup version: fixes/31 [v31.0-v31.0] www.mythtv.org
Oct 3 15:53:31 albury mythtv-setup.real: mythtv-setup[4689]: C thread_unknown mythcommandlineparser.cpp:2606 (ConfigureLogging) Qt version: compile: 5.12.5, runtime: 5.12.8
Oct 3 15:53:31 albury mythtv-setup.real: mythtv-setup[4689]: I thread_unknown mythcommandlineparser.cpp:2608 (ConfigureLogging) Linux Mint 20.2 (x86_64)
Oct 3 15:53:31 albury mythtv-setup.real: mythtv-setup[4689]: N thread_unknown mythcommandlineparser.cpp:2610 (ConfigureLogging) Enabled verbose msgs: general
Oct 3 15:53:31 albury mythtv-setup.real: mythtv-setup[4689]: N thread_unknown logging.cpp:724 (logStart) Setting Log Level to LOG_INFO
Oct 3 15:53:31 albury mythtv-setup.real: mythtv-setup[4689]: I Logger logging.cpp:280 (run) Added logging to the console
Oct 3 15:53:31 albury mythtv-setup.real: mythtv-setup[4689]: I LogForward loggingserver.cpp:248 (SyslogLogger) Added syslogging
Oct 3 15:53:32 albury mythtv-setup.real: mythtv-setup[4689]: N thread_unknown mythdirs.cpp:203 (InitializeMythDirs) Using runtime prefix = /usr
Oct 3 15:53:32 albury mythtv-setup.real: mythtv-setup[4689]: N thread_unknown mythdirs.cpp:204 (InitializeMythDirs) Using configuration directory = /home/alan/.mythtv
Oct 3 15:53:32 albury mythtv-setup.real: mythtv-setup[4689]: I CoreContext mythcorecontext.cpp:284 (Init) Assumed character encoding: en_GB.UTF-8
Oct 3 15:53:32 albury mythtv-setup.real: mythtv-setup[4689]: W CoreContext mythcorecontext.cpp:288 (Init) This application expects to be running a locale that specifies a UTF-8 codeset, and many features may behave improperly with your current language settings. Please set the LC_ALL or LC_CTYPE variable(s) in the environment in which this program is executed to include a UTF-8 codeset (such as 'en_US.UTF-8').
Oct 3 15:53:32 albury mythtv-setup.real: mythtv-setup[4689]: I CoreContext mythtranslation.cpp:62 (load) Loading en_gb translation for module mythfrontend
Oct 3 15:53:32 albury mythtv-setup.real: mythtv-setup[4689]: I CoreContext mythcontext.cpp:636 (LoadDatabaseSettings) Using a profile name of: 'albury.asandco' (Usually the same as this host's name.)
Oct 3 15:53:32 albury mythtv-setup.real: mythtv-setup[4689]: I CoreContext mythcontext.cpp:885 (TestDBconnection) Start up testing connections. DB 192.168.1.4, BE , attempt 0, status dbAwake, Delay: 2000
Oct 3 15:53:33 albury mythtv-setup.real: mythtv-setup[4689]: I CoreContext mythcontext.cpp:885 (TestDBconnection) Start up testing connections. DB 192.168.1.4, BE , attempt 1, status dbAwake, Delay: 2000
Oct 3 15:53:38 albury mythtv-setup.real: mythtv-setup[4689]: I CoreContext mythcontext.cpp:885 (TestDBconnection) Start up testing connections. DB 192.168.1.4, BE , attempt 2, status dbAwake, Delay: 2000
Oct 3 15:53:38 albury mythtv-setup.real: mythtv-setup[4689]: I CoreContext mythdisplay.cpp:367 (GetDesiredScreen) Display: Defaulting to primary screen (VGA-0)
Oct 3 15:53:38 albury mythtv-setup.real: mythtv-setup[4689]: I CoreContext mythdisplay.cpp:476 (DebugScreen) Display: Using screen 'VGA-0' (Make: Rogen Tech Distribution Inc Model: B 101740)
Oct 3 15:53:38 albury mythtv-setup.real: mythtv-setup[4689]: I CoreContext mythdisplay.cpp:479 (DebugScreen) Display: Geometry: 1280x1024+1280+0 Size(Qt): 376mmx301mm
Oct 3 15:53:38 albury mythtv-setup.real: mythtv-setup[4689]: I CoreContext mythdisplay.cpp:486 (DebugScreen) Display: Total virtual geometry: 2560x1024+0+0
Oct 3 15:53:38 albury mythtv-setup.real: mythtv-setup[4689]: N CoreContext mythdisplay.cpp:505 (Initialise) Display: Desktop video mode: 1280x1024 60.020Hz
Oct 3 15:53:38 albury mythtv-setup.real: mythtv-setup[4689]: N CoreContext mythdisplay.cpp:512 (Initialise) Display: Display has custom colourspace
Oct 3 15:53:38 albury mythtv-setup.real: mythtv-setup[4689]: I CoreContext screensaver-dbus.cpp:61 (ScreenSaverDBusPrivate) ScreenSaverDBus: Created for DBus service: org.freedesktop.ScreenSaver
Oct 3 15:53:38 albury mythtv-setup.real: mythtv-setup[4689]: I CoreContext screensaver-dbus.cpp:61 (ScreenSaverDBusPrivate) ScreenSaverDBus: Created for DBus service: org.gnome.SessionManager
Oct 3 15:53:38 albury mythtv-setup.real: mythtv-setup[4689]: I SystemIOHandlerW mythsystemunix.cpp:82 (run) Starting IO manager (write)
Oct 3 15:53:38 albury mythtv-setup.real: mythtv-setup[4689]: I SystemIOHandlerR mythsystemunix.cpp:82 (run) Starting IO manager (read)
Oct 3 15:53:38 albury mythtv-setup.real: mythtv-setup[4689]: I SystemSignalManager mythsystemunix.cpp:488 (run) Starting process signal handler
Oct 3 15:53:38 albury mythtv-setup.real: mythtv-setup[4689]: I SystemManager mythsystemunix.cpp:262 (run) Starting process manager
Oct 3 15:53:38 albury mythtv-setup.real: mythtv-setup[4689]: I CoreContext screensaver-x11.cpp:76 (ScreenSaverX11Private) ScreenSaverX11Private: DPMS is active.
Oct 3 15:53:38 albury mythtv-setup.real: mythtv-setup[4689]: 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
Oct 3 15:53:38 albury mythtv-setup.real: mythtv-setup[4689]: W CoreContext mythuihelper.cpp:993 (FindThemeDir) MythUIHelper: No theme dir: '/usr/share/mythtv/themes/Mythbuntu'
Oct 3 15:53:38 albury mythtv-setup.real: mythtv-setup[4689]: W CoreContext mythuihelper.cpp:1012 (FindThemeDir) MythUIHelper: No default theme dir: '/usr/share/mythtv/themes/Mythbuntu'
Oct 3 15:53:38 albury mythtv-setup.real: mythtv-setup[4689]: E CoreContext mythuihelper.cpp:1020 (FindThemeDir) MythUIHelper: Could not find theme: Mythbuntu - Switching to MythCenter-wide
Oct 3 15:53:38 albury mythtv-setup.real: mythtv-setup[4689]: E CoreContext lirc.cpp:199 (Init) LIRC: Failed to connect to Unix socket '/var/run/lirc/lircd'#012#011#011#011eno: No such file or directory (2)
Oct 3 15:53:38 albury mythtv-setup.real: mythtv-setup[4689]: I CoreContext jsmenu.cpp:140 (ReadConfig) No joystick configuration found, not enabling joystick control
Oct 3 15:53:38 albury mythtv-setup.real: mythtv-setup[4689]: I CoreContext mythudplistener.cpp:32 (Enable) UDPListener: Enabling
Oct 3 15:53:38 albury mythtv-setup.real: mythtv-setup[4689]: I CoreContext serverpool.cpp:542 (bind) Binding to UDP 0.0.0.0:0
Oct 3 15:53:38 albury mythtv-setup.real: mythtv-setup[4689]: I CoreContext serverpool.cpp:542 (bind) Binding to UDP [::]:0
Oct 3 15:53:38 albury mythtv-setup.real: mythtv-setup[4689]: I CoreContext mythmainwindow.cpp:1009 (Init) Using Frameless Window
Oct 3 15:53:38 albury mythtv-setup.real: mythtv-setup[4689]: I CoreContext mythmainwindow.cpp:1025 (Init) Using Full Screen Window
Oct 3 15:53:38 albury mythtv-setup.real: mythtv-setup[4689]: I CoreContext mythdisplay.cpp:227 (SetWidget) Display: Have main widget
Oct 3 15:53:38 albury mythtv-setup.real: mythtv-setup[4689]: I CoreContext mythdisplay.cpp:231 (SetWidget) Display: Have main window
Oct 3 15:53:38 albury mythtv-setup.real: mythtv-setup[4689]: I CoreContext mythdisplay.cpp:367 (GetDesiredScreen) Display: Defaulting to primary screen (VGA-0)
Oct 3 15:53:38 albury mythtv-setup.real: mythtv-setup[4689]: I CoreContext mythmainwindow.cpp:1057 (Init) UI Screen Resolution: 1280 x 1024
Oct 3 15:53:38 albury mythtv-setup.real: mythtv-setup[4689]: I CoreContext opengl/mythrenderopengl.cpp:421 (DebugFeatures) OpenGL: OpenGL vendor : X.Org
Oct 3 15:53:38 albury mythtv-setup.real: mythtv-setup[4689]: I CoreContext opengl/mythrenderopengl.cpp:422 (DebugFeatures) OpenGL: OpenGL renderer : AMD RV710 (DRM 2.50.0 / 5.4.0-88-generic, LLVM 12.0.0)
Oct 3 15:53:38 albury mythtv-setup.real: mythtv-setup[4689]: I CoreContext opengl/mythrenderopengl.cpp:423 (DebugFeatures) OpenGL: OpenGL version : 3.0 Mesa 21.0.3
Oct 3 15:53:38 albury mythtv-setup.real: mythtv-setup[4689]: I CoreContext opengl/mythrenderopengl.cpp:424 (DebugFeatures) OpenGL: Qt platform : xcb
Oct 3 15:53:38 albury mythtv-setup.real: mythtv-setup[4689]: I CoreContext opengl/mythrenderopengl.cpp:427 (DebugFeatures) OpenGL: EGL display : Yes
Oct 3 15:53:38 albury mythtv-setup.real: mythtv-setup[4689]: I CoreContext opengl/mythrenderopengl.cpp:428 (DebugFeatures) OpenGL: EGL images : Yes
Oct 3 15:53:38 albury mythtv-setup.real: mythtv-setup[4689]: I CoreContext opengl/mythrenderopengl.cpp:430 (DebugFeatures) OpenGL: Qt OpenGL format : OpenGL 3.0
Oct 3 15:53:38 albury mythtv-setup.real: mythtv-setup[4689]: I CoreContext opengl/mythrenderopengl.cpp:431 (DebugFeatures) OpenGL: Qt OpenGL surface : RGBA: 8880 Depth: 0 Stencil: 0
Oct 3 15:53:38 albury mythtv-setup.real: mythtv-setup[4689]: I CoreContext opengl/mythrenderopengl.cpp:432 (DebugFeatures) OpenGL: Max texture size : 8192
Oct 3 15:53:38 albury mythtv-setup.real: mythtv-setup[4689]: I CoreContext opengl/mythrenderopengl.cpp:433 (DebugFeatures) OpenGL: Max texture units : 48
Oct 3 15:53:38 albury mythtv-setup.real: mythtv-setup[4689]: I CoreContext opengl/mythrenderopengl.cpp:434 (DebugFeatures) OpenGL: Shaders : Yes
Oct 3 15:53:38 albury mythtv-setup.real: mythtv-setup[4689]: I CoreContext opengl/mythrenderopengl.cpp:435 (DebugFeatures) OpenGL: NPOT textures : Yes
Oct 3 15:53:38 albury mythtv-setup.real: mythtv-setup[4689]: I CoreContext opengl/mythrenderopengl.cpp:436 (DebugFeatures) OpenGL: Multitexturing : Yes
Oct 3 15:53:38 albury mythtv-setup.real: mythtv-setup[4689]: I CoreContext opengl/mythrenderopengl.cpp:437 (DebugFeatures) OpenGL: Rectangular textures : Yes
Oct 3 15:53:38 albury mythtv-setup.real: mythtv-setup[4689]: I CoreContext opengl/mythrenderopengl.cpp:439 (DebugFeatures) OpenGL: Buffer mapping : Yes
Oct 3 15:53:38 albury mythtv-setup.real: mythtv-setup[4689]: I CoreContext opengl/mythrenderopengl.cpp:440 (DebugFeatures) OpenGL: Framebuffer objects : Yes
Oct 3 15:53:38 albury mythtv-setup.real: mythtv-setup[4689]: I CoreContext opengl/mythrenderopengl.cpp:441 (DebugFeatures) OpenGL: 16bit framebuffers : Yes
Oct 3 15:53:38 albury mythtv-setup.real: mythtv-setup[4689]: I CoreContext opengl/mythrenderopengl.cpp:442 (DebugFeatures) OpenGL: Unpack Subimage : Yes
Oct 3 15:53:38 albury mythtv-setup.real: mythtv-setup[4689]: I CoreContext opengl/mythrenderopengl.cpp:443 (DebugFeatures) OpenGL: GL_RED/GL_R8 : Yes
Oct 3 15:53:38 albury mythtv-setup.real: mythtv-setup[4689]: I CoreContext opengl/mythrenderopengl.cpp:398 (Init) OpenGL: Initialised MythRenderOpenGL
Oct 3 15:53:38 albury mythtv-setup.real: mythtv-setup[4689]: I CoreContext opengl/mythrenderopengl.cpp:399 (Init) OpenGL: Using full range output
Oct 3 15:53:38 albury mythtv-setup.real: mythtv-setup[4689]: I CoreContext mythuihelper.cpp:762 (PruneCacheDir) MythUIHelper: Pruning cache directory: /home/alan/.mythtv/cache/remotecache
Oct 3 15:53:38 albury mythtv-setup.real: mythtv-setup[4689]: I CoreContext mythuihelper.cpp:819 (PruneCacheDir) MythUIHelper: Kept 27 files, deleted 0 files, stat error on 0 files
Oct 3 15:53:38 albury mythtv-setup.real: mythtv-setup[4689]: I CoreContext mythuihelper.cpp:762 (PruneCacheDir) MythUIHelper: Pruning cache directory: /home/alan/.mythtv/cache/thumbnails
Oct 3 15:53:38 albury mythtv-setup.real: mythtv-setup[4689]: I CoreContext mythuihelper.cpp:819 (PruneCacheDir) MythUIHelper: Kept 68 files, deleted 0 files, stat error on 0 files
Oct 3 15:53:38 albury mythtv-setup.real: mythtv-setup[4689]: E CoreContext devices/mythcecadapter.cpp:173 (Open) CECAdapter: Failed to load libcec.
Oct 3 15:53:38 albury mythtv-setup.real: mythtv-setup[4689]: I CoreContext mythdisplay.cpp:476 (DebugScreen) Display: Changed to screen 'VGA-1-1' (Make: Rogen Tech Distribution Inc Model: B101710-)
Oct 3 15:53:38 albury mythtv-setup.real: mythtv-setup[4689]: I CoreContext mythdisplay.cpp:479 (DebugScreen) Display: Geometry: 1280x1024+0+0 Size(Qt): 338mmx270mm
Oct 3 15:53:38 albury mythtv-setup.real: mythtv-setup[4689]: I CoreContext mythdisplay.cpp:486 (DebugScreen) Display: Total virtual geometry: 2560x1024+0+0
Oct 3 15:53:38 albury mythtv-setup.real: mythtv-setup[4689]: W CoreContext mythedid.cpp:228 (ParseBaseBlock) EDID: Chromaticity mismatch!
Oct 3 15:53:38 albury mythtv-setup.real: mythtv-setup[4689]: N CoreContext mythdisplay.cpp:505 (Initialise) Display: Desktop video mode: 1280x1024 60.020Hz
Oct 3 15:53:38 albury mythtv-setup.real: mythtv-setup[4689]: N CoreContext mythdisplay.cpp:510 (Initialise) Display: Display is using sRGB colourspace
Oct 3 15:53:39 albury mythtv-setup.real: mythtv-setup[4689]: I CoreContext mythdisplay.cpp:476 (DebugScreen) Display: Changed to screen 'VGA-0' (Make: Rogen Tech Distribution Inc Model: B 101740)
Oct 3 15:53:39 albury mythtv-setup.real: mythtv-setup[4689]: I CoreContext mythdisplay.cpp:479 (DebugScreen) Display: Geometry: 1280x1024+1280+0 Size(Qt): 376mmx301mm
Oct 3 15:53:39 albury mythtv-setup.real: mythtv-setup[4689]: I CoreContext mythdisplay.cpp:486 (DebugScreen) Display: Total virtual geometry: 2560x1024+0+0
Oct 3 15:53:43 albury mythtv-setup.real: mythtv-setup[4689]: I CoreContext mythcontext.cpp:885 (TestDBconnection) Start up testing connections. DB 192.168.1.4, BE , attempt 3, status dbAwake, Delay: 2000
Oct 3 15:53:48 albury mythtv-setup.real: mythtv-setup[4689]: I CoreContext mythcontext.cpp:885 (TestDBconnection) Start up testing connections. DB 192.168.1.4, BE , attempt 4, status dbAwake, Delay: 2000
Oct 3 15:53:53 albury mythtv-setup.real: mythtv-setup[4689]: I CoreContext mythcontext.cpp:885 (TestDBconnection) Start up testing connections. DB 192.168.1.4, BE , attempt 5, status dbAwake, Delay: 2000
Oct 3 15:53:56 albury mythtv-setup.real: mythtv-setup[4689]: I CoreContext mythcontext.cpp:1008 (TestDBconnection) Start up failure. host 192.168.1.4, status dbAwakeFail
Oct 3 15:53:56 albury mythtv-setup.real: mythtv-setup[4689]: E CoreContext main.cpp:399 (main) Failed to init MythContext, exiting.
Oct 3 15:53:56 albury mythtv-setup.real: mythtv-setup[4689]: W CoreContext mythpainter.cpp:35 (Teardown) MythPainter: 75 images not yet de-allocated.
Oct 3 15:53:56 albury mythtv-setup.real: mythtv-setup[4689]: I CoreContext opengl/mythpainteropengl.cpp:74 (ClearCache) Clearing OpenGL painter cache.
Oct 3 15:53:56 albury mythtv-setup.real: mythtv-setup[4689]: I CoreContext opengl/mythrenderopengl.cpp:147 (~MythRenderOpenGL) OpenGL: MythRenderOpenGL closing
Oct 3 15:53:57 albury mythtv-setup.real: mythtv-setup[4689]: I CoreContext mythcontext.cpp:1665 (~MythContext) Exiting
mythbackend log
Oct 3 15:50:05 albury mythbackend: mythbackend[4487]: C thread_unknown mythcommandlineparser.cpp:2602 (ConfigureLogging) mythbackend version: fixes/31 [v31.0-v31.0] www.mythtv.org
Oct 3 15:50:05 albury mythbackend: mythbackend[4487]: C thread_unknown mythcommandlineparser.cpp:2606 (ConfigureLogging) Qt version: compile: 5.12.5, runtime: 5.12.8
Oct 3 15:50:05 albury mythbackend: mythbackend[4487]: I thread_unknown mythcommandlineparser.cpp:2608 (ConfigureLogging) Linux Mint 20.2 (x86_64)
Oct 3 15:50:05 albury mythbackend: mythbackend[4487]: N thread_unknown mythcommandlineparser.cpp:2610 (ConfigureLogging) Enabled verbose msgs: general
Oct 3 15:50:05 albury mythbackend: mythbackend[4487]: N thread_unknown logging.cpp:724 (logStart) Setting Log Level to LOG_INFO
Oct 3 15:50:05 albury mythbackend: mythbackend[4487]: I Logger logging.cpp:280 (run) Added logging to the console
Oct 3 15:50:05 albury mythbackend: mythbackend[4487]: I LogForward loggingserver.cpp:248 (SyslogLogger) Added syslogging
Oct 3 15:50:05 albury mythbackend: mythbackend[4487]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Interrupt handler
Oct 3 15:50:05 albury mythbackend: mythbackend[4487]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Terminated handler
Oct 3 15:50:05 albury mythbackend: mythbackend[4487]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Segmentation fault handler
Oct 3 15:50:05 albury mythbackend: mythbackend[4487]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Aborted handler
Oct 3 15:50:05 albury mythbackend: mythbackend[4487]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Bus error handler
Oct 3 15:50:05 albury mythbackend: mythbackend[4487]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Floating point exception handler
Oct 3 15:50:05 albury mythbackend: mythbackend[4487]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Illegal instruction handler
Oct 3 15:50:05 albury mythbackend: mythbackend[4487]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Real-time signal 0 handler
Oct 3 15:50:05 albury mythbackend: mythbackend[4487]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Hangup handler
Oct 3 15:50:05 albury mythbackend: mythbackend[4487]: N thread_unknown mythdirs.cpp:203 (InitializeMythDirs) Using runtime prefix = /usr
Oct 3 15:50:05 albury mythbackend: mythbackend[4487]: N thread_unknown mythdirs.cpp:204 (InitializeMythDirs) Using configuration directory = /home/mythtv/.mythtv
Oct 3 15:50:05 albury mythbackend: mythbackend[4487]: I CoreContext mythcorecontext.cpp:284 (Init) Assumed character encoding: en_GB.UTF-8
Oct 3 15:50:05 albury mythbackend: mythbackend[4487]: I CoreContext mythcontext.cpp:629 (LoadDatabaseSettings) Empty LocalHostName. This is typical.
Oct 3 15:50:05 albury mythbackend: mythbackend[4487]: I CoreContext mythcontext.cpp:636 (LoadDatabaseSettings) Using a profile name of: 'albury.asandco' (Usually the same as this host's name.)
Oct 3 15:50:05 albury mythbackend: mythbackend[4487]: I CoreContext mythcontext.cpp:885 (TestDBconnection) Start up testing connections. DB 192.168.1.4, BE , attempt 0, status dbAwake, Delay: 2000
Oct 3 15:50:06 albury mythbackend: mythbackend[4487]: I CoreContext mythcontext.cpp:885 (TestDBconnection) Start up testing connections. DB 192.168.1.4, BE , attempt 1, status dbAwake, Delay: 2000
Oct 3 15:50:11 albury mythbackend: mythbackend[4487]: I CoreContext mythcontext.cpp:885 (TestDBconnection) Start up testing connections. DB 192.168.1.4, BE , attempt 2, status dbAwake, Delay: 2000
Oct 3 15:50:16 albury mythbackend: mythbackend[4487]: I CoreContext mythcontext.cpp:885 (TestDBconnection) Start up testing connections. DB 192.168.1.4, BE , attempt 3, status dbAwake, Delay: 2000
Oct 3 15:50:21 albury mythbackend: mythbackend[4487]: I CoreContext mythcontext.cpp:885 (TestDBconnection) Start up testing connections. DB 192.168.1.4, BE , attempt 4, status dbAwake, Delay: 2000
Oct 3 15:50:26 albury mythbackend: mythbackend[4487]: I CoreContext mythcontext.cpp:885 (TestDBconnection) Start up testing connections. DB 192.168.1.4, BE , attempt 5, status dbAwake, Delay: 2000
Oct 3 15:50:31 albury mythbackend: mythbackend[4487]: I CoreContext mythcontext.cpp:885 (TestDBconnection) Start up testing connections. DB 192.168.1.4, BE , attempt 6, status dbAwake, Delay: 2000
Oct 3 15:50:36 albury mythbackend: mythbackend[4487]: I CoreContext mythcontext.cpp:885 (TestDBconnection) Start up testing connections. DB 192.168.1.4, BE , attempt 7, status dbAwake, Delay: 2000
Oct 3 15:50:41 albury mythbackend: mythbackend[4487]: I CoreContext mythcontext.cpp:885 (TestDBconnection) Start up testing connections. DB 192.168.1.4, BE , attempt 8, status dbAwake, Delay: 2000
Oct 3 15:50:46 albury mythbackend: mythbackend[4487]: I CoreContext mythcontext.cpp:885 (TestDBconnection) Start up testing connections. DB 192.168.1.4, BE , attempt 9, status dbAwake, Delay: 2000
Oct 3 15:50:51 albury mythbackend: mythbackend[4487]: I CoreContext mythcontext.cpp:885 (TestDBconnection) Start up testing connections. DB 192.168.1.4, BE , attempt 10, status dbAwake, Delay: 2000
Oct 3 15:50:56 albury mythbackend: mythbackend[4487]: I CoreContext mythcontext.cpp:1008 (TestDBconnection) Start up failure. host 192.168.1.4, status dbAwakeFail
Oct 3 15:50:57 albury mythbackend: mythbackend[4487]: C CoreContext main.cpp:138 (main) Failed to init MythContext.
Oct 3 15:50:57 albury mythbackend: mythbackend[4487]: I CoreContext mythcontext.cpp:1665 (~MythContext) Exiting
Oct 3 15:50:59 albury mythbackend: mythbackend[4499]: C thread_unknown mythcommandlineparser.cpp:2602 (ConfigureLogging) mythbackend version: fixes/31 [v31.0-v31.0] www.mythtv.org
Oct 3 15:50:59 albury mythbackend: mythbackend[4499]: C thread_unknown mythcommandlineparser.cpp:2606 (ConfigureLogging) Qt version: compile: 5.12.5, runtime: 5.12.8
Oct 3 15:50:59 albury mythbackend: mythbackend[4499]: I thread_unknown mythcommandlineparser.cpp:2608 (ConfigureLogging) Linux Mint 20.2 (x86_64)
Oct 3 15:50:59 albury mythbackend: mythbackend[4499]: N thread_unknown mythcommandlineparser.cpp:2610 (ConfigureLogging) Enabled verbose msgs: general
Oct 3 15:50:59 albury mythbackend: mythbackend[4499]: N thread_unknown logging.cpp:724 (logStart) Setting Log Level to LOG_INFO
Oct 3 15:50:59 albury mythbackend: mythbackend[4499]: I Logger logging.cpp:280 (run) Added logging to the console
Oct 3 15:50:59 albury mythbackend: mythbackend[4499]: I LogForward loggingserver.cpp:248 (SyslogLogger) Added syslogging
Oct 3 15:50:59 albury mythbackend: mythbackend[4499]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Interrupt handler
Oct 3 15:50:59 albury mythbackend: mythbackend[4499]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Terminated handler
Oct 3 15:50:59 albury mythbackend: mythbackend[4499]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Segmentation fault handler
Oct 3 15:50:59 albury mythbackend: mythbackend[4499]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Aborted handler
Oct 3 15:50:59 albury mythbackend: mythbackend[4499]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Bus error handler
Oct 3 15:50:59 albury mythbackend: mythbackend[4499]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Floating point exception handler
Oct 3 15:50:59 albury mythbackend: mythbackend[4499]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Illegal instruction handler
Oct 3 15:50:59 albury mythbackend: mythbackend[4499]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Real-time signal 0 handler
Oct 3 15:50:59 albury mythbackend: mythbackend[4499]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Hangup handler
Oct 3 15:50:59 albury mythbackend: mythbackend[4499]: N thread_unknown mythdirs.cpp:203 (InitializeMythDirs) Using runtime prefix = /usr
Oct 3 15:50:59 albury mythbackend: mythbackend[4499]: N thread_unknown mythdirs.cpp:204 (InitializeMythDirs) Using configuration directory = /home/mythtv/.mythtv
Oct 3 15:50:59 albury mythbackend: mythbackend[4499]: I CoreContext mythcorecontext.cpp:284 (Init) Assumed character encoding: en_GB.UTF-8
Oct 3 15:50:59 albury mythbackend: mythbackend[4499]: I CoreContext mythcontext.cpp:629 (LoadDatabaseSettings) Empty LocalHostName. This is typical.
Oct 3 15:50:59 albury mythbackend: mythbackend[4499]: I CoreContext mythcontext.cpp:636 (LoadDatabaseSettings) Using a profile name of: 'albury.asandco' (Usually the same as this host's name.)
Oct 3 15:50:59 albury mythbackend: mythbackend[4499]: I CoreContext mythcontext.cpp:885 (TestDBconnection) Start up testing connections. DB 192.168.1.4, BE , attempt 0, status dbAwake, Delay: 2000
Oct 3 15:51:00 albury mythbackend: mythbackend[4499]: I CoreContext mythcontext.cpp:885 (TestDBconnection) Start up testing connections. DB 192.168.1.4, BE , attempt 1, status dbAwake, Delay: 2000
Oct 3 15:51:05 albury mythbackend: mythbackend[4499]: I CoreContext mythcontext.cpp:885 (TestDBconnection) Start up testing connections. DB 192.168.1.4, BE , attempt 2, status dbAwake, Delay: 2000
Oct 3 15:51:10 albury mythbackend: mythbackend[4499]: I CoreContext mythcontext.cpp:885 (TestDBconnection) Start up testing connections. DB 192.168.1.4, BE , attempt 3, status dbAwake, Delay: 2000
Oct 3 15:51:15 albury mythbackend: mythbackend[4499]: I CoreContext mythcontext.cpp:885 (TestDBconnection) Start up testing connections. DB 192.168.1.4, BE , attempt 4, status dbAwake, Delay: 2000
Oct 3 15:51:20 albury mythbackend: mythbackend[4499]: I CoreContext mythcontext.cpp:885 (TestDBconnection) Start up testing connections. DB 192.168.1.4, BE , attempt 5, status dbAwake, Delay: 2000
Oct 3 15:51:25 albury mythbackend: mythbackend[4499]: I CoreContext mythcontext.cpp:885 (TestDBconnection) Start up testing connections. DB 192.168.1.4, BE , attempt 6, status dbAwake, Delay: 2000
Oct 3 15:51:30 albury mythbackend: mythbackend[4499]: I CoreContext mythcontext.cpp:885 (TestDBconnection) Start up testing connections. DB 192.168.1.4, BE , attempt 7, status dbAwake, Delay: 2000
Oct 3 15:51:35 albury mythbackend: mythbackend[4499]: I CoreContext mythcontext.cpp:885 (TestDBconnection) Start up testing connections. DB 192.168.1.4, BE , attempt 8, status dbAwake, Delay: 2000
Oct 3 15:51:40 albury mythbackend: mythbackend[4499]: I CoreContext mythcontext.cpp:885 (TestDBconnection) Start up testing connections. DB 192.168.1.4, BE , attempt 9, status dbAwake, Delay: 2000
Oct 3 15:51:45 albury mythbackend: mythbackend[4499]: I CoreContext mythcontext.cpp:885 (TestDBconnection) Start up testing connections. DB 192.168.1.4, BE , attempt 10, status dbAwake, Delay: 2000
Oct 3 15:51:50 albury mythbackend: mythbackend[4499]: I CoreContext mythcontext.cpp:1008 (TestDBconnection) Start up failure. host 192.168.1.4, status dbAwakeFail
Oct 3 15:51:51 albury mythbackend: mythbackend[4499]: C CoreContext main.cpp:138 (main) Failed to init MythContext.
Oct 3 15:51:51 albury mythbackend: mythbackend[4499]: I CoreContext mythcontext.cpp:1665 (~MythContext) Exiting
Oct 3 15:51:52 albury mythbackend: mythbackend[4545]: C thread_unknown mythcommandlineparser.cpp:2602 (ConfigureLogging) mythbackend version: fixes/31 [v31.0-v31.0] www.mythtv.org
Oct 3 15:51:52 albury mythbackend: mythbackend[4545]: C thread_unknown mythcommandlineparser.cpp:2606 (ConfigureLogging) Qt version: compile: 5.12.5, runtime: 5.12.8
Oct 3 15:51:52 albury mythbackend: mythbackend[4545]: I thread_unknown mythcommandlineparser.cpp:2608 (ConfigureLogging) Linux Mint 20.2 (x86_64)
Oct 3 15:51:52 albury mythbackend: mythbackend[4545]: N thread_unknown mythcommandlineparser.cpp:2610 (ConfigureLogging) Enabled verbose msgs: general
Oct 3 15:51:52 albury mythbackend: mythbackend[4545]: N thread_unknown logging.cpp:724 (logStart) Setting Log Level to LOG_INFO
Oct 3 15:51:52 albury mythbackend: mythbackend[4545]: I Logger logging.cpp:280 (run) Added logging to the console
Oct 3 15:51:52 albury mythbackend: mythbackend[4545]: I LogForward loggingserver.cpp:248 (SyslogLogger) Added syslogging
Oct 3 15:51:52 albury mythbackend: mythbackend[4545]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Interrupt handler
Oct 3 15:51:52 albury mythbackend: mythbackend[4545]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Terminated handler
Oct 3 15:51:52 albury mythbackend: mythbackend[4545]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Segmentation fault handler
Oct 3 15:51:52 albury mythbackend: mythbackend[4545]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Aborted handler
Oct 3 15:51:52 albury mythbackend: mythbackend[4545]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Bus error handler
Oct 3 15:51:52 albury mythbackend: mythbackend[4545]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Floating point exception handler
Oct 3 15:51:52 albury mythbackend: mythbackend[4545]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Illegal instruction handler
Oct 3 15:51:52 albury mythbackend: mythbackend[4545]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Real-time signal 0 handler
Oct 3 15:51:52 albury mythbackend: mythbackend[4545]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Hangup handler
Oct 3 15:51:52 albury mythbackend: mythbackend[4545]: N thread_unknown mythdirs.cpp:203 (InitializeMythDirs) Using runtime prefix = /usr
Oct 3 15:51:52 albury mythbackend: mythbackend[4545]: N thread_unknown mythdirs.cpp:204 (InitializeMythDirs) Using configuration directory = /home/mythtv/.mythtv
Oct 3 15:51:52 albury mythbackend: mythbackend[4545]: I CoreContext mythcorecontext.cpp:284 (Init) Assumed character encoding: en_GB.UTF-8
Oct 3 15:51:52 albury mythbackend: mythbackend[4545]: I CoreContext mythcontext.cpp:629 (LoadDatabaseSettings) Empty LocalHostName. This is typical.
Oct 3 15:51:52 albury mythbackend: mythbackend[4545]: I CoreContext mythcontext.cpp:636 (LoadDatabaseSettings) Using a profile name of: 'albury.asandco' (Usually the same as this host's name.)
Oct 3 15:51:52 albury mythbackend: mythbackend[4545]: I CoreContext mythcontext.cpp:885 (TestDBconnection) Start up testing connections. DB 192.168.1.4, BE , attempt 0, status dbAwake, Delay: 2000
Oct 3 15:51:53 albury mythbackend: mythbackend[4545]: I CoreContext mythcontext.cpp:885 (TestDBconnection) Start up testing connections. DB 192.168.1.4, BE , attempt 1, status dbAwake, Delay: 2000
Oct 3 15:51:58 albury mythbackend: mythbackend[4545]: I CoreContext mythcontext.cpp:885 (TestDBconnection) Start up testing connections. DB 192.168.1.4, BE , attempt 2, status dbAwake, Delay: 2000
Oct 3 15:52:03 albury mythbackend: mythbackend[4545]: I CoreContext mythcontext.cpp:885 (TestDBconnection) Start up testing connections. DB 192.168.1.4, BE , attempt 3, status dbAwake, Delay: 2000
Oct 3 15:52:08 albury mythbackend: mythbackend[4545]: I CoreContext mythcontext.cpp:885 (TestDBconnection) Start up testing connections. DB 192.168.1.4, BE , attempt 4, status dbAwake, Delay: 2000
Oct 3 15:52:13 albury mythbackend: mythbackend[4545]: I CoreContext mythcontext.cpp:885 (TestDBconnection) Start up testing connections. DB 192.168.1.4, BE , attempt 5, status dbAwake, Delay: 2000
Oct 3 15:52:18 albury mythbackend: mythbackend[4545]: I CoreContext mythcontext.cpp:885 (TestDBconnection) Start up testing connections. DB 192.168.1.4, BE , attempt 6, status dbAwake, Delay: 2000
Oct 3 15:52:23 albury mythbackend: mythbackend[4545]: I CoreContext mythcontext.cpp:885 (TestDBconnection) Start up testing connections. DB 192.168.1.4, BE , attempt 7, status dbAwake, Delay: 2000
Oct 3 15:52:28 albury mythbackend: mythbackend[4545]: I CoreContext mythcontext.cpp:885 (TestDBconnection) Start up testing connections. DB 192.168.1.4, BE , attempt 8, status dbAwake, Delay: 2000
Oct 3 15:52:33 albury mythbackend: mythbackend[4545]: I CoreContext mythcontext.cpp:885 (TestDBconnection) Start up testing connections. DB 192.168.1.4, BE , attempt 9, status dbAwake, Delay: 2000
Oct 3 15:52:38 albury mythbackend: mythbackend[4545]: I CoreContext mythcontext.cpp:885 (TestDBconnection) Start up testing connections. DB 192.168.1.4, BE , attempt 10, status dbAwake, Delay: 2000
Oct 3 15:52:43 albury mythbackend: mythbackend[4545]: I CoreContext mythcontext.cpp:1008 (TestDBconnection) Start up failure. host 192.168.1.4, status dbAwakeFail
Oct 3 15:52:44 albury mythbackend: mythbackend[4545]: C CoreContext main.cpp:138 (main) Failed to init MythContext.
Oct 3 15:52:44 albury mythbackend: mythbackend[4545]: I CoreContext mythcontext.cpp:1665 (~MythContext) Exiting
Oct 3 15:52:45 albury mythbackend: mythbackend[4613]: C thread_unknown mythcommandlineparser.cpp:2602 (ConfigureLogging) mythbackend version: fixes/31 [v31.0-v31.0] www.mythtv.org
Oct 3 15:52:45 albury mythbackend: mythbackend[4613]: C thread_unknown mythcommandlineparser.cpp:2606 (ConfigureLogging) Qt version: compile: 5.12.5, runtime: 5.12.8
Oct 3 15:52:45 albury mythbackend: mythbackend[4613]: I thread_unknown mythcommandlineparser.cpp:2608 (ConfigureLogging) Linux Mint 20.2 (x86_64)
Oct 3 15:52:45 albury mythbackend: mythbackend[4613]: N thread_unknown mythcommandlineparser.cpp:2610 (ConfigureLogging) Enabled verbose msgs: general
Oct 3 15:52:45 albury mythbackend: mythbackend[4613]: N thread_unknown logging.cpp:724 (logStart) Setting Log Level to LOG_INFO
Oct 3 15:52:45 albury mythbackend: mythbackend[4613]: I Logger logging.cpp:280 (run) Added logging to the console
Oct 3 15:52:45 albury mythbackend: mythbackend[4613]: I LogForward loggingserver.cpp:248 (SyslogLogger) Added syslogging
Oct 3 15:52:45 albury mythbackend: mythbackend[4613]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Interrupt handler
Oct 3 15:52:45 albury mythbackend: mythbackend[4613]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Terminated handler
Oct 3 15:52:45 albury mythbackend: mythbackend[4613]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Segmentation fault handler
Oct 3 15:52:45 albury mythbackend: mythbackend[4613]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Aborted handler
Oct 3 15:52:45 albury mythbackend: mythbackend[4613]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Bus error handler
Oct 3 15:52:45 albury mythbackend: mythbackend[4613]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Floating point exception handler
Oct 3 15:52:45 albury mythbackend: mythbackend[4613]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Illegal instruction handler
Oct 3 15:52:45 albury mythbackend: mythbackend[4613]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Real-time signal 0 handler
Oct 3 15:52:45 albury mythbackend: mythbackend[4613]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Hangup handler
Oct 3 15:52:45 albury mythbackend: mythbackend[4613]: N thread_unknown mythdirs.cpp:203 (InitializeMythDirs) Using runtime prefix = /usr
Oct 3 15:52:45 albury mythbackend: mythbackend[4613]: N thread_unknown mythdirs.cpp:204 (InitializeMythDirs) Using configuration directory = /home/mythtv/.mythtv
Oct 3 15:52:45 albury mythbackend: mythbackend[4613]: I CoreContext mythcorecontext.cpp:284 (Init) Assumed character encoding: en_GB.UTF-8
Oct 3 15:52:45 albury mythbackend: mythbackend[4613]: I CoreContext mythcontext.cpp:629 (LoadDatabaseSettings) Empty LocalHostName. This is typical.
Oct 3 15:52:45 albury mythbackend: mythbackend[4613]: I CoreContext mythcontext.cpp:636 (LoadDatabaseSettings) Using a profile name of: 'albury.asandco' (Usually the same as this host's name.)
Oct 3 15:52:45 albury mythbackend: mythbackend[4613]: I CoreContext mythcontext.cpp:885 (TestDBconnection) Start up testing connections. DB 192.168.1.4, BE , attempt 0, status dbAwake, Delay: 2000
Oct 3 15:52:46 albury mythbackend: mythbackend[4613]: I CoreContext mythcontext.cpp:885 (TestDBconnection) Start up testing connections. DB 192.168.1.4, BE , attempt 1, status dbAwake, Delay: 2000
Oct 3 15:52:51 albury mythbackend: mythbackend[4613]: I CoreContext mythcontext.cpp:885 (TestDBconnection) Start up testing connections. DB 192.168.1.4, BE , attempt 2, status dbAwake, Delay: 2000
Oct 3 15:52:56 albury mythbackend: mythbackend[4613]: I CoreContext mythcontext.cpp:885 (TestDBconnection) Start up testing connections. DB 192.168.1.4, BE , attempt 3, status dbAwake, Delay: 2000
Oct 3 15:53:01 albury mythbackend: mythbackend[4613]: I CoreContext mythcontext.cpp:885 (TestDBconnection) Start up testing connections. DB 192.168.1.4, BE , attempt 4, status dbAwake, Delay: 2000
Oct 3 15:53:06 albury mythbackend: mythbackend[4613]: I CoreContext mythcontext.cpp:885 (TestDBconnection) Start up testing connections. DB 192.168.1.4, BE , attempt 5, status dbAwake, Delay: 2000
Oct 3 15:53:11 albury mythbackend: mythbackend[4613]: I CoreContext mythcontext.cpp:885 (TestDBconnection) Start up testing connections. DB 192.168.1.4, BE , attempt 6, status dbAwake, Delay: 2000
Oct 3 15:53:16 albury mythbackend: mythbackend[4613]: I CoreContext mythcontext.cpp:885 (TestDBconnection) Start up testing connections. DB 192.168.1.4, BE , attempt 7, status dbAwake, Delay: 2000
Oct 3 15:53:21 albury mythbackend: mythbackend[4613]: C CoreContext signalhandling.cpp:299 (handleSignal) Received Terminated: Code 0, PID 1, UID 0, Value 0x00000000
Oct 3 15:53:21 albury mythbackend: mythbackend[4613]: I CoreContext mythcontext.cpp:885 (TestDBconnection) Start up testing connections. DB 192.168.1.4, BE , attempt 8, status dbAwake, Delay: 2000
Oct 3 15:53:26 albury mythbackend: mythbackend[4613]: I CoreContext mythcontext.cpp:885 (TestDBconnection) Start up testing connections. DB 192.168.1.4, BE , attempt 9, status dbAwake, Delay: 2000
Oct 3 15:53:31 albury mythbackend: mythbackend[4613]: I CoreContext mythcontext.cpp:885 (TestDBconnection) Start up testing connections. DB 192.168.1.4, BE , attempt 10, status dbAwake, Delay: 2000
mythfrontend.log
Oct 3 15:31:43 albury mythfrontend.real: mythfrontend[3321]: I CoreContext AirPlay/mythraopdevice.cpp:71 (Cleanup) RAOP Device: Cleaning up.
Oct 3 15:31:43 albury mythfrontend.real: mythfrontend[3321]: I CoreContext AirPlay/mythairplayserver.cpp:393 (Cleanup) AirPlay: Cleaning up.
Oct 3 15:31:43 albury mythfrontend.real: mythfrontend[3321]: I CoreContext mythcontext.cpp:1659 (~MythContext) Waiting for threads to exit.
Oct 3 15:31:43 albury mythfrontend.real: mythfrontend[3321]: I CoreContext mythcontext.cpp:1665 (~MythContext) Exiting
Oct 3 15:47:23 albury mythfrontend.real: mythfrontend[4358]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Interrupt handler
Oct 3 15:47:23 albury mythfrontend.real: mythfrontend[4358]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Terminated handler
Oct 3 15:47:23 albury mythfrontend.real: mythfrontend[4358]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Segmentation fault handler
Oct 3 15:47:23 albury mythfrontend.real: mythfrontend[4358]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Aborted handler
Oct 3 15:47:23 albury mythfrontend.real: mythfrontend[4358]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Bus error handler
Oct 3 15:47:23 albury mythfrontend.real: mythfrontend[4358]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Floating point exception handler
Oct 3 15:47:23 albury mythfrontend.real: mythfrontend[4358]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Illegal instruction handler
Oct 3 15:47:23 albury mythfrontend.real: mythfrontend[4358]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Real-time signal 0 handler
Oct 3 15:47:23 albury mythfrontend.real: mythfrontend[4358]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup User defined signal 1 handler
Oct 3 15:47:23 albury mythfrontend.real: mythfrontend[4358]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup User defined signal 2 handler
Oct 3 15:47:23 albury mythfrontend.real: mythfrontend[4358]: I thread_unknown signalhandling.cpp:191 (SetHandlerPrivate) Setup Hangup handler
Oct 3 15:47:23 albury mythfrontend.real: mythfrontend[4358]: C thread_unknown mythcommandlineparser.cpp:2602 (ConfigureLogging) mythfrontend version: fixes/31 [v31.0-v31.0] www.mythtv.org
Oct 3 15:47:23 albury mythfrontend.real: mythfrontend[4358]: C thread_unknown mythcommandlineparser.cpp:2606 (ConfigureLogging) Qt version: compile: 5.12.5, runtime: 5.12.8
Oct 3 15:47:23 albury mythfrontend.real: mythfrontend[4358]: I thread_unknown mythcommandlineparser.cpp:2608 (ConfigureLogging) Linux Mint 20.2 (x86_64)
Oct 3 15:47:23 albury mythfrontend.real: mythfrontend[4358]: N thread_unknown mythcommandlineparser.cpp:2610 (ConfigureLogging) Enabled verbose msgs: general
Oct 3 15:47:23 albury mythfrontend.real: mythfrontend[4358]: N thread_unknown logging.cpp:724 (logStart) Setting Log Level to LOG_INFO
Oct 3 15:47:23 albury mythfrontend.real: mythfrontend[4358]: I thread_unknown mythuihelper.cpp:905 (ParseGeometryOverride) MythUIHelper: Overriding GUI size: width=1280 height=940
Oct 3 15:47:23 albury mythfrontend.real: mythfrontend[4358]: I Logger logging.cpp:280 (run) Added logging to the console
Oct 3 15:47:23 albury mythfrontend.real: mythfrontend[4358]: N thread_unknown mythdirs.cpp:203 (InitializeMythDirs) Using runtime prefix = /usr
Oct 3 15:47:23 albury mythfrontend.real: mythfrontend[4358]: N thread_unknown mythdirs.cpp:204 (InitializeMythDirs) Using configuration directory = /home/alan/.mythtv
Oct 3 15:47:23 albury mythfrontend.real: mythfrontend[4358]: I CoreContext mythcorecontext.cpp:284 (Init) Assumed character encoding: en_GB.UTF-8
Oct 3 15:47:23 albury mythfrontend.real: mythfrontend[4358]: W CoreContext mythcorecontext.cpp:288 (Init) This application expects to be running a locale that specifies a UTF-8 codeset, and many features may behave improperly with your current language settings. Please set the LC_ALL or LC_CTYPE variable(s) in the environment in which this program is executed to include a UTF-8 codeset (such as 'en_US.UTF-8').
Oct 3 15:47:23 albury mythfrontend.real: mythfrontend[4358]: N CoreContext mythcommandlineparser.cpp:2639 (ApplySettingsOverride) Setting 'RunFrontendInWindow' being forced to '1'
Oct 3 15:47:23 albury mythfrontend.real: mythfrontend[4358]: I CoreContext mythtranslation.cpp:62 (load) Loading en_gb translation for module mythfrontend
Oct 3 15:47:23 albury mythfrontend.real: mythfrontend[4358]: I LogForward loggingserver.cpp:248 (SyslogLogger) Added syslogging
Oct 3 15:47:23 albury mythfrontend.real: mythfrontend[4358]: I CoreContext mythcontext.cpp:636 (LoadDatabaseSettings) Using a profile name of: 'albury.asandco' (Usually the same as this host's name.)
Oct 3 15:47:23 albury mythfrontend.real: mythfrontend[4358]: I CoreContext mythcontext.cpp:885 (TestDBconnection) Start up testing connections. DB 192.168.1.4, BE , attempt 0, status dbAwake, Delay: 2000
Oct 3 15:47:24 albury mythfrontend.real: mythfrontend[4358]: I CoreContext mythcontext.cpp:885 (TestDBconnection) Start up testing connections. DB 192.168.1.4, BE , attempt 1, status dbAwake, Delay: 2000
Oct 3 15:47:29 albury mythfrontend.real: mythfrontend[4358]: I CoreContext mythcontext.cpp:885 (TestDBconnection) Start up testing connections. DB 192.168.1.4, BE , attempt 2, status dbAwake, Delay: 2000
Oct 3 15:47:29 albury mythfrontend.real: mythfrontend[4358]: I CoreContext mythdisplay.cpp:367 (GetDesiredScreen) Display: Defaulting to primary screen (VGA-0)
Oct 3 15:47:29 albury mythfrontend.real: mythfrontend[4358]: I CoreContext mythdisplay.cpp:476 (DebugScreen) Display: Using screen 'VGA-0' (Make: Rogen Tech Distribution Inc Model: B 101740)
Oct 3 15:47:29 albury mythfrontend.real: mythfrontend[4358]: I CoreContext mythdisplay.cpp:479 (DebugScreen) Display: Geometry: 1280x1024+1280+0 Size(Qt): 376mmx301mm
Oct 3 15:47:29 albury mythfrontend.real: mythfrontend[4358]: I CoreContext mythdisplay.cpp:486 (DebugScreen) Display: Total virtual geometry: 2560x1024+0+0
Oct 3 15:47:29 albury mythfrontend.real: mythfrontend[4358]: N CoreContext mythdisplay.cpp:505 (Initialise) Display: Desktop video mode: 1280x1024 60.020Hz
Oct 3 15:47:29 albury mythfrontend.real: mythfrontend[4358]: N CoreContext mythdisplay.cpp:512 (Initialise) Display: Display has custom colourspace
Oct 3 15:47:29 albury mythfrontend.real: mythfrontend[4358]: I CoreContext screensaver-dbus.cpp:61 (ScreenSaverDBusPrivate) ScreenSaverDBus: Created for DBus service: org.freedesktop.ScreenSaver
Oct 3 15:47:29 albury mythfrontend.real: mythfrontend[4358]: I CoreContext screensaver-dbus.cpp:61 (ScreenSaverDBusPrivate) ScreenSaverDBus: Created for DBus service: org.gnome.SessionManager
Oct 3 15:47:29 albury mythfrontend.real: mythfrontend[4358]: I SystemManager mythsystemunix.cpp:262 (run) Starting process manager
Oct 3 15:47:29 albury mythfrontend.real: mythfrontend[4358]: I SystemSignalManager mythsystemunix.cpp:488 (run) Starting process signal handler
Oct 3 15:47:29 albury mythfrontend.real: mythfrontend[4358]: I SystemIOHandlerW mythsystemunix.cpp:82 (run) Starting IO manager (write)
Oct 3 15:47:29 albury mythfrontend.real: mythfrontend[4358]: I SystemIOHandlerR mythsystemunix.cpp:82 (run) Starting IO manager (read)
Oct 3 15:47:29 albury mythfrontend.real: mythfrontend[4358]: I CoreContext screensaver-x11.cpp:76 (ScreenSaverX11Private) ScreenSaverX11Private: DPMS is active.
Oct 3 15:47:29 albury mythfrontend.real: mythfrontend[4358]: 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
Oct 3 15:47:29 albury mythfrontend.real: mythfrontend[4358]: W CoreContext mythuihelper.cpp:993 (FindThemeDir) MythUIHelper: No theme dir: '/usr/share/mythtv/themes/Mythbuntu'
Oct 3 15:47:29 albury mythfrontend.real: mythfrontend[4358]: W CoreContext mythuihelper.cpp:1012 (FindThemeDir) MythUIHelper: No default theme dir: '/usr/share/mythtv/themes/Mythbuntu'
Oct 3 15:47:29 albury mythfrontend.real: mythfrontend[4358]: E CoreContext mythuihelper.cpp:1020 (FindThemeDir) MythUIHelper: Could not find theme: Mythbuntu - Switching to MythCenter-wide
Oct 3 15:47:29 albury mythfrontend.real: mythfrontend[4358]: E CoreContext lirc.cpp:199 (Init) LIRC: Failed to connect to Unix socket '/var/run/lirc/lircd'#012#011#011#011eno: No such file or directory (2)
Oct 3 15:47:29 albury mythfrontend.real: mythfrontend[4358]: I CoreContext jsmenu.cpp:140 (ReadConfig) No joystick configuration found, not enabling joystick control
Oct 3 15:47:29 albury mythfrontend.real: mythfrontend[4358]: I CoreContext mythudplistener.cpp:32 (Enable) UDPListener: Enabling
Oct 3 15:47:29 albury mythfrontend.real: mythfrontend[4358]: I CoreContext serverpool.cpp:542 (bind) Binding to UDP 0.0.0.0:0
Oct 3 15:47:29 albury mythfrontend.real: mythfrontend[4358]: I CoreContext serverpool.cpp:542 (bind) Binding to UDP [::]:0
Oct 3 15:47:29 albury mythfrontend.real: mythfrontend[4358]: I CoreContext mythdisplay.cpp:227 (SetWidget) Display: Have main widget
Oct 3 15:47:29 albury mythfrontend.real: mythfrontend[4358]: I CoreContext mythmainwindow.cpp:1057 (Init) UI Screen Resolution: 1280 x 940
Oct 3 15:47:29 albury mythfrontend.real: mythfrontend[4358]: I CoreContext mythdisplay.cpp:231 (SetWidget) Display: Have main window
Oct 3 15:47:29 albury mythfrontend.real: mythfrontend[4358]: I CoreContext mythdisplay.cpp:367 (GetDesiredScreen) Display: Defaulting to primary screen (VGA-0)
Oct 3 15:47:29 albury mythfrontend.real: mythfrontend[4358]: I CoreContext opengl/mythrenderopengl.cpp:421 (DebugFeatures) OpenGL: OpenGL vendor : X.Org
Oct 3 15:47:29 albury mythfrontend.real: mythfrontend[4358]: I CoreContext opengl/mythrenderopengl.cpp:422 (DebugFeatures) OpenGL: OpenGL renderer : AMD RV710 (DRM 2.50.0 / 5.4.0-88-generic, LLVM 12.0.0)
Oct 3 15:47:29 albury mythfrontend.real: mythfrontend[4358]: I CoreContext opengl/mythrenderopengl.cpp:423 (DebugFeatures) OpenGL: OpenGL version : 3.0 Mesa 21.0.3
Oct 3 15:47:29 albury mythfrontend.real: mythfrontend[4358]: I CoreContext opengl/mythrenderopengl.cpp:424 (DebugFeatures) OpenGL: Qt platform : xcb
Oct 3 15:47:29 albury mythfrontend.real: mythfrontend[4358]: I CoreContext opengl/mythrenderopengl.cpp:427 (DebugFeatures) OpenGL: EGL display : Yes
Oct 3 15:47:29 albury mythfrontend.real: mythfrontend[4358]: I CoreContext opengl/mythrenderopengl.cpp:428 (DebugFeatures) OpenGL: EGL images : Yes
Oct 3 15:47:29 albury mythfrontend.real: mythfrontend[4358]: I CoreContext opengl/mythrenderopengl.cpp:430 (DebugFeatures) OpenGL: Qt OpenGL format : OpenGL 3.0
Oct 3 15:47:29 albury mythfrontend.real: mythfrontend[4358]: I CoreContext opengl/mythrenderopengl.cpp:431 (DebugFeatures) OpenGL: Qt OpenGL surface : RGBA: 8880 Depth: 0 Stencil: 0
Oct 3 15:47:29 albury mythfrontend.real: mythfrontend[4358]: I CoreContext opengl/mythrenderopengl.cpp:432 (DebugFeatures) OpenGL: Max texture size : 8192
Oct 3 15:47:29 albury mythfrontend.real: mythfrontend[4358]: I CoreContext opengl/mythrenderopengl.cpp:433 (DebugFeatures) OpenGL: Max texture units : 48
Oct 3 15:47:29 albury mythfrontend.real: mythfrontend[4358]: I CoreContext opengl/mythrenderopengl.cpp:434 (DebugFeatures) OpenGL: Shaders : Yes
Oct 3 15:47:29 albury mythfrontend.real: mythfrontend[4358]: I CoreContext opengl/mythrenderopengl.cpp:435 (DebugFeatures) OpenGL: NPOT textures : Yes
Oct 3 15:47:29 albury mythfrontend.real: mythfrontend[4358]: I CoreContext opengl/mythrenderopengl.cpp:436 (DebugFeatures) OpenGL: Multitexturing : Yes
Oct 3 15:47:29 albury mythfrontend.real: mythfrontend[4358]: I CoreContext opengl/mythrenderopengl.cpp:437 (DebugFeatures) OpenGL: Rectangular textures : Yes
Oct 3 15:47:29 albury mythfrontend.real: mythfrontend[4358]: I CoreContext opengl/mythrenderopengl.cpp:439 (DebugFeatures) OpenGL: Buffer mapping : Yes
Oct 3 15:47:29 albury mythfrontend.real: mythfrontend[4358]: I CoreContext opengl/mythrenderopengl.cpp:440 (DebugFeatures) OpenGL: Framebuffer objects : Yes
Oct 3 15:47:29 albury mythfrontend.real: mythfrontend[4358]: I CoreContext opengl/mythrenderopengl.cpp:441 (DebugFeatures) OpenGL: 16bit framebuffers : Yes
Oct 3 15:47:29 albury mythfrontend.real: mythfrontend[4358]: I CoreContext opengl/mythrenderopengl.cpp:442 (DebugFeatures) OpenGL: Unpack Subimage : Yes
Oct 3 15:47:29 albury mythfrontend.real: mythfrontend[4358]: I CoreContext opengl/mythrenderopengl.cpp:443 (DebugFeatures) OpenGL: GL_RED/GL_R8 : Yes
Oct 3 15:47:29 albury mythfrontend.real: mythfrontend[4358]: I CoreContext opengl/mythrenderopengl.cpp:398 (Init) OpenGL: Initialised MythRenderOpenGL
Oct 3 15:47:29 albury mythfrontend.real: mythfrontend[4358]: I CoreContext opengl/mythrenderopengl.cpp:399 (Init) OpenGL: Using full range output
Oct 3 15:47:29 albury mythfrontend.real: mythfrontend[4358]: I CoreContext mythuihelper.cpp:762 (PruneCacheDir) MythUIHelper: Pruning cache directory: /home/alan/.mythtv/cache/remotecache
Oct 3 15:47:29 albury mythfrontend.real: mythfrontend[4358]: I CoreContext mythuihelper.cpp:819 (PruneCacheDir) MythUIHelper: Kept 27 files, deleted 0 files, stat error on 0 files
Oct 3 15:47:29 albury mythfrontend.real: mythfrontend[4358]: I CoreContext mythuihelper.cpp:762 (PruneCacheDir) MythUIHelper: Pruning cache directory: /home/alan/.mythtv/cache/thumbnails
Oct 3 15:47:29 albury mythfrontend.real: mythfrontend[4358]: I CoreContext mythuihelper.cpp:819 (PruneCacheDir) MythUIHelper: Kept 68 files, deleted 0 files, stat error on 0 files
Oct 3 15:47:29 albury mythfrontend.real: mythfrontend[4358]: E CoreContext devices/mythcecadapter.cpp:173 (Open) CECAdapter: Failed to load libcec.
Oct 3 15:47:29 albury mythfrontend.real: mythfrontend[4358]: I CoreContext mythdisplay.cpp:476 (DebugScreen) Display: Changed to screen 'VGA-1-1' (Make: Rogen Tech Distribution Inc Model: B101710-)
Oct 3 15:47:29 albury mythfrontend.real: mythfrontend[4358]: I CoreContext mythdisplay.cpp:479 (DebugScreen) Display: Geometry: 1280x1024+0+0 Size(Qt): 338mmx270mm
Oct 3 15:47:29 albury mythfrontend.real: mythfrontend[4358]: I CoreContext mythdisplay.cpp:486 (DebugScreen) Display: Total virtual geometry: 2560x1024+0+0
Oct 3 15:47:29 albury mythfrontend.real: mythfrontend[4358]: W CoreContext mythedid.cpp:228 (ParseBaseBlock) EDID: Chromaticity mismatch!
Oct 3 15:47:29 albury mythfrontend.real: mythfrontend[4358]: N CoreContext mythdisplay.cpp:505 (Initialise) Display: Desktop video mode: 1280x1024 60.020Hz
Oct 3 15:47:29 albury mythfrontend.real: mythfrontend[4358]: N CoreContext mythdisplay.cpp:510 (Initialise) Display: Display is using sRGB colourspace
Oct 3 15:47:34 albury mythfrontend.real: mythfrontend[4358]: I CoreContext mythcontext.cpp:885 (TestDBconnection) Start up testing connections. DB 192.168.1.4, BE , attempt 3, status dbAwake, Delay: 2000
Oct 3 15:47:36 albury mythfrontend.real: mythfrontend[4358]: I CoreContext mythcontext.cpp:1008 (TestDBconnection) Start up failure. host 192.168.1.4, status dbAwakeFail
Oct 3 15:47:36 albury mythfrontend.real: mythfrontend[4358]: E CoreContext mythdbcon.cpp:235 (OpenDatabase) [DBManager0] Unable to connect to database!
Oct 3 15:47:36 albury mythfrontend.real: mythfrontend[4358]: E CoreContext mythdbcon.cpp:236 (OpenDatabase) Driver error was [1/2003]:#012QMYSQL: Unable to connect#012Database error was:#012Can't connect to MySQL server on '192.168.1.4:3306' (111)
Oct 3 15:47:46 albury mythfrontend.real: mythfrontend[4358]: I CoreContext mythcontext.cpp:885 (TestDBconnection) Start up testing connections. DB 192.168.1.4, BE , attempt 0, status dbAwake, Delay: 2000
Oct 3 15:47:47 albury mythfrontend.real: mythfrontend[4358]: I CoreContext mythcontext.cpp:885 (TestDBconnection) Start up testing connections. DB 192.168.1.4, BE , attempt 1, status dbAwake, Delay: 2000
Oct 3 15:47:52 albury mythfrontend.real: mythfrontend[4358]: I CoreContext mythcontext.cpp:885 (TestDBconnection) Start up testing connections. DB 192.168.1.4, BE , attempt 2, status dbAwake, Delay: 2000
Oct 3 15:47:58 albury mythfrontend.real: mythfrontend[4358]: I CoreContext mythcontext.cpp:1008 (TestDBconnection) Start up failure. host 192.168.1.4, status dbAwakeFail
Oct 3 15:47:58 albury mythfrontend.real: mythfrontend[4358]: A CoreContext mythcontext.cpp:502 (FindDatabase) Cannot login to database
Oct 3 15:47:58 albury mythfrontend.real: mythfrontend[4358]: E CoreContext main.cpp:1921 (main) Failed to init MythContext, exiting.
Oct 3 15:47:58 albury mythfrontend.real: mythfrontend[4358]: W CoreContext mythpainter.cpp:35 (Teardown) MythPainter: 80 images not yet de-allocated.
Oct 3 15:47:58 albury mythfrontend.real: mythfrontend[4358]: I CoreContext opengl/mythpainteropengl.cpp:74 (ClearCache) Clearing OpenGL painter cache.
Oct 3 15:47:58 albury mythfrontend.real: mythfrontend[4358]: I CoreContext opengl/mythrenderopengl.cpp:147 (~MythRenderOpenGL) OpenGL: MythRenderOpenGL closing
Oct 3 15:47:58 albury mythfrontend.real: mythfrontend[4358]: I CoreContext AirPlay/mythraopdevice.cpp:71 (Cleanup) RAOP Device: Cleaning up.
Oct 3 15:47:58 albury mythfrontend.real: mythfrontend[4358]: I CoreContext AirPlay/mythairplayserver.cpp:393 (Cleanup) AirPlay: Cleaning up.
Oct 3 15:47:58 albury mythfrontend.real: mythfrontend[4358]: I CoreContext mythcontext.cpp:1659 (~MythContext) Waiting for threads to exit.
Oct 3 15:47:58 albury mythfrontend.real: mythfrontend[4358]: I CoreContext mythcontext.cpp:1665 (~MythContext) Exiting
Apologies for my verbosity
blm-ubunet
Senior
Posts: 265
Joined: Sun Jun 15, 2014 1:08 am
Cambodia

Re: Trouble restoring database to a new machine

Post by blm-ubunet »

You must start with db server..
- is it running
- is it mysql or mariadb
- is it listening on localhost or IP addr
- what credentials can connect

systemctl status mysql.service

mysql -umythtv -p -hlocalhost mythconverg
mysql -umythtv -p -h192.168.1.4 mythconverg

Be aware mythtv-setup can be run as frontend user but may not be able to control tuners etc.. better to run mythtv-setup as user "mythtv".
Be extra aware that diff users use different config.xml files with a fallback to /etc/somewhere?
pinnerite
Senior
Posts: 256
Joined: Mon Apr 07, 2014 2:34 pm
Great Britain

Re: Trouble restoring database to a new machine

Post by pinnerite »

It is running mysql
I cannot answer the last two points. I am sorry. I am out of depth with MySQL.

$ systemctl status mysql.service

returned:
$ systemctl status mysql.service
● mysql.service - MySQL Community Server
Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
Active: active (running) since Mon 2021-10-04 11:13:17 BST; 3h 20min ago
Process: 919 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCE>
Main PID: 1207 (mysqld)
Status: "Server is operational"
Tasks: 38 (limit: 19027)
Memory: 421.6M
CGroup: /system.slice/mysql.service
└─1207 /usr/sbin/mysqld

Oct 04 11:12:57 albury.asandco systemd[1]: Starting MySQL Community Server...
Oct 04 11:13:17 albury.asandco systemd[1]: Started MySQL Community Server.

$ mysql -umythtv -p -hlocalhost mythconverg

regardless of password or none returned:
ERROR 1045 (28000): Access denied for user 'mythtv'@'localhost' (using password: YES)
same with 'mythtv'@l'192.168.1.4'

Thanks for your help by the way.
pinnerite
Senior
Posts: 256
Joined: Mon Apr 07, 2014 2:34 pm
Great Britain

Re: Trouble restoring database to a new machine

Post by pinnerite »

I have since run mc.sql with the result that
$ mysql -umythtv -p -hlocalhost mythconverg with password mythtv now gets me to the MySQL prompt.

I ran an edited version of the same, substituting 192.168.1.4 for localhost but without success.
User avatar
bill6502
Developer
Posts: 2307
Joined: Fri Feb 07, 2014 5:28 pm
United States of America

Re: Trouble restoring database to a new machine

Post by bill6502 »

Please check the output of the command above. See if the error exactly the same.

Guessing here that /etc/mysql/mysql.conf.d/mysql.cnf wasn't created or
bind-address=:: wasn't set, meaning that only localhost works, by design.
Never ever modify the /etc/mysql/mysql.cnf file because it can (and has)
been overwritten by the SQL package manager.

Also, /etc/mythtv/config.xml isn't a backup, it should be a file that ~mythtv/.mythtv/config.xml
and ~/.mythtv/config.xml have symbolic links to (shortcuts in the Windows world). That's a
standard for *buntu distributions and gets setup automatically. If files were copied 'on top'
of the links, then they get used. The new password may still be in the /etc/mythtv/config.xml
file.

Lastly, for a backend or combination frontend/backend, the config.xml file should use
localhost. That way, a socket will be used to talk to the SQL server rather than a TCP
connection. Not the end of the world if it isn't, it's just more efficient.
pinnerite
Senior
Posts: 256
Joined: Mon Apr 07, 2014 2:34 pm
Great Britain

Re: Trouble restoring database to a new machine

Post by pinnerite »

Thank you.

I choose to use a specific address rather than localhost is that there is more then one frontend accessing the backend.

I made a few changes:

1) <LocalHostName> in ~/.mythtv/config.xml was changed to 192.168.1.4
2) bin-address=:: in /etc/mysql/conf.d/mythtv.cnf was enabled

And it all works. Thank you so much.
User avatar
bill6502
Developer
Posts: 2307
Joined: Fri Feb 07, 2014 5:28 pm
United States of America

Re: Trouble restoring database to a new machine

Post by bill6502 »

That's OK, but the .xml files on the backend and remote frontend are intended to
be different. As above, use localhost on the combined BE/FE and the IP or hostname
on the remote one.

LocalHostName is normally not used. The boxes hostname is the default and it acts
as a profile ID in the settings (and other) tables.
Post Reply