[mythtv-users] BE3 - Issues with installation and database

[Barry Martin]

Hi Stephen!


sudo systemctl restart mythtv-backend
That just went back to the terminal prompt immediately.? (I'm thinking
there should be at least a little delay while the command processes.)
Restart commands can come back to the prompt pretty rapidly depending
on what program you are restarting.  Mythbackend is not normally that
fast, so it is probably not running.  As usual, to see the status of
mythbackend, do:

sudo systemctl status mythtv-backend

    I thought that return-to-prompt was too quick, which is why I
    mentioned something.


    Just rebooted to start completely – I had unplugged the other
    Backend from the network ‘for safety’ but forgot to plug in the
    Ethernet cable for this one.


    The status command summary is the Backend failed to start.


less /var/log/mythtv/mythbackend.log


    The last portion of the log starting with the last hit of “version:”
    – looks like repeats/retries above that point.



    May 26 09:01:32 Backend-3 mythbackend: mythbackend[1913]: C
    thread_unknown mythcommandlineparser.cpp:2607 (ConfigureLogging)
    mythbackend version: [v30.0] www.mythtv.org

    May 26 09:01:32 Backend-3 mythbackend: mythbackend[1913]: C
    thread_unknown mythcommandlineparser.cpp:2609 (ConfigureLogging) Qt
    version: compile: 5.9.5, runtime: 5.9.5

    May 26 09:01:32 Backend-3 mythbackend: mythbackend[1913]: N
    thread_unknown mythcommandlineparser.cpp:2611 (ConfigureLogging)
    Enabled verbose msgs: general

    May 26 09:01:32 Backend-3 mythbackend: mythbackend[1913]: N
    thread_unknown logging.cpp:734 (logStart) Setting Log Level to LOG_INFO

    May 26 09:01:32 Backend-3 mythbackend: mythbackend[1913]: I Logger
    logging.cpp:296 (run) Added logging to the console

    May 26 09:01:32 Backend-3 mythbackend: mythbackend[1913]: I
    thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup
    Interrupt handler

    May 26 09:01:32 Backend-3 mythbackend: mythbackend[1913]: I
    thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup
    Terminated handler

    May 26 09:01:32 Backend-3 mythbackend: mythbackend[1913]: I
    thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup
    Segmentation fault handler

    May 26 09:01:32 Backend-3 mythbackend: mythbackend[1913]: I
    thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup
    Aborted handler

    May 26 09:01:32 Backend-3 mythbackend: mythbackend[1913]: I
    thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup Bus
    error handler

    May 26 09:01:32 Backend-3 mythbackend: mythbackend[1913]: I
    thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup
    Floating point exception handler

    May 26 09:01:32 Backend-3 mythbackend: mythbackend[1913]: I
    thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup
    Illegal instruction handler

    May 26 09:01:32 Backend-3 mythbackend: mythbackend[1913]: I
    thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup
    Real-time signal 0 handler

    May 26 09:01:32 Backend-3 mythbackend: mythbackend[1913]: I
    LogForward loggingserver.cpp:246 (SyslogLogger) Added syslogging

    May 26 09:01:32 Backend-3 mythbackend: mythbackend[1913]: I
    thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup
    Hangup handler

    May 26 09:01:32 Backend-3 mythbackend: mythbackend[1913]: N
    thread_unknown mythdirs.cpp:203 (InitializeMythDirs) Using runtime
    prefix = /usr

    May 26 09:01:32 Backend-3 mythbackend: mythbackend[1913]: N
    thread_unknown mythdirs.cpp:205 (InitializeMythDirs) Using
    configuration directory = /home/mythtv/.mythtv

    May 26 09:01:32 Backend-3 mythbackend: mythbackend[1913]: I
    CoreContext mythcorecontext.cpp:272 (Init) Assumed character
    encoding: en_US.UTF-8

    May 26 09:01:32 Backend-3 mythbackend: mythbackend[1913]: I
    CoreContext mythcontext.cpp:641 (LoadDatabaseSettings) Empty
    LocalHostName. This is typical.

    May 26 09:01:32 Backend-3 mythbackend: mythbackend[1913]: I
    CoreContext mythcontext.cpp:650 (LoadDatabaseSettings) Using a
    profile name of: 'Backend-3' (Usually the same as this host's name.)

    May 26 09:01:32 Backend-3 mythbackend: mythbackend[1913]: I
    CoreContext mythcontext.cpp:900 (TestDBconnection) Start up testing
    connections. DB 192.168.0.3, BE , attempt 0, status dbAwake, Delay: 2000

    May 26 09:01:33 Backend-3 mythbackend: mythbackend[1913]: N
    CoreContext mythcorecontext.cpp:1780 (InitLocale) Setting QT default
    locale to en_US

    May 26 09:01:33 Backend-3 mythbackend: mythbackend[1913]: I
    CoreContext mythcorecontext.cpp:1813 (SaveLocaleDefaults) Current
    locale en_US

    May 26 09:01:33 Backend-3 mythbackend: mythbackend[1913]: N
    CoreContext mythlocale.cpp:123 (LoadDefaultsFromXML) Reading locale
    defaults from /usr/share/mythtv//locales/en_us.xml

    May 26 09:01:33 Backend-3 mythbackend: mythbackend[1913]: E
    CoreContext mythdb.cpp:284 (SaveSettingOnHost)
    SaveSettingOnHost('Country') - No database yet

    May 26 09:01:33 Backend-3 mythbackend: mythbackend[1913]: E
    CoreContext mythdb.cpp:284 (SaveSettingOnHost)
    SaveSettingOnHost('FreqTable') - No database yet

    May 26 09:01:33 Backend-3 mythbackend: mythbackend[1913]: E
    CoreContext mythdb.cpp:284 (SaveSettingOnHost)
    SaveSettingOnHost('ISO639Language0') - No database yet

    May 26 09:01:33 Backend-3 mythbackend: mythbackend[1913]: E
    CoreContext mythdb.cpp:284 (SaveSettingOnHost)
    SaveSettingOnHost('ISO639Language1') - No database yet

    May 26 09:01:33 Backend-3 mythbackend: mythbackend[1913]: E
    CoreContext mythdb.cpp:284 (SaveSettingOnHost)
    SaveSettingOnHost('Language') - No database yet

    May 26 09:01:33 Backend-3 mythbackend: mythbackend[1913]: E
    CoreContext mythdb.cpp:284 (SaveSettingOnHost)
    SaveSettingOnHost('TVFormat') - No database yet

    May 26 09:01:33 Backend-3 mythbackend: mythbackend[1913]: E
    CoreContext mythdb.cpp:284 (SaveSettingOnHost)
    SaveSettingOnHost('VbiFormat') - No database yet

    May 26 09:01:33 Backend-3 mythbackend: mythbackend[1913]: E
    CoreContext mythdb.cpp:284 (SaveSettingOnHost)
    SaveSettingOnHost('DateFormat') - No database yet

    May 26 09:01:33 Backend-3 mythbackend: mythbackend[1913]: E
    CoreContext mythdb.cpp:284 (SaveSettingOnHost)
    SaveSettingOnHost('MythArchiveDateFormat') - No database yet

    May 26 09:01:33 Backend-3 mythbackend: mythbackend[1913]: E
    CoreContext mythdb.cpp:284 (SaveSettingOnHost)
    SaveSettingOnHost('MythArchiveTimeFormat') - No database yet

    May 26 09:01:33 Backend-3 mythbackend: mythbackend[1913]: E
    CoreContext mythdb.cpp:284 (SaveSettingOnHost)
    SaveSettingOnHost('MythArchiveVideoFormat') - No database yet

    May 26 09:01:33 Backend-3 mythbackend: mythbackend[1913]: E
    CoreContext mythdb.cpp:284 (SaveSettingOnHost)
    SaveSettingOnHost('ShortDateFormat') - No database yet

    May 26 09:01:33 Backend-3 mythbackend: mythbackend[1913]: E
    CoreContext mythdb.cpp:284 (SaveSettingOnHost)
    SaveSettingOnHost('TimeFormat') - No database yet

    May 26 09:01:33 Backend-3 mythbackend: mythbackend[1913]: I
    CoreContext mythtranslation.cpp:64 (load) Loading en_us translation
    for module mythfrontend

    May 26 09:01:33 Backend-3 mythbackend: mythbackend[1913]: E
    CoreContext main_helpers.cpp:566 (run_backend) MySQL time zone
    support is missing. Please install it and try again. See
    'mysql_tzinfo_to_sql' for assistance.

    ~

    ~


    So looks like the Backend isn’t finding the database but that might
    because because of that permissions guess I made, which seems to be
    verified by your later message re: ownership (should be corrected to
    sudo chown root:mythtv /usr/local/bin/do_mythconverg.sh – I will do
    that correction when get to that step – I’m trying not to confuse
    myself too much (more!) so doing in sequence.


Or you can run mythtv-setup in a way that gets it to send the output
to a file:

mythtv-setup 2>&1 | tee mythtv-setup.log

    Ah! That will help! The Terminal windows just closed too fast!
    ...There were advantages to the old XTs and their 8088 processors!
    <joke>


    And just realized the ownership correction was in the message Im
    working on...


sudo chown root:mythtv /usr/local/bin/do_mythconverg.sh

    Hopefully will correct what I suspected as permissions error; will
    check after doing https://www.mythtv.org/wiki/MySQL_Time_Zone_Tables



    https://www.mythtv.org/wiki/MySQL_Time_Zone_Tables


    To see if the tables are already loaded (using the same query that
    mythbackend/mythtv-setup uses to check them) start mysql. sudo mysql

    Poop! MariaDB [(none)] s/b mythconverg?

    Maybe reboot because of the permissions change.

    Still (none)



    For 0.27+, type: I have v 30

    SELECT CONVERT_TZ(NOW(), 'SYSTEM', 'Etc/UTC');


    +----------------------------------------+

    | CONVERT_TZ(NOW(), 'SYSTEM', 'Etc/UTC') | Got this (as expected)

    +----------------------------------------+

    | NULL |

    +----------------------------------------+



    Assuming the distribution's time zone information is in
    /usr/share/zoneinfo, type:


    mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql <==
    command line

    barry at Backend-3:~$

    barry at Backend-3:~$ mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql
    -u root -p mysql

    Enter password: (B***6) (my password)

    ERROR 1698 (28000): Access denied for user 'root'@'localhost'

    barry at Backend-3:~$


    barry at Backend-3:~$

    barry at Backend-3:~$ mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql
    -u root -p mysql

    Enter password: (G*****S) (mythtv password)

    ERROR 1698 (28000): Access denied for user 'root'@'localhost'

    barry at Backend-3:~$


    barry at Backend-3:~$ sudo mysql_tzinfo_to_sql /usr/share/zoneinfo |
    mysql -u root -p mysql

    Enter password: (B****6)

    ERROR 1698 (28000): Access denied for user 'root'@'localhost'

    barry at Backend-3:~$


    ...Gonna be one of dose daze!



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20190526/de4f1a2e/attachment.html>