[mythtv-users] Part Two of my Myth DVB Setup Guide Posted

[Malcolm Smith]

This is really good.

Having figured this route out myself as well, I would agree with most of the
steps.

I have a couple of additions. I have a dual card setup - 1 analgoue Bt878
and a Nova-t card.


I used this SQL

SELECT @videosourceid:=sourceid FROM videosource WHERE name="Freeview";
SELECT @freq:='754166670';
SELECT @vpid:='600';
SELECT @apid:='601';
SELECT @tpid:='4168';
SELECT @channame:="%BBC1%";

SELECT @channelid:=chanid  FROM channel  WHERE (sourceid=@videosourceid AND
name LIKE @channame);
REPLACE INTO dvb_channel VALUES
(@channelid,NULL,NULL,NULL,NULL, at freq,'0',6900000,'2/3','V',NULL,'qam_64','8
','2/3','1/2','2','1/32','n','auto', at vpid, at apid ,
@tpid,NULL,NULL,NULL,NULL);
REPLACE INTO dvb_pids VALUES (@channelid, at vpid,'v','');
REPLACE INTO dvb_pids VALUES (@channelid, at apid,'a','');

The key differences are
 1. I ensure that a pick the channel id associated with this video source
 2. I do a fuzzy match  name LIKE channame
 3. I do a "REPLACE" rather than INSERT, handy if you keep trying to get it
right, you don't end up with multiple rows (REPLACE does INSERT if no row
already exists).

Another thing regarding off air channels. Does you backend crash when you
try to view live TV on an off air channel (e.g. BBC3).

-malc-
> -----Original Message-----
> From: mythtv-users-bounces at mythtv.org
> [mailto:mythtv-users-bounces at mythtv.org]On Behalf Of Terry Barnaby
> Sent: Friday, January 09, 2004 4:00 PM
> To: Discussion about mythtv
> Subject: Re: [mythtv-users] Part Two of my Myth DVB Setup Guide Posted
>
>
> Martin,
>
> I have read through it to help me with getting DVB to work.
> Some feed back: THANKS ! it helps a lot.
> Could it be put on the www.mythtv.org web site under documents
> so people can find it please ?
>
> Cheers for the work
>
> Terry
>
> Kenneth Aafløy wrote:
> > Hi!
> >
> > Martin Smith wrote:
> >
> >>I've just posted a draft of part 2 of my Myth DVB setup guide.
> >>The original part one:
> >>http://www.ethics-gradient.net/myth/mythdvb.html
> >>
> >>Covered aspects of DVB hardware and driver installation.
> >>The new part can be found at:
> >>http://www.ethics-gradient.net/myth/mythdvb2.html
> >>
> >>As Myth DVB support is much further along than back in August
> >>I've written about migrating my anlogue PVR 250 to a dual
> >>DVB-T card setup.
> >>
> >>As I'm doing this in a cautious manner (I don't want to be
> >>without MythTV at any point if I can help it) I'm still testing
> >>the DVB card before yanking the analogue one. This means the
> >>part 2 document isn't complete yet but there's enough there to
> >>make it worth posting for people to read. I'll post an update
> >>when I'm happy its all working, or I've given up on it - let's
> >>hope it's the former!
> >
> >
> > I've read through it, and it seems like a good start. Maybe add
> > a section with a short description of all DVB parameters, and
> > their relation to each other and the database.
> >
> > I also notice that you bring forth errors or bugs in the doc,
> > please post a summary of these in mythtv-dev (we can't fix bugs
> > we don't know exists, you know...)
> >
> >
> >>I hope some people find this useful. I've had a lot of hits on
> >>the original document but little feedback.
> >
> >
> > I distinctly remember contacting you about the first bit, but
> > never received a response from you.
> >
> > Kenneth
> >
> > _______________________________________________
> > mythtv-users mailing list
> > mythtv-users at mythtv.org
> > http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
> >
>
> --
> Dr Terry Barnaby                     BEAM Ltd
> Phone: +44 1454 324512               Northavon Business Center, Dean Rd
> Fax:   +44 1454 313172               Yate, Bristol, BS37 5NH, UK
> Email: terry at beam.ltd.uk             Web: www.beam.ltd.uk
> BEAM for: Visually Impaired X-Terminals, Parallel Processing, Software
>                        "Tandems are twice the fun !"
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>