[mythtv-users] Re: Getting EIT (DVB Program Guide) working?

Tue Aug 16 15:49:25 UTC 2005

It was because the networkID in dtv_multiplex was null.

I changed it to 9018 (for all mplexes) and it started getting listings :) :) :)

ANyone know where 9018 came from? (I just grepped the log file for any
SErviceID's and it came up with 9018...) i suspect I need different
values for different mplexes.

Anyone on Crystal Palace who fancies dumping their channels and
dtv_multiplex tables for me???
thanks

george

On 8/16/05, George Styles <ripnetuk at gmail.com> wrote:
> Hi,
> 
> Im trying without success to get the eit feature (where it pulls
> listings from the DVB signal) to work.
> 
> I am in the UK, using the Crystal Palace transmitter, with a budget dvb-t card.
> 
> I know the listings are there, because tv_grab_dvb gets them perfectly.
> 
> Ive compiled MythTV with the config options --enable-dvb  --enable-dvb-eit
> 
> which I know has worked, because I now get the checkbox on channel
> setup to pull  listings from the air. (I actually updated the channels
> table to set useonairguide=1 for all channels).
> 
> I imported my channel listings from a channels.conf file (as the scan
> missed radio channels and a lot of other channels first time). Video
> records OK. I record in TS format.
> 
> When mythbackend is running, I get the following, which I think
> explains my problem, but im not sure what it means - ive changed all
> the channel ids to be the service id's in case its that (update
> channel set chanid = serviceid).
> 
> 2005-08-16 16:21:10.329 EITHelper::HandleEITs()
> 2005-08-16 16:21:10.330 EITHelper::HandleEITs()
> 2005-08-16 16:21:10.340 EITHelper::ProcessEvents(2)
> 2005-08-16 16:21:10.344 EITHelper: ChanID not found so event updates
> were skipped.
> 2005-08-16 16:21:10.356 EITHelper: ChanID not found so event updates
> were skipped.
> 2005-08-16 16:21:10.365 EITHelper::HandleEITs()
> 2005-08-16 16:21:10.374 EITHelper::ProcessEvents(2)
> 2005-08-16 16:21:10.379 EITHelper: ChanID not found so event updates
> were skipped.
> 2005-08-16 16:21:10.416 EITHelper::HandleEITs()
> 2005-08-16 16:21:10.417 EITHelper::ProcessEvents(2)
> 2005-08-16 16:21:10.421 EITHelper: ChanID not found so event updates
> were skipped.
> 2005-08-16 16:21:10.514 EITHelper::HandleEITs()
> 2005-08-16 16:21:10.532 EITHelper::ProcessEvents(2)
> 2005-08-16 16:21:10.536 EITHelper: ChanID not found so event updates
> were skipped.
> 2005-08-16 16:21:10.709 EITHelper::HandleEITs()
> 2005-08-16 16:21:10.721 EITHelper::ProcessEvents(2)
> 2005-08-16 16:21:10.725 EITHelper: ChanID not found so event updates
> were skipped.
> 2005-08-16 16:21:10.731 EITHelper::HandleEITs()
> 2005-08-16 16:21:10.742 EITHelper::ProcessEvents(2)
> 2005-08-16 16:21:10.748 EITHelper::HandleEITs()
> 2005-08-16 16:21:10.758 EITHelper: ChanID not found so event updates
> were skipped.
> 2005-08-16 16:21:10.768 EITHelper: ChanID not found so event updates
> were skipped.
> 2005-08-16 16:21:13.898 AVFD: Opened codec 0x83387b0, id(MPEG2VIDEO) type(Video)
> 2005-08-16 16:21:13.898 AVFD: Opened codec 0x844a4b0, id(MP3) type(Audio)
> 2005-08-16 16:21:13.898 AVFD: Opened codec 0x8337d20, id(MP3) type(Audio)
> 2005-08-16 16:21:13.898 AVFD: Opened codec 0x84445d0, id(DVB_SUBTITLE)
> type(Subtitle
> 
> Using the source (tm) I have found the following lines in eithelper.cpp:
>       /* DVB Link to chanid */
>         query.prepare(QString("SELECT chanid, useonairguide "
>                               "FROM channel, dtv_multiplex "
>                               "WHERE serviceid = %1 AND "
>                               "      networkid = %2 AND "
>                               "      channel.mplexid = dtv_multiplex.mplexid")
>                       .arg(event.ServiceID).arg(event.NetworkID));
>     }
> 
>     if (!query.exec() || !query.isActive())
>         MythContext::DBError("Looking up chanID", query);
> 
>     if (query.size() <= 0)
>     {
>         VERBOSE(VB_IMPORTANT, "EITHelper: ChanID not found "
>                 "so event updates were skipped.");
>         return -1;
>     }
> 
> so obviously the query being built is returning no records, im
> guessing that the serviceid is not right or the network Id is not
> right. Unfortunately, the output doesnt include the query its actually
> running.
> Is there any way to get MySQL to dump a trace file of all SQLs run
> with their parameters?
> 
> 
> 
> I have turned on the extra verbose logging (mythbackend -v siparser)
> and I get a lot of info pumped out, but the interesting messages are
> as follows:
> 
> 2005-08-16 16:00:17.827 SIParser: SDT: NetworkID=9018 TransportID=16384
> 2005-08-16 16:00:17.828 SIParser: SDT: sid=16768 type=1 eit_present=1
> eit_requested=1 name=BBC PARLMNT
> 2005-08-16 16:00:17.828 SIParser: SDT: sid=16832 type=1 eit_present=1
> eit_requested=1 name=BBC FOUR
> 2005-08-16 16:00:17.828 SIParser: SDT: sid=16960 type=1 eit_present=1
> eit_requested=1 name=CBeebies
> 2005-08-16 16:00:17.829 SIParser: SDT: sid=17920 type=2 eit_present=1
> eit_requested=0 name=BBC R5 Live
> 2005-08-16 16:00:17.829 SIParser: SDT: sid=17984 type=2 eit_present=1
> eit_requested=0 name=BBC 5L SportsX
> 2005-08-16 16:00:17.829 SIParser: SDT: sid=18048 type=2 eit_present=1
> eit_requested=0 name=BBC 6 Music
> 2005-08-16 16:00:17.829 SIParser: SDT: sid=18112 type=2 eit_present=1
> eit_requested=0 name=BBC 7
> 2005-08-16 16:00:17.830 SIParser: SDT: sid=18176 type=2 eit_present=1
> eit_requested=0 name=1Xtra BBC
> 2005-08-16 16:00:17.830 SIParser: SDT: sid=18240 type=2 eit_present=1
> eit_requested=0 name=BBC Asian Net.
> 2005-08-16 16:00:17.830 SIParser: SDT: sid=19456 type=1 eit_present=0
> eit_requested=0 name=701
> 2005-08-16 16:00:17.831 SIParser: SDT: sid=19520 type=1 eit_present=0
> eit_requested=0 name=702
> 2005-08-16 16:00:17.831 SIParser: SDT: sid=19584 type=1 eit_present=0
> eit_requested=0 name=703
> 2005-08-16 16:00:17.831 SIParser: SDT: sid=19968 type=1 eit_present=1
> eit_requested=1 name=Community
> 2005-08-16 16:00:17.937 SIParser: Unknown Descriptor: 5e 3d  0 65 6e
> 67  b 66 75 6c 6c 20 73 63 72 65 65 6e 65 6e 67  8 6d 6f 6e 61 75 72
> 61 6c 65 6e 67 1d 73 75 62 74 69 74 6c 65 73 20 66 6f 72 20 68 61 72
> 64 20 6f 66 20 68 65 61 72 69 6e 67
> 2005-08-16 16:00:17.938 SIParser: Unknown Descriptor: 5e 3d  0 65 6e
> 67  b 66 75 6c 6c 20 73 63 72 65 65 6e 65 6e 67  8 6d 6f 6e 61 75 72
> 61 6c 65 6e 67 1d 73 75 62 74 69 74 6c 65 73 20 66 6f 72 20 68 61 72
> 64 20 6f 66 20 68 65 61 72 69 6e 67
> 2005-08-16 16:00:17.940 SIParser: Unknown Descriptor: 5e 3d  0 65 6e
> 67  b 66 75 6c 6c 20 73 63 72 65 65 6e 65 6e 67  8 6d 6f 6e 61 75 72
> 61 6c 65 6e 67 1d 73 75 62 74 69 74 6c 65 73 20 66 6f 72 20 68 61 72
> 64 20 6f 66 20 68 65 61 72 69 6e 67
> 2005-08-16 16:00:17.940 SIParser: Unknown Descriptor: 5e 1c  0 65 6e
> 67  b 66 75 6c 6c 20 73 63 72 65 65 6e 65 6e 67  8 6d 6f 6e 61 75 72
> 61 6c
> 2005-08-16 16:00:17.997 SIParser: SDT: NetworkID=9018 TransportID=20480
> 2005-08-16 16:00:17.997 SIParser: SDT: sid=22080 type=1 eit_present=1
> eit_requested=1 name=Sky News
> 2005-08-16 16:00:17.997 SIParser: SDT: sid=22144 type=1 eit_present=1
> eit_requested=1 name=Sky Spts News
> 2005-08-16 16:00:17.998 SIParser: SDT: sid=22208 type=1 eit_present=1
> eit_requested=1 name=Sky Travel
> 2005-08-16 16:00:17.998 SIParser: SDT: sid=22272 type=1 eit_present=1
> eit_requested=1 name=UKTV History
> 2005-08-16 16:00:17.999 SIParser: SDT: sid=22336 type=1 eit_present=1
> eit_requested=1 name=E4+1
> 2005-08-16 16:00:18.000 SIParser: SDT: sid=22592 type=2 eit_present=1
> eit_requested=0 name=talkSPORT
> 2005-08-16 16:00:18.000 SIParser: SDT: sid=22976 type=2 eit_present=1
> eit_requested=0 name=Premier Radio
> 2005-08-16 16:00:18.000 SIParser: SDT: sid=23040 type=2 eit_present=1
> eit_requested=0 name=3C
>