- observium - lists.observium.org

Device not yet polled?
by observium＠velder.li 20 May '13

20 May '13

Hello there i changed a complete device (hostname is the same, but different location). Location was not updated. Hmmm, ok, i deleted the device, rm -r'ed rrd dir and re-added the device. Now it says Device not yet polled That's not correct. Device is polled. And the LocationBar does not update the locations. There's only UNKNOWN (1). Bug or my problem? Regards, patrick

4 14

Small splat patch + CheckPoint logo
by Laurens Vets 19 May '13

19 May '13

Small patch to add logo and initial splat.inc.php file for CheckPoint SecurePlatform support. I intend to expand this further... -Laurens

1 0

Re: [Observium] [Observium-dev] r4031 - in observer/trunk: html/images/os includes includes/discovery/os
by Adam Armstrong 19 May '13

19 May '13

It is indeed. The first should be .2 :-) Adam. "Rob J. Epping" <rob.epping(a)gmail.com> wrote: >On Sun, May 19, 2013 at 5:32 PM, <observium-commits(a)observium.org> wrote: >[SNIP] >> + if (strstr($sysObjectId, "1.3.6.1.4.1.2.3.1.2.1.1.3") || >> + strstr($sysObjectId, "1.3.6.1.4.1.2.3.1.2.1.1.3") ) { $os = "aix"; } > >Am I misreading this or is the same oid tested twice? >-- >GRTNX, >RobJE >_______________________________________________ >observium mailing list >observium(a)observium.org >http://postman.memetic.org/cgi-bin/mailman/listinfo/observium

1 0

Re: [Observium] [Observium-dev] r4031 - in observer/trunk: html/images/os includes includes/discovery/os
by Rob J. Epping 19 May '13

19 May '13

On Sun, May 19, 2013 at 5:32 PM, <observium-commits(a)observium.org> wrote: [SNIP] > + if (strstr($sysObjectId, "1.3.6.1.4.1.2.3.1.2.1.1.3") || > + strstr($sysObjectId, "1.3.6.1.4.1.2.3.1.2.1.1.3") ) { $os = "aix"; } Am I misreading this or is the same oid tested twice? -- GRTNX, RobJE

1 0

Re: [Observium] Device not yet polled?
by Adam Armstrong 19 May '13

19 May '13

