Community
    • Categories
    • Recent
    • Popular
    • Users
    • Search
    • Register
    • Login

    IP Liste verschwunden

    Scheduled Pinned Locked Moved Allgemein
    8 Posts 2 Posters 254 Views
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • L Offline
      Leanback
      last edited by

      Guten Abend zusammen,

      ich habe ein komisches Problem.
      In der Version 18 CE ist bei mir auf einmal die IP-Liste im Ordner Netz unter Layer 3 Netz verschwunden.
      Daraufhin habe ich auf die neueste idoit 20 Version upgedatet, allerdings hat mir das die Liste nicht wiedergebracht.

      Hat jemand eine Idee was das sein kann und wie ich die Liste wiederbekomme?

      So sieht es bei mit nun aus:
      35b209c2-4363-4b45-a5f9-f9f57fd2fdd9-image.png

      Setup:
      MariaDB 10.5
      PHP8.0
      apache 2.4.54
      Debian11
      idoit 20 Rev. 202220000

      Beste Grüße
      Sergej

      LFischerL 1 Reply Last reply Reply Quote 0
      • LFischerL Offline
        LFischer @Leanback
        last edited by

        Hallo @Leanback

        das ist allerdings ein merkwürdiges Phänomen... Was wurden denn für Aktionen unternommen unmittelbar bevor die Kategorie "verschwunden" ist? Lässt sich ausschließen das es sich dabei um ein Rechte-Problem handelt?

        Du könntest im Report-Manager folgende Query ausführen:

        SELECT a.isysgui_cats__id AS childId, a.isysgui_cats__title AS childTitle, b.isysgui_cats__id AS parentId, b.isysgui_cats__title AS parentTitle
        FROM isysgui_cats AS a
        LEFT JOIN isysgui_cats AS b ON b.isysgui_cats__id = a.isysgui_cats__parent
        WHERE a.isysgui_cats__const = 'C__CATS__NET_IP_ADDRESSES'
        

        Diese Query sollte dir sowas anzeigen wie

        childId 77
        childTitle "IP list"
        parentId 22
        parentTitle "Net"

        Darüber können wir sicherstellen das die Verknüpfung zwischen den beiden Kategorien gegeben ist. Alternativ können wir auch diese Query hier ausprobieren (das Ergebnis sollte das gleiche sein):

        SELECT a.isysgui_cats__id AS childId, a.isysgui_cats__title AS childTitle, b.isysgui_cats__id AS parentId, b.isysgui_cats__title AS parentTitle
        FROM isysgui_cats_2_subcategory
        LEFT JOIN isysgui_cats AS a ON a.isysgui_cats__id = isysgui_cats_2_subcategory__isysgui_cats__id__parent
        LEFT JOIN isysgui_cats AS b ON b.isysgui_cats__id = isysgui_cats_2_subcategory__isysgui_cats__id__child
        WHERE b.isysgui_cats__const = 'C__CATS__NET_IP_ADDRESSES'
        

        Kannst du hierzu die Ergebnisse liefern?

        Viele Grüße
        Leo

        L 2 Replies Last reply Reply Quote 0
        • L Offline
          Leanback @LFischer
          last edited by Leanback

          Hallo @LFischer,

          vielen Dank für deine Rückmeldung.
          Ich habe beide Querys ausgeführt (in der mysql Konsole, da ich auch keinen Report Manager habe) dort kam bei beiden Abfragen ein "Empty set".
          Zum Test habe ich es auf einer anderen Instanz getestet und da kam das Ergebnis wie du es geschrieben hast.

          Auch mit "/?moduleID=1004" in der URL kann ich den Report Manager nicht öffnen.

          Zur Berechtigung:
          Es gibt und gab bisher nur einen User, und das ist der admin User.

          Es ist nichts spannendes passiert, auch im logbook lässt sich nichts dramatisches feststellen.

          1 Reply Last reply Reply Quote 0
          • L Offline
            Leanback @LFischer
            last edited by

            Hallo @LFischer,

            ich habe noch einmal die idoit-jobs laufen lassen. Folgendes Ergebniss habe ich erhalten:

            Perform important background tasks for i-doit
            Archive i-doit logbook
            Logbook archiving-handler initialized - 2022-12-08 14:43:29
            
            Using local database
            Archiving all entries older than 90 days (older than 2022-09-09)
            About to move 0 logbook entries
            Done!
            About to move 0 logbook category entries
            Done!
            Memory peak: 18 MB
            
            Finished the process - 2022-12-08 14:43:29
            
            Cleanup i-doit rights
            Auth paths cleanup initialized (2022-12-08 14:43:30)
            Cleanup done.
            
            Purge unfinished objects
            Starting cleanup...
            Unused objects with status unfinished deleted Total of 0.
            Done
            
            Re-create search index
            Start Indexing!
            
            
            Finished reading 461 rows
            
            Start mapping 461 rows to 1173 documents for "General" (C__CATG__GLOBAL)
            
            517 of 1173 documents were skipped!
            
            Start mapping 178 rows to 178 documents for "General" (C__CATG__GLOBAL)
            
            Start inserting documents
            
            Finished inserting documents!
            
            
            Finished reading 81 rows
            
            Start mapping 81 rows to 243 documents for "Model" (C__CATG__MODEL)
            
            152 of 243 documents were skipped!
            
            Start inserting documents
            
            Finished inserting documents!
            
            
            Finished reading 4 rows
            
            Start mapping 4 rows to 6 documents for "Form factor" (C__CATG__FORMFACTOR)
            
            2 of 6 documents were skipped!
            
            Start inserting documents
            
            Finished inserting documents!
            
            
            Finished reading 32 rows
            
            Start mapping 32 rows to 68 documents for "CPU" (C__CATG__CPU)
            
            36 of 68 documents were skipped!
            
            Start inserting documents
            
            Finished inserting documents!
            
            
            Finished reading 2 rows
            
            Start mapping 2 rows to 2 documents for "Memory" (C__CATG__MEMORY)
            
            0 of 2 documents were skipped!
            
            Start inserting documents
            
            Finished inserting documents!
            
            
            Finished reading 2 rows
            
            Start mapping 2 rows to 4 documents for "Power consumer" (C__CATG__POWER_CONSUMER)
            
            2 of 4 documents were skipped!
            
            Start inserting documents
            
            Finished inserting documents!
            
            
            Finished reading 6 rows
            
            Start mapping 6 rows to 18 documents for "Access" (C__CATG__ACCESS)
            
            8 of 18 documents were skipped!
            
            Start inserting documents
            
            Finished inserting documents!
            
            
            Finished reading 10 rows
            
            Start mapping 10 rows to 40 documents for "Controller" (C__CATG__CONTROLLER)
            
            29 of 40 documents were skipped!
            
            Start inserting documents
            
            Finished inserting documents!
            
            
            Finished reading 1 rows
            
            Start mapping 1 rows to 2 documents for "Location" (C__CATG__LOCATION)
            
            1 of 2 documents were skipped!
            
            Start inserting documents
            
            Finished inserting documents!
            
            
            Finished reading 6 rows
            
            Start mapping 6 rows to 18 documents for "Graphic card" (C__CATG__GRAPHIC)
            
            12 of 18 documents were skipped!
            
            Start inserting documents
            
            Finished inserting documents!
            
            
            Finished reading 4 rows
            
            Start mapping 4 rows to 74 documents for "Accounting" (C__CATG__ACCOUNTING)
            
            59 of 74 documents were skipped!
            
            Start inserting documents
            
            Finished inserting documents!
            
            
            Finished reading 202 rows
            
            Start mapping 202 rows to 808 documents for "Port" (C__CATG__NETWORK_PORT)
            
            606 of 808 documents were skipped!
            
            Start inserting documents
            
            Finished inserting documents!
            
            
            Finished reading 4 rows
            
            Start mapping 4 rows to 20 documents for "Interface" (C__CATG__NETWORK_INTERFACE)
            
            16 of 20 documents were skipped!
            
            Start inserting documents
            
            Finished inserting documents!
            
            
            Finished reading 6 rows
            
            Start mapping 6 rows to 18 documents for "logical Ports" (C__CATG__NETWORK_LOG_PORT)
            
            12 of 18 documents were skipped!
            
            Start inserting documents
            
            Finished inserting documents!
            
            
            Finished reading 11 rows
            
            Start mapping 11 rows to 46 documents for "Drive" (C__CATG__DRIVE)
            
            27 of 46 documents were skipped!
            
            Start inserting documents
            
            Finished inserting documents!
            
            
            Finished reading 8 rows
            
            Start mapping 8 rows to 53 documents for "Device" (C__CATG__STORAGE_DEVICE)
            
            41 of 53 documents were skipped!
            
            Start inserting documents
            
            Finished inserting documents!
            
            
            Start mapping 40 rows to 160 documents for "Host address" (C__CATG__IP)
            
            89 of 160 documents were skipped!
            
            Start mapping 40 rows to 80 documents for "Host address" (C__CATG__IP)
            
            Start inserting documents
            
            Finished inserting documents!
            
            
            Finished reading 3 rows
            
            Start mapping 3 rows to 15 documents for "Version" (C__CATG__VERSION)
            
            12 of 15 documents were skipped!
            
            Start inserting documents
            
            Finished inserting documents!
            
            
            Finished reading 3 rows
            
            Start mapping 3 rows to 6 documents for "Raid-Array" (C__CATG__RAID)
            
            3 of 6 documents were skipped!
            
            Start inserting documents
            
            Finished inserting documents!
            
            
            Finished reading 8 rows
            
            Start mapping 8 rows to 72 documents for "Address" (C__CATG__ADDRESS)
            
            20 of 72 documents were skipped!
            
            Start inserting documents
            
            Finished inserting documents!
            
            
            Finished reading 9 rows
            
            Start mapping 9 rows to 10 documents for "Room" (C__CATS__ROOM)
            
            1 of 10 documents were skipped!
            
            Start inserting documents
            
            Finished inserting documents!
            
            
            Finished reading 30 rows
            
            Start mapping 30 rows to 150 documents for "Net" (C__CATS__NET)
            
            60 of 150 documents were skipped!
            
            Start inserting documents
            
            Finished inserting documents!
            
            
            Finished reading 14 rows
            
            Start mapping 14 rows to 70 documents for "License keys" (C__CATS__LICENCE_LIST)
            
            50 of 70 documents were skipped!
            
            Start inserting documents
            
            Finished inserting documents!
            
            
            Finished reading 3 rows
            
            Start mapping 3 rows to 75 documents for "Master Data" (C__CATS__PERSON_MASTER)
            
            68 of 75 documents were skipped!
            
            Start inserting documents
            
            Finished inserting documents!
            
            
            Finished reading 2 rows
            
            Start mapping 2 rows to 4 documents for "Login" (C__CATS__PERSON_LOGIN)
            
            2 of 4 documents were skipped!
            
            Start inserting documents
            
            Finished inserting documents!
            
            
            Finished reading 5 rows
            
            Start mapping 5 rows to 20 documents for "Master Data" (C__CATS__PERSON_GROUP_MASTER)
            
            5 of 20 documents were skipped!
            
            Start inserting documents
            
            Finished inserting documents!
            
            
            Finished reading 10 rows
            
            Start mapping 10 rows to 30 documents for "DHCP" (C__CATS__NET_DHCP)
            
            10 of 30 documents were skipped!
            
            Start inserting documents
            
            Finished inserting documents!
            
            
            Finished reading 25 rows
            
            Start mapping 25 rows to 100 documents for "Layer 2 Net" (C__CATS__LAYER2_NET)
            
            75 of 100 documents were skipped!
            
            Start inserting documents
            
            Finished inserting documents!
            
            Finished indexing!
            
            0 rows got read!
            3345 documents got mapped!
            1915 documents got skipped while mapping, because of empty data!
            1414 documents got inserting!
            0 documents of inserted documents got skipped because they were duplicated!
            Send notifications
            Begin to notify...
            
            

            Ich glaube mir fehlen auch Dateien die ich mal hochgeladen habe, die kann ich nämlich nicht mehr finden. Scheint ein größeres Problem zu sein.
            Wäre toll wenn wir das lösen könnten.

            LFischerL 1 Reply Last reply Reply Quote 0
            • LFischerL Offline
              LFischer @Leanback
              last edited by

              Hey @Leanback

              das klingt tatsächlich sehr merkwürdig - verstehe ich es richtig das du i-doit OPEN einsetzt? In der Version gibt es die IP-Liste gar nicht - von daher wäre dein jetziger Stand "korrekt"... Hast du ggf. von einer PRO Installation auf eine OPEN gewechselt?

              VG Leo

              L 1 Reply Last reply Reply Quote 0
              • L Offline
                Leanback @LFischer
                last edited by

                Hi @LFischer,

                ja ich habe die idoit OPEN Version und bin mir ziemlich sicher dass die IP Liste immer da war. Ich bin auch nie von einer Pro auf Open gewechselt.
                Aber wenn die nicht zur Open Version gehört, hatte ich vielleicht Glück dass ich das ne Zeit lang nutzen konnte. Aber verstehen tu ich das trotzdem nicht, jetzt fehlt die Liste natürlich 🙂

                Beste Grüße
                Sergej

                LFischerL 1 Reply Last reply Reply Quote 0
                • LFischerL Offline
                  LFischer @Leanback
                  last edited by

                  Hey @Leanback

                  ich kann mal meine Kollegen vom Support fragen ob es ggf. in einer der älteren OPEN Versionen irgendwelche solchen Unstimmigkeiten gegeben hat 🤔

                  Bezüglich der hochgeladenen Dateien: kannst du das etwas weiter ausführen?

                  VG Leo

                  L 1 Reply Last reply Reply Quote 0
                  • L Offline
                    Leanback @LFischer
                    last edited by

                    Hallo @LFischer,

                    Die Dateien habe ich mittlerweile wiedergefunden, diese haben lediglich die Zuordnung zu den Lizenz-Objekten verloren.

                    Vielen Dank für deine Unterstützung.

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