{"id":1453,"date":"2023-10-15T03:32:51","date_gmt":"2023-10-15T01:32:51","guid":{"rendered":"http:\/\/eiseler.de\/wordpress\/?p=1453"},"modified":"2023-10-15T03:33:58","modified_gmt":"2023-10-15T01:33:58","slug":"influxdb-zu-iobroker","status":"publish","type":"post","link":"https:\/\/eiseler.de\/wordpress\/?p=1453","title":{"rendered":"influxDB zu ioBroker"},"content":{"rendered":"\n<p>Wie bekomme ich einen Wert aus influxDB zu einem Datenpunkt in ioBroker. Ich habe dazu folgendes Script erstellt.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code><\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>#!\/bin\/bash\ntt=`curl -s 'http:\/\/192.168.178.127:8086\/query?db=forall' --data-urlencode $'q=select last(temperature_C) from \"Bresser-5in1\" where  time &gt; now() - 400s and \"id\"=\\'202\\' order by time desc' | grep -Eo '&#91;0-9.-]+' | tail -1`\n#tt=`cat \/home\/pi\/current_bresser_temp`\nbar=${tt\/\/\\\"\/}\ntt=$bar\necho $tt\ncurl 'http:\/\/192.168.178.127:8087\/set\/0_userdata.0.EisDatenPunkte.Wetter.bressertemp?value='${tt}'&amp;ack=true'<\/code><\/pre>\n\n\n\n<p><\/p>\n<div class=\"sharedaddy sd-sharing-enabled\"><div class=\"robots-nocontent sd-block sd-social sd-social-icon-text sd-sharing\"><h3 class=\"sd-title\">Share this:<\/h3><div class=\"sd-content\"><ul><li class=\"share-facebook\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-facebook-1453\" class=\"share-facebook sd-button share-icon\" href=\"https:\/\/eiseler.de\/wordpress\/?p=1453&amp;share=facebook\" target=\"_blank\" title=\"Click to share on Facebook\"><span>Facebook<\/span><\/a><\/li><li class=\"share-twitter\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-twitter-1453\" class=\"share-twitter sd-button share-icon\" href=\"https:\/\/eiseler.de\/wordpress\/?p=1453&amp;share=twitter\" target=\"_blank\" title=\"Click to share on Twitter\"><span>Twitter<\/span><\/a><\/li><li class=\"share-linkedin\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-linkedin-1453\" class=\"share-linkedin sd-button share-icon\" href=\"https:\/\/eiseler.de\/wordpress\/?p=1453&amp;share=linkedin\" target=\"_blank\" title=\"Click to share on LinkedIn\"><span>LinkedIn<\/span><\/a><\/li><li class=\"share-pocket\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-pocket sd-button share-icon\" href=\"https:\/\/eiseler.de\/wordpress\/?p=1453&amp;share=pocket\" target=\"_blank\" title=\"Click to share on Pocket\"><span>Pocket<\/span><\/a><\/li><li class=\"share-end\"><\/li><\/ul><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>Wie bekomme ich einen Wert aus influxDB zu einem Datenpunkt in ioBroker. Ich habe dazu folgendes Script erstellt.<\/p>\n<div class=\"sharedaddy sd-sharing-enabled\"><div class=\"robots-nocontent sd-block sd-social sd-social-icon-text sd-sharing\"><h3 class=\"sd-title\">Share this:<\/h3><div class=\"sd-content\"><ul><li class=\"share-facebook\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-facebook-1453\" class=\"share-facebook sd-button share-icon\" href=\"https:\/\/eiseler.de\/wordpress\/?p=1453&amp;share=facebook\" target=\"_blank\" title=\"Click to share on Facebook\"><span>Facebook<\/span><\/a><\/li><li class=\"share-twitter\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-twitter-1453\" class=\"share-twitter sd-button share-icon\" href=\"https:\/\/eiseler.de\/wordpress\/?p=1453&amp;share=twitter\" target=\"_blank\" title=\"Click to share on Twitter\"><span>Twitter<\/span><\/a><\/li><li class=\"share-linkedin\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-linkedin-1453\" class=\"share-linkedin sd-button share-icon\" href=\"https:\/\/eiseler.de\/wordpress\/?p=1453&amp;share=linkedin\" target=\"_blank\" title=\"Click to share on LinkedIn\"><span>LinkedIn<\/span><\/a><\/li><li class=\"share-pocket\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-pocket sd-button share-icon\" href=\"https:\/\/eiseler.de\/wordpress\/?p=1453&amp;share=pocket\" target=\"_blank\" title=\"Click to share on Pocket\"><span>Pocket<\/span><\/a><\/li><li class=\"share-end\"><\/li><\/ul><\/div><\/div><\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"spay_email":"","footnotes":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false},"categories":[50,46],"tags":[],"class_list":["post-1453","post","type-post","status-publish","format-standard","hentry","category-iobroker","category-smart-home"],"jetpack_featured_media_url":"","jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p8zAuQ-nr","jetpack-related-posts":[{"id":1445,"url":"https:\/\/eiseler.de\/wordpress\/?p=1445","url_meta":{"origin":1453,"position":0},"title":"Ulanzi Smart Pixel Clock","date":"07\/10\/2023","format":false,"excerpt":"Zu einem vern\u00fcnftigen Preis zu haben ist die Ulanzi Pixel Clock, die hier https:\/\/www.mydealz.de\/visit\/threadbeldesc\/2232719 oder \u00fcber Ali zu bekommen ist und hier kurz vorgestellt wird Im verlinkten Beitrag sind die wichtigsten links bereits zu finden. Das geniale ist, dass es ein Projekt \"Awtrix\" gibt dass es einfach dar\u00fcber geflasht wird\u2026","rel":"","context":"In &quot;Gadgets&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1333,"url":"https:\/\/eiseler.de\/wordpress\/?p=1333","url_meta":{"origin":1453,"position":1},"title":"ioBroker with docker, docker-compose, Homematic, grafana some hints","date":"02\/11\/2020","format":false,"excerpt":"some hints which helped me: docker-compose.yml, some ports version: '2' services: iobroker: restart: always image: buanet\/iobroker:latest container_name: iobroker hostname: iobroker ports: - \"8081:8081\" - \"1880:1880\" #node-red - \"1883:1883\" #mqtt - \"2001:2001\" #homematic - \"2010:2010\" #homematic - \"8082:8082\" #iobroker admin - \"8282:8282\" #flot - \"8088:8088\" #terminal - \"8284:8284\" #socketIO - \"33980:33980\"\u2026","rel":"","context":"Similar post","img":{"alt_text":"","src":"https:\/\/i1.wp.com\/eiseler.de\/wordpress\/wp-content\/uploads\/2020\/11\/image.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":941,"url":"https:\/\/eiseler.de\/wordpress\/?p=941","url_meta":{"origin":1453,"position":2},"title":"iMac 27 retina schaltet pl\u00f6tzlich Monitor aus","date":"01\/03\/2018","format":false,"excerpt":"Mein iMac Retina 27'' 2014 mit AMD Radeon R9 M295X 4096 MB fing pl\u00f6tzlich an, speziell bei Spielen, den Monitor auszuschalten. Also machte ich mich daran die Ursache, bzw. eine L\u00f6sung zu suchen. Der Fehler scheint nichts mit der CPU Auslastung zu tun zu haben. Um aber genauer einzugrenzen installierte\u2026","rel":"","context":"In &quot;Mac&quot;","img":{"alt_text":"","src":"https:\/\/i2.wp.com\/eiseler.de\/wordpress\/wp-content\/uploads\/2018\/02\/Bildschirmfoto-2018-02-26-um-01.28.42-303x1024.png?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":884,"url":"https:\/\/eiseler.de\/wordpress\/?p=884","url_meta":{"origin":1453,"position":3},"title":"Mein NIU Elektro Roller","date":"25\/01\/2018","format":false,"excerpt":"Am 21.11.2017 habe ich den Roller bei GreenCity am Nordbad abgeholt. Er stand zwar schon eine Woche fr\u00fcher da, aber es war in der Stadt kein Versicherungskennzeichen mehr aufzutreiben, so dass ich online eines bestellen musste. Die Motivation Fahrten in die n\u00e4here Umgebung nehmen drastisch zu, wenn die Kinder \u00e4lter\u2026","rel":"","context":"In &quot;Niu&quot;","img":{"alt_text":"","src":"https:\/\/i2.wp.com\/eiseler.de\/wordpress\/wp-content\/uploads\/2018\/01\/IMG_4170-e1516917346734-300x225.jpg?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":596,"url":"https:\/\/eiseler.de\/wordpress\/?p=596","url_meta":{"origin":1453,"position":4},"title":"Elektro Arbeiten","date":"04\/05\/2016","format":false,"excerpt":"Nachdem ich just im Keller zus\u00e4tzliche Steckdosen installiert, hier mal en Tipp bez\u00fcglich Werkzeug dazu.\u00a0 Was ben\u00f6tige ich um Elektroarbeiten durchzuf\u00fchren? Klar kann man alles irgendwie mit L\u00fcsterklemmen und Chinaimporten machen. Meistens h\u00f6rt aber mittendrin der Spa\u00df auf, weil es zu fummelig wird. Hier mal ein paar Dinge die das\u2026","rel":"","context":"In &quot;Test Review&quot;","img":{"alt_text":"","src":"https:\/\/i1.wp.com\/eiseler.de\/wordpress\/wp-content\/uploads\/2016\/05\/steckdose-212x300.jpg?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":889,"url":"https:\/\/eiseler.de\/wordpress\/?p=889","url_meta":{"origin":1453,"position":5},"title":"NIU Gep\u00e4cktr\u00e4ger Tuning","date":"26\/01\/2018","format":false,"excerpt":"Der Niu wurde angeschafft um m\u00f6glichst schnell etwas zu besorgen, oder ein Kind irgendwo hin zu bringen. Im ersten Eintrag habe ich geschrieben, dass er das sehr gut kann. Was aber etwas st\u00f6rt, ist die geringe Gep\u00e4ck\/Einkaufsunterbringm\u00f6glichkeit. Zum Eislauftraining brauchen wir Schlittschuhe, Helm, Sch\u00fctzer, Trinkflasche, meinen Kaffee ;-), meine Kamera.\u2026","rel":"","context":"In &quot;Niu&quot;","img":{"alt_text":"","src":"https:\/\/i1.wp.com\/eiseler.de\/wordpress\/wp-content\/uploads\/2018\/01\/IMG_4184-e1516921468913-225x300.jpg?resize=350%2C200","width":350,"height":200},"classes":[]}],"_links":{"self":[{"href":"https:\/\/eiseler.de\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1453","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/eiseler.de\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/eiseler.de\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/eiseler.de\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/eiseler.de\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1453"}],"version-history":[{"count":3,"href":"https:\/\/eiseler.de\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1453\/revisions"}],"predecessor-version":[{"id":1456,"href":"https:\/\/eiseler.de\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1453\/revisions\/1456"}],"wp:attachment":[{"href":"https:\/\/eiseler.de\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1453"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/eiseler.de\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1453"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/eiseler.de\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1453"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}