{"id":410,"date":"2017-07-12T19:49:07","date_gmt":"2017-07-12T17:49:07","guid":{"rendered":"http:\/\/www.maxx.net.ua\/?p=410"},"modified":"2017-07-12T19:49:07","modified_gmt":"2017-07-12T17:49:07","slug":"%d1%80%d0%be%d0%b7%d1%83%d0%bc%d0%bd%d0%b0-%d1%85%d0%b0%d1%82%d0%b8%d0%bd%d0%ba%d0%b0-openhab-%d0%b7%d0%b1%d0%b5%d1%80%d1%96%d0%b3%d0%b0%d0%bd%d0%bd%d1%8f-%d1%96%d1%81%d1%82%d0%be%d1%80%d1%96%d1%97","status":"publish","type":"post","link":"https:\/\/www.maxx.net.ua\/?p=410","title":{"rendered":"\u0420\u043e\u0437\u0443\u043c\u043d\u0430 \u0445\u0430\u0442\u0438\u043d\u043a\u0430 &#8211; OpenHAB, \u0437\u0431\u0435\u0440\u0456\u0433\u0430\u043d\u043d\u044f \u0456\u0441\u0442\u043e\u0440\u0456\u0457"},"content":{"rendered":"<p>\u0423 \u0446\u0456\u0454\u0457 \u0441\u0442\u0430\u0442\u0442\u0456 \u043c\u043e\u0432\u0430 \u043f\u0456\u0434\u0435 \u043f\u0440\u043e \u0442\u0435, \u044f\u043a \u0437\u0431\u0435\u0440\u0456\u0433\u0430\u0442\u0438 \u0456\u0441\u0442\u043e\u0440\u0438\u0447\u043d\u0456 \u0434\u0430\u043d\u0456 \u0442\u0430 \u043f\u043e\u0442\u0456\u043c \u0441\u0442\u0440\u043e\u0457\u0442\u0438 \u0433\u0440\u0430\u0444\u0456\u043a\u0438. \u0426\u0435 \u0434\u0430\u0454 \u0437\u043c\u043e\u0433\u0443 \u043f\u043e\u0442\u0456\u043c \u0446\u0456 \u0434\u0430\u043d\u0456 \u0430\u043d\u0430\u043b\u0456\u0437\u0443\u0432\u0430\u0442\u0438. \u041d\u0430\u043f\u0440\u0438\u043a\u043b\u0430\u0434 \u043a\u043e\u043d\u0434\u0438\u0446\u0456\u043e\u043d\u0435\u0440, \u043e\u0431\u0456\u0433\u0440\u0456\u0432\u0430\u0447, \u043d\u0430\u0433\u0440\u0456\u0432\u0430\u0447 \u0432\u043e\u0434\u0438 \u0432\u0438\u0442\u0440\u0430\u0447\u0430\u0454 \u0431\u0456\u043b\u044c\u0448\u0435 \u0435\u043b\u0435\u043a\u0442\u0440\u043e\u0435\u043d\u0435\u0440\u0433\u0456\u0457 \u043a\u043e\u043b\u0438 \u0443\u0432\u0456\u043c\u043a\u043d\u0435\u043d\u0438\u0439 \u043f\u043e\u0441\u0442\u0456\u0439\u043d\u043e \u0447\u0438 \u0442\u0456\u043b\u044c\u043a\u0438 \u043a\u043e\u043b\u0438 \u0442\u0440\u0435\u0431\u0430. \u0422\u0430 \u0456\u043d\u0448\u0435.<\/p>\n<p>\u0414\u043b\u044f \u0437\u0431\u0435\u0440\u0456\u0433\u0430\u043d\u043d\u044f \u0434\u0430\u043d\u0438\u0445 \u0431\u0443\u0434\u0435\u043c\u043e \u0432\u0438\u043a\u043e\u0440\u0438\u0441\u0442\u043e\u0432\u0443\u0432\u0430\u0442\u0438 \u0431\u0430\u0437\u0443 \u0434\u0430\u043d\u0438\u0445 <a href=\"http:\/\/www.h2database.com\/html\/main.html\">H2<\/a>.<\/p>\n<h2>\u0412\u0441\u0442\u0430\u043d\u043e\u0432\u043b\u0435\u043d\u043d\u044f \u0431\u0430\u0437\u0438 \u0434\u0430\u043d\u0438\u0445<\/h2>\n<p>\u0417\u0430\u0432\u0430\u043d\u0442\u0430\u0436\u0438\u043c\u043e \u0430\u0440\u0445\u0456\u0432 \u0442\u0430 \u0440\u043e\u0437\u043f\u0430\u043a\u0443\u0454\u043c\u043e \u0443 \u0442\u0435\u043a\u0443 \u043d\u0430\u043f\u0440\u0438\u043a\u043b\u0430\u0434 \/opt\/h2v3<\/p>\n<p><a href=\"http:\/\/www.maxx.net.ua\/wp-content\/uploads\/2017\/07\/h2v3.png\"><img loading=\"lazy\" class=\"alignnone wp-image-411 size-full\" src=\"http:\/\/www.maxx.net.ua\/wp-content\/uploads\/2017\/07\/h2v3.png\" alt=\"\" width=\"523\" height=\"200\" srcset=\"https:\/\/www.maxx.net.ua\/wp-content\/uploads\/2017\/07\/h2v3.png 523w, https:\/\/www.maxx.net.ua\/wp-content\/uploads\/2017\/07\/h2v3-300x115.png 300w\" sizes=\"(max-width: 523px) 100vw, 523px\" \/><\/a><\/p>\n<p>\u0421\u0442\u0432\u043e\u0440\u0438\u043c\u043e \u0442\u0435\u043a\u0443 \u0434\u043b\u044f \u0431\u0430\u0437\u0438 \u0434\u0430\u043d\u0438\u0445:\u00a0\/opt\/h2\/db<\/p>\n<p>\u0414\u043b\u044f \u0437\u0430\u043f\u0443\u0441\u043a\u0443 \u0441\u0442\u0432\u043e\u0440\u0435\u043c\u043e \u0441\u043a\u0440\u0456\u043f\u0442\u00a0\u00a0\/opt\/h2v3\/bin\/start.sh<\/p>\n<pre title=\" \/opt\/h2v3\/bin\/start.sh\" class=\"nums:false lang:sh decode:true\">#!\/bin\/sh\ncd \/opt\/h2v3\/bin\/\njava -cp .\/h2-1.3.175.jar org.h2.tools.Server -web -webPort 8081 -webAllowOthers -tcp -tcpPort 8082 -tcpAllowOthers -baseDir \/opt\/h2\/db\n<\/pre>\n<p>\u0414\u043b\u044f \u0437\u0430\u043f\u0443\u0441\u043a\u0443 \u0431\u0430\u0437\u0438 \u0434\u0456\u043d\u0438\u0445 \u043f\u0456\u0434 \u0447\u0430\u0441 \u0441\u0442\u0430\u0440\u0442\u0443 \u0441\u0438\u0441\u0442\u0435\u043c\u0438 \u0441\u0442\u0432\u043e\u0440\u0438\u043c\u043e \u0444\u0430\u0439\u043b \/etc\/systemd\/system\/h2.service<\/p>\n<pre class=\"nums:false lang:sh decode:true\">[Unit]\nDescription=H2 database\nAfter=h2.target\nBefore=openhab2.service\n\n[Service]\nExecStart=\/opt\/h2v3\/bin\/start.sh\n\n[Install]\nWantedBy=default.target<\/pre>\n<p>\u0423\u0432\u0456\u043c\u043a\u043d\u0435\u043c\u043e \u0446\u0435\u0439 \u0441\u0435\u0440\u0432\u0456\u0441 \u043f\u0456\u0434 \u0447\u0430\u0441 \u0441\u0442\u0430\u0440\u0442\u0443 \u0441\u0438\u0441\u0442\u0435\u043c\u0438 \u0437\u0430 \u0434\u043e\u043f\u043e\u043c\u043e\u0433\u043e\u044e \u043a\u043e\u043c\u0430\u043d\u0434\u0438<\/p>\n<pre class=\"nums:false lang:sh decode:true\">sudo systemctl enable h2.service<\/pre>\n<h2>\u041a\u043e\u043d\u0444\u0456\u0433\u0443\u0440\u0443\u0432\u0430\u043d\u043d\u044f OpenHAB \u0434\u043b\u044f \u0437\u0431\u0435\u0440\u0456\u0433\u0430\u043d\u043d\u044f \u0434\u0430\u043d\u0438\u0445<\/h2>\n<p>\u0412\u0441\u0442\u0430\u043d\u043e\u0432\u0438\u043c\u043e JDBC Persistence H2 addon<\/p>\n<p><a href=\"http:\/\/www.maxx.net.ua\/wp-content\/uploads\/2017\/07\/install-h2-addon.png\"><img loading=\"lazy\" class=\"wp-image-412 size-large alignnone\" src=\"http:\/\/www.maxx.net.ua\/wp-content\/uploads\/2017\/07\/install-h2-addon-1024x462.png\" alt=\"\" width=\"640\" height=\"289\" srcset=\"https:\/\/www.maxx.net.ua\/wp-content\/uploads\/2017\/07\/install-h2-addon-1024x462.png 1024w, https:\/\/www.maxx.net.ua\/wp-content\/uploads\/2017\/07\/install-h2-addon-300x135.png 300w, https:\/\/www.maxx.net.ua\/wp-content\/uploads\/2017\/07\/install-h2-addon-768x346.png 768w, https:\/\/www.maxx.net.ua\/wp-content\/uploads\/2017\/07\/install-h2-addon.png 1351w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>\u0414\u043e\u0434\u0430\u0454\u043c\u043e \u0448\u043b\u044f\u0445 \u0434\u043e \u0431\u0430\u0437\u0438 \u0434\u0430\u043d\u0438\u0445 \u0443 \u0444\u0430\u0439\u043b\u00a0\/etc\/openhab2\/services.jdbc.cfg<\/p>\n<pre class=\"nums:false lang:sh decode:true\">url=jdbc:h2:tcp:\/\/localhost:8082\/openhab-db<\/pre>\n<p>\u0421\u0442\u0432\u043e\u0440\u0438\u043c\u043e \u043a\u043e\u043d\u0444\u0456\u0433\u0443\u0440\u0430\u0446\u0456\u044e \u0434\u043b\u044f \u0437\u0431\u0435\u0440\u0456\u0433\u0430\u043d\u043d\u044f \u0443\u0441\u0456\u0445 \u0437\u043d\u0430\u0447\u0435\u043d\u043d\u044c\u044e \u0414\u043b\u044f \u0446\u044c\u043e\u0433\u043e \u0441\u0442\u0432\u043e\u0440\u0438\u043c\u043e \u0444\u0430\u0439\u043b\u00a0\/etc\/openhab2\/persistence\/jdbc.persist:<\/p>\n<pre class=\"nums:false lang:xhtml decode:true\">Strategies {\n        \/\/ if no strategy is specified for an item entry below, the default list will be used\n        everyMinute     : \"0 * * * * ?\"\n        every5Minutes : \"0 *\/5 * * * ?\"\n        everyHour   : \"0 0 * * * ?\"\n        everyDay    : \"0 0 0 * * ?\"\n        default = everyChange\n}\n\nItems {\n    \/\/ persist all items once a day and on every change and restore them from the db at startup\n        BATHROOM*, ROOM1* : strategy = everyChange, everyMinute, everyDay, restoreOnStartup\n}\n<\/pre>\n<p>\u0412\u0441\u0435. OpenHAB \u043f\u043e\u0432\u0438\u043d\u0435\u043d \u0441\u0442\u0432\u043e\u0440\u0438\u0442\u0438 \u0443\u0441\u0456 \u0442\u0430\u0431\u043b\u0438\u0446\u0456 \u0442\u0430 \u043f\u043e\u0447\u0430\u0442\u0438 \u0437\u0430\u043f\u0438\u0441\u0443\u0432\u0430\u0442\u0438 \u0434\u0430\u043d\u043d\u0456:<\/p>\n<p><a href=\"http:\/\/www.maxx.net.ua\/wp-content\/uploads\/2017\/07\/h2example.png\"><img loading=\"lazy\" class=\"wp-image-413 size-full alignnone\" src=\"http:\/\/www.maxx.net.ua\/wp-content\/uploads\/2017\/07\/h2example.png\" alt=\"\" width=\"699\" height=\"558\" srcset=\"https:\/\/www.maxx.net.ua\/wp-content\/uploads\/2017\/07\/h2example.png 699w, https:\/\/www.maxx.net.ua\/wp-content\/uploads\/2017\/07\/h2example-300x239.png 300w\" sizes=\"(max-width: 699px) 100vw, 699px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>\u041e\u043d\u043e\u0432\u0438\u043c\u043e \u043a\u043e\u043d\u0444\u0456\u0433\u0443\u0440\u0430\u0446\u0456\u044e \u0441\u0430\u0439\u0442\u0443 (\u0434\u043e\u0434\u0430\u043c\u043e \u0433\u0440\u0430\u0444\u0456\u043a):<\/p>\n<pre class=\"nums:false lang:xhtml decode:true \">sitemap house label=\"\u041c\u0456\u0439 \u0434\u0456\u043c\" {\n        Frame label=\"\u0414\u0430\u0442\u0430\" {\n                Text item=Date\n        }\n\n        Frame label=\"\u0412\u0430\u043d\u043d\u0430\" {\n                Switch item=BATHROOM_BOILER_1\n                Text item=BATHROOM_BOILER1_CURRENT_1\n                Text item=BATHROOM_BOILER1_CURRENT\n        }\n\n        Frame label=\"History\" {\n                Chart label=\"Current\" item=BATHROOM_BOILER1_CURRENT_1 period=12h refresh=300\n        }\n}\n<\/pre>\n<p>\u0423 \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442\u0456 \u043e\u0442\u0440\u0438\u043c\u0430\u0454\u043c\u043e \u0442\u0430\u043a\u0443 \u0441\u0442\u043e\u0440\u0456\u043d\u043a\u0443<\/p>\n<p><a href=\"http:\/\/www.maxx.net.ua\/wp-content\/uploads\/2017\/07\/graph.jpg\"><img loading=\"lazy\" class=\"wp-image-415 size-full alignnone\" src=\"http:\/\/www.maxx.net.ua\/wp-content\/uploads\/2017\/07\/graph.jpg\" alt=\"\" width=\"800\" height=\"721\" srcset=\"https:\/\/www.maxx.net.ua\/wp-content\/uploads\/2017\/07\/graph.jpg 800w, https:\/\/www.maxx.net.ua\/wp-content\/uploads\/2017\/07\/graph-300x270.jpg 300w, https:\/\/www.maxx.net.ua\/wp-content\/uploads\/2017\/07\/graph-768x692.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u0423 \u0446\u0456\u0454\u0457 \u0441\u0442\u0430\u0442\u0442\u0456 \u043c\u043e\u0432\u0430 \u043f\u0456\u0434\u0435 \u043f\u0440\u043e \u0442\u0435, \u044f\u043a \u0437\u0431\u0435\u0440\u0456\u0433\u0430\u0442\u0438 \u0456\u0441\u0442\u043e\u0440\u0438\u0447\u043d\u0456 \u0434\u0430\u043d\u0456 \u0442\u0430 \u043f\u043e\u0442\u0456\u043c \u0441\u0442\u0440\u043e\u0457\u0442\u0438 \u0433\u0440\u0430\u0444\u0456\u043a\u0438. \u0426\u0435 \u0434\u0430\u0454 \u0437\u043c\u043e\u0433\u0443 \u043f\u043e\u0442\u0456\u043c \u0446\u0456 \u0434\u0430\u043d\u0456 \u0430\u043d\u0430\u043b\u0456\u0437\u0443\u0432\u0430\u0442\u0438. \u041d\u0430\u043f\u0440\u0438\u043a\u043b\u0430\u0434 \u043a\u043e\u043d\u0434\u0438\u0446\u0456\u043e\u043d\u0435\u0440, \u043e\u0431\u0456\u0433\u0440\u0456\u0432\u0430\u0447, \u043d\u0430\u0433\u0440\u0456\u0432\u0430\u0447 \u0432\u043e\u0434\u0438 \u0432\u0438\u0442\u0440\u0430\u0447\u0430\u0454 \u0431\u0456\u043b\u044c\u0448\u0435 \u0435\u043b\u0435\u043a\u0442\u0440\u043e\u0435\u043d\u0435\u0440\u0433\u0456\u0457 \u043a\u043e\u043b\u0438 \u0443\u0432\u0456\u043c\u043a\u043d\u0435\u043d\u0438\u0439 \u043f\u043e\u0441\u0442\u0456\u0439\u043d\u043e \u0447\u0438 \u0442\u0456\u043b\u044c\u043a\u0438 \u043a\u043e\u043b\u0438 \u0442\u0440\u0435\u0431\u0430. \u0422\u0430 \u0456\u043d\u0448\u0435. \u0414\u043b\u044f \u0437\u0431\u0435\u0440\u0456\u0433\u0430\u043d\u043d\u044f \u0434\u0430\u043d\u0438\u0445 \u0431\u0443\u0434\u0435\u043c\u043e \u0432\u0438\u043a\u043e\u0440\u0438\u0441\u0442\u043e\u0432\u0443\u0432\u0430\u0442\u0438 \u0431\u0430\u0437\u0443 \u0434\u0430\u043d\u0438\u0445 H2. \u0412\u0441\u0442\u0430\u043d\u043e\u0432\u043b\u0435\u043d\u043d\u044f \u0431\u0430\u0437\u0438 \u0434\u0430\u043d\u0438\u0445 \u0417\u0430\u0432\u0430\u043d\u0442\u0430\u0436\u0438\u043c\u043e \u0430\u0440\u0445\u0456\u0432 \u0442\u0430 \u0440\u043e\u0437\u043f\u0430\u043a\u0443\u0454\u043c\u043e \u0443 [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[6],"tags":[],"_links":{"self":[{"href":"https:\/\/www.maxx.net.ua\/index.php?rest_route=\/wp\/v2\/posts\/410"}],"collection":[{"href":"https:\/\/www.maxx.net.ua\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.maxx.net.ua\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.maxx.net.ua\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.maxx.net.ua\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=410"}],"version-history":[{"count":0,"href":"https:\/\/www.maxx.net.ua\/index.php?rest_route=\/wp\/v2\/posts\/410\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.maxx.net.ua\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=410"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.maxx.net.ua\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=410"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.maxx.net.ua\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=410"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}