[mythtv-users] mythfilldatgabase failure

[Hika van den Hoven]

Hoi Daryl,

Friday, March 17, 2023, 4:56:03 PM, you wrote:




> On Fri, Mar 17, 2023 at 11:32 AM Bill Meek <keemllib at gmail.com> wrote:


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


> That was my initial attempt, but when mythfilldatabase failed again I went back to the wiki 
>  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



>  daryl at trieli:~$  ls -ld ~mythtv/.mythtv/*.xmltv ~mythtv/.xmltvls:
> cannot access '/home/mythtv/.mythtv/*.xmltv': No such file or directory
> drwxrwxr-x 3 gdm lxd 4096 Mar 17 10:24  /home/mythtv/.xmltv

> but :
> daryl at trieli:~$ ls -al /home/mythtv
> total 24
> drwxr-x--- 5 mythtv mythtv 4096 Mar 17 10:25 .
> drwxr-xr-x 5 root   root   4096 Mar 17 10:48 ..
> -rw-r--r-- 1 gdm    lxd     143 Mar 17 10:22 antenna.xmltv
> drwxr-xr-x 8 gdm    lxd    4096 Mar 17 10:25 .mythtv
> drwx------ 2 gdm    lxd    4096 Mar 17 10:25 .smolt
> drwxrwxr-x 3 gdm    lxd    4096 Mar 17 10:24 .xmltv

> And:
> daryl at trieli:~$ ls -ld /home/mythtv
> drwxr-x--- 5 mythtv mythtv 4096 Mar 17 10:25 /home/mythtv
> daryl at trieli:~$ 

>  
>  ~mythtv/.xmltv/SchedulesDirect.DB
>  Everything should be owner:group mythtv:mythtv.
>  
>  -- 
>  Bill




> So it looks like I'm messed up here 
>  _
>  

goto the mythtv homedirectory and type there:
sudo chown -R mythtv.mythtv *

This will change ownership for all files, directories, subdirectories,
etc. under that home directory

It is a dangerous command so make very sure you are in the right
directory


Tot mails,
  Hika                            mailto:hikavdh at gmail.com

"Zonder hoop kun je niet leven
Zonder leven is er geen hoop
Het eeuwige dilemma
Zeker als je hoop moet vernietigen om te kunnen overleven!"

De lerende Mens