[SOLVED] Can't run mythtv-setup / Database problem Arch

For discussion of topics specific to MythTV on linux
Post Reply
x_driver
Junior
Posts: 28
Joined: Tue Nov 24, 2015 9:15 pm
United States of America

[SOLVED] Can't run mythtv-setup / Database problem Arch

Post by x_driver »

System was working fine. Performed an update and now I can't seem to connect to the backend or run mythtv-setup. The code below shows an error that 'mysql_tzinfo_to_sql' is missing but I've updated and checked and it's there.

Code: Select all

[family@HTPC ~]$ mythtv-setup          
"Display: Not requesting EGL for vendor 'NVIDIA, 1.5'"
2021-07-25 14:03:07.367045 I  Setup Interrupt handler
2021-07-25 14:03:07.367056 I  Setup Terminated handler
2021-07-25 14:03:07.367058 I  Setup Segmentation fault handler
2021-07-25 14:03:07.367061 I  Setup Aborted handler
2021-07-25 14:03:07.367062 I  Setup Bus error handler
2021-07-25 14:03:07.367067 I  Setup Floating point exception handler
2021-07-25 14:03:07.367068 I  Setup Illegal instruction handler
2021-07-25 14:03:07.367071 I  Setup Real-time signal 0 handler
2021-07-25 14:03:07.367074 I  Setup Hangup handler
2021-07-25 14:03:07.367115 C  mythtv-setup version: makepkg [v31.0-159-g7037525723-dirty] www.mythtv.org
2021-07-25 14:03:07.367117 C  Qt version: compile: 5.15.2, runtime: 5.15.2
2021-07-25 14:03:07.367130 I  Arch Linux (x86_64)
2021-07-25 14:03:07.367131 N  Enabled verbose msgs:  general
2021-07-25 14:03:07.367138 N  Setting Log Level to LOG_INFO
2021-07-25 14:03:07.377494 I  Added logging to the console
2021-07-25 14:03:07.529846 N  Using runtime prefix = /usr
2021-07-25 14:03:07.529865 N  Using configuration directory = /home/family/.mythtv
2021-07-25 14:03:07.529955 I  Assumed character encoding: C
2021-07-25 14:03:07.529964 W  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, and LANG variable(s) in the environment in which this program is executed to include a UTF-8 codeset (such as 'en_US.UTF-8').
2021-07-25 14:03:07.530751 I  Loading en_us translation for module mythfrontend
2021-07-25 14:03:07.531235 I  Using a profile name of: 'HTPC' (Usually the same as this host's name.)
2021-07-25 14:03:07.531402 I  Start up testing connections. DB localhost, BE , attempt 0, status dbAwake, Delay: 2000
2021-07-25 14:03:08.546161 N  Setting QT default locale to en_US
2021-07-25 14:03:08.546185 I  Current locale en_US
2021-07-25 14:03:08.546280 N  Reading locale defaults from /usr/share/mythtv//locales/en_us.xml
2021-07-25 14:03:08.565505 I  Display: Found screen 'HDMI-0'
2021-07-25 14:03:08.565543 I  Display: Using screen 'HDMI-0' (Make: ONKYO Corporation Model: AV Receiver-)
2021-07-25 14:03:08.565569 I  Display: Qt screen pixel ratio: 1.00
2021-07-25 14:03:08.565612 I  Display: Geometry: 1920x1080+0+0 Size(Qt): 1600mmx900mm
2021-07-25 14:03:08.570261 N  Display: Desktop video mode: 1920x1080 119.879Hz
2021-07-25 14:03:08.570292 N  Display: Display is using sRGB colourspace
2021-07-25 14:03:08.594840 I  Starting process manager
2021-07-25 14:03:08.594925 I  Starting process signal handler
2021-07-25 14:03:08.594951 I  Starting IO manager (read)
2021-07-25 14:03:08.597072 I  Starting IO manager (write)
2021-07-25 14:03:08.646108 I  ScreenSaverX11Private: DPMS is active.
2021-07-25 14:03:08.744783 I  PowerDBus: Added UPower.Device '/org/freedesktop/UPower/devices/mouse_hidpp_battery_0'
2021-07-25 14:03:08.745247 I  Power: On AC power
2021-07-25 14:03:08.778971 I  Power: Supported actions: Suspend,Hibernate,Restart,Shutdown,HybridSleep
2021-07-25 14:03:08.782307 I  Loading en_us translation for module mythfrontend
2021-07-25 14:03:08.782660 E  LIRC: Failed to connect to Unix socket '/var/run/lirc/lircd'
			eno: No such file or directory (2)
2021-07-25 14:03:08.782684 I  No joystick configuration found, not enabling joystick control
2021-07-25 14:03:08.782686 I  UDPListener: Enabling
2021-07-25 14:03:08.783739 I  Binding to UDP 0.0.0.0:6948
2021-07-25 14:03:08.784307 I  Binding to UDP [::]:6948
2021-07-25 14:03:08.809777 I  Using Full Screen Window
2021-07-25 14:03:08.835837 I  Display: Have main widget
2021-07-25 14:03:08.835841 I  Display: Have main window
2021-07-25 14:03:08.836010 I  Display: Found screen 'HDMI-0'
2021-07-25 14:03:08.836332 I  UI Screen Resolution: 1920 x 1080
2021-07-25 14:03:08.976610 I  OpenGL: OpenGL vendor        : NVIDIA Corporation
2021-07-25 14:03:08.976613 I  OpenGL: OpenGL renderer      : NVIDIA GeForce GTX 970/PCIe/SSE2
2021-07-25 14:03:08.976614 I  OpenGL: OpenGL version       : 4.6.0 NVIDIA 470.57.02
2021-07-25 14:03:08.976618 I  OpenGL: Qt platform          : xcb
2021-07-25 14:03:08.976626 I  OpenGL: EGL display          : No
2021-07-25 14:03:08.976627 I  OpenGL: EGL images           : No
2021-07-25 14:03:08.976629 I  OpenGL: Qt OpenGL format     : OpenGL 4.6
2021-07-25 14:03:08.976630 I  OpenGL: Qt OpenGL surface    : RGBA: 8880 Depth: 24 Stencil: 0
2021-07-25 14:03:08.976631 I  OpenGL: Max texture size     : 16384
2021-07-25 14:03:08.976632 I  OpenGL: Max texture units    : 192
2021-07-25 14:03:08.976634 I  OpenGL: Shaders              : Yes
2021-07-25 14:03:08.976635 I  OpenGL: NPOT textures        : Yes
2021-07-25 14:03:08.976636 I  OpenGL: Multitexturing       : Yes
2021-07-25 14:03:08.976637 I  OpenGL: Rectangular textures : Yes
2021-07-25 14:03:08.976638 I  OpenGL: Buffer mapping       : Yes
2021-07-25 14:03:08.976639 I  OpenGL: Framebuffer objects  : Yes
2021-07-25 14:03:08.976640 I  OpenGL: 16bit framebuffers   : Yes
2021-07-25 14:03:08.976641 I  OpenGL: Unpack Subimage      : Yes
2021-07-25 14:03:08.976642 I  OpenGL: GL_RED/GL_R8         : Yes
2021-07-25 14:03:08.977731 I  OpenGL: Initialised MythRenderOpenGL
2021-07-25 14:03:08.977734 I  OpenGL: Using full range output
2021-07-25 14:03:08.984218 I  MythUIHelper: Pruning cache directory: /home/family/.mythtv/cache/remotecache
2021-07-25 14:03:08.984259 I  MythUIHelper: Kept 0 files, deleted 0 files, stat error on 0 files
2021-07-25 14:03:08.984263 I  MythUIHelper: Pruning cache directory: /home/family/.mythtv/cache/thumbnails
2021-07-25 14:03:08.984276 I  MythUIHelper: Kept 0 files, deleted 0 files, stat error on 0 files
2021-07-25 14:03:09.027513 I  CECAdapter: Using physical address 1.2.0.0 from EDID
2021-07-25 14:03:09.039502 E  CECAdapter: Failed to find any CEC devices.
2021-07-25 14:03:09.039563 I  CECAdapter: Closing down CEC.
2021-07-25 14:03:09.040357 E  MySQL time zone support is missing.  Please install it and try again.  See 'mysql_tzinfo_to_sql' for assistance.
2021-07-25 14:03:09.067068 W  MythPainter: 69 images not yet de-allocated.
2021-07-25 14:03:09.067099 I  Clearing OpenGL painter cache.
2021-07-25 14:03:09.067107 I  OpenGL: MythRenderOpenGL closing
2021-07-25 14:03:09.076778 I  PowerDBus: Closing interfaces
2021-07-25 14:03:09.481757 I  Exiting
I think it has something to do with the database refusing the connection. My config.xml has the appropriate password for mysql.

Code: Select all

* mariadb.service - MariaDB 10.6.3 database server
     Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
     Active: active (running) since Sun 2021-07-25 13:53:12 MST; 14min ago
       Docs: man:mariadbd(8)
             https://mariadb.com/kb/en/library/systemd/
    Process: 507 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
    Process: 513 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
    Process: 540 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
   Main PID: 521 (mariadbd)
     Status: "Taking your SQL requests now..."
      Tasks: 9 (limit: 19109)
     Memory: 99.7M
        CPU: 433ms
     CGroup: /system.slice/mariadb.service
             `-521 /usr/bin/mariadbd

Jul 25 13:53:12 HTPC mariadbd[521]: Version: '10.6.3-MariaDB'  socket: '/run/mysqld/mysqld.sock'  port: 3306  Arch Linux
Jul 25 13:53:12 HTPC systemd[1]: Started MariaDB 10.6.3 database server.
Jul 25 13:53:14 HTPC mariadbd[521]: 2021-07-25 13:53:14 3 [Warning] Aborted connection 3 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connection closed normally without authentication)
Jul 25 13:53:15 HTPC mariadbd[521]: 2021-07-25 13:53:15 6 [Warning] Aborted connection 6 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connection closed normally without authentication)
Jul 25 13:53:17 HTPC mariadbd[521]: 2021-07-25 13:53:17 9 [Warning] Aborted connection 9 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connection closed normally without authentication)
Jul 25 13:53:18 HTPC mariadbd[521]: 2021-07-25 13:53:18 12 [Warning] Aborted connection 12 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connection closed normally without authentication)
Jul 25 13:53:20 HTPC mariadbd[521]: 2021-07-25 13:53:20 15 [Warning] Aborted connection 15 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connection closed normally without authentication)
Jul 25 13:59:09 HTPC mariadbd[521]: 2021-07-25 13:59:09 18 [Warning] Aborted connection 18 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connection closed normally without authentication)
Jul 25 14:00:08 HTPC mariadbd[521]: 2021-07-25 14:00:08 21 [Warning] Aborted connection 21 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connection closed normally without authentication)
Jul 25 14:03:08 HTPC mariadbd[521]: 2021-07-25 14:03:08 24 [Warning] Aborted connection 24 to db: 'unconnected' user: 'unauthenticated' host: 'localhost' (This connection closed normally without authentication)
Last edited by x_driver on Mon Jul 26, 2021 11:12 pm, edited 1 time in total.
User avatar
bill6502
Developer
Posts: 2299
Joined: Fri Feb 07, 2014 5:28 pm
United States of America

Re: Can't run mythtv-setup / Database problem Arch

Post by bill6502 »

See this, which has a workaround: https://github.com/MythTV/mythtv/issues/373 .
x_driver
Junior
Posts: 28
Joined: Tue Nov 24, 2015 9:15 pm
United States of America

Re: [SOLVED] Can't run mythtv-setup / Database problem Arch

Post by x_driver »

Bill,

That did the trick, thx.
Post Reply