Loggin to MS SQL or MySQL

[MSB 0]

Hello,

I have grown impatient with the lack of history for powerusage on my HC2. Everytime I upgrade the BOX Fibaro needs to clear my energy history which I do not like. So I grown impatient and want to log to SQL for backup. So Can I do something to log to SQL via for example a virtual device and a webpage or something. Any ideas?

[sonnyboy 11]

With Beyond Measure you can log hc data to mysql. With Isakssons komponent

I do it and it works great.

Check here.

Please login or register to see this link.

[Dalle1985 16]

If you know a bit of scripting it is quite easy to do. I have a setup which works in this way:

- A button on a virtual device is activated by a scene (scenes can't handle http requests for some strange reason)

- the virtual device opens a http-socket to my webserver and activates a php-script by means of a get message.

- the phpscript imports the entire device json from the hc2, located at:

Please login or register to see this code.

- the script then identifies the devices you want to log (i log everything of a specific device type, i.e. Plugs, or by means of a specific function i.e. "isBatteryOperated") and then exports the value and device ID to the database. A separate database stores the name as a function of id to avoid having to save the name in each value readout.

- the database can then be read out using a number of different graphing tools.

[MSB 0]

Good variant. With this I can go from fibaro to domoticz and IF fibaro gets better I can even go back again without loosing energy history.

[remcoploeg 10]

Dall1985 can you share your php script / virtual device for this solution?

 

thanks,

 

Remco

[sonnyboy 11]

It would be very nice with a step by step how to log to MySQL. That is the only thing that i miss in HC:2.

[remcoploeg 10]

Yes, that would be great. Than I can finally create some statistics about my house. The HC2 doesn't store enought data to do this...

[Bamsefar 13]

If the only thing you are after is loggin numbers, you might be interested in ThingSpeak.com, which is a service with logging capabilities - then you simply do not need a MySQL server - just simple LUA code like:

Please login or register to see this code.