Hallo,
ich habe hier DbLog, dass nicht so arbeitet wie ich es möchte.
list DbLog
Internals:
COLUMNS field length used for Device: 64, Type: 64, Event: 512, Reading: 64, Value: 128, Unit: 32
CONFIGURATION ./db.conf
DEF ./db.conf .*:(PV_DC|pvIn).*
FD 5
FUUID 6939d7ae-f33f-3e5d-3524-8475f9b5bfd5e436
FVERSION 93_DbLog.pm:v5.11.0-s29401/2024-12-05
MODE asynchronous
MODEL MYSQL
NAME csl_debian_DbLog
NR 2
NTFY_ORDER 50-csl_debian_DbLog
PID 164125
REGEXP .*:(PV_DC|pvIn).*
SBP_PID 164126
SBP_STATE running
STATE connected
TYPE DbLog
UTF8 1
dbconn mysql:database=fhem;host=localhost;port=3306
dbuser fhemuser
eventCount 612
HELPER:
COLSET 1
DEVICECOL 64
EVENTCOL 512
OLDSTATE connected
PACKAGE main
READINGCOL 64
TC current
TH history
TYPECOL 64
UNITCOL 32
VALUECOL 128
VERSION 5.11.0
OLDREADINGS:
READINGS:
2026-03-08 19:19:56 CacheOverflowLastNum 0
2026-03-08 15:14:57 CacheOverflowLastState normal
2026-03-08 19:20:07 CacheUsage 4
2026-03-08 19:19:56 NextSync 2026-03-08 19:20:26 or when CacheUsage 500 is reached
2026-03-08 19:20:07 notify_processing_time 0.0003
2026-03-08 19:19:56 state connected
Attributes:
DbLogType Current/History
asyncMode 1
room LOG
showNotifyTime 1
verbose 2
eine Datenbank:
MariaDB [fhem]> SHOW GRANTS FOR 'fhemuser'@'localhost';
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Grants for fhemuser@localhost |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------+
| GRANT SELECT, INSERT, UPDATE, INDEX, CREATE VIEW, SHOW VIEW ON *.* TO `fhemuser`@`localhost` IDENTIFIED BY PASSWORD '*0A00846A5F41FFFFE0EAE0BFBF930679977C41F4' |
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON `fhem`.* TO `fhemuser`@`localhost` |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------+
und ein device:
2026-03-08 19:23:36 I_AC-Power 0.28871
2026-03-08 19:23:36 I_AC_Current 1.38
2026-03-08 19:23:36 I_AC_Energy_WH 1374.734
2026-03-08 19:23:36 I_DC_Power 0.2931
2026-03-08 19:23:36 I_Status On
2026-03-08 19:23:36 I_Temp_SF -2
2026-03-08 19:23:36 I_Temp_Sink 39.06
2026-03-08 19:23:36 M_AC_POWER 0.00
2026-03-08 19:23:36 M_AC_POWER_FeedIn 0
2026-03-08 19:23:36 M_AC_POWER_Purchased 0
2026-03-08 19:23:36 M_Energy_W_SF -3
2026-03-08 19:23:36 M_Exported 186.17
2026-03-08 19:23:36 M_Imported 951.46
2026-03-08 19:23:36 NetzHaus 0.000
2026-03-08 19:23:36 PV_DC 0.000
2026-03-08 19:23:36 pvIn 0.000
2026-03-08 19:23:36 pvOut 0.000
2026-03-08 18:54:24 state opened
der Event Monitor zeigt:
2026-03-08 19:28:21 ModbusAttr SE_10k PV_DC: 0.000
2026-03-08 19:28:21 ModbusAttr SE_10k BatNet: 0.360
2026-03-08 19:28:21 ModbusAttr SE_10k BatExport: 0.000
2026-03-08 19:28:21 ModbusAttr SE_10k BatHaus: 0.360
2026-03-08 19:28:21 ModbusAttr SE_10k PV_Export: 0.000
2026-03-08 19:28:21 ModbusAttr SE_10k PV_Haus: 0.005
2026-03-08 19:28:21 ModbusAttr SE_10k NetzHaus: 0.000
2026-03-08 19:28:21 DbLog csl_debian_DbLog notify_processing_time: 0.0021
2026-03-08 19:28:21 DbLog csl_debian_DbLog notify_processing_time: 0.0003
....
2026-03-08 19:30:34 ModbusAttr SE_10k WR_Effizienz: 0.985
2026-03-08 19:30:34 ModbusAttr SE_10k PV_DC: 0.000
2026-03-08 19:30:34 ModbusAttr SE_10k BatNet: 0.360
.....
2026-03-08 19:31:31 ModbusAttr SE_10k PV_Haus: 0.000
2026-03-08 19:31:31 ModbusAttr SE_10k NetzHaus: 0.000
2026-03-08 19:31:32 DbLog csl_debian_DbLog notify_processing_time: 0.0018
2026-03-08 19:31:32 DbLog csl_debian_DbLog notify_processing_time: 0.0002
entgegen aller Erwartungen
ergibt SELECT TIMESTAMP, DEVICE, READING, VALUE FROM history ORDER BY TIMESTAMP DESC LIMIT 10;
+---------------------+---------------------+------------------+-----------+
| TIMESTAMP | DEVICE | READING | VALUE |
+---------------------+---------------------+------------------+-----------+
| 2026-03-08 18:38:35 | SE_10k | state | CONNECTED |
| 2026-03-08 14:58:00 | SE_10k | vom_Dach | 2.712 |
| 2026-03-08 14:58:00 | YieldDay_M_Imported | state | 951.13 |
| 2026-03-08 14:58:00 | YieldDay_M_Exported | state | 183.90 |
| 2026-03-08 14:58:00 | SE_10k | pvOut | 2.420 |
| 2026-03-08 14:58:00 | SE_10k | etotal | 646.419 |
| 2026-03-08 14:58:00 | SE_10k | dc2ac | 0.000 |
| 2026-03-08 14:58:00 | SE_10k | ac2dc | 0.000 |
| 2026-03-08 14:58:00 | SE_10k | WR_Effizienz | 0.985 |
| 2026-03-08 14:58:00 | SE_10k | PV_Leistung-temp | 5.09 |
+---------------------+---------------------+------------------+-----------+
10 rows in set (0,001 sec)
Wenn man nun den timestamp betrachtet: es sind allesamt Einträge die _vor_ 2026-03-08 19:31:31 entstanden sind.
Diese Einträge kammen ausschließlich mit DbLog DEF ./db.conf .*
Sobald ich einen Filter anlege (s.o.) werden:
1. Einmalig die Filterwerte in DB übertragen
2.danach gar keine events in DB geschrieben.
Weiß jemand einen Rat?
Gruß
Martin
MODE asynchronous