[mythtv-users] HD Homerun Prime Scripting

Kirk Bocek t004 at kbocek.com
Tue Oct 18 16:08:54 UTC 2011

On 10/18/2011 8:54 AM, Ozzy Lash wrote:
> On Tue, Oct 18, 2011 at 10:48 AM, Kirk Bocek<t004 at kbocek.com>  wrote:
>> On 10/17/2011 10:27 PM, Ozzy Lash wrote:
>>> On Mon, Oct 17, 2011 at 11:51 PM, Kirk Bocek<t004 at kbocek.com>    wrote:
>>>> On 10/17/2011 5:32 PM, Gary Buhrmaster wrote:
>>>>> On Mon, Oct 17, 2011 at 23:57, Kirk Bocek<t004 at kbocek.com>      wrote:
>>>>> ....
>>>>>> So let me phrase it in terms of what seems like a widely used utility:
>>>>>> scte65scan. Bill Lash here extracted some simple SQL here for inserting
>>>>>> records into dtv_multiplex. Can I get anyone to comment on *that* code?
>>>>> I am not a MythTV developer, and therefore have no standing,  but.....
>>>>> I consider that I run it at my own risk, and should something "weird"
>>>>> happen with MythTV, it is all my fault, and until I reproduce any issues
>>>>> with a clean database, the presumption *should* be that I messed
>>>>> something up.  Full disclosure, I also occasionally use direct
>>>>> database updates.  The moment I type 'mysql' I consider that the
>>>>> MythTV database is "tainted" in the same terms that the Linux kernel
>>>>> developers do.  That is, I am completely and utterly on my own, and
>>>>> should ask no one for assistance.
>>>>> Gary
>>>> Gary, I'm not sure if you're telling me I shouldn't be asking questions
>>>> here. I have a script that is certainly going to help *me*. It's going
>>>> to save broken recordings which is currently how I find out Comcast has
>>>> changed channels on me. If it's going to help me, it must also help
>>>> others if they choose to use it.
>>>> I'd like that script to be as bullet-proof as possible and to play as
>>>> nicely as possible with Myth. It seems reasonable to ask for guidance on
>>>> what I'm doing. Robert has very good reasons for why that guidance is
>>>> not likely to come. I'm a little put off by that answer. So I'll
>>>> strengthen the warnings in my script, incorporate Robert's philosophy
>>>> about direct database manipulation and just put it out there and hope it
>>>> helps others.
>>>> Kirk Bocek
>>> While I understand Robert's concern, I think anyone using clear qam
>>> today is doing some sort of database manipulation to get the channels
>>> in the database.  I like his suggestion of trying to get what you are
>>> trying to do in mythtv itself, but I think there are some issues with
>>> that, since you are updating information for your clear qam sources
>>> with information from a cablecard source.
>>> I do think that you have a good script for maintaining clear qam
>>> channels.  I think it would be pretty easy to create something like
>>> scte65scan which would work using the hdhrcc to get an initial set of
>>> channels.  The process would be something like:
>>> 1. use hdhomerun_config to scan all the channels selecting any
>>> programs that aren't marked as encrypted.
>>> 2. tune to each of the non-encrypted channels using the frequency and
>>> programid from the initial scan, and get the vchannel, and other
>>> information (channel name, ...)
>>> 3. match the frequency up with the dtv_multiplex table
>>> I may be missing a few clear qam channels today that have crept in
>>> since my initial scte65scan.  My guess is, that they aren't channels
>>> that I care about, but there might be something there.
>>> Bill
>> I think that's a good point, Bill. I was mulling over Robert's words but
>> couldn't quite pull it all together. Somehow I can't be the only one
>> having to muck about in the MySQL tables in order to get MythTV to work.
>> There's still a lot of manual maintenance work that needs to be done
>> here to keep MythTV working on a day-to-day basis.
>> I'm going to charge ahead on put the dtv_multiplex code in my script,
>> thanks to your diving into scte65scan. I've got a simple method to test
>> it (and a back-out process too!) I'll ask you to help me test it in a
>> day or so.
>> For new channels, you could use this script to add channels by manually
>> adding the new channel to the channel table but leaving a holder value
>> in mplexid and serviceid: anything other than zero. When you run my
>> script, those fields will get tuned with the proper values.
>> But once again, we're in the same boat as my problem with dtv_multiplex
>> where there's a bunch of fields where I have no idea what they're for.
>> Is there a wiki page that explains the function of each of the fields?
>> How about some source code? I can RTFM. Really.
>> _______________________________________________
>> mythtv-users mailing list
>> mythtv-users at mythtv.org
>> http://www.mythtv.org/mailman/listinfo/mythtv-users
> Well, there is:
> http://www.mythtv.org/wiki/Dtv_multiplex_table
> and
> http://www.mythtv.org/wiki/Channel
> But I'm not sure how much extra info this gives.
> Bill

Well... thanks. <redfaced> I am ashamed I didn't bother to search for 
this first.

"I have no knowledge about what the fields mean or are used for with 
satellite reception."

Does anyone, or is this a bunch of historical leftovers for forgotten 
and unused tuners?

"For North American digital cable reception of non-encrypted channels 
(whether Standard Definition or High Definition) using a pcHDTV HD3000 
or similar, the only fields which need data are 
sourceid,frequency,modulation and sistandard"

There's my answer. I think I'll throw this link into the comments.

More information about the mythtv-users mailing list