[mythtv-users] PIDs missing along with dvb_channel data
ikke
ikke at surfeu.fi
Wed Mar 2 22:06:18 UTC 2005
On Thu, Mar 03, 2005 at 12:06:15AM +1100, Hamish Moffatt wrote:
> On Tue, Mar 01, 2005 at 10:40:37PM +0200, ikke wrote:
> > can you please help me set up mythtv with my dvb-c card? The problem is
> > that the backend does complain that no pids are set. And when I look
> > into mysql database converge table I see there is nothing in either
> > dvb_channel or dvb_pids tables. Channel table gets filled nicely with
> > both `mythfilldatabase --manual` and the autotune feature in
> > mythtvconfig. I use tv_grab_fi for my local HTV cable company settings.
> >
> > What's wrong in mythtv or me when these both setup programs fail to fill
> > those two tables?
>
> Those tables aren't used any more as of 0.17.
>
> After upgrading you need to set up your channels from scratch. Use the
> setup program and do a scan.
>
> In the sql dump, the dtv_multiplex table would be more interesting.
>
> Hamish
Thanks for responding, I'm still stuck here. Been redoing the configs night after night. I never upgraded from previous, this is the first install. I grabbed the latest rpms which happened to be 0.17. Ok, so that's why tables were empty.
Do I need to use the mythfilldatabase --manual, or the mythtvsetup autoconfig? Mythfilldatabase fills the TV program info just fine, I can set programs for recording. They just never get recorded because mythbackend complains about missing pids.
This time I used only the mythfilldatabase method. Here is an example of a channel creation dialog:
----&<----- mythfilldatabase --------
Choose a channel ID (positive integer) [0] 1
Choose a channel name (any string, long version) [TV 1]
Choose a channel callsign (any string, short version) TV1
Choose a channel number (just like xawtv) 17
Choose a channel fine tune offset (just like xawtv)
Choose a TV format (PAL/SECAM/NTSC/ATSC/Default) [Default]
Choose a channel icon image (any path name)
----&<----- mythfilldatabase --------
Like said I got the info from here: http://dvb.swelcom.fi/cable.php , and I need to use tv_grab_fi for mythfilldatabase, which forces it to be done manually.
The table dump:
----&<----- mythconverg --------
-- MySQL dump 8.23
--
-- Host: localhost Database: mythconverg
---------------------------------------------------------
-- Server version 3.23.58
--
-- Table structure for table `channel`
--
CREATE TABLE channel (
chanid int(10) unsigned NOT NULL default '0',
channum varchar(5) NOT NULL default '',
freqid varchar(10) default NULL,
sourceid int(10) unsigned default NULL,
callsign varchar(20) NOT NULL default '',
name varchar(64) NOT NULL default '',
icon varchar(255) NOT NULL default 'none',
finetune int(11) default NULL,
videofilters varchar(255) NOT NULL default '',
xmltvid varchar(64) NOT NULL default '',
recpriority int(10) NOT NULL default '0',
contrast int(11) default '32768',
brightness int(11) default '32768',
colour int(11) default '32768',
hue int(11) default '32768',
tvformat varchar(10) NOT NULL default 'Default',
commfree tinyint(4) NOT NULL default '0',
visible tinyint(1) NOT NULL default '1',
outputfilters varchar(255) NOT NULL default '',
useonairguide tinyint(1) default '0',
mplexid smallint(6) default NULL,
serviceid smallint(6) default NULL,
atscsrcid int(11) default NULL,
PRIMARY KEY (chanid),
KEY channel_src (channum,sourceid)
) TYPE=MyISAM;
--
-- Dumping data for table `channel`
--
INSERT INTO channel VALUES (1,'17','17',1,'TV1','TV 1','',0,'','1.katso.fi',0,32768,32768,32768,32768,'Default',0,1,'',0,NULL,NULL,NULL);
INSERT INTO channel VALUES (2,'33','33',1,'TV2','TV 2','',0,'','2.katso.fi',0,32768,32768,32768,32768,'Default',0,1,'',0,NULL,NULL,NULL);
INSERT INTO channel VALUES (3,'49','49',1,'MTV3 D','MTV 3','',0,'','3.katso.fi',0,32768,32768,32768,32768,'Default',0,1,'',0,NULL,NULL,NULL);
INSERT INTO channel VALUES (4,'65','65',1,'Nelonen D','Nelonen','',0,'','4.katso.fi',0,32768,32768,32768,32768,'Default',0,1,'',0,NULL,NULL,NULL);
INSERT INTO channel VALUES (5,'81','81',1,'FST','FST','',0,'','fst.katso.fi',0,32768,32768,32768,32768,'Default',0,1,'',0,NULL,NULL,NULL);
INSERT INTO channel VALUES (6,'209','209',1,'MTV3+','MTV3+','',0,'','mv3.katso.fi',0,32768,32768,32768,32768,'Default',0,1,'',0,NULL,NULL,NULL);
INSERT INTO channel VALUES (7,'225','225',1,'Nelonen Plus','Nelonen+','',0,'','nel.katso.fi',0,32768,32768,32768,32768,'Default',0,1,'',0,NULL,NULL,NULL);
INSERT INTO channel VALUES (8,'97','97',1,'subtv','Subtv','',0,'','subtv.katso.fi',0,32768,32768,32768,32768,'Default',0,1,'',0,NULL,NULL,NULL);
INSERT INTO channel VALUES (9,'145','145',1,'YLE Teema','Yle Teema','',0,'','tma.katso.fi',0,32768,32768,32768,32768,'Default',0,1,'',0,NULL,NULL,NULL);
INSERT INTO channel VALUES (10,'113','113',1,'Urheilukanava','Urheilukanava','',0,'','urh.katso.fi',0,32768,32768,32768,32768,'Default',0,1,'',0,NULL,NULL,NULL);
INSERT INTO channel VALUES (11,'129','129',1,'YLE24','YLE24','',0,'','y24.katso.fi',0,32768,32768,32768,32768,'Default',0,1,'',0,NULL,NULL,NULL);
--
-- Table structure for table `dtv_multiplex`
--
CREATE TABLE dtv_multiplex (
mplexid smallint(6) NOT NULL auto_increment,
sourceid smallint(6) default NULL,
transportid int(11) default NULL,
networkid int(11) default NULL,
frequency int(11) default NULL,
inversion char(1) default 'a',
symbolrate int(11) default NULL,
fec varchar(10) default 'auto',
polarity char(1) default NULL,
modulation varchar(10) default 'auto',
bandwidth char(1) default 'a',
lp_code_rate varchar(10) default 'auto',
transmission_mode char(1) default 'a',
guard_interval varchar(10) default 'auto',
visible smallint(1) NOT NULL default '0',
constellation varchar(10) default 'auto',
hierarchy varchar(10) default 'auto',
hp_code_rate varchar(10) default 'auto',
sistandard varchar(10) default 'dvb',
serviceversion smallint(6) default '33',
updatetimestamp timestamp(14) NOT NULL,
PRIMARY KEY (mplexid)
) TYPE=MyISAM;
--
-- Dumping data for table `dtv_multiplex`
--
INSERT INTO dtv_multiplex VALUES (1,1,10,0,367000000,'a',5900000,'none','','qam_128','a','auto','a','auto',0,'auto','a','auto','dvb',27,20050301001146);
INSERT INTO dtv_multiplex VALUES (2,1,9,0,276000000,'a',5900000,'none','','qam_128','a','auto','a','auto',0,'auto','a','auto','dvb',24,20050301001150);
INSERT INTO dtv_multiplex VALUES (3,1,8,0,138000000,'a',6900000,'none','','qam_128','a','auto','a','auto',0,'auto','a','auto','dvb',6,20050301001153);
INSERT INTO dtv_multiplex VALUES (4,1,7,0,154000000,'a',6900000,'none','','qam_128','a','auto','a','auto',0,'auto','a','auto','dvb',13,20050301001159);
INSERT INTO dtv_multiplex VALUES (5,1,6,0,146000000,'a',6900000,'none','','qam_128','a','auto','a','auto',0,'auto','a','auto','dvb',11,20050301001203);
INSERT INTO dtv_multiplex VALUES (6,1,5,0,297000000,'a',5900000,'none','','qam_128','a','auto','a','auto',0,'auto','a','auto','dvb',5,20050301001206);
INSERT INTO dtv_multiplex VALUES (7,1,4,0,170000000,'a',6900000,'none','','qam_128','a','auto','a','auto',0,'auto','a','auto','dvb',26,20050301001210);
INSERT INTO dtv_multiplex VALUES (8,1,3,15,162000000,'a',6900000,'none','','qam_64','a','auto','a','auto',0,'auto','a','auto','dvb',22,20050301001214);
INSERT INTO dtv_multiplex VALUES (9,1,2,0,290000000,'a',5900000,'none','','qam_128','a','auto','a','auto',0,'auto','a','auto','dvb',29,20050301001218);
INSERT INTO dtv_multiplex VALUES (10,1,1,0,283000000,'a',5900000,'none','','qam_128','a','auto','a','auto',0,'auto','a','auto','dvb',15,20050301001222);
INSERT INTO dtv_multiplex VALUES (11,1,18,0,262000000,'a',5900000,'none','','qam_128','a','auto','a','auto',0,'auto','a','auto','dvb',10,20050301001225);
INSERT INTO dtv_multiplex VALUES (12,1,17,0,269000000,'a',5900000,'none','','qam_128','a','auto','a','auto',0,'auto','a','auto','dvb',15,20050301001229);
INSERT INTO dtv_multiplex VALUES (13,1,16,0,388000000,'a',5900000,'none','','qam_128','a','auto','a','auto',0,'auto','a','auto','dvb',8,20050301001234);
INSERT INTO dtv_multiplex VALUES (14,1,15,0,395000000,'a',5900000,'none','','qam_128','a','auto','a','auto',0,'auto','a','auto','dvb',27,20050301001239);
INSERT INTO dtv_multiplex VALUES (15,1,14,0,381000000,'a',5900000,'none','','qam_128','a','auto','a','auto',0,'auto','a','auto','dvb',8,20050301001242);
INSERT INTO dtv_multiplex VALUES (16,1,13,0,374000000,'a',5900000,'none','','qam_128','a','auto','a','auto',0,'auto','a','auto','dvb',25,20050301001246);
INSERT INTO dtv_multiplex VALUES (17,1,12,0,332000000,'a',5900000,'none','','qam_128','a','auto','a','auto',0,'auto','a','auto','dvb',24,20050301001250);
INSERT INTO dtv_multiplex VALUES (18,1,11,0,325000000,'a',5900000,'none','','qam_128','a','auto','a','auto',0,'auto','a','auto','dvb',33,20050301001141);
----&<----- mythconverg --------
More information about the mythtv-users
mailing list