[mythtv] Re: CVS not switching to correct input
matt.jarvis at philips.com
matt.jarvis at philips.com
Wed Aug 6 11:08:35 EDT 2003
Isaac
I've reinstalled from scratch, clean install of RH9 and mythcvs as of last
night ( Tuesday ). The ioctl message has now gone away but it's still not
switching to the correct input. As the composite 1 input is the only one
with any channels defined, I'm assuming this is something to do with the
channels in the database. I've attached a mysqldump with five channels
that I'm using to test. Just to confirm xawtv works fine, and if I set the
default input on the card to any of the other inputs ( whilst leaving the
input connection linked to composite 1 ) it will start on the input I
defined in setup and I can then switch back to composite 1 using c and
myth works fine. V.odd. BTW the only thing I deviated from in the docs is
to use the rpms to install xmltv, could this be the cause ? I've snipped
the program entries out of the dump, if you need the full dump let me
know.
Thanks for your help
Matt
-------------- next part --------------
-- MySQL dump 8.22
--
-- Host: localhost Database: mythconverg
---------------------------------------------------------
-- Server version 3.23.54
--
-- Table structure for table 'capturecard'
--
CREATE TABLE capturecard (
cardid int(10) unsigned NOT NULL auto_increment,
videodevice varchar(128) default NULL,
audiodevice varchar(128) default NULL,
vbidevice varchar(128) default NULL,
cardtype varchar(32) default 'V4L',
defaultinput varchar(32) default 'Television',
audioratelimit int(11) default NULL,
hostname varchar(255) default NULL,
use_ts int(11) default NULL,
dvb_type char(1) default NULL,
PRIMARY KEY (cardid)
) TYPE=MyISAM;
--
-- Dumping data for table 'capturecard'
--
INSERT INTO capturecard VALUES (1,'/dev/video0','/dev/dsp','/dev/vbi','V4L','Composite1',0,'videoserver',NULL,NULL);
--
-- Table structure for table 'cardinput'
--
CREATE TABLE cardinput (
cardinputid int(10) unsigned NOT NULL auto_increment,
cardid int(10) unsigned NOT NULL default '0',
sourceid int(10) unsigned NOT NULL default '0',
inputname varchar(32) NOT NULL default '',
externalcommand varchar(128) default NULL,
preference int(11) default NULL,
shareable char(1) default 'N',
tunechan varchar(5) NOT NULL default '',
startchan varchar(5) NOT NULL default '',
PRIMARY KEY (cardinputid)
) TYPE=MyISAM;
--
-- Dumping data for table 'cardinput'
--
INSERT INTO cardinput VALUES (1,1,1,'Composite1','/usr/local/bin/channelchange',NULL,'N','','103');
--
-- Table structure for table 'channel'
--
CREATE TABLE channel (
chanid int(10) unsigned NOT NULL default '0',
channum varchar(5) NOT NULL default '',
freqid varchar(5) NOT NULL default '',
sourceid int(10) unsigned default NULL,
callsign varchar(20) default NULL,
name varchar(20) default NULL,
icon varchar(255) default NULL,
finetune int(11) default NULL,
videofilters varchar(255) default NULL,
xmltvid varchar(64) default NULL,
rank 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',
PRIMARY KEY (chanid)
) TYPE=MyISAM;
--
-- Dumping data for table 'channel'
--
INSERT INTO channel VALUES (103,'103','103',1,'ITV1','ITV1 (ITV1 London)','/root/.mythtv/channels/logo-49.gif',0,NULL,'carlton.com',0,32768,32768,32768,32768);
INSERT INTO channel VALUES (104,'104','104',1,'CH4','Channel 4','/root/.mythtv/channels/logo-53.gif',0,NULL,'channel4.com',0,32768,32768,32768,32768);
INSERT INTO channel VALUES (105,'105','105',1,'5','five','/root/.mythtv/channels/logo-54.gif',0,NULL,'channel5.co.uk',0,32768,32768,32768,32768);
INSERT INTO channel VALUES (101,'101','101',1,'BBC1','BBC1 (London)','/root/.mythtv/channels/logo-713.gif',0,NULL,'london.bbc1.bbc.co.uk',0,32768,32768,32768,32768);
INSERT INTO channel VALUES (102,'102','102',1,'BBC2','BBC2 (London)','/root/.mythtv/channels/logo-724.gif',0,NULL,'london.bbc2.bbc.co.uk',0,32768,32768,32768,32768);
--
-- Table structure for table 'channel_dvb'
--
CREATE TABLE channel_dvb (
chanid int(10) unsigned NOT NULL default '0',
listingid varchar(20) default NULL,
pids varchar(50) default NULL,
freq int(10) unsigned default NULL,
pol char(1) default 'V',
symbol_rate int(10) unsigned default NULL,
tone int(10) unsigned default NULL,
diseqc int(10) unsigned default NULL,
inversion varchar(10) default NULL,
bandwidth varchar(10) default NULL,
hp_code_rate varchar(10) default NULL,
lp_code_rate varchar(10) default NULL,
modulation varchar(10) default NULL,
transmission_mode varchar(10) default NULL,
guard_interval varchar(10) default NULL,
hierarchy varchar(10) default NULL,
PRIMARY KEY (chanid)
) TYPE=MyISAM;
--
-- Dumping data for table 'channel_dvb'
--
--
-- Table structure for table 'codecparams'
--
CREATE TABLE codecparams (
profile int(10) unsigned NOT NULL default '0',
name varchar(128) NOT NULL default '',
value varchar(128) default NULL,
PRIMARY KEY (profile,name)
) TYPE=MyISAM;
--
-- Dumping data for table 'codecparams'
--
INSERT INTO codecparams VALUES (2,'width','480');
INSERT INTO codecparams VALUES (2,'height','480');
INSERT INTO codecparams VALUES (2,'rtjpegquality','170');
INSERT INTO codecparams VALUES (2,'rtjpeglumafilter','0');
INSERT INTO codecparams VALUES (2,'rtjpegchromafilter','0');
INSERT INTO codecparams VALUES (2,'mpeg4bitrate','2200');
INSERT INTO codecparams VALUES (2,'mpeg4maxquality','2');
INSERT INTO codecparams VALUES (2,'mpeg4minquality','15');
INSERT INTO codecparams VALUES (2,'mpeg4qualdiff','3');
INSERT INTO codecparams VALUES (2,'mpeg4scalebitrate','1');
INSERT INTO codecparams VALUES (2,'mpeg4optionvhq','0');
INSERT INTO codecparams VALUES (2,'mpeg4option4mv','0');
INSERT INTO codecparams VALUES (2,'hardwaremjpegquality','100');
INSERT INTO codecparams VALUES (2,'hardwaremjpeghdecimation','4');
INSERT INTO codecparams VALUES (2,'hardwaremjpegvdecimation','4');
INSERT INTO codecparams VALUES (2,'samplerate','32000');
INSERT INTO codecparams VALUES (2,'mp3quality','7');
--
-- Table structure for table 'conflictresolutionany'
--
CREATE TABLE conflictresolutionany (
prefertitle varchar(128) NOT NULL default '',
disliketitle varchar(128) NOT NULL default '',
KEY prefertitle (prefertitle),
KEY disliketitle (disliketitle)
) TYPE=MyISAM;
--
-- Dumping data for table 'conflictresolutionany'
--
--
-- Table structure for table 'conflictresolutionoverride'
--
CREATE TABLE conflictresolutionoverride (
chanid int(10) unsigned NOT NULL default '0',
starttime timestamp(14) NOT NULL,
endtime timestamp(14) NOT NULL,
KEY chanid (chanid,starttime),
KEY endtime (endtime)
) TYPE=MyISAM;
--
-- Dumping data for table 'conflictresolutionoverride'
--
--
-- Table structure for table 'conflictresolutionsingle'
--
CREATE TABLE conflictresolutionsingle (
preferchanid int(10) unsigned NOT NULL default '0',
preferstarttime timestamp(14) NOT NULL,
preferendtime timestamp(14) NOT NULL,
dislikechanid int(10) unsigned NOT NULL default '0',
dislikestarttime timestamp(14) NOT NULL,
dislikeendtime timestamp(14) NOT NULL,
KEY preferchanid (preferchanid,preferstarttime),
KEY preferendtime (preferendtime)
) TYPE=MyISAM;
--
-- Dumping data for table 'conflictresolutionsingle'
--
--
-- Table structure for table 'credits'
--
CREATE TABLE credits (
person mediumint(8) unsigned NOT NULL default '0',
chanid int(10) unsigned NOT NULL default '0',
starttime timestamp(14) NOT NULL,
role set('actor','director','producer','executive_producer','writer','guest_star','host','adapter','presenter','commentator','guest') NOT NULL default '',
UNIQUE KEY chanid (chanid,starttime,person),
KEY person (person,role)
) TYPE=MyISAM;
--
-- Dumping data for table 'credits'
--
--
-- Table structure for table 'favorites'
--
CREATE TABLE favorites (
favid int(11) unsigned NOT NULL auto_increment,
userid int(11) unsigned NOT NULL default '0',
chanid int(11) unsigned NOT NULL default '0',
PRIMARY KEY (favid)
) TYPE=MyISAM;
--
-- Dumping data for table 'favorites'
--
--
-- Table structure for table 'oldrecorded'
--
CREATE TABLE oldrecorded (
chanid int(10) unsigned NOT NULL default '0',
starttime timestamp(14) NOT NULL,
endtime timestamp(14) NOT NULL,
title varchar(128) default NULL,
subtitle varchar(128) default NULL,
description text,
category varchar(64) default NULL,
PRIMARY KEY (chanid,starttime),
KEY endtime (endtime),
KEY title (title)
) TYPE=MyISAM;
--
-- Dumping data for table 'oldrecorded'
--
--
-- Table structure for table 'people'
--
CREATE TABLE people (
person mediumint(8) unsigned NOT NULL auto_increment,
name char(128) NOT NULL default '',
PRIMARY KEY (person),
KEY name (name(20))
) TYPE=MyISAM;
--
-- Dumping data for table 'people'
--
--
-- Table structure for table 'program'
--
CREATE TABLE program (
chanid int(10) unsigned NOT NULL default '0',
starttime timestamp(14) NOT NULL,
endtime timestamp(14) NOT NULL,
title varchar(128) default NULL,
subtitle varchar(128) default NULL,
description text,
category varchar(64) default NULL,
category_type varchar(64) default NULL,
airdate year(4) NOT NULL default '0000',
stars float unsigned NOT NULL default '0',
previouslyshown tinyint(4) NOT NULL default '0',
PRIMARY KEY (chanid,starttime),
KEY endtime (endtime),
KEY title (title)
) TYPE=MyISAM;
--
-- Dumping data for table 'program'
--
SNIP
--
-- Table structure for table 'programrating'
--
CREATE TABLE programrating (
chanid int(10) unsigned NOT NULL default '0',
starttime timestamp(14) NOT NULL,
system char(8) NOT NULL default '',
rating char(8) NOT NULL default '',
UNIQUE KEY chanid (chanid,starttime,system,rating),
KEY starttime (starttime,system)
) TYPE=MyISAM;
--
-- Dumping data for table 'programrating'
--
--
-- Table structure for table 'record'
--
CREATE TABLE record (
recordid int(10) unsigned NOT NULL auto_increment,
type int(10) unsigned NOT NULL default '0',
chanid int(10) unsigned default NULL,
starttime time NOT NULL default '00:00:00',
startdate date NOT NULL default '0000-00-00',
endtime time NOT NULL default '00:00:00',
enddate date NOT NULL default '0000-00-00',
title varchar(128) default NULL,
subtitle varchar(128) default NULL,
description text,
category varchar(64) default NULL,
profile int(10) unsigned NOT NULL default '0',
rank int(10) NOT NULL default '0',
autoexpire int(11) NOT NULL default '0',
maxepisodes int(11) NOT NULL default '0',
maxnewest int(11) NOT NULL default '0',
recorddups int(11) NOT NULL default '0',
PRIMARY KEY (recordid),
KEY chanid (chanid,starttime),
KEY title (title)
) TYPE=MyISAM;
--
-- Dumping data for table 'record'
--
--
-- Table structure for table 'recorded'
--
CREATE TABLE recorded (
chanid int(10) unsigned NOT NULL default '0',
starttime timestamp(14) NOT NULL,
endtime timestamp(14) NOT NULL,
title varchar(128) default NULL,
subtitle varchar(128) default NULL,
description text,
category varchar(64) default NULL,
hostname varchar(255) default NULL,
bookmark varchar(128) default NULL,
editing int(10) unsigned NOT NULL default '0',
cutlist text,
autoexpire int(11) NOT NULL default '0',
PRIMARY KEY (chanid,starttime),
KEY endtime (endtime)
) TYPE=MyISAM;
--
-- Dumping data for table 'recorded'
--
--
-- Table structure for table 'recordedmarkup'
--
CREATE TABLE recordedmarkup (
chanid int(10) unsigned NOT NULL default '0',
starttime timestamp(14) NOT NULL,
mark bigint(20) NOT NULL default '0',
offset varchar(32) default NULL,
type int(11) NOT NULL default '0',
PRIMARY KEY (chanid,starttime,mark,type)
) TYPE=MyISAM;
--
-- Dumping data for table 'recordedmarkup'
--
--
-- Table structure for table 'recordingprofiles'
--
CREATE TABLE recordingprofiles (
id int(10) unsigned NOT NULL auto_increment,
name varchar(128) default NULL,
videocodec varchar(128) default NULL,
audiocodec varchar(128) default NULL,
PRIMARY KEY (id),
UNIQUE KEY name (name)
) TYPE=MyISAM;
--
-- Dumping data for table 'recordingprofiles'
--
INSERT INTO recordingprofiles VALUES (1,'Default',NULL,NULL);
INSERT INTO recordingprofiles VALUES (2,'Live TV','RTjpeg','MP3');
INSERT INTO recordingprofiles VALUES (3,'Transcode',NULL,NULL);
--
-- Table structure for table 'settings'
--
CREATE TABLE settings (
value varchar(128) NOT NULL default '',
data text,
hostname varchar(255) default NULL,
KEY value (value,hostname)
) TYPE=MyISAM;
--
-- Dumping data for table 'settings'
--
INSERT INTO settings VALUES ('DBSchemaVer','1003',NULL);
INSERT INTO settings VALUES ('BackendServerIP','127.0.0.1','videoserver');
INSERT INTO settings VALUES ('BackendServerPort','6543','videoserver');
INSERT INTO settings VALUES ('BackendStatusPort','6544','videoserver');
INSERT INTO settings VALUES ('MasterServerIP','127.0.0.1',NULL);
INSERT INTO settings VALUES ('MasterServerPort','6543',NULL);
INSERT INTO settings VALUES ('RecordFilePrefix','/video/mythtv','videoserver');
INSERT INTO settings VALUES ('LiveBufferDir','/video/mythtv/buffer','videoserver');
INSERT INTO settings VALUES ('BufferSize','5','videoserver');
INSERT INTO settings VALUES ('MaxBufferFill','50','videoserver');
INSERT INTO settings VALUES ('MaxTranscoders','0','videoserver');
INSERT INTO settings VALUES ('TranscoderAutoRun','0',NULL);
INSERT INTO settings VALUES ('TranscoderUseCutlist','1',NULL);
INSERT INTO settings VALUES ('TVFormat','PAL',NULL);
INSERT INTO settings VALUES ('VbiFormat','None',NULL);
INSERT INTO settings VALUES ('FreqTable','europe-west',NULL);
INSERT INTO settings VALUES ('TimeOffset','',NULL);
INSERT INTO settings VALUES ('MasterBackendOverride','1',NULL);
INSERT INTO settings VALUES ('Deinterlace','1','videoserver');
INSERT INTO settings VALUES ('ReduceJitter','0','videoserver');
INSERT INTO settings VALUES ('ExperimentalAVSync','0','videoserver');
INSERT INTO settings VALUES ('PlaybackExitPrompt','0','videoserver');
INSERT INTO settings VALUES ('EndOfRecordingExitPrompt','0','videoserver');
INSERT INTO settings VALUES ('FixedAspectRatio','0','videoserver');
INSERT INTO settings VALUES ('ClearSavedPosition','1','videoserver');
INSERT INTO settings VALUES ('FastForwardAmount','30','videoserver');
INSERT INTO settings VALUES ('RewindAmount','5','videoserver');
INSERT INTO settings VALUES ('StickyKeys','0','videoserver');
INSERT INTO settings VALUES ('FFRewRepos','1','videoserver');
INSERT INTO settings VALUES ('ExactSeeking','0','videoserver');
INSERT INTO settings VALUES ('JumpAmount','10','videoserver');
INSERT INTO settings VALUES ('AutoCommercialFlag','1',NULL);
INSERT INTO settings VALUES ('CommercialSkipMethod','1',NULL);
INSERT INTO settings VALUES ('AggressiveCommDetect','1',NULL);
INSERT INTO settings VALUES ('AutoCommercialSkip','0','videoserver');
INSERT INTO settings VALUES ('VertScanPercentage','0','videoserver');
INSERT INTO settings VALUES ('HorizScanPercentage','0','videoserver');
INSERT INTO settings VALUES ('XScanDisplacement','0','videoserver');
INSERT INTO settings VALUES ('YScanDisplacement','0','videoserver');
INSERT INTO settings VALUES ('OSDTheme','blueosd','videoserver');
INSERT INTO settings VALUES ('OSDDisplayTime','3','videoserver');
INSERT INTO settings VALUES ('OSDFont','FreeSans.ttf','videoserver');
INSERT INTO settings VALUES ('OSDCCFont','FreeMono.ttf','videoserver');
INSERT INTO settings VALUES ('DefaultCCMode','0','videoserver');
INSERT INTO settings VALUES ('RecordPreRoll','0','videoserver');
INSERT INTO settings VALUES ('RecordOverTime','0','videoserver');
INSERT INTO settings VALUES ('PlayBoxOrdering','1','videoserver');
INSERT INTO settings VALUES ('ChannelOrdering','channum + 0','videoserver');
INSERT INTO settings VALUES ('DisplayChanNum','0','videoserver');
INSERT INTO settings VALUES ('GeneratePreviewPixmaps','0','videoserver');
INSERT INTO settings VALUES ('PlaybackPreview','1','videoserver');
INSERT INTO settings VALUES ('AdvancedRecord','0','videoserver');
INSERT INTO settings VALUES ('AutoExpireDiskThreshold','0',NULL);
INSERT INTO settings VALUES ('AutoExpireFrequency','10',NULL);
INSERT INTO settings VALUES ('AutoExpireMethod','1',NULL);
INSERT INTO settings VALUES ('AutoExpireDefault','1',NULL);
INSERT INTO settings VALUES ('MinRecordDiskThreshold','300',NULL);
INSERT INTO settings VALUES ('EPGFillType','6','videoserver');
INSERT INTO settings VALUES ('EPGScrollType','1','videoserver');
INSERT INTO settings VALUES ('EPGShowChannelIcon','1','videoserver');
INSERT INTO settings VALUES ('chanPerPage','5','videoserver');
INSERT INTO settings VALUES ('timePerPage','4','videoserver');
INSERT INTO settings VALUES ('UnknownTitle','Unknown','videoserver');
INSERT INTO settings VALUES ('UnknownCategory','Unknown','videoserver');
INSERT INTO settings VALUES ('DefaultTVChannel','3','videoserver');
INSERT INTO settings VALUES ('Theme','blue','videoserver');
INSERT INTO settings VALUES ('RandomTheme','0','videoserver');
INSERT INTO settings VALUES ('XineramaScreen','0','videoserver');
INSERT INTO settings VALUES ('GuiWidth','0','videoserver');
INSERT INTO settings VALUES ('GuiHeight','0','videoserver');
INSERT INTO settings VALUES ('GuiOffsetX','0','videoserver');
INSERT INTO settings VALUES ('GuiOffsetY','0','videoserver');
INSERT INTO settings VALUES ('RunFrontendInWindow','0','videoserver');
INSERT INTO settings VALUES ('Language','EN','videoserver');
INSERT INTO settings VALUES ('DateFormat','ddd MMM d','videoserver');
INSERT INTO settings VALUES ('ShortDateFormat','M/d','videoserver');
INSERT INTO settings VALUES ('TimeFormat','h:mm AP','videoserver');
INSERT INTO settings VALUES ('QtFontSmall','12','videoserver');
INSERT INTO settings VALUES ('QtFontMedium','16','videoserver');
INSERT INTO settings VALUES ('QtFontBig','25','videoserver');
INSERT INTO settings VALUES ('PlayBoxTransparency','1','videoserver');
INSERT INTO settings VALUES ('PlayBoxShading','0','videoserver');
INSERT INTO settings VALUES ('AudioOutputDevice','/dev/dsp','videoserver');
INSERT INTO settings VALUES ('AggressiveSoundcardBuffer','0','videoserver');
INSERT INTO settings VALUES ('MythControlsVolume','1','videoserver');
INSERT INTO settings VALUES ('MixerDevice','/dev/mixer','videoserver');
INSERT INTO settings VALUES ('MixerControl','PCM','videoserver');
INSERT INTO settings VALUES ('MasterMixerVolume','70','videoserver');
INSERT INTO settings VALUES ('PCMMixerVolume','70','videoserver');
INSERT INTO settings VALUES ('AllowQuitShutdown','0','videoserver');
INSERT INTO settings VALUES ('HaltCommand','halt','videoserver');
INSERT INTO settings VALUES ('RankingActive','0',NULL);
INSERT INTO settings VALUES ('RankingOrder','1',NULL);
INSERT INTO settings VALUES ('SingleRecordRank','0',NULL);
INSERT INTO settings VALUES ('WeekslotRecordRank','0',NULL);
INSERT INTO settings VALUES ('TimeslotRecordRank','0',NULL);
INSERT INTO settings VALUES ('ChannelRecordRank','0',NULL);
INSERT INTO settings VALUES ('AllRecordRank','0',NULL);
--
-- Table structure for table 'transcoding'
--
CREATE TABLE transcoding (
chanid int(10) unsigned default NULL,
starttime timestamp(14) NOT NULL,
status int(11) default NULL,
hostname varchar(255) default NULL
) TYPE=MyISAM;
--
-- Dumping data for table 'transcoding'
--
--
-- Table structure for table 'videosource'
--
CREATE TABLE videosource (
sourceid int(10) unsigned NOT NULL auto_increment,
name varchar(128) NOT NULL default '',
xmltvgrabber varchar(128) default NULL,
userid varchar(128) NOT NULL default '',
PRIMARY KEY (sourceid),
UNIQUE KEY name (name)
) TYPE=MyISAM;
--
-- Dumping data for table 'videosource'
--
INSERT INTO videosource VALUES (1,'sky','tv_grab_uk','');
More information about the mythtv-dev
mailing list