<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p><br>
</p>
<p><br>
</p>
<p> </p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">Hi Stephen!</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<pre class="western"><font color="#000000">sudo systemctl restart mythtv-backend</font>
<font color="#000000">That just went back to the terminal prompt immediately.? (I'm thinking </font>
<font color="#000000">there should be at least a little delay while the command processes.)</font>
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</pre>
<dl>
<dd>
<table width="623" cellspacing="0" cellpadding="4">
<colgroup><col width="613"> </colgroup><tbody>
<tr>
<td style="border: 1px solid #000000; padding: 0.04in"
width="613" valign="top">
<p>I thought that return-to-prompt was too quick, which
is why I mentioned something.</p>
<p><br>
</p>
<p>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.</p>
<p><br>
</p>
<p>The status command summary is the Backend failed to
start. </p>
</td>
</tr>
</tbody>
</table>
</dd>
</dl>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<pre class="western">less /var/log/mythtv/mythbackend.log</pre>
<p style="margin-bottom: 0in; line-height: 100%">
<br>
</p>
<dl>
<dd>
<table width="626" cellspacing="0" cellpadding="4">
<colgroup><col width="616"> </colgroup><tbody>
<tr>
<td style="border: 1px solid #000000; padding: 0.04in"
width="616" valign="top">
<p>The last portion of the log starting with the last
hit of “version:” – looks like repeats/retries above
that point.</p>
<p><br>
</p>
<p><br>
</p>
<p><font face="DejaVu Sans Mono, monospace"><font
style="font-size: 10pt" size="2">May 26 09:01:32
Backend-3 mythbackend: mythbackend[1913]: C
thread_unknown mythcommandlineparser.cpp:2607
(ConfigureLogging) mythbackend version: [v30.0]
<a class="moz-txt-link-abbreviated" href="http://www.mythtv.org">www.mythtv.org</a></font></font></p>
<p><font face="DejaVu Sans Mono, monospace"><font
style="font-size: 10pt" size="2">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</font></font></p>
<p><font face="DejaVu Sans Mono, monospace"><font
style="font-size: 10pt" size="2">May 26 09:01:32
Backend-3 mythbackend: mythbackend[1913]: N
thread_unknown mythcommandlineparser.cpp:2611
(ConfigureLogging) Enabled verbose msgs: general</font></font></p>
<p><font face="DejaVu Sans Mono, monospace"><font
style="font-size: 10pt" size="2">May 26 09:01:32
Backend-3 mythbackend: mythbackend[1913]: N
thread_unknown logging.cpp:734 (logStart) Setting
Log Level to LOG_INFO</font></font></p>
<p><font face="DejaVu Sans Mono, monospace"><font
style="font-size: 10pt" size="2">May 26 09:01:32
Backend-3 mythbackend: mythbackend[1913]: I Logger
logging.cpp:296 (run) Added logging to the console</font></font></p>
<p><font face="DejaVu Sans Mono, monospace"><font
style="font-size: 10pt" size="2">May 26 09:01:32
Backend-3 mythbackend: mythbackend[1913]: I
thread_unknown signalhandling.cpp:194
(SetHandlerPrivate) Setup Interrupt handler</font></font></p>
<p><font face="DejaVu Sans Mono, monospace"><font
style="font-size: 10pt" size="2">May 26 09:01:32
Backend-3 mythbackend: mythbackend[1913]: I
thread_unknown signalhandling.cpp:194
(SetHandlerPrivate) Setup Terminated handler</font></font></p>
<p><font face="DejaVu Sans Mono, monospace"><font
style="font-size: 10pt" size="2">May 26 09:01:32
Backend-3 mythbackend: mythbackend[1913]: I
thread_unknown signalhandling.cpp:194
(SetHandlerPrivate) Setup Segmentation fault
handler</font></font></p>
<p><font face="DejaVu Sans Mono, monospace"><font
style="font-size: 10pt" size="2">May 26 09:01:32
Backend-3 mythbackend: mythbackend[1913]: I
thread_unknown signalhandling.cpp:194
(SetHandlerPrivate) Setup Aborted handler</font></font></p>
<p><font face="DejaVu Sans Mono, monospace"><font
style="font-size: 10pt" size="2">May 26 09:01:32
Backend-3 mythbackend: mythbackend[1913]: I
thread_unknown signalhandling.cpp:194
(SetHandlerPrivate) Setup Bus error handler</font></font></p>
<p><font face="DejaVu Sans Mono, monospace"><font
style="font-size: 10pt" size="2">May 26 09:01:32
Backend-3 mythbackend: mythbackend[1913]: I
thread_unknown signalhandling.cpp:194
(SetHandlerPrivate) Setup Floating point exception
handler</font></font></p>
<p><font face="DejaVu Sans Mono, monospace"><font
style="font-size: 10pt" size="2">May 26 09:01:32
Backend-3 mythbackend: mythbackend[1913]: I
thread_unknown signalhandling.cpp:194
(SetHandlerPrivate) Setup Illegal instruction
handler</font></font></p>
<p><font face="DejaVu Sans Mono, monospace"><font
style="font-size: 10pt" size="2">May 26 09:01:32
Backend-3 mythbackend: mythbackend[1913]: I
thread_unknown signalhandling.cpp:194
(SetHandlerPrivate) Setup Real-time signal 0
handler</font></font></p>
<p><font face="DejaVu Sans Mono, monospace"><font
style="font-size: 10pt" size="2">May 26 09:01:32
Backend-3 mythbackend: mythbackend[1913]: I
LogForward loggingserver.cpp:246 (SyslogLogger)
Added syslogging</font></font></p>
<p><font face="DejaVu Sans Mono, monospace"><font
style="font-size: 10pt" size="2">May 26 09:01:32
Backend-3 mythbackend: mythbackend[1913]: I
thread_unknown signalhandling.cpp:194
(SetHandlerPrivate) Setup Hangup handler</font></font></p>
<p><font face="DejaVu Sans Mono, monospace"><font
style="font-size: 10pt" size="2">May 26 09:01:32
Backend-3 mythbackend: mythbackend[1913]: N
thread_unknown mythdirs.cpp:203
(InitializeMythDirs) Using runtime prefix = /usr</font></font></p>
<p><font face="DejaVu Sans Mono, monospace"><font
style="font-size: 10pt" size="2">May 26 09:01:32
Backend-3 mythbackend: mythbackend[1913]: N
thread_unknown mythdirs.cpp:205
(InitializeMythDirs) Using configuration directory
= /home/mythtv/.mythtv</font></font></p>
<p><font face="DejaVu Sans Mono, monospace"><font
style="font-size: 10pt" size="2">May 26 09:01:32
Backend-3 mythbackend: mythbackend[1913]: I
CoreContext mythcorecontext.cpp:272 (Init) Assumed
character encoding: en_US.UTF-8</font></font></p>
<p><font face="DejaVu Sans Mono, monospace"><font
style="font-size: 10pt" size="2">May 26 09:01:32
Backend-3 mythbackend: mythbackend[1913]: I
CoreContext mythcontext.cpp:641
(LoadDatabaseSettings) Empty LocalHostName. This
is typical.</font></font></p>
<p><font face="DejaVu Sans Mono, monospace"><font
style="font-size: 10pt" size="2">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.)</font></font></p>
<p><font face="DejaVu Sans Mono, monospace"><font
style="font-size: 10pt" size="2">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</font></font></p>
<p><font face="DejaVu Sans Mono, monospace"><font
style="font-size: 10pt" size="2">May 26 09:01:33
Backend-3 mythbackend: mythbackend[1913]: N
CoreContext mythcorecontext.cpp:1780 (InitLocale)
Setting QT default locale to en_US</font></font></p>
<p><font face="DejaVu Sans Mono, monospace"><font
style="font-size: 10pt" size="2">May 26 09:01:33
Backend-3 mythbackend: mythbackend[1913]: I
CoreContext mythcorecontext.cpp:1813
(SaveLocaleDefaults) Current locale en_US</font></font></p>
<p><font face="DejaVu Sans Mono, monospace"><font
style="font-size: 10pt" size="2">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</font></font></p>
<p><font face="DejaVu Sans Mono, monospace"><font
style="font-size: 10pt" size="2">May 26 09:01:33
Backend-3 mythbackend: mythbackend[1913]: E
CoreContext mythdb.cpp:284 (SaveSettingOnHost)
SaveSettingOnHost('Country') - No database yet</font></font></p>
<p><font face="DejaVu Sans Mono, monospace"><font
style="font-size: 10pt" size="2">May 26 09:01:33
Backend-3 mythbackend: mythbackend[1913]: E
CoreContext mythdb.cpp:284 (SaveSettingOnHost)
SaveSettingOnHost('FreqTable') - No database yet</font></font></p>
<p><font face="DejaVu Sans Mono, monospace"><font
style="font-size: 10pt" size="2">May 26 09:01:33
Backend-3 mythbackend: mythbackend[1913]: E
CoreContext mythdb.cpp:284 (SaveSettingOnHost)
SaveSettingOnHost('ISO639Language0') - No database
yet</font></font></p>
<p><font face="DejaVu Sans Mono, monospace"><font
style="font-size: 10pt" size="2">May 26 09:01:33
Backend-3 mythbackend: mythbackend[1913]: E
CoreContext mythdb.cpp:284 (SaveSettingOnHost)
SaveSettingOnHost('ISO639Language1') - No database
yet</font></font></p>
<p><font face="DejaVu Sans Mono, monospace"><font
style="font-size: 10pt" size="2">May 26 09:01:33
Backend-3 mythbackend: mythbackend[1913]: E
CoreContext mythdb.cpp:284 (SaveSettingOnHost)
SaveSettingOnHost('Language') - No database yet</font></font></p>
<p><font face="DejaVu Sans Mono, monospace"><font
style="font-size: 10pt" size="2">May 26 09:01:33
Backend-3 mythbackend: mythbackend[1913]: E
CoreContext mythdb.cpp:284 (SaveSettingOnHost)
SaveSettingOnHost('TVFormat') - No database yet</font></font></p>
<p><font face="DejaVu Sans Mono, monospace"><font
style="font-size: 10pt" size="2">May 26 09:01:33
Backend-3 mythbackend: mythbackend[1913]: E
CoreContext mythdb.cpp:284 (SaveSettingOnHost)
SaveSettingOnHost('VbiFormat') - No database yet</font></font></p>
<p><font face="DejaVu Sans Mono, monospace"><font
style="font-size: 10pt" size="2">May 26 09:01:33
Backend-3 mythbackend: mythbackend[1913]: E
CoreContext mythdb.cpp:284 (SaveSettingOnHost)
SaveSettingOnHost('DateFormat') - No database yet</font></font></p>
<p><font face="DejaVu Sans Mono, monospace"><font
style="font-size: 10pt" size="2">May 26 09:01:33
Backend-3 mythbackend: mythbackend[1913]: E
CoreContext mythdb.cpp:284 (SaveSettingOnHost)
SaveSettingOnHost('MythArchiveDateFormat') - No
database yet</font></font></p>
<p><font face="DejaVu Sans Mono, monospace"><font
style="font-size: 10pt" size="2">May 26 09:01:33
Backend-3 mythbackend: mythbackend[1913]: E
CoreContext mythdb.cpp:284 (SaveSettingOnHost)
SaveSettingOnHost('MythArchiveTimeFormat') - No
database yet</font></font></p>
<p><font face="DejaVu Sans Mono, monospace"><font
style="font-size: 10pt" size="2">May 26 09:01:33
Backend-3 mythbackend: mythbackend[1913]: E
CoreContext mythdb.cpp:284 (SaveSettingOnHost)
SaveSettingOnHost('MythArchiveVideoFormat') - No
database yet</font></font></p>
<p><font face="DejaVu Sans Mono, monospace"><font
style="font-size: 10pt" size="2">May 26 09:01:33
Backend-3 mythbackend: mythbackend[1913]: E
CoreContext mythdb.cpp:284 (SaveSettingOnHost)
SaveSettingOnHost('ShortDateFormat') - No database
yet</font></font></p>
<p><font face="DejaVu Sans Mono, monospace"><font
style="font-size: 10pt" size="2">May 26 09:01:33
Backend-3 mythbackend: mythbackend[1913]: E
CoreContext mythdb.cpp:284 (SaveSettingOnHost)
SaveSettingOnHost('TimeFormat') - No database yet</font></font></p>
<p><font face="DejaVu Sans Mono, monospace"><font
style="font-size: 10pt" size="2">May 26 09:01:33
Backend-3 mythbackend: mythbackend[1913]: I
CoreContext mythtranslation.cpp:64 (load) Loading
en_us translation for module mythfrontend</font></font></p>
<p><font face="DejaVu Sans Mono, monospace"><font
style="font-size: 10pt" size="2">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.</font></font></p>
<p><font face="DejaVu Sans Mono, monospace"><font
style="font-size: 10pt" size="2">~</font></font></p>
<p><font face="DejaVu Sans Mono, monospace"><font
style="font-size: 10pt" size="2">~</font></font></p>
<p><br>
</p>
<p>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 <font
face="DejaVu Sans Mono, monospace"><font
style="font-size: 9pt" size="2">sudo chown
root:mythtv /usr/local/bin/do_mythconverg.sh</font></font>
– I will do that correction when get to that step –
I’m trying not to confuse myself too much (more!) so
doing in sequence.</p>
</td>
</tr>
</tbody>
</table>
</dd>
</dl>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<pre class="western">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</pre>
<dl>
<dd>
<table width="627" cellspacing="0" cellpadding="4">
<colgroup><col width="617"> </colgroup><tbody>
<tr>
<td style="border: 1px solid #000000; padding: 0.04in"
width="617" valign="top">
<p>Ah! That will help! The Terminal windows just closed
too fast! ...There were advantages to the old XTs and
their 8088 processors! <joke></p>
<p><br>
</p>
<p>And just realized the ownership correction was in the
message Im working on...</p>
</td>
</tr>
</tbody>
</table>
</dd>
</dl>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<pre class="western">sudo chown root:mythtv /usr/local/bin/do_mythconverg.sh</pre>
<dl>
<dd>
<table width="627" cellspacing="0" cellpadding="4">
<colgroup><col width="617"> </colgroup><tbody>
<tr>
<td style="border: 1px solid #000000; padding: 0.04in"
width="617" valign="top">
<p>Hopefully will correct what I suspected as
permissions error; will check after doing <a
href="https://www.mythtv.org/wiki/MySQL_Time_Zone_Tables">https://www.mythtv.org/wiki/MySQL_Time_Zone_Tables</a></p>
</td>
</tr>
</tbody>
</table>
</dd>
</dl>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<dl>
<dd>
<table width="624" cellspacing="0" cellpadding="4">
<colgroup><col width="614"> </colgroup><tbody>
<tr>
<td style="border: 1px solid #000000; padding: 0.04in"
width="614" valign="top">
<p><a class="moz-txt-link-freetext" href="https://www.mythtv.org/wiki/MySQL_Time_Zone_Tables">https://www.mythtv.org/wiki/MySQL_Time_Zone_Tables</a></p>
<p><br>
</p>
<p>To see if the tables are already loaded (using the
same query that mythbackend/mythtv-setup uses to check
them) start mysql. sudo mysql</p>
<p><font face="Liberation Sans Narrow, sans-serif">
Poop! MariaDB [(none)] s/b mythconverg?</font></p>
<p><font face="Liberation Sans Narrow, sans-serif">
Maybe reboot because of the permissions change.</font></p>
<p><font face="Liberation Sans Narrow, sans-serif">
Still (none)</font></p>
<p><br>
</p>
<p><br>
</p>
<p>For 0.27+, type: <font face="Liberation Sans Narrow,
sans-serif">I have v 30</font></p>
<p>SELECT CONVERT_TZ(NOW(), 'SYSTEM', 'Etc/UTC');</p>
<p><br>
</p>
<p>+----------------------------------------+</p>
<p>| CONVERT_TZ(NOW(), 'SYSTEM', 'Etc/UTC') | <font
face="Liberation Sans Narrow, sans-serif">Got this
(as expected)</font></p>
<p>+----------------------------------------+</p>
<p>| NULL |</p>
<p>+----------------------------------------+</p>
<p><br>
</p>
<p><br>
</p>
<p>Assuming the distribution's time zone information is
in /usr/share/zoneinfo, type:</p>
<p><br>
</p>
<p>mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u
root -p mysql <== command line</p>
<p> barry@Backend-3:~$ </p>
<p> barry@Backend-3:~$ mysql_tzinfo_to_sql
/usr/share/zoneinfo | mysql -u root -p mysql</p>
<p> Enter password: (B***6) (my password)</p>
<p> ERROR 1698 (28000): Access denied for user
'root'@'localhost'</p>
<p> barry@Backend-3:~$ </p>
<p><br>
</p>
<p> barry@Backend-3:~$ </p>
<p> barry@Backend-3:~$ mysql_tzinfo_to_sql
/usr/share/zoneinfo | mysql -u root -p mysql</p>
<p> Enter password: (G*****S) (mythtv password)</p>
<p> ERROR 1698 (28000): Access denied for user
'root'@'localhost'</p>
<p> barry@Backend-3:~$ </p>
<p><br>
</p>
<p> barry@Backend-3:~$ sudo mysql_tzinfo_to_sql
/usr/share/zoneinfo | mysql -u root -p mysql</p>
<p> Enter password: (B****6)</p>
<p> ERROR 1698 (28000): Access denied for user
'root'@'localhost'</p>
<p> barry@Backend-3:~$ </p>
<p><br>
</p>
<p>...Gonna be one of dose daze!</p>
</td>
</tr>
</tbody>
</table>
</dd>
</dl>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p>
<style type="text/css">td p { margin-bottom: 0in; }pre.cjk { font-family: "Courier New", monospace; }p { margin-bottom: 0.1in; line-height: 115%; }a:link { }</style></p>
</body>
</html>