[mythtv-users] Important Stuff

[Al McIntosh]

Brian Wood wrote:

>Ok, enough of this foolishness about disk space, satellite receivers,  
>and system operation, let's get down to the really important things:
>
>How com "Dilbert" never seems to work with MythNews ???
>
>
>  
>




I have the same problem, Dilbert and Fark no longer work.  At a quick 
glance, I  see  neither has been downloaded:


mysql> SELECT name, url, updated FROM newssites where name = 'Dilbert' 
or name = 'Fark';
+---------+---------------------------------------------------+---------+
| name    | 
url                                                           | updated |
+---------+---------------------------------------------------+---------+
| Dilbert | http://dwlt.net/tapestry/dilbert.rdf        | NULL |
| Fark     | http://www.pluck.com/rss/fark.rss        | NULL |
+---------+---------------------------------------------------+---------+
2 rows in set (0.00 sec)


Lets investigate:


------------------------------ Dilbert 
--------------------------------------------------------
$ wget http://dwlt.net/tapestry/dilbert.rdf
--09:08:15--  http://dwlt.net/tapestry/dilbert.rdf
           => `dilbert.rdf'
Resolving dwlt.net... 217.163.9.108
Connecting to dwlt.net|217.163.9.108|:80... connected.
HTTP request sent, awaiting response... 301 Moved Permanently
Location: http://www.tapestrycomics.com/dilbert.xml [following]
--09:08:19--  http://www.tapestrycomics.com/dilbert.xml
           => `dilbert.xml'
Resolving www.tapestrycomics.com... 66.29.14.120
Connecting to www.tapestrycomics.com|66.29.14.120|:80... connected.
HTTP request sent, awaiting response... 302 Found
Location: http://feeds.feedburner.com/tapestrydilbert [following]
--09:08:23--  http://feeds.feedburner.com/tapestrydilbert
           => `tapestrydilbert'
Resolving feeds.feedburner.com... 66.150.96.111
Connecting to feeds.feedburner.com|66.150.96.111|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 2,838 (2.8K) [application/xml]

100%[====================================================================================>] 
2,838         --.--K/s

09:08:24 (723.63 KB/s) - `tapestrydilbert' saved [2838/2838]


------------------------------ Fark 
--------------------------------------------------------

]$ wget http://www.pluck.com/rss/fark.rss
--09:08:36--  http://www.pluck.com/rss/fark.rss
           => `fark.rss'
Resolving www.pluck.com... 66.179.81.250
Connecting to www.pluck.com|66.179.81.250|:80... connected.
HTTP request sent, awaiting response... 301 Moved Permanently
Location: http://feeds.feedburner.com/fark/HifS [following]
--09:08:38--  http://feeds.feedburner.com/fark/HifS
           => `HifS'
Resolving feeds.feedburner.com... 66.150.96.111
Connecting to feeds.feedburner.com|66.150.96.111|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: unspecified [text/xml]

    [   
<=>                                                                               
] 22,342        40.26K/s

09:08:39 (40.21 KB/s) - `HifS' saved [22342]



The links work but the initial http response does not equal '200'  which 
makes me  *suspect* the download mechanism does not handle redirects.
Looks like they both require an update.

Lets update the urls using the redirect target:

mysql> UPDATE newssites SET url = 
'http://feeds.feedburner.com/tapestrydilbert' where name = 'Dilbert';
Query OK, 1 row affected (0.03 sec)
Rows matched: 1  Changed: 1  Warnings: 0



mysql> UPDATE newssites SET url = 
'http://feeds.feedburner.com/fark/HifS' where name = 'Fark';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0


Go to mythfrontend and check it out, hey it worked.

mysql> SELECT name, url, updated FROM newssites where name = 'Dilbert' 
or name = 'Fark';
+---------+---------------------------------------------------------+------------+
| name    | url                                                  
                 |updated    |
+---------+---------------------------------------------------------+------------+
| Dilbert | http://feeds.feedburner.com/tapestrydilbert | 1141918951 |
| Fark    | http://feeds.feedburner.com/fark/HifS          | 1141918952 |
+---------+---------------------------------------------------------+------------+
2 rows in set (0.00 sec)



In the case of Dilbert under Settings->Information->News when you select 
Humor -> Dilbert the following sql needs to be updated:

INSERT INTO newssites (name,category,url,ico)  VALUES( 'Dilbert', 
'Humor', 'http://dwlt.net/tapestry/dilbert.rdf', '' );