Put opentherm data into a database (MySQL) with PHP

This Forum is about the Opentherm gateway (OTGW) from Schelte

Moderator: hvxl

Post Reply
hansieh
Starting Member
Starting Member
Posts: 25
Joined: Sun Nov 26, 2006 12:27 pm
Location: Netherlands
Contact:

Put opentherm data into a database (MySQL) with PHP

Post 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/
(domotica, arduino, MySQL, PHP, electronics)
http://www.chamiri.nl
marcelr
Global Moderator
Global Moderator
Posts: 1153
Joined: Thu May 10, 2012 10:58 pm
Location: Ehv

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

Post 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
Attachments
parse_otmon_log.m.zip
Updated version. Small error in the calculation of OT floats fixed.
(1.1 KiB) Downloaded 511 times
read_ot_log.m.zip
main routine
(945 Bytes) Downloaded 512 times
Last edited by marcelr on Sun Jan 03, 2016 5:35 pm, edited 1 time in total.
User avatar
Rene
Global Moderator
Global Moderator
Posts: 1689
Joined: Wed Oct 08, 2008 3:54 pm
Location: Netherlands

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

Post by Rene »

I just use a key value store, like for all my other metrics. Influxdb is perfect for storing timeseries.
Rene.
hansieh
Starting Member
Starting Member
Posts: 25
Joined: Sun Nov 26, 2006 12:27 pm
Location: Netherlands
Contact:

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

Post 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.
(domotica, arduino, MySQL, PHP, electronics)
http://www.chamiri.nl
raymonvdm
Senior Member
Senior Member
Posts: 1153
Joined: Sun Dec 18, 2011 1:23 am

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

Post by raymonvdm »

I use MQTTwarn to perform some actions based on the MQTT output of OTMonitor

https://github.com/jpmens/mqttwarn
Running HS3PRO on PC with Z-Wave / OpenTherm / Plugwise / RFXcom / MQTT / XAP400 / Logitech Media Server and Squeezelite on PI`s
Dickuk
Starting Member
Starting Member
Posts: 15
Joined: Fri Nov 02, 2012 10:31 pm

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

Post by Dickuk »

Have a look at https://github.com/thoukydides/heatmiser-wifi

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

Return to “Opentherm Gateway Forum”