Mailing List Archive

Problem with mythfilldatabase
Hi all

I have been having trouble with schedule updates over the last week.I use
a script run by cron to update with freeview.xml
data.I decided to try to get tv_grab_nz-py to work.This was unsuccessful
(again).
In the process I deleted and recreated my video sources and
rescanned.Re-entered xmltv id for each channel in the channel editor.

The problem is: when I run mythfilldatabase I get:

2016-06-05 12:29:16.181688 N Unknown xmltv channel identifier:
tv2.freeviewnz.tv - Skipping channel.

messages for every channel.

I think I may have missed a step in the process but I can find what.

Any suggestions?

_Paul

_______________________________________________
mythtvnz mailing list
mythtvnz@lists.linuxnut.co.nz
http://lists.ourshack.com/mailman/listinfo/mythtvnz
Archives http://www.gossamer-threads.com/lists/mythtv/mythtvnz/
Re: Problem with mythfilldatabase [ In reply to ]
On Sun, 05 Jun 2016 12:43:04 +1200, you wrote:

>Hi all
>
>I have been having trouble with schedule updates over the last week.I use
>a script run by cron to update with freeview.xml
>data.I decided to try to get tv_grab_nz-py to work.This was unsuccessful
>(again).
>In the process I deleted and recreated my video sources and
>rescanned.Re-entered xmltv id for each channel in the channel editor.
>
>The problem is: when I run mythfilldatabase I get:
>
> 2016-06-05 12:29:16.181688 N Unknown xmltv channel identifier:
>tv2.freeviewnz.tv - Skipping channel.
>
>messages for every channel.
>
>I think I may have missed a step in the process but I can find what.
>
>Any suggestions?
>
>_Paul

Youn need to have a .xmltv config file in /home/<mythtv user>/.mythtv
for each source. So for my FreeviewHD source, I have this file:

root@mypvr:/home/stephen/.mythtv# cat FreeviewHD.xmltv
channel=tv1.freeviewnz.tv
channel=tv2.freeviewnz.tv
channel=tv3.freeviewnz.tv
channel=four.freeviewnz.tv
channel=maori-tv.freeviewnz.tv
channel=tv1-plus1.freeviewnz.tv
channel=tv2-plus1.freeviewnz.tv
channel=tv3-plus1.freeviewnz.tv
channel=four-plus1.freeviewnz.tv
channel=duke.freeviewnz.tv
channel=edge-tv.freeviewnz.tv
channel=prime.freeviewnz.tv
channel=choice.freeviewnz.tv
channel=shopping-channel.freeviewnz.tv
channel=parliament.freeviewnz.tv
channel!hope-channel.freeviewnz.tv
channel=aljazeera.freeviewnz.tv
channel=te-reo.freeviewnz.tv
channel!shine.freeviewnz.tv
channel=firstlight.freeviewnz.tv
channel=sommet-sports.freeviewnz.tv
channel=tvsn-shopping-channel.freeviewnz.tv
channel=chinese-tv8.freeviewnz.tv
channel=tv33.freeviewnz.tv
channel=yes-shop.freeviewnz.tv
channel=apna.freeviewnz.tv
channel=rnz-national.freeviewnz.tv
channel=rnz-concert.freeviewnz.tv
channel=basefm.freeviewnz.tv
channel!georgefm.freeviewnz.tv
channel!tvnz7.freeviewnz.tv
channel!tv9.freeviewnz.tv

The = sign says to include the EPG data for that channel, and the ! to
exclude it.

_______________________________________________
mythtvnz mailing list
mythtvnz@lists.linuxnut.co.nz
http://lists.ourshack.com/mailman/listinfo/mythtvnz
Archives http://www.gossamer-threads.com/lists/mythtv/mythtvnz/
Re: Problem with mythfilldatabase [ In reply to ]
On Sun, 05 Jun 2016 15:06:56 +1200, you wrote:

