<div dir="ltr"><div dir="ltr"><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Mar 16, 2023 at 1:21 PM Mike Hodson <<a href="mailto:mystica@gmail.com">mystica@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">~ is homedir; if no user is provided, it is 'the current logged in user'<div>~user is homedir of user<div>~mythtv is mythtv's homedir wherever that may be, and this path is expandable as such:</div><div>echo ~mythtv<br></div><div><br></div><div>The .xmltv directory inside mythtv user's homedir should then contain a sqlite database file named SchedulesDirect.DB.</div><div><br></div><div>Mike<br></div></div><div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Mar 16, 2023 at 10:59 AM Daryl McDonald <<a href="mailto:darylangela@gmail.com" target="_blank">darylangela@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div dir="ltr"><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Mar 16, 2023 at 10:50 AM Bill Meek <<a href="mailto:keemllib@gmail.com" target="_blank">keemllib@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div><span></span>On Thursday 16
March 2023 06:36:37 AM (-05:00), Daryl McDonald wrote:<br><br><blockquote style="margin:0px 0px 0.8ex;border-left:2px solid rgb(0,0,255);padding-left:1ex"><div dir="ltr">Looks like the issue:<div>daryl@trieli:~$
tv_grab_zz_sdjson_sqlite --capabilities<br>Command
'tv_grab_zz_sdjson_sqlite' not found, but can be installed with:<br>sudo
apt install xmltv-util<br>daryl@trieli:~$ sudo apt install -y
xmltv-util</div><div><br></div><div>but after installing the xmltv-util
we're still not quite there:<br><div><br></div><div>daryl@trieli:~$ sudo su
mythtv<br>$ mythfilldatabase<br>2023-03-16 07:19:48.143231 C
mythfilldatabase version: fixes/32
[v32.0+fixes.20220325.f69ce764b7-0ubuntu1] <a href="http://www.mythtv.org" target="_blank">www.mythtv.org</a><br>2023-03-16
07:19:48.143241 C Qt version: compile: 5.15.2, runtime:
5.15.3<br>2023-03-16 07:19:48.143273 I Ubuntu 22.04.2 LTS
(x86_64)<br>2023-03-16 07:19:48.143275 N Enabled verbose msgs:
general<br>2023-03-16 07:19:48.143282 N Setting Log Level to
LOG_INFO<br>2023-03-16 07:19:48.153821 I Added logging to the
console<br>2023-03-16 07:19:48.153973 I Setup Interrupt
handler<br>2023-03-16 07:19:48.153982 I Setup Terminated
handler<br>2023-03-16 07:19:48.153986 I Setup Segmentation fault
handler<br>2023-03-16 07:19:48.153989 I Setup Aborted
handler<br>2023-03-16 07:19:48.153991 I Setup Bus error
handler<br>2023-03-16 07:19:48.153995 I Setup Floating point
exception handler<br>2023-03-16 07:19:48.153998 I Setup Illegal
instruction handler<br>2023-03-16 07:19:48.154016 I Setup Real-time
signal 0 handler<br>2023-03-16 07:19:48.154019 I Setup Hangup
handler<br>2023-03-16 07:19:48.154104 N Using runtime prefix =
/usr<br>2023-03-16 07:19:48.154106 N Using configuration directory =
/home/mythtv/.mythtv<br>2023-03-16 07:19:48.154132 I Assumed
character encoding: en_CA.UTF-8<br>2023-03-16 07:19:48.154381 I Empty
LocalHostName. This is typical.<br>2023-03-16 07:19:48.154384 I Using
a profile name of: 'trieli' (Usually the same as this host's
name.)<br>2023-03-16 07:19:48.154415 I Start up testing connections.
DB localhost, BE , attempt 0, status dbAwake, Delay: 2000<br>2023-03-16
07:19:49.192982 N Setting QT default locale to en_CA<br>2023-03-16
07:19:49.192999 I Current locale en_CA<br>2023-03-16 07:19:49.193080
N Reading locale defaults from
/usr/share/mythtv//locales/en_ca.xml<br>2023-03-16 07:19:49.245071 I
PowerDBus: Added UPower.Device
'/org/freedesktop/UPower/devices/keyboard_hidpp_battery_0'<br>2023-03-16
07:19:49.245705 I Power: On AC power<br>2023-03-16 07:19:49.248229 I
PowerDBus: Added UPower.Device
'/org/freedesktop/UPower/devices/mouse_hidpp_battery_1'<br>2023-03-16
07:19:49.293742 I Power: Supported actions:
Suspend,Restart,Shutdown<br>2023-03-16 07:19:49.295612 I Loading
en_ca translation for module mythfrontend<br>2023-03-16 07:19:49.298571 I
Current MythTV Schema Version (DBSchemaVer): 1376<br>2023-03-16
07:19:49.304452 I MythCoreContext::ConnectCommandSocket(): Connecting
to backend server: <a href="http://127.0.0.1:6543" target="_blank">127.0.0.1:6543</a> (try
1 of 1)<br>2023-03-16 07:19:49.310106 I
MythCoreContext::CheckProtoVersion(): Using protocol version 91
BuzzOff<br>2023-03-16 07:19:49.310593 I Opening blocking connection
to master backend<br>2023-03-16 07:19:49.611505 I Updating source #1
(antenna) with grabber tv_grab_zz_sdjson_sqlite<br>2023-03-16
07:19:49.612353 I Found 37 channels for source 1 which use
grabber<br>2023-03-16 07:19:49.613030 I Starting process
manager<br>2023-03-16 07:19:49.613228 I Starting IO manager
(read)<br>2023-03-16 07:19:49.613255 I Starting process signal
handler<br>2023-03-16 07:19:49.618288 I Starting IO manager
(write)<br>2023-03-16 07:19:50.415621 I Grabber has capabilities:
baseline manualconfig preferredmethod lineups apiconfig <br>2023-03-16
07:19:51.267150 I Grabber prefers method: allatonce<br>2023-03-16
07:19:51.268351 I XMLTV config file is:
/home/mythtv/.mythtv/antenna.xmltv<br>2023-03-16 07:19:52.120150 E
XMLTV grabber returned error code 1<br>2023-03-16 07:19:52.770885 E
Malformed XML file, missing </tv> element, at line 1, Premature
end of document.<br>2023-03-16 07:19:53.034614 I Updating source #8
(intenna) with grabber tv_grab_zz_sdjson_sqlite<br>2023-03-16
07:19:53.035398 I Found 36 channels for source 8 which use
grabber<br>2023-03-16 07:19:53.872718 I Grabber has capabilities:
baseline manualconfig preferredmethod lineups apiconfig <br>2023-03-16
07:19:54.674329 I Grabber prefers method: allatonce<br>2023-03-16
07:19:54.675297 I XMLTV config file is:
/home/mythtv/.mythtv/intenna.xmltv<br>2023-03-16 07:19:55.478235 E
XMLTV grabber returned error code 1<br>2023-03-16 07:19:55.977897 E
Malformed XML file, missing </tv> element, at line 1, Premature
end of document.<br>2023-03-16 07:19:56.079645 E Failed to fetch some
program info<br>2023-03-16 07:19:56.079702 I Adjusting program
database end times.<br>2023-03-16 07:19:56.080286 I 0
replacements made<br>2023-03-16 07:19:56.080289 I Marking generic
episodes.<br>2023-03-16 07:19:56.359440 I Found
0<br>2023-03-16 07:19:56.359447 I Extending non-unique programids
with multiple parts.<br>2023-03-16 07:19:56.518298 I
Found 0<br>2023-03-16 07:19:56.518304 I Fixing missing original
airdates.<br>2023-03-16 07:19:57.027359 I Found 0 with
programids<br>2023-03-16 07:19:57.028199 I Found 0
without programids<br>2023-03-16 07:19:57.028203 I Marking
repeats.<br>2023-03-16 07:19:57.056135 I Found
0<br>2023-03-16 07:19:57.056142 I Unmarking new episode rebroadcast
repeats.<br>2023-03-16 07:19:57.233117 I Found
0<br>2023-03-16 07:19:58.067377 I Marking episode first
showings.<br>2023-03-16 07:19:59.402563 I Found
43413<br>2023-03-16 07:19:59.402570 I Marking episode last
showings.<br>2023-03-16 07:20:00.743345 I Found
43331<br>2023-03-16 07:20:00.755586 I
<br>===============================================================<br>|
Attempting to contact the master backend for rescheduling. |<br>| If
the master is not running, rescheduling will happen when |<br>| the master
backend is restarted.
|<br>===============================================================<br>2023-03-16
07:20:00.756650 N mythfilldatabase run complete.<br>2023-03-16
07:20:00.756726 I PowerDBus: Closing interfaces<br>2023-03-16
07:20:00.758004 I Waiting for threads to exit.<br>2023-03-16
07:20:00.758029 I
Exiting<br>$ <br></div></div><div><br></div><div>so I did the
following from the wiki:</div><div>sudo apt update<br>sudo apt install git
make xmltv perl-doc<br># Note: xmltv gets the required perl
modules<br><br>mkdir -p build<br>cd build<br>git clone <a href="https://github.com/XMLTV/xmltv.git" target="_blank">https://github.com/XMLTV/xmltv.git</a><br>cd
xmltv<br>perl Makefile.PL<br>make<br>make test<br>sudo make
install<br></div><div><br></div><div>and the mythfilldatabase still failed.
do I need to continue in the wiki, I assumed the rest would come with the
database restore? Daryl</div></div>
</blockquote><span><div><span><br></span></div>I'd rerun mythfilldatabase -v
xmltv and see if there are any clues.</span><div><span><br></span></div><div><span>The mythconverg DB may be OK (because of lines
like: Found 37 channels for source 1 which use
grabber),</span></div><div><span>but did you
restore the SQLIte DB. The default would
be: ~mythtv/.xmltv/SchedulesDirect.DB.</span></div><div><span><br>-- <br>Bill</span></div></div>I used "<a href="http://mythconverg_restore.pl" target="_blank">mythconverg_restore.pl</a>" so, no I didn't restore the SQLite DB. Sorry, I'm not clear on what you mean by the default would be: ~mythtv/.xmltv/SchedulesDirect.DB.</blockquote></div></div></blockquote></div></blockquote><div><br></div><div>I'm not sure where to go from here:</div><div><br></div><div>Your Schedules Direct account has the following lineups configured:<br>Lineup ID Description<br>======================================================================<br>CAN-OTA-N9A7C3 Local Over the Air Broadcast (Antenna N9A7C3)<br>Specify a Schedules Direct account lineup management action<br>0: Exit lineup management<br>1: Add an additional lineup to your account<br>2: Delete an existing lineup from your account<br>3: Display your password hash<br>4: Delete any password hash stored in the database<br>5: Initialize/update the local database<br>6: Manage database lineup channel selection<br>Select one: [0,1,2,3,4,5,6 (default=0)] 5<br><br>Enter your database[/home/mythtv/.xmltv/SchedulesDirect.DB]: <br>Initializing database /home/mythtv/.xmltv/SchedulesDirect.DB<br>Unable to create settings table in database /home/mythtv/.xmltv/SchedulesDirect.DB: attempt to write a readonly database<br>$</div><div>And if I try to proceed:</div><div><br></div><div> $ tv_grab_zz_sdjson_sqlite --configure --config-file $HOME/.mythtv/antenna.xmltv<br></div>Failed to write to /home/mythtv/.mythtv/antenna.xmltv.TMP at /usr/local/share/perl/5.34.0/XMLTV/Configure.pm line 187.<br>$ <br><div> </div><div>I'm open to suggestions. TIA Daryl </div></div></div>