MariaDB update broke Mythbackend

For discussion of topics specific to MythTV on linux
Post Reply
jiminorris
Junior
Posts: 23
Joined: Sun May 29, 2016 3:52 pm
Great Britain

MariaDB update broke Mythbackend

Post by jiminorris »

I'm running Myth32 on Debian testing. Recently updated mariadb and now mythbackend won't launch.

MySQL is working fine:

Code: Select all

systemctl status mysql.service
○ mariadb.service - MariaDB 10.11.2 database server
     Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; preset: enabled)
     Active: inactive (dead)
       Docs: man:mariadbd(8)
             https://mariadb.com/kb/en/library/systemd/
But Mythtv isn't having any of it.

Some filenames seem to be causing trouble, since mythbackend.service has worked for years, but now

Code: Select all

systemctl status mythbackend.service
Unit mythbackend.service could not be found.
I'm probably missing a symlink somewhere, as I do have files /etc/systemd/system/multi-user.target.wants/mythtv-backend.service and /lib/systemd/system/mythtv-backend.service where they need to be.

That said, if I use those service files with systemd if does run the service, but fails:

Code: Select all

● mythtv-backend.service - MythTV Backend
     Loaded: loaded (/lib/systemd/system/mythtv-backend.service; enabled; preset: enabled)
     Active: active (running) since Sat 2023-03-18 10:43:58 GMT; 5s ago
       Docs: https://www.mythtv.org/wiki/Mythbackend
   Main PID: 20195 (mythbackend)
      Tasks: 3 (limit: 76976)
     Memory: 13.2M
        CPU: 43ms
     CGroup: /system.slice/mythtv-backend.service
             └─20195 /usr/bin/mythbackend

Mar 18 10:43:58 localhost mythbackend[20195]: 2023-03-18 10:43:58.690155 I  Setup Illegal instruction handler
Mar 18 10:43:58 localhost mythbackend[20195]: 2023-03-18 10:43:58.690159 I  Setup Real-time signal 0 handler
Mar 18 10:43:58 localhost mythbackend[20195]: 2023-03-18 10:43:58.690162 I  Setup Hangup handler
Mar 18 10:43:58 localhost mythbackend[20195]: 2023-03-18 10:43:58.690223 N  Using runtime prefix = /usr
Mar 18 10:43:58 localhost mythbackend[20195]: 2023-03-18 10:43:58.690224 N  Using configuration directory = /var/lib/mythtv/.mythtv
Mar 18 10:43:58 localhost mythbackend[20195]: 2023-03-18 10:43:58.690236 I  Assumed character encoding: en_GB.UTF-8
Mar 18 10:43:58 localhost mythbackend[20195]: 2023-03-18 10:43:58.690374 I  Empty LocalHostName. This is typical.
Mar 18 10:43:58 localhost mythbackend[20195]: 2023-03-18 10:43:58.690376 I  Using a profile name of: 'localhost' (Usually the same as this host's name.)
Mar 18 10:43:58 localhost mythbackend[20195]: 2023-03-18 10:43:58.690398 I  Start up testing connections. DB 127.0.0.1, BE , attempt 0, status dbAwake, Delay: 2000
Mar 18 10:43:59 localhost mythbackend[20195]: 2023-03-18 10:43:59.691052 I  Start up testing connections. DB 127.0.0.1, BE , attempt 1, status dbAwake, Delay: 2000
~
~
~
so clearly it isn't reaching the database file, but since nothing has changed, I'm stuck for solutions.
User avatar
paulh
Developer
Posts: 909
Joined: Thu Feb 06, 2014 6:09 pm
Great Britain

Re: MariaDB update broke Mythbackend

Post by paulh »

Try mythtv-backend.service for the service name
white_haired_uncle
Senior
Posts: 244
Joined: Thu Feb 23, 2023 8:55 pm
Location: Safe outside my gilded cage
United States of America

Re: MariaDB update broke Mythbackend

Post by white_haired_uncle »

You said mysql is working fine, but systemd says "Active: inactive (dead)"?
jiminorris
Junior
Posts: 23
Joined: Sun May 29, 2016 3:52 pm
Great Britain

Re: MariaDB update broke Mythbackend

Post by jiminorris »

paulh wrote:
Sat Mar 18, 2023 11:50 am
Try mythtv-backend.service for the service name
Yes, sorry, that does work and the service is running, but it still doesn't seem to find the database.
white_haired_uncle wrote:
Sat Mar 18, 2023 2:14 pm
You said mysql is working fine, but systemd says "Active: inactive (dead)"?
Curious, I missed that part! Looks like it's more a mariadb issue than myth...
Post Reply