- observium - lists.observium.org

how to disable reading mac-address-table via snmp?
by norbi 21 May '13

21 May '13

hi List, how can i disable the reading of the entire mac-address-table from switches? problem is, we have about 4000 ports, 129 switches, and snmpbulkwalk needs about 22sec for one run, because the mac-address-table from uplinkports are to big. norbert

4 4

FDB Table
by Dario Calamai 21 May '13

21 May '13

Hi All! I have a new job in a new provider and Observium is up, again! :) my FDB Table is empty, still working in progress? I had a quick look to the code and I think that somethings in includes/polling/q-bridge-mib-fdb.inc.php have to be change for example dot1qTpFdbEntry is not working with my cisco 2960/3750, but dot1dTpFdbEntry does! [line 27] another example is that the function to search per-vlan mac-address is missing, now shows only the mac-addr in vlan1 [add "-c <community>@700" to snmpwalk command for vlan 700] Thanks, -- dario calamai http://www.linkedin.com/in/dariocalamai

2 1

Map Missing
by Wes Kennedy 21 May '13

21 May '13

I recently update to 4040 and now the map isn't showing up for me. Where do I go to enable it? -Wes

3 2

dell force10 s4810 mib and dell m1000e blade chassis
by Mihai - Cristian Satmarean 21 May '13

21 May '13

Dear all, please instruct me how to install the dell force 10 s4810 to be correctly discovered by observium, also the same problem with Dell blade chassis M1000e. Thank you!

5 15

Re: [Observium] <testing>
by Adam Armstrong 20 May '13

20 May '13

Idiot. Tyler Treat <tyler.treat(a)royell.org> wrote: >_______________________________________________ >observium mailing list >observium(a)observium.org >http://postman.memetic.org/cgi-bin/mailman/listinfo/observium

2 2

<testing>
by Tyler Treat 20 May '13

20 May '13

Test message. ___________________________ Tyler Treat ___________________________

1 0

Re: [Observium] IPMI Problems
by Adam Armstrong 20 May '13

20 May '13

Remove them with a SQL query on the event log table. :-) observium(a)velder.li wrote: >OK ;-) > >Last problem: tons of following entries in the log: > > >2013-05-19 19:35:24 System sysObjectID -> .1.3.6.1.4.1.8072.3.2.10 >2013-05-19 19:00:23 System sysObjectID -> .1.3.6.1.4.1.8072.3.2.10 >2013-05-19 18:55:24 System sysObjectID -> .1.3.6.1.4.1.8072.3.2.10 >2013-05-19 18:52:20 System sysObjectID -> .1.3.6.1.4.1.8072.3.2.10 >2013-05-19 18:50:23 System sysObjectID -> .1.3.6.1.4.1.8072.3.2.10 >2013-05-19 18:50:04 System sysObjectID -> .1.3.6.1.4.1.8072.3.2.10 >2013-05-19 18:47:52 System sysObjectID -> .1.3.6.1.4.1.8072.3.2.10 >2013-05-19 18:45:35 System sysObjectID -> .1.3.6.1.4.1.8072.3.2.10 >2013-05-19 18:45:25 System sysObjectID -> .1.3.6.1.4.1.8072.3.2.10 >2013-05-19 18:42:28 System sysObjectID -> .1.3.6.1.4.1.8072.3.2.10 >2013-05-19 18:40:24 System sysObjectID -> .1.3.6.1.4.1.8072.3.2.10 >2013-05-19 18:35:24 System sysObjectID -> .1.3.6.1.4.1.8072.3.2.10 > > > >Is there a possibility to hide them? > > >Regards > > > > >Am 20.05.2013 20:58, schrieb Adam Armstrong: >> The ipmi stuff is known to work about as well as a fire blanket made >> of paper. :-) >> >> Adam. >> >> observium(a)velder.li wrote: >> >> Hello there >> >> I just remembered that i cannot see any IPMI infos anymore in >> observium? >> There are also a lot of messages: >> >> 2013-05-20 20:55:06 vmhost01.dc System Sensor Deleted: fanspeed ipmi >> 4 FAN 2 >> 2013-05-20 20:55:06 vmhost01.dc System Sensor Deleted: fanspeed ipmi >> 3 FAN 1 >> 2013-05-20 20:55:06 vmhost01.dc System Sensor Deleted: fanspeed ipmi >> 5 FAN 3 >> 2013-05-20 20:55:06 vmhost01.dc System Sensor Deleted: fanspeed ipmi >> 7 FAN A >> 2013-05-20 20:55:06 vmhost01.dc System Sensor Deleted: temperature >> ipmi 1 System Temp >> 2013-05-20 20:55:06 vmhost01.dc System Sensor Deleted: voltage ipmi >> 8 >> Vcore >> 2013-05-20 20:55:06 vmhost01.dc System Sensor Deleted: voltage ipmi >> 9 >> 3.3VCC >> 2013-05-20 20:55:06 vmhost01.dc System Sensor Deleted: voltage ipmi >> 10 12V >> 2013-05-20 20:55:06 vmhost01.dc System Sensor Deleted: voltage ipmi >> 11 VDIMM >> 2013-05-20 20:55:06 vmhost01.dc System Sensor Deleted: voltage ipmi >> 16 AVCC >> 2013-05-20 20:55:06 vmhost01.dc System Sensor Deleted: voltage ipmi >> 15 VSB >> 2013-05-20 20:55:06 vmhost01.dc System Sensor Deleted: voltage ipmi >> 14 VBAT >> 2013-05-20 20:55:06 vmhost01.dc System Sensor Deleted: voltage ipmi >> 13 -12V >> 2013-05-20 20:55:06 vmhost01.dc System Sensor Deleted: voltage ipmi >> 12 5VCC >> 2013-05-20 20:55:06 vmhost01.dc System Sensor Added: voltage ipmi 16 >> AVCC >> >> >> Is that a known bug? >> >> 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