Agh. Jason Lixfeld <jason(a)lixfeld.ca> wrote: >Indeed. > >ERROR 1054 (42S22): Unknown column 'location_geoapi' in 'field list' > >Sooo... was this me thinking that I actually did run './discovery.php -h new' after one of my updates when in fact I was dreaming it?? > >I was damn sure that I ran that, and made sure I ran it after the upgrade to 4027. Would that not have cleared it if I had forgotten to run it at some point prior? Or do I have to svn back to 3992, run discovery -h new, then upgrade to 4027 again and run discovery -h new again? > >On 2013-05-19, at 10:50 AM, Adam Armstrong <adama(a)memetic.org> wrote: > >> Do you get an error if you try to run the query by hand? >> >> The UPDATE query between SQL[]. >> >> adam. >> >> On 2013-05-19 15:19, Jason Lixfeld wrote: >>> I'm having a similar issue, but this particular device is brand new >>> and had nothing to do with maps. >>> Device information only shows "Cisco IOS" where other devices of the >>> same hardware type running the same OS all show their Device >>> Information just fine. >>> I've tried to delete the device and let it get re-polled, with no difference. >>> I should be clear - all other Observium behaviour on the device is >>> fine, just that Device Information stuff seems to be stuck... >>> Here's the same outpot from ./poller -h ... -d >>> SQL[UPDATE `devices` set `uptime` ='154877',`sysObjectID` >>> ='.1.3.6.1.4.1.9.1.1250',`sysName` ='pe01.2bloorstw01.yyz',`sysDescr` >>> ='Cisco IOS Software, ME360x Software (ME360x-UNIVERSAL-M), Version >>> 15.3(2)S, RELEASE SOFTWARE (fc1)\r\nTechnical Support: >>> http://www.cisco.com/techsupport\r\nCopyright (c) 1986-2013 by Cisco >>> Systems, Inc.\r\nCompiled Mon 25-Mar-13 12:58 by >>> prod_rel_team',`location_geoapi` ='mapquest',`location_lat` >>> ='37.7463058',`location_lon` ='-25.6668573',`location_city` >>> ='Unknown',`location_county` ='Unknown',`location_state` >>> ='Unknown',`location_country` ='Unknown',`version` >>> ='15.3(2)S',`features` ='UNIVERSAL',`hardware` >>> ='ciscoMe3600x24fsM',`last_polled` =NOW(),`last_polled_timetaken` >>> ='2.832',`device_state` ='N;' WHERE `device_id` = '182'] >>> SQL[INSERT INTO `perf_times` >>> (`type`,`doing`,`start`,`duration`,`devices`) VALUES >>> ('poll','pe01.2bloorstw01.yyz','1368972218.5967','2.912','1')] >>> ./poller.php pe01.2bloorstw01.yyz May 19, 2013, 10:03 - 1 devices >>> polled in 2.912 secs >>> The database, however, is missing much of this.. >>> mysql> select * from devices where sysname = 'pe01.2bloorstw01.yyz'; >>> +-----------+----------------------+----------------------+-----------+-----------+----------+----------+----------+------------+------------+---------+------+-----------+---------+---------+----------+------------+-------------+----------+------------+---------+----------+----------+----------+------+--------+--------+----------+--------+--------------+-------------+-----------------------+---------------------------+---------------------+---------+---------+--------+------+ >>> | device_id | hostname | sysName | community >>> | authlevel | authname | authpass | authalgo | cryptopass | cryptoalgo >>> | snmpver | port | transport | timeout | retries | ssh_port | >>> bgpLocalAs | sysObjectID | sysDescr | sysContact | version | hardware >>> | features | location | os | status | ignore | disabled | uptime | >>> agent_uptime | last_polled | last_polled_timetaken | >>> last_discovered_timetaken | last_discovered | purpose | type | >>> serial | icon | >>> +-----------+----------------------+----------------------+-----------+-----------+----------+----------+----------+------------+------------+---------+------+-----------+---------+---------+----------+------------+-------------+----------+------------+---------+----------+----------+----------+------+--------+--------+----------+--------+--------------+-------------+-----------------------+---------------------------+---------------------+---------+---------+--------+------+ >>> | 182 | pe01.2bloorstw01.yyz | pe01.2BloorStW01.YYZ | public >>> | NULL | NULL | NULL | NULL | NULL | NULL >>> | v2c | 161 | udp | NULL | NULL | 22 | 21949 >>> | NULL | NULL | | NULL | NULL | NULL >>> | | ios | 1 | 0 | 0 | NULL | 0 >>> | NULL | NULL | 1.91 | >>> 2013-05-19 09:08:43 | NULL | network | NULL | NULL | >>> +-----------+----------------------+----------------------+-----------+-----------+----------+----------+----------+------------+------------+---------+------+-----------+---------+---------+----------+------------+-------------+----------+------------+---------+----------+----------+----------+------+--------+--------+----------+--------+--------------+-------------+-----------------------+---------------------------+---------------------+---------+---------+--------+------+ >>> 1 row in set (0.00 sec) >>> mysql> >>> This device was first added while I was running v0.13.5.3992. >>> I upgraded to 4027, deleted and rediscovered and the above output is >>> from the 4027 -d output. >>> Anything else I can try to help? >>> PS. I just checked back and I have another device that is having the >>> same issue. It's not an ME3600, it's a C4500 and among many others >>> running the same OS, same HW configuration, etc. >>> On 2013-05-18, at 4:46 PM, observium(a)velder.li wrote: >>> Tested it. All new added devices on my observium aren't polled. Test Install, it works. Strange. >>> btw, where is the map? >>> regards >>> Am 17.05.2013 19:38, schrieb observium(a)velder.li: >>> Tried multiple devices. Still exists. Will try a fresh installation of >>> observium tonight. >>> Am 17.05.2013 15:13, schrieb Adam Armstrong: >>> There are no issues with that SQL query, so I'm not sure where the >>> problem could be. >>> adam. >>> On 2013-05-16 21:10, observium(a)velder.li wrote: >>> Hi Adam >>> Thx for your answer. >>> Output: >>> SQL[UPDATE `devices` set `uptime` ='7915',`sysObjectID` >>> ='.1.3.6.1.4.1.8072.3.2.10',`sysDescr` ='Linux ns3 3.2.0-4-amd64 #1 >>> SMP Debian 3.2.41-2+deb7u2 x86_64',`location_geoapi` >>> ='mapquest',`location_lat` ='33.7490987',`location_lon` >>> ='-84.3901849',`location_city` ='Atlanta',`location_county` ='Fulton >>> County',`location_state` ='Georgia',`location_country` ='us',`version` >>> ='3.2.0-4-amd64',`features` ='Debian 7.0',`hardware` ='Generic x86 >>> 64-bit',`last_polled` =NOW(),`last_polled_timetaken` >>> ='85.83',`device_state` >>> ='a:2:{s:7:\"ucd_mem\";a:7:{s:10:\"swap_total\";s:6:\"522236\";s:10:\"swap_avail\";s:6:\"521932\";s:9:\"mem_total\";s:6:\"250904\";s:9:\"mem_avail\";s:5:\"17104\";s:10:\"mem_shared\";s:1:\"0\";s:10:\"mem_buffer\";s:5:\"18036\";s:10:\"mem_cached\";s:6:\"160488\";}s:8:\"ucd_load\";s:1:\"1\";}' >>> WHERE `device_id` = '55'] >>> SQL[INSERT INTO `perf_times` >>> (`type`,`doing`,`start`,`duration`,`devices`) VALUES >>> ('poll','ns3.mydomain.li','1368734745.1935','85.83','1')] ./poller.php >>> ns3.mydomain.li May 16, 2013, 22:07 - 1 devices polled in 85.83 secs >>> But it still shows not polled yet. Any Idea? >>> Regards >>> Patrick >>> Am 16.05.2013 21:38, schrieb Adam Armstrong: >>> This is definitely a bug. >>> It's failing to update the device record for some reason. >>> Run : >>> ./poller.php -h <host> -d >>> there will be a SQL query towards the end which is trying to update >>> the location and set the last_polled time. This might help explain why >>> it's failing. >>> adam. >>> On 2013-05-16 20:25, observium(a)velder.li wrote: >>> Hello there >>> i changed a complete device (hostname is the same, but different >>> location). Location was not updated. Hmmm, ok, i deleted the device, >>> rm -r'ed rrd dir and re-added the device. Now it says >>> Device not yet polled >>> That's not correct. Device is polled. And the LocationBar does not >>> update the locations. There's only UNKNOWN (1). >>> Bug or my problem? >>> Regards, >>> patrick >>> _______________________________________________ >>> observium mailing list >>> observium(a)observium.org >>> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium >>> _______________________________________________ >>> observium mailing list >>> observium(a)observium.org >>> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium >>> _______________________________________________ >>> observium mailing list >>> observium(a)observium.org >>> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium >>> _______________________________________________ >>> observium mailing list >>> observium(a)observium.org >>> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium >>> _______________________________________________ >>> observium mailing list >>> observium(a)observium.org >>> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium >>> _______________________________________________ >>> observium mailing list >>> observium(a)observium.org >>> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium >>> _______________________________________________ >>> observium mailing list >>> observium(a)observium.org >>> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium >> _______________________________________________ >> observium mailing list >> observium(a)observium.org >> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium > >_______________________________________________ >observium mailing list >observium(a)observium.org >http://postman.memetic.org/cgi-bin/mailman/listinfo/observium

