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

Since Latest update Observium no longer working

Details

    • Bug
    • Resolution: Unresolved
    • Major
    • None
    • Professional Edition
    • Discovery
    • Ubuntu

    Description

      After latest update discovery.php returns an error the behavior of Observium is that it is no longer polling stuffs.

      It seems that there is a problem with the DB but when updating ./discovery.php -u reports no error and has been issued immediately after svn update.

      Here is the error in verbose mode:

      SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND (`last_discovered` IS NULL OR `last_discovered` = '0000-00-00 00:00:00' OR `force_discovery` = '1') AND `poller_id` = '0' ORDER BY `last_discovered_timetaken` ASC]

      SQL RUNTIME[0.00040293s]

      SQL ERROR[Error in query: (Unknown column 'poller_id' in 'where clause') 1054]

      #####  Finished discovery run at 2020-12-24 07:45:58  #####

      Attachments

        Activity

          [OBS-3586] Since Latest update Observium no longer working

          Hi Maurizio, we have not received the additional information requested earlier from you in this issue 'After latest update discovery.php returns an error the behavior of Observium is that it is no longer polling stuffs.

          It seems that there is a problem with the DB but when updating ./discovery.php -u reports no error and has been issued immediately after svn update.

          Here is the error in verbose mode:

          SQL[SELECT * FROM `devices` WHERE `disabled` = 0 AND (`last_discovered` IS NULL OR `last_discovered` = '0000-00-00 00:00:00' OR `force_discovery` = '1') AND `poller_id` = '0' ORDER BY `last_discovered_timetaken` ASC]

          SQL RUNTIME[0.00040293s]

          SQL ERROR[Error in query: (Unknown column 'poller_id' in 'where clause') 1054]

          #####  Finished discovery run at 2020-12-24 07:45:58  #####'!

          Issues without your response will be closed within 2 weeks.

          landy Mike Stupalov added a comment - Hi Maurizio, we have not received the additional information requested earlier from you in this issue 'After latest update discovery.php returns an error the behavior of Observium is that it is no longer polling stuffs. It seems that there is a problem with the DB but when updating ./discovery.php -u reports no error and has been issued immediately after svn update. Here is the error in verbose mode: SQL [SELECT * FROM `devices` WHERE `disabled` = 0 AND (`last_discovered` IS NULL OR `last_discovered` = '0000-00-00 00:00:00' OR `force_discovery` = '1') AND `poller_id` = '0' ORDER BY `last_discovered_timetaken` ASC] SQL RUNTIME [0.00040293s] SQL ERROR [Error in query: (Unknown column 'poller_id' in 'where clause') 1054] #####  Finished discovery run at 2020-12-24 07:45:58  ##### '! Issues without your response will be closed within 2 weeks.

          Please make and attach additional information about the device:

          • full snmp dump from device:

            snmpwalk -v2c -c <community>  --hexOutputLength=0 -ObentxU <hostname> .1 > myagent.snmpwalk
            snmpwalk -v2c -c <community>  --hexOutputLength=0 -ObentxU <hostname> .1.3.6.1.4.1 >> myagent.snmpwalk

            If device not support SNMP version 2c, replace -v2c with -v1.

          • If you have problems with discovery or poller processes, please do and attach these debugs:

            ./discovery.php -d -h <device>
            ./poller.php -d -h <device>

          • additionally attach device and/or vendor specific MIB files

          Note, this comment is added automatically.

          bot Observium Bot added a comment - Please make and attach additional information about the device: full snmp dump from device: snmpwalk -v2c -c <community> --hexOutputLength=0 -ObentxU <hostname> .1 > myagent.snmpwalk snmpwalk -v2c -c <community> --hexOutputLength=0 -ObentxU <hostname> .1.3.6.1.4.1 >> myagent.snmpwalk If device not support SNMP version 2c, replace -v2c with -v1. If you have problems with discovery or poller processes, please do and attach these debugs: ./discovery.php -d -h <device> ./poller.php -d -h <device> additionally attach device and/or vendor specific MIB files Note, this comment is added automatically.

          People

            landy Mike Stupalov
            Del Bianco Maurizio
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated: