<div dir="ltr"><div dir="ltr"><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, Mar 17, 2023 at 3:51 PM Bill Meek <<a href="mailto:keemllib@gmail.com">keemllib@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><br>
<br>
<br>
On Friday 17 March 2023 02:34:53 PM (-05:00), Daryl McDonald wrote:<br>
<br>
> On Fri, Mar 17, 2023 at 3:25 PM Bill Meek wrote:<br>
> <br>
> > On Friday 17 March 2023 01:38:30 PM (-05:00), Daryl McDonald wrote:<br>
> ><br>
> > ...<br>
> ><br>
> > > I found the new password , edited the config.xml file, now FE connects to<br>
> > > BE but mythfilldatabase still fails:<br>
> > ><br>
> > > 2023-03-17 14:34:52.387726 E XMLTV grabber returned error code 1<br>
> > > 2023-03-17 14:34:52.887191 E Malformed XML file, missing element, at<br>
> > > line 1, Premature end of document.<br>
> ><br>
> > Run mythfilldatabase as you normally do, but add xmltv logging, like this:<br>
> ><br>
> > mythfilldatabase -v xmltv<br>
> ><br>
> > Look in the output for a line that contains this:<br>
> ><br>
> > Grabber Command: nice<br>
> ><br>
> > Cut and paste everything after nice up to --output ... . It should look<br>
> > something like this (I added the --debug switch):<br>
> ><br>
> > tv_grab_zz_sdjson_sqlite --config-file $HOME/.mythtv/antenna.xmltv<br>
> > --debug<br>
> ><br>
> > Look for clues in the output for why it's failing or paste the command and<br>
> > output<br>
> > here.<br>
> ><br>
> > --<br>
> > Bill<br>
> ><br>
> <br>
> daryl@trieli:~$ sudo su mythtv<br>
> [sudo] password for daryl:<br>
> $ mythfilldatabase -v xmltv<br>
<br>
...<br>
<br>
> 2023-03-17 15:33:28.533620 I Grabber Command: nice<br>
> tv_grab_zz_sdjson_sqlite --config-file '/home/mythtv/.mythtv/antenna.xmltv'<br>
> --output /tmp/mythpNSTyE<br>
<br>
...<br>
<br>
OK, but you have to run Grabber Command manually:<br>
<br>
tv_grab_zz_sdjson_sqlite --config-file '/home/mythtv/.mythtv/intenna.xmltv' --debug<br>
<br>
Looking for a reason for the failure there.<br>
<br>
-- <br>
Bill<br></blockquote><div><br></div><div>daryl@trieli:~$ tv_grab_zz_sdjson_sqlite --config-file '/home/mythtv/.mythtv/intenna.xmltv' --debug</div>DEBUG: Returning from SchedulesDirect::Debug with: <br>DEBUG: $VAR1 = 1;<br>Opening the local database<br>Obtaining authentication token for Schedules Direct<br>DEBUG: Entering SchedulesDirect::obtainToken with args: <br>DEBUG: $VAR1 = "darylangela";<br>DEBUG: $VAR2 = undef;<br>DEBUG: $VAR3 = "92ed9f927cf1162628e1e1a92221672e1d63aa70";<br>DEBUG: $VAR4 = undef;<br>DEBUG: Entering SchedulesDirect::_resetError<br>DEBUG: Returning from SchedulesDirect::_resetError<br>DEBUG: Entering SchedulesDirect::Username with args: <br>DEBUG: $VAR1 = "darylangela";<br>DEBUG: Entering SchedulesDirect::_resetSession<br>DEBUG: Entering SchedulesDirect::_resetError<br>DEBUG: Returning from SchedulesDirect::_resetError<br>DEBUG: Returning from SchedulesDirect::_resetSession<br>DEBUG: Returning from SchedulesDirect::Username with: <br>DEBUG: $VAR1 = "darylangela";<br>DEBUG: Entering SchedulesDirect::PasswordHash with args: <br>DEBUG: $VAR1 = "92ed9f927cf1162628e1e1a92221672e1d63aa70";<br>DEBUG: Entering SchedulesDirect::_resetSession<br>DEBUG: Entering SchedulesDirect::_resetError<br>DEBUG: Returning from SchedulesDirect::_resetError<br>DEBUG: Returning from SchedulesDirect::_resetSession<br>DEBUG: Returning from SchedulesDirect::PasswordHash with: <br>DEBUG: $VAR1 = "92ed9f927cf1162628e1e1a92221672e1d63aa70";<br>DEBUG: Entering SchedulesDirect::_resetSession<br>DEBUG: Entering SchedulesDirect::_resetError<br>DEBUG: Returning from SchedulesDirect::_resetError<br>DEBUG: Returning from SchedulesDirect::_resetSession<br>DEBUG: HTTP request:<br>DEBUG: $VAR1 = bless( {<br>DEBUG: "_headers" => bless( {}, 'HTTP::Headers' ),<br>DEBUG: "_uri" => bless( do{\(my $o = "<a href="https://json.schedulesdirect.org/20141201/token">https://json.schedulesdirect.org/20141201/token</a>")}, 'URI::https' ),<br>DEBUG: "_method" => "POST",<br>DEBUG: "_content" => "{\"username\":\"darylangela\",\"password\":\"92ed9f927cf1162628e1e1a92221672e1d63aa70\"}"<br>DEBUG: }, 'HTTP::Request' );<br>DEBUG: HTTP response:<br>DEBUG: $VAR1 = bless( {<br>DEBUG: "_headers" => bless( {<br>DEBUG: "server" => "nginx/1.18.0 (Ubuntu)",<br>DEBUG: "client-ssl-version" => "TLSv1_2",<br>DEBUG: "client-ssl-cipher" => "ECDHE-RSA-AES128-GCM-SHA256",<br>DEBUG: "client-peer" => "<a href="http://52.5.17.38:443">52.5.17.38:443</a>",<br>DEBUG: "x-xss-protection" => "1; mode=block",<br>DEBUG: "::std_case" => {<br>DEBUG: "x-content-type-options" => "X-Content-Type-Options",<br>DEBUG: "client-ssl-socket-class" => "Client-SSL-Socket-Class",<br>DEBUG: "x-xss-protection" => "X-XSS-Protection",<br>DEBUG: "client-peer" => "Client-Peer",<br>DEBUG: "client-ssl-cipher" => "Client-SSL-Cipher",<br>DEBUG: "client-ssl-version" => "Client-SSL-Version",<br>DEBUG: "client-ssl-cert-issuer" => "Client-SSL-Cert-Issuer",<br>DEBUG: "client-transfer-encoding" => "Client-Transfer-Encoding",<br>DEBUG: "client-ssl-cert-subject" => "Client-SSL-Cert-Subject",<br>DEBUG: "schedulesdirect-serverid" => "Schedulesdirect-Serverid",<br>DEBUG: "x-frame-options" => "X-Frame-Options",<br>DEBUG: "client-response-num" => "Client-Response-Num",<br>DEBUG: "client-date" => "Client-Date"<br>DEBUG: },<br>DEBUG: "content-type" => "application/json;charset=UTF-8",<br>DEBUG: "client-ssl-socket-class" => "IO::Socket::SSL",<br>DEBUG: "x-content-type-options" => "nosniff",<br>DEBUG: "date" => "Fri, 17 Mar 2023 19:55:08 GMT",<br>DEBUG: "client-response-num" => 1,<br>DEBUG: "client-date" => "Fri, 17 Mar 2023 19:55:08 GMT",<br>DEBUG: "schedulesdirect-serverid" => "20141201.web",<br>DEBUG: "x-frame-options" => "SAMEORIGIN",<br>DEBUG: "client-transfer-encoding" => [<br>DEBUG: "chunked"<br>DEBUG: ],<br>DEBUG: "client-ssl-cert-subject" => "/CN=*.<a href="http://json.schedulesdirect.org">json.schedulesdirect.org</a>",<br>DEBUG: "client-ssl-cert-issuer" => "/C=US/O=Amazon/CN=Amazon RSA 2048 M01",<br>DEBUG: "content-encoding" => "gzip",<br>DEBUG: "vary" => "Accept-Encoding",<br>DEBUG: "connection" => "keep-alive"<br>DEBUG: }, 'HTTP::Headers' ),<br>DEBUG: "_request" => bless( {<br>DEBUG: "_uri_canonical" => bless( do{\(my $o = "<a href="https://json.schedulesdirect.org/20141201/token">https://json.schedulesdirect.org/20141201/token</a>")}, 'URI::https' ),<br>DEBUG: "_headers" => bless( {<br>DEBUG: "user-agent" => "tv_grab_zz_sdjson_sqlite",<br>DEBUG: "pragma" => "no-cache",<br>DEBUG: "accept-encoding" => "gzip, x-gzip, deflate, x-bzip2, bzip2",<br>DEBUG: "accept" => "application/json",<br>DEBUG: "content-type" => "application/json",<br>DEBUG: "::std_case" => {<br>DEBUG: "if-ssl-cert-subject" => "If-SSL-Cert-Subject"<br>DEBUG: },<br>DEBUG: "cache-control" => "no-cache"<br>DEBUG: }, 'HTTP::Headers' ),<br>DEBUG: "_uri" => $VAR1->{"_request"}{"_uri_canonical"},<br>DEBUG: "_method" => "POST",<br>DEBUG: "_content" => "{\"username\":\"darylangela\",\"password\":\"92ed9f927cf1162628e1e1a92221672e1d63aa70\"}",<br>DEBUG: "_protocol" => undef<br>DEBUG: }, 'HTTP::Request' ),<br>DEBUG: "_content" => "\37\213\b\0\0\0\0\0\0\3\35\312\275\n\0021\20\4\340w\331\372N\222=C~j\e\261\260\261\262\333\$s\"r\36\\\202\26\342\273\273\330\f3|\363\241\262VP2\3-hMn\332\351|\242\201\32\266\27\266\343A7\e\273\267\32\2737\262J\225\216~_\360\27\236F3\215\326_lL\316%\23\256\372\350\353\3Oe/\22\312\234\243c\211\271\202Q\2623\2149\370\300\f\361\364\375\1\\\351j\222\200\0\0\0",<br>DEBUG: "_msg" => "OK",<br>DEBUG: "_protocol" => "HTTP/1.1",<br>DEBUG: "_rc" => 200<br>DEBUG: }, 'HTTP::Response' );<br>DEBUG: HTTP decoded response content:<br>DEBUG: $VAR1 = "{\"code\":0,\"message\":\"OK\",\"serverID\":\"20141201.web\",\"datetime\":\"2023-03-17T19:55:08Z\",\"token\":\"7aa8cfb952a9bde2ecb502ef87822ea7\"}";<br>DEBUG: Entering SchedulesDirect::Token with args: <br>DEBUG: Returning from SchedulesDirect::Token with: <br>DEBUG: $VAR1 = "7aa8cfb952a9bde2ecb502ef87822ea7 1679082907.72004";<br>DEBUG: Returning from SchedulesDirect::obtainToken with: <br>DEBUG: $VAR1 = "7aa8cfb952a9bde2ecb502ef87822ea7 1679082907.72004";<br>Unexpected error when executing statement (replace into settings (tag, value) values (?, ?)): attempt to write a readonly database<br>daryl@trieli:~$ <br><br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"> _______________________________________________<br><br>
</blockquote></div></div>