Hello everyone, I’ve been running Pimatic for almost a year on MySQL without any issue but recently my Pimatic stopped working for no reason. I reinstalled the Pimatic and ran it with the old config but the result was the same - pimatic won’t start and there is no message in the console or logs at all.
I was searching for the problem so I remove MySQL connection and let pimatic create new sql lite db and suddnly everythink is working just fine. I never touched MySQL in last year or so and didn’t do any changes. I’ve also tried connecting MySQL from command line and it’s ok. Status of the db is also ok.
Could you please advice me what could be the problem or how to get to an error message where I could learn more why pimatic is not starting? It’s can be stuck at the last line without any error for days but the http server is not started and front end is not loading.
Log from command line:
pi@raspberrypi:~/pimatic-app-v2 $ sudo node_modules/pimatic/pimatic.js
20:13:37.307 2018-01-19 Friday
20:13:46.522 [pimatic] Starting pimatic version 0.9.42
20:13:47.742 [pimatic] Could not find a rule with the ID “lights-on-when-out” from group “lights” in rules config section.
20:13:47.746 [pimatic] Could not find a rule with the ID “lights-on-when-out-2” from group “lights” in rules config section.
20:13:47.748 [pimatic] Could not find a rule with the ID “lights-on-when-out3” from group “lights” in rules config section.
20:13:47.754 [pimatic] Could not find a device with the ID “spare-relay-a” from page “garage” in devices config section.
20:13:51.237 [pimatic, ppm] 2.15.12
20:13:51.373 [pimatic] Loading plugin: “pimatic-cron” (0.8.8)
20:13:52.131 [pimatic] Loading plugin: “pimatic-mobile-frontend” (0.9.12)
20:13:53.414 [pimatic] Loading plugin: “pimatic-mysensors” (0.9.0)
20:13:53.584 [pimatic] Loading plugin: “pimatic-ping” (0.9.5)
20:13:53.664 [pimatic] Loading plugin: “pimatic-sysinfo” (0.9.4)
20:13:53.942 [pimatic] Loading plugin: “pimatic-alert” (0.3.7)
20:13:54.006 [pimatic] Loading plugin: “pimatic-ds18b20” (0.8.9)
20:13:54.067 [pimatic] Loading plugin: “pimatic-dht-sensors” (0.9.3)
20:13:54.115 [pimatic] Loading plugin: “pimatic-gpio” (0.9.0)
20:13:54.250 [pimatic] Loading plugin: “pimatic-pushbullet” (0.9.0)
20:13:55.235 [pimatic] Loading plugin: “pimatic-bmp180” (2.0.1)
20:13:55.284 [pimatic] Loading plugin: “pimatic-sunrise” (0.8.7)
20:13:55.379 [pimatic] Loading plugin: “pimatic-openweather” (0.9.4)
20:13:55.495 [pimatic] Loading plugin: “pimatic-tradfri” (0.1.17)
20:13:55.792 [pimatic-cron] the time is: Fri Jan 19 2018 20:13:55 GMT+0100 (CET)
20:13:55.818 [pimatic-mysensors] <- TimeOffset -3600
20:13:56.247 [pimatic-mysensors] initializing SerialPortDriver
20:13:57.203 [pimatic-sunrise] Your location is set to lat: 49.799264, long: 13.489642
20:13:57.313 [pimatic-tradfri] Plugin initialization…
20:13:57.695 [pimatic-mysensors] Connected to MySensors Gateway.
20:13:58.089 [pimatic-mysensors] MySensorsSwitch kitchen-fan kitchen fan true
20:13:58.107 [pimatic] New device “kitchen fan”…
20:13:58.686 [pimatic] New device “pressure”…
20:13:58.739 [pimatic-mysensors] MySensorsDHT kitchen-wall kitchen-wall
20:13:58.752 [pimatic] New device “kitchen-wall”…
20:13:58.804 [pimatic-mysensors] MySensorsDHT kitchen kitchen
20:13:58.815 [pimatic] New device “kitchen”…
20:13:58.927 [pimatic-mysensors] MySensorsDHT badroom badroom
20:13:58.935 [pimatic] New device “badroom”…
20:13:58.972 [pimatic-mysensors] MySensorsSwitch badroom-fan badroom fan false
20:13:58.977 [pimatic] New device “badroom fan”…
20:13:59.027 [pimatic] New device “kata”…
20:13:59.085 [pimatic] New device “PIR livingroom”…
20:13:59.122 [pimatic] New device “PIR hall”…
20:13:59.155 [pimatic] New device “hall”…
20:13:59.225 [pimatic] New device “living room”…
20:13:59.306 [pimatic] New device “system”…
20:13:59.369 [pimatic-mysensors] MySensorsSwitch hot-water-circulation hot water circulation true
20:13:59.392 [pimatic] New device “hot water circulation”…
20:13:59.431 [pimatic-mysensors] MySensorsDistance water-tank water tank: distance to top
20:13:59.438 [pimatic] New device “water tank: distance to top”…
20:13:59.475 [pimatic-mysensors] MySensorsDST hot-water hot-water
20:13:59.492 [pimatic] New device “hot-water”…
20:13:59.553 [pimatic] New device “water tank: water volume”…
20:13:59.589 [pimatic-mysensors] MySensorsDHT water-tank-environment water tank: environment
20:13:59.595 [pimatic] New device “water tank: environment”…
20:13:59.758 [pimatic] New device “weather - now”…
20:13:59.854 [pimatic] New device “weather forecast, 1 day”…
20:13:59.919 [pimatic] New device “water tank: income forecast”…
20:13:59.957 [pimatic] New device “water tank: free volume”…
20:13:59.988 [pimatic] New device “water tank: water level”…
20:14:00.016 [pimatic] New device “flowers watering”…
20:14:00.053 [pimatic] New device “lawn watering”…
20:14:00.082 [pimatic] New device “municipal water”…
20:14:00.111 [pimatic] New device “drain”…
20:14:00.140 [pimatic] New device “home alarm switch”…
20:14:00.170 [pimatic] New device “home alarm enabled”…
20:14:00.205 [pimatic] New device “home alarm state”…
20:14:00.249 [pimatic] New device “home alarm”…
20:14:00.328 [pimatic] New device “keypad”…
20:14:00.421 [pimatic] New device “siren inside”…
20:14:00.451 [pimatic] New device “siren inside tamper”…
20:14:00.480 [pimatic-mysensors] MySensorsSwitch garage-gate-control garage gate false
20:14:00.484 [pimatic] New device “garage gate”…
20:14:00.522 [pimatic-mysensors] MySensorsSwitch spare-relay-b pipe heating false
20:14:00.526 [pimatic] New device “pipe heating”…
20:14:00.551 [pimatic-mysensors] MySensorsSwitch spare-releay-3 spare releay false
20:14:00.557 [pimatic] New device “spare releay”…
20:14:00.599 [pimatic-mysensors] MySensorsSwitch electric-pump electric pump true
20:14:00.603 [pimatic] New device “electric pump”…
20:14:00.653 [pimatic] New device “weather forecast, 2 days”…
20:14:00.715 [pimatic] New device “weather forecast, 3 days”…
20:14:00.775 [pimatic] New device “weather forecast, 4 days”…
20:14:00.835 [pimatic] New device “weather forecast, 5 days”…
20:14:00.890 [pimatic-mysensors] MySensorsPIR garage-gate garage gate true
20:14:00.902 [pimatic] New device “garage gate”…
20:14:00.947 [pimatic-mysensors] MySensorsPIR pir-garage PIR - garage false
20:14:00.954 [pimatic] New device “PIR - garage”…
20:14:01.008 [pimatic] New device “Jan”…
20:14:01.038 [pimatic-mysensors] MySensorsPIR garage-door garage door false
20:14:01.044 [pimatic] New device “garage door”…
20:14:01.079 [pimatic-mysensors] MySensorsPIR garage-window garage window false
20:14:01.085 [pimatic] New device “garage window”…
20:14:01.117 [pimatic] New device “outside sirene - flashing”…
20:14:01.145 [pimatic] New device “outside sirene - sirene”…
20:14:01.210 [pimatic] New device “pipe tems”…
20:14:01.239 [pimatic] New device “TradfriHub”…
20:14:01.283 [pimatic] New device “living room - cieling”…
20:14:01.341 [pimatic] New device “living room - lamp”…
20:14:01.385 [pimatic] New device “TRADFRI remote control”…
20:14:01.426 [pimatic] New device “LIVING ROOM”…
20:14:01.483 [pimatic] New device “Scene”…
Original MySQL confing (it’s not working with this one)
"database": {
"client": "mysql",
"connection": {
"host": "192.168.1.123",
"user": "pimatic",
"password": "XXXXXXXX",
"database": "home_automation_v1"
},
"deviceAttributeLogging": [
{
"deviceId": "*",
"attributeName": "*",
"type": "*",
"interval": "0",
"expire": "15y"
},
{
"deviceId": "*",
"attributeName": "*",
"type": "continuous",
"interval": "5min",
"expire": "15y"
},
{
"deviceId": "pir-livingroom",
"attributeName": "*",
"type": "number",
"expire": "60d"
},
{
"deviceId": "pir-hall",
"attributeName": "*",
"type": "number",
"expire": "60d"
}
],
"messageLogging": [
{
"level": "*",
"tags": [],
"expire": "30d"
},
{
"level": "debug",
"tags": [],
"expire": "0"
}
]
},
SQL lite config (it’s working with this one)
"database": {
"deviceAttributeLogging": [
{
"deviceId": "*",
"attributeName": "*",
"type": "*",
"interval": "0",
"expire": "7d"
},
{
"deviceId": "*",
"attributeName": "*",
"type": "continuous",
"interval": "5min",
"expire": "7d"
},
{
"deviceId": "*",
"attributeName": "temperature",
"type": "number",
"expire": "1y"
},
{
"deviceId": "*",
"attributeName": "humidity",
"type": "number",
"expire": "1y"
}
],
"messageLogging": [
{
"level": "*",
"tags": [],
"expire": "7d"
},
{
"level": "debug",
"tags": [],
"expire": "0"
}
]
},