Navigation

    Logo
    • Register
    • Login
    • Search
    • Recent
    • Tags
    • Unread
    • Categories
    • Unreplied
    • Popular
    • GitHub
    • Docu
    • Hilfe
    1. Home
    2. Deutsch
    3. Error/Bug
    4. "Verbunden mit influxdb" Falsch -> Keine Werte in Datenbank

    NEWS

    • Neuer Blog: Fotos und Eindrücke aus Solingen

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

    • ioBroker goes Matter ... Matter Adapter in Stable

    "Verbunden mit influxdb" Falsch -> Keine Werte in Datenbank

    This topic has been deleted. Only users with topic management privileges can see it.
    • Homoran
      Homoran Global Moderator Administrators last edited by

      Hallo Ingo,

      Auf meinem Pine64 bleibt das ja auch gelb! Du erinnerst dich?

      Läuft trotzdem gut.

      Gruß

      Rainer

      1 Reply Last reply Reply Quote 0
      • apollon77
        apollon77 last edited by

        Ich kapiere es nur nicht 😞

        Admin und js-controller sind aktuell?

        Was steht denn im "connected" Datenpunkt vom Adapter/Instanz?

        1 Reply Last reply Reply Quote 0
        • E
          eastcoast last edited by

          @apollon77:

          Admin und js-controller sind aktuell? `
          ioBroker Admin: 1.6.11

          js-controller: 0.15.3
          @apollon77:

          Was steht denn im "connected" Datenpunkt vom Adapter/Instanz? `
          Nichts…!? Siehe Bild
          1408_clipboard01.jpg

          1 Reply Last reply Reply Quote 0
          • apollon77
            apollon77 last edited by

            Ich blick es genauso wenig wie bei Homoran … Bitte update vom Github. Jetzt gibts error-logging wenn "connected" nicht aktualisiert werden kann. Mal schauen ob das mehr Infos bringt.

            1 Reply Last reply Reply Quote 0
            • E
              eastcoast last edited by

              @apollon77:

              Ich blick es genauso wenig wie bei Homoran … Bitte update vom Github. Jetzt gibts error-logging wenn "connected" nicht aktualisiert werden kann. Mal schauen ob das mehr Infos bringt. `
              Hallo,

              installiert via console mit "npm install https://github.com/ioBroker/ioBroker.influxdb.git" und hier der Log:

              influxdb.0	2017-03-06 18:53:13.083	debug	influxdb.0 Datatype javascript.0.froniusSymo.meter.PowerReal_P_Sum: Currently: number, StorageType: false
              influxdb.0	2017-03-06 18:53:13.083	debug	influxdb.0 Datatype javascript.0.froniusSymo.inverter.DAY_ENERGY: Currently: number, StorageType: false
              influxdb.0	2017-03-06 18:53:13.074	debug	influxdb.0 Datatype javascript.0.froniusSymo.inverter.PAC: Currently: number, StorageType: false
              influxdb.0	2017-03-06 18:53:03.064	debug	inMem message javascript.0.froniusSymo.meter.PowerReal_P_Sum javascript.0.froniusSymo.meter.PowerReal_P_Sum
              influxdb.0	2017-03-06 18:53:03.056	debug	inMem message javascript.0.froniusSymo.inverter.DAY_ENERGY javascript.0.froniusSymo.inverter.DAY_ENERGY
              influxdb.0	2017-03-06 18:53:03.021	debug	inMem message javascript.0.froniusSymo.inverter.PAC javascript.0.froniusSymo.inverter.PAC
              influxdb.0	2017-03-06 18:52:34.215	info	enabled logging of javascript.0.froniusSymo.history.energyProdDay, 6 points now activated
              influxdb.0	2017-03-06 18:52:34.215	info	enabled logging of javascript.0.froniusSymo.history.energyRetDay, 5 points now activated
              influxdb.0	2017-03-06 18:52:34.214	info	enabled logging of javascript.0.froniusSymo.history.energyConsDay, 4 points now activated
              influxdb.0	2017-03-06 18:52:34.214	info	enabled logging of javascript.0.froniusSymo.meter.PowerReal_P_Sum, 3 points now activated
              influxdb.0	2017-03-06 18:52:34.213	info	enabled logging of javascript.0.froniusSymo.inverter.DAY_ENERGY, 2 points now activated
              influxdb.0	2017-03-06 18:52:34.209	info	enabled logging of javascript.0.froniusSymo.inverter.PAC, 1 points now activated
              influxdb.0	2017-03-06 18:52:34.175	info	Connected!
              influxdb.0	2017-03-06 18:52:34.025	info	Connecting http://localhost:8086 ...
              influxdb.0	2017-03-06 18:52:34.021	info	Buffer initialized with data for 0 points and 0 conflicts from last exit
              influxdb.0	2017-03-06 18:52:34.014	info	starting. Version 1.4.0 in /opt/iobroker/node_modules/iobroker.influxdb, node: v4.8.0
              influxdb.0	2017-03-06 18:52:33.969	debug	statesDB connected
              influxdb.0	2017-03-06 18:52:33.889	debug	objectDB connected
              host.xxxx-iobroker	2017-03-06 18:52:32.034	info	instance system.adapter.influxdb.0 started with pid 13381
              
              
              1 Reply Last reply Reply Quote 0
              • apollon77
                apollon77 last edited by

                Kooooomisch …

                Bitte nochmal und "iobroker upload influxdb" nicht vergessen!! Habe jetzt auch Success-Logging eingebaut 🙂

                1 Reply Last reply Reply Quote 0
                • Homoran
                  Homoran Global Moderator Administrators last edited by

                  der fast erste Satz ist "connected"

                  dann finde ich nur noch Datenaktualisierungen und sonst nichts.

                  Unter Objekte nach wie vor keine Angabe ob connected = true oder false

                  Gibt es etwas wonach man das log filtern kann?

                  Gruß

                  Rainer

                  1 Reply Last reply Reply Quote 0
                  • apollon77
                    apollon77 last edited by

                    also basierend auf "debug"-level hatte ich das eingebaut

                    adapter.log.debug('connected set to ' + connected);

                    also es sollte etwas kommen wie "connected set to true". Aber halt als Debug.

                    https://github.com/ioBroker/ioBroker.in … in.js#L123

                    Kannst es lokal auch einfach in info ändern oder so

                    1 Reply Last reply Reply Quote 0
                    • apollon77
                      apollon77 last edited by

                      Kann das nochmal einer machen/checken bitte?!

                      1 Reply Last reply Reply Quote 0
                      • Homoran
                        Homoran Global Moderator Administrators last edited by

                        @apollon77:

                        Kann das nochmal einer machen/checken bitte?! `
                        Was willst du sehen?

                        Mein log von heute ist inzwischen 188MB groß, da muss ich schon wissen wonach ich suchen kann.

                        Habe nochmal aus dem git upgedated und upgeloaded 😉

                        Auf Anhieb finde ich jetzt:

                        `2017-03-07 18:02:59.020  - [32minfo[39m: host.ioBroker_Pine64 object change system.adapter.influxdb.0
                        2017-03-07 18:02:59.022  - [32minfo[39m: host.ioBroker_Pine64 "system.adapter.influxdb.0" enabled
                        2017-03-07 18:02:59.022  - [32minfo[39m: host.ioBroker_Pine64 stopInstance system.adapter.influxdb.0
                        2017-03-07 18:02:59.023  - [32minfo[39m: host.ioBroker_Pine64 stopInstance system.adapter.influxdb.0 killing pid 1350
                        2017-03-07 18:02:59.219  - [33mwarn[39m: host.ioBroker_Pine64 instance system.adapter.influxdb.0 terminated due to SIGTERM
                        2017-03-07 18:02:59.220  - [32minfo[39m: host.ioBroker_Pine64 instance system.adapter.influxdb.0 terminated with code null ()
                        2017-03-07 18:03:01.558  - [32minfo[39m: host.ioBroker_Pine64 instance system.adapter.influxdb.0 started with pid 1392
                        2017-03-07 18:03:02.597  - [32minfo[39m: host.ioBroker_Pine64 instance system.adapter.rflink.0 started with pid 1398
                        2017-03-07 18:03:04.024  - [32minfo[39m: solarwetter.0 force terminating adapter after 1 minute
                        2017-03-07 18:03:04.593  - [32minfo[39m: host.ioBroker_Pine64 instance system.adapter.solarwetter.0 terminated with code 0 (OK)
                        2017-03-07 18:03:05.741  - [32minfo[39m: host. States connected to redis 127.0.0.1:6379
                        2017-03-07 18:03:05.860  - [32minfo[39m: rflink.0 starting. Version 1.0.8 in /opt/iobroker/node_modules/iobroker.rflink, node: v4.6.1
                        2017-03-07 18:03:05.830  - [34mdebug[39m: influxdb.0 objectDB connected
                        2017-03-07 18:03:05.917  - [34mdebug[39m: influxdb.0 statesDB connected
                        2017-03-07 18:03:05.948  - [32minfo[39m: host. States connected to redis 127.0.0.1:6379
                        2017-03-07 18:03:05.983  - [34mdebug[39m: host. redis get system.adapter.influxdb.0.alive ok: {"val":false,"ack":true,"ts":1488906179221,"q":0,"from":"system.host.ioBroker_Pine64","lc":1488906179221}
                        2017-03-07 18:03:06.079  - [32minfo[39m: influxdb.0 starting. Version 1.4.0 in /opt/iobroker/node_modules/iobroker.influxdb, node: v4.6.1
                        2017-03-07 18:03:06.086  - [32minfo[39m: vis.0 400 files uploaded...
                        2017-03-07 18:03:06.191  - [32minfo[39m: rflink.0 Serial port opened
                        2017-03-07 18:03:06.116  - [32minfo[39m: influxdb.0 No stored data from last exit found
                        2017-03-07 18:03:06.126  - [32minfo[39m: influxdb.0 Connecting http://localhost:8086 ...
                        2017-03-07 18:03:06.202  - [34mdebug[39m: host. redis psubscribe io.influxdb.0.checkLogging
                        2017-03-07 18:03:06.241  - [34mdebug[39m: host. redis keys 1 *.logging[/code]`
                        
                        Die Ampel ist gelb, unter influxdb.0.info.connection steht immer noch nichts
                        
                        EDIT:
                        
                        das noch gefunden:
                        `~~[code]~~2017-03-07 17:59:43.956  - [32minfo[39m: iobroker got /opt/iobroker/node_modules/iobroker.influxdb/admin
                        2017-03-07 17:59:43.986  - [32minfo[39m: iobroker upload [2] influxdb.admin /opt/iobroker/node_modules/iobroker.influxdb/admin/influxdb.png influxdb.png image/png
                        2017-03-07 17:59:44.124  - [32minfo[39m: iobroker upload [1] influxdb.admin /opt/iobroker/node_modules/iobroker.influxdb/admin/index.html index.html text/html
                        2017-03-07 17:59:44.224  - [32minfo[39m: iobroker upload [0] influxdb.admin /opt/iobroker/node_modules/iobroker.influxdb/admin/custom.html custom.html text/html
                        2017-03-07 17:59:44.305  - [34mdebug[39m: host. redis pmessage  io.* io.system.adapter.influxdb.upload {"val":0,"ack":false,"ts":1488905984302,"q":0,"lc":1480363337473}
                        2017-03-07 17:59:44.412  - [32minfo[39m: host.ioBroker_Pine64 object change system.adapter.influxdb.0
                        2017-03-07 17:59:44.439  - [33mwarn[39m: influxdb.0 Store data for 0 points and 0 conflicts
                        2017-03-07 17:59:44.444  - [34mdebug[39m: host. redis publish io.system.adapter.influxdb.0.alive {"val":false,"ack":true,"ts":1488905984444,"q":0,"from":"system.adapter.influxdb.0","lc":1488905984444}
                        2017-03-07 17:59:44.413  - [32minfo[39m: host.ioBroker_Pine64 "system.adapter.influxdb.0" disabled
                        2017-03-07 17:59:44.416  - [32minfo[39m: host.ioBroker_Pine64 stopInstance system.adapter.influxdb.0
                        2017-03-07 17:59:44.417  - [32minfo[39m: host.ioBroker_Pine64 stopInstance system.adapter.influxdb.0 killing pid 12189
                        2017-03-07 17:59:44.456  - [32minfo[39m: influxdb.0 terminating
                        2017-03-07 17:59:44.492  - [32minfo[39m: host.ioBroker_Pine64 object change system.adapter.influxdb.0
                        2017-03-07 17:59:44.494  - [32minfo[39m: host.ioBroker_Pine64 "system.adapter.influxdb.0" enabled
                        2017-03-07 17:59:44.539  - [32minfo[39m: host.ioBroker_Pine64 instance system.adapter.influxdb.0 started with pid 23258
                        2017-03-07 17:59:44.602  - [32minfo[39m: host.ioBroker_Pine64 instance system.adapter.influxdb.0 terminated with code 0 (OK)
                        2017-03-07 17:59:44.623  - [32minfo[39m: iobroker Adapter "system.adapter.influxdb.0" restarted.
                        2017-03-07 17:59:44.643  - [32minfo[39m: iobroker exit 0
                        2017-03-07 17:59:45.061  - [32minfo[39m: host.ioBroker_Pine64 Update repository "default" under "http://download.iobroker.net/sources-dist.json"
                        2017-03-07 17:59:47.801  - [34mdebug[39m: influxdb.0 objectDB connected
                        2017-03-07 17:59:47.867  - [34mdebug[39m: influxdb.0 statesDB connected
                        2017-03-07 17:59:47.882  - [32minfo[39m: host. States connected to redis 127.0.0.1:6379
                        2017-03-07 17:59:47.906  - [34mdebug[39m: host. redis get system.adapter.influxdb.0.alive ok: {"val":false,"ack":true,"ts":1488905984628,"q":0,"from":"system.host.ioBroker_Pine64","lc":1488905984444}
                        2017-03-07 17:59:47.966  - [32minfo[39m: influxdb.0 starting. Version 1.4.0 in /opt/iobroker/node_modules/iobroker.influxdb, node: v4.6.1
                        2017-03-07 17:59:47.982  - [32minfo[39m: influxdb.0 Buffer initialized with data for 0 points and 0 conflicts from last exit
                        2017-03-07 17:59:47.989  - [32minfo[39m: influxdb.0 Connecting http://localhost:8086 ...
                        2017-03-07 17:59:48.034  - [34mdebug[39m: host. redis psubscribe io.influxdb.0.checkLogging
                        2017-03-07 17:59:48.062  - [34mdebug[39m: host. redis keys 1 *.logging
                        2017-03-07 17:59:48.066  - [34mdebug[39m: host. redis publish io.system.adapter.influxdb.0.alive {"val":true,"ack":true,"ts":1488905988066,"q":0,"from":"system.adapter.influxdb.0","lc":1488905988066}
                        2017-03-07 17:59:48.072  - [34mdebug[39m: host. redis publish io.system.adapter.influxdb.0.connected {"val":true,"ack":true,"ts":1488905988068,"q":0,"from":"system.adapter.influxdb.0","lc":1488905988068}
                        2017-03-07 17:59:48.075  - [34mdebug[39m: host. redis publish io.system.adapter.influxdb.0.memRss {"val":41.66,"ack":true,"ts":1488905988074,"q":0,"from":"system.adapter.influxdb.0","lc":1488905988074}
                        2017-03-07 17:59:48.079  - [34mdebug[39m: host. redis publish io.system.adapter.influxdb.0.memHeapTotal {"val":36.73,"ack":true,"ts":1488905988078,"q":0,"from":"system.adapter.influxdb.0","lc":1488905988078}
                        2017-03-07 17:59:48.083  - [34mdebug[39m: host. redis publish io.system.adapter.influxdb.0.memHeapUsed {"val":25.55,"ack":true,"ts":1488905988082,"q":0,"from":"system.adapter.influxdb.0","lc":1488905988082}
                        2017-03-07 17:59:48.088  - [34mdebug[39m: host. redis publish io.system.adapter.influxdb.0.uptime {"val":3,"ack":true,"ts":1488905988087,"q":0,"from":"system.adapter.influxdb.0","lc":1488905988087}
                        2017-03-07 17:59:48.093  - [34mdebug[39m: host. redis publish io.influxdb.0.info.connected {"val":false,"ack":true,"ts":1488905988093,"q":0,"from":"system.adapter.influxdb.0","lc":1488905988093}
                        2017-03-07 17:59:48.108  - [34mdebug[39m: host. redis mget 1 1
                        2017-03-07 17:59:48.113  - [34mdebug[39m: influxdb.0 connected set to false
                        2017-03-07 17:59:48.171  - [32minfo[39m: influxdb.0 Connected!
                        2017-03-07 17:59:48.172  - [34mdebug[39m: host. redis publish io.influxdb.0.info.connected {"val":true,"ack":true,"ts":1488905988172,"q":0,"from":"system.adapter.influxdb.0","lc":1488905988172}
                        2017-03-07 17:59:48.178  - [34mdebug[39m: influxdb.0 connected set to true[/code]`
                        
                        Gruß
                        
                        Rainer[/code]
                        
                        1 Reply Last reply Reply Quote 0
                        • E
                          eastcoast last edited by

                          @apollon77:

                          Kann das nochmal einer machen/checken bitte?! `
                          Hallo,

                          habe gerade nochmal von github aktualisiert…

                          Status ist noch gelb, Objekt influxdb.0.info.connection hat keinen Wert, hier der Log:

                          influxdb.0	2017-03-07 18:42:12.333	debug	influxdb.0 Datatype javascript.0.froniusSymo.meter.PowerReal_P_Sum: Currently: number, StorageType: false
                          influxdb.0	2017-03-07 18:42:12.274	debug	influxdb.0 Datatype javascript.0.froniusSymo.inverter.DAY_ENERGY: Currently: number, StorageType: false
                          influxdb.0	2017-03-07 18:42:12.271	debug	influxdb.0 Datatype javascript.0.froniusSymo.inverter.PAC: Currently: number, StorageType: false
                          influxdb.0	2017-03-07 18:42:02.329	debug	inMem message javascript.0.froniusSymo.meter.PowerReal_P_Sum javascript.0.froniusSymo.meter.PowerReal_P_Sum
                          influxdb.0	2017-03-07 18:42:02.250	debug	inMem message javascript.0.froniusSymo.inverter.DAY_ENERGY javascript.0.froniusSymo.inverter.DAY_ENERGY
                          influxdb.0	2017-03-07 18:42:02.243	debug	inMem message javascript.0.froniusSymo.inverter.PAC javascript.0.froniusSymo.inverter.PAC
                          influxdb.0	2017-03-07 18:41:04.279	info	enabled logging of javascript.0.froniusSymo.history.energyProdDay, 6 points now activated
                          influxdb.0	2017-03-07 18:41:04.279	info	enabled logging of javascript.0.froniusSymo.history.energyRetDay, 5 points now activated
                          influxdb.0	2017-03-07 18:41:04.279	info	enabled logging of javascript.0.froniusSymo.history.energyConsDay, 4 points now activated
                          influxdb.0	2017-03-07 18:41:04.279	info	enabled logging of javascript.0.froniusSymo.meter.PowerReal_P_Sum, 3 points now activated
                          influxdb.0	2017-03-07 18:41:04.278	info	enabled logging of javascript.0.froniusSymo.inverter.DAY_ENERGY, 2 points now activated
                          influxdb.0	2017-03-07 18:41:04.278	info	enabled logging of javascript.0.froniusSymo.inverter.PAC, 1 points now activated
                          influxdb.0	2017-03-07 18:41:04.266	debug	connected set to true
                          influxdb.0	2017-03-07 18:41:04.257	info	Connected!
                          influxdb.0	2017-03-07 18:41:04.160	debug	connected set to false
                          influxdb.0	2017-03-07 18:41:04.071	info	Connecting http://localhost:8086 ...
                          influxdb.0	2017-03-07 18:41:04.069	info	Buffer initialized with data for 0 points and 0 conflicts from last exit
                          influxdb.0	2017-03-07 18:41:04.065	info	starting. Version 1.4.0 in /opt/iobroker/node_modules/iobroker.influxdb, node: v4.8.0
                          influxdb.0	2017-03-07 18:41:04.015	debug	statesDB connected
                          influxdb.0	2017-03-07 18:41:03.952	debug	objectDB connected
                          
                          
                          1 Reply Last reply Reply Quote 0
                          • apollon77
                            apollon77 last edited by

                            ` > 2017-03-07 17:59:48.171 - [32minfo[39m: influxdb.0 Connected!

                            2017-03-07 17:59:48.172 - [34mdebug[39m: host. redis publish io.influxdb.0.info.connected {"val":true,"ack":true,"ts":1488905988172,"q":0,"from":"system.adapter.influxdb.0","lc":1488905988172}

                            2017-03-07 17:59:48.178 - [34mdebug[39m: influxdb.0 connected set to true `

                            Also das hier sagt (und das andere Log ist bis auf die redis-Debug-Logs identisch) hier eindeutig das das setzen des Wertes klappt…

                            Also die Frage ist damit für mich eher: Warum wird es im Admin nicht angezeigt ...? Kann es sein das Ihr irgendwie in die "Anzahl der Meldungten und daher "Unsubscribe im Admin" reingerannt seid?

                            @Homoran: Schalt dorhc für den Datenpunkt mal History ein und schaue nach ein paa ein/aus-Sachen (also Adapte restarts oder so) was History sagt 🙂

                            Und kannst Debug wieder ausschalten. `

                            1 Reply Last reply Reply Quote 0
                            • E
                              eastcoast last edited by

                              @apollon77:

                              Also die Frage ist damit für mich eher: Warum wird es im Admin nicht angezeigt …? Kann es sein das Ihr irgendwie in die "Anzahl der Meldungten und daher "Unsubscribe im Admin" reingerannt seid? `
                              Keine Ahnung wie ich einen "Unsubscribe im Admin" feststellen kann,

                              aber die Anzahl neuer Meldungen im Log ist Minimal…
                              @apollon77:

                              @Homoran: Schalt dorhc für den Datenpunkt mal History ein und schaue nach ein paa ein/aus-Sachen (also Adapte restarts oder so) was History sagt 🙂 `
                              Ich hab das mal gemacht, aber es gibt einfach keine Werte…

                              in der Historie Tabelle steht dann nur "No data", hier der Log von History (SQL)

                              sql.0	2017-03-10 14:43:05.709	info	No Data
                              sql.0	2017-03-10 14:43:05.709	warn	Cannot get index of "influxdb.0.info.connection": id not found
                              
                              

                              Bin mitlerweile auf

                              js-controller 0.16.2

                              admin 1.7.0

                              …damit hat sich nichts geändert.

                              1 Reply Last reply Reply Quote 0
                              • apollon77
                                apollon77 last edited by

                                So, ich habs … wer lesen kann ist arg im Vorteil ...

                                connected != connection ... Der Adapter hat schlicht den Status in den falschen State geschrieben und ich habs nicht gesehn :-((

                                Bitte version von Github versuchen. Passts damit?

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

                                Support us

                                ioBroker
                                Community Adapters
                                Donate

                                818
                                Online

                                31.8k
                                Users

                                80.0k
                                Topics

                                1.3m
                                Posts

                                4
                                22
                                5748
                                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