Send data to MySQL Database via Virtual Device

[lukashwm 0]

Hello folks,

 

I found this tutorial: 

Please login or register to see this link.

 , it also contains a link to this forum but the link itself is dead. I want to know if this is still possible because I can't get it to work. 

 

I can put the string in my url bar and it works. Like: http://myServer/data_post.php?type=temperature_sensor&name=exampleDevice&value=10.0&id=900 . It creates something in the database. So the webserver seems to run.

In HC2 device Overview the virtual device also confirms the button action by showing "Weather uploaded" but nothing happens.

 

The only difference is I got a webserver not a NAS to work as the database bridge. Also put the following inside the .htaccess file of the fibarostats folder to make sure its not a CORS policy problem.

 

<IfModule mod_headers.c>
  Header add Access-Control-Allow-Origin "http://myIpAdress" 
  Header add Access-Control-Allow-Methods: "GET,POST,OPTIONS,DELETE,PUT"
  Header add Access-Control-Allow-Headers: "Content-Type"
  Header add Access-Control-Allow-Credentials true 

  RewriteEngine on
  RewriteBase /
</IfModule>

 

kind regards,

Lukas

[drboss 107]

Maybe my solution help you:

Please login or register to see this link.

 , but in result of forum search engine  you will find many others solution to send any data to sql server. Second forum with many example is freach forum:

Please login or register to see this link.

 

 

 

[lukashwm 0]

I tried to implement ur solution but can't get it working...

 

How do I have to implement the lua scripts ? I create a Virtual Device or a scene with a button and insert the lua code right? But if I click a button or run the scene than nothing happens. No errors, just nothing. Is there a way to debug? Or am I just missing something?

 

ATM i got two different domains and I am able to fire http request and they are also inserted to my database but I got no chance to do it from the HC2. 

[drboss 107]

sql-syslog.lua is the scene (look the header), if you need write any message to sql (in this example like syslog message) call this scene from any other scene or VD by commands:

if __fibaroSceneId~=nil then dev = 'S' .. __fibaroSceneId else dev = 'V' .. fibaro:getSelfId() end

fibaro:startScene(76, {{sev = "info"}, {src = dev}, {msg = "test"}}) fibaro:startScene(76, {{sev = "info"}, {src = dev}, {msg = urlencode("test")}})

 

or

fibaro:startScene(76, {{sev = "debug"}, {src= "any info 1"}, {msg = "any info 2"}})

 

when 76 is scene id with sql-syslog.lua code, and src, msg, sev is data for sql table.

All was described in source.

 

I tested and used this scripts many time.