2 3

Re: [Observium] Device not yet polled?
by Adam Armstrong 19 May '13

19 May '13

You seem to be missing database fields which you should not be missing. I'll check the definition files and make another sql update if needed. Adam. Jason Lixfeld <jason(a)lixfeld.ca> wrote: >Indeed. > >ERROR 1054 (42S22): Unknown column 'location_geoapi' in 'field list' > >Sooo... was this me thinking that I actually did run './discovery.php -h new' after one of my updates when in fact I was dreaming it?? > >I was damn sure that I ran that, and made sure I ran it after the upgrade to 4027. Would that not have cleared it if I had forgotten to run it at some point prior? Or do I have to svn back to 3992, run discovery -h new, then upgrade to 4027 again and run discovery -h new again? > >On 2013-05-19, at 10:50 AM, Adam Armstrong <adama(a)memetic.org> wrote: > >> Do you get an error if you try to run the query by hand? >> >> The UPDATE query between SQL[]. >> >> adam. >> >> On 2013-05-19 15:19, Jason Lixfeld wrote: >>> I'm having a similar issue, but this particular device is brand new >>> and had nothing to do with maps. >>> Device information only shows "Cisco IOS" where other devices of the >>> same hardware type running the same OS all show their Device >>> Information just fine. >>> I've tried to delete the device and let it get re-polled, with no difference. >>> I should be clear - all other Observium behaviour on the device is >>> fine, just that Device Information stuff seems to be stuck... >>> Here's the same outpot from ./poller -h ... -d >>> SQL[UPDATE `devices` set `uptime` ='154877',`sysObjectID` >>> ='.1.3.6.1.4.1.9.1.1250',`sysName` ='pe01.2bloorstw01.yyz',`sysDescr` >>> ='Cisco IOS Software, ME360x Software (ME360x-UNIVERSAL-M), Version >>> 15.3(2)S, RELEASE SOFTWARE (fc1)\r\nTechnical Support: >>> http://www.cisco.com/techsupport\r\nCopyright (c) 1986-2013 by Cisco >>> Systems, Inc.\r\nCompiled Mon 25-Mar-13 12:58 by >>> prod_rel_team',`location_geoapi` ='mapquest',`location_lat` >>> ='37.7463058',`location_lon` ='-25.6668573',`location_city` >>> ='Unknown',`location_county` ='Unknown',`location_state` >>> ='Unknown',`location_country` ='Unknown',`version` >>> ='15.3(2)S',`features` ='UNIVERSAL',`hardware` >>> ='ciscoMe3600x24fsM',`last_polled` =NOW(),`last_polled_timetaken` >>> ='2.832',`device_state` ='N;' WHERE `device_id` = '182'] >>> SQL[INSERT INTO `perf_times` >>> (`type`,`doing`,`start`,`duration`,`devices`) VALUES >>> ('poll','pe01.2bloorstw01.yyz','1368972218.5967','2.912','1')] >>> ./poller.php pe01.2bloorstw01.yyz May 19, 2013, 10:03 - 1 devices >>> polled in 2.912 secs >>> The database, however, is missing much of this.. >>> mysql> select * from devices where sysname = 'pe01.2bloorstw01.yyz'; >>> +-----------+----------------------+----------------------+-----------+-----------+----------+----------+----------+------------+------------+---------+------+-----------+---------+---------+----------+------------+-------------+----------+------------+---------+----------+----------+----------+------+--------+--------+----------+--------+--------------+-------------+-----------------------+---------------------------+---------------------+---------+---------+--------+------+ >>> | device_id | hostname | sysName | community >>> | authlevel | authname | authpass | authalgo | cryptopass | cryptoalgo >>> | snmpver | port | transport | timeout | retries | ssh_port | >>> bgpLocalAs | sysObjectID | sysDescr | sysContact | version | hardware >>> | features | location | os | status | ignore | disabled | uptime | >>> agent_uptime | last_polled | last_polled_timetaken | >>> last_discovered_timetaken | last_discovered | purpose | type | >>> serial | icon | >>> +-----------+----------------------+----------------------+-----------+-----------+----------+----------+----------+------------+------------+---------+------+-----------+---------+---------+----------+------------+-------------+----------+------------+---------+----------+----------+----------+------+--------+--------+----------+--------+--------------+-------------+-----------------------+---------------------------+---------------------+---------+---------+--------+------+ >>> | 182 | pe01.2bloorstw01.yyz | pe01.2BloorStW01.YYZ | public >>> | NULL | NULL | NULL | NULL | NULL | NULL >>> | v2c | 161 | udp | NULL | NULL | 22 | 21949 >>> | NULL | NULL | | NULL | NULL | NULL >>> | | ios | 1 | 0 | 0 | NULL | 0 >>> | NULL | NULL | 1.91 | >>> 2013-05-19 09:08:43 | NULL | network | NULL | NULL | >>> +-----------+----------------------+----------------------+-----------+-----------+----------+----------+----------+------------+------------+---------+------+-----------+---------+---------+----------+------------+-------------+----------+------------+---------+----------+----------+----------+------+--------+--------+----------+--------+--------------+-------------+-----------------------+---------------------------+---------------------+---------+---------+--------+------+ >>> 1 row in set (0.00 sec) >>> mysql> >>> This device was first added while I was running v0.13.5.3992. >>> I upgraded to 4027, deleted and rediscovered and the above output is >>> from the 4027 -d output. >>> Anything else I can try to help? >>> PS. I just checked back and I have another device that is having the >>> same issue. It's not an ME3600, it's a C4500 and among many others >>> running the same OS, same HW configuration, etc. >>> On 2013-05-18, at 4:46 PM, observium(a)velder.li wrote: >>> Tested it. All new added devices on my observium aren't polled. Test Install, it works. Strange. >>> btw, where is the map? >>> regards >>> Am 17.05.2013 19:38, schrieb observium(a)velder.li: >>> Tried multiple devices. Still exists. Will try a fresh installation of >>> observium tonight. >>> Am 17.05.2013 15:13, schrieb Adam Armstrong: >>> There are no issues with that SQL query, so I'm not sure where the >>> problem could be. >>> adam. >>> On 2013-05-16 21:10, observium(a)velder.li wrote: >>> Hi Adam >>> Thx for your answer. >>> Output: >>> SQL[UPDATE `devices` set `uptime` ='7915',`sysObjectID` >>> ='.1.3.6.1.4.1.8072.3.2.10',`sysDescr` ='Linux ns3 3.2.0-4-amd64 #1 >>> SMP Debian 3.2.41-2+deb7u2 x86_64',`location_geoapi` >>> ='mapquest',`location_lat` ='33.7490987',`location_lon` >>> ='-84.3901849',`location_city` ='Atlanta',`location_county` ='Fulton >>> County',`location_state` ='Georgia',`location_country` ='us',`version` >>> ='3.2.0-4-amd64',`features` ='Debian 7.0',`hardware` ='Generic x86 >>> 64-bit',`last_polled` =NOW(),`last_polled_timetaken` >>> ='85.83',`device_state` >>> ='a:2:{s:7:\"ucd_mem\";a:7:{s:10:\"swap_total\";s:6:\"522236\";s:10:\"swap_avail\";s:6:\"521932\";s:9:\"mem_total\";s:6:\"250904\";s:9:\"mem_avail\";s:5:\"17104\";s:10:\"mem_shared\";s:1:\"0\";s:10:\"mem_buffer\";s:5:\"18036\";s:10:\"mem_cached\";s:6:\"160488\";}s:8:\"ucd_load\";s:1:\"1\";}' >>> WHERE `device_id` = '55'] >>> SQL[INSERT INTO `perf_times` >>> (`type`,`doing`,`start`,`duration`,`devices`) VALUES >>> ('poll','ns3.mydomain.li','1368734745.1935','85.83','1')] ./poller.php >>> ns3.mydomain.li May 16, 2013, 22:07 - 1 devices polled in 85.83 secs >>> But it still shows not polled yet. Any Idea? >>> Regards >>> Patrick >>> Am 16.05.2013 21:38, schrieb Adam Armstrong: >>> This is definitely a bug. >>> It's failing to update the device record for some reason. >>> Run : >>> ./poller.php -h <host> -d >>> there will be a SQL query towards the end which is trying to update >>> the location and set the last_polled time. This might help explain why >>> it's failing. >>> adam. >>> On 2013-05-16 20:25, observium(a)velder.li wrote: >>> Hello there >>> i changed a complete device (hostname is the same, but different >>> location). Location was not updated. Hmmm, ok, i deleted the device, >>> rm -r'ed rrd dir and re-added the device. Now it says >>> Device not yet polled >>> That's not correct. Device is polled. And the LocationBar does not >>> update the locations. There's only UNKNOWN (1). >>> Bug or my problem? >>> Regards, >>> patrick >>> _______________________________________________ >>> observium mailing list >>> observium(a)observium.org >>> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium >>> _______________________________________________ >>> observium mailing list >>> observium(a)observium.org >>> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium >>> _______________________________________________ >>> observium mailing list >>> observium(a)observium.org >>> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium >>> _______________________________________________ >>> observium mailing list >>> observium(a)observium.org >>> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium >>> _______________________________________________ >>> observium mailing list >>> observium(a)observium.org >>> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium >>> _______________________________________________ >>> observium mailing list >>> observium(a)observium.org >>> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium >>> _______________________________________________ >>> observium mailing list >>> observium(a)observium.org >>> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium >> _______________________________________________ >> observium mailing list >> observium(a)observium.org >> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium > >_______________________________________________ >observium mailing list >observium(a)observium.org >http://postman.memetic.org/cgi-bin/mailman/listinfo/observium