2 1

IPMI Problems
by observium＠velder.li 20 May '13

20 May '13

Hello there I just remembered that i cannot see any IPMI infos anymore in observium? There are also a lot of messages: 2013-05-20 20:55:06 vmhost01.dc System Sensor Deleted: fanspeed ipmi 4 FAN 2 2013-05-20 20:55:06 vmhost01.dc System Sensor Deleted: fanspeed ipmi 3 FAN 1 2013-05-20 20:55:06 vmhost01.dc System Sensor Deleted: fanspeed ipmi 5 FAN 3 2013-05-20 20:55:06 vmhost01.dc System Sensor Deleted: fanspeed ipmi 7 FAN A 2013-05-20 20:55:06 vmhost01.dc System Sensor Deleted: temperature ipmi 1 System Temp 2013-05-20 20:55:06 vmhost01.dc System Sensor Deleted: voltage ipmi 8 Vcore 2013-05-20 20:55:06 vmhost01.dc System Sensor Deleted: voltage ipmi 9 3.3VCC 2013-05-20 20:55:06 vmhost01.dc System Sensor Deleted: voltage ipmi 10 12V 2013-05-20 20:55:06 vmhost01.dc System Sensor Deleted: voltage ipmi 11 VDIMM 2013-05-20 20:55:06 vmhost01.dc System Sensor Deleted: voltage ipmi 16 AVCC 2013-05-20 20:55:06 vmhost01.dc System Sensor Deleted: voltage ipmi 15 VSB 2013-05-20 20:55:06 vmhost01.dc System Sensor Deleted: voltage ipmi 14 VBAT 2013-05-20 20:55:06 vmhost01.dc System Sensor Deleted: voltage ipmi 13 -12V 2013-05-20 20:55:06 vmhost01.dc System Sensor Deleted: voltage ipmi 12 5VCC 2013-05-20 20:55:06 vmhost01.dc System Sensor Added: voltage ipmi 16 AVCC Is that a known bug? Regards Patrick

1 0

snmp v3 device add failing
by Jacob Gardiner 20 May '13

20 May '13

