Hallo nochmal,
kaum macht man es richtig, schon gehts.....
Es fehlte:
apt-get install libdbd-mysql libdbd-mysql-perl
Dankeschön
----------------------------------------------------------------------------------------------------
Moin zusammen,
bin am verzweifeln. Ich habe schon zum dritten Mal versucht, den FHEM unter Proxmox mit Debian11 Bullseye zu installieren.
Nun möchte ich die LogDB installieren. Auch im dritten Versuch..... immer die Fehlermeldung.
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/x86_64-linux-gnu/perl/5.32.1 /usr/local/share/perl/5.32.1 /usr/lib/x86_64-linux-gnu/perl5/5.32 /usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl-base /usr/lib/x86_64-linux-gnu/perl/5.32 /usr/share/perl/5.32 /usr/local/lib/site_perl ./FHEM/lib) at (eval 208) 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 3253.
hier das komplette List:
Internals:
CFGFN
COLUMNS field length used for Device: 64, Type: 64, Event: 512, Reading: 64, Value: 128, Unit: 32
CONFIGURATION ./fhemdb.cfg
DEF ./fhemdb.cfg .*:.*
FUUID 6214920c-f33f-bd9c-95a1-f175d967bf79ed04
FVERSION 93_DbLog.pm:v4.12.6-s25478/2022-01-17
MODE asynchronous
MODEL MYSQL
NAME LogDB
NR 20
NTFY_ORDER 50-LogDB
PID 205
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/x86_64-linux-gnu/perl/5.32.1 /usr/local/share/perl/5.32.1 /usr/lib/x86_64-linux-gnu/perl5/5.32 /usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl-base /usr/lib/x86_64-linux-gnu/perl/5.32 /usr/share/perl/5.32 /usr/local/lib/site_perl ./FHEM/lib) at (eval 208) 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 3253.
TYPE DbLog
UTF8 1
dbconn mysql: - <<- das passt, es greifen mehrere auf die Datenbank zu
dbuser fhem
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/x86_64-linux-gnu/perl/5.32.1 /usr/local/share/perl/5.32.1 /usr/lib/x86_64-linux-gnu/perl5/5.32 /usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl-base /usr/lib/x86_64-linux-gnu/perl/5.32 /usr/share/perl/5.32 /usr/local/lib/site_perl ./FHEM/lib) at (eval 208) 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 3253.
PACKAGE main
READINGCOL 64
TC current
TH history
TYPECOL 64
UNITCOL 32
VALUECOL 128
VERSION 4.12.6
READINGS:
2022-02-22 08:34:36 CacheOverflowLastNum 0
2022-02-22 08:34:36 CacheOverflowLastState normal
2022-02-22 08:45:39 CacheUsage 0
2022-02-22 08:45:39 NextSync 2022-02-22 08:46:09 or if CacheUsage 500 reached
2022-02-22 08:45:47 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/x86_64-linux-gnu/perl/5.32.1 /usr/local/share/perl/5.32.1 /usr/lib/x86_64-linux-gnu/perl5/5.32 /usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl-base /usr/lib/x86_64-linux-gnu/perl/5.32 /usr/share/perl/5.32 /usr/local/lib/site_perl ./FHEM/lib) at (eval 208) 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 3253.
Attributes:
DbLogSelectionMode Include
DbLogType Current/History
asyncMode 1
cacheEvents 2
excludeDevs TYPE=DbLog
room y-Devices
showNotifyTime 1
showproctime 1
useCharfilter 1
Bei der Installation habe ich mich immer an den FHEM Stammtisch - Workshop DbLog mit MySQL von DS-Starter gehalten.
Kann das an Debian 11 liegen? Ich habe es schon so oft installiert, nur mit debian 11 diese Probleme.
Gerne liefere ich noch mehr, wenn benötigt.
Dankeschön
ja das Thema ist alt, ich habe gearde FHEM neu installiert und hatte das gleiche Problem.
In der Anleitung: https://wiki.fhem.de/wiki/DbLog#Konfiguration
fehlte:
sudo apt-get install libdbi-perl libclass-dbi-mysql-perl
Es ist nicht wirklich entscheidend, was im wiki steht, sondern was in der commandref vom Modulautor verankert wurde. Denn nur die commandref ist offizielle "Quelle der Wahrheit".
Und in der commandref zu DbLog sind alle zusätzlich zu installierenden perl-Pakete aufgeführt, sortiert nach dem jeweils verwendeten Datenbankmodell.