Navigation

    Logo
    • Register
    • Login
    • Search
    • Recent
    • Tags
    • Unread
    • Categories
    • Unreplied
    • Popular
    • GitHub
    • Docu
    • Hilfe
    1. Home
    2. Deutsch
    3. Error/Bug
    4. iobroker: Could not connect database (invalid protocol)

    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

    UNSOLVED iobroker: Could not connect database (invalid protocol)

    This topic has been deleted. Only users with topic management privileges can see it.
    • Thomas Braun
      Thomas Braun Most Active @_Matze_ last edited by Thomas Braun

      @_Matze_

      iobroker stop
      iobroker fix
      

      Oh, hattest du ja schon....

      sudo netstat -tulpen
      
      iobroker list adapters
      iobroker list instances
      
      _ 1 Reply Last reply Reply Quote 0
      • _
        _Matze_ @Thomas Braun last edited by _Matze_

        @Thomas-Braun

        sudo netstat -tulpen
        
        Proto Recv-Q Send-Q Local Address           Foreign Address         State       Benutzer   Inode      PID/Program name    
        tcp        0      0 0.0.0.0:25              0.0.0.0:*               LISTEN      0          30531      1678/master         
        tcp        0      0 127.0.0.1:1338          0.0.0.0:*               LISTEN      0          38409      2905/containerd     
        tcp        0      0 0.0.0.0:445             0.0.0.0:*               LISTEN      0          27596      1275/smbd           
        tcp        0      0 0.0.0.0:20000           0.0.0.0:*               LISTEN      0          27150      1276/perl           
        tcp        0      0 127.0.0.1:45639         0.0.0.0:*               LISTEN      0          38410      2905/containerd     
        tcp        0      0 127.0.0.1:10248         0.0.0.0:*               LISTEN      0          1367431    33270/kubelet       
        tcp        0      0 0.0.0.0:25000           0.0.0.0:*               LISTEN      0          36920      1311/python3        
        tcp        0      0 127.0.0.1:10249         0.0.0.0:*               LISTEN      0          41435      3280/kube-proxy     
        tcp        0      0 127.0.0.1:3306          0.0.0.0:*               LISTEN      107        29383      1245/mysqld         
        tcp        0      0 127.0.0.1:10251         0.0.0.0:*               LISTEN      0          36958      758/kube-scheduler  
        tcp        0      0 0.0.0.0:139             0.0.0.0:*               LISTEN      0          27597      1275/smbd           
        tcp        0      0 10.168.1.26:6379        0.0.0.0:*               LISTEN      124        26195      888/redis-server 12 
        tcp        0      0 127.0.0.1:6379          0.0.0.0:*               LISTEN      124        26194      888/redis-server 12 
        tcp        0      0 127.0.0.1:2380          0.0.0.0:*               LISTEN      0          37327      2899/etcd           
        tcp        0      0 127.0.0.1:10252         0.0.0.0:*               LISTEN      0          37913      777/kube-controller 
        tcp        0      0 0.0.0.0:111             0.0.0.0:*               LISTEN      0          1307275    11313/rpcbind       
        tcp        0      0 127.0.0.1:10256         0.0.0.0:*               LISTEN      0          41433      3280/kube-proxy     
        tcp        0      0 0.0.0.0:10000           0.0.0.0:*               LISTEN      0          32131      2064/perl           
        tcp        0      0 127.0.0.53:53           0.0.0.0:*               LISTEN      101        21728      502/systemd-resolve 
        tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN      0          28135      849/sshd            
        tcp6       0      0 :::25                   :::*                    LISTEN      0          30532      1678/master         
        tcp6       0      0 :::16443                :::*                    LISTEN      0          41051      3272/kube-apiserver 
        tcp6       0      0 :::12379                :::*                    LISTEN      0          37331      2899/etcd           
        tcp6       0      0 :::443                  :::*                    LISTEN      0          29310      1519/apache2        
        tcp6       0      0 :::445                  :::*                    LISTEN      0          27594      1275/smbd           
        tcp6       0      0 :::9000                 :::*                    LISTEN      0          24180      703/webhook         
        tcp6       0      0 :::10250                :::*                    LISTEN      0          1367428    33270/kubelet       
        tcp6       0      0 :::139                  :::*                    LISTEN      0          27595      1275/smbd           
        tcp6       0      0 :::10255                :::*                    LISTEN      0          1365742    33270/kubelet       
        tcp6       0      0 :::111                  :::*                    LISTEN      0          1307278    11313/rpcbind       
        tcp6       0      0 :::10000                :::*                    LISTEN      0          32132      2064/perl           
        tcp6       0      0 :::80                   :::*                    LISTEN      0          29306      1519/apache2        
        tcp6       0      0 :::10257                :::*                    LISTEN      0          37917      777/kube-controller 
        tcp6       0      0 :::10259                :::*                    LISTEN      0          36962      758/kube-scheduler  
        tcp6       0      0 :::21                   :::*                    LISTEN      108        30454      1524/proftpd: (acce 
        tcp6       0      0 :::22                   :::*                    LISTEN      0          26823      849/sshd            
        udp        0      0 0.0.0.0:889             0.0.0.0:*                           0          1307274    11313/rpcbind       
        udp        0      0 0.0.0.0:50174           0.0.0.0:*                           109        22111      584/avahi-daemon: r 
        udp        0      0 0.0.0.0:5353            0.0.0.0:*                           109        22109      584/avahi-daemon: r 
        udp        0      0 0.0.0.0:20000           0.0.0.0:*                           0          27151      1276/perl           
        udp        0      0 0.0.0.0:10000           0.0.0.0:*                           0          32133      2064/perl           
        udp        0      0 127.0.0.53:53           0.0.0.0:*                           101        21727      502/systemd-resolve 
        udp        0      0 0.0.0.0:111             0.0.0.0:*                           0          1307273    11313/rpcbind       
        udp        0      0 10.1.45.0:123           0.0.0.0:*                           122        36320      845/ntpd            
        udp        0      0 10.168.1.26:123         0.0.0.0:*                           0          28742      845/ntpd            
        udp        0      0 127.0.0.1:123           0.0.0.0:*                           0          28740      845/ntpd            
        udp        0      0 0.0.0.0:123             0.0.0.0:*                           0          28736      845/ntpd            
        udp        0      0 10.1.45.0:137           0.0.0.0:*                           0          44088      953/nmbd            
        udp        0      0 10.1.45.0:137           0.0.0.0:*                           0          44087      953/nmbd            
        udp        0      0 10.168.1.255:137        0.0.0.0:*                           0          28370      953/nmbd            
        udp        0      0 10.168.1.26:137         0.0.0.0:*                           0          28369      953/nmbd            
        udp        0      0 0.0.0.0:137             0.0.0.0:*                           0          28359      953/nmbd            
        udp        0      0 10.1.45.0:138           0.0.0.0:*                           0          44090      953/nmbd            
        udp        0      0 10.1.45.0:138           0.0.0.0:*                           0          44089      953/nmbd            
        udp        0      0 10.168.1.255:138        0.0.0.0:*                           0          28372      953/nmbd            
        udp        0      0 10.168.1.26:138         0.0.0.0:*                           0          28371      953/nmbd            
        udp        0      0 0.0.0.0:138             0.0.0.0:*                           0          28360      953/nmbd            
        udp        0      0 0.0.0.0:8472            0.0.0.0:*                           0          36259      -                   
        udp6       0      0 :::889                  :::*                                0          1307277    11313/rpcbind       
        udp6       0      0 :::39933                :::*                                109        22112      584/avahi-daemon: r 
        udp6       0      0 :::5353                 :::*                                109        22110      584/avahi-daemon: r 
        udp6       0      0 :::111                  :::*                                0          1307276    11313/rpcbind       
        udp6       0      0 fe80::3c:3dff:fecf::123 :::*                                122        36324      845/ntpd            
        udp6       0      0 fe80::20c:29ff:fe85:123 :::*                                0          28746      845/ntpd            
        udp6       0      0 ::1:123                 :::*                                0          28744      845/ntpd            
        udp6       0      0 :::123                  :::*                                0          28733      845/ntpd
        
        iobroker list adapters
        Could not connect database at 0.0.0.0:9000 (invalid protocol). Please make sure the configured IP and port points to a host running JS-Controller >= 2.0.
        Could not connect database at 0.0.0.0:9000 (invalid protocol). Please make sure the configured IP and port points to a host running JS-Controller >= 2.0.
        system.adapter.discovery               : discovery      - v2.3.5
        system.adapter.ping                    : ping           - v1.4.7
        system.adapter.hm-rpc                  : hm-rpc         - v1.14.2
        system.adapter.hm-rega                 : hm-rega        - v2.6.7
        system.adapter.openhab                 : openhab        - v1.1.0
        system.adapter.web                     : web            - v3.0.8
        system.adapter.history                 : history        - v1.9.6
        system.adapter.cloud                   : cloud          - v3.0.3
        system.adapter.mobile                  : mobile         - v0.5.0
        system.adapter.yamaha                  : yamaha         - v0.3.19
        system.adapter.vis                     : vis            - v1.2.1
        system.adapter.vis-fancyswitch         : vis-fancyswitch - v1.1.0
        system.adapter.flot                    : flot           - v1.10.0
        system.adapter.telegram                : telegram       - v1.5.9
        system.adapter.feiertage               : feiertage      - v1.0.11
        system.adapter.fritzbox                : fritzbox       - v0.2.1
        system.adapter.icons-ultimate-png      : icons-ultimate-png - v1.0.1
        system.adapter.icons-mfd-png           : icons-mfd-png  - v1.0.2
        system.adapter.vis-jqui-mfd            : vis-jqui-mfd   - v1.0.12
        system.adapter.upnp                    : upnp           - v1.0.14
        system.adapter.text2command            : text2command   - v1.3.0
        system.adapter.material                : material       - v0.13.8
        system.adapter.cul                     : cul            - v1.2.1
        system.adapter.daswetter               : daswetter      - v3.0.1
        system.adapter.yr                      : yr             - v2.0.3
        system.adapter.yahka                   : yahka          - v0.11.0
        system.adapter.mqtt                    : mqtt           - v2.1.2
        system.adapter.vcard                   : vcard          - v0.0.9
        system.adapter.ical                    : ical           - v1.7.0
        system.adapter.sonoff                  : sonoff         - v2.3.3
        system.adapter.backitup                : backitup       - v1.5.7
        system.adapter.mqtt-client             : mqtt-client    - v1.3.1
        system.adapter.openweathermap          : openweathermap - v0.1.0
        system.adapter.habpanel                : habpanel       - v0.3.4
        system.adapter.vis-material            : vis-material   - v0.1.3
        system.adapter.info                    : info           - v1.7.2
        system.adapter.terminal                : terminal       - v0.1.2
        system.adapter.wetty                   : wetty          - v0.1.1
        system.adapter.javascript              : javascript     - v4.5.1
        system.adapter.admin-2                 : admin-2        - v2.0.10
        system.adapter.rickshaw                : rickshaw       - v1.0.0
        system.adapter.mihome                  : mihome         - v1.3.0
        system.adapter.hass-mqtt               : hass-mqtt      - v0.0.7
        system.adapter.simple-api              : simple-api     - v2.4.5
        system.adapter.iqontrol                : iqontrol       - v0.4.0
        system.adapter.node-red                : node-red       - v1.17.2
        system.adapter.shuttercontrol          : shuttercontrol - v0.6.1
        system.adapter.fb-checkpresence        : fb-checkpresence - v1.0.1
        system.adapter.admin                   : admin          - v4.1.1
        system.adapter.zigbee                  : zigbee         - v1.0.3
        system.adapter.tr-064                  : tr-064         - v4.0.3
        system.adapter.web-speedy              : web-speedy     - v0.2.0
        system.adapter.radar2                  : radar2         - v1.0.9
        system.adapter.coronavirus-statistics  : coronavirus-statistics - v0.5.9
        system.adapter.shelly                  : shelly         - v3.2.8
        system.adapter.rpi2                    : rpi2           - v1.2.0
        system.adapter.bring                   : bring          - v1.7.2
        system.adapter.socketio                : socketio       - v3.0.7
        system.adapter.windows-control         : windows-control - v0.1.3
        
        Thomas Braun 1 Reply Last reply Reply Quote 0
        • Thomas Braun
          Thomas Braun Most Active @_Matze_ last edited by Thomas Braun

          @_Matze_ Bitte in </> code tags. Danke.

          iobroker list instances
          
          _ 1 Reply Last reply Reply Quote 0
          • _
            _Matze_ @Thomas Braun last edited by

            @Thomas-Braun said in iobroker: Could not connect database (invalid protocol):

            iobroker list instances

            iobroker list instances
            
            Could not connect database at 0.0.0.0:9000 (invalid protocol). Please make sure the configured IP and port points to a host running JS-Controller >= 2.0.
            Could not connect database at 0.0.0.0:9000 (invalid protocol). Please make sure the configured IP and port points to a host running JS-Controller >= 2.0.
              system.adapter.backitup.0              : backitup              - disabled
              system.adapter.bring.0                 : bring                 -  enabled
              system.adapter.cloud.0                 : cloud                 - disabled
              system.adapter.coronavirus-statistics.0: coronavirus-statistics -  enabled
              system.adapter.cul.0                   : cul                   -  enabled, port: 23
              system.adapter.daswetter.0             : daswetter             - disabled
              system.adapter.discovery.0             : discovery             -  enabled
              system.adapter.fb-checkpresence.0      : fb-checkpresence      -  enabled
              system.adapter.flot.0                  : flot                  -  enabled
              system.adapter.fritzbox.0              : fritzbox              -  enabled
              system.adapter.history.0               : history               -  enabled
              system.adapter.hm-rega.0               : hm-rega               -  enabled
              system.adapter.hm-rpc.1                : hm-rpc                -  enabled, port: 18701
              system.adapter.hm-rpc.2                : hm-rpc                -  enabled, port: 12001
              system.adapter.hm-rpc.3                : hm-rpc                -  enabled, port: 12010
              system.adapter.info.0                  : info                  -  enabled
              system.adapter.iqontrol.0              : iqontrol              -  enabled
              system.adapter.javascript.0            : javascript            -  enabled
              system.adapter.material.0              : material              -  enabled
              system.adapter.mihome.0                : mihome                - disabled, port: 9898, bind: 0.0.0.0
              system.adapter.mqtt.1                  : mqtt                  -  enabled, port: 1885, bind: 0.0.0.0
              system.adapter.openweathermap.0        : openweathermap        - disabled
              system.adapter.ping.0                  : ping                  -  enabled
              system.adapter.rickshaw.0              : rickshaw              -  enabled
              system.adapter.shelly.0                : shelly                -  enabled, port: 1882, bind: 10.168.1.26
              system.adapter.shuttercontrol.0        : shuttercontrol        - disabled
              system.adapter.simple-api.0            : simple-api            -  enabled, port: 8087, bind: 0.0.0.0, run as: admin
              system.adapter.telegram.0              : telegram              -  enabled, port: 8443, bind: 0.0.0.0
              system.adapter.telegram.1              : telegram              - disabled, port: 8443, bind: 0.0.0.0
              system.adapter.terminal.0              : terminal              - disabled, port: 8088, bind: 0.0.0.0, run as: admin
              system.adapter.text2command.0          : text2command          -  enabled
              system.adapter.tr-064.0                : tr-064                -  enabled
              system.adapter.web.0                   : web                   -  enabled, port: 8082, bind: 0.0.0.0, run as: admin
              system.adapter.wetty.0                 : wetty                 - disabled, port: 8089, bind: 0.0.0.0
              system.adapter.yahka.0                 : yahka                 - disabled
              system.adapter.yamaha.0                : yamaha                -  enabled
              system.adapter.zigbee.0                : zigbee                -  enabled, port: /dev/ttyACM0
            
            + instance is alive
            
            _ 1 Reply Last reply Reply Quote 0
            • _
              _Matze_ @_Matze_ last edited by

              @_Matze_

              🙄 Sieht so aus, als hätte ich mir durch die Installation von webhooks den Port 9000 versperrt

              Thomas Braun 1 Reply Last reply Reply Quote 0
              • Thomas Braun
                Thomas Braun Most Active @_Matze_ last edited by

                @_Matze_
                Genau, auf 9000 läuft ein webhook

                0 :::9000                 :::*                    LISTEN      0          24180      703/webhook
                

                Kannst die Ports vom iobroker mit einer custom installation aber auf andere Ports biegen.

                _ 1 Reply Last reply Reply Quote 0
                • _
                  _Matze_ @Thomas Braun last edited by

                  @Thomas-Braun
                  Den Webhook habe ich wieder deinstalliert - trotzdem kann ich noch nicht per Browser darauf zugreifen. Ich vermute durch meine Reparaturversuche habe ich noch etwas anderes zerlegt.

                  iobroker status
                  iobroker is running on this host.
                  
                  At least one iobroker host is running.
                  
                  Objects type: file
                  States  type: file
                  

                  Hast Du noch einen Tip?

                  Thomas Braun 1 Reply Last reply Reply Quote 0
                  • Thomas Braun
                    Thomas Braun Most Active @_Matze_ last edited by

                    @_Matze_ Zeig nochmal die Instanzen:

                    iobroker list instances
                    
                    _ 1 Reply Last reply Reply Quote 0
                    • _
                      _Matze_ @Thomas Braun last edited by

                      @Thomas-Braun said in iobroker: Could not connect database (invalid protocol):

                      iobroker list instances

                      iobroker list instances
                        system.adapter.backitup.0              : backitup              - disabled
                      + system.adapter.bring.0                 : bring                 -  enabled
                        system.adapter.cloud.0                 : cloud                 - disabled
                        system.adapter.coronavirus-statistics.0: coronavirus-statistics -  enabled
                      + system.adapter.cul.0                   : cul                   -  enabled, port: 23
                        system.adapter.daswetter.0             : daswetter             - disabled
                      + system.adapter.discovery.0             : discovery             -  enabled
                        system.adapter.fb-checkpresence.0      : fb-checkpresence      -  enabled
                        system.adapter.flot.0                  : flot                  -  enabled
                      + system.adapter.fritzbox.0              : fritzbox              -  enabled
                        system.adapter.history.0               : history               -  enabled
                      + system.adapter.hm-rega.0               : hm-rega               -  enabled
                      + system.adapter.hm-rpc.1                : hm-rpc                -  enabled, port: 18701
                      + system.adapter.hm-rpc.2                : hm-rpc                -  enabled, port: 12001
                      + system.adapter.hm-rpc.3                : hm-rpc                -  enabled, port: 12010
                        system.adapter.info.0                  : info                  -  enabled
                        system.adapter.iqontrol.0              : iqontrol              -  enabled
                        system.adapter.javascript.0            : javascript            -  enabled
                        system.adapter.material.0              : material              -  enabled
                        system.adapter.mihome.0                : mihome                - disabled, port: 9898, bind: 0.0.0.0
                      + system.adapter.mqtt.1                  : mqtt                  -  enabled, port: 1885, bind: 0.0.0.0
                        system.adapter.openweathermap.0        : openweathermap        - disabled
                      + system.adapter.ping.0                  : ping                  -  enabled
                        system.adapter.rickshaw.0              : rickshaw              -  enabled
                      + system.adapter.shelly.0                : shelly                -  enabled, port: 1882, bind: 10.168.1.26
                        system.adapter.shuttercontrol.0        : shuttercontrol        - disabled
                      + system.adapter.simple-api.0            : simple-api            -  enabled, port: 8087, bind: 0.0.0.0, run as: admin
                      + system.adapter.telegram.0              : telegram              -  enabled, port: 8443, bind: 0.0.0.0
                        system.adapter.telegram.1              : telegram              - disabled, port: 8443, bind: 0.0.0.0
                        system.adapter.terminal.0              : terminal              - disabled, port: 8088, bind: 0.0.0.0, run as: admin
                      + system.adapter.text2command.0          : text2command          -  enabled
                      + system.adapter.tr-064.0                : tr-064                -  enabled
                      + system.adapter.web.0                   : web                   -  enabled, port: 8082, bind: 0.0.0.0, run as: admin
                        system.adapter.wetty.0                 : wetty                 - disabled, port: 8089, bind: 0.0.0.0
                        system.adapter.yahka.0                 : yahka                 - disabled
                      + system.adapter.yamaha.0                : yamaha                -  enabled
                      + system.adapter.zigbee.0                : zigbee                -  enabled, port: /dev/ttyACM0
                      
                      + instance is alive
                      
                      Thomas Braun 1 Reply Last reply Reply Quote 0
                      • Thomas Braun
                        Thomas Braun Most Active @_Matze_ last edited by

                        @_Matze_
                        iobroker add admin

                        _ 1 Reply Last reply Reply Quote 0
                        • _
                          _Matze_ @Thomas Braun last edited by

                          @Thomas-Braun said in iobroker: Could not connect database (invalid protocol):

                          iobroker add admin

                          Das war es! Herzlichen Dank für Deine Hilfe!!! Es läuft wieder alles 👍 👏 👏

                          Thomas Braun 1 Reply Last reply Reply Quote 0
                          • Thomas Braun
                            Thomas Braun Most Active @_Matze_ last edited by Thomas Braun

                            @_Matze_ Freut mich. Magst du noch verraten wo der webhook herkam?

                            _ 1 Reply Last reply Reply Quote 0
                            • _
                              _Matze_ @Thomas Braun last edited by

                              @Thomas-Braun Den hatte ich am Vorabend installiert. Da hatte ich versucht eine Telegram direkt an einen User abzusetzen, um an die fertige Spülmaschine zu erinnern. Automatische Kommunikation mit Teens 🙂
                              https://nordicapis.com/how-to-build-your-first-telegram-bot-using-php-in-under-30-minutes/
                              Tja, und dann blieb der Webhook einfach zurück, ohne dass ich ihn wieder sauber deinstalliert hätte. Beim nächsten Reboot hat sich das dann bemerkbar gemacht.

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

                              Support us

                              ioBroker
                              Community Adapters
                              Donate

                              842
                              Online

                              31.8k
                              Users

                              80.0k
                              Topics

                              1.3m
                              Posts

                              database js-controller
                              2
                              14
                              2006
                              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