Device location not updated in database (already fixed?)
Hi Observium developers,
I just found out that when i changed the snmp location of a device it is not changed in the database. We are currently using R5919 (yeah… i know. ;-))
Poller output with debugging shows the new location correctly.
CMD[/usr/bin/snmpget -v3 **************** SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'arn2-kafw1.mgmt.sidn.nl':'161' sysUpTime.0 sysLocation.0 sysContact.0 sysName.0] EXITCODE[0]) RUNTIME[0.0304s], STDOUT[ sysUpTime.0 = 5:18:28:36.57 sysLocation.0 = Arnhem ==> OK, this is the new location <cut>
On every poll we see the location change in the syslog, but the location is not updated in the database.
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('78','NULL','system',NOW(),'Location -> Arnhem')] Module [ system ] time: 0.1684s
2014-12-09 11:43:03 System Location -> Arnhem 2014-12-09 11:38:10 System Location -> Arnhem 2014-12-09 11:33:09 System Location -> Arnhem 2014-12-09 11:28:13 System Location -> Arnhem 2014-12-09 11:23:12 System Location -> Arnhem 2014-12-09 11:18:08 System Location -> Arnhem
A manual change of the location in the device record resolved this issue.
It seems that there is a statement missing to update the device record.
Met vriendelijke groet, kind regards,
Erwin Heringa
SIDN | Meander 501 | 6825 MD | Postbus 5022 | 6802 EA | ARNHEM T +31 (0)26 352 55 59 | F +31 (0)26 352 55 05 erwin.heringa@sidn.nl | www.sidn.nl
Hi,
On 09.12.2014 14:46, Erwin Heringa wrote:
Hi Observium developers,
I just found out that when i changed the snmp location of a device it is not changed in the database. We are currently using R5919 (yeah… i know. ;-))
Already fixed in latest revisions ;)
Poller output with debugging shows the new location correctly.
CMD[/usr/bin/snmpget -v3 **************** SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'arn2-kafw1.mgmt.sidn.nl http://arn2-kafw1.mgmt.sidn.nl':'161' sysUpTime.0 sysLocation.0 sysContact.0 sysName.0] EXITCODE[0]) RUNTIME[0.0304s], STDOUT[ sysUpTime.0 = 5:18:28:36.57 sysLocation.0 = Arnhem ==> OK, this is the new location
<cut>
On every poll we see the location change in the syslog, but the location is not updated in the database.
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('78','NULL','system',NOW(),'Location -> Arnhem')] Module [ system ] time: 0.1684s
2014-12-09 11:43:03 System Location -> Arnhem 2014-12-09 11:38:10 System Location -> Arnhem 2014-12-09 11:33:09 System Location -> Arnhem 2014-12-09 11:28:13 System Location -> Arnhem 2014-12-09 11:23:12 System Location -> Arnhem 2014-12-09 11:18:08 System Location -> Arnhem
A manual change of the location in the device record resolved this issue.
It seems that there is a statement missing to update the device record.
Met vriendelijke groet, kind regards,
Erwin Heringa
SIDN | Meander 501 | 6825 MD | Postbus 5022 | 6802 EA | ARNHEM T +31 (0)26 352 55 59 | F +31 (0)26 352 55 05 erwin.heringa@sidn.nl mailto:erwin.heringa@sidn.nl | www.sidn.nl http://www.sidn.nl
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
Thanks a lot!
Met vriendelijke groet, kind regards,
Erwin Heringa
SIDN | Meander 501 | 6825 MD | Postbus 5022 | 6802 EA | ARNHEM T +31 (0)26 352 55 59 | F +31 (0)26 352 55 05 erwin.heringa@sidn.nl mailto:erwin.heringa@sidn.nl | www.sidn.nl http://www.sidn.nl/
On 09 Dec 2014, at 14:42, Mike Stupalov <mike@observium.org mailto:mike@observium.org> wrote:
Hi,
On 09.12.2014 14:46, Erwin Heringa wrote:
Hi Observium developers,
I just found out that when i changed the snmp location of a device it is not changed in the database. We are currently using R5919 (yeah… i know. ;-))
Already fixed in latest revisions ;)
Poller output with debugging shows the new location correctly.
CMD[/usr/bin/snmpget -v3 **************** SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'arn2-kafw1.mgmt.sidn.nl http://arn2-kafw1.mgmt.sidn.nl/':'161' sysUpTime.0 sysLocation.0 sysContact.0 sysName.0] EXITCODE[0]) RUNTIME[0.0304s], STDOUT[ sysUpTime.0 = 5:18:28:36.57 sysLocation.0 = Arnhem ==> OK, this is the new location
<cut>
On every poll we see the location change in the syslog, but the location is not updated in the database.
SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('78','NULL','system',NOW(),'Location -> Arnhem')] Module [ system ] time: 0.1684s
2014-12-09 11:43:03 System Location -> Arnhem 2014-12-09 11:38:10 System Location -> Arnhem 2014-12-09 11:33:09 System Location -> Arnhem 2014-12-09 11:28:13 System Location -> Arnhem 2014-12-09 11:23:12 System Location -> Arnhem 2014-12-09 11:18:08 System Location -> Arnhem
A manual change of the location in the device record resolved this issue.
It seems that there is a statement missing to update the device record.
Met vriendelijke groet, kind regards,
Erwin Heringa
SIDN | Meander 501 | 6825 MD | Postbus 5022 | 6802 EA | ARNHEM T +31 (0)26 352 55 59 | F +31 (0)26 352 55 05 erwin.heringa@sidn.nl mailto:erwin.heringa@sidn.nl | www.sidn.nl http://www.sidn.nl/
observium mailing list observium@observium.org mailto:observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
-- Mike Stupalov http://observium.org http://observium.org/_______________________________________________ observium mailing list observium@observium.org mailto:observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
participants (2)
-
Erwin Heringa -
Mike Stupalov