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

George Styles ripnetuk at gmail.com
Tue Aug 16 15:40:52 UTC 2005


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


More information about the mythtv-users mailing list