>On Sun, 05 Jun 2016 12:43:04 +1200, you wrote:
>
>>Hi all
>>
>>I have been having trouble with schedule updates over the last week.I use
>>a script run by cron to update with freeview.xml
>>data.I decided to try to get tv_grab_nz-py to work.This was unsuccessful
>>(again).
>>In the process I deleted and recreated my video sources and
>>rescanned.Re-entered xmltv id for each channel in the channel editor.
>>
>>The problem is: when I run mythfilldatabase I get:
>>
>> 2016-06-05 12:29:16.181688 N Unknown xmltv channel identifier:
>>tv2.freeviewnz.tv - Skipping channel.
>>
>>messages for every channel.
>>
>>I think I may have missed a step in the process but I can find what.
>>
>>Any suggestions?
>>
>>_Paul
>
>Youn need to have a .xmltv config file in /home/<mythtv user>/.mythtv
>for each source. So for my FreeviewHD source, I have this file:
>
>root@mypvr:/home/stephen/.mythtv# cat FreeviewHD.xmltv
>channel=tv1.freeviewnz.tv
>channel=tv2.freeviewnz.tv
>channel=tv3.freeviewnz.tv
>channel=four.freeviewnz.tv
>channel=maori-tv.freeviewnz.tv
>channel=tv1-plus1.freeviewnz.tv
>channel=tv2-plus1.freeviewnz.tv
>channel=tv3-plus1.freeviewnz.tv
>channel=four-plus1.freeviewnz.tv
>channel=duke.freeviewnz.tv
>channel=edge-tv.freeviewnz.tv
>channel=prime.freeviewnz.tv
>channel=choice.freeviewnz.tv
>channel=shopping-channel.freeviewnz.tv
>channel=parliament.freeviewnz.tv
>channel!hope-channel.freeviewnz.tv
>channel=aljazeera.freeviewnz.tv
>channel=te-reo.freeviewnz.tv
>channel!shine.freeviewnz.tv
>channel=firstlight.freeviewnz.tv
>channel=sommet-sports.freeviewnz.tv
>channel=tvsn-shopping-channel.freeviewnz.tv
>channel=chinese-tv8.freeviewnz.tv
>channel=tv33.freeviewnz.tv
>channel=yes-shop.freeviewnz.tv
>channel=apna.freeviewnz.tv
>channel=rnz-national.freeviewnz.tv
>channel=rnz-concert.freeviewnz.tv
>channel=basefm.freeviewnz.tv
>channel!georgefm.freeviewnz.tv
>channel!tvnz7.freeviewnz.tv
>channel!tv9.freeviewnz.tv
>
>The = sign says to include the EPG data for that channel, and the ! to
>exclude it.

You can make your .xmltv file like this:

root@mypvr:/home/stephen/.mythtv# mysql -s -N -p
Enter password:
mysql> tee /tmp/FreeviewHD.xmltv
Logging to file '/tmp/FreeviewHD.xmltv'
mysql> select concat('channel=',xmltvid) from channel where
sourceid=1;
channel=aljazeera.freeviewnz.tv
channel=apna.freeviewnz.tv
channel=basefm.freeviewnz.tv
channel=chinese-tv8.freeviewnz.tv
channel=choice.freeviewnz.tv
channel=duke.freeviewnz.tv
channel=edge-tv.freeviewnz.tv
channel=firstlight.freeviewnz.tv
channel=four-plus1.freeviewnz.tv
channel=four.freeviewnz.tv
channel=maori-tv.freeviewnz.tv
channel=parliament.freeviewnz.tv
channel=prime.freeviewnz.tv
channel=rnz-concert.freeviewnz.tv
channel=rnz-national.freeviewnz.tv
channel=shopping-channel.freeviewnz.tv
channel=te-reo.freeviewnz.tv
channel=tv1-plus1.freeviewnz.tv
channel=tv1.freeviewnz.tv
channel=tv2-plus1.freeviewnz.tv
channel=tv2.freeviewnz.tv
channel=tv29.freeviewnz.tv
channel=tv3-plus1.freeviewnz.tv
channel=tv3.freeviewnz.tv
channel=tv33.freeviewnz.tv
channel=tvnz7.freeviewnz.tv
channel=tvsn-shopping-channel.freeviewnz.tv
channel=yes-shop.freeviewnz.tv
mysql> notee
Outfile disabled.
mysql> quit

You have to edit the file to remove the notee command on the end, then
move it to the right directory.

_______________________________________________
mythtvnz mailing list
mythtvnz@lists.linuxnut.co.nz
http://lists.ourshack.com/mailman/listinfo/mythtvnz
Archives http://www.gossamer-threads.com/lists/mythtv/mythtvnz/
Re: Problem with mythfilldatabase [ In reply to ]
On Sun, 05 Jun 2016 15:36:10 +1200, Stephen Worthington
<stephen_agent@jsw.gen.nz> wrote:

