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.