Navigation

    Logo
    • Register
    • Login
    • Search
    • Recent
    • Tags
    • Unread
    • Categories
    • Unreplied
    • Popular
    • GitHub
    • Docu
    • Hilfe
    1. Home
    2. Deutsch
    3. Off Topic
    4. Grafana
    5. Fritzbox mit Grafana visualisieren [Version 2022]

    NEWS

    • ioBroker@Smart Living Forum Solingen, 14.06. - Agenda added

    • ioBroker goes Matter ... Matter Adapter in Stable

    • Monatsrückblick - April 2025

    Fritzbox mit Grafana visualisieren [Version 2022]

    This topic has been deleted. Only users with topic management privileges can see it.
    • crunchip
      crunchip Forum Testing Most Active @iobroJB last edited by

      @iobrojb sagte in Fritzbox mit Grafana visualisieren [Version 2022]:

      Leider zeigt Grafana keine Werte an, obwohl ich die vorhandene influxdb zugewiesen habe

      Sind denn auch Daten in der Datenbank?

      Ich hatte das wie weiter oben geschrieben, per upnp Adapter laufen, der die Daten holte und die query's im Dashboard entsprechend angepasst.

      Nutze das allerdings seit rund 3 Jahren nicht mehr

      1 Reply Last reply Reply Quote 0
      • M
        Maxtor62 @Guest last edited by Maxtor62

        @dp20eic
        hi, ist ein alter Thread aber ich versuch es trotzdem.

        Ich habe jetzt schon Proxmox LXC Container mit Debian 11 + 12, Ubuntu 22.04 + 23.04 versucht das Teil ans Laufen zu bringen.
        Auch mit nem Docker auf dem Synology NAS hab ich es versucht. Was soll ich sagen? Es klappt einfach nicht. Kann das an meiner Fritte liegen. Das ist die 7590 AX. Wäre super, wenn mir jemand noch n Tipp geben könnte. Hier die Logs dazu.

        (.venv) stefan@helper:/opt/fritzinfluxdb$ ./fritzinfluxdb.py
        2023-10-31 18:15:40,918 - INFO: Starting fritzinfluxdb v1.2.1 (2023-01-26)
        2023-10-31 18:15:40,918 - INFO: Done reading config files
        2023-10-31 18:15:40,938 - INFO: Successfully parsed config
        2023-10-31 18:15:40,940 - INFO: Connection to InfluxDB 2 established
        2023-10-31 18:15:46,412 - INFO: Successfully established FritzBox TR-069 session
        2023-10-31 18:15:47,135 - INFO: Successfully established FritzBox Lua session
        2023-10-31 18:15:47,136 - INFO: Successfully connected to FritzBox '192.168.178.1' (fritz.box) Model: FRITZ!Box 7590 AX (DSL) - FW: 7.                                     57
        2023-10-31 18:15:47,136 - INFO: Starting main loop
        2023-10-31 18:15:59,125 - INFO: Service 'Cable Info (Fritz!OS 7.29 - latest)' not applicable for this FritzBox Model Link type 'DSL'
        2023-10-31 18:16:00,134 - ERROR: Unable to convert FritzBox Lua value '0-673710080' for 'ha_alert' to '<class 'int'>': invalid literal                                      for int() with base 10: '0-673710080'
        2023-10-31 18:16:00,134 - ERROR: Unable to convert FritzBox Lua value '0-1865154560' for 'ha_alert' to '<class 'int'>': invalid litera                                     l for int() with base 10: '0-1865154560'
        2023-10-31 18:16:24,525 - ERROR: Failed to write to InfluxDB '192.168.178.139': 422: failure writing points to database: partial write                                     : field type conflict: input field "ha_alert" on measurement "fritzbox" is type string, already exists as type integer dropped=2
        2023-10-31 18:16:30,738 - ERROR: Unable to convert FritzBox Lua value '0-673710080' for 'ha_alert' to '<class 'int'>': invalid literal                                      for int() with base 10: '0-673710080'
        2023-10-31 18:16:30,738 - ERROR: Unable to convert FritzBox Lua value '0-1865154560' for 'ha_alert' to '<class 'int'>': invalid litera                                     l for int() with base 10: '0-1865154560'
        2023-10-31 18:16:30,767 - ERROR: Failed to write to InfluxDB '192.168.178.139': 422: failure writing points to database: partial write                                     : field type conflict: input field "ha_alert" on measurement "fritzbox" is type string, already exists as type integer dropped=2
        2023-10-31 18:16:35,802 - ERROR: Failed to write to InfluxDB '192.168.178.139': 422: failure writing points to database: partial write                                     : field type conflict: input field "ha_alert" on measurement "fritzbox" is type string, already exists as type integer dropped=2
        2023-10-31 18:16:40,870 - ERROR: Failed to write to InfluxDB '192.168.178.139': 422: failure writing points to database: partial write                                     : field type conflict: input field "ha_alert" on measurement "fritzbox" is type string, already exists as type integer dropped=2
        2023-10-31 18:16:45,920 - ERROR: Failed to write to InfluxDB '192.168.178.139': 422: failure writing points to database: partial write                                     : field type conflict: input field "ha_alert" on measurement "fritzbox" is type string, already exists as type integer dropped=2
        2023-10-31 18:16:50,991 - ERROR: Failed to write to InfluxDB '192.168.178.139': 422: failure writing points to database: partial write                                     : field type conflict: input field "ha_alert" on measurement "fritzbox" is type string, already exists as type integer dropped=2
        2023-10-31 18:16:56,016 - ERROR: Failed to write to InfluxDB '192.168.178.139': 422: failure writing points to database: partial write                                     : field type conflict: input field "ha_alert" on measurement "fritzbox" is type string, already exists as type integer dropped=2
        2023-10-31 18:17:02,085 - ERROR: Unable to convert FritzBox Lua value '0-673710080' for 'ha_alert' to '<class 'int'>': invalid literal                                      for int() with base 10: '0-673710080'
        2023-10-31 18:17:02,085 - ERROR: Unable to convert FritzBox Lua value '0-1865154560' for 'ha_alert' to '<class 'int'>': invalid litera                                     l for int() with base 10: '0-1865154560'
        2023-10-31 18:17:03,083 - ERROR: Failed to write to InfluxDB '192.168.178.139': 422: failure writing points to database: partial write                                     : field type conflict: input field "ha_alert" on measurement "fritzbox" is type string, already exists as type integer dropped=2
        2023-10-31 18:17:08,623 - ERROR: Failed to write to InfluxDB '192.168.178.139': 422: failure writing points to database: partial write                                     : field type conflict: input field "ha_alert" on measurement "fritzbox" is type string, already exists as type integer dropped=2
        2023-10-31 18:17:14,134 - ERROR: Failed to write to InfluxDB '192.168.178.139': 422: failure writing points to database: partial write                                     : field type conflict: input field "ha_alert" on measurement "fritzbox" is type string, already exists as type integer dropped=2
        2023-10-31 18:17:19,203 - ERROR: Failed to write to InfluxDB '192.168.178.139': 422: failure writing points to database: partial write                                     : field type conflict: input field "ha_alert" on measurement "fritzbox" is type string, already exists as type integer dropped=2
        2023-10-31 18:17:24,889 - ERROR: Failed to write to InfluxDB '192.168.178.139': 422: failure writing points to database: partial write                                     : field type conflict: input field "ha_alert" on measurement "fritzbox" is type string, already exists as type integer dropped=2
        2023-10-31 18:17:30,976 - ERROR: Failed to write to InfluxDB '192.168.178.139': 422: failure writing points to database: partial write                                     : field type conflict: input field "ha_alert" on measurement "fritzbox" is type string, already exists as type integer dropped=2
        2023-10-31 18:17:33,338 - ERROR: Unable to convert FritzBox Lua value '0-673710080' for 'ha_alert' to '<class 'int'>': invalid literal                                      for int() with base 10: '0-673710080'
        2023-10-31 18:17:33,339 - ERROR: Unable to convert FritzBox Lua value '0-1865154560' for 'ha_alert' to '<class 'int'>': invalid litera                                     l for int() with base 10: '0-1865154560'
        2023-10-31 18:17:36,381 - ERROR: Failed to write to InfluxDB '192.168.178.139': 422: failure writing points to database: partial write                                     : field type conflict: input field "ha_alert" on measurement "fritzbox" is type string, already exists as type integer dropped=2
        2023-10-31 18:17:41,420 - ERROR: Failed to write to InfluxDB '192.168.178.139': 422: failure writing points to database: partial write                                     : field type conflict: input field "ha_alert" on measurement "fritzbox" is type string, already exists as type integer dropped=2
        2023-10-31 18:17:46,463 - ERROR: Failed to write to InfluxDB '192.168.178.139': 422: failure writing points to database: partial write                                     : field type conflict: input field "ha_alert" on measurement "fritzbox" is type string, already exists as type integer dropped=2
        2023-10-31 18:17:51,571 - ERROR: Failed to write to InfluxDB '192.168.178.139': 422: failure writing points to database: partial write                                     : field type conflict: input field "ha_alert" on measurement "fritzbox" is type string, already exists as type integer dropped=2
        2023-10-31 18:17:56,971 - ERROR: Failed to write to InfluxDB '192.168.178.139': 422: failure writing points to database: partial write                                     : field type conflict: input field "ha_alert" on measurement "fritzbox" is type string, already exists as type integer dropped=2
        2023-10-31 18:18:02,262 - ERROR: Failed to write to InfluxDB '192.168.178.139': 422: failure writing points to database: partial write                                     : field type conflict: input field "ha_alert" on measurement "fritzbox" is type string, already exists as type integer dropped=2
        2023-10-31 18:18:05,602 - ERROR: Unable to convert FritzBox Lua value '0-673710080' for 'ha_alert' to '<class 'int'>': invalid literal                                      for int() with base 10: '0-673710080'
        2023-10-31 18:18:05,602 - ERROR: Unable to convert FritzBox Lua value '0-1865154560' for 'ha_alert' to '<class 'int'>': invalid litera                                     l for int() with base 10: '0-1865154560'
        2023-10-31 18:18:07,437 - ERROR: Failed to write to InfluxDB '192.168.178.139': 422: failure writing points to database: partial write                                     : field type conflict: input field "ha_alert" on measurement "fritzbox" is type string, already exists as type integer dropped=2
        2023-10-31 18:18:17,150 - ERROR: Failed to write to InfluxDB '192.168.178.139': 422: failure writing points to database: partial write                                     : field type conflict: input field "ha_alert" on measurement "fritzbox" is type string, already exists as type integer dropped=2
        2023-10-31 18:18:22,474 - ERROR: Failed to write to InfluxDB '192.168.178.139': 422: failure writing points to database: partial write                                     : field type conflict: input field "ha_alert" on measurement "fritzbox" is type string, already exists as type integer dropped=2
        2023-10-31 18:18:29,000 - ERROR: Failed to write to InfluxDB '192.168.178.139': 422: failure writing points to database: partial write                                     : field type conflict: input field "ha_alert" on measurement "fritzbox" is type string, already exists as type integer dropped=2
        2023-10-31 18:18:35,006 - ERROR: Failed to write to InfluxDB '192.168.178.139': 422: failure writing points to database: partial write                                     : field type conflict: input field "ha_alert" on measurement "fritzbox" is type string, already exists as type integer dropped=2
        2023-10-31 18:18:36,383 - ERROR: Unable to convert FritzBox Lua value '0-673710080' for 'ha_alert' to '<class 'int'>': invalid literal                                      for int() with base 10: '0-673710080'
        2023-10-31 18:18:36,383 - ERROR: Unable to convert FritzBox Lua value '0-1865154560' for 'ha_alert' to '<class 'int'>': invalid litera                                     l for int() with base 10: '0-1865154560'
        2023-10-31 18:18:40,422 - ERROR: Failed to write to InfluxDB '192.168.178.139': 422: failure writing points to database: partial write                                     : field type conflict: input field "ha_alert" on measurement "fritzbox" is type string, already exists as type integer dropped=2
        2023-10-31 18:18:45,471 - ERROR: Failed to write to InfluxDB '192.168.178.139': 422: failure writing points to database: partial write                                     : field type conflict: input field "ha_alert" on measurement "fritzbox" is type string, already exists as type integer dropped=2
        2023-10-31 18:18:51,073 - ERROR: Failed to write to InfluxDB '192.168.178.139': 422: failure writing points to database: partial write                                     : field type conflict: input field "ha_alert" on measurement "fritzbox" is type string, already exists as type integer dropped=2
        2023-10-31 18:18:56,581 - ERROR: Failed to write to InfluxDB '192.168.178.139': 422: failure writing points to database: partial write                                     : field type conflict: input field "ha_alert" on measurement "fritzbox" is type string, already exists as type integer dropped=2
        ^C2023-10-31 18:19:01,953 - INFO: Received exit signal SIGINT...
        2023-10-31 18:19:01,954 - INFO: Cancelling 4 outstanding tasks
        2023-10-31 18:19:01,955 - INFO: Closed FritzBox TR-069 connection
        2023-10-31 18:19:01,955 - INFO: Closed FritzBox Lua connection
        2023-10-31 18:19:01,955 - INFO: Closed InfluxDB session
        2023-10-31 18:19:01,955 - INFO: Successfully shutdown fritzinfluxdb
        (.venv) stefan@helper:/opt/fritzinfluxdb$
        
        

        Die Datenbank wird kurz mit Daten gefüttert, die ich auch mit Grafana darstellen sehe, aber nach ca. einer Minute sind die Daten wieder weg, N/A.
        fritte.PNG

        ? 1 Reply Last reply Reply Quote 0
        • ?
          A Former User @Maxtor62 last edited by

          @maxtor62 sagte in Fritzbox mit Grafana visualisieren [Version 2022]:

          Es klappt einfach nicht.

          Moin,

          wie ist die FritzBox eingerichtet, welchen User nutzt Du zum Login?
          Die Einrichtung im LX Container hast Du nach Vorgabe wie auf der Github Seite gemacht, also auch fritzconnection und alle Python Module installiert?

          Zeig mal die fritzinfluxdb.ini aber nimm vorher den User und das Passwort raus, oder x es aus

          VG
          Bernd

          M 1 Reply Last reply Reply Quote 0
          • M
            Maxtor62 @Guest last edited by

            @dp20eic
            hi sorry für meine Ungeduld. Hab halt schon so viel probiert.
            Auf der Fritte hab ich extra ein User eingerichtet den ich dafür nehme. Hat alle Rechte.
            Die Einrichtung habe ich jedes Mal genau so wie Du oder auf Github beschrieben, gemacht.
            Fritzconnection und alle Python Module installiert.

            Hier die fritzinfluxdb.ini

            
            [influxdb]
            
            # requires a hostname or IP which points to your InfluxDB instance
            hostname = 192.168.178.139
            
            # define the port your InfluxDB instance is listening on
            port = 8086
            
            # weather TLS encryption is enabled or disabled
            #tls_enabled = false
            
            # set this to 'true' to enforces TLS certificate validation
            #verify_tls = false
            
            # set a measurement name which is used to write the data to InfluxDB
            # If this is changed from the default then it also has to be changed
            # from the default value during the Grafana dashboard installation
            measurement_name = fritzbox
            
            # The amount of days the data should be stored in InfluxDB.
            # Older data will be deleted.
            # Attention: THIS IS ONLY CONFIGURED ON NEW DB/BUCKET CREATION!
            data_retention_days = 365
            
            # define which InfluxDB version you are using
            version = 2
            
            ##### InfluxDB version 1.x options
            
            # username and password to use to write data to InfluxDB
            username =
            password =
            
            # defines the InfluxDB database to write the data to
            # if the credentials permit to create databases then this
            # will be created automatically
            database =
            
            
            ##### InfluxDB version 2.x options
            
            # requires an InfluxDB API token with permissions to write to the desired bucket
            token = RRoG5NJBBUqnql1OKaHuxo3d2xqz0YpA-2AOO-fviu1Ft5mpafJizebVkpiQdGxwdtQvDv3AUJvXWLMreSQ1NA==
            
            # a valid InfluxDB organisation needs to be defined which is used during login
            organisation = home
            
            # defines the InfluxDB bucket to write the data to
            # if the credentials permit to create buckets then this
            # will be created automatically
            bucket = fritzbox
            
            
            ###
            ### [fritzbox]
            ###
            ### Controls the parameters for connecting to your InfluxDB instance.
            ###
            
            [fritzbox]
            # changes the default FritzBox IP
            hostname = 192.168.178.1
            
            # username and password to connect to the FritzBox
            username = XXXX
            password = XXXX
            
            # Define the port the FritzBox is listening on
            # change to 49443 if you use ssl
            port = 49000
            
            # weather TLS encryption is enabled or disabled (will set port to 49443 if port is undefined)
            #tls_enabled = false
            
            # set this to 'true' to enforces TLS certificate validation (only affects Lua sessions)
            #verify_tls = false
            
            # defines the InfluxDB measurement tag which is used
            # to tag data from this FritzBox
            #box_tag = fritz.box
            
            # Define the FritzBox time zone. Used to convert dates/times from FritzBox to correct UTC Timestamp
            timezone = Europe/Berlin
            
            # the maximum of time in seconds which a connection to the FritzBox is allowed to take
            connect_timeout = 30
            
            # interval to request data from FritzBox in seconds
            # the value CAN'T be lower then 10 seconds
            request_interval = 30
            
            
            # EOF
            
            

            Danke und Grüße

            ? 1 Reply Last reply Reply Quote 0
            • ?
              A Former User @Maxtor62 last edited by

              @maxtor62 sagte in Fritzbox mit Grafana visualisieren [Version 2022]:

              Hier die fritzinfluxdb.ini

              Moin,

              also da sehe ich erst einmal keine Klinke.
              Ich habe mal nach dem im Log aufgeführten Fehler ha_alert im Source auf Github gesucht, das kommt wohl aus dem Bereich homeauto.py, jetzt kann ich damit aber auch nicht mehr anfangen, ob das jetzt an der FritzBox liegt, oder ob die Version 7.57 da für die AX eine Macke hat oder ob Du da vielleicht Geräte in Samrt Home eingerichtet hast und deswegen der Fehler kommt.

              Warte einfach mal ab, was bb-Ricardo zu dem Fehler sagt.

              VG
              Bernd

              M 1 Reply Last reply Reply Quote 0
              • M
                Maxtor62 @Guest last edited by

                @dp20eic
                ok, danke für Deine Mühe. Im SmatHome hab ich nur Fritz Geräte über DECT eingerichtet, außer die drei Rollladen Motoren. Die sind von BoxControl, was auch über DECT läuft. Da sollte die Fritte ja kein Problem haben.
                Ich werde mich in Geduld üben.

                Grüße
                Stefan

                ? 1 Reply Last reply Reply Quote 0
                • ?
                  A Former User @Maxtor62 last edited by

                  @maxtor62 sagte in Fritzbox mit Grafana visualisieren [Version 2022]:

                  ok, danke für Deine Mühe. Im SmatHome hab ich nur Fritz Geräte über DECT eingerichtet, außer die drei Rollladen Motoren. Die sind von BoxControl, was auch über DECT läuft. Da sollte die Fritte ja kein Problem haben.

                  Moin,

                  na dann kann es ja doch sein, dass da etwas nicht korrekt eingerichtet oder installiert ist. Du solltest mal gleich dein issuse auf Github mit allen Informationen erweitern, damit bb-Ricardo nicht erst noch nachfragen muss, verzögert dann ja nur zusätzlich.

                  VG
                  Bernd

                  M 1 Reply Last reply Reply Quote 0
                  • M
                    Maxtor62 @Guest last edited by

                    @dp20eic

                    es ist unglaublich.

                    FritzBox boot tut gut.

                    Jetzt funktioniert alles.
                    fritte.PNG

                    Danke Dir noch mal.

                    Grüße
                    Stefan

                    ? 1 Reply Last reply Reply Quote 0
                    • ?
                      A Former User @Maxtor62 last edited by

                      @maxtor62 sagte in Fritzbox mit Grafana visualisieren [Version 2022]:

                      Danke Dir noch mal.

                      Moin,

                      bidde schön, ist aber nicht meine Verdienst, Du kannst Dich bei bb-Ricardo bedanken.

                      Und ja, mach mal, tut ein Boot gut 🙂

                      VG
                      Bernd

                      1 Reply Last reply Reply Quote 0
                      • M
                        michihorn @crunchip last edited by

                        @crunchip Hallo hab mal mitgelesen, bei der Anleitung die Du empfohlen hast, scheitere ich schon bei sudo pip install fritzcollectd mit folgender Meldung:

                        
                        error: externally-managed-environment
                        
                        × This environment is externally managed
                        ╰─> To install Python packages system-wide, try apt install
                            python3-xyz, where xyz is the package you are trying to
                            install.
                        
                            If you wish to install a non-Debian-packaged Python package,
                            create a virtual environment using python3 -m venv path/to/venv.
                            Then use path/to/venv/bin/python and path/to/venv/bin/pip. Make
                            sure you have python3-full installed.
                        
                            For more information visit http://rptl.io/venv
                        
                        note: If you believe this is a mistake, please contact your Python installation or OS distribution provider. You can override this, at the risk of breaking your Python installation or OS, by passing --break-system-packages.
                        hint: See PEP 668 for the detailed specification.
                        
                        

                        Hast du ne Ahnung was ich tun muss?
                        Michael

                        crunchip 1 Reply Last reply Reply Quote 0
                        • crunchip
                          crunchip Forum Testing Most Active @michihorn last edited by

                          @michihorn hast du das befolgt?
                          https://forum.iobroker.net/post/793557

                          M 1 Reply Last reply Reply Quote 0
                          • M
                            michihorn @crunchip last edited by michihorn

                            @crunchip Ja habe ich, selbst mit "neu" aufgesetzter Maschine klappt es nicht
                            habe es jetzt mal so versucht:

                            pip install fritzcollectd --break-system-packages
                            

                            Ist durch gelaufen, brachte am Ende aber folgende Meldung:

                            
                              note: This error originates from a subprocess, and is likely not a problem with pip.
                            error: legacy-install-failure
                            
                            × Encountered error while trying to install package.
                            ╰─> lxml
                            
                            note: This is an issue with the package mentioned above, not pip.
                            hint: See above for output from the failure.
                            
                            

                            EDIT: So hat es geklappt:
                            Quelle
                            pip3.png

                            Eine TOP Anleitung zur Installation der Fritzbox Visualisierung findet man unter:
                            Anleitung

                            Keine Panik die Anleitung trägt den Titel "Fritz!Box Monitoring mit Raspberry Pi Zero W" funktioniert aber auch top bei neueren Versionen. Kleiner Tip, sollte mal die Installation von collectd schiefgehen, kann die Installation komplett mit "sudo apt-get purge --auto-remove collectd" gelöscht werden.

                            crunchip 1 Reply Last reply Reply Quote 0
                            • crunchip
                              crunchip Forum Testing Most Active @michihorn last edited by

                              @michihorn kann dir da aktuell nicht weiterhelfen, hab das schon lange nicht mehr laufen.

                              1 Reply Last reply Reply Quote 0
                              • First post
                                Last post

                              Support us

                              ioBroker
                              Community Adapters
                              Donate

                              539
                              Online

                              31.7k
                              Users

                              79.7k
                              Topics

                              1.3m
                              Posts

                              11
                              143
                              13356
                              Loading More Posts
                              • Oldest to Newest
                              • Newest to Oldest
                              • Most Votes
                              Reply
                              • Reply as topic
                              Log in to reply
                              Community
                              Impressum | Datenschutz-Bestimmungen | Nutzungsbedingungen
                              The ioBroker Community 2014-2023
                              logo