[mythtv-users] mythfilldatgabase failure

[Greg Oliver]

On Fri, Mar 17, 2023 at 10:57 AM Daryl McDonald <darylangela at gmail.com>
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/.xmltv
> ls: 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
>
>> _
>>
>
> Yeah - looks like your UID and GID numbers changed between machines.  The
old mythtv:mythtv is now gdm:lxd

chown -R mythtv:mythtv /home/mythtv

should fix it.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20230317/4ea4a012/attachment.htm>