[mythtv-users] eit / epg grabber for dvb-t

[Minty]

On 7/19/07, David Watkins <watkinshome at gmail.com> wrote:
> There is a command line option to enable EIT message logging on the
> backend.  I can't remember exactly, so try mythbackend --help.

So I tried with -v all and -v eit, summary below - nothing that
suggests whats going wrong.

I modified /etc/init.d/mythtv-backend to have:

ARGS="--verbose all --daemon --logfile /var/log/mythtv/mythbackend.log
--pidfile $RUNDIR/$NAME.pid"

Restarted, then grep'd -i for "eit" in that after seeing an EIT scan
scroll past.  The result is below, with the lines starting => being
the values I got for the SQL statements when run manually.  It looks
reasonable enough to me...  I'd be happy to supply full logs if anyone
wants them:

2007-07-19 22:12:04.141 MSqlQuery: SELECT data FROM settings WHERE
value = 'EITTimeOffset' AND hostname = 'tv' ;
=> Empty Set
2007-07-19 22:12:04.143 MSqlQuery: SELECT data FROM settings WHERE
value = 'EITTimeOffset' AND hostname IS NULL;
=> Auto
2007-07-19 22:12:04.144 EITHelper: localtime offset 1:00:00
2007-07-19 22:12:05.059 MSqlQuery: SELECT data FROM settings WHERE
value = 'EITIgnoresSource' AND hostname = 'tv' ;
=> Empty Set
2007-07-19 22:12:05.061 MSqlQuery: SELECT data FROM settings WHERE
value = 'EITIgnoresSource' AND hostname IS NULL;
=> 0
2007-07-19 22:12:05.096 MSqlQuery: SELECT data FROM settings WHERE
value = 'EITTransportTimeout' AND hostname = 'tv' ;
=> Empty Set
2007-07-19 22:12:05.097 MSqlQuery: SELECT data FROM settings WHERE
value = 'EITTransportTimeout' AND hostname IS NULL;
=> 5
2007-07-19 22:12:05.099 MSqlQuery: SELECT data FROM settings WHERE
value = 'EITCrawIdleStart' AND hostname = 'tv' ;
=> Empty Set
2007-07-19 22:12:05.101 MSqlQuery: SELECT data FROM settings WHERE
value = 'EITCrawIdleStart' AND hostname IS NULL;
=> 60
2007-07-19 22:14:03.600 MSqlQuery: SELECT SUM(useeit) FROM
videosource, cardinput WHERE videosource.sourceid = cardinput.sourceid
AND      cardinput.cardid     = 1
=> 1
2007-07-19 22:14:03.606 MSqlQuery: SELECT min(channum) FROM channel,
cardinput, capturecard, videosource WHERE cardinput.sourceid   =
channel.sourceid AND       videosource.sourceid = channel.sourceid AND
      capturecard.cardid   = cardinput.cardid AND
channel.mplexid        IS NOT NULL      AND       useonairguide
= 1                AND       useeit               = 1
AND       channum             != ''               AND
cardinput.cardid     = 1 GROUP BY mplexid ORDER BY cardinput.sourceid,
mplexid,          atsc_major_chan, atsc_minor_chan
=> 1, 10, 15, 701, 18
2007-07-19 22:14:03.607 EITScanner: StartActiveScan called with 5 multiplexes
2007-07-19 22:14:03.608 TVRec(1): SetFlags(EITScannerRunning,) ->
RunMainLoop,EITScannerRunning,
2007-07-19 22:14:03.744 TVRec(1): ClearFlags(RingBufferReady,) ->
RunMainLoop,EITScannerRunning,
2007-07-19 22:14:03.745 TVRec(1): Request: Program(no) channel(10)
input() flags(EITScan,)
2007-07-19 22:14:03.750 TVRec(1): ClearFlags(PENDINGACTIONS,) ->
RunMainLoop,EITScannerRunning,
2007-07-19 22:14:05.460 TVRec(1): SetFlags(SignalMonitorRunning,) ->
RunMainLoop,SignalMonitorRunning,EITScannerRunning,
2007-07-19 22:14:05.461 TVRec(1): ClearFlags(WaitingForSignal,) ->
RunMainLoop,SignalMonitorRunning,EITScannerRunning,
2007-07-19 22:14:05.463 TVRec(1): SetFlags(WaitingForSignal,) ->
RunMainLoop,WaitingForSignal,SignalMonitorRunning,EITScannerRunning,
2007-07-19 22:14:05.464 TVRec(1): ClearFlags(NeedToStartRecorder,) ->
RunMainLoop,WaitingForSignal,SignalMonitorRunning,EITScannerRunning,
2007-07-19 22:14:05.468 EITScanner: Now looking for EIT data on
multiplex of channel 10
2007-07-19 22:14:05.470 EITCache: Pruning all entries that ended
before UTC 2007-07-18T22:19:08
2007-07-19 22:14:05.471 EITCache: Deleting old cache entries from the database
2007-07-19 22:14:05.473 MSqlQuery: DELETE FROM eit_cache WHERE endtime
< 1184793548

===========================================================
===========================================================

Then I switched /etc/init.d/mythtv-backend to have

ARGS="--verbose eit --daemon --logfile /var/log/mythtv/mythbackend.log
--pidfile $RUNDIR/$NAME.pid"

Not really much of use here I think:

2007-07-19 22:37:14.927 EITScanner: StartActiveScan called with 5 multiplexes
2007-07-19 22:37:15.989 EITScanner: Now looking for EIT data on
multiplex of channel 10
2007-07-19 22:37:15.994 EITCache: Pruning all entries that ended
before UTC 2007-07-18T22:42:18
2007-07-19 22:37:15.996 EITCache: Deleting old cache entries from the database

2007-07-19 22:42:19.058 EITScanner: Now looking for EIT data on
multiplex of channel 15
2007-07-19 22:42:19.063 EITCache: Pruning all entries that ended
before UTC 2007-07-18T22:47:22
2007-07-19 22:42:19.065 EITCache: Deleting old cache entries from the database