<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:1230843658;
mso-list-type:hybrid;
mso-list-template-ids:-1958605100 -1 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;}
@list l0:level1
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level2
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level3
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l0:level4
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level5
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level6
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l0:level7
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level8
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level9
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
--></style></head><body lang=EN-US link=blue vlink="#954F72" style='word-wrap:break-word'><div class=WordSection1><p class=MsoNormal>Everyone, thanks for your help. I have figured out my issues. Here is a summary.</p><p class=MsoNormal><o:p> </o:p></p><ol style='margin-top:0in' start=1 type=1><li class=MsoListParagraph style='margin-left:0in;mso-list:l0 level1 lfo1'>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</li><li class=MsoListParagraph style='margin-left:0in;mso-list:l0 level1 lfo1'>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.</li></ol><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Thanks again for everyone’s help!</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>tony<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><div style='mso-element:para-border-div;border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal style='border:none;padding:0in'><b>From: </b><a href="mailto:rramesh2400@gmail.com">Ram Ramesh</a><br><b>Sent: </b>Tuesday, December 21, 2021 11:13 AM<br><b>To: </b><a href="mailto:mythtv-users@mythtv.org">Discussion about MythTV</a>; <a href="mailto:tonyg@guadagno.org">Tony Guadagno</a><br><b>Subject: </b>Re: [mythtv-users] SchedulesDirect PW changed.....how do i update my grabber</p></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>On 12/21/21 9:59 AM, Tony Guadagno wrote:</p><p class=MsoNormal>><o:p> </o:p></p><p class=MsoNormal>> Not sure what is wrong at this point….i decided to start from </p><p class=MsoNormal>> scratch….i removed all copies of the db. And ran this(as mythtv </p><p class=MsoNormal>> user)… and I get the error…I have checked and the perms are correct on </p><p class=MsoNormal>> the directory and file….a new empty db gets created but it seems it </p><p class=MsoNormal>> cannot insert into it</p><p class=MsoNormal>><o:p> </o:p></p><p class=MsoNormal>> $ tv_grab_zz_sdjson_sqlite --manage-lineups --config-file </p><p class=MsoNormal>> $HOME/.mythtv/SchedulesDirect.xmltv</p><p class=MsoNormal>><o:p> </o:p></p><p class=MsoNormal>> Enter your username at Schedules Direct: tguadagno</p><p class=MsoNormal>><o:p> </o:p></p><p class=MsoNormal>> Enter your password for user at Schedules Direct:</p><p class=MsoNormal>><o:p> </o:p></p><p class=MsoNormal>> Your Schedules Direct account has the following lineups configured:</p><p class=MsoNormal>><o:p> </o:p></p><p class=MsoNormal>> Lineup ID Description</p><p class=MsoNormal>><o:p> </o:p></p><p class=MsoNormal>> ======================================================================</p><p class=MsoNormal>><o:p> </o:p></p><p class=MsoNormal>> USA-OTA-14548 Local Over the Air Broadcast (Antenna 14548)</p><p class=MsoNormal>><o:p> </o:p></p><p class=MsoNormal>> Specify a Schedules Direct account lineup management action</p><p class=MsoNormal>><o:p> </o:p></p><p class=MsoNormal>> 0: Exit lineup management</p><p class=MsoNormal>><o:p> </o:p></p><p class=MsoNormal>> 1: Add an additional lineup to your account</p><p class=MsoNormal>><o:p> </o:p></p><p class=MsoNormal>> 2: Delete an existing lineup from your account</p><p class=MsoNormal>><o:p> </o:p></p><p class=MsoNormal>> 3: Display your password hash</p><p class=MsoNormal>><o:p> </o:p></p><p class=MsoNormal>> 4: Delete any password hash stored in the database</p><p class=MsoNormal>><o:p> </o:p></p><p class=MsoNormal>> 5: Initialize/update the local database</p><p class=MsoNormal>><o:p> </o:p></p><p class=MsoNormal>> 6: Manage database lineup channel selection</p><p class=MsoNormal>><o:p> </o:p></p><p class=MsoNormal>> Select one: [0,1,2,3,4,5,6 (default=0)] 5</p><p class=MsoNormal>><o:p> </o:p></p><p class=MsoNormal>> Enter your database[/home/mythtv/.xmltv/SchedulesDirect.DB]:</p><p class=MsoNormal>><o:p> </o:p></p><p class=MsoNormal>> Initializing database /home/mythtv/.xmltv/SchedulesDirect.DB</p><p class=MsoNormal>><o:p> </o:p></p><p class=MsoNormal>> Unable to create settings table in database </p><p class=MsoNormal>> /home/mythtv/.xmltv/SchedulesDirect.DB: attempt to write a readonly </p><p class=MsoNormal>> database</p><p class=MsoNormal>><o:p> </o:p></p><p class=MsoNormal>> Tony</p><p class=MsoNormal>><o:p> </o:p></p><p class=MsoNormal>> *From: *Bill Meek <mailto:keemllib@gmail.com></p><p class=MsoNormal>> *Sent: *Tuesday, December 21, 2021 10:54 AM</p><p class=MsoNormal>> *To: *mythtv-users@mythtv.org <mailto:mythtv-users@mythtv.org></p><p class=MsoNormal>> *Subject: *Re: [mythtv-users] SchedulesDirect PW changed.....how do i </p><p class=MsoNormal>> update my grabber</p><p class=MsoNormal>><o:p> </o:p></p><p class=MsoNormal>> On 12/21/21 9:29 AM, Tony Guadagno wrote:</p><p class=MsoNormal>><o:p> </o:p></p><p class=MsoNormal>> > $ tv_grab_zz_sdjson_sqlite --manage-lineups --config-file </p><p class=MsoNormal>> $HOME/.mythtv/SchedulesDirect.xmltv</p><p class=MsoNormal>><o:p> </o:p></p><p class=MsoNormal>> ></p><p class=MsoNormal>><o:p> </o:p></p><p class=MsoNormal>> > Unexpected error when executing statement (replace into settings </p><p class=MsoNormal>> (tag, value) values (?, ?)): attempt to write a readonly database</p><p class=MsoNormal>><o:p> </o:p></p><p class=MsoNormal>> The config-file should have a database= line and that file needs write </p><p class=MsoNormal>> permission.</p><p class=MsoNormal>><o:p> </o:p></p><p class=MsoNormal>> I'm guessing that $HOME = /home/mythtv, not your user's $HOME (since </p><p class=MsoNormal>> you said</p><p class=MsoNormal>><o:p> </o:p></p><p class=MsoNormal>> you logged in at mythtv). I've seen folks with 2 copies if </p><p class=MsoNormal>> SchedulesDirect.DB.</p><p class=MsoNormal>><o:p> </o:p></p><p class=MsoNormal>> One left over from setup as a non mythtv user.</p><p class=MsoNormal>><o:p> </o:p></p><p class=MsoNormal>> -- </p><p class=MsoNormal>><o:p> </o:p></p><p class=MsoNormal>> Bill</p><p class=MsoNormal>><o:p> </o:p></p><p class=MsoNormal>> _______________________________________________</p><p class=MsoNormal>><o:p> </o:p></p><p class=MsoNormal>> mythtv-users mailing list</p><p class=MsoNormal>><o:p> </o:p></p><p class=MsoNormal>> mythtv-users@mythtv.org</p><p class=MsoNormal>><o:p> </o:p></p><p class=MsoNormal>> http://lists.mythtv.org/mailman/listinfo/mythtv-users</p><p class=MsoNormal>><o:p> </o:p></p><p class=MsoNormal>> http://wiki.mythtv.org/Mailing_List_etiquette</p><p class=MsoNormal>><o:p> </o:p></p><p class=MsoNormal>> MythTV Forums: https://forum.mythtv.org</p><p class=MsoNormal>><o:p> </o:p></p><p class=MsoNormal>><o:p> </o:p></p><p class=MsoNormal>> _______________________________________________</p><p class=MsoNormal>> mythtv-users mailing list</p><p class=MsoNormal>> mythtv-users@mythtv.org</p><p class=MsoNormal>> http://lists.mythtv.org/mailman/listinfo/mythtv-users</p><p class=MsoNormal>> http://wiki.mythtv.org/Mailing_List_etiquette</p><p class=MsoNormal>> MythTV Forums: https://forum.mythtv.org</p><p class=MsoNormal>In my home directory (as well as ~mythtv) I see this file </p><p class=MsoNormal>.mythtv/OTA-xxxx.xmltv. This file contains my schedulesdirect username </p><p class=MsoNormal>and password in plain English. Hope you have something similar and easy </p><p class=MsoNormal>to change the password.</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>You need it in both places if you want to run mythfilldatabase from both </p><p class=MsoNormal>accounts. Otherwise you just need it in the relevant place.</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Regards</p><p class=MsoNormal>Ramesh</p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p></div></body></html>