[mythtv-users] HDTV reception via Cable
R. G. Newbury
newbury at mandamus.org
Mon Apr 3 19:31:08 UTC 2006
Jeffrey R. Born wrote:
> I don’t have anything in the dtv_multiplex table after going through all
> the setup for a pcHDTV card. I can’t seem to find a place to reimport
> information from a channels.conf. Not even sure that would load that
> table. I found this because 1 HD playback in myth is not working yet
> and I went hunting in the lists for missed steps. It seemed reasonable
> to follow Geoff’s advice and to verify and modify the information in
> this table to match the channels conf information.
>
>
>
> Any ideas how to rebuild this information?
This is in the archive already.....
Open mysql to the mythconverg database
#mysql -u mythtv -pmythtv mythconverg;
> describe [tablename] will show you the names of the columns in a table
Then
>select * from dtv_multiplex;
I assume your sourceid is "2": that is your chanid's are like 2118.
IF there are no entries, then:
>insert into dtv_multiplex (sourceid, frequency, modulation) values
("2","525000000","QAM_256);
Repeat for each frequency. I only have 9 rows in this table.
IF there are entries and you want to blow them all away, you can:
> delete from dtv_multiplex where fec ="AUTO"; (or any other column
where all the values are the same....Then repeat as above.
To change the channel table, you need something like:
> update channel set sourceid="2", mplexid="1", serviceid="34" where
chanid = 2118;
etc....(29 times or whatever the number is!. Take your time and be
careful in making the entries. I jumped a line the first time although
that was no apparent for a while...when I could not tune a channel.
Then I made a printout of channels.conf, checked the mplexid entries
carefully and worked down line by line entering the channel info.
Still took me about 2 weeks to actually get the callsigns matched up
properly. I get 6 or 7 CBC feeds and 5 CTV feeds, and most of the time
they have the same stuff playing, so it was a matter of actually
watching commercials (ugh!) to figure out where the station was and then
adjust the callsigns properly!
Geoff
More information about the mythtv-users
mailing list