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.