We couldn't load all Actvitity tabs. Refresh the page to try again.
If the problem persists, contact your Jira admin.
Uploaded image for project: 'Observium'
  1. Observium
  2. OBS-2227

ifIndex column changed to bigint(20) to support Huawei Ports

Details

    • Improvement
    • Resolution: Fixed
    • Minor
    • None
    • None
    • Poller

    Description

      After trying to add our Huawei MA5800 OLT, I did not see any GPON port. Doing a poller debug gave me the following result:

      mError in query: (Duplicate entry '1076-2147483647' for key 'device_ifIndex')

      As the ifIndex of the Huawei ports start with some big integer:

      ifIndex.4194312192 = -100655104
      ifIndex.4194312448 = -100654848
      ifIndex.4194312704 = -100654592
      ifIndex.4194312960 = -100654336

      I suggested that the maximum of the 32 bit default ifIndex column of the table ports was the problem. 
      After changing this to bigint,(ALTER TABLE ports MODIFY COLUMN ifIndex BIGINT NOT NULL  the poller can add the OLt ports with the 64 bit ifIndex:

      Maybe you can change the database scheme so the Huawei ports can be added standard.

      regards,

      Rinse Kloek

       

      Attachments

        Activity

          Loading...
          Uploaded image for project: 'Observium'
          1. Observium
          2. OBS-2227

          ifIndex column changed to bigint(20) to support Huawei Ports

          Details

            • Improvement
            • Resolution: Fixed
            • Minor
            • None
            • None
            • Poller

            Description

              After trying to add our Huawei MA5800 OLT, I did not see any GPON port. Doing a poller debug gave me the following result:

              mError in query: (Duplicate entry '1076-2147483647' for key 'device_ifIndex')

              As the ifIndex of the Huawei ports start with some big integer:

              ifIndex.4194312192 = -100655104
              ifIndex.4194312448 = -100654848
              ifIndex.4194312704 = -100654592
              ifIndex.4194312960 = -100654336

              I suggested that the maximum of the 32 bit default ifIndex column of the table ports was the problem. 
              After changing this to bigint,(ALTER TABLE ports MODIFY COLUMN ifIndex BIGINT NOT NULL  the poller can add the OLt ports with the 64 bit ifIndex:

              Maybe you can change the database scheme so the Huawei ports can be added standard.

              regards,

              Rinse Kloek

               

              Attachments

                Activity

                  People

                    landy Mike Stupalov
                    rinsekloek Rinse Kloek
                    Votes:
                    0 Vote for this issue
                    Watchers:
                    3 Start watching this issue

                    Dates

                      Created:
                      Updated:
                      Resolved:

                      People

                        landy Mike Stupalov
                        rinsekloek Rinse Kloek
                        Votes:
                        0 Vote for this issue
                        Watchers:
                        3 Start watching this issue

                        Dates

                          Created:
                          Updated:
                          Resolved: