Ad Widget

Collapse

Maps that desapears..

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • pierre-hoffmann
    Senior Member
    • Jan 2008
    • 133

    #16
    Hi,

    I've same problem with 1.6.2 on a huge map;
    how to modifie mysql database to un-hide the map ??

    WorkArround for 1.6.2 or not ?

    Regards
    P.Hoffmann
    System & Network Admin.
    __________________________
    Zabbix version 1.8.1
    Hosts monitored 1300
    OS Novell SLES 10 SP2
    __________________________

    Comment

    • Neurotox
      Junior Member
      • Nov 2008
      • 25

      #17
      Manual fix

      Hi,

      To be able to access your map again you have to go directly in your database.

      You will have to use 2 tables: sysmaps and sysmaps_elements.

      1: finding the sysmapid:
      select * from sysmaps;
      then write the sysmapid corresponding to your map (for this example, we will assume 3)

      2: finding the problematic host:
      select * from sysmaps_elements where sysmapid=3;
      look for and element with elementid=0 and write is selementid number ( example: 6
      look also for and element with elementid is not 0 and write this number (example: 10074)

      3: change the problematic entry:
      update sysmaps_elements SET elementid=10074 where selementid=6;

      Then you will be able to see your map again, but be carefull one of your element will not be good (check the "label" or the "x" "y" value of the items with elementid=0 to be able to find which one is problematic).

      This work well for me.

      Thanks,
      François

      Comment

      • richlv
        Senior Member
        Zabbix Certified Trainer
        Zabbix Certified SpecialistZabbix Certified Professional
        • Oct 2005
        • 3112

        #18
        well, theoretically, you could just delete all elements with element id 0 - should be faster.
        but i'd strongly suggest first using select instead of delete, and having backups before you mess with the db directly is always a good idea
        Zabbix 3.0 Network Monitoring book

        Comment

        • Neurotox
          Junior Member
          • Nov 2008
          • 25

          #19
          True, deleting the bad entries will probably be more logical

          Comment

          • pierre-hoffmann
            Senior Member
            • Jan 2008
            • 133

            #20
            Hi,

            I've delete bad entry and now it works !!

            Thanks

            A patch for php code 1.6.2 ??? Or wait 1.6.3 ??

            Regards.
            P.Hoffmann
            System & Network Admin.
            __________________________
            Zabbix version 1.8.1
            Hosts monitored 1300
            OS Novell SLES 10 SP2
            __________________________

            Comment

            • nkeeter
              Junior Member
              • Oct 2008
              • 2

              #21
              Deleting the bad entry is how I fixed it as well...

              I did the same thing with mine. Is the fix for this going to be included in the next release?

              Comment

              • richlv
                Senior Member
                Zabbix Certified Trainer
                Zabbix Certified SpecialistZabbix Certified Professional
                • Oct 2005
                • 3112

                #22
                it already is included
                1.6.3 is out.
                Zabbix 3.0 Network Monitoring book

                Comment

                Working...