Page 1 of 1

Put opentherm data into a database (MySQL) with PHP

PostPosted: Wed Dec 30, 2015 1:19 pm
by hansieh
Yesterday, I have my opentherm gateway soldered and connected and everything works fine.
My next step is to put the generated data via PHP in a database (MySQL) from where I can created the graphs.

Before I go creating it myself, I am wondering if there might be someone who has already created a database model and some PHP code what I could use.

For example what I like to created (My site):
http://www.chamiri.nl/drupal7/

Re: put opentherm data into a database (MySQL) with PHP

PostPosted: Wed Dec 30, 2015 3:42 pm
by marcelr
I am wondering if there might be someone who has already created a database model and some PHP code what I could use.


Not exactly, but I have a matlab script (two, actually) that dumps otgw log data into a struct (per day). Is easily converted to php.

EDIT 20160103: parse_otmon_log.m had a bug, fixed.

grtz,

marcelr

Re: put opentherm data into a database (MySQL) with PHP

PostPosted: Wed Dec 30, 2015 8:16 pm
by Rene
I just use a key value store, like for all my other metrics. Influxdb is perfect for storing timeseries.

Re: put opentherm data into a database (MySQL) with PHP

PostPosted: Wed Dec 30, 2015 9:31 pm
by hansieh
Rene wrote:I just use a key value store, like for all my other metrics. Influxdb is perfect for storing timeseries.

Hi Rene,
Influxdb looks very intressing, I will give it a try. thank for the tip.

Re: put opentherm data into a database (MySQL) with PHP

PostPosted: Thu Dec 31, 2015 10:36 am
by raymonvdm
I use MQTTwarn to perform some actions based on the MQTT output of OTMonitor

https://github.com/jpmens/mqttwarn

Re: put opentherm data into a database (MySQL) with PHP

PostPosted: Mon Jan 04, 2016 10:33 am
by Dickuk
Have a look at https://github.com/thoukydides/heatmiser-wifi

I modified his code to produce graphs on the opentherm data.