[mythtv] IPTV not working in 0.27 -- possible bug in mythsocket.cpp?

[Stephen Worthington]

On Wed, 27 Nov 2013 15:58:06 +0100, you wrote:

>On Wed, Nov 27, 2013 at 12:46 PM, José Oliver Segura <primijos at gmail.com> wrote:
>> TL;DR
>>
>> Is mythsocket using QTcpSocket for "remote content", even
>> for RTP UDP-Multicast connections when it should use QUdpSocket
>> instead?
>
>Mmm.. OK, after some additional tests, looks like mythavtest is not
>the way to test IPTV (or, at least, rtp:// multicast IPTV)?
>
>I said that because I've run additional tests just scheduling some
>recordings on IPTV channels and the results are very different from
>those obtained by using mythavtest.
>
>I've scheduled a 1min recording on an IPTV channel and enabled
>additional logging in mythbackend, and there are some interesting
>lines in the logfile, basically:
>
>2013-11-27 13:30:00.051857 D  MSqlQuery::exec(DBManager9) SELECT
>channel.chanid FROM channel WHERE channum  = '010' AND       sourceid
>= '2' <<<< Returns 1 row(s)
>2013-11-27 13:30:00.051924 D  MSqlQuery::next(DBManager9) Result:
>"chanid = 2010"
>2013-11-27 13:30:00.052779 D  MSqlQuery::exec(DBManager9) SELECT
>type+0, url, bitrate FROM iptv_channel WHERE chanid = '2010' ORDER BY
>type+0 <<<< Returns 1 row(s)
>2013-11-27 13:30:00.052885 D  MSqlQuery::next(DBManager9) Result:
>"type+0 = 1, url = , bitrate = 0"
>2013-11-27 13:30:00.052933 I  Loaded [data][fectype][fec0][fec1] for 2010
>2013-11-27 13:30:00.053051 I  IPTVChan[8]: Tune([data][fectype][fec0][fec1])
>2013-11-27 13:30:00.053096 E  IPTVChan[8]: Invalid tuning info
>[data][fectype][fec0][fec1]
>2013-11-27 13:30:00.053114 E  DTVChan[8](): SetChannelByString(010):
>Tuning to IPTV URL
>2013-11-27 13:30:00.053129 I  DTVChan[8](): SetChannelByString(010): failure
>2013-11-27 13:30:00.053153 E  TVRec[8]: Failed to set channel to 010.
>Reverting to kState_None
>2013-11-27 13:30:00.053271 I  TVRec[8]: Changing from RecordingOnly to None
>
>
>It looks like the IPTV tuner cannot tune due to invalid tuning data.
>That's the channel data in the database:
>
>mysql> select * from iptv_channel where chanid = '2010';
>+--------+--------+-----+------+---------+
>| iptvid | chanid | url | type | bitrate |
>+--------+--------+-----+------+---------+
>|     10 |   2010 |     | data |       0 |
>+--------+--------+-----+------+---------+
>
>
>As you can see, url is empty (it is empty for all IPTV channels). I've
>tried to set it manually:
>
>mysql> update iptv_channel set url='rtp://239.0.0.74:8208' where chanid='2010';
>Query OK, 1 row affected (0.01 sec)
>Rows matched: 1  Changed: 1  Warnings: 0
>
>After that, I've scheduled another 1min recording on the same chanel
>and this time I, at least, get some data. The tuner changes to
>recording and around 12MB of data is stored. However, that data looks
>damaged. Neither vlc nor mplayer can play it.
>
>I've just removed the "url" from that row in order to let things as
>they were originally.
>
>After that, I've deleted all my tuners, inputs and video sources and
>re-added then (this time just the IPTV source, no DVB tuners now) but
>the problem persists: the url column in the iptv_channel is not
>populated and the IPTV tuner complains about invalid tuning info.
>
>Any hint about why that column is not being populated and/or what
>values should go there (if they are not the rtp://x.x.x.x:p values
>associated with each channel but can be derived from the IPTV channels
>URLs I can try to update them manually just to perform some additional
>tests)
>
>Thanks in advance.
>
>Best,
>Jose

When I read this post, it tickled my memory about something I had seen
in passing while browsing the database.  Have you noticed that there
is now an iptv_channel table, with a URL field in it?  I think the URL
field in the channel table may no longer be used and you need to have
an entry in the iptv_channel table instead, referred to by iptvid and
chanid.