1 0

Re: [Observium] Device not yet polled?
by Adam Armstrong 19 May '13

19 May '13

The fuck. observium(a)velder.li wrote: >Hmm.. > >Here it is >-- >#1054 - Unknown column 'sysObjectID' in 'field list' >-- > > >discovery does not help. Any ideas? > > >Regards >Patrick > > >Am 19.05.2013 18:43, schrieb Adam Armstrong: >> Agh. >> >> Jason Lixfeld <jason(a)lixfeld.ca> wrote: >> >> Indeed. >> >> ERROR 1054 (42S22): Unknown column 'location_geoapi' in 'field list' >> >> Sooo... was this me thinking that I actually did run './discovery.php >> -h new' after one of my updates when in fact I was dreaming it?? >> >> I was damn sure that I ran that, and made sure I ran it after the >> upgrade to 4027. Would that not have cleared it if I had forgotten to >> run it at some point prior? Or do I have to svn back to 3992, run >> discovery -h new, then upgrade to 4027 again and run discovery -h new >> again? >> >> On 2013-05-19, at 10:50 AM, Adam Armstrong <adama(a)memetic.org> wrote: >> >> Do you get an error if you try to run the query by hand? >> >> The UPDATE query between SQL[]. >> >> adam. >> >> On 2013-05-19 15:19, Jason Lixfeld wrote: >> I'm having a similar issue, but this particular device is brand new >> and had nothing to do with maps. >> Device information only shows "Cisco IOS" where other devices of the >> same hardware type running the same OS all show their Device >> Information just fine. >> I've tried to delete the device and let it get re-polled, with no >> difference. >> I should be clear - all other Observium behaviour on the device is >> fine, just that Device Information stuff seems to be stuck... >> Here's the same outpot from ./poller -h ... -d >> SQL[UPDATE `devices` set `uptime` ='154877',`sysObjectID` >> ='.1.3.6.1.4.1.9.1.1250',`sysName` ='pe01.2bloorstw01.yyz',`sysDescr` >> ='Cisco IOS Software, ME360x Software (ME360x-UNIVERSAL-M), Version >> 15.3(2)S, RELEASE SOFTWARE (fc1)\r\nTechnical Support: >> http://www.cisco.com/techsupport\r\nCopyright (c) 1986-2013 by Cisco >> Systems, Inc.\r\nCompiled Mon 25-Mar-13 12:58 by >> prod_rel_team',`location_geoapi` ='mapquest',`location_lat` >> ='37.7463058',`location_lon` ='-25.6668573',`location_city` >> ='Unknown',`location_county` ='Unknown',`location_state` >> ='Unknown',`location_country` ='Unknown',`version` >> ='15.3(2)S',`features` ='UNIVERSAL',`hardware` >> ='ciscoMe3600x24fsM',`last_polled` =NOW(),`last_polled_timetaken` >> ='2.832',`device_state` ='N;' WHERE `device_id` = '182'] >> SQL[INSERT INTO `perf_times` >> (`type`,`doing`,`start`,`duration`,`devices`) VALUES >> ('poll','pe01.2bloorstw01.yyz','1368972218.5967','2.912','1')] >> ./poller.php pe01.2bloorstw01.yyz May 19, 2013, 10:03 - 1 devices >> polled in 2.912 secs >> The database, however, is missing much of this.. >> mysql> select * from devices where sysname = 'pe01.2bloorstw01.yyz'; >> +-----------+----------------------+----------------------+-----------+-----------+----------+----------+----------+------------+------------+---------+------+-----------+---------+---------+----------+------------+-------------+----------+------------+---------+----------+----------+----------+------+--------+--------+----------+--------+--------------+-------------+-----------------------+---------------------------+---------------------+---------+---------+--------+------+ >> | device_id | hostname | sysName | community >> | authlevel | authname | authpass | authalgo | cryptopass | cryptoalgo >> | snmpver | port | transport | timeout | retries | ssh_port | >> bgpLocalAs | sysObjectID | sysDescr | sysContact | version | hardware >> | features | location | os | status | ignore | disabled | uptime | >> agent_uptime | last_polled | last_polled_timetaken | >> last_discovered_timetaken | last_discovered | purpose | type | >> serial | icon | >> +-----------+----------------------+----------------------+-----------+-----------+----------+----------+----------+------------+------------+---------+------+-----------+---------+---------+----------+------------+-------------+----------+------------+---------+----------+----------+----------+------+--------+--------+----------+--------+--------------+-------------+-----------------------+---------------------------+---------------------+---------+---------+--------+------+ >> | 182 | pe01.2bloorstw01.yyz | pe01.2BloorStW01.YYZ | public >> | NULL | NULL | NULL | NULL | NULL | NULL >> | v2c | 161 | udp | NULL | NULL | 22 | 21949 >> | NULL | NULL | | NULL | NULL | NULL >> | | ios | 1 | 0 | 0 | NULL | 0 >> | NULL | NULL | 1.91 | >> 2013-05-19 09:08:43 | NULL | network | NULL | NULL | >> +-----------+----------------------+----------------------+-----------+-----------+----------+----------+----------+------------+------------+---------+------+-----------+---------+---------+----------+------------+-------------+----------+------------+---------+----------+----------+----------+------+--------+--------+----------+--------+--------------+-------------+-----------------------+---------------------------+---------------------+---------+---------+--------+------+ >> 1 row in set (0.00 sec) >> mysql> >> This device was first added while I was running v0.13.5.3992. >> I upgraded to 4027, deleted and rediscovered and the above output is >> from the 4027 -d output. >> Anything else I can try to help? >> PS. I just checked back and I have another device that is having the >> same issue. It's not an ME3600, it's a C4500 and among many others >> running the same OS, same HW configuration, etc. >> On 2013-05-18, at 4:46 PM, observium(a)velder.li wrote: >> Tested it. All new added devices on my observium aren't polled. Test >> Install, it works. Strange. >> btw, where is the map? >> regards >> Am 17.05.2013 19:38, schrieb observium(a)velder.li: >> Tried multiple devices. Still exists. Will try a fresh installation of >> observium tonight. >> Am 17.05.2013 15:13, schrieb Adam Armstrong: >> There are no issues with that SQL query, so I'm not sure where the >> problem could be. >> adam. >> On 2013-05-16 21:10, observium(a)velder.li wrote: >> Hi Adam >> Thx for your answer. >> Output: >> SQL[UPDATE `devices` set `uptime` ='7915',`sysObjectID` >> ='.1.3.6.1.4.1.8072.3.2.10',`sysDescr` ='Linux ns3 3.2.0-4-amd64 #1 >> SMP Debian 3.2.41-2+deb7u2 x86_64',`location_geoapi` >> ='mapquest',`location_lat` ='33.7490987',`location_lon` >> ='-84.3901849',`location_city` ='Atlanta',`location_county` ='Fulton >> County',`location_state` ='Georgia',`location_country` ='us',`version` >> ='3.2.0-4-amd64',`features` ='Debian 7.0',`hardware` ='Generic x86 >> 64-bit',`last_polled` =NOW(),`last_polled_timetaken` >> ='85.83',`device_state` >> ='a:2:{s:7:\"ucd_mem\";a:7:{s:10:\"swap_total\";s:6:\"522236\";s:10:\"swap_avail\";s:6:\"521932\";s:9:\"mem_total\";s:6:\"250904\";s:9:\"mem_avail\";s:5:\"17104\";s:10:\"mem_shared\";s:1:\"0\";s:10:\"mem_buffer\";s:5:\"18036\";s:10:\"mem_cached\";s:6:\"160488\";}s:8:\"ucd_load\";s:1:\"1\";}' >> WHERE `device_id` = '55'] >> SQL[INSERT INTO `perf_times` >> (`type`,`doing`,`start`,`duration`,`devices`) VALUES >> ('poll','ns3.mydomain.li','1368734745.1935','85.83','1')] ./poller.php >> ns3.mydomain.li May 16, 2013, 22:07 - 1 devices polled in 85.83 secs >> But it still shows not polled yet. Any Idea? >> Regards >> Patrick >> Am 16.05.2013 21:38, schrieb Adam Armstrong: >> This is definitely a bug. >> It's failing to update the device record for some reason. >> Run : >> ./poller.php -h <host> -d >> there will be a SQL query towards the end which is trying to update >> the location and set the last_polled time. This might help explain why >> it's failing. >> adam. >> On 2013-05-16 20:25, observium(a)velder.li wrote: >> Hello there >> i changed a complete device (hostname is the same, but different >> location). Location was not updated. Hmmm, ok, i deleted the device, >> rm -r'ed rrd dir and re-added the device. Now it says >> Device not yet polled >> That's not correct. Device is polled. And the LocationBar does not >> update the locations. There's only UNKNOWN (1). >> Bug or my problem? >> Regards, >> patrick >> _______________________________________________ >> observium mailing list >> observium(a)observium.org >> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium >> _______________________________________________ >> observium mailing list >> observium(a)observium.org >> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium >> _______________________________________________ >> observium mailing list >> observium(a)observium.org >> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium >> _______________________________________________ >> observium mailing list >> observium(a)observium.org >> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium >> _______________________________________________ >> observium mailing list >> observium(a)observium.org >> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium >> _______________________________________________ >> observium mailing list >> observium(a)observium.org >> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium >> _______________________________________________ >> observium mailing list >> observium(a)observium.org >> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium >> _______________________________________________ >> observium mailing list >> observium(a)observium.org >> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium >> >> _______________________________________________ >> observium mailing list >> observium(a)observium.org >> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium >> _______________________________________________ >> observium mailing list >> observium(a)observium.org >> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium >_______________________________________________ >observium mailing list >observium(a)observium.org >http://postman.memetic.org/cgi-bin/mailman/listinfo/observium

