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

distro_ver too short for HardenedBSD

Details

    • Bug
    • Resolution: Fixed
    • Minor
    • None
    • Professional Edition
    • Default
    • None

    Description

      HardenedBSD (security hardened variant of FreeBSD) reports distro_ver as 17 character string:

       

      14.0-CURRENT-HBSD

       

       

      This causes Observium event log to fill up with following repeating entries:

       

      Distro_ver changed: '14.0-CURRENT-HBS' -> '14.0-CURRENT-HBSD'

       

       

      This continous distro_ver change detection is caused by distro_ver being declared and stored as 16-character VARCHAR:

      `distro_ver` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL

       

      Would it be possible to alter distro_ver in schema to be bit longer than 16-characters to accomodate HardenedBSD and other OSs that report longer version identifiers? 

      Attachments

        Issue Links

          relates to

          Add New Device / OS - User wants to add support for currently unsupported device or OS. OBS-4257 OS: HardenedBSD

          • Major - Major loss of function.
          • Resolved

          Activity

            [OBS-4246] distro_ver too short for HardenedBSD
            landy Mike Stupalov made changes -
            Link New: This issue relates to OBS-4257 [ OBS-4257 ]
            nodefield Ilkka Myller added a comment -

            I'll stay with the stable as this is not critical issue.

            You'll probably release Observium Professional 22.9 soon  

             

            Thank you for the quick fix and great customer service!

             

            nodefield Ilkka Myller added a comment - I'll stay with the stable as this is not critical issue. You'll probably release Observium Professional 22.9 soon     Thank you for the quick fix and great customer service!  
            landy Mike Stupalov added a comment -

            yes, stable updated less often.
            you can try switch to rolling:
            https://docs.observium.org/updating/#switch-between-rolling-and-stable-trains

            landy Mike Stupalov added a comment - yes, stable updated less often. you can try switch to rolling: https://docs.observium.org/updating/#switch-between-rolling-and-stable-trains
            nodefield Ilkka Myller added a comment -

            Pro version stable r12278 still unchanged:

            <redacted>@observium:/opt/observium# svn up
            		 
            Updating '.':
            		 
            At revision 12278.
            		 
            <redacted>@observium:/opt/observium# grep -ri distro_ver update
            		 
            update/089.sql:ALTER TABLE  `devices` ADD `distro_ver` VARCHAR( 16 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL;
            		 
            update/db_schema_mysql.sql:  `distro_ver` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL,

             

            nodefield Ilkka Myller added a comment - Pro version stable r12278 still unchanged: <redacted> @observium :/opt/observium# svn up Updating '.' : At revision 12278 . <redacted> @observium :/opt/observium# grep -ri distro_ver update update/ 089 .sql:ALTER TABLE  `devices` ADD `distro_ver` VARCHAR( 16 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL; update/db_schema_mysql.sql:  `distro_ver` varchar( 16 ) COLLATE utf8_unicode_ci DEFAULT NULL,  
            landy Mike Stupalov made changes -
            Resolution New: Fixed [ 1 ]
            Status Original: In Progress [ 3 ] New: Resolved [ 5 ]
            landy Mike Stupalov added a comment -

            Ok, in r12276 this field increased (need run ./discovery.php -u after update).
            Also improved distro script for detect HardenedBSD (as distribution).

            landy Mike Stupalov added a comment - Ok, in r12276 this field increased (need run ./discovery.php -u after update). Also improved distro script for detect HardenedBSD (as distribution).
            landy Mike Stupalov made changes -
            Status Original: In Review [ 10101 ] New: In Progress [ 3 ]
            landy Mike Stupalov made changes -
            Status Original: Pending Response [ 10000 ] New: In Review [ 10101 ]
            nodefield Ilkka Myller added a comment -

             

             

            ~# sysctl hardening.version
            		 
            hardening.version: 1400003

             

             

            :~# cat /var/db/hbsd-update/version
            		 
            hbsd-v1400003-9a91c5120c1d2e120213d7b8d6a56c15bffc9ad4

             

            nodefield Ilkka Myller added a comment -     ~# sysctl hardening.version hardening.version: 1400003     :~# cat /var/db/hbsd-update/version hbsd-v1400003-9a91c5120c1d2e120213d7b8d6a56c15bffc9ad4  
            landy Mike Stupalov made changes -
            Status Original: In Review [ 10101 ] New: Pending Response [ 10000 ]

            People

              landy Mike Stupalov
              nodefield Ilkka Myller
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: