{"id":22,"date":"2024-09-26T10:32:39","date_gmt":"2024-09-26T08:32:39","guid":{"rendered":"https:\/\/roess.ovh\/?page_id=22"},"modified":"2024-11-04T06:37:11","modified_gmt":"2024-11-04T05:37:11","slug":"poolueberwachung","status":"publish","type":"page","link":"https:\/\/roess.ovh\/index.php\/projekte\/pr\/poolueberwachung\/","title":{"rendered":"Pool\u00fcberwachung"},"content":{"rendered":"\n

<\/p>\n\n\n\n

Wasserqualit\u00e4ts\u00fcberwacher f\u00fcr einen Pool.<\/strong><\/p>\n\n\n\n

Dieser sollte  z.B. im Pumpenhaus untergebracht, t\u00e4glich \u00fcber WLAN Messwerte an einen WEB-Server oder per mail \u00fcbertragen. <\/p>\n\n\n\n

Dabei kann ein ESP32 dauerhaft stromversorgt werden und eine Verbindung zum WLAN aufrechterhalten. <\/p>\n\n\n\n

So k\u00f6nnte man feststellen, ob der ordentlich gewartet wird oder ob der Pool kurz vorm Umkippen ist. <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
    \n
  1. L\u00f6sungsansatz Der ESP32 sendet den Messwert \u00fcber einen MQTT-Server an einen zweiten ESP32, der die Messwerte darstellt.<\/strong><\/li>\n<\/ol>\n\n\n\n

    Files:<\/p>\n\n\n\n

    main.py<\/p>\n\n\n\n

    ESP32 \u00dcberwachung<\/h1>\n\n\n\n

    Complete project details at https:\/\/RandomNerdTutorials.com\/micropython-programming-with-esp32-and-esp8266\/<\/h1>\n\n\n\n

    def sub_cb(topic, msg):
    # print((‘Uebertragung: ‘, topic, msg))
    msg=str(msg)
    msg= msg[2:]
    msg=msg[:-5]
    print((‘NTC3905-100k: ‘, msg))
    # print [“%0.2f” % i]
    def connect_and_subscribe():
    global client_id, mqtt_server, topic_sub
    client = MQTTClient(client_id, mqtt_server, user=mqtt_user, password=mqtt_pass, ssl=True)
    client.set_callback(sub_cb)
    client.connect()
    client.subscribe(topic_sub)
    print(‘Connected to %s MQTT broker, subscribed to %s topic’ % (mqtt_server, topic_sub))
    return client<\/p>\n\n\n\n

    def restart_and_reconnect():
    print(‘Failed to connect to MQTT broker. Reconnecting\u2026’)
    time.sleep(10)
    machine.reset()<\/p>\n\n\n\n

    try:
    client = connect_and_subscribe()
    except OSError as e:
    restart_and_reconnect()<\/p>\n\n\n\n

    while True:
    try:
    new_message = client.wait_msg()
    client.publish(topic_pub, b’received’)
    time.sleep(1)
    except OSError as e:
    restart_and_reconnect()<\/p>\n\n\n\n

    <\/p>\n\n\n\n

    #————————————————–<\/p>\n\n\n\n

    <\/p>\n\n\n\n

    boot.py:<\/strong><\/p>\n\n\n\n

    Complete project details at https:\/\/RandomNerdTutorials.com\/micropython-programming-with-esp32-and-esp8266\/<\/h1>\n\n\n\n

    import time
    from umqttsimple import MQTTClient
    import ubinascii
    import machine
    import micropython
    import network
    import esp
    esp.osdebug(None)
    import gc
    gc.collect()<\/p>\n\n\n\n

    # ==> eigene Werte einfuegen<\/p>\n\n\n\n

    ssid = ‘ssid<\/em>‘
    password = ‘password<\/em>‘
    mqtt_server = ‘mqtt_server<\/em>‘
    mqtt_user = ‘mqtt_user<\/em>‘
    mqtt_pass = ‘mqtt_password<\/em>‘<\/p>\n\n\n\n

    EXAMPLE IP ADDRESS<\/h1>\n\n\n\n

    mqtt_server = ‘192.168.1.144’<\/h1>\n\n\n\n

    client_id = ubinascii.hexlify(machine.unique_id())
    topic_sub = b’hello’
    topic_pub = b’notification’<\/p>\n\n\n\n

    last_message = 0
    message_interval = 5
    counter = 0<\/p>\n\n\n\n

    station = network.WLAN(network.STA_IF)<\/p>\n\n\n\n

    station.active(True)
    station.connect(ssid, password)<\/p>\n\n\n\n

    while station.isconnected() == False:
    pass<\/p>\n\n\n\n

    print(‘Connection successful’)
    print(station.ifconfig())<\/p>\n\n\n\n

    #————————————————–<\/p>\n\n\n\n

    zus\u00e4tzlich Datei ‘umqttsimple.py’ und eine SSL-Library auf den ESP32 schreiben.<\/p>\n\n\n\n

    <\/p>\n\n\n\n

    2. Software- und Kalibrierungsaktualisierung<\/strong><\/p>\n\n\n\n

    Die Aktualisierung des Messprogramms bzw. von Kalibrier-
    Faktoren geschieht OTA (over the air) mit Hilfe eines GitHUB-
    Repositories (https:\/\/github.com\/proess\/ESP32_OTA<\/a>), welches die Aktualisierungen mit Hilfe von
    Versionsnummern (Software bzw. Kalibrierwerte) erm\u00f6glicht.<\/p>\n\n\n\n

    ReadMe.md: MicroPython Over-the-Air updater<\/strong><\/h1>\n\n\n\n

    This library enables you to update your MicroPython projects over the air, at start-up, or whenever you choose.<\/p>\n\n\n\n

    \n\n\n\n

    To use this code:<\/p>\n\n\n\n

      \n
    1. Add the ota.py<\/code> to your MicroPython device<\/li>\n\n\n\n
    2. Create a file named WIFI_CONFIG.py<\/code> on your MicroPython device, which contains two variables: SSID<\/code> and PASSWORD<\/code>: SSID = \"my wifi hotspot name\" PASSWORD = \"wifi password\"<\/code><\/li>\n\n\n\n
    3. Add this to your main program code: from ota import OTAUpdater from WIFI_CONFIG import SSID, PASSWORD firmware_url = \"https:\/\/raw.githubusercontent.com\/<username>\/<repo_name>\/<branch_name>\"<\/code> where <username><\/code> is your github username, <repo_name><\/code> is the name of the repository to check for updates and <branch_name><\/code> is the name of the branch to monitor.<\/li>\n\n\n\n
    4. Add this to your main program code: ota_updater = OTAUpdater(SSID, PASSWORD, firmware_url, \"test.py\") ota_updater.download_and_install_update_if_available()<\/code><\/li>\n\n\n\n
    5. On your GitHub repository, add a version.json<\/code> file, and add a version<\/code> element to the JSON file, with a version number: { \"version\":3 }<\/code><\/li>\n<\/ol>\n\n\n\n
      \n\n\n\n

      The OTA-Updater<\/code> will connect to github over wifi using your provided wifi credentials, check what the most up-to-date version of the firmware is, compare this to a local file present on the device named version.json<\/code>, which contains the version number of the current on device firmware.<\/p>\n\n\n\n

      If the local file is not present it will create one with a version number of 0<\/code>. If the Github version is newer, it will download the latest file and overwrite the file on the device with the same name, then restart the MicroPython board.<\/p>\n\n\n\n

      \n\n\n\n

      If you find this useful, please let me know on our discord server: https:\/\/www.kevsrobots.com\/discord<\/a><\/p>\n\n\n\n

      ota_test.py<\/p>\n\n\n\n

      from ota import OTAUpdater
      from WIFI_CONFIG import SSID, PASSWORD<\/p>\n\n\n\n

      firmware_url = “https:\/\/github.com\/proess\/ESP32_OTA\/blob\/main”<\/p>\n\n\n\n

      ota_updater = OTAUpdater(SSID, PASSWORD, firmware_url, “main.py”)<\/p>\n\n\n\n

      ota_updater.download_and_install_update_if_available()<\/p>\n\n\n\n

      <\/p>\n\n\n\n

      Beispiel zur Messwert\u00fcbertragung und -darstellung<\/strong><\/p>\n\n\n\n

      So k\u00f6nnte es aussehen, wenn man in Spanien einen Temperatur-Messf\u00fchler anfasst und wieder losl\u00e4sst \ud83d\ude42<\/p>\n\n\n\n

      \"\"<\/figure>\n","protected":false},"excerpt":{"rendered":"

      Wasserqualit\u00e4ts\u00fcberwacher f\u00fcr einen Pool. Dieser sollte  z.B. im Pumpenhaus untergebracht, t\u00e4glich \u00fcber WLAN Messwerte an einen WEB-Server oder per mail \u00fcbertragen. Dabei kann ein ESP32 dauerhaft stromversorgt werden und eine Verbindung zum WLAN aufrechterhalten. So k\u00f6nnte man feststellen, ob der ordentlich gewartet wird oder ob der Pool kurz vorm Umkippen ist.  Files: main.py ESP32 \u00dcberwachung […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":18,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"class_list":["post-22","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/roess.ovh\/index.php\/wp-json\/wp\/v2\/pages\/22","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/roess.ovh\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/roess.ovh\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/roess.ovh\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/roess.ovh\/index.php\/wp-json\/wp\/v2\/comments?post=22"}],"version-history":[{"count":18,"href":"https:\/\/roess.ovh\/index.php\/wp-json\/wp\/v2\/pages\/22\/revisions"}],"predecessor-version":[{"id":112,"href":"https:\/\/roess.ovh\/index.php\/wp-json\/wp\/v2\/pages\/22\/revisions\/112"}],"up":[{"embeddable":true,"href":"https:\/\/roess.ovh\/index.php\/wp-json\/wp\/v2\/pages\/18"}],"wp:attachment":[{"href":"https:\/\/roess.ovh\/index.php\/wp-json\/wp\/v2\/media?parent=22"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}