[mythtv-users] HD Homerun Prime Scripting
ozzy.lash at gmail.com
Tue Oct 18 15:54:46 UTC 2011
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, 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.
> 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
Well, there is:
But I'm not sure how much extra info this gives.
More information about the mythtv-users