[mythtv-users] mythfilldatgabase failure

Fri Mar 17 15:06:05 UTC 2023

On Thu, Mar 16, 2023 at 1:21 PM Mike Hodson <mystica at gmail.com> wrote:

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

Your Schedules Direct account has the following lineups configured:
Lineup ID            Description
======================================================================
CAN-OTA-N9A7C3       Local Over the Air Broadcast (Antenna N9A7C3)
Specify a Schedules Direct account lineup management action
0: Exit lineup management
1: Add an additional lineup to your account
2: Delete an existing lineup from your account
3: Display your password hash
4: Delete any password hash stored in the database
5: Initialize/update the local database
6: Manage database lineup channel selection
Select one: [0,1,2,3,4,5,6 (default=0)] 5

Enter your database[/home/mythtv/.xmltv/SchedulesDirect.DB]:
Initializing database /home/mythtv/.xmltv/SchedulesDirect.DB
Unable to create settings table in database
/home/mythtv/.xmltv/SchedulesDirect.DB: attempt to write a readonly database
$
And if I try to proceed:

 $ tv_grab_zz_sdjson_sqlite --configure --config-file
$HOME/.mythtv/antenna.xmltv
Failed to write to /home/mythtv/.mythtv/antenna.xmltv.TMP at
/usr/local/share/perl/5.34.0/XMLTV/Configure.pm line 187.
$

I'm open to suggestions.   TIA  Daryl
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20230317/42e869a5/attachment.htm>