[mythtv-users] mythfilldatgabase failure

[Bill Meek]

On Friday 17 March 2023 10:06:05 AM (-05:00), Daryl McDonald wrote:

...
snip
...

 > >>>
 > >>> 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


It appears that you're running the above as  user mythtv - that's good.

But the permissions on the files and/or directories are preventing it from 
working.

I assumed you meant to copy the mythtv user files/directories from the old 
host to the new one.
If mythfilldatabase and the grabber were working there, I don't believe 
there's a need to start
configuring it from scratch like the above.

Check permissions with this:

     ls -ld ~mythtv/.mythtv/*.xmltv ~mythtv/.xmltv 
~mythtv/.xmltv/SchedulesDirect.DB
Everything should be owner:group mythtv:mythtv.

-- 
Bill