GELÖST: DBLog keine Verbindung

Begonnen von cineflow, 04 Oktober 2021, 13:51:51

Vorheriges Thema - Nächstes Thema

cineflow

Hallo Forum,

seit meinem Systemupgrade auf Bullseye verbindet sich fhem nicht mehr mit meiner Datenbank.
In der Shell und von anderen Geräten läuft sie aber problemlos.

Von Zeit zu Zeit springt der Status für Sekunden auf connected, dann wieder zurück in die Fehlermeldung.

Auch libdbd-mysql-pearl ist auf dem aktuellen Stand.

Was kann ich tun?

cineflow

Zitat
Internals:
   COLUMNS    field length used for Device: 64, Type: 64, Event: 512, Reading: 64, Value: 128, Unit: 32
   CONFIGURATION /opt/fhem/contrib/dblog/db.conf
   DEF        /opt/fhem/contrib/dblog/db.conf .*:.*
   FUUID      5e2b785f-f33f-d607-623f-8a356c4098a3ffc7
   FVERSION   93_DbLog.pm:v4.12.3-s24440/2021-05-15
   MODE       synchronous
   MODEL      MYSQL
   NAME       DBLogging
   NR         64
   NTFY_ORDER 50-DBLogging
   PID        866
   REGEXP     .*:.*
   STATE      install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (you may need to install the DBD::mysql module) (@INC contains: ./lib ./FHEM . /etc/perl /usr/local/lib/arm-linux-gnueabihf/perl/5.32.1 /usr/local/share/perl/5.32.1 /usr/lib/arm-linux-gnueabihf/perl5/5.32 /usr/share/perl5 /usr/lib/arm-linux-gnueabihf/perl-base /usr/lib/arm-linux-gnueabihf/perl/5.32 /usr/share/perl/5.32 /usr/local/lib/site_perl ./FHEM/lib) at (eval 3598) line 3.
Perhaps the DBD::mysql perl module hasn't been fully installed,
or perhaps the capitalisation of 'mysql' isn't right.
Available drivers: DBM, ExampleP, File, Gofer, MariaDB, Mem, Proxy, SQLite, Sponge.
at ./FHEM/93_DbLog.pm line 3238.

   TYPE       DbLog
   UTF8       0
   dbconn     mysql:database=fhem;host=localhost;port=3306
   dbuser     fhemuser
   HELPER:
     COLSET     1
     DEVICECOL  64
     EVENTCOL   512
     OLDSTATE   install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (you may need to install the DBD::mysql module) (@INC contains: ./lib ./FHEM . /etc/perl /usr/local/lib/arm-linux-gnueabihf/perl/5.32.1 /usr/local/share/perl/5.32.1 /usr/lib/arm-linux-gnueabihf/perl5/5.32 /usr/share/perl5 /usr/lib/arm-linux-gnueabihf/perl-base /usr/lib/arm-linux-gnueabihf/perl/5.32 /usr/share/perl/5.32 /usr/local/lib/site_perl ./FHEM/lib) at (eval 3598) line 3.
Perhaps the DBD::mysql perl module hasn't been fully installed,
or perhaps the capitalisation of 'mysql' isn't right.
Available drivers: DBM, ExampleP, File, Gofer, MariaDB, Mem, Proxy, SQLite, Sponge.
at ./FHEM/93_DbLog.pm line 3238.

     PACKAGE    main
     READINGCOL 64
     TC         current
     TH         history
     TYPECOL    64
     UNITCOL    32
     VALUECOL   128
     VERSION    4.12.3
   READINGS:
     2021-10-04 13:14:20   CacheOverflowLastNum 0
     2021-04-02 23:55:06   CacheOverflowLastState normal
     2021-09-15 03:00:50   reduceLogState  reduceLogNbl finished. Rows processed: 114420, deleted: 34584, updated: 8636, time: 50.00sec
     2021-10-04 13:45:11   state           install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (you may need to install the DBD::mysql module) (@INC contains: ./lib ./FHEM . /etc/perl /usr/local/lib/arm-linux-gnueabihf/perl/5.32.1 /usr/local/share/perl/5.32.1 /usr/lib/arm-linux-gnueabihf/perl5/5.32 /usr/share/perl5 /usr/lib/arm-linux-gnueabihf/perl-base /usr/lib/arm-linux-gnueabihf/perl/5.32 /usr/share/perl/5.32 /usr/local/lib/site_perl ./FHEM/lib) at (eval 3598) line 3.
Perhaps the DBD::mysql perl module hasn't been fully installed,
or perhaps the capitalisation of 'mysql' isn't right.
Available drivers: DBM, ExampleP, File, Gofer, MariaDB, Mem, Proxy, SQLite, Sponge.
at ./FHEM/93_DbLog.pm line 3238.

Attributes:
   DbLogSelectionMode Include
   DbLogType  Current/History
   alias      Datenbank-Log1
   group      Logging
   icon       edit_save
   room       9.8.0_System


Lösung:
Nach dem dritten Mal reinstall libdbd-mysql-perl funktioniert es nun.

Wernieman

Hast Du eventuell mal Module per CPAN installiert?
- Bitte um Input für Output
- When there is a Shell, there is a Way
- Wann war Dein letztes Backup?

Wie man Fragen stellt: https://tty1.net/smart-questions_de.html