[mythtv-users] mythfilldatgabase failure
Daryl McDonald
darylangela at gmail.com
Fri Mar 17 19:56:41 UTC 2023
On Fri, Mar 17, 2023 at 3:51 PM Bill Meek <keemllib at gmail.com> wrote:
>
>
>
> On Friday 17 March 2023 02:34:53 PM (-05:00), Daryl McDonald wrote:
>
> > On Fri, Mar 17, 2023 at 3:25 PM Bill Meek wrote:
> >
> > > On Friday 17 March 2023 01:38:30 PM (-05:00), Daryl McDonald wrote:
> > >
> > > ...
> > >
> > > > I found the new password , edited the config.xml file, now FE
> connects to
> > > > BE but mythfilldatabase still fails:
> > > >
> > > > 2023-03-17 14:34:52.387726 E XMLTV grabber returned error code 1
> > > > 2023-03-17 14:34:52.887191 E Malformed XML file, missing element, at
> > > > line 1, Premature end of document.
> > >
> > > Run mythfilldatabase as you normally do, but add xmltv logging, like
> this:
> > >
> > > mythfilldatabase -v xmltv
> > >
> > > Look in the output for a line that contains this:
> > >
> > > Grabber Command: nice
> > >
> > > Cut and paste everything after nice up to --output ... . It should look
> > > something like this (I added the --debug switch):
> > >
> > > tv_grab_zz_sdjson_sqlite --config-file $HOME/.mythtv/antenna.xmltv
> > > --debug
> > >
> > > Look for clues in the output for why it's failing or paste the command
> and
> > > output
> > > here.
> > >
> > > --
> > > Bill
> > >
> >
> > daryl at trieli:~$ sudo su mythtv
> > [sudo] password for daryl:
> > $ mythfilldatabase -v xmltv
>
> ...
>
> > 2023-03-17 15:33:28.533620 I Grabber Command: nice
> > tv_grab_zz_sdjson_sqlite --config-file
> '/home/mythtv/.mythtv/antenna.xmltv'
> > --output /tmp/mythpNSTyE
>
> ...
>
> OK, but you have to run Grabber Command manually:
>
> tv_grab_zz_sdjson_sqlite --config-file
> '/home/mythtv/.mythtv/intenna.xmltv' --debug
>
> Looking for a reason for the failure there.
>
> --
> Bill
>
daryl at trieli:~$ tv_grab_zz_sdjson_sqlite --config-file
'/home/mythtv/.mythtv/intenna.xmltv' --debug
DEBUG: Returning from SchedulesDirect::Debug with:
DEBUG: $VAR1 = 1;
Opening the local database
Obtaining authentication token for Schedules Direct
DEBUG: Entering SchedulesDirect::obtainToken with args:
DEBUG: $VAR1 = "darylangela";
DEBUG: $VAR2 = undef;
DEBUG: $VAR3 = "92ed9f927cf1162628e1e1a92221672e1d63aa70";
DEBUG: $VAR4 = undef;
DEBUG: Entering SchedulesDirect::_resetError
DEBUG: Returning from SchedulesDirect::_resetError
DEBUG: Entering SchedulesDirect::Username with args:
DEBUG: $VAR1 = "darylangela";
DEBUG: Entering SchedulesDirect::_resetSession
DEBUG: Entering SchedulesDirect::_resetError
DEBUG: Returning from SchedulesDirect::_resetError
DEBUG: Returning from SchedulesDirect::_resetSession
DEBUG: Returning from SchedulesDirect::Username with:
DEBUG: $VAR1 = "darylangela";
DEBUG: Entering SchedulesDirect::PasswordHash with args:
DEBUG: $VAR1 = "92ed9f927cf1162628e1e1a92221672e1d63aa70";
DEBUG: Entering SchedulesDirect::_resetSession
DEBUG: Entering SchedulesDirect::_resetError
DEBUG: Returning from SchedulesDirect::_resetError
DEBUG: Returning from SchedulesDirect::_resetSession
DEBUG: Returning from SchedulesDirect::PasswordHash with:
DEBUG: $VAR1 = "92ed9f927cf1162628e1e1a92221672e1d63aa70";
DEBUG: Entering SchedulesDirect::_resetSession
DEBUG: Entering SchedulesDirect::_resetError
DEBUG: Returning from SchedulesDirect::_resetError
DEBUG: Returning from SchedulesDirect::_resetSession
DEBUG: HTTP request:
DEBUG: $VAR1 = bless( {
DEBUG: "_headers" => bless( {}, 'HTTP::Headers' ),
DEBUG: "_uri" => bless( do{\(my $o = "
https://json.schedulesdirect.org/20141201/token")}, 'URI::https' ),
DEBUG: "_method" => "POST",
DEBUG: "_content" =>
"{\"username\":\"darylangela\",\"password\":\"92ed9f927cf1162628e1e1a92221672e1d63aa70\"}"
DEBUG: }, 'HTTP::Request' );
DEBUG: HTTP response:
DEBUG: $VAR1 = bless( {
DEBUG: "_headers" => bless( {
DEBUG: "server" => "nginx/1.18.0
(Ubuntu)",
DEBUG: "client-ssl-version" =>
"TLSv1_2",
DEBUG: "client-ssl-cipher" =>
"ECDHE-RSA-AES128-GCM-SHA256",
DEBUG: "client-peer" => "
52.5.17.38:443",
DEBUG: "x-xss-protection" => "1;
mode=block",
DEBUG: "::std_case" => {
DEBUG:
"x-content-type-options" => "X-Content-Type-Options",
DEBUG:
"client-ssl-socket-class" => "Client-SSL-Socket-Class",
DEBUG:
"x-xss-protection" => "X-XSS-Protection",
DEBUG:
"client-peer" => "Client-Peer",
DEBUG:
"client-ssl-cipher" => "Client-SSL-Cipher",
DEBUG:
"client-ssl-version" => "Client-SSL-Version",
DEBUG:
"client-ssl-cert-issuer" => "Client-SSL-Cert-Issuer",
DEBUG:
"client-transfer-encoding" => "Client-Transfer-Encoding",
DEBUG:
"client-ssl-cert-subject" => "Client-SSL-Cert-Subject",
DEBUG:
"schedulesdirect-serverid" => "Schedulesdirect-Serverid",
DEBUG:
"x-frame-options" => "X-Frame-Options",
DEBUG:
"client-response-num" => "Client-Response-Num",
DEBUG:
"client-date" => "Client-Date"
DEBUG: },
DEBUG: "content-type" =>
"application/json;charset=UTF-8",
DEBUG: "client-ssl-socket-class"
=> "IO::Socket::SSL",
DEBUG: "x-content-type-options"
=> "nosniff",
DEBUG: "date" => "Fri, 17 Mar
2023 19:55:08 GMT",
DEBUG: "client-response-num" => 1,
DEBUG: "client-date" => "Fri, 17
Mar 2023 19:55:08 GMT",
DEBUG: "schedulesdirect-serverid"
=> "20141201.web",
DEBUG: "x-frame-options" =>
"SAMEORIGIN",
DEBUG: "client-transfer-encoding"
=> [
DEBUG:
"chunked"
DEBUG:
],
DEBUG: "client-ssl-cert-subject"
=> "/CN=*.json.schedulesdirect.org",
DEBUG: "client-ssl-cert-issuer"
=> "/C=US/O=Amazon/CN=Amazon RSA 2048 M01",
DEBUG: "content-encoding" =>
"gzip",
DEBUG: "vary" =>
"Accept-Encoding",
DEBUG: "connection" =>
"keep-alive"
DEBUG: }, 'HTTP::Headers' ),
DEBUG: "_request" => bless( {
DEBUG: "_uri_canonical" => bless(
do{\(my $o = "https://json.schedulesdirect.org/20141201/token")},
'URI::https' ),
DEBUG: "_headers" => bless( {
DEBUG:
"user-agent" => "tv_grab_zz_sdjson_sqlite",
DEBUG:
"pragma" => "no-cache",
DEBUG:
"accept-encoding" => "gzip, x-gzip, deflate, x-bzip2, bzip2",
DEBUG:
"accept" => "application/json",
DEBUG:
"content-type" => "application/json",
DEBUG:
"::std_case" => {
DEBUG:
"if-ssl-cert-subject" => "If-SSL-Cert-Subject"
DEBUG:
},
DEBUG:
"cache-control" => "no-cache"
DEBUG: },
'HTTP::Headers' ),
DEBUG: "_uri" =>
$VAR1->{"_request"}{"_uri_canonical"},
DEBUG: "_method" => "POST",
DEBUG: "_content" =>
"{\"username\":\"darylangela\",\"password\":\"92ed9f927cf1162628e1e1a92221672e1d63aa70\"}",
DEBUG: "_protocol" => undef
DEBUG: }, 'HTTP::Request' ),
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",
DEBUG: "_msg" => "OK",
DEBUG: "_protocol" => "HTTP/1.1",
DEBUG: "_rc" => 200
DEBUG: }, 'HTTP::Response' );
DEBUG: HTTP decoded response content:
DEBUG: $VAR1 =
"{\"code\":0,\"message\":\"OK\",\"serverID\":\"20141201.web\",\"datetime\":\"2023-03-17T19:55:08Z\",\"token\":\"7aa8cfb952a9bde2ecb502ef87822ea7\"}";
DEBUG: Entering SchedulesDirect::Token with args:
DEBUG: Returning from SchedulesDirect::Token with:
DEBUG: $VAR1 = "7aa8cfb952a9bde2ecb502ef87822ea7 1679082907.72004";
DEBUG: Returning from SchedulesDirect::obtainToken with:
DEBUG: $VAR1 = "7aa8cfb952a9bde2ecb502ef87822ea7 1679082907.72004";
Unexpected error when executing statement (replace into settings (tag,
value) values (?, ?)): attempt to write a readonly database
daryl at trieli:~$
_______________________________________________
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20230317/813cbfc1/attachment.htm>
More information about the mythtv-users
mailing list