Hallo zusammen,
eben wollte ich meinen VDR um ein erweitertes EPG ausstatten. Doch mit der Datenbank klappt's nicht. Mir fielen folgende Zeilen im Log nach dem Start von epgd auf:
Dec 20 17:25:35 sam-linux-test epgd[10944]: SQL-Error in 'create index idxmovietitle on movie(movie_title);' - Specified key was too long; max key length is 767 bytes (1071)
Dec 20 17:25:35 sam-linux-test epgd[10944]: SQL-Error in 'createIndices()' - Specified key was too long; max key length is 767 bytes (1071) '' [create index idxmovietitle on movie(movie_title);]
Ich verwende Opensuse 13.2 und hier wird MariaDB 10.0.13 angeboten.Für einen Tipp wäre ich super dankbar!
Grüße
Stefan
Das Log beim Starten von mysql bzw. MariaDB:
Dec 20 17:15:12 sam-linux-test rcmysql[3539]: Creating MySQL privilege database...
Dec 20 17:15:12 sam-linux-test rcmysql[3539]: Installing MariaDB/MySQL system tables in '/var/lib/mysql' ...
Dec 20 17:15:12 sam-linux-test rcmysql[3539]: 141220 17:15:12 [Note] InnoDB: Using mutexes to ref count buffer pool pages
Dec 20 17:15:12 sam-linux-test rcmysql[3539]: 141220 17:15:12 [Note] InnoDB: The InnoDB memory heap is disabled
Dec 20 17:15:12 sam-linux-test rcmysql[3539]: 141220 17:15:12 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
Dec 20 17:15:12 sam-linux-test rcmysql[3539]: 141220 17:15:12 [Note] InnoDB: Compressed tables use zlib 1.2.8
Dec 20 17:15:12 sam-linux-test rcmysql[3539]: 141220 17:15:12 [Note] InnoDB: Using Linux native AIO
Dec 20 17:15:12 sam-linux-test rcmysql[3539]: 141220 17:15:12 [Note] InnoDB: Not using CPU crc32 instructions
Dec 20 17:15:12 sam-linux-test rcmysql[3539]: 141220 17:15:12 [Note] InnoDB: Initializing buffer pool, size = 128.0M
Dec 20 17:15:12 sam-linux-test rcmysql[3539]: 141220 17:15:12 [Note] InnoDB: Completed initialization of buffer pool
Dec 20 17:15:12 sam-linux-test rcmysql[3539]: 141220 17:15:12 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
Dec 20 17:15:12 sam-linux-test rcmysql[3539]: 141220 17:15:12 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
Dec 20 17:15:12 sam-linux-test rcmysql[3539]: 141220 17:15:12 [Note] InnoDB: Database physically writes the file full: wait...
Dec 20 17:15:12 sam-linux-test rcmysql[3539]: 141220 17:15:12 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
Dec 20 17:15:12 sam-linux-test rcmysql[3539]: 141220 17:15:12 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
Dec 20 17:15:12 sam-linux-test rcmysql[3539]: 141220 17:15:12 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
Dec 20 17:15:12 sam-linux-test rcmysql[3539]: 141220 17:15:12 [Warning] InnoDB: New log files created, LSN=45781
Dec 20 17:15:12 sam-linux-test rcmysql[3539]: 141220 17:15:12 [Note] InnoDB: Doublewrite buffer not found: creating new
Dec 20 17:15:12 sam-linux-test rcmysql[3539]: 141220 17:15:12 [Note] InnoDB: Doublewrite buffer created
Dec 20 17:15:12 sam-linux-test rcmysql[3539]: 141220 17:15:12 [Note] InnoDB: 128 rollback segment(s) are active.
Dec 20 17:15:13 sam-linux-test rcmysql[3539]: 141220 17:15:13 [Warning] InnoDB: Creating foreign key constraint system tables.
Dec 20 17:15:13 sam-linux-test rcmysql[3539]: 141220 17:15:13 [Note] InnoDB: Foreign key constraint system tables created
Dec 20 17:15:13 sam-linux-test rcmysql[3539]: 141220 17:15:13 [Note] InnoDB: Creating tablespace and datafile system tables.
Dec 20 17:15:13 sam-linux-test rcmysql[3539]: 141220 17:15:13 [Note] InnoDB: Tablespace and datafile system tables created.
Dec 20 17:15:13 sam-linux-test rcmysql[3539]: 141220 17:15:13 [Note] InnoDB: Waiting for purge to start
Dec 20 17:15:13 sam-linux-test rcmysql[3539]: 141220 17:15:13 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.19-67.0 started; log sequence number 0
Dec 20 17:15:13 sam-linux-test rcmysql[3539]: 141220 17:15:13 [Note] InnoDB: FTS optimize thread exiting.
Dec 20 17:15:13 sam-linux-test rcmysql[3539]: 141220 17:15:13 [Note] InnoDB: Starting shutdown...
Dec 20 17:15:14 sam-linux-test dbus[671]: [system] Activating via systemd: service name='org.freedesktop.PackageKit' unit='packagekit.service'
Dec 20 17:15:14 sam-linux-test PackageKit[3650]: daemon start
Dec 20 17:15:14 sam-linux-test dbus[671]: [system] Successfully activated service 'org.freedesktop.PackageKit'
Dec 20 17:15:14 sam-linux-test PackageKit[3650]: get-updates transaction /1_ddaadbaa from uid 1000 finished with success after 744ms
Dec 20 17:15:15 sam-linux-test rcmysql[3539]: 141220 17:15:15 [Note] InnoDB: Shutdown completed; log sequence number 1616697
Dec 20 17:15:15 sam-linux-test rcmysql[3539]: OK
Dec 20 17:15:15 sam-linux-test rcmysql[3539]: Filling help tables...
Dec 20 17:15:15 sam-linux-test rcmysql[3539]: 141220 17:15:15 [Note] InnoDB: Using mutexes to ref count buffer pool pages
Dec 20 17:15:15 sam-linux-test rcmysql[3539]: 141220 17:15:15 [Note] InnoDB: The InnoDB memory heap is disabled
Dec 20 17:15:15 sam-linux-test rcmysql[3539]: 141220 17:15:15 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
Dec 20 17:15:15 sam-linux-test rcmysql[3539]: 141220 17:15:15 [Note] InnoDB: Compressed tables use zlib 1.2.8
Dec 20 17:15:15 sam-linux-test rcmysql[3539]: 141220 17:15:15 [Note] InnoDB: Using Linux native AIO
Dec 20 17:15:15 sam-linux-test rcmysql[3539]: 141220 17:15:15 [Note] InnoDB: Not using CPU crc32 instructions
Dec 20 17:15:15 sam-linux-test rcmysql[3539]: 141220 17:15:15 [Note] InnoDB: Initializing buffer pool, size = 128.0M
Dec 20 17:15:15 sam-linux-test rcmysql[3539]: 141220 17:15:15 [Note] InnoDB: Completed initialization of buffer pool
Dec 20 17:15:15 sam-linux-test rcmysql[3539]: 141220 17:15:15 [Note] InnoDB: Highest supported file format is Barracuda.
Dec 20 17:15:15 sam-linux-test rcmysql[3539]: 141220 17:15:15 [Note] InnoDB: 128 rollback segment(s) are active.
Dec 20 17:15:15 sam-linux-test rcmysql[3539]: 141220 17:15:15 [Note] InnoDB: Waiting for purge to start
Dec 20 17:15:15 sam-linux-test rcmysql[3539]: 141220 17:15:15 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.19-67.0 started; log sequence number 1616697
Dec 20 17:15:15 sam-linux-test rcmysql[3539]: 141220 17:15:15 [Note] InnoDB: FTS optimize thread exiting.
Dec 20 17:15:15 sam-linux-test rcmysql[3539]: 141220 17:15:15 [Note] InnoDB: Starting shutdown...
Dec 20 17:15:17 sam-linux-test rcmysql[3539]: 141220 17:15:17 [Note] InnoDB: Shutdown completed; log sequence number 1616707
Dec 20 17:15:17 sam-linux-test rcmysql[3539]: OK
Dec 20 17:15:17 sam-linux-test rcmysql[3539]: PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
Dec 20 17:15:17 sam-linux-test rcmysql[3539]: To do so, start the server, then issue the following commands:
Dec 20 17:15:17 sam-linux-test rcmysql[3539]: '/usr/bin/mysqladmin' -u root password 'new-password'
Dec 20 17:15:17 sam-linux-test rcmysql[3539]: '/usr/bin/mysqladmin' -u root -h sam-linux-test password 'new-password'
Dec 20 17:15:17 sam-linux-test rcmysql[3539]: Alternatively you can run:
Dec 20 17:15:17 sam-linux-test rcmysql[3539]: '/usr/bin/mysql_secure_installation'
Dec 20 17:15:17 sam-linux-test rcmysql[3539]: which will also give you the option of removing the test
Dec 20 17:15:17 sam-linux-test rcmysql[3539]: databases and anonymous user created by default. This is
Dec 20 17:15:17 sam-linux-test rcmysql[3539]: strongly recommended for production servers.
Dec 20 17:15:17 sam-linux-test rcmysql[3539]: See the MariaDB Knowledgebase at http://mariadb.com/kb or the
Dec 20 17:15:17 sam-linux-test rcmysql[3539]: MySQL manual for more instructions.
Dec 20 17:15:17 sam-linux-test rcmysql[3539]: You can start the MariaDB daemon with:
Dec 20 17:15:17 sam-linux-test rcmysql[3539]: rcmysql start
Dec 20 17:15:17 sam-linux-test rcmysql[3539]: You can test the MariaDB daemon with mariadb-test package
Dec 20 17:15:17 sam-linux-test rcmysql[3539]: Please report any problems at http://mariadb.org/jira
Dec 20 17:15:17 sam-linux-test rcmysql[3539]: The latest information about MariaDB is available at http://mariadb.org/.
Dec 20 17:15:17 sam-linux-test rcmysql[3539]: You can find additional information about the MySQL part at:
Dec 20 17:15:17 sam-linux-test rcmysql[3539]: http://dev.mysql.com
Dec 20 17:15:17 sam-linux-test rcmysql[3539]: Support MariaDB development by buying support/new features from
Dec 20 17:15:17 sam-linux-test rcmysql[3539]: SkySQL Ab. You can contact us about this at sales@skysql.com.
Dec 20 17:15:17 sam-linux-test rcmysql[3539]: Alternatively consider joining our community based development effort:
Dec 20 17:15:17 sam-linux-test rcmysql[3539]: http://mariadb.com/kb/en/contr…g-to-the-mariadb-project/
Dec 20 17:15:18 sam-linux-test rcmysql[3539]: Starting service MySQL Something went wrong
Das Log beim Starten von epgd:
Dec 20 17:25:32 sam-linux-test epgd[10944]: Set locale to 'de_DE.UTF-8'
Dec 20 17:25:32 sam-linux-test epgd[10944]: detected UTF-8
Dec 20 17:25:32 sam-linux-test epgd[10944]: Initially creating uuid, storing to '/etc/epgd/uuid'
Dec 20 17:25:32 sam-linux-test epgd[10944]: Loading plugin: /usr/local/lib/epgd/plugins/libepgd-epgdata.so
Dec 20 17:25:32 sam-linux-test epgd[10944]: Read 26 option from /etc/epgd/epgd.conf
Dec 20 17:25:32 sam-linux-test epgd[10944]: Creating directory '/var/cache/epgd'
Dec 20 17:25:32 sam-linux-test epgd[10944]: Info: Stylesheet '/etc/epgd/epgdata-utf-8.xsl' loaded
Dec 20 17:25:32 sam-linux-test epgd[10944]: SQL client character now 'utf8'
Dec 20 17:25:32 sam-linux-test epgd[10944]: Initialy creating table 'vdrs'
Dec 20 17:25:32 sam-linux-test epgd[10944]: 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), PRIMARY KEY(uuid DESC)) ENGINE InnoDB;
Dec 20 17:25:32 sam-linux-test epgd[10944]: create index idxstate on vdrs(state);
Dec 20 17:25:32 sam-linux-test epgd[10944]: State now 'init'
Dec 20 17:25:32 sam-linux-test epgd[10944]: Initialy creating table 'channelmap'
Dec 20 17:25:32 sam-linux-test epgd[10944]: create table channelmap(extid VARCHAR(10), channelid VARCHAR(50), source VARCHAR(20), channelname VARCHAR(100), vps INT(11), 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;
Dec 20 17:25:32 sam-linux-test epgd[10944]: create index idxsourceExtid on channelmap(source, extid);
Dec 20 17:25:32 sam-linux-test epgd[10944]: create index idxsource on channelmap(source);
Dec 20 17:25:32 sam-linux-test epgd[10944]: create index idxupdflg on channelmap(updflg);
Dec 20 17:25:32 sam-linux-test epgd[10944]: create index idxsourcechannelid on channelmap(source, channelid);
Dec 20 17:25:32 sam-linux-test epgd[10944]: create index idxmergesp on channelmap(mergesp);
Dec 20 17:25:32 sam-linux-test epgd[10944]: create index idxchannelid on channelmap(channelid);
Dec 20 17:25:32 sam-linux-test epgd[10944]: Initialy creating table 'fileref'
Dec 20 17:25:32 sam-linux-test epgd[10944]: 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;
Dec 20 17:25:32 sam-linux-test epgd[10944]: create index idxSourceFileref on fileref(source, fileref);
Dec 20 17:25:32 sam-linux-test epgd[10944]: create index idxFileref on fileref(fileref);
Dec 20 17:25:32 sam-linux-test epgd[10944]: Initialy creating table 'images'
Dec 20 17:25:32 sam-linux-test epgd[10944]: create table images(imagename VARCHAR(100), inssp INT(11), updsp INT(11), image MEDIUMBLOB, PRIMARY KEY(imagename DESC)) ENGINE InnoDB;
Dec 20 17:25:32 sam-linux-test epgd[10944]: Initialy creating table 'imagerefs'
Dec 20 17:25:32 sam-linux-test epgd[10944]: 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;
Dec 20 17:25:32 sam-linux-test epgd[10944]: create index idxlfn on imagerefs(lfn);
Dec 20 17:25:32 sam-linux-test epgd[10944]: create index idxname on imagerefs(imagename);
Dec 20 17:25:32 sam-linux-test epgd[10944]: Initialy creating table 'episodes'
Dec 20 17:25:32 sam-linux-test epgd[10944]: create table episodes(compname VARCHAR(100), comppartname VARCHAR(200), lang VARCHAR(10), inssp INT(11), updsp INT(11), link INT(11), shortname 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;
Dec 20 17:25:32 sam-linux-test epgd[10944]: create index idxupdsp on episodes(updsp);
Dec 20 17:25:32 sam-linux-test epgd[10944]: Initialy creating table 'events'
Dec 20 17:25:32 sam-linux-test epgd[10944]: 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 TEXT(25000), starttime INT(10), duration INT(5), parentalrating INT(2), vps INT(10), shortdescription VARCHAR(3000), actor VARCHAR(3000), audio VARCHAR(50), category VARCHAR(50), country VARCHAR(50), director VARCHAR(250), flags VARCHAR(100), genre VARCHAR(100), info TEXT(10000), music VARCHAR(250), producer TEXT(1000), screenplay VARCHAR(500), shortreview VARCHAR(500), tipp VARCHAR(250), topic VARCHAR(500), year VARCHAR(10), rating VARCHAR(250), fsk VARCHAR(2), movieid VARCHAR(20), moderator VARCHAR(250), other TEXT(2000), guest TEXT(1000), camera TEXT(1000), extepnum INT(4), imagecount INT(2), episode VARCHAR(250), episodepart VARCHAR(250), episodelang VARCHAR(3), scrseriesid INT(11), scrseriesepisode INT(11), scrmovieid INT(11), scrsp INT(11), PRIMARY KEY(eventid DESC, channelid DESC), KEY(masterid DESC)) ENGINE InnoDB;
Dec 20 17:25:32 sam-linux-test epgd[10944]: create index idxcomptitle on events(comptitle);
Dec 20 17:25:33 sam-linux-test epgd[10944]: create index idxsource on events(source);
Dec 20 17:25:33 sam-linux-test epgd[10944]: create index idxfilerefsource on events(fileref, source);
Dec 20 17:25:33 sam-linux-test epgd[10944]: create index idxchannelid on events(channelid);
Dec 20 17:25:33 sam-linux-test epgd[10944]: create index idxuseid on events(useid);
Dec 20 17:25:33 sam-linux-test epgd[10944]: create index idxuseidchannelid on events(useid, channelid);
Dec 20 17:25:33 sam-linux-test epgd[10944]: create index idxupdflgupdsp on events(updflg, updsp);
Dec 20 17:25:33 sam-linux-test epgd[10944]: create index idxsourcechannelid on events(source, channelid);
Dec 20 17:25:33 sam-linux-test epgd[10944]: create index idxscrsp on events(scrsp);
Dec 20 17:25:33 sam-linux-test epgd[10944]: create index idxsourceupdsp on events(source, updsp);
Dec 20 17:25:33 sam-linux-test epgd[10944]: create index idxscrseriesid on events(scrseriesid);
Dec 20 17:25:33 sam-linux-test epgd[10944]: Initialy creating table 'components'
Dec 20 17:25:33 sam-linux-test epgd[10944]: 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;
Dec 20 17:25:33 sam-linux-test epgd[10944]: Initialy creating table 'parameters'
Dec 20 17:25:33 sam-linux-test epgd[10944]: create table parameters(owner VARCHAR(40), name VARCHAR(40), inssp INT(11), updsp INT(11), value VARCHAR(100), PRIMARY KEY(owner DESC, name DESC)) ENGINE InnoDB;
Dec 20 17:25:33 sam-linux-test epgd[10944]: Initialy creating table 'recordings'
Dec 20 17:25:33 sam-linux-test epgd[10944]: create table recordings(uuid VARCHAR(40), rec_path VARCHAR(200), rec_start INT(11) unsigned, event_id INT(11) unsigned, channel_id VARCHAR(50), scrapinfo_movie_id INT(11) unsigned, scrapinfo_series_id INT(11) unsigned, scrapinfo_episode_id INT(11) unsigned, scrap_new INT(11) unsigned, rec_title VARCHAR(200), rec_subtitle VARCHAR(500), rec_duration INT(11) unsigned, movie_id INT(11) unsigned, series_id INT(11) unsigned, episode_id INT(11) unsigned, PRIMARY KEY(uuid DESC, rec_path DESC, rec_start DESC)) ENGINE InnoDB;
Dec 20 17:25:33 sam-linux-test epgd[10944]: create index idxuuid on recordings(uuid);
Dec 20 17:25:33 sam-linux-test epgd[10944]: create index idxrec_path on recordings(rec_path);
Dec 20 17:25:33 sam-linux-test epgd[10944]: create index idxrec_start on recordings(rec_start);
Dec 20 17:25:33 sam-linux-test epgd[10944]: create index idxscrap_new on recordings(scrap_new);
Dec 20 17:25:33 sam-linux-test epgd[10944]: Initialy creating table 'analyse'
Dec 20 17:25:33 sam-linux-test epgd[10944]: 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;
Dec 20 17:25:33 sam-linux-test epgd[10944]: create index idxvdr_masterid on analyse(vdr_masterid);
Dec 20 17:25:33 sam-linux-test epgd[10944]: Initialy creating table 'snapshot'
Dec 20 17:25:33 sam-linux-test epgd[10944]: 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;
Dec 20 17:25:33 sam-linux-test epgd[10944]: create index idxchannelid on snapshot(channelid);
Dec 20 17:25:33 sam-linux-test epgd[10944]: create index idxstarttimeSource on snapshot(starttime, source);
Dec 20 17:25:33 sam-linux-test epgd[10944]: Loading '/etc/epgd/channelmap.conf'
Dec 20 17:25:33 sam-linux-test epgd[10944]: 103 channel mappings read.
Dec 20 17:25:33 sam-linux-test epgd[10944]: Creating directory '/var/cache/epgd/epgdata'
Dec 20 17:25:33 sam-linux-test epgd[10944]: Creating procedure 'mergeepg'
Dec 20 17:25:33 sam-linux-test epgd[10944]: Creating procedure 'reverseepg'
Dec 20 17:25:33 sam-linux-test epgd[10944]: Creating function 'getupdflg'
Dec 20 17:25:33 sam-linux-test epgd[10944]: Creating function 'getcrosslvr'
Dec 20 17:25:33 sam-linux-test epgd[10944]: Creating function 'getlvrmin'
Dec 20 17:25:34 sam-linux-test epgd[10944]: Creating view 'eventsview' using definition in '/etc/epgd/eventsview.sql'
Dec 20 17:25:34 sam-linux-test epgd[10944]: Creating view 'eventsviewplain' using definition in '/etc/epgd/eventsviewplain.sql'
Dec 20 17:25:34 sam-linux-test epgd[10944]: Creating view 'thetvdbview' using definition in '/etc/epgd/thetvdbview.sql'
Dec 20 17:25:34 sam-linux-test epgd[10944]: No external events on database, force initial check!
Dec 20 17:25:34 sam-linux-test epgd[10944]: using scrapping language de
Dec 20 17:25:34 sam-linux-test epgd[10944]: Initialy creating table 'series'
Dec 20 17:25:34 sam-linux-test epgd[10944]: 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(10000), series_firstaired VARCHAR(50), series_network VARCHAR(100), series_imdb_id VARCHAR(20), series_genre VARCHAR(100), series_rating FLOAT(3,1), series_status VARCHAR(50), PRIMARY KEY(series_id DESC)) ENGINE InnoDB;
Dec 20 17:25:34 sam-linux-test epgd[10944]: create index idxseriesname on series(series_name);
Dec 20 17:25:34 sam-linux-test epgd[10944]: Initialy creating table 'series_episode'
Dec 20 17:25:34 sam-linux-test epgd[10944]: 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(10000), episode_firstaired VARCHAR(20), episode_gueststars VARCHAR(1000), episode_rating FLOAT(3,1), episode_last_updated INT(11) unsigned, series_id INT(11) unsigned, PRIMARY KEY(episode_id DESC)) ENGINE InnoDB;
Dec 20 17:25:34 sam-linux-test epgd[10944]: create index idxseries_id on series_episode(series_id);
Dec 20 17:25:34 sam-linux-test epgd[10944]: Initialy creating table 'series_media'
Dec 20 17:25:34 sam-linux-test epgd[10944]: 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, media_url VARCHAR(100), media_width INT(11) unsigned, media_height INT(11) unsigned, media_rating FLOAT(3,1), media_content MEDIUMBLOB, PRIMARY KEY(series_id DESC, season_number DESC, episode_id DESC, actor_id DESC, media_type DESC)) ENGINE InnoDB;
Dec 20 17:25:34 sam-linux-test epgd[10944]: create index idxseries_id on series_media(series_id);
Dec 20 17:25:34 sam-linux-test epgd[10944]: create index idxseason_number on series_media(season_number);
Dec 20 17:25:34 sam-linux-test epgd[10944]: create index idxepisode_id on series_media(episode_id);
Dec 20 17:25:34 sam-linux-test epgd[10944]: create index idxactor_id on series_media(actor_id);
Dec 20 17:25:34 sam-linux-test epgd[10944]: Initialy creating table 'series_actor'
Dec 20 17:25:34 sam-linux-test epgd[10944]: 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;
Dec 20 17:25:34 sam-linux-test epgd[10944]: tvdb scraper connected
Dec 20 17:25:34 sam-linux-test epgd[10937]: Starting EPG-Daemon..done
Dec 20 17:25:35 sam-linux-test epgd[10944]: Initialy creating table 'movie'
Dec 20 17:25:35 sam-linux-test epgd[10944]: create table movie(movie_id INT(11) unsigned, movie_title VARCHAR(300), movie_original_title VARCHAR(300), movie_tagline VARCHAR(1000), movie_overview TEXT(5000), 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(3,1), movie_vote_average FLOAT(3,1), PRIMARY KEY(movie_id DESC)) ENGINE InnoDB;
Dec 20 17:25:35 sam-linux-test epgd[10944]: create index idxmovie_id on movie(movie_id);
Dec 20 17:25:35 sam-linux-test epgd[10944]: create index idxmovietitle on movie(movie_title);
Dec 20 17:25:35 sam-linux-test epgd[10944]: SQL-Error in 'create index idxmovietitle on movie(movie_title);' - Specified key was too long; max key length is 767 bytes (1071)
Dec 20 17:25:35 sam-linux-test epgd[10944]: SQL-Error in 'createIndices()' - Specified key was too long; max key length is 767 bytes (1071) '' [create index idxmovietitle on movie(movie_title);]
Dec 20 17:25:35 sam-linux-test epgd[10944]: Initialy creating table 'movie_actor'
Dec 20 17:25:35 sam-linux-test epgd[10944]: create table movie_actor(actor_id INT(11) unsigned, actor_name VARCHAR(300), PRIMARY KEY(actor_id DESC)) ENGINE InnoDB;
Dec 20 17:25:35 sam-linux-test epgd[10944]: create index idxactor_id on movie_actor(actor_id);
Dec 20 17:25:35 sam-linux-test epgd[10944]: Initialy creating table 'movie_actors'
Dec 20 17:25:35 sam-linux-test epgd[10944]: 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;
Dec 20 17:25:35 sam-linux-test epgd[10944]: create index idxmovie_id on movie_actors(movie_id);
Dec 20 17:25:35 sam-linux-test epgd[10944]: create index idxactor_id on movie_actors(actor_id);
Dec 20 17:25:35 sam-linux-test epgd[10944]: Initialy creating table 'movie_media'
Dec 20 17:25:35 sam-linux-test epgd[10944]: 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;
Dec 20 17:25:35 sam-linux-test epgd[10944]: create index idxmovie_id on movie_media(movie_id);
Dec 20 17:25:35 sam-linux-test epgd[10944]: create index idxactor_id on movie_media(actor_id);
Dec 20 17:25:35 sam-linux-test epgd[10944]: moviedb scraper connected
Dec 20 17:25:35 sam-linux-test epgd[10944]: Scheduled next update in 10 second(s)
Dec 20 17:25:35 sam-linux-test epgd[10944]: State now 'standby'
Dec 20 17:25:45 sam-linux-test epgd[10944]: State now 'busy (events)'
Dec 20 17:25:45 sam-linux-test epgd[10944]: Starting cleanup of events
Dec 20 17:25:45 sam-linux-test epgd[10944]: Delete fileref [substr(name,1,8) <= '20141219']
Dec 20 17:25:45 sam-linux-test epgd[10944]: Delete events [starttime+duration < 1419071145]
Dec 20 17:25:45 sam-linux-test epgd[10944]: Cleanup of events finished
Dec 20 17:25:45 sam-linux-test epgd[10944]: EPG Update started
Dec 20 17:25:45 sam-linux-test epgd[10944]: Updating 'epgdata' day today+0 now
Dec 20 17:25:45 sam-linux-test epgd[10944]: Download file: 'http://www.epgdata.com/index.php?action=sendPackage&iOEM=VDR&pin=insert-your-pin-here&dayOffset=0&dataType=xml' to '20141220_20141219_de_qy.zip
Dec 20 17:26:00 sam-linux-test epgd[10944]: Processing file '20141220_20141219_de_qy.zip-20930856' for day 0 (0/1)
Dec 20 17:26:05 sam-linux-test epgd[10944]: Updating 'epgdata' day today+1 now
Dec 20 17:26:07 sam-linux-test epgd[10944]: Download file: 'http://www.epgdata.com/index.php?action=sendPackage&iOEM=VDR&pin=insert-your-pin-here&dayOffset=1&dataType=xml' to '20141221_20141219_de_qy.zip
locale root
LANG=POSIX
LC_CTYPE=de_DE.UTF-8
LC_NUMERIC="POSIX"
LC_TIME="POSIX"
LC_COLLATE="POSIX"
LC_MONETARY="POSIX"
LC_MESSAGES="POSIX"
LC_PAPER="POSIX"
LC_NAME="POSIX"
LC_ADDRESS="POSIX"
LC_TELEPHONE="POSIX"
LC_MEASUREMENT="POSIX"
LC_IDENTIFICATION="POSIX"
LC_ALL=
locale vdr-User
LANG=de_DE.UTF-8
LC_CTYPE="de_DE.UTF-8"
LC_NUMERIC="de_DE.UTF-8"
LC_TIME="de_DE.UTF-8"
LC_COLLATE="de_DE.UTF-8"
LC_MONETARY="de_DE.UTF-8"
LC_MESSAGES="de_DE.UTF-8"
LC_PAPER="de_DE.UTF-8"
LC_NAME="de_DE.UTF-8"
LC_ADDRESS="de_DE.UTF-8"
LC_TELEPHONE="de_DE.UTF-8"
LC_MEASUREMENT="de_DE.UTF-8"
LC_IDENTIFICATION="de_DE.UTF-8"
LC_ALL=
SHOW TABLES;
+-------------------+
| Tables_in_epg2vdr |
+-------------------+
| analyse |
| channelmap |
| components |
| episodes |
| events |
| eventsview |
| eventsviewplain |
| fileref |
| imagerefs |
| images |
| movie |
| movie_actor |
| movie_actors |
| movie_media |
| parameters |
| recordings |
| series |
| series_actor |
| series_episode |
| series_media |
| snapshot |
| thetvdbview |
| vdrs |
+-------------------+
23 rows in set (0.00 sec)
SELECT * FROM mysql.func;
+--------+-----+---------------+----------+
| name | ret | dl | type |
+--------+-----+---------------+----------+
| epglv | 2 | mysqlepglv.so | function |
| epglvr | 2 | mysqlepglv.so | function |
+--------+-----+---------------+----------+
2 rows in set (0.00 sec)
SHOW FUNCTION STATUS;
+---------+-------------+----------+-----------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+
| Db | Name | Type | Definer | Modified | Created | Security_type | Comment | character_set_client | collation_connection | Database Collation |
+---------+-------------+----------+-----------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+
| epg2vdr | getcrosslvr | FUNCTION | epg2vdr@% | 2014-12-20 17:25:33 | 2014-12-20 17:25:33 | DEFINER | | utf8 | utf8_general_ci | utf8_general_ci |
| epg2vdr | getlvrmin | FUNCTION | epg2vdr@% | 2014-12-20 17:25:33 | 2014-12-20 17:25:33 | DEFINER | | utf8 | utf8_general_ci | utf8_general_ci |
| epg2vdr | getupdflg | FUNCTION | epg2vdr@% | 2014-12-20 17:25:33 | 2014-12-20 17:25:33 | DEFINER | | utf8 | utf8_general_ci | utf8_general_ci |
+---------+-------------+----------+-----------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+
3 rows in set (0.00 sec)
show variables like 'innodb_file_format%';
+--------------------------+-----------+
| Variable_name | Value |
+--------------------------+-----------+
| innodb_file_format | Barracuda |
| innodb_file_format_check | ON |
| innodb_file_format_max | Antelope |
+--------------------------+-----------+
3 rows in set (0.00 sec)
show variables like 'innodb_large_prefix';
+---------------------+-------+
| Variable_name | Value |
+---------------------+-------+
| innodb_large_prefix | OFF |
+---------------------+-------+
1 row in set (0.00 sec)