<div data-type="image"
data-url="http://192.168.6.20:8083/fhem/protect/?name=UnifiProtect&cam=6731f11a00e40025de&width=1024&ts=1742070038.328" alt="Haustüre"
class="nocache">
</div>
DBI connect('database=fhem;host=10.1.1.99;port=3306','fhemuser',...) failed: Can't connect to MySQL server on '10.1.1.99' (111) at ./FHEM/93_DbLog.pm line 2563.
Edit nach erneutem restart von FHEM:2025.03.15 20:38:00 3: WR_1: CreateDataObjects unpack of 0047 with N for MODBUS_Unit-ID resulted in undefined value
2025.03.15 20:38:00 3: WR_1: CreateDataObjects unpack of 0000 with N for MODBUS_Byte_Order_Note resulted in undefined value
und2025.03.15 20:38:11 4: DbRep LogDBRep_PV_KI_Prognose - -------- New selection ---------
2025.03.15 20:38:11 4: DbRep LogDBRep_PV_KI_Prognose - Command: sqlCmd call dwd_load('full',curdate(),'none');
2025.03.15 20:38:11 4: DbRep LogDBRep_PV_KI_Prognose - Timestamp begin human readable: not set
2025.03.15 20:38:11 4: DbRep LogDBRep_PV_KI_Prognose - Timestamp end human readable: not set
2025.03.15 20:38:11 5: DbRep LogDBRep_PV_KI_Prognose - BlockingCall with PID "78701" started
2025.03.15 20:38:11 4: DbRep LogDBRep_PV_KI_Prognose - Database Model: MYSQL
2025.03.15 20:38:11 4: DbRep LogDBRep_PV_KI_Prognose - Database connect - user: fhemMysql, UTF-8 option set: no
2025.03.15 20:38:11 4: DbRep LogDBRep_PV_KI_Prognose - SQL execute: SHOW VARIABLES LIKE 'collation_database'
2025.03.15 20:38:11 4: DbRep LogDBRep_PV_KI_Prognose - Database Character set is >utf8mb4_bin<
2025.03.15 20:38:11 4: DbRep LogDBRep_PV_KI_Prognose - simple do statement: set names "utf8mb4" collate "utf8mb4_bin"
2025.03.15 20:38:11 4: DbRep LogDBRep_PV_KI_Prognose - SQL execute: call dwd_load('full',curdate(),'none');
2025.03.15 20:38:12 2: DbRep LogDBRep_PV_KI_Prognose - ERROR - DBD::mysql::st execute failed: Data truncated for column 'Neff' at row 125 at ./FHEM/93_DbRep.pm line 11860.
Ein 'call dwd_load('update',curdate(),'none');' läuft problemlos durch. Die Neff-Werte in den Tabellen current und history sind alle normal(0-100). Ein lösche der Tabelle dwdfull hilft auch nichts.define fhemMysql DbLog ./dbMysql.conf .*:.*
attr fhemMysql DbLogSelectionMode Include
attr fhemMysql DbLogType Current/History
attr fhemMysql asyncMode 1
attr fhemMysql room DB
attr fhemMysql showproctime 1
attr fhemMysql syncInterval 60
# COLUMNS field length used for Device: 64, Type: 64, Event: 512, Reading: 64, Value: 128, Unit: 32
# CONFIGURATION ./dbMysql.conf
# DEF ./dbMysql.conf .*:.*
# FD 7
# FUUID 67cc50da-f33f-6b20-de25-f81665c254e03213
# FVERSION 93_DbLog.pm:v5.11.0-s29401/2024-12-05
# MODE asynchronous
# MODEL MYSQL
# NAME fhemMysql
# NR 3
# NTFY_ORDER 50-fhemMysql
# PID 67338
# REGEXP .*:.*
# SBP_PID 67340
# SBP_STATE running
# STATE connected
# TYPE DbLog
# dbconn mysql:database=fhem;host=localhost;port=3306
# dbuser fhemMysql
# eventCount 528
# 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:
# 2025-03-15 21:17:18 CacheOverflowLastNum 0
# 2025-03-15 10:01:05 CacheOverflowLastState normal
# 2025-03-15 21:17:18 CacheUsage 28
# 2025-03-15 21:17:18 NextSync 2025-03-15 21:18:18 or when CacheUsage 500 is reached
# 2025-03-15 21:17:18 background_processing_time 0.0825
# 2025-03-15 21:17:18 sql_processing_time 0.0748
# 2025-03-15 21:17:18 state connected
#
setstate fhemMysql connected
setstate fhemMysql 2025-03-15 21:17:18 CacheOverflowLastNum 0
setstate fhemMysql 2025-03-15 10:01:05 CacheOverflowLastState normal
setstate fhemMysql 2025-03-15 21:17:18 CacheUsage 28
setstate fhemMysql 2025-03-15 21:17:18 NextSync 2025-03-15 21:18:18 or when CacheUsage 500 is reached
setstate fhemMysql 2025-03-15 21:17:18 background_processing_time 0.0825
setstate fhemMysql 2025-03-15 21:17:18 sql_processing_time 0.0748
setstate fhemMysql 2025-03-15 21:17:18 state connected
Zitat von: supasheriff am 04 März 2025, 18:28:21try and error![]()
ich probiere verschiedene csv´s und schau welche Werte passen, da übernehme ich dann die ID und die Einstellungen in meine eigene csv.
.... mühsam
b,,datetime,,,,0700,,,,temp2,,,,,,btime,,,,,,bdate,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
list myHmUART
Save config
Bib
CUL_HM
Esszi
Kueche
Unsorted
Wozi
fewo_SZ
fewo_Wozi
icoEverything Everything
Logfile
Commandref
Remote doc
Edit files
Select style
Event monitor
Internals:
CFGFN /opt/fhem/rolladen.cfg
CNT 1
Clients :CUL_HM:
DEF /dev/ttyAMA0
DevState 1
DevType UART
DeviceName /dev/ttyAMA0@115200
FD 5
FUUID 67d467d1-f33f-e901-dd2b-b36f974b4950ce43
LastOpen 1742068220.73415
NAME myHmUART
NOTIFYDEV global
NR 48
NTFY_ORDER 50-myHmUART
PARTIAL 040e0401009e01
STATE opened
TYPE HMUARTLGW
XmitOpen 0
model HM-MOD-UART
Helper:
AckPending:
1:
cmd 00
dst 0
frame FD00030001009E03
resend 3
time 1742068221.73653
LastSendLen:
3
Log:
IDs:
MatchList:
1:CUL_HM ^A......................
PeerQueue:
HASH(0xfb15a8)
HASH(0x2405728)
HASH(0x240b3a0)
HASH(0x2414058)
HASH(0x2416460)
HASH(0x2416b50)
HASH(0x241a350)
HASH(0x241aa58)
HASH(0x241c850)
HASH(0x241cf88)
HASH(0x241e570)
HASH(0x241eca8)
HASH(0x2422230)
HASH(0x2422968)
HASH(0x2423148)
HASH(0x24259b8)
HASH(0x24286a8)
HASH(0x242eae0)
HASH(0x1ac1760)
HASH(0x227cee0)
HASH(0x2360d20)
HASH(0x23610e0)
HASH(0x2360840)
HASH(0x21678a8)
HASH(0x21830b8)
HASH(0x21830d0)
HASH(0x21827e8)
HASH(0x21825a8)
HASH(0x232d938)
HASH(0x235bc28)
HASH(0x22d2ac8)
HASH(0x22df130)
HASH(0x21824a0)
HASH(0x21683d0)
HASH(0x21795b8)
HASH(0x1ffa2d0)
Peers:
0589F6 pending
3CBCFC pending
3CBE05 pending
469587 pending
46A553 pending
46FC75 pending
47A5D5 pending
4915C1 pending
4915E9 pending
4915FF pending
491608 pending
49164F pending
4934D2 pending
493570 pending
49DA4B pending
503383 pending
52935C pending
529493 pending
READINGS:
2025-03-15 06:43:44 D-type HM-MOD-UART
2025-03-15 20:50:21 cond init
2025-03-15 06:43:44 loadLvl suspended
2025-03-15 20:50:20 state opened
helper:
Attributes:
hmId 434343