möchte eine lokale Sqlite Datenbank auf meiner CCU3 zum speichern von Aktor Schaltungen aufsetzten.
Ich hab dabei wahrscheinlich etwas grundsätzlich kaputt gemacht.
1. Habe versucht sqlite über Pakete der RedMatic zu installieren. Dabei ist ein Fehler aufgetreten.
2. Sqlite in der Palette von RED nicht zu sehen.
3 Red Palette Manager zeigt
4. Debug in der RedMatic eingeschaltet. Einträge die auf sqlite zeigen.
Code: Alles auswählen
{
"ccu": {
"VERSION": "3.45.7",
"PRODUCT": "ccu3",
"PLATFORM": "rpi3"
},
"redmatic": "4.7.1",
"nodejs": "10.15.3",
"ain2": "3.0.0",
"node-red": "0.20.5",
"node-red-contrib-mysensors": "3.3.0",
"node-red-contrib-rfxcom": "2.8.1",
"node-red-node-sqlite": "0.3.7",
"npm": "6.9.0",
"node-red-contrib-aggregator": "1.5.0",
"node-red-contrib-alexa-home-skill": "0.1.17",
"node-red-contrib-alexa-remote2": "2.2.2",
"node-red-contrib-bigtimer": "2.1.9",
"node-red-contrib-ccu": "2.1.5",
"node-red-contrib-combine": "1.8.1",
"node-red-contrib-cron": "0.0.4",
"node-red-contrib-influxdb": "0.2.2",
"node-red-contrib-moment": "3.0.2",
"node-red-contrib-mytimeout": "3.0.1",
"node-red-contrib-sun-position": "0.2.11",
"node-red-contrib-timeouttrigger": "0.0.2",
"node-red-dashboard": "2.15.2",
"node-red-node-email": "1.4.0",
"node-red-node-openweathermap": "0.2.1",
"node-red-node-rbe": "0.2.4",
"node-red-node-smooth": "0.1.0",
"redmatic-led": "1.1.0",
"redmatic-webapp": "0.3.1"
}
May 07 18:39:17
Package node-red-node-serialport update 0.7.1 to 0.8.1
Get https://github.com/rdmtc/RedMatic/releases/download/v4.4.1/redmatic-pkg-node-red-node-serialport-0.8.1.tar.gz
Extracting node-red-node-serialport.tar.gz
Done.
Package node-red-node-sqlite update 0.3.6 to 0.3.7
Get https://github.com/rdmtc/RedMatic/releases/download/v4.4.1/redmatic-pkg-node-red-node-sqlite-0.3.7.tar.gz
Extracting node-red-node-sqlite.tar.gz
Done.
Package node-red-contrib-smartmeter update 0.2.0 to 0.2.1
Get https://github.com/rdmtc/RedMatic/releases/download/v4.4.1/redmatic-pkg-node-red-contrib-smartmeter-0.2.1.tar.gz
Extracting node-red-contrib-smartmeter.tar.gz
Done.
Package node-red-contrib-modbus 4.1.3 is up-to-date
Package node-red-contrib-mysensors update 3.2.0 to 3.3.0
Get https://github.com/rdmtc/RedMatic/releases/download/v4.4.1/redmatic-pkg-node-red-contrib-mysensors-3.3.0.tar.gz
Extracting node-red-contrib-mysensors.tar.gz
Done.
Package node-red-contrib-rfxcom 2.8.1 is up-to-date
Package redmatic-homekit update 2.0.3 to 2.3.2
Get https://github.com/rdmtc/RedMatic/releases/download/v4.4.1/redmatic-pkg-redmatic-homekit-2.3.2.tar.gz
May 07 18:40:46
Package node-red-node-serialport 0.8.1 is up-to-date
Package node-red-node-sqlite 0.3.7 is up-to-date
Package node-red-contrib-smartmeter 0.2.1 is up-to-date
Package node-red-contrib-modbus 4.1.3 is up-to-date
Package node-red-contrib-mysensors 3.3.0 is up-to-date
Package node-red-contrib-rfxcom 2.8.1 is up-to-date
Package redmatic-homekit update 2.0.3 to 2.3.2
PackJun 16 10:28:50 schl_ccu3 daemon.info redmatic: Starting Node-RED
Jun 16 10:28:52 schl_ccu3 daemon.info node-red[22873]: Welcome to Node-RED
Jun 16 10:28:52 schl_ccu3 daemon.info node-red[22873]: ===================
Jun 16 10:28:52 schl_ccu3 daemon.info node-red[22873]: Node-RED version: v0.20.5
Jun 16 10:28:52 schl_ccu3 daemon.info node-red[22873]: Node.js version: v10.15.3
Jun 16 10:28:52 schl_ccu3 daemon.info node-red[22873]: Linux 4.14.34 arm LE
Jun 16 10:28:52 schl_ccu3 daemon.err node-red: (node:22873) [DEP0005] DeprecationWarning: Buffer() is deprecated due to security and usability issues. Please use the Buffer.alloc(), Buffer.allocUnsafe(), or Buffer.from() methods instead.
Jun 16 10:28:53 schl_ccu3 daemon.info node-red[22873]: Loading palette nodes
Jun 16 10:28:54 schl_ccu3 daemon.debug node-red[22873]: Module: node-red-dashboard 2.15.2
Jun 16 10:28:54 schl_ccu3 daemon.debug node-red[22873]: /usr/local/addons/redmatic/var/node_modules/node-red-dashboard
Jun 16 10:28:54 schl_ccu3 daemon.debug node-red[22873]: Module: node-red-contrib-aggregator 1.5.0
Jun 16 10:28:54 schl_ccu3 daemon.debug node-red[22873]: /usr/local/addons/redmatic/var/node_modules/node-red-contrib-aggregator
Jun 16 10:28:54 schl_ccu3 daemon.debug node-red[22873]: Module: node-red-contrib-alexa-remote2 2.2.2
Jun 16 10:28:54 schl_ccu3 daemon.debug node-red[22873]: /usr/local/addons/redmatic/var/node_modules/node-red-contrib-alexa-remote2
Jun 16 10:28:54 schl_ccu3 daemon.debug node-red[22873]: Module: node-red-contrib-bigtimer 2.1.9
Jun 16 10:28:54 schl_ccu3 daemon.debug node-red[22873]: /usr/local/addons/redmatic/var/node_modules/node-red-contrib-bigtimer
Jun 16 10:28:54 schl_ccu3 daemon.debug node-red[22873]: Module: node-red-contrib-ccu 2.1.5
Jun 16 10:28:54 schl_ccu3 daemon.debug node-red[22873]: /usr/local/addons/redmatic/var/node_modules/node-red-contrib-ccu
Jun 16 10:28:54 schl_ccu3 daemon.debug node-red[22873]: Module: node-red-contrib-combine 1.8.1
Jun 16 10:28:54 schl_ccu3 daemon.debug node-red[22873]: /usr/local/addons/redmatic/var/node_modules/node-red-contrib-combine
Jun 16 10:28:54 schl_ccu3 daemon.debug node-red[22873]: Module: node-red-contrib-cron 0.0.4
Jun 16 10:28:54 schl_ccu3 daemon.debug node-red[22873]: /usr/local/addons/redmatic/var/node_modules/node-red-contrib-cron
Jun 16 10:28:54 schl_ccu3 daemon.debug node-red[22873]: Module: node-red-contrib-influxdb 0.2.2
Jun 16 10:28:54 schl_ccu3 daemon.debug node-red[22873]: /usr/local/addons/redmatic/var/node_modules/node-red-contrib-influxdb
Jun 16 10:28:54 schl_ccu3 daemon.debug node-red[22873]: Module: node-red-contrib-moment 3.0.2
Jun 16 10:28:54 schl_ccu3 daemon.debug node-red[22873]: /usr/local/addons/redmatic/var/node_modules/node-red-contrib-moment
Jun 16 10:28:54 schl_ccu3 daemon.debug node-red[22873]: Module: node-red-contrib-mytimeout 3.0.1
Jun 16 10:28:54 schl_ccu3 daemon.debug node-red[22873]: /usr/local/addons/redmatic/var/node_modules/node-red-contrib-mytimeout
Jun 16 10:28:54 schl_ccu3 daemon.debug node-red[22873]: Module: node-red-contrib-sun-position 0.2.11
Jun 16 10:28:54 schl_ccu3 daemon.debug node-red[22873]: /usr/local/addons/redmatic/var/node_modules/node-red-contrib-sun-position
Jun 16 10:28:54 schl_ccu3 daemon.debug node-red[22873]: Module: node-red-contrib-timeouttrigger 0.0.2
Jun 16 10:28:54 schl_ccu3 daemon.debug node-red[22873]: /usr/local/addons/redmatic/var/node_modules/node-red-contrib-timeouttrigger
Jun 16 10:28:54 schl_ccu3 daemon.debug node-red[22873]: Module: node-red-contrib-alexa-home-skill 0.1.17
Jun 16 10:28:54 schl_ccu3 daemon.debug node-red[22873]: /usr/local/addons/redmatic/var/node_modules/node-red-contrib-alexa-home-skill
Jun 16 10:28:54 schl_ccu3 daemon.debug node-red[22873]: Module: node-red-node-email 1.4.0
Jun 16 10:28:54 schl_ccu3 daemon.debug node-red[22873]: /usr/local/addons/redmatic/var/node_modules/node-red-node-email
Jun 16 10:28:54 schl_ccu3 daemon.debug node-red[22873]: Module: node-red-node-openweathermap 0.2.1
Jun 16 10:28:54 schl_ccu3 daemon.debug node-red[22873]: /usr/local/addons/redmatic/var/node_modules/node-red-node-openweathermap
Jun 16 10:28:54 schl_ccu3 daemon.debug node-red[22873]: Module: node-red-node-rbe 0.2.4
Jun 16 10:28:54 schl_ccu3 daemon.debug node-red[22873]: /usr/local/addons/redmatic/var/node_modules/node-red-node-rbe
Jun 16 10:28:54 schl_ccu3 daemon.debug node-red[22873]: Module: node-red-node-smooth 0.1.0
Jun 16 10:28:54 schl_ccu3 daemon.debug node-red[22873]: /usr/local/addons/redmatic/var/node_modules/node-red-node-smooth
Jun 16 10:28:54 schl_ccu3 daemon.debug node-red[22873]: Module: redmatic-led 1.1.0
Jun 16 10:28:54 schl_ccu3 daemon.debug node-red[22873]: /usr/local/addons/redmatic/var/node_modules/redmatic-led
Jun 16 10:28:54 schl_ccu3 daemon.debug node-red[22873]: Module: redmatic-webapp 0.3.1
Jun 16 10:28:54 schl_ccu3 daemon.debug node-red[22873]: /usr/local/addons/redmatic/var/node_modules/redmatic-webapp
Jun 16 10:28:54 schl_ccu3 daemon.debug node-red[22873]: Module: node-red-node-sentiment 0.1.3
Jun 16 10:28:54 schl_ccu3 daemon.debug node-red[22873]: /usr/local/addons/redmatic/lib/node_modules/node-red/node_modules/node-red-node-sentiment
Jun 16 10:28:54 schl_ccu3 daemon.debug node-red[22873]: Module: node-red-node-tail 0.0.2
Jun 16 10:28:54 schl_ccu3 daemon.debug node-red[22873]: /usr/local/addons/redmatic/lib/node_modules/node-red/node_modules/node-red-node-tail
Jun 16 10:28:54 schl_ccu3 daemon.debug node-red[22873]: Module: node-red-contrib-mysensors 3.3.0
Jun 16 10:28:54 schl_ccu3 daemon.debug node-red[22873]: /usr/local/addons/redmatic/lib/node_modules/node-red-contrib-mysensors
Jun 16 10:28:54 schl_ccu3 daemon.debug node-red[22873]: Module: node-red-contrib-rfxcom 2.8.1
Jun 16 10:28:54 schl_ccu3 daemon.debug node-red[22873]: /usr/local/addons/redmatic/lib/node_modules/node-red-contrib-rfxcom
Jun 16 10:28:54 schl_ccu3 daemon.debug node-red[22873]: Module: node-red-node-sqlite 0.3.7
Jun 16 10:28:54 schl_ccu3 daemon.debug node-red[22873]: /usr/local/addons/redmatic/lib/node_modules/node-red-node-sqlite
Jun 16 10:28:58 schl_ccu3 daemon.info node-red[22873]: Dashboard version 2.15.2 started at /addons/red/ui
Jun 16 10:28:59 schl_ccu3 daemon.info node-red[22873]: node-red-contrib-ccu version: 2.1.5
Jun 16 10:29:01 schl_ccu3 daemon.warn node-red[22873]: ------------------------------------------------------
Jun 16 10:29:01 schl_ccu3 daemon.warn node-red[22873]: [node-red-node-sqlite/sqlite] TypeError: Cannot read property 'prototype' of undefined (line:4)
Jun 16 10:29:01 schl_ccu3 daemon.warn node-red[22873]: ------------------------------------------------------
Jun 16 10:29:01 schl_ccu3 daemon.info node-red[22873]: Settings file : /usr/local/addons/redmatic/lib/settings.js
Jun 16 10:29:01 schl_ccu3 daemon.info node-red[22873]: Context store : 'default' [module=memory]
Jun 16 10:29:01 schl_ccu3 daemon.info node-red[22873]: Context store : 'file' [module=localfilesystem]
Jun 16 10:29:01 schl_ccu3 daemon.info node-red[22873]: User directory : /usr/local/addons/redmatic/var
Jun 16 10:29:01 schl_ccu3 daemon.info node-red[22873]: Server now running at http://127.0.0.1:1880/addons/red/
Jun 16 10:29:01 schl_ccu3 daemon.info node-red[22873]: Active project : ArminCCU
Jun 16 10:29:01 schl_ccu3 daemon.info node-red[22873]: Flows file : /usr/local/addons/redmatic/var/projects/ArminCCU/flows.json
Jun 16 10:29:01 schl_ccu3 daemon.debug node-red[22873]: loaded flow revision: f85634619838eb5f36ea5818d2607c25
Jun 16 10:29:01 schl_ccu3 daemon.debug node-red[22873]: red/runtime/nodes/credentials.load : using active project key - disabled
Jun 16 10:29:01 schl_ccu3 daemon.debug node-red[22873]: red/runtime/nodes/credentials.load : keyType=disabled
Jun 16 10:29:01 schl_ccu3 daemon.info node-red[22873]: Starting flows
Vielen Dank schon mal.