Hallo!
Ich hab mir irgendwie meine epgd bzw. epg2vdr Installation total zerschossen und jetzt funktioniert EPG-mässig nichts richtig und der syslog ist voller Fehlermeldungen
Es handelt sich um einen 0.6er stable mit stable-Paketquellen von gandalf-der-grosse (stable und main) und frodo (siehe unten).
Was habe ich gemacht? (leider in dieser Reihenfolge):
1. Einstellung "innodb_file_per_table" eingefügt in /etc/mysql/my.cnf
2. vdr-epg-daemon und vdr-plugin-epg2vdr installiert (aus ppa:frodo-vdr/stable-vdr-epgd-http-yavdr)
3. channelmap.conf: symlink auf Frodos "tvm tvsp" channelmap angelegt
4. mysql-server installiert und Datenbank und User angelegt
5. epgd & epg2vdr (von 2.) wieder deinstalliert (remove) und danach nochmal neu installiert
Im Syslog schauts jetzt gruselig aus - hoffentlich nur relevante Auszüge:
...
Aug 25 18:05:45 myVDR vdr: [1142] VDR version 2.2.0 started
...
Aug 25 18:05:47 myVDR vdr: [1142] restfulapi: The EPG-Images will be loaded from /var/cache/vdr/epgimages!
...
Aug 25 18:05:48 myVDR /etc/mysql/debian-start[1622]: Upgrading MySQL tables if necessary.
Aug 25 18:05:48 myVDR /etc/mysql/debian-start[1626]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored
Aug 25 18:05:48 myVDR /etc/mysql/debian-start[1626]: Looking for 'mysql' as: /usr/bin/mysql
Aug 25 18:05:48 myVDR /etc/mysql/debian-start[1626]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
2$g 25 18:05:48 myVDR /etc/mysql/debian-start[1626]: This installation of MySQL is already upgraded to 5.5.50, use --force if you still need to run mysql_upgrade
Aug 25 18:05:48 myVDR /etc/mysql/debian-start[1641]: Checking for insecure root accounts.
2$g 25 18:05:48 myVDR /etc/mysql/debian-start[1646]: Triggering myisam-recover for all MyISAM tables
2$g 25 18:05:49 myVDR epghttpd: Set locale to 'de_DE.UTF-8'
Aug 25 18:05:49 myVDR epghttpd: detected UTF-8
Aug 25 18:05:49 myVDR epghttpd: Read 26 option from /etc/epgd/epgd.conf
Aug 25 18:05:49 myVDR epghttpd: Log level is set to (1)
Aug 25 18:05:49 myVDR epghttpd: Initialize python script '/etc/epgd/recording.py'
$ug 25 18:05:49 myVDR epghttpd: Initialize python script '/etc/epgd/recording.py'
$ug 25 18:05:49 myVDR epghttpd: Dictionary '/etc/epgd/epg.dat' loaded
$ug 25 18:05:49 myVDR epghttpd: Info: Calling mysql_library_init()
$ug 25 18:05:49 myVDR epgd: Set locale to 'de_DE.UTF-8'
Aug 25 18:05:49 myVDR epgd: Info: Systemd support not enabled, epgd won't be sending notifications!
2$g 25 18:05:49 myVDR epgd: Loading uuid from '/etc/epgd/uuid' succeeded [1D388D76-7ECF-4B75-8A3A-003B5CE985A7]
Aug 25 18:05:49 myVDR epgd: Dictionary '/etc/epgd/epg.dat' loaded
Aug 25 18:05:49 myVDR epgd: Initialize python script '/etc/epgd/recording.py'
2$g 25 18:05:49 myVDR vdr: [1142] loading plugin: /usr/lib/vdr/plugins/libvdr-streamdev-server.so.2.2.0
...
2$g 25 18:05:49 myVDR epgd: Loading plugin: /usr/lib/epgd/plugins/libepgd-tvm.so
Aug 25 18:05:49 myVDR vdr: [1142] loading plugin: /usr/lib/vdr/plugins/libvdr-dynamite.so.2.2.0
Aug 25 18:05:49 myVDR epgd: Loading plugin: /usr/lib/epgd/plugins/libepgd-tvsp.so
Aug 25 18:05:49 myVDR epgd: Loading plugin: /usr/lib/epgd/plugins/libepgd-epgdata.so
Aug 25 18:05:49 myVDR epgd: Read 26 option from /etc/epgd/epgd.conf
$ug 25 18:05:49 myVDR epgd: Using syslog facility 'user' (8), log level set to (1)
$ug 25 18:05:49 myVDR epgd: Info: Calling mysql_library_init()
$ug 25 18:05:49 myVDR vdr: [1142] loading /var/lib/vdr/setup.conf
$ug 25 18:05:49 myVDR vdr: [1142] ERROR: unknown config parameter: softhddevice.SkipLines = 2
...
Aug 25 18:05:49 myVDR epghttpd: Connecting to database at 'localhost:3306'
Aug 25 18:05:49 myVDR epghttpd: Calling mysql_init(1632)
...
Aug 25 18:05:49 myVDR epgd: Info: Stylesheet '/etc/epgd/tvmovie-utf-8.xsl' loaded
$ug 25 18:05:49 myVDR epgd: Info: Stylesheet '/etc/epgd/tvsp-utf-8.xsl' loaded
$ug 25 18:05:49 myVDR epgd: Info: Stylesheet '/etc/epgd/epgdata-utf-8.xsl' loaded
$ug 25 18:05:49 myVDR epgd: Checking database connection ...
$ug 25 18:05:49 myVDR epgd: Calling mysql_init(1627)
...
Aug 25 18:05:49 myVDR vdr: [1142] loading /var/lib/vdr/keymacros.conf
Aug 25 18:05:49 myVDR vdr: [1142] ERROR: unknown plugin 'xineliboutput'
Aug 25 18:05:49 myVDR console-kit-daemon[1533]: GLib-CRITICAL: Source ID 23 was not found when attempting to remove it
2$g 25 18:05:49 myVDR epghttpd: SQL client character now 'utf8'
Aug 25 18:05:49 myVDR epgd: SQL client character now 'utf8'
2$g 25 18:05:49 myVDR epgd: Checking table structure and indices ...
2$g 25 18:05:49 myVDR epgd: Checking table 'analyse'
Aug 25 18:05:49 myVDR epgd: SystemNotification thread thread started (pid=1627, tid=1680, prio=low)
Aug 25 18:05:49 myVDR epgd: SystemNotification thread thread ended (pid=1627, tid=1680)
...
$ug 25 18:05:49 myVDR epgd: Checking table 'channelmap'
Aug 25 18:05:49 myVDR epgd: SystemNotification thread thread started (pid=1627, tid=1709, prio=low)
Aug 25 18:05:49 myVDR epgd: SystemNotification thread thread ended (pid=1627, tid=1709)
Aug 25 18:05:49 myVDR vdr: [1706] dbus2vdr: System: connected with unique name :1.15
Aug 25 18:05:49 myVDR vdr: [1706] dbus2vdr: thread-pool for handling signal-emits started
2$g 25 18:05:50 myVDR epgd: Checking table 'components'
Aug 25 18:05:50 myVDR epgd: SystemNotification thread thread started (pid=1627, tid=1711, prio=low)
2$g 25 18:05:50 myVDR epgd: SystemNotification thread thread ended (pid=1627, tid=1711)
2$g 25 18:05:50 myVDR epgd: Checking table 'episodes'
Aug 25 18:05:50 myVDR epgd: SystemNotification thread thread started (pid=1627, tid=1712, prio=low)
Aug 25 18:05:50 myVDR epgd: SystemNotification thread thread ended (pid=1627, tid=1712)
Aug 25 18:05:50 myVDR vdr: [1142] loading /var/lib/vdr/plugins/epgsearch/epgsearchcats.conf
Aug 25 18:05:50 myVDR vdr: [1142] loading /var/lib/vdr/plugins/epgsearch/epgsearchmenu.conf
$ug 25 18:05:50 myVDR epgd: Checking table 'events'
$ug 25 18:05:50 myVDR epgd: SystemNotification thread thread started (pid=1627, tid=1713, prio=low)
$ug 25 18:05:50 myVDR epgd: SystemNotification thread thread ended (pid=1627, tid=1713)
$ug 25 18:05:50 myVDR vdr: [1725] EPGSearch: conflictcheck thread started (pid=1142, tid=1725, prio=high)
...
Aug 25 18:05:50 myVDR vdr: [1744] [live] ERROR: Unable to load cert/key (/var/lib/vdr/plugins/live/live.pem//var/lib/vdr/plugins/live/live-key.pem): Datei oder Verzeic$
Aug 25 18:05:50 myVDR epgd: Checking table 'fileref'
Aug 25 18:05:50 myVDR epgd: SystemNotification thread thread started (pid=1627, tid=1753, prio=low)
Aug 25 18:05:50 myVDR epgd: SystemNotification thread thread ended (pid=1627, tid=1753)
2$g 25 18:05:50 myVDR vdr: [1142] restfulapi: The cached files will be loaded from /var/cache/vdr/plugins/restfulapi!
Aug 25 18:05:50 myVDR vdr: [1142] restfulapi: The config dir is /var/cache/vdr/plugins/restfulapi!
2$g 25 18:05:50 myVDR epgd: Checking table 'imagerefs'
2$g 25 18:05:50 myVDR epgd: SystemNotification thread thread started (pid=1627, tid=1758, prio=low)
Aug 25 18:05:50 myVDR epgd: SystemNotification thread thread ended (pid=1627, tid=1758)
Aug 25 18:05:50 myVDR epgd: Checking table 'images'
Aug 25 18:05:50 myVDR epgd: SystemNotification thread thread started (pid=1627, tid=1759, prio=low)
Aug 25 18:05:50 myVDR epgd: SystemNotification thread thread ended (pid=1627, tid=1759)
$ug 25 18:05:50 myVDR epgd: Checking table 'movie'
$ug 25 18:05:50 myVDR epgd: SystemNotification thread thread started (pid=1627, tid=1762, prio=low)
$ug 25 18:05:50 myVDR vdr: [1142] restfulapi: found 1 files in /var/cache/vdr/epgimages/*.
$ug 25 18:05:50 myVDR epgd: SystemNotification thread thread ended (pid=1627, tid=1762)
...
Aug 25 18:05:50 myVDR epgd: Checking table 'movie_actor'
Aug 25 18:05:50 myVDR epgd: SystemNotification thread thread started (pid=1627, tid=1784, prio=low)
Aug 25 18:05:50 myVDR epgd: SystemNotification thread thread ended (pid=1627, tid=1784)
Aug 25 18:05:50 myVDR epgd: Checking table 'movie_actors'
$ug 25 18:05:50 myVDR epgd: SystemNotification thread thread started (pid=1627, tid=1787, prio=low)
$ug 25 18:05:50 myVDR epgd: SystemNotification thread thread ended (pid=1627, tid=1787)
$ug 25 18:05:50 myVDR epgd: Checking table 'movie_media'
$ug 25 18:05:50 myVDR epgd: SystemNotification thread thread started (pid=1627, tid=1788, prio=low)
Aug 25 18:05:50 myVDR epgd: SystemNotification thread thread ended (pid=1627, tid=1788)
...
Aug 25 18:05:50 myVDR epgd: Checking table 'snapshot'
Aug 25 18:05:50 myVDR epgd: SystemNotification thread thread started (pid=1627, tid=1813, prio=low)
Aug 25 18:05:50 myVDR epgd: SystemNotification thread thread ended (pid=1627, tid=1813)
Aug 25 18:05:50 myVDR epghttpd: SQL-Error in 'prepare(stmt_prepare)' - Table 'epg2vdr.eventsviewplain' doesn't exist (1146) 'Table 'epg2vdr.eventsviewplain' doesn't ex$
$ug 25 18:05:50 myVDR epghttpd: SQL-Error in 'prepare(stmt_prepare)' - Table 'epg2vdr.eventsviewplain' doesn't exist (1146) 'Table 'epg2vdr.eventsviewplain' doesn't ex$
$ug 25 18:05:50 myVDR epghttpd: SQL-Error in 'prepare(stmt_prepare)' - Table 'epg2vdr.eventsviewplain' doesn't exist (1146) 'Table 'epg2vdr.eventsviewplain' doesn't ex$
$ug 25 18:05:50 myVDR epghttpd: SQL-Error in 'prepare(stmt_prepare)' - Table 'epg2vdr.eventsviewplain' doesn't exist (1146) 'Table 'epg2vdr.eventsviewplain' doesn't ex$
$ug 25 18:05:50 myVDR epghttpd: SQL-Error in 'prepare(stmt_prepare)' - Table 'epg2vdr.eventsviewplain' doesn't exist (1146) 'Table 'epg2vdr.eventsviewplain' doesn't ex$
Aug 25 18:05:50 myVDR epghttpd: SQL-Error in 'prepare(stmt_prepare)' - Table 'epg2vdr.eventsviewplain' doesn't exist (1146) 'Table 'epg2vdr.eventsviewplain' doesn't ex$
2$g 25 18:05:50 myVDR epghttpd: Calling mysql_init(1632)
...
Aug 25 18:05:50 myVDR epghttpd: Listener at port 9999 established, waiting for connections
Aug 25 18:05:50 myVDR epghttpd: Info: Systemd support not enabled, epgd won't be sending notifications!
2$g 25 18:05:50 myVDR epgd: Checking table 'timers'
Aug 25 18:05:50 myVDR epgd: SystemNotification thread thread started (pid=1627, tid=1817, prio=low)
2$g 25 18:05:50 myVDR epgd: SystemNotification thread thread ended (pid=1627, tid=1817)
2$g 25 18:05:50 myVDR vdr: [softhddev] ready detached
Aug 25 18:05:50 myVDR vdr: [1142] starting plugin: streamdev-server
Aug 25 18:05:50 myVDR epgd: Checking table 'timersdone'
Aug 25 18:05:50 myVDR epgd: SystemNotification thread thread started (pid=1627, tid=1818, prio=low)
Aug 25 18:05:50 myVDR epgd: SystemNotification thread thread ended (pid=1627, tid=1818)
...
Aug 25 18:05:50 myVDR epgd: Closing mysql connection and calling mysql_thread_end(1627)
2$g 25 18:05:50 myVDR epgd: Checking table structure and indices succeeded
2$g 25 18:05:50 myVDR epgd: Calling mysql_init(1627)
Aug 25 18:05:50 myVDR console-kit-daemon[1533]: GLib-CRITICAL: Source ID 59 was not found when attempting to remove it
...
2$g 25 18:05:51 myVDR epgd: State now 'init'
...
Aug 25 18:05:51 myVDR epgd: SQL-Error in 'select epglv('123', '123')' - FUNCTION epg2vdr.epglv does not exist (1305)
Aug 25 18:05:51 myVDR epgd: SQL-Error in 'select epglvr('123', '123')' - FUNCTION epg2vdr.epglvr does not exist (1305)
2$g 25 18:05:51 myVDR epgd: Error: Missing functions epglv/epglvr, please install first!
Aug 25 18:05:51 myVDR epgd: Closing mysql connection and calling mysql_thread_end(1627)
2$g 25 18:05:51 myVDR vdr: [1841] VNSI: Recordings state changed (288)
2$g 25 18:05:51 myVDR vdr: [1841] VNSI: Requesting clients to reload recordings list
Aug 25 18:05:51 myVDR epgd: Info: Released the last usage of mysql_lib, calling mysql_library_end() now
Aug 25 18:05:51 myVDR console-kit-daemon[1533]: GLib-CRITICAL: Source ID 72 was not found when attempting to remove it
Aug 25 18:05:51 myVDR kernel: [ 33.051419] init: epgd main process (1627) terminated with status 1
...
...
...
Aug 25 19:10:57 myVDR vdr: [softhddev] empty video packet 11 bytes
Aug 25 19:11:25 myVDR vdr: video: slow down video, duping frame
Aug 25 19:11:25 myVDR vdr: video: 11:56:09.530 +56 331 0/\ms 33+2 v-buf
Aug 25 19:11:52 myVDR vdr: epg2vdr: Trying to re-connect to database!
Aug 25 19:11:52 myVDR vdr: epg2vdr: Calling mysql_init(1892)
Aug 25 19:11:52 myVDR vdr: epg2vdr: SQL-Error in 'prepare(stmt_prepare)' - Table 'epg2vdr.eventsview' doesn't exist (1146) 'Table 'epg2vdr.eventsview' doesn't exist' [select useid, eventid, source, delflg, updflg, fileref, tableid, version, title, shorttext, starttime, duration, parentalrating, vps, contents, description from eventsview where channelid = ? and updsp > ? and UPDFLG in ('A','L','P','C','D','R')]
Aug 25 19:11:52 myVDR vdr: epg2vdr: Retry #57 failed, retrying in 60 seconds!
Aug 25 19:11:52 myVDR vdr: epg2vdr: Closing mysql connection and calling mysql_thread_end(1892)
Alles anzeigen
Das Webinterface auf Port 9999 zeigt mir auch nur einen roten Daumen bzw. seit Neuestem oben auch ein Menü (Magazin, Timer, Aufnahmen, etc.) aber leider alles leer.
Wie komme ich aus der Nummer am besten wieder raus?
Ich möchte einfach nur ein EPG, das mind. 14 Tage in die Zukunft kommt und einfach wieder "ruhig" seinen Dienst verrichtet, wie mit yaVDR 0.5
Vielen Dank schon jetzt für eure Hilfe!
greetz
davie2000