[mythtv-users] PIDs missing along with dvb_channel data

ikke ikke at surfeu.fi
Tue Mar 1 20:40:37 UTC 2005


Hello,

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?

Here's what's currently in my mysql tables, and you can see dvb_channel
and dvb_pid are empty. What should I put there? Here's a link where to
find channel data in our area: http://dvb.swelcom.fi/cable.php , there's
even linuxtv scan and VDR channels.conf file. In mysqldump first 9
channels are filled by mythfilldatabase and the rest with mythtvsetup
autotune.

---------&<---MYSQLDUMP-------------------
-- 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 (512,'17','17',1,'Yle1','TV
1','',0,'','1.katso.fi',0,32768,32768,32768,32768,'Default',0,1,'',0,NULL,NULL,NULL);
INSERT INTO channel VALUES (513,'33','33',1,'Yle2','TV
2','',0,'','2.katso.fi',0,32768,32768,32768,32768,'Default',0,1,'',0,NULL,NULL,NULL);
INSERT INTO channel VALUES (305,'49','49',1,'MTV3','MTV
3','',0,'','3.katso.fi',0,32768,32768,32768,32768,'Default',0,1,'',0,NULL,NULL,NULL);
INSERT INTO channel VALUES
(514,'81','81',1,'Svedu','FST','',0,'','fst.katso.fi',0,32768,32768,32768,32768,'Default',0,1,'',0,NULL,NULL,NULL);
INSERT INTO channel VALUES
(304,'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
(516,'225','225',1,'Neppa+','Nelonen+','',0,'','nel.katso.fi',0,32768,32768,32768,32768,'Default',0,1,'',0,NULL,NULL,NULL);
INSERT INTO channel VALUES
(353,'97','97',1,'Subba','Subtv','',0,'','subtv.katso.fi',0,32768,32768,32768,32768,'Default',0,1,'',0,NULL,NULL,NULL);
INSERT INTO channel VALUES
(417,'113','113',1,'Urkka','Urheilukanava','',0,'','urh.katso.fi',0,32768,32768,32768,32768,'Default',0,1,'',0,NULL,NULL,NULL);
INSERT INTO channel VALUES
(515,'129','129',1,'Yle24','YLE24','',0,'','y24.katso.fi',0,32768,32768,32768,32768,'Default',0,1,'',0,NULL,NULL,NULL);
INSERT INTO channel VALUES
(517,'113',NULL,1,'Urheilukanava','Urheilukanava','none',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,8,113,0);
INSERT INTO channel VALUES (518,'241',NULL,1,'The Voice','The
Voice','none',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,8,241,0);
INSERT INTO channel VALUES
(519,'1973',NULL,1,'Infokanava','Infokanava','none',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,8,1973,0);
INSERT INTO channel VALUES (520,'49',NULL,1,'MTV3 D','MTV3
D','none',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,9,49,0);
INSERT INTO channel VALUES (521,'65',NULL,1,'Nelonen D','Nelonen
D','none',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,9,65,0);
INSERT INTO channel VALUES
(522,'97',NULL,1,'subtv','subtv','none',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,9,97,0);
INSERT INTO channel VALUES (523,'225',NULL,1,'Nelonen Plus','Nelonen
Plus','none',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,9,225,0);
INSERT INTO channel VALUES
(524,'17',NULL,1,'TV1','TV1','none',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,10,17,0);
INSERT INTO channel VALUES
(525,'33',NULL,1,'TV2','TV2','none',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,10,33,0);
INSERT INTO channel VALUES
(526,'81',NULL,1,'FST','FST','none',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,10,81,0);
INSERT INTO channel VALUES
(527,'129',NULL,1,'YLE24','YLE24','none',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,10,129,0);
INSERT INTO channel VALUES (528,'145',NULL,1,'YLE Teema','YLE
Teema','none',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,10,145,0);

--
-- Table structure for table `dvb_channel`
--

CREATE TABLE dvb_channel (
  chanid smallint(6) NOT NULL default '0',
  serviceid smallint(6) default NULL,
  networkid smallint(6) default NULL,
  providerid smallint(6) default NULL,
  transportid smallint(6) default NULL,
  frequency int(11) default NULL,
  inversion char(1) default NULL,
  symbolrate int(11) default NULL,
  fec varchar(10) default NULL,
  polarity char(1) default NULL,
  satid smallint(6) default NULL,
  modulation varchar(10) default NULL,
  bandwidth char(1) default NULL,
  lp_code_rate varchar(10) default NULL,
  transmission_mode char(1) default NULL,
  guard_interval varchar(10) default NULL,
  hierarchy char(1) default NULL,
  pmtcache blob,
  PRIMARY KEY  (chanid)
) TYPE=MyISAM;

--
-- Dumping data for table `dvb_channel`
--



--
-- Table structure for table `dvb_pids`
--

CREATE TABLE dvb_pids (
  chanid smallint(6) NOT NULL default '0',
  pid smallint(6) NOT NULL default '0',
  type char(1) NOT NULL default 'o',
  lang char(3) NOT NULL default '',
  PRIMARY KEY  (chanid,pid)
) TYPE=MyISAM;

--
-- Dumping data for table `dvb_pids`
--
---------&<-----MYSQLDUMP-----------------

this is what mythbackend keeps complaining:

2005-03-01 22:31:32.990 Changing from None to WatchingLiveTV
2005-03-01 22:31:33.002 DVB#0 Recorder: Card opened successfully (using
PS mode).
2005-03-01 22:31:33.004 DVB#0 CA: SetPMT for ServiceID=0
2005-03-01 22:31:33.004 DVB#0 ERROR - No PIDS set, please correct your
channel setup.
2005-03-01 22:31:34.005 DVB#0 WARNING - No data from card in 1 second.



Board works technically fine, I can see picture with czap and tvtime.
Some more info:
mythtv-0.17-95.rhfc3.at (latest from atrpms)
OS: FC3
dvb-c:  Philips Semiconductors SAA7146 (rev 01), some technotrend board 2100





More information about the mythtv-users mailing list