[skippy]

Hallo zusammen,

nachdem nun der mysql-server läuft, gibt es vom epg-daemon Fehlermeldungen in der /var/log/messages. Daten von EPGData werden nicht geholt.

Code: [Select]

Feb 13 17:51:07 (MLD) user.err epgd: Set locale to 'de_DE.UTF-8'
Feb 13 17:51:07 (MLD) user.err epgd: Info: Systemd support not enabled, epgd won't be sending notifications!
Feb 13 17:51:07 (MLD) user.err epgd: Initially creating uuid, storing to '/etc/epgd/uuid'
Feb 13 17:51:07 (MLD) user.err epgd: Dictionary '/etc/epgd/epg.dat' loaded
Feb 13 17:51:07 (MLD) user.err epgd: Initialize python script '/etc/epgd/recording.py'
Feb 13 17:51:07 (MLD) user.err epgd: Loading plugin: /lib/epgd/plugins/libepgd-epgdata.so
Feb 13 17:51:07 (MLD) user.err epgd: Loading plugin: /lib/epgd/plugins/libepgd-tvm.so
Feb 13 17:51:07 (MLD) user.err epgd: Loading plugin: /lib/epgd/plugins/libepgd-tvsp.so
Feb 13 17:51:07 (MLD) user.err epgd: Read 30 option from /etc/epgd/epgd.conf
Feb 13 17:51:07 (MLD) user.err epgd: Using syslog facility 'user' (8), log level set to (0)
Feb 13 17:51:07 (MLD) user.err epgd: Creating directory '/var/cache/epg-daemon/'
Feb 13 17:51:07 (MLD) user.err epgd: Info: Stylesheet '/etc/epgd/epgdata-utf-8.xsl' loaded
Feb 13 17:51:07 (MLD) user.err epgd: Info: Stylesheet '/etc/epgd/tvmovie-utf-8.xsl' loaded
Feb 13 17:51:07 (MLD) user.err epgd: Info: Stylesheet '/etc/epgd/tvsp-utf-8.xsl' loaded
Feb 13 17:51:07 (MLD) user.err epgd: Checking database connection ...
Feb 13 17:51:07 (MLD) user.err epgd: Calling mysql_init(25956)
Feb 13 17:51:07 (MLD) user.err epgd: SQL client character now 'utf8'
Feb 13 17:51:07 (MLD) user.err epgd: Checking table structure and indices ...
Feb 13 17:51:07 (MLD) user.err epgd: Initialy creating table 'analyse'
Feb 13 17:51:07 (MLD) user.err epghttpd: Set locale to 'de_DE.UTF-8'
Feb 13 17:51:07 (MLD) user.err epghttpd: detected UTF-8
Feb 13 17:51:07 (MLD) user.err epghttpd: Read 30 option from /etc/epgd/epgd.conf
Feb 13 17:51:07 (MLD) user.err epghttpd: Log level is set to (0)
Feb 13 17:51:07 (MLD) user.err epghttpd: Initialize python script '/etc/epgd/recording.py'
Feb 13 17:51:07 (MLD) user.err epghttpd: Initialize python script '/etc/epgd/recording.py'
Feb 13 17:51:07 (MLD) user.err epghttpd: Dictionary '/etc/epgd/epg.dat' loaded
Feb 13 17:51:07 (MLD) user.err epghttpd: Connecting to database at 'localhost:3306'
Feb 13 17:51:07 (MLD) user.err epghttpd: Calling mysql_init(26102)
Feb 13 17:51:07 (MLD) user.err epghttpd: SQL client character now 'utf8'
Feb 13 17:51:07 (MLD) user.err epghttpd: Initialy creating table 'vdrs'
Feb 13 17:51:08 (MLD) user.err epgd: Initialy creating table 'channelmap'
Feb 13 17:51:08 (MLD) user.err epghttpd: Initialy creating table 'useevents'
Feb 13 17:51:12 (MLD) user.err epghttpd: SQL-Error in 'create index idxchannelid on channelmap(channelid);' - Duplicate key name 'idxchannelid' (1061)
Feb 13 17:51:12 (MLD) user.err epghttpd: SQL-Error in 'createIndices()' - Duplicate key name 'idxchannelid' (1061) '' [create index idxchannelid on channelmap(channelid);]
Feb 13 17:51:12 (MLD) user.err epgd: Initialy creating table 'components'
Feb 13 17:51:12 (MLD) user.err epghttpd: Initialy creating table 'images'
Feb 13 17:51:13 (MLD) user.err epgd: Initialy creating table 'episodes'
Feb 13 17:51:13 (MLD) user.err epghttpd: Initialy creating table 'imagerefs'
Feb 13 17:51:14 (MLD) user.err epgd: Initialy creating table 'events'
Feb 13 17:51:17 (MLD) user.err epghttpd: Initialy creating table 'timers'
Feb 13 17:51:19 (MLD) user.err epghttpd: Initialy creating table 'timersdone'
Feb 13 17:51:20 (MLD) user.err epghttpd: Initialy creating table 'searchtimers'
Feb 13 17:51:21 (MLD) user.err epghttpd: Initialy creating table 'movie'
Feb 13 17:51:22 (MLD) user.err epghttpd: SQL-Error in 'create index idxmovietitle on movie(movie_title);' - Specified key was too long; max key length is 767 bytes (1071)
Feb 13 17:51:22 (MLD) user.err epghttpd: SQL-Error in 'createIndices()' - Specified key was too long; max key length is 767 bytes (1071) '' [create index idxmovietitle on movie(movie_title);]
Feb 13 17:51:22 (MLD) user.err epghttpd: Initialy creating table 'movie_actor'
Feb 13 17:51:23 (MLD) user.err epghttpd: Initialy creating table 'movie_actors'
Feb 13 17:51:23 (MLD) user.err epgd: Initialy creating table 'fileref'
Feb 13 17:51:25 (MLD) user.err epghttpd: Initialy creating table 'movie_media'
Feb 13 17:51:25 (MLD) user.err epgd: Initialy creating table 'messages'
Feb 13 17:51:26 (MLD) user.err epgd: SQL-Error in 'create index idxmovietitle on movie(movie_title);' - Specified key was too long; max key length is 767 bytes (1071)
Feb 13 17:51:26 (MLD) user.err epgd: SQL-Error in 'createIndices()' - Specified key was too long; max key length is 767 bytes (1071) '' [create index idxmovietitle on movie(movie_title);]
Feb 13 17:51:26 (MLD) user.err epgd: SQL-Error in 'create index idxactor_id on movie_media(actor_id);' - Duplicate key name 'idxactor_id' (1061)
Feb 13 17:51:26 (MLD) user.err epgd: SQL-Error in 'createIndices()' - Duplicate key name 'idxactor_id' (1061) '' [create index idxactor_id on movie_media(actor_id);]
Feb 13 17:51:26 (MLD) user.err epgd: Initialy creating table 'parameters'
Feb 13 17:51:26 (MLD) user.err epghttpd: Initialy creating table 'series'
Feb 13 17:51:27 (MLD) user.err epgd: Initialy creating table 'recordingdirs'
Feb 13 17:51:28 (MLD) user.err epgd: Initialy creating table 'recordinglist'
Feb 13 17:51:28 (MLD) user.err epghttpd: Initialy creating table 'series_episode'
Feb 13 17:51:28 (MLD) user.err epgd: Initialy creating table 'series_actor'
Feb 13 17:51:29 (MLD) user.err epgd: SQL-Error in 'create index idxseries_id on series_episode(series_id);' - Duplicate key name 'idxseries_id' (1061)
Feb 13 17:51:29 (MLD) user.err epgd: SQL-Error in 'createIndices()' - Duplicate key name 'idxseries_id' (1061) '' [create index idxseries_id on series_episode(series_id);]
Feb 13 17:51:29 (MLD) user.err epgd: Initialy creating table 'series_media'
Feb 13 17:51:29 (MLD) user.err epghttpd: Initialy creating table 'series_media'
Feb 13 17:51:30 (MLD) user.err epgd: SQL-Error in '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 VARC
Feb 13 17:51:30 (MLD) user.err epgd: SQL-Error in 'createTable()' - Table 'series_media' already exists (1050) '' [create table series_media(series_id INT(11) unsigned, season_number INT(11) unsigned, episod
e_id INT(11) unsigned, actor_id INT(11) unsigned, media_typ
Feb 13 17:51:30 (MLD) user.err epgd: Initialy creating table 'snapshot'
Feb 13 17:51:30 (MLD) user.err epgd: Initialy creating table 'users'
Feb 13 17:51:31 (MLD) user.err epgd: Closing mysql connection and calling mysql_thread_end(25956)
Feb 13 17:51:32 (MLD) user.err epghttpd: 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,
Feb 13 17:51:32 (MLD) user.err epghttpd: 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,
Feb 13 17:51:32 (MLD) user.err epghttpd: 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,
Feb 13 17:51:32 (MLD) user.err epghttpd: SQL-Error in 'prepare(stmt_prepare)' - Table 'epg2vdr.eventsviewplain' doesn't exist (1146) 'Table 'epg2vdr.eventsviewplain' doesn't exist' [select imageid, merge, su
b_actor, sub_audio, sub_camera, sub_category, cnt_channelid
Feb 13 17:51:32 (MLD) user.err epghttpd: SQL-Error in 'prepare(stmt_prepare)' - Table 'epg2vdr.eventsviewplain' doesn't exist (1146) 'Table 'epg2vdr.eventsviewplain' doesn't exist' [select imageid, merge, su
b_actor, sub_audio, sub_camera, sub_category, cnt_channelid
Feb 13 17:51:32 (MLD) user.err epghttpd: SQL-Error in 'prepare(stmt_prepare)' - Table 'epg2vdr.eventsviewplain' doesn't exist (1146) 'Table 'epg2vdr.eventsviewplain' doesn't exist' [select t._starttime, t.ac
tion, t.active, t.autotimerid, t.autotimerinssp, t.autotime
Feb 13 17:51:32 (MLD) user.err epghttpd: Calling mysql_init(26102)
Feb 13 17:51:32 (MLD) user.err epghttpd: SQL-Error in 'prepare(stmt_prepare)' - Table 'epg2vdr.eventsviewplain' doesn't exist (1146) 'Table 'epg2vdr.eventsviewplain' doesn't exist' [select sub_actor, sub_aud
io, sub_camera, sub_category, cnt_channelid, cnt_longdescri
Feb 13 17:51:32 (MLD) user.err epghttpd: Error: At least 1 statements not prepared successfully
Feb 13 17:51:32 (MLD) user.err epghttpd: Starting http server ...
Feb 13 17:51:32 (MLD) user.err epghttpd: Listener at port 8017 established, waiting for connections
Feb 13 17:51:32 (MLD) user.err epghttpd: Info: Systemd support not enabled, epgd won't be sending notifications!

Debug-Log habe ich hochgeladen => Upload Code lautet: 7Pa2WV

Viele Grüße skippy

[goerdi]

Dito.... hab es mal neu aufgesetzt.... mysql-upgrade lief durch aber epgd startet nicht..

[clausmuus]

Es gibt VDR-Portal bereits einen Post zu dem Thema. Nur scheint der Lösungsvorschlag bereits im epg-daemon integriert zu sein, ohne allerdings zu helfen.
Ich werde das heute Abend mal weiter analysieren.

Claus

[skippy]

Hallo zusammen,

die Ursache wurde im Videochat gefunden. In die Datei /etc/my.cnf müssen noch die nachfolgenden Parameter in der Sektion [mysqld] hinzugefügt werden:

Code: [Select]

character-set-server = latin1
innodb_large_prefix  = ON
innodb_file_format = BARRACUDA

Danach ein

Code: [Select]

restart mysql-server
und dann

Code: [Select]

start epg-daemon
start epghttpd
Das mysql-server Paket wurde entsprechend aktualisiert, damit künftig diese Ergänzung überflüssig wird.

Viele Grüße und vielen Dank an alle Mitwirkenden
skippy