Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you may not be able to execute some actions.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

domoticz tables and mysensors

ebioz last edited by

Hi,
i am using mysensors on 3 arduinos that are collecting data with various sensors and managing the watering of my garden. Data is collected by domoticz on a RPI.
I am trying to get the data from domoticz to send it to another system that will allow to store it for a long time and external to my home as i don't want to open domoticz itself on internet.
I choose to pull the DB every minute to get last updated data. (bad idea ? better idea ?)

And domoticz database is far to be simple ... or logic.
I started with the table deviceStatus that have all the collected metrics. But i can't find the link between the table and the table my sensorChilds : how can i know that a device in deviceStatus is link to a node and child ?
i spent hours looking for the link and was not able to find how domoticz link it in the DB....

Thanks for your help.
Reply Quote 0
1 Reply Last reply

1
Posts

17
Views

Suggested Topics

Vera Gateway Versions
Troubleshooting • • karenbobiv

5

0
Votes

5
Posts

2061
Views

@karenbobiv I doubt it's related to the MySensors communication. Are you using a Dallas temp sensor? Could you check that the is actually connected to the dallas sensor by using isConnected(). When googling your problem I found a few hits on -196.6 which is the error code (DEVICE_DISCONNECTED) converted to Fahrenheit. Start debug mode (Config.h) to see what the sensor actually sends.
Node update on value from Domoticz
Domoticz • • zboblamont

2

0
Votes

2
Posts

17
Views

@zboblamont OK, so experiments concluded that the return data from the latest version of Domoticz is a String whether it be V_VARx or V_TEXT. I tried the dual declaration using the same CHILD_ID as intended and as VAR_X (using an RF24 - not sure of the relevance) and the actual value sent but failed to make any sense of abstracting the Ulong conversion or the string. Only by presenting a fresh CHILD_ID and duplicating the send of data (water meter) as a V_VAR1 could I recover the last sent reading as a V_VAR1 from that fresh CHILD_ID, thence eventually arriving at 'strtoul' as a solution to restoring the last known value. For clarity my Gateway and Controller run on a UPS, and I hope shortly to add the spare router to that UPS so I'm not left in the dark on what is happening in the dark on a battery powered laptop... Hope this helps others trying to keep track of meters between relentless power cuts and reboots...
How to get the bad status (red) for Temperature Node
Domoticz • • giangired

5

0
Votes

5
Posts

55
Views

Thanks everyone for the answers. However what I would like to do is create a routine with Dzvents that when I have the "red" indication (as shown in the image) causes a switch to operate which cuts the voltage to a device. The value of ".lastUpdate.minutesAgo" seems not to be the right solution because it continues to be increased in any case, regardless of the temperature value and the status of the "red" or normal indication.
Questions about an old setup
Domoticz • • dbemowsk

5

0
Votes

5
Posts

56
Views

@dbemowsk I'm sorry, I really don't know. I've never tried domoticz, not to mention any of its plugins. I do have Alexa working with my system, but I don't like it, just because of sending recorded voice out of the house all the time. So I plan to replace it once I get time to get Rhasspy going, assuming that I can get it going well enough. Alexa works very well with home assistant. Though we use a service that costs $5/month to be the cloud piece to interact with the Alexa service so that I don't have to get something standalone working here for that. Though I think that service is really only for integrating to home assistant, so it probably wouldn't do you any good. It's saved me a bunch of time, and as I want to use my time to replace the whole thing with Rhasspy, it's been worth it to me. But part of the reason I mention all of that is that with a quick search, it looks like controlicz is a similar service. Although they do say that you need to add the skill to your Alexa account. That would be annoying to me - doesn't that mean you need to say something like "Alexa, ask controlicz to turn on the kitchen light" or whatever?? With Nabu Casa, it also just uses the built-in smart home skill, so you don't have to install anything extra, leaving those extra words out each time. After the 10th time of having to do it I bet I'd really be gritting my teeth!
Trying to automate in Domoticz
Domoticz • • Feliw05

4

0
Votes

4
Posts

34
Views

the problem is "if (switch.state == 'On') then" that not works, write: if (switch.active) then or if (switch.inActive) then Device attributes and methods for all devices
S_GAS, send and request problem
Domoticz • • Marcin

1

0
Votes

1
Posts

6
Views

No one has replied

domoticz tables and mysensors

Suggested Topics

Vera Gateway Versions
Troubleshooting • • karenbobiv

Node update on value from Domoticz
Domoticz • • zboblamont

How to get the bad status (red) for Temperature Node
Domoticz • • giangired

Questions about an old setup
Domoticz • • dbemowsk

Trying to automate in Domoticz
Domoticz • • Feliw05

S_GAS, send and request problem
Domoticz • • Marcin

13
Online

11.4k
Users

11.1k
Topics

112.7k
Posts

domoticz tables and mysensors

Suggested Topics

Vera Gateway Versions Troubleshooting • • karenbobiv

Node update on value from Domoticz Domoticz • • zboblamont

How to get the bad status (red) for Temperature Node Domoticz • • giangired

Questions about an old setup Domoticz • • dbemowsk

Trying to automate in Domoticz Domoticz • • Feliw05

S_GAS, send and request problem Domoticz • • Marcin

13Online

11.4kUsers

11.1kTopics

112.7kPosts

Vera Gateway Versions
Troubleshooting • • karenbobiv

Node update on value from Domoticz
Domoticz • • zboblamont

How to get the bad status (red) for Temperature Node
Domoticz • • giangired

Questions about an old setup
Domoticz • • dbemowsk

Trying to automate in Domoticz
Domoticz • • Feliw05

S_GAS, send and request problem
Domoticz • • Marcin

13
Online

11.4k
Users

11.1k
Topics

112.7k
Posts