[mythtv-users] SchedulesDirect PW changed.....how do i update my grabber

Tony Guadagno tonyg at guadagno.org
Tue Dec 21 16:32:50 UTC 2021


Everyone, thanks for your help.  I have figured out my issues.  Here is a summary.

1. Ramesh…the passwd is only in the file if you are NOT using the SQLite file…I am using SQLite so the creds are stored in the db
2. My “unable to write” issue was self inflicted.  I accidentally run tv_grab_zz_sdjson_sqlite as a non-myth user…that screwed up several things.  Most importantly, it created SchedulesDirect.DB-shm and SchedulesDirect.DB-wal that were owned by the non myth users…even though the .db had the right ownership and perms, if these others do not, then the error will be thrown.

Thanks again for everyone’s help!

tony

From: Ram Ramesh
Sent: Tuesday, December 21, 2021 11:13 AM
To: Discussion about MythTV; Tony Guadagno
Subject: Re: [mythtv-users] SchedulesDirect PW changed.....how do i update my grabber

On 12/21/21 9:59 AM, Tony Guadagno wrote:
>
> Not sure what is wrong at this point….i decided to start from 
> scratch….i removed all copies of the db.  And ran this(as mythtv 
> user)… and I get the error…I have checked and the perms are correct on 
> the directory and file….a new empty db gets created but it seems it 
> cannot insert into it
>
> $ tv_grab_zz_sdjson_sqlite --manage-lineups --config-file 
> $HOME/.mythtv/SchedulesDirect.xmltv
>
> Enter your username at Schedules Direct: tguadagno
>
> Enter your password for user at Schedules Direct:
>
> Your Schedules Direct account has the following lineups configured:
>
> Lineup ID            Description
>
> ======================================================================
>
> USA-OTA-14548        Local Over the Air Broadcast (Antenna 14548)
>
> 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
>
> Tony
>
> *From: *Bill Meek <mailto:keemllib at gmail.com>
> *Sent: *Tuesday, December 21, 2021 10:54 AM
> *To: *mythtv-users at mythtv.org <mailto:mythtv-users at mythtv.org>
> *Subject: *Re: [mythtv-users] SchedulesDirect PW changed.....how do i 
> update my grabber
>
> On 12/21/21 9:29 AM, Tony Guadagno wrote:
>
> > $ tv_grab_zz_sdjson_sqlite --manage-lineups --config-file 
> $HOME/.mythtv/SchedulesDirect.xmltv
>
> >
>
> > Unexpected error when executing statement (replace into settings 
> (tag, value) values (?, ?)): attempt to write a readonly database
>
> The config-file should have a database= line and that file needs write 
> permission.
>
> I'm guessing that $HOME = /home/mythtv, not your user's $HOME (since 
> you said
>
> you logged in at mythtv). I've seen folks with 2 copies if 
> SchedulesDirect.DB.
>
> One left over from setup as a non mythtv user.
>
> -- 
>
> Bill
>
> _______________________________________________
>
> mythtv-users mailing list
>
> mythtv-users at mythtv.org
>
> http://lists.mythtv.org/mailman/listinfo/mythtv-users
>
> http://wiki.mythtv.org/Mailing_List_etiquette
>
> MythTV Forums: https://forum.mythtv.org
>
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://lists.mythtv.org/mailman/listinfo/mythtv-users
> http://wiki.mythtv.org/Mailing_List_etiquette
> MythTV Forums: https://forum.mythtv.org
In my home directory (as well as ~mythtv) I see this file 
.mythtv/OTA-xxxx.xmltv. This file contains my schedulesdirect username 
and password in plain English.  Hope you have something similar and easy 
to change the password.

You need it in both places if you want to run mythfilldatabase from both 
accounts. Otherwise you just need it in the relevant place.

Regards
Ramesh


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20211221/f18b8956/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 7293 bytes
Desc: not available
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20211221/f18b8956/attachment.bin>


More information about the mythtv-users mailing list