I've got a juniper device i'm trying to add using snmpv3 but running into some issues when running the ./addhost.php script. I can poll the device from observium using snmpget/walk and can confirm that there's no firewalls or bad config on the router. (replaced hostname, community and password and aes below) # snmpget -v3 -u gops -A COMMUNITY -l authPriv -X PASS -x AES -a SHA my.juniper.router sysDescr.0 SNMPv2-MIB::sysDescr.0 = STRING: Juniper Networks, Inc. jsr4350 internet router, kernel JUNOS 10.1R2.8 #0: 2010-05-11 03:31:06 UTC builder@queth.juniper.net:/volume/build/junos/10.1/release/10.1R2.8/obj-i386/bsd/sys/compile/JSR Build date: 2010-05-11 03:18:36 UTC Copyright (c) 1996- Then, when running ./addhost.php: # ./addhost.php my.juniper.router COMMUNITY v3 gops PASS PASS sha aes 161 udp Trying v3 parameters observium/noAuthNoPriv ... No reply on credentials observium/noAuthNoPriv using v3 Could not reach my.juniper.router with given SNMP community using v3 Observium v0.13.5.4015 Add Host Tool -- Jacob Gardiner @jacobgardiner <http://twitter.com/jacobgardiner>

2 3

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

19 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

esx 5 server memory not showing
by Chip Gonzales 17 May '13

17 May '13

I have several ESX 5.0 servers that are successfully polling and returning data from CPU/Storage/VMs, however the system memory is not getting polled/graphed. This is running the discovery process with debugging: Memory : DEBUG: SNMP Auth options = -v2c -c alpha /usr/bin/snmpbulkwalk -v2c -c alpha -OQUs -m NETSWITCH-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/hp udp:flux:161 hpLocal hpLocalMem = No Such Instance currently exists at this OID DEBUG: SNMP Auth options = -v2c -c alpha /usr/bin/snmpbulkwalk -v2c -c alpha -OQUs -m NETSWITCH-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/hp udp:flux:161 hpGlobal hpGlobalMem = No Such Instance currently exists at this OID

3 4

Re: [Observium] NFS - APPS or nfsstat can be graphed with obserium?
by Adam Armstrong 17 May '13

17 May '13

Nfs requires the UNIX agent to be used on servers. Adam. Mihai - Cristian Satmarean <mihai.satmarean(a)gmail.com> wrote: >_______________________________________________ >observium mailing list >observium(a)observium.org >http://postman.memetic.org/cgi-bin/mailman/listinfo/observium

2 1

NFS - APPS or nfsstat can be graphed with obserium?
by Mihai - Cristian Satmarean 17 May '13

17 May '13

lately we have some huge NFS activity and we would like to have a way to record those things, I tired activating NFS in the server apps, but I have nothing there. Is there anything more that I need to do? Thank you!

1 0

Re: [Observium] [PATCH] Display mysql Processlist
by Adam Armstrong 17 May '13

17 May '13

I winder why this was missing... :-) Pieter De Wit <pieter(a)insync.za.net> wrote: >_______________________________________________ >observium mailing list >observium(a)observium.org >http://postman.memetic.org/cgi-bin/mailman/listinfo/observium

1 0

[PATCH] Display mysql Processlist
by Pieter De Wit 17 May '13

17 May '13

Hi Devs, Please can we add this to the "MySQL App System" tab (html/pages/device/apps/mysql.inc.php) Index: mysql.inc.php =================================================================== --- mysql.inc.php (revision 4017) +++ mysql.inc.php (working copy) @@ -9,6 +9,7 @@ $graphs['system'] = array( 'mysql_connections' => 'Connections', + 'mysql_status' => 'Process List', 'mysql_files_tables' => 'Files and Tables', 'mysql_myisam_indexes' => 'MyISAM Indexes', 'mysql_network_traffic' => 'Network Traffic', Credit to Benoit please :) Cheers, Pieter

1 0

Front page 'boxes' layout.
by Adam Armstrong 17 May '13

17 May '13

I've just re-added the old boxes status display to the front page. http://alpha.memetic.org/~adama/snaps/p64g472tda.png You can enable it by adding the new type, "device_status_boxes" to the $config['frontpage']['order'] array. adam.

1 0