Page 1 of 1

Log Data to MySQL Database

Posted: 17 Feb 2016 16:32
by Bergman
Hello!

I am very new to ZWave in general, so please bear with me if I misunderstand something.

What I am trying to do is log all data from my ZWave and send it as it is being gathered to my MySQL database so that I can use it for graphs.

My current setup is a Raspberry Pi running the image found at http://razberry.z-wave.me/z-way-server/razberry.img.zip with the Razberry chip on it, and a Aeon Labs ZW075-C16 to measure power consumption.

Which part of the ZWay API would be best to look at here?

Best regards,
Anton

Re: Log Data to MySQL Database

Posted: 18 Feb 2016 11:27
by pz1
Did you look into the Developers Documentation Document? It is on site http://razberry.zwave.me

Re: Log Data to MySQL Database

Posted: 19 Feb 2016 14:47
by Bergman
I have been reading the Z-Way API and other documents for days now and I still cannot figure out how to do it in an easy way.

Re: Log Data to MySQL Database

Posted: 19 Feb 2016 15:42
by pz1
Have a look here https://github.com/maros/Zway-InfluxDbStats
Don't know if that is available as an online app in the meantime. Haven't seen it yet there. I don't know anything about this userModule

Re: Log Data to MySQL Database

Posted: 19 Feb 2016 15:56
by Bergman
I am also reading about a module called Sensor Value Logging? Could that be something that I could use? As far as I understand this way available under Z-Way HA, but I cannot find it now? Was it removed?

Re: Log Data to MySQL Database

Posted: 19 Feb 2016 16:19
by pz1
I guess you found it in the meantime (It still is in the official v2.2.1 release)

Re: Log Data to MySQL Database

Posted: 13 May 2016 12:30
by gabrielb
I have read about the InfluxDB module, is it possible to modify it to use mysql database instead?