[mythtv] DVB-T

Paul Woodward paul_woodward at fastnet.co.uk
Thu Dec 11 18:48:24 EST 2003 

You've posted to the dev forum which really isn't the place for setup
queries.

1. Look in the archives for the last week of the users forum. You should
see a post from me that contains full insert statements to set up your
channels in the database.

2. try this: (not perfect but will get you going...)
This is for the Crystal Palace, London transmitter, but it should give
you an idea of what is required.

> # phpMyAdmin SQL Dump
> # version 2.5.4
> # http://www.phpmyadmin.net
> #
> # Host: localhost
> # Generation Time: Dec 08, 2003 at 12:48 PM
> # Server version: 4.0.15
> # PHP Version: 4.3.3
> #
> # Database : `mythconverg`
> #
>
> #
> # Dumping data for table `channel`
> #
>
> INSERT INTO `channel` (`chanid`, `channum`, `freqid`, `sourceid`, 
> `callsign`, `name`, `icon`, `finetune`, `videofilters`, `xmltvid`, 
> `recpriority`, `contrast`, `brightness`, `colour`, `hue`) VALUES 
> (1007, '8', '', 1, '', 'The HIts', 
> '/root/.mythtv/channels/logo-744.gif', 0, NULL, 
> '744.tv-listings.ananova.com', 0, 32768, 32768, 32768, 32768), (1009, 
> '', '', 1, '', 'Radio 5 Live Extra', 
> '/root/.mythtv/channels/logo-745.gif', 0, NULL, 
> '745.tv-listings.ananova.com', 0, 32768, 32768, 32768, 32768), (1014, 
> '7', '', 1, '', 'BBC3', '/root/.mythtv/channels/logo-935.gif', 0, 
> NULL, 'bbc3.bbc.co.uk', 0, 32768, 32768, 32768, 32768), (1015, '3', 
> '3', 1, '', 'ITV1 (ITV1 London)', 
> '/root/.mythtv/channels/logo-49.gif', 0, NULL, 'carlton.com', 0, 
> 32768, 32768, 32768, 32768), (1016, '', '', 1, '', 'CBBC', 
> '/root/.mythtv/channels/logo-733.gif', 0, NULL, 'cbbc.bbc.co.uk', 0, 
> 32768, 32768, 32768, 32768), (1017, '', '', 1, '', 'CBeebies', 
> '/root/.mythtv/channels/logo-734.gif', 0, NULL, 'cbeebies.bbc.co.uk', 
> 0, 32768, 32768, 32768, 32768), (1018, '4', '4', 1, '', 'Channel 4', 
> '/root/.mythtv/channels/logo-53.gif', 0, NULL, 'channel4.com', 0, 
> 32768, 32768, 32768, 32768), (1019, '5', '5', 1, '', 'five', 
> '/root/.mythtv/channels/logo-54.gif', 0, NULL, 'channel5.co.uk', 0, 
> 32768, 32768, 32768, 32768), (1020, '', '', 1, '', 'Classic FM', 
> '/root/.mythtv/channels/logo-228.gif', 0, NULL, 'classicfm.co.uk', 0, 
> 32768, 32768, 32768, 32768), (1021, '24', 'R4FM', 1, '', 'Radio 4 
> (FM)', '/root/.mythtv/channels/logo-33.gif', 0, NULL, 
> 'fm.radio-4.bbc.co.uk', 0, 32768, 32768, 32768, 32768), (1023, '12', 
> '', 1, '', 'ITV News Channel', '/root/.mythtv/channels/logo-616.gif', 
> 0, NULL, 'itn.co.uk', 0, 32768, 32768, 32768, 32768), (1024, '6', '', 
> 1, '', 'ITV2', '/root/.mythtv/channels/logo-451.gif', 0, NULL, 
> 'itv2.itv.co.uk', 0, 32768, 32768, 32768, 32768), (1026, '1', '1', 1, 
> '', 'BBC1 (London)', '/root/.mythtv/channels/logo-713.gif', 0, NULL, 
> 'london.bbc1.bbc.co.uk', 0, 32768, 32768, 32768, 32768), (1027, '2', 
> '2', 1, '', 'BBC2 (London)', '/root/.mythtv/channels/logo-724.gif', 0,

> NULL, 'london.bbc2.bbc.co.uk', 0, 32768, 32768, 32768, 32768), (1030, 
> '10', '', 1, '', 'BBC News 24', '/root/.mythtv/channels/logo-85.gif', 
> 0, NULL, 'news-24.bbc.co.uk', 0, 32768, 32768, 32768, 32768), (1031, 
> '13', '', 1, '', 'Sky Sports News', 
> '/root/.mythtv/channels/logo-231.gif', 0, NULL, 'news.sports.sky.com',

> 0, 32768, 32768, 32768, 32768), (1000, '9', '', 1, '0', 'TMF', 
> '/root/.mythtv/channels/logo-422.gif', 0, NULL, '', 0, 32768, 32768, 
> 32768, 32768), (1034, '21', 'R1', 1, '', 'Radio 1', 
> '/root/.mythtv/channels/logo-77.gif', 0, NULL, 'radio-1.bbc.co.uk', 0,

> 32768, 32768, 32768, 32768), (1035, '22', 'R2', 1, '', 'Radio 2', 
> '/root/.mythtv/channels/logo-86.gif', 0, NULL, 'radio-2.bbc.co.uk', 0,

> 32768, 32768, 32768, 32768), (1036, '23', 'R3', 1, '', 'Radio 3', 
> '/root/.mythtv/channels/logo-8.gif', 0, NULL, 'radio-3.bbc.co.uk', 0, 
> 32768, 32768, 32768, 32768), (1037, 'R5', 'R5', 1, '', 'Radio 5 Live',

> '/root/.mythtv/channels/logo-87.gif', 0, NULL, 'radio-5.bbc.co.uk', 0,

> 32768, 32768, 32768, 32768), (1043, '11', '', 1, '', 'Sky News', 
> '/root/.mythtv/channels/logo-114.gif', 0, NULL, 'sky-news.sky.com', 0,

> 32768, 32768, 32768, 32768), (1013, '', '', 1, '', 'BBC7', 
> '/root/.mythtv/channels/logo-932.gif', 0, NULL, 
> '932.tv-listings.ananova.com', 0, 32768, 32768, 32768, 32768), (1025, 
> 'BBC4', 'BBC4', 1, '', 'BBC4', '/root/.mythtv/channels/logo-742.gif', 
> 0, NULL, 'knowledge.bbc.co.uk', 0, 32768, 32768, 32768, 32768);
>
>
> # phpMyAdmin SQL Dump
> # version 2.5.4
> # http://www.phpmyadmin.net
> #
> # Host: localhost
> # Generation Time: Dec 08, 2003 at 12:49 PM
> # Server version: 4.0.15
> # PHP Version: 4.3.3
> #
> # Database : `mythconverg`
> #
>
> #
> # Dumping data for table `dvb_channel`
> #
>
> INSERT INTO `dvb_channel` (`chanid`, `serviceid`, `networkid`, 
> `providerid`, `transportid`, `frequency`, `inversion`, `symbolrate`, 
> `fec`, `polarity`, `satid`, `modulation`, `bandwidth`, `lp_code_rate`,

> `transmission_mode`, `guard_interval`, `hierarchy`) VALUES (1026, 
> 4164, NULL, 0, NULL, 505833333, '0', NULL, '3/4', 'V', NULL, '16', 
> '8', 'auto', '2', '1/32', 'n'), (1015, 8617, NULL, 0, NULL, 481833333,

> '0', NULL, '2/3', 'V', NULL, '64', '8', NULL, '2', '1/32', 'n'), 
> (1027, 4227, NULL, 0, NULL, 505833333, '0', NULL, '3/4', 'V', NULL, 
> '16', '8', NULL, '2', '1/32', 'n'), (1018, 8384, NULL, 0, NULL, 
> 481833333, '0', NULL, '2/3', 'V', NULL, '64', '8', NULL, '2', '1/32', 
> 'n'), (1019, 12866, NULL, 0, NULL, 561833333, '0', NULL, '2/3', 'V', 
> NULL, '64', '8', NULL, '2', '1/32', 'n'), (1024, 8325, NULL, 0, NULL, 
> 481833333, '0', NULL, '1/2', 'V', NULL, '64', '8', NULL, '2', '1/32', 
> 'n'), (1014, 4351, NULL, 0, NULL, 505833333, '0', NULL, '3/4', 'V', 
> NULL, '16', '8', NULL, '2', '1/32', 'n'), (1034, 14336, NULL, 0, NULL,

> 561833333, '0', NULL, '2/3', 'V', NULL, '64', '8', 'auto', '2', 
> '1/32', 'n'), (1030, 4415, NULL, 0, NULL, 505833333, '0', NULL, '3/4',

> 'V', NULL, '16', '8', NULL, '2', '1/32', 'n'), (1043, 22080, NULL, 0, 
> NULL, 578166666, '0', NULL, '3/4', 'V', NULL, '16', '8', NULL, '2', 
> '1/32', 'n'), (1035, 14400, NULL, 0, NULL, 561833333, '0', NULL, 
> '2/3', 'V', NULL, '64', '8', 'auto', '2', '1/32', 'n'), (1036, 14464, 
> NULL, 0, NULL, 561833333, '0', NULL, '2/3', 'V', NULL, '64', '8', 
> 'auto', '2', '1/32', 'n'), (1021, 14528, NULL, 0, NULL, 561833333, 
> '0', NULL, '2/3', 'V', NULL, '64', '8', 'auto', '2', '1/32', 'n'), 
> (1023, 8581, NULL, 0, NULL, 481833333, '0', NULL, '2/3', 'V', NULL, 
> '64', '8', 'auto', '2', '1/32', 'n'), (1007, 25664, 0, 0, 0, 
> 537833333, '0', 0, 'auto', 'v', 0, 'auto', '8', 'none', '8', 'auto', 
> 'n'), (1009, NULL, NULL, NULL, NULL, NULL, 'a', NULL, 'auto', 'h', 0, 
> 'auto', 'a', 'auto', 'a', 'auto', 'a'), (1037, NULL, NULL, NULL, NULL,

> NULL, 'a', NULL, 'auto', 'h', 0, 'auto', 'a', 'auto', 'a', 'auto', 
> 'a'), (1000, 25728, NULL, NULL, NULL, 537833333, '0', 0, 'auto', 'v', 
> 0, 'auto', '8', 'none', 'a', 'auto', 'n');
>
>
> # phpMyAdmin SQL Dump
> # version 2.5.4
> # http://www.phpmyadmin.net
> #
> # Host: localhost
> # Generation Time: Dec 08, 2003 at 12:49 PM
> # Server version: 4.0.15
> # PHP Version: 4.3.3
> #
> # Database : `mythconverg`
> #
>
> #
> # Dumping data for table `dvb_pids`
> #
>
> INSERT INTO `dvb_pids` (`chanid`, `pid`, `type`, `lang`) VALUES (1026,

> 600, 'v', ''), (1026, 601, 'a', ''), (1015, 512, 'v', ''),
> (1015, 650, 'a', ''),
> (1027, 610, 'v', ''),
> (1027, 611, 'a', ''),
> (1018, 2827, 'v', ''),
> (1018, 2828, 'a', ''),
> (1019, 6017, 'v', ''),
> (1019, 6018, 'a', ''),
> (1024, 2818, 'v', ''),
> (1024, 2819, 'a', ''),
> (1014, 620, 'v', ''),
> (1014, 621, 'a', ''),
> (1034, 6210, 'a', ''),
> (1030, 640, 'v', ''),
> (1030, 641, 'a', ''),
> (1043, 101, 'v', ''),
> (1043, 102, 'a', ''),
> (1035, 6226, 'a', ''),
> (1036, 6242, 'a', ''),
> (1021, 6258, 'a', ''),
> (1023, 2850, 'v', ''),
> (1023, 2851, 'a', ''),
> (1007, 101, 'v', ''),
> (1007, 102, 'a', ''),
> (1000, 201, 'v', ''),
> (1000, 202, 'a', ''),
> (1034, 0, 'v', ''),
> (1035, 0, 'v', ''),
> (1036, 0, 'v', '');

Paul

-----Original Message-----
From: mythtv-dev-bounces at mythtv.org
[mailto:mythtv-dev-bounces at mythtv.org] On Behalf Of Dave Gartside
Sent: 11 December 2003 22:18
To: 'mythtv-dev at mythtv.org'
Subject: [mythtv] DVB-T

Hi guys, I'm new to the whole mythtv scene, myth looks great however I
have
a bit of a problem.

I am using a NOVA-T dvb card which is working with the latest CVS dvb
drivers on the latest fresh kernel from kernel.org 2.4.23. I have got
myth
compiled and running from CVS however I don't seem to have entries in
the
sql database for audio/video pids. I have tried running Kenneth's
channel
editor program/patch against the CVS and latest build release, but the
patch
fails on mythwidgets.cpp and compilation aborts. Kenneth's website
appears
to have disappeared so I don't know if there is an update.


Any help would be great as I am desperate to get this going as I can see
just how polished it looks!

Thanks....

Dave.


**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**********************************************************************


---

Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.548 / Virus Database: 341 - Release Date: 05/12/2003

More information about the mythtv-dev mailing list