[CaTS] ForgetMeNot - Week 3: Data persistence and charts with OpenHAB

RE: [CaTS] ForgetMeNot - Week 3: Data persistence and charts with OpenHAB

gonium — Sun, 04 Oct 2015 12:24:13 GMT

Just a quick addition: I needed to add an item for the temperature chart period - otherwise, OpenHAB wasn't able to detect the type of the switch in the sitemap. The result was that all three graphs were shown simultaneously. This is how my item definition looks like:

[embed:dc8ab71f-3b98-42d9-b0f6-e21e02a0f8e2:3ef06e6b-9b7d-4651-b12d-db8be7f5e991:type=text&text=Number+Temperature_Chart_Period+%22Chart+period+%5B%25s%5D%22]

Hope this helps. Thanks for this great walkthrough!

-Mathias

RE: [CaTS] ForgetMeNot - Week 3: Data persistence and charts with OpenHAB

Former Member — Fri, 30 Jan 2015 12:31:11 GMT

Hai Fredrick,

the following is my mysql.persist :

// persistence strategies have a name and a definition and are referred to in the "Items" section

Strategies {

// for rrd charts, we need a cron strategy

everyMinute : "0 * * * * ?"

}

Items {

DemoSwitch,NoOfLights,Window_GF_Toilet,Heating* : strategy = everyChange, everyMinute, restoreOnStartup

// let's only store temperature values in mysql

Temperature*,Weather_Chart* : strategy = everyMinute, restoreOnStartup

}

I am pushing random values as temperature values for Weather_Chart group. i Just want to know if i have to create manually tables or will openhab generate tables based on the items inside it?

RE: [CaTS] ForgetMeNot - Week 3: Data persistence and charts with OpenHAB

fvan — Fri, 19 Sep 2014 13:53:32 GMT

[mention:8fb233e8974445138ef0af2b63b49f94:e9ed411860ed4f2ba0265705b8793d05] made a good point (thanks):

even though everything seems to work as is, it might be recommended to also set the default persistence to mysql:

[embed:dc8ab71f-3b98-42d9-b0f6-e21e02a0f8e2:3ef06e6b-9b7d-4651-b12d-db8be7f5e991:type=text&text=%23+The+name+of+the+default+persistence+service+to+use%0Apersistence%3Adefault%3Dmysql]

Frederick

RE: [CaTS] ForgetMeNot - Week 3: Data persistence and charts with OpenHAB

ravi_butani — Sat, 23 Aug 2014 10:40:58 GMT

I did all u have done... on my url it shows blank chart... even after many restarts it cant show any data on chart.. mysql:url=jdbc:mysql://127.0.0.1:3306/openhab is this url in config is same for all and if not how can I know my correct URL...?

RE: [CaTS] ForgetMeNot - Week 3: Data persistence and charts with OpenHAB

michaelwylie — Mon, 18 Aug 2014 20:27:04 GMT

Also, my project needs a cool name like everyone elses, any help there?

RE: [CaTS] ForgetMeNot - Week 3: Data persistence and charts with OpenHAB

michaelwylie — Mon, 18 Aug 2014 20:26:01 GMT

Is there a faster way to restart the system? I feel like it takes forever and I've already removed all the unnecessary bindings.

RE: [CaTS] ForgetMeNot - Week 3: Data persistence and charts with OpenHAB

hlipka — Mon, 18 Aug 2014 20:19:36 GMT

OK, I got it to work. I used Frederick's mysql.persist configuration, and was able to get my Items table populated (and the other tables as well). But what is strange: with each restart, only the first sensor sending data gets the entry in the Items table, for all others I got no entry there. But 3 restarts later I'm there [View:/resized-image/__size/16x16/__key/commentfiles/f7d226abd59f475c9d224a79e3f0ec07-3feec164-d1a4-40a2-8588-a226114afe03/7725.contentimage_5F00_1.png:16:16]

RE: [CaTS] ForgetMeNot - Week 3: Data persistence and charts with OpenHAB

hlipka — Mon, 18 Aug 2014 19:55:25 GMT

@Frederick : Yes, I cleared the IDs, this setup actually shows the sensor state properly in the web UI.

[mention:8fb233e8974445138ef0af2b63b49f94:e9ed411860ed4f2ba0265705b8793d05]: Well spotted, that line was incorrect. OpenHAB seems to read the configuration fine nonetheless (there isnother sensor defined after that which also worked fine).

But even when I change that to be correct, the MySQL setup doesn't work [View:/resized-image/__size/16x16/__key/commentfiles/f7d226abd59f475c9d224a79e3f0ec07-3feec164-d1a4-40a2-8588-a226114afe03/8321.contentimage_5F00_2.png:16:16]

RE: [CaTS] ForgetMeNot - Week 3: Data persistence and charts with OpenHAB

hlipka — Mon, 18 Aug 2014 17:37:17 GMT

Strange. I did the same, but for some reason my 'Items' table is not getting populated [View:/resized-image/__size/16x16/__key/commentfiles/f7d226abd59f475c9d224a79e3f0ec07-3feec164-d1a4-40a2-8588-a226114afe03/contentimage_5F00_2.png:16:16] There is no error in the log file, so I'm kind of stuck. (The table itself got created, though)

RE: [CaTS] ForgetMeNot - Week 3: Data persistence and charts with OpenHAB

mcb1 — Mon, 18 Aug 2014 04:57:02 GMT

Thanks Frederick

That's exactly the sort of thing I need to do for my project ...

Mark

RE: [CaTS] ForgetMeNot - Week 3: Data persistence and charts with OpenHAB

vish — Mon, 18 Aug 2014 04:16:06 GMT

Wow....that's an elaborate guide. Thanks Frederick! [View:/resized-image/__size/16x16/__key/commentfiles/f7d226abd59f475c9d224a79e3f0ec07-3feec164-d1a4-40a2-8588-a226114afe03/contentimage_5F00_1.png:16:16] I'm also trying to do the same thing, but stuck. I think this will solve my problem.