Professional
Gruppe: G2V3+User
Beiträge: 889
Mitgliedsnummer.: 544
Mitglied seit: 2005-06-01
|
Wollte nun da ja xmltv2vdr nicht geht epgd starten um das ganze mal zu testet. Ich dachte es wäre schon "Betriebsbereit" dabei. Leider startet der Dienst nicht:
CODE | Apr 15 11:36:45 vdr01 epgd[8385]: Set locale to 'de_DE.UTF-8' Apr 15 11:36:45 vdr01 epgd[8385]: Info: Systemd support not enabled, epgd won't be sending notifications! Apr 15 11:36:45 vdr01 epgd[8385]: Loading uuid from '/etc/epgd//uuid' succeeded [B1C50D0B-683F-4FC5-84C5-792F5C109E2B] Apr 15 11:36:45 vdr01 epgd[8385]: Dictionary '/etc/epgd//epg.dat' loaded Apr 15 11:36:45 vdr01 epgd[8385]: Initialize python script '/etc/epgd//recording.py' Apr 15 11:36:46 vdr01 epgd[8385]: Loading plugin: /usr/lib/epgd/plugins/libepgd-epgdata.so Apr 15 11:36:46 vdr01 epgd[8385]: Loading plugin: /usr/lib/epgd/plugins/libepgd-tvm.so Apr 15 11:36:46 vdr01 epgd[8385]: Loading plugin: /usr/lib/epgd/plugins/libepgd-tvsp.so Apr 15 11:36:46 vdr01 epgd[8385]: Read 26 option from /etc/epgd//epgd.conf Apr 15 11:36:46 vdr01 epgd[8385]: Using syslog facility 'user' (8), log level set to (1) Apr 15 11:36:46 vdr01 epgd[8385]: Info: Calling mysql_library_init() Apr 15 11:36:46 vdr01 epgd[8385]: Info: Stylesheet '/etc/epgd//epgdata-utf-8.xsl' loaded Apr 15 11:36:46 vdr01 epgd[8385]: Info: Stylesheet '/etc/epgd//tvmovie-utf-8.xsl' loaded Apr 15 11:36:46 vdr01 epgd[8385]: Info: Stylesheet '/etc/epgd//tvsp-utf-8.xsl' loaded Apr 15 11:36:46 vdr01 epgd[8385]: Checking database connection ... Apr 15 11:36:46 vdr01 epgd[8385]: Calling mysql_init(8385) Apr 15 11:36:46 vdr01 epgd[8385]: SQL client character now 'utf8' Apr 15 11:36:46 vdr01 epgd[8385]: Checking table structure and indices ... Apr 15 11:36:46 vdr01 epgd[8385]: Checking table 'analyse' Apr 15 11:36:46 vdr01 epgd[8385]: Initialy creating table 'analyse' Apr 15 11:36:46 vdr01 epgd[8385]: create table analyse(channelid VARCHAR(50), vdr_masterid INT(11) unsigned, vdr_eventid BIGINT(11) unsigned, vdr_starttime INT(10), vdr_duration INT(5), vdr_title VARCHAR(200), vdr_shorttext VARCHAR(300), ext_masterid INT(11) unsigned, ext_eventid BIGINT(11) unsigned, ext_starttime INT(10), ext_duration INT(5), ext_title VARCHAR(200), ext_shorttext VARCHAR(300), ext_episode VARCHAR(1), ext_merge INT(11), ext_images VARCHAR(1), lvmin INT(3), rank INT(5), PRIMARY KEY(channelid DESC, vdr_eventid DESC)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC; Apr 15 11:36:46 vdr01 epgd[8385]: create index idxvdr_masterid on analyse(vdr_masterid); Apr 15 11:36:46 vdr01 epgd[8385]: Checking table 'channelmap' Apr 15 11:36:46 vdr01 epgd[8385]: Initialy creating table 'channelmap' Apr 15 11:36:46 vdr01 epgd[8385]: create table channelmap(extid VARCHAR(10), channelid VARCHAR(50), source VARCHAR(20), ord INT(11), visible INT(11), channelname VARCHAR(100), vps INT(11), format VARCHAR(50), unknownatvdr INT(1) unsigned, merge INT(11), mergesp INT(11), inssp INT(11), updsp INT(11), updflg VARCHAR(1), PRIMARY KEY(extid DESC, channelid DESC, source DESC)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC; Apr 15 11:36:46 vdr01 epgd[8385]: create index idxsourceExtid on channelmap(source, extid); Apr 15 11:36:46 vdr01 epgd[8385]: create index idxsource on channelmap(source); Apr 15 11:36:47 vdr01 epgd[8385]: create index idxupdflg on channelmap(updflg); Apr 15 11:36:47 vdr01 epgd[8385]: create index idxsourcechannelid on channelmap(source, channelid); Apr 15 11:36:47 vdr01 epgd[8385]: create index idxmergesp on channelmap(mergesp); Apr 15 11:36:47 vdr01 epgd[8385]: create index idxchannelid on channelmap(channelid); Apr 15 11:36:47 vdr01 epgd[8385]: Checking table 'components' Apr 15 11:36:47 vdr01 epgd[8385]: Initialy creating table 'components' Apr 15 11:36:47 vdr01 epgd[8385]: create table components(eventid BIGINT(11) unsigned, channelid VARCHAR(50), stream INT(3), type INT(3), lang VARCHAR(8), description VARCHAR(100), inssp INT(11), updsp INT(11), PRIMARY KEY(eventid DESC, channelid DESC, stream DESC, type DESC, lang DESC, description DESC)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC; Apr 15 11:36:47 vdr01 epgd[8385]: Checking table 'episodes' Apr 15 11:36:47 vdr01 epgd[8385]: Initialy creating table 'episodes' Apr 15 11:36:47 vdr01 epgd[8385]: create table episodes(compname VARCHAR(100), comppartname VARCHAR(200), lang VARCHAR(10), inssp INT(11), updsp INT(11), link INT(11), shortname VARCHAR(100), compshortname VARCHAR(100), episodename VARCHAR(100), partname VARCHAR(300), season INT(11), part INT(11), parts INT(11), number INT(11), extracol1 VARCHAR(250), extracol2 VARCHAR(250), extracol3 VARCHAR(250), comment VARCHAR(250), PRIMARY KEY(compname DESC, comppartname DESC, lang DESC)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC; Apr 15 11:36:47 vdr01 epgd[8385]: create index idxupdsp on episodes(updsp); Apr 15 11:36:47 vdr01 epgd[8385]: Checking table 'events' Apr 15 11:36:47 vdr01 epgd[8385]: Initialy creating table 'events' Apr 15 11:36:47 vdr01 epgd[8385]: create table events(eventid BIGINT(11) unsigned, channelid VARCHAR(50), masterid INT(11) unsigned not null auto_increment, useid INT(11) unsigned, source VARCHAR(10), fileref VARCHAR(100), inssp INT(10), updsp INT(10), updflg VARCHAR(1), delflg VARCHAR(1), tableid INT(2), version INT(3), title VARCHAR(200), comptitle VARCHAR(200), shorttext VARCHAR(300), compshorttext VARCHAR(300), longdescription MEDIUMTEXT, complongdescription MEDIUMTEXT, starttime INT(10), duration INT(5), parentalrating INT(2), vps INT(10), contents VARCHAR(100) comment 'Genre code like table 28 of ETSI EN 300 468', shortdescription MEDIUMTEXT, actor MEDIUMTEXT, audio VARCHAR(50), category VARCHAR(50), country VARCHAR(50), director TEXT, commentator VARCHAR(200), flags VARCHAR(100), genre VARCHAR(100), music VARCHAR(250), producer TEXT, screenplay VARCHAR(500), shortreview VARCHAR(500), tipp VARCHAR(250), topic VARCHAR(1000), year VARCHAR(10), rating VARCHAR(250), numrating INT(2), txtrating VARCHAR(100), movieid VARCHAR(20), moderator VARCHAR(250), other TEXT, guest TEXT, camera TEXT, extepnum INT(4), imagecount INT(2), episodecompname VARCHAR(100), episodecompshortname VARCHAR(100), episodecomppartname VARCHAR(200), episodelang VARCHAR(10), scrseriesid INT(11), scrseriesepisode INT(11), scrmovieid INT(11), scrsp INT(11), PRIMARY KEY(eventid DESC, channelid DESC), KEY(masterid DESC)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC; Apr 15 11:36:48 vdr01 epgd[8385]: create index idxcomptitle on events(comptitle); Apr 15 11:36:48 vdr01 epgd[8385]: create index idxsource on events(source); Apr 15 11:36:48 vdr01 epgd[8385]: create index idxfilerefsource on events(fileref, source); Apr 15 11:36:48 vdr01 epgd[8385]: create index idxchannelid on events(channelid); Apr 15 11:36:48 vdr01 epgd[8385]: create index idxuseid on events(useid); Apr 15 11:36:48 vdr01 epgd[8385]: create index idxuseidchannelid on events(useid, channelid); Apr 15 11:36:48 vdr01 epgd[8385]: create index idxupdflgupdsp on events(updflg, updsp); Apr 15 11:36:48 vdr01 epgd[8385]: create index idxsourcechannelid on events(source, channelid); Apr 15 11:36:48 vdr01 epgd[8385]: create index idxscrsp on events(scrsp); Apr 15 11:36:49 vdr01 epgd[8385]: create index idxsourceupdsp on events(source, updsp); Apr 15 11:36:49 vdr01 epgd[8385]: create index idxscrseriesid on events(scrseriesid); Apr 15 11:36:49 vdr01 epgd[8385]: create index idxchannelidstarttime on events(channelid, starttime); Apr 15 11:36:49 vdr01 epgd[8385]: Checking table 'fileref' Apr 15 11:36:49 vdr01 epgd[8385]: Initialy creating table 'fileref' Apr 15 11:36:49 vdr01 epgd[8385]: create table fileref(name VARCHAR(100), source VARCHAR(10), inssp INT(11), updsp INT(11), extid VARCHAR(10), fileref VARCHAR(100), tag VARCHAR(100), PRIMARY KEY(name DESC, source DESC)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC; Apr 15 11:36:49 vdr01 epgd[8385]: create index idxSourceFileref on fileref(source, fileref); Apr 15 11:36:49 vdr01 epgd[8385]: create index idxFileref on fileref(fileref); Apr 15 11:36:49 vdr01 epgd[8385]: Checking table 'imagerefs' Apr 15 11:36:49 vdr01 epgd[8385]: Initialy creating table 'imagerefs' Apr 15 11:36:49 vdr01 epgd[8385]: create table imagerefs(eventid BIGINT(11) unsigned, lfn INT(11), inssp INT(11), updsp INT(11), source VARCHAR(10), fileref VARCHAR(100), imagename VARCHAR(100), imagenamefs VARCHAR(100), PRIMARY KEY(eventid DESC, lfn DESC)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC; Apr 15 11:36:50 vdr01 epgd[8385]: create index idxlfn on imagerefs(lfn); Apr 15 11:36:50 vdr01 epgd[8385]: create index idxname on imagerefs(imagename); Apr 15 11:36:50 vdr01 epgd[8385]: create index idxnamefs on imagerefs(imagenamefs); Apr 15 11:36:50 vdr01 epgd[8385]: Checking table 'images' Apr 15 11:36:50 vdr01 epgd[8385]: Initialy creating table 'images' Apr 15 11:36:50 vdr01 epgd[8385]: create table images(imagename VARCHAR(100), inssp INT(11), updsp INT(11), image MEDIUMBLOB, PRIMARY KEY(imagename DESC)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC; Apr 15 11:36:50 vdr01 epgd[8385]: Checking table 'messages' Apr 15 11:36:50 vdr01 epgd[8385]: Initialy creating table 'messages' Apr 15 11:36:50 vdr01 epgd[8385]: create table messages(id INT(11) unsigned not null auto_increment, inssp INT(11), updsp INT(11), type VARCHAR(1) comment 'Warning, Info, Error, Fatal', title VARCHAR(200), state VARCHAR(1) comment 'Read, New, Deleted', text MEDIUMTEXT, PRIMARY KEY(id DESC)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC; Apr 15 11:36:50 vdr01 epgd[8385]: Checking table 'movie' Apr 15 11:36:50 vdr01 epgd[8385]: Initialy creating table 'movie' Apr 15 11:36:50 vdr01 epgd[8385]: create table movie(movie_id INT(11) unsigned, movie_title VARCHAR(300), movie_original_title VARCHAR(300), movie_tagline VARCHAR(1000), movie_overview TEXT, movie_adult INT(11) unsigned, movie_collection_id INT(11) unsigned, movie_collection_name VARCHAR(300), movie_budget INT(11) unsigned, movie_revenue INT(11) unsigned, movie_genres VARCHAR(500), movie_homepage VARCHAR(300), movie_release_date VARCHAR(20), movie_runtime INT(11) unsigned, movie_popularity FLOAT(4,1), movie_vote_average FLOAT(4,1), PRIMARY KEY(movie_id DESC)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC; Apr 15 11:36:51 vdr01 epgd[8385]: create index idxmovie_id on movie(movie_id); Apr 15 11:36:51 vdr01 epgd[8385]: create index idxmovietitle on movie(movie_title); Apr 15 11:36:51 vdr01 epgd[8385]: Checking table 'movie_actor' Apr 15 11:36:51 vdr01 epgd[8385]: Initialy creating table 'movie_actor' Apr 15 11:36:51 vdr01 epgd[8385]: create table movie_actor(actor_id INT(11) unsigned, actor_name VARCHAR(300), PRIMARY KEY(actor_id DESC)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC; Apr 15 11:36:51 vdr01 epgd[8385]: create index idxactor_id on movie_actor(actor_id); Apr 15 11:36:51 vdr01 epgd[8385]: Checking table 'movie_actors' Apr 15 11:36:51 vdr01 epgd[8385]: Initialy creating table 'movie_actors' Apr 15 11:36:51 vdr01 epgd[8385]: create table movie_actors(movie_id INT(11) unsigned, actor_id INT(11) unsigned, actor_role VARCHAR(300), PRIMARY KEY(movie_id DESC, actor_id DESC)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC; Apr 15 11:36:51 vdr01 epgd[8385]: create index idxmovie_id on movie_actors(movie_id); Apr 15 11:36:51 vdr01 epgd[8385]: create index idxactor_id on movie_actors(actor_id); Apr 15 11:36:52 vdr01 epgd[8385]: Checking table 'movie_media' Apr 15 11:36:52 vdr01 epgd[8385]: Initialy creating table 'movie_media' Apr 15 11:36:52 vdr01 epgd[8385]: create table movie_media(movie_id INT(11) unsigned, actor_id INT(11) unsigned, media_type INT(11) unsigned, media_url VARCHAR(100), media_width INT(11) unsigned, media_height INT(11) unsigned, media_content MEDIUMBLOB, PRIMARY KEY(movie_id DESC, actor_id DESC, media_type DESC)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC; Apr 15 11:36:52 vdr01 epgd[8385]: create index idxmovie_id on movie_media(movie_id); Apr 15 11:36:52 vdr01 epgd[8385]: create index idxactor_id on movie_media(actor_id); Apr 15 11:36:52 vdr01 epgd[8385]: Checking table 'parameters' Apr 15 11:36:52 vdr01 epgd[8385]: Initialy creating table 'parameters' Apr 15 11:36:52 vdr01 epgd[8385]: create table parameters(owner VARCHAR(40), name VARCHAR(40), inssp INT(11), updsp INT(11), value VARCHAR(500), PRIMARY KEY(owner DESC, name DESC)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC; Apr 15 11:36:52 vdr01 epgd[8385]: Checking table 'recordingdirs' Apr 15 11:36:52 vdr01 epgd[8385]: Initialy creating table 'recordingdirs' Apr 15 11:36:52 vdr01 epgd[8385]: create table recordingdirs(vdruuid VARCHAR(40), directory VARCHAR(255), inssp INT(11), updsp INT(11), PRIMARY KEY(vdruuid DESC, directory DESC)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC; Apr 15 11:36:52 vdr01 epgd[8385]: Checking table 'recordingimages' Apr 15 11:36:52 vdr01 epgd[8385]: Initialy creating table 'recordingimages' Apr 15 11:36:52 vdr01 epgd[8385]: create table recordingimages(imgid VARCHAR(40) comment 'md5 of title/shorttext', lfn INT(11) unsigned, inssp INT(11), updsp INT(11), title VARCHAR(200), shorttext VARCHAR(300), image MEDIUMBLOB, PRIMARY KEY(imgid DESC, lfn DESC)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC; Apr 15 11:36:53 vdr01 epgd[8385]: Checking table 'recordinglist' Apr 15 11:36:53 vdr01 epgd[8385]: Initialy creating table 'recordinglist' Apr 15 11:36:53 vdr01 epgd[8385]: create table recordinglist(md5path VARCHAR(40), starttime INT(11) unsigned, owner VARCHAR(40) comment 'uuid of vdr', inssp INT(10), updsp INT(10), lastifoupd INT(10), imgid VARCHAR(40) comment 'md5 of title/shorttext', vdruuid VARCHAR(40), path VARCHAR(1000), name VARCHAR(1000), folder VARCHAR(1000), title VARCHAR(200), shorttext VARCHAR(300), longdescription MEDIUMTEXT, description MEDIUMTEXT, duration INT(11) unsigned, fsk INT(1) unsigned, eventid INT(11) unsigned comment 'useid', channelid VARCHAR(50), channelname VARCHAR(100) comment 'just a copy', state VARCHAR(1), inuse INT(1) unsigned, job VARCHAR(1), actor MEDIUMTEXT, audio VARCHAR(50), category VARCHAR(50), country VARCHAR(50), director TEXT, flags VARCHAR(100), genre VARCHAR(100), music VARCHAR(250), producer TEXT, screenplay VARCHAR(500), shortreview VARCHAR(500), tipp VARCHAR(250), topic VARCHAR(1000), year VARCHAR(10), rating VARCHAR(250), numrating INT(2), txtrating VARCHAR(100), moderator VARCHAR(250), other TEXT, guest TEXT, camera TEXT, episodecompname VARCHAR(100), episodecompshortname VARCHAR(100), episodecomppartname VARCHAR(200), episodelang VARCHAR(10), scrseriesid INT(11) unsigned, scrseriesepisode INT(11) unsigned, scrmovieid INT(11) unsigned, scrinfomovieid INT(11) unsigned, scrinfoseriesid INT(11) unsigned, scrinfoepisodeid INT(11) unsigned, scrnew INT(11) unsigned, scrsp INT(11), PRIMARY KEY(md5path DESC, starttime DESC, owner DESC)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC; Apr 15 11:36:53 vdr01 epgd[8385]: Checking table 'searchtimers' Apr 15 11:36:53 vdr01 epgd[8385]: Initialy creating table 'searchtimers' Apr 15 11:36:53 vdr01 epgd[8385]: create table searchtimers(id INT(11) unsigned not null auto_increment, inssp INT(11), updsp INT(11), channelids VARCHAR(500) comment 'comma separated list of channleids or empty', chexclude INT(11) unsigned, chformat VARCHAR(50) comment 'HD,SD', chnummin INT(11) unsigned comment 'min channel number', chnummax INT(11) unsigned comment 'max channel number', name VARCHAR(100) comment 'Bezeichung des Suchtimers', expression VARCHAR(200), expression1 VARCHAR(200), searchmode INT(11) unsigned comment '1 exact, 2 regexp, 3 like, 4 enthalten, ..', searchfields INT(11) unsigned comment 'Bitmaske: 1 title, 2 shorttext, 4 - desc, ..', searchfields1 INT(11) unsigned comment 'Bitmaske: 0 off, 1 title, 2 shorttext, 4 - desc, ..', casesensitiv INT(11) unsigned comment '0,1', repeatfields INT(11) unsigned comment 'Bitmaske: 1 title, 2 shorttext, 4 - desc, ..', episodename VARCHAR(100), season VARCHAR(10) comment 'e.g. \'1-7\'', seasonpart VARCHAR(10) comment 'e.g. \'20-\'', category VARCHAR(150) comment 'e.g. \'Spielfilm\',\'Serie\'', genre VARCHAR(150) comment 'e.g. \'Krimi\',\'Action\'', year VARCHAR(10) comment 'e.g. \'2010-2015\'', tipp VARCHAR(250), noepgmatch INT(11), type VARCHAR(1) comment '\'R\'ecord, \'V\'iew, \'S\'earch', state VARCHAR(1) comment 'D - Deleted', namingmode INT(11), template VARCHAR(100), active INT(11) unsigned comment '0,1', source VARCHAR(40) comment 'webif ,osd, ...', hits INT(11) unsigned comment 'stastic counter, just for info', modsp INT(11) comment 'last user modification time', lastrun INT(11) comment 'last execution of search timer', vdruuid VARCHAR(40) comment 'empty or uuid of vdr', weekdays INT(11) comment 'bitmask like timers, 0 foy all', nextdays INT(11) unsigned, starttime INT(11) comment 'null for unlimited search', endtime INT(11) comment 'null for unlimited search', directory VARCHAR(512), priority INT(11), lifetime INT(11), vps INT(11), childlock INT(11), PRIMARY KEY(id DESC)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC; Apr 15 11:36:53 vdr01 epgd[8385]: Checking table 'series' Apr 15 11:36:53 vdr01 epgd[8385]: Initialy creating table 'series' Apr 15 11:36:53 vdr01 epgd[8385]: create table series(series_id INT(11) unsigned, series_name VARCHAR(200), series_last_scraped INT(11) unsigned, series_last_updated INT(11) unsigned, series_overview TEXT, series_firstaired VARCHAR(50), series_network VARCHAR(100), series_imdb_id VARCHAR(20), series_genre VARCHAR(100), series_rating FLOAT(4,1), series_status VARCHAR(50), PRIMARY KEY(series_id DESC)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC; Apr 15 11:36:53 vdr01 epgd[8385]: create index idxseriesname on series(series_name); Apr 15 11:36:53 vdr01 epgd[8385]: Checking table 'series_actor' Apr 15 11:36:53 vdr01 epgd[8385]: Initialy creating table 'series_actor' Apr 15 11:36:53 vdr01 epgd[8385]: create table series_actor(actor_id INT(11) unsigned, actor_name VARCHAR(100), actor_role VARCHAR(500), actor_sortorder INT(11) unsigned, PRIMARY KEY(actor_id DESC)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC; Apr 15 11:36:54 vdr01 epgd[8385]: Checking table 'series_episode' Apr 15 11:36:54 vdr01 epgd[8385]: Initialy creating table 'series_episode' Apr 15 11:36:54 vdr01 epgd[8385]: create table series_episode(episode_id INT(11) unsigned, episode_number INT(11) unsigned, season_number INT(11) unsigned, episode_name VARCHAR(300), episode_overview TEXT, episode_firstaired VARCHAR(20), episode_gueststars VARCHAR(1000), episode_rating FLOAT(4,1), episode_last_updated INT(11) unsigned, series_id INT(11) unsigned, PRIMARY KEY(episode_id DESC)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC; Apr 15 11:36:54 vdr01 epgd[8385]: create index idxseries_id on series_episode(series_id); Apr 15 11:36:54 vdr01 epgd[8385]: Checking table 'series_media' Apr 15 11:36:54 vdr01 epgd[8385]: Initialy creating table 'series_media' Apr 15 11:36:54 vdr01 epgd[8385]: create table series_media(series_id INT(11) unsigned, season_number INT(11) unsigned, episode_id INT(11) unsigned, actor_id INT(11) unsigned, media_type INT(11) unsigned, inssp INT(11), updsp INT(11), media_url VARCHAR(100), media_width INT(11) unsigned, media_height INT(11) unsigned, media_rating FLOAT(4,1), media_content MEDIUMBLOB, PRIMARY KEY(series_id DESC, season_number DESC, episode_id DESC, actor_id DESC, media_type DESC)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC; Apr 15 11:36:54 vdr01 epgd[8385]: create index idxseries_id on series_media(series_id); Apr 15 11:36:54 vdr01 epgd[8385]: create index idxseason_number on series_media(season_number); Apr 15 11:36:54 vdr01 epgd[8385]: create index idxepisode_id on series_media(episode_id); Apr 15 11:36:54 vdr01 epgd[8385]: create index idxactor_id on series_media(actor_id); Apr 15 11:36:55 vdr01 epgd[8385]: Checking table 'snapshot' Apr 15 11:36:55 vdr01 epgd[8385]: Initialy creating table 'snapshot' Apr 15 11:36:55 vdr01 epgd[8385]: create table snapshot(channelid VARCHAR(50), source VARCHAR(10), masterid INT(11) unsigned, eventid BIGINT(11) unsigned, useid INT(11) unsigned, starttime INT(10), duration INT(5), title VARCHAR(200), comptitle VARCHAR(200), shorttext VARCHAR(300), compshorttext VARCHAR(300), updsp INT(10), episode VARCHAR(1), merge INT(11), images VARCHAR(1)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC; Apr 15 11:36:55 vdr01 epgd[8385]: create index idxchannelid on snapshot(channelid); Apr 15 11:36:55 vdr01 epgd[8385]: create index idxstarttimeSource on snapshot(starttime, source); Apr 15 11:36:55 vdr01 epgd[8385]: Checking table 'timers' Apr 15 11:36:55 vdr01 epgd[8385]: Initialy creating table 'timers' Apr 15 11:36:55 vdr01 epgd[8385]: create table timers(id INT(11) unsigned not null auto_increment, vdruuid VARCHAR(40), inssp INT(11), updsp INT(11), eventid INT(11) unsigned comment 'useid', channelid VARCHAR(50), _starttime INT(10) comment 'pre filled start timer for trigger', source VARCHAR(40) comment 'like osd, webif, epgd', type VARCHAR(1) comment '\'R\'ecord, \'V\'iew (umschalt)', state VARCHAR(1) default 'u' comment '\'D\'eleted, \'R\'unning, \'F\'inished', info VARCHAR(255) comment 'error reason if state is failed', action VARCHAR(1) default 'a', tccmailcnt INT(11) unsigned, wrncount INT(11) unsigned, retrys INT(11) unsigned, namingmode INT(11), template VARCHAR(100), active INT(11) unsigned, day INT(10), weekdays INT(10), starttime INT(10), endtime INT(10), file VARCHAR(512), directory VARCHAR(512), priority INT(11), lifetime INT(11), vps INT(11), childlock INT(11), aux VARCHAR(1000), autotimername VARCHAR(100) comment 'Bezeichung des Suchtimers', autotimerid INT(11) unsigned comment 'id of autotimer', autotimerinssp INT(11), doneid INT(11) unsigned comment 'id of done entry', expression VARCHAR(200), PRIMARY KEY(id DESC, vdruuid DESC)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC; Apr 15 11:36:55 vdr01 epgd[8385]: create index idxeventidchannelidvdruuid on timers(eventid, channelid, vdruuid); Apr 15 11:36:55 vdr01 epgd[8385]: create index idxvdruuidstate on timers(vdruuid, state); Apr 15 11:36:55 vdr01 epgd[8385]: Checking table 'timersdone' Apr 15 11:36:55 vdr01 epgd[8385]: Initialy creating table 'timersdone' Apr 15 11:36:55 vdr01 epgd[8385]: create table timersdone(id INT(11) unsigned not null auto_increment, inssp INT(11), updsp INT(11), source VARCHAR(40), state VARCHAR(1) comment 'Q requested, C created, R recorded, F Failed', timerid INT(11) unsigned comment 'not filled completely in all cases yet', autotimerid INT(11) unsigned, autotimername VARCHAR(100) comment 'Bezeichung des Suchtimers', title VARCHAR(200), comptitle VARCHAR(200), shorttext VARCHAR(300), compshorttext VARCHAR(300), longdescription MEDIUMTEXT, complongdescription MEDIUMTEXT, episodecompname VARCHAR(100), episodecompshortname VARCHAR(100), episodecomppartname VARCHAR(200), episodelang VARCHAR(10), episodeseason INT(11), episodepart INT(11), channelid VARCHAR(50), channelname VARCHAR(100), expression VARCHAR(200) comment 'expression of autotimer', starttime INT(10), duration INT(5), aux VARCHAR(512), PRIMARY KEY(id DESC)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC; Apr 15 11:36:56 vdr01 epgd[8385]: create index idxcheckdoubles on timersdone(comptitle); Apr 15 11:36:56 vdr01 epgd[8385]: Checking table 'useevents' Apr 15 11:36:56 vdr01 epgd[8385]: Initialy creating table 'useevents' Apr 15 11:36:56 vdr01 epgd[8385]: create table useevents(cnt_source VARCHAR(10), cnt_channelid VARCHAR(50), cnt_eventid BIGINT(11) unsigned, cnt_masterid INT(11) unsigned, cnt_useid INT(11) unsigned, sub_source VARCHAR(10), sub_eventid BIGINT(11) unsigned, all_updsp INT(11), cnt_updflg VARCHAR(1), cnt_delflg VARCHAR(1), cnt_fileref VARCHAR(100), cnt_tableid INT(2), cnt_version INT(3), sub_title VARCHAR(200), sub_shorttext VARCHAR(300), sub_comptitle VARCHAR(200), sub_compshorttext VARCHAR(300), sub_genre VARCHAR(100), sub_country VARCHAR(50), sub_year VARCHAR(10), cnt_starttime INT(10), cnt_duration INT(5), cnt_parentalrating INT(2), cnt_vps INT(10), cnt_contents VARCHAR(100) comment 'Genre code like table 28 of ETSI EN 300 468', sub_category VARCHAR(50), sub_shortdescription MEDIUMTEXT, sub_shortreview VARCHAR(500), sub_tipp VARCHAR(250), sub_rating VARCHAR(250), sub_numrating INT(2), sub_txtrating VARCHAR(100), sub_topic VARCHAR(1000), sub_longdescription MEDIUMTEXT, sub_complongdescription MEDIUMTEXT, cnt_longdescription MEDIUMTEXT, sub_moderator VARCHAR(250), sub_guest TEXT, sub_actor MEDIUMTEXT, sub_producer TEXT, sub_other TEXT, sub_director TEXT, sub_commentator VARCHAR(200), sub_screenplay VARCHAR(500), sub_camera TEXT, sub_music VARCHAR(250), sub_audio VARCHAR(50), sub_flags VARCHAR(100), sub_imagecount INT(2), sub_scrseriesid INT(11), sub_scrseriesepisode INT(11), sub_scrmovieid INT(11), sub_scrsp INT(11), sub_episodecompname VARCHAR(100), sub_episodecompshortname VARCHAR(100), sub_episodecomppartname VARCHAR(200), epi_episodename VARCHAR(100), epi_shortname VARCHAR(100), epi_partname VARCHAR(300), epi_lang VARCHAR(10), epi_extracol1 VARCHAR(250), epi_extracol2 VARCHAR(250), epi_extracol3 VARCHAR(250), epi_season INT(11), epi_part INT(11), epi_parts INT(11), epi_number INT(11), PRIMARY KEY(cnt_source DESC, cnt_channelid DESC, cnt_eventid DESC)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC; Apr 15 11:36:56 vdr01 epgd[8385]: create index idxchannelidstarttime on useevents(cnt_channelid, cnt_starttime); Apr 15 11:36:56 vdr01 epgd[8385]: create index idxuseid on useevents(cnt_useid); Apr 15 11:36:56 vdr01 epgd[8385]: create index idxchannelidupdflgupdsp on useevents(cnt_channelid, cnt_updflg, all_updsp); Apr 15 11:36:57 vdr01 epgd[8385]: create index idxchannelid on useevents(cnt_channelid); Apr 15 11:36:57 vdr01 epgd[8385]: create index idxupdflgstarttimeduration on useevents(all_updsp, cnt_starttime, cnt_duration); Apr 15 11:36:57 vdr01 epgd[8385]: Checking table 'users' Apr 15 11:36:57 vdr01 epgd[8385]: Initialy creating table 'users' Apr 15 11:36:57 vdr01 epgd[8385]: create table users(user VARCHAR(40), inssp INT(11), updsp INT(11), passwd VARCHAR(100), active INT(1), rights INT(11) unsigned, PRIMARY KEY(user DESC)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC; Apr 15 11:36:57 vdr01 epgd[8385]: Checking table 'vdrs' Apr 15 11:36:57 vdr01 epgd[8385]: Initialy creating table 'vdrs' Apr 15 11:36:57 vdr01 epgd[8385]: create table vdrs(uuid VARCHAR(40), inssp INT(11), updsp INT(11), name VARCHAR(100), version VARCHAR(100), dbapi INT(11) unsigned, lastupd INT(11), nextupd INT(11), lastmerge INT(11), state VARCHAR(20), master VARCHAR(1), ip VARCHAR(20), mac VARCHAR(18), pid INT(11) unsigned, svdrp INT(11) unsigned, osd2webp INT(11) unsigned, tunercount INT(11) unsigned, shareinweb INT(1) unsigned, usecommonrecfolder INT(1) unsigned, videodir VARCHAR(300), videototal INT(11) unsigned, videofree INT(11) unsigned, PRIMARY KEY(uuid DESC)) ENGINE=InnoDB ROW_FORMAT=DYNAMIC; Apr 15 11:36:57 vdr01 epgd[8385]: create index idxstate on vdrs(state); Apr 15 11:36:57 vdr01 epgd[8385]: Closing mysql connection and calling mysql_thread_end(8385) Apr 15 11:36:57 vdr01 epgd[8385]: Checking table structure and indices succeeded Apr 15 11:36:57 vdr01 epgd[8385]: Calling mysql_init(8385) Apr 15 11:36:57 vdr01 epgd[8385]: Migration of table 'recordinglist' from version <= 4 ... Apr 15 11:36:57 vdr01 epgd[8385]: ... done Apr 15 11:36:57 vdr01 epgd[8385]: Migration of table 'recordinglist' from version <= 5 ... Apr 15 11:36:57 vdr01 epgd[8385]: ... done Apr 15 11:36:57 vdr01 epgd[8385]: Migration of table 'imagerefs' from version <= 6 ... Apr 15 11:36:57 vdr01 epgd[8385]: ... done Apr 15 11:36:57 vdr01 epgd[8385]: State now 'init' Apr 15 11:36:57 vdr01 epgd[8385]: SQL-Error in 'select epglv('123', '123')' - FUNCTION epg2vdr.epglv does not exist (1305) Apr 15 11:36:57 vdr01 epgd[8385]: SQL-Error in 'select epglvr('123', '123')' - FUNCTION epg2vdr.epglvr does not exist (1305) Apr 15 11:36:57 vdr01 epgd[8385]: Error: Missing functions epglv/epglvr, please install first! Apr 15 11:36:57 vdr01 epgd[8385]: Closing mysql connection and calling mysql_thread_end(8385) Apr 15 11:36:57 vdr01 epgd[8385]: Info: Released the last usage of mysql_lib, calling mysql_library_end() now Apr 15 11:36:57 vdr01 /etc/init.d/epgd[8384]: start-stop-daemon: failed to start `/usr/bin/epgd' Apr 15 11:36:58 vdr01 epghttpd[8427]: Set locale to 'de_DE.UTF-8' Apr 15 11:36:58 vdr01 epghttpd[8427]: detected UTF-8 Apr 15 11:36:58 vdr01 epghttpd[8427]: Read 26 option from /etc/epgd/epgd.conf Apr 15 11:36:58 vdr01 epghttpd[8427]: Log level is set to (1) Apr 15 11:36:58 vdr01 epghttpd[8427]: Initialize python script '/etc/epgd/recording.py' Apr 15 11:36:58 vdr01 epghttpd[8427]: Initialize python script '/etc/epgd/recording.py' Apr 15 11:36:58 vdr01 epghttpd[8427]: Dictionary '/etc/epgd/epg.dat' loaded Apr 15 11:36:58 vdr01 epghttpd[8427]: Info: Calling mysql_library_init() Apr 15 11:36:58 vdr01 epghttpd[8427]: Connecting to database at 'localhost:3306' Apr 15 11:36:58 vdr01 epghttpd[8427]: Calling mysql_init(8427) Apr 15 11:36:58 vdr01 epghttpd[8427]: SQL client character now 'utf8' Apr 15 11:36:58 vdr01 epghttpd[8427]: SQL-Error in 'prepare(stmt_prepare)' - Table 'epg2vdr.eventsviewplain' doesn't exist (1146) 'Table 'epg2vdr.eventsviewplain' doesn't exist' [select e.cnt_useid, e.cnt_channelid, e.sub_imagecount, e.sub_title, e.sub_shorttext, e.sub_shortdescription, e.cnt_starttime, e.cnt_duration, e.sub_category, e.sub_genre, e.sub_tipp, e.sub_numrating from eventsviewplain e, (select distinct channelid,channelname,ord,visible from channelmap) c where e.cnt_channelid = c.channelid and c.visible & 1 and e.cnt_starttime <= ? and e.cnt_starttime+cnt_duration > ? and e.cnt_channelid like ? and e.updflg in ('A','L','P') order by c.ord, e.cnt_starttime] Apr 15 11:36:58 vdr01 epghttpd[8427]: SQL-Error in 'prepare(stmt_prepare)' - Table 'epg2vdr.eventsviewplain' doesn't exist (1146) 'Table 'epg2vdr.eventsviewplain' doesn't exist' [select e.cnt_useid, e.cnt_channelid, e.sub_imagecount, e.sub_title, e.sub_shorttext, e.sub_shortdescription, e.cnt_starttime, e.cnt_duration, e.sub_category, e.sub_genre, e.sub_tipp, e.sub_numrating from eventsviewplain e, (select distinct channelid,channelname,ord,visible from channelmap) c where e.cnt_channelid = c.channelid and c.visible & 1 and e.cnt_starttime >= ? and e.cnt_starttime <= ? and e.cnt_channelid like ? and e.updflg in ('A','L','P') order by c.ord, e.cnt_starttime] Apr 15 11:36:58 vdr01 epghttpd[8427]: SQL-Error in 'prepare(stmt_prepare)' - Table 'epg2vdr.eventsviewplain' doesn't exist (1146) 'Table 'epg2vdr.eventsviewplain' doesn't exist' [select e.cnt_useid, e.cnt_channelid, e.sub_imagecount, e.sub_title, e.sub_shorttext, e.sub_shortdescription, e.cnt_starttime, e.cnt_duration, e.sub_category, e.sub_genre, e.sub_tipp, e.sub_numrating from (select min(concat(e.cnt_starttime, e.cnt_channelid, e.cnt_source)) PK, e.cnt_channelid, c.ord from eventsviewplain e, (select distinct channelid,channelname,ord,visible from channelmap) c where e.cnt_channelid = c.channelid and c.visible & 1 and e.updflg in ('A','L','P') and e.cnt_starttime > ? and e.cnt_starttime < 127800 + ? group by e.cnt_channelid, c.ord) s, eventsviewplain e where s.PK = concat(e.cnt_starttime, e.cnt_channelid, e.cnt_source) and e.cnt_starttime > ? and e.cnt_starttime < 127800 + ? order by s.ord, e.cnt_starttime] Apr 15 11:36:58 vdr01 epghttpd[8427]: SQL-Error in 'prepare(stmt_prepare)' - Table 'epg2vdr.eventsviewplain' doesn't exist (1146) 'Table 'epg2vdr.eventsviewplain' doesn't exist' [select imageid, merge, sub_actor, sub_audio, sub_camera, sub_category, cnt_channelid, cnt_longdescription, cnt_source, sub_commentator, sub_complongdescription, sub_compshorttext, sub_comptitle, cnt_contents, sub_country, cnt_delflg, sub_director, cnt_duration, sub_episodecompname, sub_episodecomppartname, sub_episodecompshortname, epi_extracol1, epi_extracol2, epi_extracol3, epi_lang, epi_episodename, epi_number, epi_part, epi_partname, epi_parts, epi_season, epi_shortname, cnt_fileref, sub_flags, sub_genre, sub_guest, sub_imagecount, sub_longdescription, sub_moderator, sub_music, sub_numrating, sub_other, cnt_parentalrating, sub_producer, sub_rating, sub_screenplay, sub_scrmovieid, sub_scrseriesepisode, sub_scrseriesid, sub_shortdescription, sub_shortreview, sub_shorttext, cnt_starttime, cnt_tableid, sub_tipp, sub_title, sub_topic, sub_txtrating, all_updsp, cnt_useid, cnt_version, cnt_vps, sub_year from eventsviewplain where cnt_useid = ?] Apr 15 11:36:58 vdr01 epghttpd[8427]: SQL-Error in 'prepare(stmt_prepare)' - Table 'epg2vdr.eventsviewplain' doesn't exist (1146) 'Table 'epg2vdr.eventsviewplain' doesn't exist' [select imageid, merge, sub_actor, sub_audio, sub_camera, sub_category, cnt_channelid, cnt_longdescription, cnt_source, sub_commentator, sub_complongdescription, sub_compshorttext, sub_comptitle, cnt_contents, sub_country, cnt_delflg, sub_director, cnt_duration, sub_episodecompname, sub_episodecomppartname, sub_episodecompshortname, epi_extracol1, epi_extracol2, epi_extracol3, epi_lang, epi_episodename, epi_number, epi_part, epi_partname, epi_parts, epi_season, epi_shortname, cnt_fileref, sub_flags, sub_genre, sub_guest, sub_imagecount, sub_longdescription, sub_moderator, sub_music, sub_numrating, sub_other, cnt_parentalrating, sub_producer, sub_rating, sub_screenplay, sub_scrmovieid, sub_scrseriesepisode, sub_scrseriesid, sub_shortdescription, sub_shortreview, sub_shorttext, cnt_starttime, cnt_tableid, sub_tipp, sub_title, sub_topic, sub_txtrating, all_updsp, cnt_useid, cnt_version, cnt_vps, sub_year from eventsviewplain where cnt_channelid = ? and cnt_starttime <= ? and cnt_starttime+cnt_duration >= ?] Apr 15 11:36:58 vdr01 epghttpd[8427]: SQL-Error in 'prepare(stmt_prepare)' - Table 'epg2vdr.eventsviewplain' doesn't exist (1146) 'Table 'epg2vdr.eventsviewplain' doesn't exist' [select t._starttime, t.action, t.active, t.autotimerid, t.autotimerinssp, t.autotimername, t.aux, t.channelid, t.childlock, t.day, t.directory, t.doneid, t.endtime, t.eventid, t.expression, t.file, t.id, t.info, t.lifetime, t.namingmode, t.priority, t.retrys, t.source, t.starttime, t.state, t.tccmailcnt, t.template, t.type, t.vdruuid, t.vps, t.weekdays, t.wrncount, e.cnt_useid, e.cnt_channelid, e.cnt_source, e.cnt_eventid, e.sub_title, e.sub_shorttext, e.sub_shortdescription, e.sub_category, e.sub_genre, e.sub_tipp, e.sub_numrating from timers t left outer join eventsviewplain e on (t.eventid = e.cnt_useid) and e.updflg in ('A','L','P')] Apr 15 11:36:58 vdr01 epghttpd[8427]: SQL-Error in 'prepare(stmt_prepare)' - FUNCTION epg2vdr.epglvr does not exist (1305) 'FUNCTION epg2vdr.epglvr does not exist' [select actor, audio, camera, category, channelid, channelname, country, description, director, duration, episodecompname, episodecomppartname, episodecompshortname, episodelang, eventid, flags, folder, fsk, genre, guest, imgid, inuse, job, longdescription, md5path, moderator, music, name, numrating, other, owner, path, producer, rating, screenplay, scrinfoepisodeid, scrinfomovieid, scrinfoseriesid, scrmovieid, scrnew, scrseriesepisode, scrseriesid, scrsp, shortreview, shorttext, starttime, state, tipp, title, topic, txtrating, vdruuid, year, 100 - ifNull(epglvr(title, ?), 100), 100 - ifNull(epglvr(shorttext, ?), 100) from recordinglist where (state <> 'D' or state is null)and epglvr(title, ?) < 47] Apr 15 11:36:58 vdr01 epghttpd[8427]: Calling mysql_init(8427) Apr 15 11:36:58 vdr01 epghttpd[8427]: SQL-Error in 'prepare(stmt_prepare)' - Table 'epg2vdr.eventsviewplain' doesn't exist (1146) 'Table 'epg2vdr.eventsviewplain' doesn't exist' [select sub_actor, sub_audio, sub_camera, sub_category, cnt_channelid, cnt_longdescription, cnt_source, sub_commentator, sub_complongdescription, sub_compshorttext, sub_comptitle, cnt_contents, sub_country, cnt_delflg, sub_director, cnt_duration, sub_episodecompname, sub_episodecomppartname, sub_episodecompshortname, epi_extracol1, epi_extracol2, epi_extracol3, epi_lang, epi_episodename, epi_number, epi_part, epi_partname, epi_parts, epi_season, epi_shortname, cnt_fileref, sub_flags, sub_genre, sub_guest, sub_imagecount, sub_longdescription, sub_moderator, sub_music, sub_numrating, sub_other, cnt_parentalrating, sub_producer, sub_rating, sub_screenplay, sub_scrmovieid, sub_scrseriesepisode, sub_scrseriesid, sub_shortdescription, sub_shortreview, sub_shorttext, cnt_starttime, cnt_tableid, sub_tipp, sub_title, sub_topic, sub_txtrating, all_updsp, cnt_useid, cnt_version, cnt_vps, sub_year from eventsviewplain where cnt_useid = ?] Apr 15 11:36:58 vdr01 epghttpd[8427]: Error: At least 1 statements not prepared successfully Apr 15 11:36:58 vdr01 epghttpd[8427]: Starting http server ... Apr 15 11:36:58 vdr01 epghttpd[8427]: Listener at port 9999 established, waiting for connections Apr 15 11:36:58 vdr01 epghttpd[8427]: Info: Systemd support not enabled, epgd won't be sending notifications! |
Da scheint einiges nicht zu passen ;-(
|