Stadtgeflüster: epgd kommt noch vor Ostern in der http Version

Zoolook · 12. März 2016

Hi,

ich wollte auch mal die HTTP-VErsion vom epgd ausprobieren (hatte vorher epgd master-branch genutzt), und jetzt kann ich trotz neu Anlegen der DB den epgd nicht starten:

Spoiler anzeigen

Code

htpc2 epgd # journalctl -f | grep epgd
Mar 12 18:30:58 htpc2 epgd[28082]: Set locale to 'en_US.UTF-8'
Mar 12 18:30:58 htpc2 epgd[28082]: Loading uuid from '/etc/epgd/uuid' succeeded [10DE58CD-69A0-4506-B624-364D06D38C50]
Mar 12 18:30:58 htpc2 epgd[28082]: Dictionary '/etc/epgd/epg.dat' loaded
Mar 12 18:30:58 htpc2 epgd[28082]: Initialize python script '/etc/epgd/recording.py'
Mar 12 18:30:58 htpc2 epgd[28082]: Loading plugin: /usr/lib/epgd/plugins/libepgd-tvm.so
Mar 12 18:30:58 htpc2 epgd[28082]: Read 23 option from /etc/epgd/epgd.conf
Mar 12 18:30:58 htpc2 epgd[28082]: Using syslog facility 'user' (8), log level set to (1)
Mar 12 18:30:58 htpc2 epgd[28082]: Info: Calling mysql_library_init()
Mar 12 18:30:58 htpc2 epgd[28082]: Info: Stylesheet '/etc/epgd/tvmovie-utf-8.xsl' loaded
Mar 12 18:30:58 htpc2 epgd[28082]: Checking database connection ...
Mar 12 18:30:58 htpc2 epgd[28082]: Calling mysql_init(28082)
Mar 12 18:30:58 htpc2 epgd[28082]: SQL client character now 'utf8'
Mar 12 18:30:58 htpc2 epgd[28082]: Checking table structure and indices ...
Mar 12 18:30:58 htpc2 epgd[28082]: Checking table 'analyse'
Mar 12 18:30:58 htpc2 epgd[28082]: Initialy creating table 'analyse'
Mar 12 18:30:58 htpc2 epgd[28082]: create table analyse(channelid VARCHAR(50), vdr_masterid INT(11) unsigned, vdr_eventid INT(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 INT(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;
Mar 12 18:30:58 htpc2 epgd[28082]: create index idxvdr_masterid on analyse(vdr_masterid);
Mar 12 18:30:58 htpc2 epgd[28082]: Checking table 'channelmap'
Mar 12 18:30:58 htpc2 epgd[28082]: Initialy creating table 'channelmap'
Mar 12 18:30:58 htpc2 epgd[28082]: 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;
Mar 12 18:30:58 htpc2 epgd[28082]: create index idxsourceExtid on channelmap(source, extid);
Mar 12 18:30:58 htpc2 epgd[28082]: create index idxsource on channelmap(source);
Mar 12 18:30:58 htpc2 epgd[28082]: create index idxupdflg on channelmap(updflg);
Mar 12 18:30:59 htpc2 epgd[28082]: create index idxsourcechannelid on channelmap(source, channelid);
Mar 12 18:30:59 htpc2 epgd[28082]: create index idxmergesp on channelmap(mergesp);
Mar 12 18:30:59 htpc2 epgd[28082]: create index idxchannelid on channelmap(channelid);
Mar 12 18:30:59 htpc2 epgd[28082]: Checking table 'components'
Mar 12 18:30:59 htpc2 epgd[28082]: Initialy creating table 'components'
Mar 12 18:30:59 htpc2 epgd[28082]: create table components(eventid INT(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;
Mar 12 18:30:59 htpc2 epgd[28082]: Checking table 'episodes'
Mar 12 18:30:59 htpc2 epgd[28082]: Initialy creating table 'episodes'
Mar 12 18:30:59 htpc2 epgd[28082]: 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;
Mar 12 18:30:59 htpc2 epgd[28082]: create index idxupdsp on episodes(updsp);
Mar 12 18:30:59 htpc2 epgd[28082]: Checking table 'events'
Mar 12 18:30:59 htpc2 epgd[28082]: Initialy creating table 'events'
Mar 12 18:30:59 htpc2 epgd[28082]: create table events(eventid INT(11) unsigned, channelid VARCHAR(50), masterid INT(11) unsigned not null auto_increment, useid INT(11) unsigned, source VARCHAR(10), fileref VARCHAR(50), 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 VARCHAR(3000), actor TEXT, audio VARCHAR(50), category VARCHAR(50), country VARCHAR(50), director TEXT, flags VARCHAR(100), genre VARCHAR(100), info TEXT, music VARCHAR(250), producer TEXT, screenplay VARCHAR(500), shortreview VARCHAR(500), tipp VARCHAR(250), topic VARCHAR(500), year VARCHAR(10), rating VARCHAR(250), numrating INT(2), 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;
Mar 12 18:30:59 htpc2 epgd[28082]: create index idxcomptitle on events(comptitle);
Mar 12 18:30:59 htpc2 epgd[28082]: create index idxsource on events(source);
Mar 12 18:30:59 htpc2 epgd[28082]: create index idxfilerefsource on events(fileref, source);
Mar 12 18:30:59 htpc2 epgd[28082]: create index idxchannelid on events(channelid);
Mar 12 18:30:59 htpc2 epgd[28082]: create index idxuseid on events(useid);
Mar 12 18:30:59 htpc2 epgd[28082]: create index idxuseidchannelid on events(useid, channelid);
Mar 12 18:30:59 htpc2 epgd[28082]: create index idxupdflgupdsp on events(updflg, updsp);
Mar 12 18:30:59 htpc2 epgd[28082]: create index idxsourcechannelid on events(source, channelid);
Mar 12 18:30:59 htpc2 epgd[28082]: create index idxscrsp on events(scrsp);
Mar 12 18:30:59 htpc2 epgd[28082]: create index idxsourceupdsp on events(source, updsp);
Mar 12 18:30:59 htpc2 epgd[28082]: create index idxscrseriesid on events(scrseriesid);
Mar 12 18:30:59 htpc2 epgd[28082]: create index idxchannelidstarttime on events(channelid, starttime);
Mar 12 18:30:59 htpc2 epgd[28082]: Checking table 'fileref'
Mar 12 18:30:59 htpc2 epgd[28082]: Initialy creating table 'fileref'
Mar 12 18:30:59 htpc2 epgd[28082]: 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;
Mar 12 18:30:59 htpc2 epgd[28082]: create index idxSourceFileref on fileref(source, fileref);
Mar 12 18:30:59 htpc2 epgd[28082]: create index idxFileref on fileref(fileref);
Mar 12 18:30:59 htpc2 epgd[28082]: Checking table 'imagerefs'
Mar 12 18:30:59 htpc2 epgd[28082]: Initialy creating table 'imagerefs'
Mar 12 18:30:59 htpc2 epgd[28082]: create table imagerefs(eventid INT(11) unsigned, lfn INT(11), inssp INT(11), updsp INT(11), source VARCHAR(10), fileref VARCHAR(100), imagename VARCHAR(100), PRIMARY KEY(eventid DESC, lfn DESC)) ENGINE InnoDB;
Mar 12 18:30:59 htpc2 epgd[28082]: create index idxlfn on imagerefs(lfn);
Mar 12 18:30:59 htpc2 epgd[28082]: create index idxname on imagerefs(imagename);
Mar 12 18:30:59 htpc2 epgd[28082]: Checking table 'images'
Mar 12 18:30:59 htpc2 epgd[28082]: Initialy creating table 'images'
Mar 12 18:30:59 htpc2 epgd[28082]: create table images(imagename VARCHAR(100), inssp INT(11), updsp INT(11), image MEDIUMBLOB, PRIMARY KEY(imagename DESC)) ENGINE InnoDB;
Mar 12 18:30:59 htpc2 epgd[28082]: Checking table 'movie'
Mar 12 18:30:59 htpc2 epgd[28082]: Initialy creating table 'movie'
Mar 12 18:30:59 htpc2 epgd[28082]: 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;
Mar 12 18:30:59 htpc2 epgd[28082]: create index idxmovie_id on movie(movie_id);
Mar 12 18:30:59 htpc2 epgd[28082]: create index idxmovietitle on movie(movie_title);
Mar 12 18:30:59 htpc2 epgd[28082]: SQL-Error in 'create index idxmovietitle on movie(movie_title);' - Index column size too large. The maximum column size is 767 bytes. (1709)
Mar 12 18:30:59 htpc2 epgd[28082]: SQL-Error in 'createIndices()' - Index column size too large. The maximum column size is 767 bytes. (1709) '' [create index idxmovietitle on movie(movie_title);]
Mar 12 18:30:59 htpc2 epgd[28082]: Checking table 'movie_actor'
Mar 12 18:30:59 htpc2 epgd[28082]: Initialy creating table 'movie_actor'
Mar 12 18:30:59 htpc2 epgd[28082]: create table movie_actor(actor_id INT(11) unsigned, actor_name VARCHAR(300), PRIMARY KEY(actor_id DESC)) ENGINE InnoDB;
Mar 12 18:30:59 htpc2 epgd[28082]: Checking table 'movie_actors'
Mar 12 18:30:59 htpc2 epgd[28082]: Initialy creating table 'movie_actors'
Mar 12 18:30:59 htpc2 epgd[28082]: 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;
Mar 12 18:30:59 htpc2 epgd[28082]: Checking table 'movie_media'
Mar 12 18:30:59 htpc2 epgd[28082]: Initialy creating table 'movie_media'
Mar 12 18:30:59 htpc2 epgd[28082]: 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;
Mar 12 18:30:59 htpc2 epgd[28082]: Checking table 'parameters'
Mar 12 18:30:59 htpc2 epgd[28082]: Initialy creating table 'parameters'
Mar 12 18:30:59 htpc2 epgd[28082]: create table parameters(owner VARCHAR(40), name VARCHAR(40), inssp INT(11), updsp INT(11), value VARCHAR(150), PRIMARY KEY(owner DESC, name DESC)) ENGINE InnoDB;
Mar 12 18:30:59 htpc2 epgd[28082]: Checking table 'recordingdirs'
Mar 12 18:30:59 htpc2 epgd[28082]: Initialy creating table 'recordingdirs'
Mar 12 18:30:59 htpc2 epgd[28082]: create table recordingdirs(vdruuid VARCHAR(40), directory VARCHAR(255), inssp INT(11), updsp INT(11), PRIMARY KEY(vdruuid DESC, directory DESC)) ENGINE InnoDB;
Mar 12 18:30:59 htpc2 epgd[28082]: Checking table 'recordinglist'
Mar 12 18:30:59 htpc2 epgd[28082]: Initialy creating table 'recordinglist'
Mar 12 18:30:59 htpc2 epgd[28082]: 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), vdruuid VARCHAR(40), path VARCHAR(1000), name VARCHAR(1000), folder VARCHAR(1000), title VARCHAR(200), shorttext VARCHAR(300), longdescription MEDIUMTEXT, duration INT(11) unsigned, fsk INT(1) unsigned, eventid INT(11) unsigned, channelid VARCHAR(50), channelname VARCHAR(100) comment 'just a copy', state VARCHAR(1), inuse INT(1) unsigned, job VARCHAR(1), actor TEXT, audio VARCHAR(50), category VARCHAR(50), country VARCHAR(50), director TEXT, flags VARCHAR(100), genre VARCHAR(100), info TEXT, music VARCHAR(250), producer TEXT, screenplay VARCHAR(500), shortreview VARCHAR(500), tipp VARCHAR(250), topic VARCHAR(500), year VARCHAR(10), rating VARCHAR(250), numrating INT(2), 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;
Mar 12 18:30:59 htpc2 epgd[28082]: Checking table 'searchtimers'
Mar 12 18:30:59 htpc2 epgd[28082]: Initialy creating table 'searchtimers'
Mar 12 18:30:59 htpc2 epgd[28082]: 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', chformat VARCHAR(50) comment 'HD,SD', 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\'', year VARCHAR(10) comment 'e.g. \'2010-2015\'', tipp VARCHAR(250), noepgmatch INT(11), state VARCHAR(1) comment 'D - Deleted', namingmode INT(11), 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', 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;
Mar 12 18:30:59 htpc2 epgd[28082]: Checking table 'series'
Mar 12 18:30:59 htpc2 epgd[28082]: Initialy creating table 'series'
Mar 12 18:30:59 htpc2 epgd[28082]: 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;
Mar 12 18:30:59 htpc2 epgd[28082]: Checking table 'series_actor'
Mar 12 18:30:59 htpc2 epgd[28082]: Initialy creating table 'series_actor'
Mar 12 18:30:59 htpc2 epgd[28082]: 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;
Mar 12 18:30:59 htpc2 epgd[28082]: Checking table 'series_episode'
Mar 12 18:30:59 htpc2 epgd[28082]: Initialy creating table 'series_episode'
Mar 12 18:30:59 htpc2 epgd[28082]: 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;
Mar 12 18:30:59 htpc2 epgd[28082]: Checking table 'series_media'
Mar 12 18:30:59 htpc2 epgd[28082]: Initialy creating table 'series_media'
Mar 12 18:30:59 htpc2 epgd[28082]: 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;
Mar 12 18:30:59 htpc2 epgd[28082]: Checking table 'snapshot'
Mar 12 18:30:59 htpc2 epgd[28082]: Initialy creating table 'snapshot'
Mar 12 18:30:59 htpc2 epgd[28082]: create table snapshot(channelid VARCHAR(50), source VARCHAR(10), masterid INT(11) unsigned, eventid INT(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;
Mar 12 18:30:59 htpc2 epgd[28082]: Checking table 'timers'
Mar 12 18:30:59 htpc2 epgd[28082]: Initialy creating table 'timers'
Mar 12 18:30:59 htpc2 epgd[28082]: create table timers(id INT(11) unsigned not null auto_increment, vdruuid VARCHAR(40), inssp INT(11), updsp INT(11), eventid INT(11) unsigned, channelid VARCHAR(50), source VARCHAR(40), state VARCHAR(1) comment '\'D\'eleted, \'R\'unning, \'F\'inished', info VARCHAR(255) comment 'error reason if state is failed', action VARCHAR(1), reason VARCHAR(250), tccmailcnt INT(11), namingmode INT(11), 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), 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;
Mar 12 18:30:59 htpc2 epgd[28082]: Checking table 'timersdone'
Mar 12 18:30:59 htpc2 epgd[28082]: Initialy creating table 'timersdone'
Mar 12 18:30:59 htpc2 epgd[28082]: 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, 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;
Mar 12 18:30:59 htpc2 epgd[28082]: Checking table 'useevents'
Mar 12 18:30:59 htpc2 epgd[28082]: Initialy creating table 'useevents'
Mar 12 18:30:59 htpc2 epgd[28082]: create table useevents(cnt_source VARCHAR(10), cnt_channelid VARCHAR(50), cnt_eventid INT(11) unsigned, cnt_masterid INT(11) unsigned, cnt_useid INT(11) unsigned, sub_source VARCHAR(10), sub_eventid INT(11) unsigned, all_updsp INT(11), cnt_updflg VARCHAR(1), cnt_delflg VARCHAR(1), cnt_fileref VARCHAR(50), 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 VARCHAR(3000), sub_shortreview VARCHAR(500), sub_tipp VARCHAR(250), sub_rating VARCHAR(250), sub_numrating INT(2), sub_topic VARCHAR(500), sub_longdescription MEDIUMTEXT, sub_complongdescription MEDIUMTEXT, cnt_longdescription MEDIUMTEXT, sub_info TEXT, sub_moderator VARCHAR(250), sub_guest TEXT, sub_actor TEXT, sub_producer TEXT, sub_other TEXT, sub_director TEXT, 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;
Mar 12 18:30:59 htpc2 epgd[28082]: Checking table 'users'
Mar 12 18:30:59 htpc2 epgd[28082]: Initialy creating table 'users'
Mar 12 18:30:59 htpc2 epgd[28082]: 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;
Mar 12 18:30:59 htpc2 epgd[28082]: Checking table 'vdrs'
Mar 12 18:30:59 htpc2 epgd[28082]: Initialy creating table 'vdrs'
Mar 12 18:30:59 htpc2 epgd[28082]: 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), state VARCHAR(20), master VARCHAR(1), ip VARCHAR(20), pid INT(11) unsigned, svdrp 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;
Mar 12 18:30:59 htpc2 epgd[28082]: Closing mysql connection and calling mysql_thread_end(28082)
Mar 12 18:30:59 htpc2 epgd[28082]: Calling sd_notify(STOPPING=1$)
Mar 12 18:30:59 htpc2 epgd[28082]: Info: Released the last usage of mysql_lib, calling mysql_library_end() now
Mar 12 18:30:59 htpc2 systemd[1]: epgd.service: Control process exited, code=exited status=1
Mar 12 18:30:59 htpc2 systemd[1]: epgd.service: Unit entered failed state.
Mar 12 18:30:59 htpc2 systemd[1]: epgd.service: Failed with result 'exit-code'.
^C
htpc2 epgd #

Alles anzeigen

Weiß jemand woran das liegen mag? Ach ja, ich verwende folgende MySQL-Version:

Code

mysql  Ver 14.14 Distrib 5.6.27, for Linux (x86_64) using  EditLine wrapper

und der Inhalt von /etc/mysql/my.cnf ist dieser:

Spoiler anzeigen

Code

htpc2 epgd # cat /etc/mysql/my.cnf
# /etc/mysql/my.cnf: The global mysql configuration file.
# $Header: /var/cvsroot/gentoo-x86/dev-db/mysql/files/my.cnf-5.6,v 1.2 2015/03/15 17:31:35 grknight Exp $


# The following options will be passed to all MySQL clients
[client]
#password                                   	= your_password
port                                        	= 3306
socket                                      	= /var/run/mysqld/mysqld.sock
default-character-set=utf8


[code=sql]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8


[mysqladmin]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8


[mysqlcheck]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8


[mysqldump]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8


[mysqlimport]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8


[mysqlshow]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8


[myisamchk]
character-sets-dir=/usr/share/mysql/charsets


[myisampack]
character-sets-dir=/usr/share/mysql/charsets


# use [safe_mysqld] with mysql-3
[mysqld_safe]
err-log                                     	= /var/log/mysql/mysql.err


# add a section [mysqld-4.1] or [mysqld-5.0] for specific configurations
[mysqld]
character-set-server        	= utf8
skip-character-set-client-handshake
collation-server=utf8_unicode_ci
init-connect='SET NAMES utf8'
user                                        	= mysql
port                                        	= 3306
socket                                      	= /var/run/mysqld/mysqld.sock
pid-file                                    	= /var/run/mysqld/mysqld.pid
log-error                                   	= /var/log/mysql/mysqld.err
basedir                                     	= /usr
datadir                                     	= /var/lib/mysql
skip-external-locking
key_buffer_size                     	= 16M
max_allowed_packet                  	= 4M
table_open_cache                    	= 400
sort_buffer_size                    	= 512K
net_buffer_length                   	= 16K
read_buffer_size                    	= 256K
read_rnd_buffer_size        	= 512K
myisam_sort_buffer_size     	= 8M
lc_messages_dir             	= /usr/share/mysql
#Set this to your desired error message language
lc_messages                 	= en_US


# security:
# using "localhost" in connects uses sockets by default
# skip-networking
# bind-address                      	= 127.0.0.1


# log-bin
server-id                                   	= 1


# point the following paths to different dedicated disks
tmpdir                                      	= /tmp/
#log-update                         	= /path-to-dedicated-directory/hostname


# you need the debug USE flag enabled to use the following directives,
# if needed, uncomment them, start the server and issue
# #tail -f /tmp/mysqld.sql /tmp/mysqld.trace
# this will show you *exactly* what's happening in your server ;)


#log                                        	= /tmp/mysqld.sql
#gdb
#debug                                      	= d:t:i:o,/tmp/mysqld.trace
#one-thread


# the rest of the innodb config follows:
# don't eat too much memory, we're trying to be safe on 64Mb boxes
# you might want to bump this up a bit on boxes with more RAM
innodb_buffer_pool_size = 128M
#
# i'd like to use /var/lib/mysql/innodb, but that is seen as a database :-(
# and upstream wants things to be under /var/lib/mysql/, so that's the route
# we have to take for the moment
#innodb_data_home_dir       	= /var/lib/mysql/
#innodb_log_group_home_dir  	= /var/lib/mysql/
# you may wish to change this size to be more suitable for your system
# the max is there to avoid run-away growth on your machine
innodb_data_file_path = ibdata1:10M:autoextend:max:128M
# we keep this at around 25% of of innodb_buffer_pool_size
# sensible values range from 1MB to (1/innodb_log_files_in_group*innodb_buffer_pool_size)
innodb_log_file_size = 48M
# this is the default, increase it if you have very large transactions going on
innodb_log_buffer_size = 8M
# this is the default and won't hurt you
# you shouldn't need to tweak it
innodb_log_files_in_group=2
# see the innodb config docs, the other options are not always safe
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
innodb_file_per_table
innodb_large_prefix=ON


# Uncomment this to get FEDERATED engine support
#plugin-load=federated=ha_federated.so
loose-federated


[mysqldump]
quick
max_allowed_packet                  	= 16M


[code=sql]
# uncomment the next directive if you are not familiar with SQL
#safe-updates


[isamchk]
key_buffer_size                     	= 20M
sort_buffer_size                    	= 20M
read_buffer                         	= 2M
write_buffer                        	= 2M


[myisamchk]
key_buffer_size                     	= 20M
sort_buffer_size                    	= 20M
read_buffer_size                    	= 2M
write_buffer_size                   	= 2M


[mysqlhotcopy]
interactive-timeout

Alles anzeigen

Ich hätte gedacht, innodb_large_prefix=ON sollte helfen...

Gruß,
Lucian

iNOB · 13. März 2016

Ich meine mich zu entsinnen, dass ich den Fehler auch mal hatte und erst mit Löschen und Anlegen einer komplett neuen Datenbank der Fehler beseitigt war (epgd-tool -new-db).

magicamun · 13. März 2016

Geile Arbeit - noch ein paar Kleinigkeiten aber schon sehr gut.

"Suchen" geht "irgendwie" nicht

]Im Suchtimer wäre es schön auch "Genre" als Suchkriterium zu haben

*Auf Mobilen Geräten (iPad) ist die Anzeige viel zu klein - man kann sie zwar vergößern - aber handlich ist das dann auch nicht

Zoolook · 13. März 2016

Zitat von iNOB

Ich meine mich zu entsinnen, dass ich den Fehler auch mal hatte und erst mit Löschen und Anlegen einer komplett neuen Datenbank der Fehler beseitigt war (epgd-tool -new-db).

Ja, den Gedanken hatte ich auch, aber es hat nichts gebracht. Die DB ist nun leer, und trotzdem kommt der Fehler. Heute habe ich sogar auch MySQL komplett neu initialisiert (mit dem alten my.cnf), nachdem ich die alten Daten von der Platte gelöscht habe, denn für was anderes als EPGd nutze ich es nicht, und trotzdem, gleiches Verhalten...

iNOB · 13. März 2016

Häng mal das an das Ende von my.cnf und starte mysql neu, vielleicht bringts was:

Code

sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

Zoolook · 13. März 2016

Zitat von iNOB
Häng mal das an das Ende von my.cnf und starte mysql neu, vielleicht bringts was:
Code
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

Ich vermute Du meintest in der [mysqld]-Sektion der my.cnf? Ich habe's mal sicherheitshalber sowhohl dort alc auch am Ende der my.cnf ist eine Sektion [mysqlhotcopy] hinzu gefügt, leider ohne erfolg:

Spoiler anzeigen

Code

htpc2 epgd # journalctl -f | grep 'epgd\['
Mar 13 11:07:01 htpc2 epgd[15543]: Set locale to 'en_US.UTF-8'
Mar 13 11:07:01 htpc2 epgd[15543]: Loading uuid from '/etc/epgd/uuid' succeeded [10DE58CD-69A0-4506-B624-364D06D38C50]
Mar 13 11:07:01 htpc2 epgd[15543]: Dictionary '/etc/epgd/epg.dat' loaded
Mar 13 11:07:01 htpc2 epgd[15543]: Initialize python script '/etc/epgd/recording.py'
Mar 13 11:07:01 htpc2 epgd[15543]: Loading plugin: /usr/lib/epgd/plugins/libepgd-tvm.so
Mar 13 11:07:01 htpc2 epgd[15543]: Read 23 option from /etc/epgd/epgd.conf
Mar 13 11:07:01 htpc2 epgd[15543]: Using syslog facility 'user' (8), log level set to (1)
Mar 13 11:07:01 htpc2 epgd[15543]: Info: Calling mysql_library_init()
Mar 13 11:07:01 htpc2 epgd[15543]: Info: Stylesheet '/etc/epgd/tvmovie-utf-8.xsl' loaded
Mar 13 11:07:01 htpc2 epgd[15543]: Checking database connection ...
Mar 13 11:07:01 htpc2 epgd[15543]: Calling mysql_init(15543)
Mar 13 11:07:01 htpc2 epgd[15543]: SQL client character now 'utf8'
Mar 13 11:07:01 htpc2 epgd[15543]: Checking table structure and indices ...
Mar 13 11:07:01 htpc2 epgd[15543]: Checking table 'analyse'
Mar 13 11:07:01 htpc2 epgd[15543]: Checking table 'channelmap'
Mar 13 11:07:01 htpc2 epgd[15543]: Checking table 'components'
Mar 13 11:07:01 htpc2 epgd[15543]: Checking table 'episodes'
Mar 13 11:07:01 htpc2 epgd[15543]: Checking table 'events'
Mar 13 11:07:01 htpc2 epgd[15543]: Checking table 'fileref'
Mar 13 11:07:01 htpc2 epgd[15543]: Checking table 'imagerefs'
Mar 13 11:07:01 htpc2 epgd[15543]: Checking table 'images'
Mar 13 11:07:01 htpc2 epgd[15543]: Checking table 'movie'
Mar 13 11:07:01 htpc2 epgd[15543]: create index idxmovietitle on movie(movie_title);
Mar 13 11:07:01 htpc2 epgd[15543]: SQL-Error in 'create index idxmovietitle on movie(movie_title);' - Index column size too large. The maximum column size is 767 bytes. (1709)
Mar 13 11:07:01 htpc2 epgd[15543]: SQL-Error in 'createIndices()' - Index column size too large. The maximum column size is 767 bytes. (1709) '' [create index idxmovietitle on movie(movie_title);]
Mar 13 11:07:01 htpc2 epgd[15543]: Checking table 'movie_actor'
Mar 13 11:07:01 htpc2 epgd[15543]: Checking table 'movie_actors'
Mar 13 11:07:01 htpc2 epgd[15543]: Checking table 'movie_media'
Mar 13 11:07:01 htpc2 epgd[15543]: Checking table 'parameters'
Mar 13 11:07:01 htpc2 epgd[15543]: Checking table 'recordingdirs'
Mar 13 11:07:01 htpc2 epgd[15543]: Checking table 'recordinglist'
Mar 13 11:07:01 htpc2 epgd[15543]: Checking table 'searchtimers'
Mar 13 11:07:01 htpc2 epgd[15543]: Checking table 'series'
Mar 13 11:07:01 htpc2 epgd[15543]: Checking table 'series_actor'
Mar 13 11:07:01 htpc2 epgd[15543]: Checking table 'series_episode'
Mar 13 11:07:01 htpc2 epgd[15543]: Checking table 'series_media'
Mar 13 11:07:01 htpc2 epgd[15543]: Checking table 'snapshot'
Mar 13 11:07:01 htpc2 epgd[15543]: create index idxchannelid on snapshot(channelid);
Mar 13 11:07:01 htpc2 epgd[15543]: create index idxstarttimeSource on snapshot(starttime, source);
Mar 13 11:07:01 htpc2 epgd[15543]: Checking table 'timers'
Mar 13 11:07:01 htpc2 epgd[15543]: create index idxeventidchannelidvdruuid on timers(eventid, channelid, vdruuid);
Mar 13 11:07:01 htpc2 epgd[15543]: Checking table 'timersdone'
Mar 13 11:07:01 htpc2 epgd[15543]: create index idxcheckdoubles on timersdone(comptitle);
Mar 13 11:07:01 htpc2 epgd[15543]: Checking table 'useevents'
Mar 13 11:07:01 htpc2 epgd[15543]: create index idxchannelidstarttime on useevents(cnt_channelid, cnt_starttime);
Mar 13 11:07:01 htpc2 epgd[15543]: create index idxuseid on useevents(cnt_useid);
Mar 13 11:07:01 htpc2 epgd[15543]: create index idxchannelidupdflgupdsp on useevents(cnt_channelid, cnt_updflg, all_updsp);
Mar 13 11:07:01 htpc2 epgd[15543]: create index idxchannelid on useevents(cnt_channelid);
Mar 13 11:07:01 htpc2 epgd[15543]: create index idxupdflgstarttimeduration on useevents(all_updsp, cnt_starttime, cnt_duration);
Mar 13 11:07:01 htpc2 epgd[15543]: Checking table 'users'
Mar 13 11:07:01 htpc2 epgd[15543]: Checking table 'vdrs'
Mar 13 11:07:01 htpc2 epgd[15543]: Closing mysql connection and calling mysql_thread_end(15543)
Mar 13 11:07:01 htpc2 epgd[15543]: Calling sd_notify(STOPPING=1$)
Mar 13 11:07:01 htpc2 epgd[15543]: Info: Released the last usage of mysql_lib, calling mysql_library_end() now

Alles anzeigen

iNOB · 13. März 2016

Bist du dir sicher, den richtigen branch von vdr-epg-daemon (https://projects.vdr-developer.org/git/vdr-epg-daemon.git) erwischt zu haben?

Code

git branch -a
* http
  master
  remotes/origin/HEAD -> origin/master
  remotes/origin/dev
  remotes/origin/dev1
  remotes/origin/devmg
  remotes/origin/http
  remotes/origin/master
  remotes/origin/merge-devel

rechner · 13. März 2016

Zitat von magicamun

"Suchen" geht "irgendwie" nicht
]Im Suchtimer wäre es schön auch "Genre" als Suchkriterium zu haben
*Auf Mobilen Geräten (iPad) ist die Anzeige viel zu klein - man kann sie zwar vergößern - aber handlich ist das dann auch nicht

Kannst du das genauer beschreiben, was geht nicht?

Zitat von magicamun

Im Suchtimer wäre es schön auch "Genre" als Suchkriterium zu haben

Wenn du erweitert anklickst, kannst du die Kategorie/Genre auswählen, das ist allerdings im Backend noch nicht realisiert, glaube ich

Zitat von magicamun

Auf Mobilen Geräten (iPad) ist die Anzeige viel zu klein - man kann sie zwar vergößern - aber handlich ist das dann auch nicht

Welche Anzeige meinst du? Ich benutze es immer auf meinem galaxy tab (10") und manchmal auf meinem Handy(4.5").
Horchi schaut sich dass ab und zu auf einem ipad mini an. Ich bin gerne bereit, die ein oder andere Sache anzupassen, soweit es geht, aber dann musst du schon konkreter werden

gruss
Rechner

Zoolook · 13. März 2016

Zitat von iNOB

Bist du dir sicher, den richtigen branch von vdr-epg-daemon (https://projects.vdr-developer.org/git/vdr-epg-daemon.git) erwischt zu haben?

Ja, ganz sicher nehme ich den "http"-Branch, der ja auch einen entsprechenden epghttpd daemon baut und eine neue dictionary-Datei /etc/epgd/epg.dat eingeführt hat, das wird mit installiert.

magicamun · 13. März 2016

Suchen:

Ich gebe in Suchmuster z.B. Tagesschau ein und drücke "suchen" - vollkoemmen regungslos - kein Ergebnis

Genre:

In den erweiterten Suchoptionen kann man die Kategroei auswählen - das ist soweit i.O - Genre wäre zusätzlich hilfreich - das sind zwei verschiedene Informationen

iPad:
Komisches Phänomen - wenn ich ohne Benutzerlogin arbeite ist das Magazin oben links in der Ecke - so klein, dass man nichts lesen kann - wenn man mit Anmeldung arbeitet, ist das Layout/die Größe i.O

447377 · 13. März 2016

Zitat von Zoolook

Mar 12 18:30:59 htpc2 epgd[28082]: SQL-Error in 'create index idxmovietitle on movie(movie_title);' - Index column size too large. The maximum column size is 767 bytes. (1709) Mar 12 18:30:59 htpc2 epgd[28082]: SQL-Error in 'createIndices()' - Index column size too large. The maximum column size is 767 bytes. (1709)

Schaue Dir mal diesen Beitrag an:
http://www.vdr-portal.de/board…7-bytes-1071/#post1223543
...Ich änderte stattdessen das Row_format von Compact auf Dynamic für die Table Movie. Und schon gehen mehr als 255 Zeichen bzw. 767 bytes...

Gruß
Stefan

CKone · 13. März 2016

Hier ist auch auf Blackberry Classic und iPad mini alles super ...

Christian

lostinspc · 13. März 2016

Zitat von Zoolook

Ja, ganz sicher nehme ich den "http"-Branch, der ja auch einen entsprechenden epghttpd daemon baut und eine neue dictionary-Datei /etc/epgd/epg.dat eingeführt hat, das wird mit installiert.

Zoolook:
Ich habe mir gestern auch mal epgd http gegeben, allerdings ohne vorherige epgd-Erfahrung.
Hatte die gleiche Fehlermeldung wie du.
Bei mir lag es am falschen epg2vdr (!) -Branch (du brauchst sowohl für epgd als auch für epg2vdr den http-Branch).

Peter

btw: coole Sache, dieses epgd-http

lostinspc · 13. März 2016

Zitat von magicamun

Suchen:

Ich gebe in Suchmuster z.B. Tagesschau ein und drücke "suchen" - vollkoemmen regungslos - kein Ergebnis

Funktioniert hier problemlos, gibt so ca 100 Treffer ...

Zoolook · 13. März 2016

Zitat von lostinspc

Ich habe mir gestern auch mal epgd http gegeben, allerdings ohne vorherige epgd-Erfahrung.
Hatte die gleiche Fehlermeldung wie du.
Bei mir lag es am falschen epg2vdr (!) -Branch (du brauchst sowohl für epgd als auch für epg2vdr den http-Branch).

Nun, ich stieg eben um weil ich erst vor einiger Zeit das vdr-epg2vdr Plugin auf diesen neune Branch aktualisiert hatte, nicht alles sorgfältig damals gelesen (war wie so oft spät vor'm Haja) und danach merkte ich daß ich gar kein EPG mehr hatte. Das Problem bei mir ist aber nun daß der EPGd erst gar nicht mehr startet wegen dem Fehler, das entsprechende VDR-Plugin sollte doch nur auf VDR-Seite einen Einfluss haben.

Zitat von 447377

Schaue Dir mal diesen Beitrag an:
http://www.vdr-portal.de/board16-video-d…71/#post1223543
...Ich änderte stattdessen das Row_format von Compact auf Dynamic für die Table Movie. Und schon gehen mehr als 255 Zeichen bzw. 767 bytes...

Ja, den hatte ich gestern Abend auch gefunden und befolgt, bloß nicht mehr in meiner Problembeschreibung erwähnt, ich hatte irgendwie den Eindruck bei mir bringt das nichts, sämtliche ROW-Formats bleiben immer nocht "Compact". Ich habe es jetzt nochmal gemacht und poste mal hier den output, vielelicht versteht jemand was davon:

Spoiler anzeigen

Code

htpc2 ~ # mysql -u epg2vdr -pepg -Depg2vdr -h localhost
Warning: Using a password on the command line interface can be insecure.
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A


Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 177
Server version: 5.6.27 Source distribution


Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.


Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.


Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.


mysql> SHOW TABLE STATUS;
+----------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------+
| Name       	| Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time     	| Update_time | Check_time | Collation   	| Checksum | Create_options | Comment |
+----------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------+
| analyse    	| InnoDB |  	10 | Compact	|	0 |          	0 |   	16384 |           	0 |        	0 |     	0 |       	NULL | 2016-03-13 11:04:52 | NULL    	| NULL   	| utf8_general_ci | 	NULL |            	|     	|
| channelmap 	| InnoDB |  	10 | Compact	|	0 |          	0 |   	16384 |           	0 |        	0 |     	0 |       	NULL | 2016-03-13 11:04:52 | NULL    	| NULL   	| utf8_general_ci | 	NULL |            	|     	|
| components 	| InnoDB |  	10 | Compact	|	0 |          	0 |   	16384 |           	0 |        	0 |     	0 |       	NULL | 2016-03-13 11:04:52 | NULL    	| NULL   	| utf8_general_ci | 	NULL |            	|     	|
| episodes   	| InnoDB |  	10 | Compact	|	0 |          	0 |   	16384 |           	0 |        	0 |     	0 |       	NULL | 2016-03-13 11:04:52 | NULL    	| NULL   	| utf8_general_ci | 	NULL |            	|     	|
| events     	| InnoDB |  	10 | Compact	|	0 |          	0 |   	16384 |           	0 |   	163840 |     	0 |          	1 | 2016-03-13 11:04:53 | NULL    	| NULL   	| utf8_general_ci | 	NULL |            	|     	|
| fileref    	| InnoDB |  	10 | Compact	|	0 |          	0 |   	16384 |           	0 |        	0 |     	0 |       	NULL | 2016-03-13 11:04:53 | NULL    	| NULL   	| utf8_general_ci | 	NULL |            	|     	|
| imagerefs  	| InnoDB |  	10 | Compact	|	0 |          	0 |   	16384 |           	0 |        	0 |     	0 |       	NULL | 2016-03-13 11:04:53 | NULL    	| NULL   	| utf8_general_ci | 	NULL |            	|     	|
| images     	| InnoDB |  	10 | Compact	|	0 |          	0 |   	16384 |           	0 |        	0 |     	0 |       	NULL | 2016-03-13 11:04:53 | NULL    	| NULL   	| utf8_general_ci | 	NULL |            	|     	|
| movie      	| InnoDB |  	10 | Compact	|	0 |          	0 |   	16384 |           	0 |        	0 |     	0 |       	NULL | 2016-03-13 11:04:53 | NULL    	| NULL   	| utf8_general_ci | 	NULL |            	|     	|
| movie_actor	| InnoDB |  	10 | Compact	|	0 |          	0 |   	16384 |           	0 |        	0 |     	0 |       	NULL | 2016-03-13 11:04:50 | NULL    	| NULL   	| utf8_general_ci | 	NULL |            	|     	|
| movie_actors   | InnoDB |  	10 | Compact	|	0 |          	0 |   	16384 |           	0 |        	0 |     	0 |       	NULL | 2016-03-13 11:04:50 | NULL    	| NULL   	| utf8_general_ci | 	NULL |            	|     	|
| movie_media	| InnoDB |  	10 | Compact	|	0 |          	0 |   	16384 |           	0 |        	0 |     	0 |       	NULL | 2016-03-13 11:04:50 | NULL    	| NULL   	| utf8_general_ci | 	NULL |            	|     	|
| parameters 	| InnoDB |  	10 | Compact	|	0 |          	0 |   	16384 |           	0 |        	0 |     	0 |       	NULL | 2016-03-13 11:04:53 | NULL    	| NULL   	| utf8_general_ci | 	NULL |            	|     	|
| recordingdirs  | InnoDB |  	10 | Compact	|	0 |          	0 |   	16384 |           	0 |        	0 |     	0 |       	NULL | 2016-03-13 11:04:53 | NULL    	| NULL   	| utf8_general_ci | 	NULL |            	|     	|
| recordinglist  | InnoDB |  	10 | Compact	|	0 |          	0 |   	16384 |           	0 |        	0 |     	0 |       	NULL | 2016-03-13 11:04:53 | NULL    	| NULL   	| utf8_general_ci | 	NULL |            	|     	|
| recordings 	| InnoDB |  	10 | Compact	|	0 |          	0 |   	16384 |           	0 |        	0 |     	0 |       	NULL | 2016-03-13 11:04:50 | NULL    	| NULL   	| utf8_general_ci | 	NULL |            	|     	|
| searchtimers   | InnoDB |  	10 | Compact	|	0 |          	0 |   	16384 |           	0 |        	0 |     	0 |          	1 | 2016-03-13 11:04:53 | NULL    	| NULL   	| utf8_general_ci | 	NULL |            	|     	|
| series     	| InnoDB |  	10 | Compact	|	0 |          	0 |   	16384 |           	0 |        	0 |     	0 |       	NULL | 2016-03-13 11:04:53 | NULL    	| NULL   	| utf8_general_ci | 	NULL |            	|     	|
| series_actor   | InnoDB |  	10 | Compact	|	0 |          	0 |   	16384 |           	0 |        	0 |     	0 |       	NULL | 2016-03-13 11:04:50 | NULL    	| NULL   	| utf8_general_ci | 	NULL |            	|     	|
| series_episode | InnoDB |  	10 | Compact	|	0 |          	0 |   	16384 |           	0 |        	0 |     	0 |       	NULL | 2016-03-13 11:04:53 | NULL    	| NULL   	| utf8_general_ci | 	NULL |            	|     	|
| series_media   | InnoDB |  	10 | Compact	|	0 |          	0 |   	16384 |           	0 |    	65536 |     	0 |       	NULL | 2016-03-13 11:04:53 | NULL    	| NULL   	| utf8_general_ci | 	NULL |            	|     	|
| snapshot   	| InnoDB |  	10 | Compact	|	0 |          	0 |   	16384 |           	0 |        	0 |     	0 |       	NULL | 2016-03-13 11:07:01 | NULL    	| NULL   	| utf8_general_ci | 	NULL |            	|     	|
| timers     	| InnoDB |  	10 | Compact	|	0 |          	0 |   	16384 |           	0 |        	0 |     	0 |          	1 | 2016-03-13 11:07:01 | NULL    	| NULL   	| utf8_general_ci | 	NULL |            	|     	|
| timersdone 	| InnoDB |  	10 | Compact	|	0 |          	0 |   	16384 |           	0 |        	0 |     	0 |          	1 | 2016-03-13 11:07:01 | NULL    	| NULL   	| utf8_general_ci | 	NULL |            	|     	|
| useevents  	| InnoDB |  	10 | Compact	|	0 |          	0 |   	16384 |           	0 |        	0 |     	0 |       	NULL | 2016-03-13 11:07:01 | NULL    	| NULL   	| utf8_general_ci | 	NULL |            	|     	|
| users      	| InnoDB |  	10 | Compact	|	0 |          	0 |   	16384 |           	0 |        	0 |     	0 |       	NULL | 2016-03-13 11:04:53 | NULL    	| NULL   	| utf8_general_ci | 	NULL |            	|     	|
| vdrs       	| InnoDB |  	10 | Compact	|	1 |      	16384 |   	16384 |           	0 |    	16384 |     	0 |       	NULL | 2016-03-13 11:04:53 | NULL    	| NULL   	| utf8_general_ci | 	NULL |            	|     	|
+----------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+----------------+---------+
27 rows in set (0.00 sec)


mysql> ALTER TABLE movie ROW_FORMAT=DYNAMIC;
Query OK, 0 rows affected, 2 warnings (0.04 sec)
Records: 0  Duplicates: 0  Warnings: 2


mysql> SHOW TABLE STATUS;
+----------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+--------------------+---------+
| Name       	| Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time     	| Update_time | Check_time | Collation   	| Checksum | Create_options 	| Comment |
+----------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+--------------------+---------+
| analyse    	| InnoDB |  	10 | Compact	|	0 |          	0 |   	16384 |           	0 |        	0 |     	0 |       	NULL | 2016-03-13 11:04:52 | NULL    	| NULL   	| utf8_general_ci | 	NULL |                	|     	|
| channelmap 	| InnoDB |  	10 | Compact	|	0 |          	0 |   	16384 |           	0 |        	0 |     	0 |       	NULL | 2016-03-13 11:04:52 | NULL    	| NULL   	| utf8_general_ci | 	NULL |                	|     	|
| components 	| InnoDB |  	10 | Compact	|	0 |          	0 |   	16384 |           	0 |        	0 |     	0 |       	NULL | 2016-03-13 11:04:52 | NULL    	| NULL   	| utf8_general_ci | 	NULL |                	|     	|
| episodes   	| InnoDB |  	10 | Compact	|	0 |          	0 |   	16384 |           	0 |        	0 |     	0 |       	NULL | 2016-03-13 11:04:52 | NULL    	| NULL   	| utf8_general_ci | 	NULL |                	|     	|
| events     	| InnoDB |  	10 | Compact	|	0 |          	0 |   	16384 |           	0 |   	163840 |     	0 |          	1 | 2016-03-13 11:04:53 | NULL    	| NULL   	| utf8_general_ci | 	NULL |                	|     	|
| fileref    	| InnoDB |  	10 | Compact	|	0 |          	0 |   	16384 |           	0 |        	0 |     	0 |       	NULL | 2016-03-13 11:04:53 | NULL    	| NULL   	| utf8_general_ci | 	NULL |                	|     	|
| imagerefs  	| InnoDB |  	10 | Compact	|	0 |          	0 |   	16384 |           	0 |        	0 |     	0 |       	NULL | 2016-03-13 11:04:53 | NULL    	| NULL   	| utf8_general_ci | 	NULL |                	|     	|
| images     	| InnoDB |  	10 | Compact	|	0 |          	0 |   	16384 |           	0 |        	0 |     	0 |       	NULL | 2016-03-13 11:04:53 | NULL    	| NULL   	| utf8_general_ci | 	NULL |                	|     	|
| movie      	| InnoDB |  	10 | Compact	|	0 |          	0 |   	16384 |           	0 |    	16384 |     	0 |       	NULL | 2016-03-13 13:50:06 | NULL    	| NULL   	| utf8_general_ci | 	NULL | row_format=DYNAMIC |     	|
| movie_actor	| InnoDB |  	10 | Compact	|	0 |          	0 |   	16384 |           	0 |        	0 |     	0 |       	NULL | 2016-03-13 11:04:50 | NULL    	| NULL   	| utf8_general_ci | 	NULL |                	|     	|
| movie_actors   | InnoDB |  	10 | Compact	|	0 |          	0 |   	16384 |           	0 |        	0 |     	0 |       	NULL | 2016-03-13 11:04:50 | NULL    	| NULL   	| utf8_general_ci | 	NULL |                	|     	|
| movie_media	| InnoDB |  	10 | Compact	|	0 |          	0 |   	16384 |           	0 |        	0 |     	0 |       	NULL | 2016-03-13 11:04:50 | NULL    	| NULL   	| utf8_general_ci | 	NULL |                	|     	|
| parameters 	| InnoDB |  	10 | Compact	|	0 |          	0 |   	16384 |           	0 |        	0 |     	0 |       	NULL | 2016-03-13 11:04:53 | NULL    	| NULL   	| utf8_general_ci | 	NULL |                	|     	|
| recordingdirs  | InnoDB |  	10 | Compact	|	0 |          	0 |   	16384 |           	0 |        	0 |     	0 |       	NULL | 2016-03-13 11:04:53 | NULL    	| NULL   	| utf8_general_ci | 	NULL |                	|     	|
| recordinglist  | InnoDB |  	10 | Compact	|	0 |          	0 |   	16384 |           	0 |        	0 |     	0 |       	NULL | 2016-03-13 11:04:53 | NULL    	| NULL   	| utf8_general_ci | 	NULL |                	|     	|
| recordings 	| InnoDB |  	10 | Compact	|	0 |          	0 |   	16384 |           	0 |        	0 |     	0 |       	NULL | 2016-03-13 11:04:50 | NULL    	| NULL   	| utf8_general_ci | 	NULL |                	|     	|
| searchtimers   | InnoDB |  	10 | Compact	|	0 |          	0 |   	16384 |           	0 |        	0 |     	0 |          	1 | 2016-03-13 11:04:53 | NULL    	| NULL   	| utf8_general_ci | 	NULL |                	|     	|
| series     	| InnoDB |  	10 | Compact	|	0 |          	0 |   	16384 |           	0 |        	0 |     	0 |       	NULL | 2016-03-13 11:04:53 | NULL    	| NULL   	| utf8_general_ci | 	NULL |                	|     	|
| series_actor   | InnoDB |  	10 | Compact	|	0 |          	0 |   	16384 |           	0 |        	0 |     	0 |       	NULL | 2016-03-13 11:04:50 | NULL    	| NULL   	| utf8_general_ci | 	NULL |                	|     	|
| series_episode | InnoDB |  	10 | Compact	|	0 |          	0 |   	16384 |           	0 |        	0 |     	0 |       	NULL | 2016-03-13 11:04:53 | NULL    	| NULL   	| utf8_general_ci | 	NULL |                	|     	|
| series_media   | InnoDB |  	10 | Compact	|	0 |          	0 |   	16384 |           	0 |    	65536 |     	0 |       	NULL | 2016-03-13 11:04:53 | NULL    	| NULL   	| utf8_general_ci | 	NULL |                	|     	|
| snapshot   	| InnoDB |  	10 | Compact	|	0 |          	0 |   	16384 |           	0 |        	0 |     	0 |       	NULL | 2016-03-13 11:07:01 | NULL    	| NULL   	| utf8_general_ci | 	NULL |                	|     	|
| timers     	| InnoDB |  	10 | Compact	|	0 |          	0 |   	16384 |           	0 |        	0 |     	0 |          	1 | 2016-03-13 11:07:01 | NULL    	| NULL   	| utf8_general_ci | 	NULL |                	|     	|
| timersdone 	| InnoDB |  	10 | Compact	|	0 |          	0 |   	16384 |           	0 |        	0 |     	0 |          	1 | 2016-03-13 11:07:01 | NULL    	| NULL   	| utf8_general_ci | 	NULL |                	|     	|
| useevents  	| InnoDB |  	10 | Compact	|	0 |          	0 |   	16384 |           	0 |        	0 |     	0 |       	NULL | 2016-03-13 11:07:01 | NULL    	| NULL   	| utf8_general_ci | 	NULL |                	|     	|
| users      	| InnoDB |  	10 | Compact	|	0 |          	0 |   	16384 |           	0 |        	0 |     	0 |       	NULL | 2016-03-13 11:04:53 | NULL    	| NULL   	| utf8_general_ci | 	NULL |                	|     	|
| vdrs       	| InnoDB |  	10 | Compact	|	1 |      	16384 |   	16384 |           	0 |    	16384 |     	0 |       	NULL | 2016-03-13 11:04:53 | NULL    	| NULL   	| utf8_general_ci | 	NULL |                	|     	|
+----------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-----------------+----------+--------------------+---------+
27 rows in set (0.00 sec)


mysql>

Alles anzeigen

leider immer noch mit diesem Ergebnis:

Spoiler anzeigen

Code

htpc2 epgd # journalctl -f | grep 'epgd\['
Mar 13 13:59:42 htpc2 epgd[19153]: Set locale to 'en_US.UTF-8'
Mar 13 13:59:42 htpc2 epgd[19153]: Loading uuid from '/etc/epgd/uuid' succeeded [10DE58CD-69A0-4506-B624-364D06D38C50]
Mar 13 13:59:42 htpc2 epgd[19153]: Dictionary '/etc/epgd/epg.dat' loaded
Mar 13 13:59:42 htpc2 epgd[19153]: Initialize python script '/etc/epgd/recording.py'
Mar 13 13:59:43 htpc2 epgd[19153]: Loading plugin: /usr/lib/epgd/plugins/libepgd-tvm.so
Mar 13 13:59:43 htpc2 epgd[19153]: Read 23 option from /etc/epgd/epgd.conf
Mar 13 13:59:43 htpc2 epgd[19153]: Using syslog facility 'user' (8), log level set to (1)
Mar 13 13:59:43 htpc2 epgd[19153]: Info: Calling mysql_library_init()
Mar 13 13:59:43 htpc2 epgd[19153]: Info: Stylesheet '/etc/epgd/tvmovie-utf-8.xsl' loaded
Mar 13 13:59:43 htpc2 epgd[19153]: Checking database connection ...
Mar 13 13:59:43 htpc2 epgd[19153]: Calling mysql_init(19153)
Mar 13 13:59:43 htpc2 epgd[19153]: SQL client character now 'utf8'
Mar 13 13:59:43 htpc2 epgd[19153]: Checking table structure and indices ...
Mar 13 13:59:43 htpc2 epgd[19153]: Checking table 'analyse'
Mar 13 13:59:43 htpc2 epgd[19153]: Checking table 'channelmap'
Mar 13 13:59:43 htpc2 epgd[19153]: Checking table 'components'
Mar 13 13:59:43 htpc2 epgd[19153]: Checking table 'episodes'
Mar 13 13:59:43 htpc2 epgd[19153]: Checking table 'events'
Mar 13 13:59:43 htpc2 epgd[19153]: Checking table 'fileref'
Mar 13 13:59:43 htpc2 epgd[19153]: Checking table 'imagerefs'
Mar 13 13:59:43 htpc2 epgd[19153]: Checking table 'images'
Mar 13 13:59:43 htpc2 epgd[19153]: Checking table 'movie'
Mar 13 13:59:43 htpc2 epgd[19153]: create index idxmovietitle on movie(movie_title);
Mar 13 13:59:43 htpc2 epgd[19153]: SQL-Error in 'create index idxmovietitle on movie(movie_title);' - Index column size too large. The maximum column size is 767 bytes. (1709)
Mar 13 13:59:43 htpc2 epgd[19153]: SQL-Error in 'createIndices()' - Index column size too large. The maximum column size is 767 bytes. (1709) '' [create index idxmovietitle on movie(movie_title);]
Mar 13 13:59:43 htpc2 epgd[19153]: Checking table 'movie_actor'
Mar 13 13:59:43 htpc2 epgd[19153]: Checking table 'movie_actors'
Mar 13 13:59:43 htpc2 epgd[19153]: Checking table 'movie_media'
Mar 13 13:59:43 htpc2 epgd[19153]: Checking table 'parameters'
Mar 13 13:59:43 htpc2 epgd[19153]: Checking table 'recordingdirs'
Mar 13 13:59:43 htpc2 epgd[19153]: Checking table 'recordinglist'
Mar 13 13:59:43 htpc2 epgd[19153]: Checking table 'searchtimers'
Mar 13 13:59:43 htpc2 epgd[19153]: Checking table 'series'
Mar 13 13:59:43 htpc2 epgd[19153]: Checking table 'series_actor'
Mar 13 13:59:43 htpc2 epgd[19153]: Checking table 'series_episode'
Mar 13 13:59:43 htpc2 epgd[19153]: Checking table 'series_media'
Mar 13 13:59:43 htpc2 epgd[19153]: Checking table 'snapshot'
Mar 13 13:59:43 htpc2 epgd[19153]: Checking table 'timers'
Mar 13 13:59:43 htpc2 epgd[19153]: Checking table 'timersdone'
Mar 13 13:59:43 htpc2 epgd[19153]: Checking table 'useevents'
Mar 13 13:59:43 htpc2 epgd[19153]: Checking table 'users'
Mar 13 13:59:43 htpc2 epgd[19153]: Checking table 'vdrs'
Mar 13 13:59:43 htpc2 epgd[19153]: Closing mysql connection and calling mysql_thread_end(19153)
Mar 13 13:59:43 htpc2 epgd[19153]: Calling sd_notify(STOPPING=1$)
Mar 13 13:59:43 htpc2 epgd[19153]: Info: Released the last usage of mysql_lib, calling mysql_library_end() now

Alles anzeigen

Gruß,
Lucian

iNOB · 13. März 2016

Gibts eine Möglichkeit seine "alten" Suchtimer (72 St.) von epgsearch ebenfalls zu übernehmen? Die jetzt alle neu reinzutickern ist recht mühsam...

magicamun · 13. März 2016

So - suchen geht auch (woeder) - Neustart des epghttpd.

Ich hatte rund 40 Suchtimer (manuell übernommen) - war lästig aber das aufräumen hat auch nicht geschadet.

447377 · 13. März 2016

Zitat von Zoolook

Ja, den hatte ich gestern Abend auch gefunden und befolgt, bloß nicht mehr in meiner Problembeschreibung erwähnt, ich hatte irgendwie den Eindruck bei mir bringt das nichts, sämtliche ROW-Formats bleiben immer nocht "Compact". Ich habe es jetzt nochmal gemacht und poste mal hier den output, vielelicht versteht jemand was davon:

Und die /etc/my.cnf hast Du auch entsprechend angepasst?

Stefan

iNOB · 13. März 2016

Was muss ich den machen, dass er mit dem Suchtimer "Grey's Anatomy" was findet? Der epghttp-daemon schmeisst mir dann auch gleich ne Fehlermeldung raus:

Spoiler anzeigen

Muss ich das Semikolon irgendwie maskieren?

[Edit] Nicht schön, aber so gehts: Grey\'s Anatomy [/Edit]

iNOB · 13. März 2016

Wenn ich die /etc/epgd/channelmap.conf ändere (ergänze), kann ich nach Neuladen des Webfrontends die Änderungen in der Kanalliste nicht sehen?! Ein Neustart von epg und epghttp daemon hat mich auch nicht weitergebracht. Wie geht das im Sinne des Erfinders richtig?

Stadtgeflüster: epgd kommt noch vor Ostern in der http Version

Jetzt mitmachen!

Teilen