[mythtv-users] HD Homerun Prime Scripting

Kirk Bocek t004 at kbocek.com
Tue Oct 18 15:48:10 UTC 2011

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.

More information about the mythtv-users mailing list