1 0

Re: [Observium] snmpwalk v snmpbulkwalk
by Adam Armstrong 19 May '13

19 May '13

It's using bulkwalk, unless the device is set to snmpv1 Adam. Michael H Lambert <lambert(a)psc.edu> wrote: >How do I tell whether the poller is using snmpwalk or snmpbulkwalk for a given device? > >Thanks, > >Michael > >_______________________________________________ >observium mailing list >observium(a)observium.org >http://postman.memetic.org/cgi-bin/mailman/listinfo/observium

2 1

snmpwalk v snmpbulkwalk
by Michael H Lambert 19 May '13

19 May '13

How do I tell whether the poller is using snmpwalk or snmpbulkwalk for a given device? Thanks, Michael

1 0

Re: [Observium] Device not yet polled?
by Adam Armstrong 19 May '13

19 May '13

The map is not enabled as default. Check the config documentation on the site. If your main installation's database is desynced, you could just delete it and read all the hosts. Adam. observium(a)velder.li wrote: >Tested it. All new added devices on my observium aren't polled. Test >Install, it works. Strange. > >btw, where is the map? > >regards > > >Am 17.05.2013 19:38, schrieb observium(a)velder.li: >> Tried multiple devices. Still exists. Will try a fresh installation of >> observium tonight. >> >> >> >> >> Am 17.05.2013 15:13, schrieb Adam Armstrong: >> There are no issues with that SQL query, so I'm not sure where the >> problem could be. >> >> adam. >> >> On 2013-05-16 21:10, observium(a)velder.li wrote: >> Hi Adam >> >> Thx for your answer. >> >> Output: >> >> >> SQL[UPDATE `devices` set `uptime` ='7915',`sysObjectID` >> ='.1.3.6.1.4.1.8072.3.2.10',`sysDescr` ='Linux ns3 3.2.0-4-amd64 #1 >> SMP Debian 3.2.41-2+deb7u2 x86_64',`location_geoapi` >> ='mapquest',`location_lat` ='33.7490987',`location_lon` >> ='-84.3901849',`location_city` ='Atlanta',`location_county` ='Fulton >> County',`location_state` ='Georgia',`location_country` ='us',`version` >> ='3.2.0-4-amd64',`features` ='Debian 7.0',`hardware` ='Generic x86 >> 64-bit',`last_polled` =NOW(),`last_polled_timetaken` >> ='85.83',`device_state` >> ='a:2:{s:7:\"ucd_mem\";a:7:{s:10:\"swap_total\";s:6:\"522236\";s:10:\"swap_avail\";s:6:\"521932\";s:9:\"mem_total\";s:6:\"250904\";s:9:\"mem_avail\";s:5:\"17104\";s:10:\"mem_shared\";s:1:\"0\";s:10:\"mem_buffer\";s:5:\"18036\";s:10:\"mem_cached\";s:6:\"160488\";}s:8:\"ucd_load\";s:1:\"1\";}' >> WHERE `device_id` = '55'] >> SQL[INSERT INTO `perf_times` >> (`type`,`doing`,`start`,`duration`,`devices`) VALUES >> ('poll','ns3.mydomain.li','1368734745.1935','85.83','1')] ./poller.php >> ns3.mydomain.li May 16, 2013, 22:07 - 1 devices polled in 85.83 secs >> >> >> >> >> But it still shows not polled yet. Any Idea? >> >> >> >> Regards >> Patrick >> >> >> Am 16.05.2013 21:38, schrieb Adam Armstrong: >> This is definitely a bug. >> >> It's failing to update the device record for some reason. >> >> Run : >> >> ./poller.php -h <host> -d >> >> there will be a SQL query towards the end which is trying to update >> the location and set the last_polled time. This might help explain why >> it's failing. >> >> adam. >> >> On 2013-05-16 20:25, observium(a)velder.li wrote: >> Hello there >> >> i changed a complete device (hostname is the same, but different >> location). Location was not updated. Hmmm, ok, i deleted the device, >> rm -r'ed rrd dir and re-added the device. Now it says >> >> Device not yet polled >> >> That's not correct. Device is polled. And the LocationBar does not >> update the locations. There's only UNKNOWN (1). >> >> Bug or my problem? >> >> >> Regards, >> patrick >> _______________________________________________ >> observium mailing list >> observium(a)observium.org >> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium >> _______________________________________________ >> observium mailing list >> observium(a)observium.org >> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium >> _______________________________________________ >> observium mailing list >> observium(a)observium.org >> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium >> _______________________________________________ >> observium mailing list >> observium(a)observium.org >> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium >> _______________________________________________ >> observium mailing list >> observium(a)observium.org >> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium >_______________________________________________ >observium mailing list >observium(a)observium.org >http://postman.memetic.org/cgi-bin/mailman/listinfo/observium

1 0