Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-35901

Samigo: The export-import fails when the specified IP addresses length is greater than 255 characters

    XMLWordPrintable

    Details

    • 10 status:
      Resolved
    • Previous Issue Keys:
      SAM-2355

      Description

      Steps to reproduce the issue:

      1. Create an assessment.
      2. Set the assessment to allow only the next specified IP addresses:

      192.168.1.1
      192.168.1.4
      192.168.1.16
      192.168.1.22
      192.168.1.70
      192.168.1.74
      192.168.1.76
      192.168.1.78
      192.168.1.91
      192.168.1.94
      192.168.1.97
      192.168.1.102
      192.168.1.107
      192.168.1.115
      192.168.1.117
      192.168.1.122
      192.168.1.125
      192.168.1.133
      192.168.1.135
      192.168.1.149

      This data is stored in the table SAM_SECUREDIP_T. One row for each IP.

      3. Export the assessment.
      4. Try to import. The import fails.

      The reason it fails is that when samigo imports, all IP addressess (more than 255 characters) are stored in the db field SAM_ASSESSMETADATA_T.ENTRY which is able to store only 255 characters.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                jjmerono@um.es Juan José Meroño Sánchez
                Reporter:
                raulsv Raúl Sánchez Vegas
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Git Source Code