mythfilldatabase runs manually, not automatically

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

Moderator: Forum Moderators

Post Reply
jddj
Newcomer
Posts: 1
Joined: Sat Jan 21, 2023 3:13 am
United States of America

mythfilldatabase runs manually, not automatically

Post by jddj »

Hi. Not a noob, been running several versions of mythtv for over a decade, have run separate backends, front-ends, PS3 front-end, NAS version, buncha stuff.

I'm running mythtv-backend v31.0 on a headless raspberry pi 4 4GB under Debian (not raspiOS), with MariaDB, and using the tv_grab_zz_sdjson grabber, and it records OK as long as there's guide information. Problem is it won't run mythfilldatabase on its own. I can run it in the shell as the mythtv user (mythtv) and get 18 days of guide data. I can log into the database as the mythtv user on localhost, but not as mythtv on MYSERVER. I think I've chased down all the places I can switch the database user to localhost, but there's apparently still something wrong.

Betting the problem is the scheduled process can't log into the database based on the log segment (from syslog) below.

Any direction as to where I need fix this would be appreciated. Is it just that I have to set up the grants for mythtv at MYSERVER?

Code: Select all

MythTV Version : v31.0
MythTV Branch : 
Network Protocol : 91
Library API : 31.20200101-1
QT Version : 5.15.2
Options compiled in:
 linux release use_hidesyms using_alsa using_jack using_oss using_pulse using_pulseoutput using_backend using_bindings_perl using_bindings_python using_bindings_php using_dvb using_firewire using_frontend using_hdhomerun using_vbox using_ceton using_hdpvr using_ivtv using_joystick_menu using_libcec using_libcrypto using_gnutls using_libdns_sd using_libfftw3 using_libxml2 using_lirc using_mheg using_opengl using_egl using_qtwebkit using_qtscript using_qtdbus using_taglib using_v4l2 using_v4l2prime using_x11 using_libbluray_external using_xrandr using_systemd_notify using_systemd_journal using_drm using_bindings_perl using_bindings_python using_bindings_php using_freetype2 using_mythtranscode using_opengl using_egl using_drm using_vdpau using_ffmpeg_threads using_mheg using_libass using_libxml2 using_libmp3lame

Code: Select all

Jan 21 02:32:03 MYSERVER mythbackend[2377]: 2023-01-21 02:32:03.447482 I  Queueing HouseKeeperTask 'MythFillDB'.
Jan 21 02:32:03 MYSERVER mythbackend[2377]: 2023-01-21 02:32:03.452935 I  New DB connection, total: 7
Jan 21 02:32:03 MYSERVER mythbackend[2377]: 2023-01-21 02:32:03.457840 I  Running HouseKeeperTask 'MythFillDB'.
Jan 21 02:32:04 MYSERVER mariadbd[685]: 2023-01-21  2:32:04 239 [Warning] Aborted connection 239 to db: 'unconnected' user: 'unauthenticated' host: 'bistromat
h.lan' (This connection closed normally without authentication)
Jan 21 02:32:04 MYSERVER mythbackend[2377]: 2023-01-21 02:32:04.508322 I  MainServer: MainServer::ANN Playback
Jan 21 02:32:04 MYSERVER mythbackend[2377]: 2023-01-21 02:32:04.508345 I  MainServer: adding: MYSERVER(aaaae8d68f20) as a client (events: 0)
Jan 21 02:32:09 MYSERVER kernel: [167014.598729] [UFW BLOCK] IN=eth0 OUT= MAC=01:00:5e:00:00:01:a0:36:bc:82:f3:d0:08:00 SRC=10.2.4.1 DST=224.0.0.1 LEN=36 TOS=
0x00 PREC=0x00 TTL=1 ID=14567 DF PROTO=2 
Jan 21 02:32:15 MYSERVER mythbackend[2377]: 2023-01-21 02:32:15.250170 I  New DB connection, total: 7
Jan 21 02:32:15 MYSERVER mythbackend[2377]: 2023-01-21 02:32:15.259887 I  Reschedule requested for MATCH 0 0 0 - MythFillDatabase
Jan 21 02:32:15 MYSERVER mythbackend[2377]: 2023-01-21 02:32:15.261169 I  MySQL reconnected successfully
Jan 21 02:32:15 MYSERVER mythbackend[2377]: 2023-01-21 02:32:15.346796 I  Playback sock(aaaae8d68f20) 'MYSERVER' disconnected
Jan 21 02:32:15 MYSERVER mythbackend[2377]: 2023-01-21 02:32:15.355889 I  Scheduled 8 items in 0.1 = 0.02 match + 0.02 check + 0.03 place
Jan 21 02:32:15 MYSERVER mythbackend[2377]: 2023-01-21 02:32:15.424759 I  HouseKeeperTask 'MythFillDB' Finished Successfully.
User avatar
bill6502
Developer
Posts: 2299
Joined: Fri Feb 07, 2014 5:28 pm
United States of America

Re: mythfilldatabase runs manually, not automatically

Post by bill6502 »

Hi,

Could be that the 'Aborted connection...' message is a red herring, unless it appears every time
mythfilldatabase is run by the backend (and no other times, Google has some clues about this.)

The Housekeeper ran mythfilldatabase in 12 seconds. Doesn't sound right. I'd restart the backend with
-v system,xmltv and see what's actually being run. Compare the directories to this:
viewtopic.php?f=36&t=3480&start=15#p19508

I'm guessing that your config.xml files for your user and the user that runs the backend (mythtv?) are
exactly the same. That's where the hostname used for DB access is defined. On a backend (with the DB
on it), the hostname should be localhost so that sockets are used rather than TCP.
Post Reply