> On Sun, 05 Jun 2016 15:06:56 +1200, you wrote:
>
>> On Sun, 05 Jun 2016 12:43:04 +1200, you wrote:
>>
>>> Hi all
>>>
>>> I have been having trouble with schedule updates over the last week.I
>>> use
>>> a script run by cron to update with freeview.xml
>>> data.I decided to try to get tv_grab_nz-py to work.This was
>>> unsuccessful
>>> (again).
>>> In the process I deleted and recreated my video sources and
>>> rescanned.Re-entered xmltv id for each channel in the channel editor.
>>>
>>> The problem is: when I run mythfilldatabase I get:
>>>
>>> 2016-06-05 12:29:16.181688 N Unknown xmltv channel identifier:
>>> tv2.freeviewnz.tv - Skipping channel.
>>>
>>> messages for every channel.
>>>
>>> I think I may have missed a step in the process but I can find what.
>>>
>>> Any suggestions?
>>>
>>> _Paul
>>
>> Youn need to have a .xmltv config file in /home/<mythtv user>/.mythtv
>> for each source. So for my FreeviewHD source, I have this file:
>>
>> root@mypvr:/home/stephen/.mythtv# cat FreeviewHD.xmltv
>> channel=tv1.freeviewnz.tv
>> channel=tv2.freeviewnz.tv
>> channel=tv3.freeviewnz.tv
>> channel=four.freeviewnz.tv
>> channel=maori-tv.freeviewnz.tv
>> channel=tv1-plus1.freeviewnz.tv
>> channel=tv2-plus1.freeviewnz.tv
>> channel=tv3-plus1.freeviewnz.tv
>> channel=four-plus1.freeviewnz.tv
>> channel=duke.freeviewnz.tv
>> channel=edge-tv.freeviewnz.tv
>> channel=prime.freeviewnz.tv
>> channel=choice.freeviewnz.tv
>> channel=shopping-channel.freeviewnz.tv
>> channel=parliament.freeviewnz.tv
>> channel!hope-channel.freeviewnz.tv
>> channel=aljazeera.freeviewnz.tv
>> channel=te-reo.freeviewnz.tv
>> channel!shine.freeviewnz.tv
>> channel=firstlight.freeviewnz.tv
>> channel=sommet-sports.freeviewnz.tv
>> channel=tvsn-shopping-channel.freeviewnz.tv
>> channel=chinese-tv8.freeviewnz.tv
>> channel=tv33.freeviewnz.tv
>> channel=yes-shop.freeviewnz.tv
>> channel=apna.freeviewnz.tv
>> channel=rnz-national.freeviewnz.tv
>> channel=rnz-concert.freeviewnz.tv
>> channel=basefm.freeviewnz.tv
>> channel!georgefm.freeviewnz.tv
>> channel!tvnz7.freeviewnz.tv
>> channel!tv9.freeviewnz.tv
>>
>> The = sign says to include the EPG data for that channel, and the ! to
>> exclude it.
>
> You can make your .xmltv file like this:
>
> root@mypvr:/home/stephen/.mythtv# mysql -s -N -p
> Enter password:
> mysql> tee /tmp/FreeviewHD.xmltv
> Logging to file '/tmp/FreeviewHD.xmltv'
> mysql> select concat('channel=',xmltvid) from channel where
> sourceid=1;
> channel=aljazeera.freeviewnz.tv
> channel=apna.freeviewnz.tv
> channel=basefm.freeviewnz.tv
> channel=chinese-tv8.freeviewnz.tv
> channel=choice.freeviewnz.tv
> channel=duke.freeviewnz.tv
> channel=edge-tv.freeviewnz.tv
> channel=firstlight.freeviewnz.tv
> channel=four-plus1.freeviewnz.tv
> channel=four.freeviewnz.tv
> channel=maori-tv.freeviewnz.tv
> channel=parliament.freeviewnz.tv
> channel=prime.freeviewnz.tv
> channel=rnz-concert.freeviewnz.tv
> channel=rnz-national.freeviewnz.tv
> channel=shopping-channel.freeviewnz.tv
> channel=te-reo.freeviewnz.tv
> channel=tv1-plus1.freeviewnz.tv
> channel=tv1.freeviewnz.tv
> channel=tv2-plus1.freeviewnz.tv
> channel=tv2.freeviewnz.tv
> channel=tv29.freeviewnz.tv
> channel=tv3-plus1.freeviewnz.tv
> channel=tv3.freeviewnz.tv
> channel=tv33.freeviewnz.tv
> channel=tvnz7.freeviewnz.tv
> channel=tvsn-shopping-channel.freeviewnz.tv
> channel=yes-shop.freeviewnz.tv
> mysql> notee
> Outfile disabled.
> mysql> quit
>
> You have to edit the file to remove the notee command on the end, then
> move it to the right directory.
>
> _______________________________________________
> mythtvnz mailing list
> mythtvnz@lists.linuxnut.co.nz
> http://lists.ourshack.com/mailman/listinfo/mythtvnz
> Archives http://www.gossamer-threads.com/lists/mythtv/mythtvnz/

Thanks for that Stephen.I'll check it.
I got the database sorted by doing a full db restore from this morning's
back up.

Cheers

Paul

_______________________________________________
mythtvnz mailing list
mythtvnz@lists.linuxnut.co.nz
http://lists.ourshack.com/mailman/listinfo/mythtvnz
Archives http://www.gossamer-threads.com/lists/mythtv/mythtvnz/