- observium - lists.observium.org

Queries printing on page
by Patmore, Gregory 16 Jan '14

16 Jan '14

Hi all, I’m working on setting up observium/open source edition, and when I load any of the web pages within the GUI I am seeing the SQL queries getting printed to the web page. Has anyone else ran into this issue? If so, any fix? Thanks for any help/advice in advance. - Gregory Patmore Systems Administrator clearchannel digital gregorypatmore(a)clearchannel.com<applewebdata://60628E97-6F4E-4D45-AB1C-5E7C8440B2EA/johnderagon@clearchannel.com> 32 Avenue of the Americas, 4th floor new york, ny 10013

2 1

To modify the general info of an alert checker
by BERTRAND Adrien [BPCE Assurances] 15 Jan '14

15 Jan '14

Hi, It seems that we can't modify some information on an alert checker (via the web interface) like : - The name of the checker - The message (for the description) - The delay All the other boxes have a modify and a delete button but not for this one. I'm up to date (0.14.1.4883) via the subscription edition of Observium. Keep in touch, Adrien BERTRAND Administrateur Sécurité du Système d'Information Information security administrator BPCE Assurances 88 av. de France, 75013 Paris Tel : (+33)1.42.79.47.81 [Description : Q_BPCE_Assurances.jpg]

1 0

Data Fetch Failure
by Shaun Bradley 15 Jan '14

15 Jan '14

Hi all, I've gone through the normal procedure for getting the observium_agent working for mysql and apache, but even though I've added the config values to the http.conf (centos) I get a data fetch failure when running the apache script manually. MySQL one works fine. I'm at a loss to what it is as I can retrieve the URL in the apache script manually also. Thanks, Shaun

1 0

Poller hung by misbehaving device/net-snmp
by Adam Bishop 14 Jan '14

14 Jan '14

Hello, One of the devices I'm polling began misbehaving (its SNMP stack couldn't cope with uptime > 4294967296 seconds). This caused the Observium poller to hang indefinitely. The underlying cause seems to be an issue with net-snmp, however this did cause other devices to not be polled and eventually exhausted the file descriptor limit (at which point, several thousand php processes were running). I'm not sure of the best way to protect observium from net-snmp failing; as a very dirty hack I've replaced the following line in the config: - $config['snmpget'] = "/usr/bin/snmpget"; + $config['snmpget'] = "/usr/bin/timeout 1m /usr/bin/snmpget"; I also tried setting snmpget's -t option, but this did not have an effect. This is on the community version, but I believe the subscription version would be affected too (I've not seen anything in the change logs that would indicate otherwise). For completeness, a not-very-interesting poller trace follows. Hope this is useful, Adam Bishop gpg: 0x6609D460 Janet, the UK's research and education network. Without timeout: ------------------------------------------------ DEBUG! Observium v0.13.10.4586 Poller Starting polling run: SQL[SELECT `device_id` FROM `devices` WHERE `disabled` = 0 AND `hostname` LIKE 'atlas_1r' ORDER BY `device_id` ASC] SQL[SELECT * FROM `devices` WHERE `device_id` = '11'] SQL[SELECT * FROM devices_attribs WHERE `device_id` = '11'] SQL[SELECT * FROM `alert_tests` WHERE 1] SQL[SELECT *,`alert_table`.`alert_table_id` AS `alert_table_id` FROM `alert_table` LEFT JOIN `alert_table-state` ON `alert_table`.`alert_table_id` = `alert_table-state`.`alert_table_id` WHERE `device_id` = '11'] Array ( ) Array ( ) atlas_1r 11 apc DEBUG: SNMP Auth options = -v3 -l 'authNoPriv' -n "" -a 'MD5' -A '<snip>' -u 'observium' /usr/bin/snmpget -v3 -l 'authNoPriv' -n "" -a 'MD5' -A '<snip>' -u 'observium' -Oqv -m SNMPv2-MIB -M /opt/observium/mibs 'udp':'atlas_1r':'161' sysObjectID.0 With timeout: DEBUG! Observium v0.13.10.4586 Poller Starting polling run: SQL[SELECT `device_id` FROM `devices` WHERE `disabled` = 0 AND `hostname` LIKE 'atlas_1r' ORDER BY `device_id` ASC] SQL[SELECT * FROM `devices` WHERE `device_id` = '11'] SQL[SELECT * FROM devices_attribs WHERE `device_id` = '11'] SQL[SELECT * FROM `alert_tests` WHERE 1] SQL[SELECT *,`alert_table`.`alert_table_id` AS `alert_table_id` FROM `alert_table` LEFT JOIN `alert_table-state` ON `alert_table`.`alert_table_id` = `alert_table-state`.`alert_table_id` WHERE `device_id` = '11'] Array ( ) Array ( ) atlas_1r 11 apc DEBUG: SNMP Auth options = -v3 -l 'authNoPriv' -n "" -a 'MD5' -A '<snip>' -u 'observium' /usr/bin/snmpget -v3 -l 'authNoPriv' -n "" -a 'MD5' -A '<snip>' -u 'observium' -Oqv -m SNMPv2-MIB -M /opt/observium/mibs 'udp':'atlas_1r':'161' sysObjectID.0 SNMP Unreachable SQL[UPDATE `devices` set `status` ='0' WHERE device_id='11'] SQL[INSERT INTO `alerts` (`importance`,`device_id`,`message`) VALUES ('0','11','Device is down')] SQL[INSERT INTO `eventlog` (`device_id`,`reference`,`type`,`timestamp`,`message`) VALUES ('11','NULL','system',NOW(),'Device status changed to Down (snmp)')] RRD[cmd[update /opt/observium/rrd/atlas_1r/status.rrd N:0] stdout[] stderr[]] RRD[cmd[update /opt/observium/rrd/atlas_1r/ping.rrd N:6.02] stdout[] stderr[]] RRD[cmd[update /opt/observium/rrd/atlas_1r/ping_snmp.rrd N:U] stdout[] stderr[]] SQL[INSERT INTO `perf_times` (`type`,`doing`,`start`,`duration`,`devices`) VALUES ('poll','atlas_1r','1389715032.3017','60.58','1')] /opt/observium/poller.php atlas_1r January 14, 2014, 15:58 - 1 devices polled in 60.58 secs MySQL: Cell[0/0s] Row[1/0s] Rows[3/0s] Column[0/0s] Update[1/0.03s] Insert[3/0.03s] Delete[0/0s] Janet(UK) is a trading name of Jisc Collections and Janet Limited, a not-for-profit company which is registered in England under No. 2881024 and whose Registered Office is at Lumen House, Library Avenue, Harwell Oxford, Didcot, Oxfordshire. OX11 0SG. VAT No. 614944238

2 2

syslog search
by Carlos Martinez 14 Jan '14

14 Jan '14

Is there a way to search all syslogs for all devices at the same time? I had a network interruption at a particular time and I would love to go a page and put in the time frame and see all syslog messages from everything monitored in a given location to see what happened. ________________________________ This message may contain confidential or privileged information. If you are not the intended recipient, please advise us immediately and delete this message. See http://www.datapipe.com/legal/email_disclaimer/ for further information on confidentiality and the risks of non-secure electronic communication. If you cannot access these links, please notify us by reply message and we will send the contents to you. Unless otherwise specified in a written agreement, this e-mail neither constitutes an agreement to conduct transactions by electronic means nor creates any legally binding contract or enforceable agreement.

1 0

TIA, I like to ask for help.
by tikastribe BidzPogPhodyMikeGyson 14 Jan '14

14 Jan '14

Hi Gurus, I'm not good in linux but my boss ask me to install observium in our RHEL box. I followed this link http://www.observium.org/wiki/RHEL_Installation#Introduction then I stop here. (I have a fresh install RHEL then i just follow everything) My comments are in open and closed parenthesis. Copy the default configuration file and edit it for your system: (I copy the config.php in my observium folder where the extracted folder was. Is this right?) cp config.php.default config.php Add an entry for fping to config.php as the location is different on RHEL: (I edit the copied file) $config['fping'] = "/usr/sbin/fping"; Edit config.php. Change the options to reflect your installation. Setup the MySQL database and insert the default schema: (I really stop here because when i type this in shell i had this error -bash: php: command not found) php includes/update/update.php It is OK to have some errors in the SQL revisions up to 006. Create the rrd directory to store RRDs in: (i dont know where to put this?) mkdir rrd chown apache:apache rrd Thank you and Regards,Michelle

2 1

Null data billing module API
by Daniel Rolfe 14 Jan '14

14 Jan '14

Hi all, I'm trying to port billing data out of observium via the simple API but I'm only getting null data as below: {"login":{"success":{"code":"101","msg":"User authentification succeeded"}},"data":[{"timestamp":null,"traf_total": null,"traf_in":null,"traf_out":null},{"timestamp":null," traf_total":null,"traf_in":null,"traf_out":null},{" timestamp":null,"traf_total":null,"traf_in":null,"traf_out" :null},{"timestamp":null,"traf_total":null,"traf_in":null,"traf_out":null} Any ideas on what could be causing this ? Regards, Daniel

2 4

Multiple communities/hosts for same IP address (localhost)
by Bogdan Ghita 13 Jan '14

13 Jan '14

Hello I'm trying to setup a monitoring system for two networks that have several devices each (mostly switches) behind a NAT router; unfortunately I am limited on the ports, so had to use SSH tunnelling from the Observium machine to each of the networks in order to access all the devices. I followed the instructions from http://vfamilyserver.org/blog/2013/03/snmp-hell-part-1-proxy-to-multiple-de… setup the SNMP proxying and it all works quite well, I can snmpwalk each of the devices behind one of the two NAT routers only by changing the community name (haven't yet setup the second one). However, I'm not sure how/if it's possible for Observium to see the different devices - I've added the NAT router with add_device.php (I used command line rather than web interface due to SNMP running over TCP) and was recorded as 127.0.0.1 (which does make sense, as it's the tunnelled from the local host); then, when I tried to run the command with one of the other community strings, it returned an "Already got device 127.0.0.1". Further, although I haven't yet set it up, I will probably have the same problem when adding the tunnelled NAT router on the second network. Is there a configuration/workaround that would allow to differentiate between these multiple instances of what appears to be the same [local]host? Best regards Bogdan

4 5

Re: [Observium] Sudden loss of history
by Adam Armstrong 12 Jan '14

12 Jan '14

3 3

Sudden loss of history
by Robert Williams 12 Jan '14

12 Jan '14

Hi Guys, At midnight last night during the normal scheduled re-discovery we appear to have lost all historic data for all ports on a large number of our switches. I’m still checking them all but it appears to have affected all Cisco 2960G units (24 or 48 port). Data collection is working fine, but all history has gone, including all CPU, RAM, temperatures, fans, RPS Power etc. [cid:image001.png@01CF0F7A.BD8E4C80] There are no Eventlog entries for the devices for the last 24 hours, but there are some from a couple of days ago which read like this: [cid:image002.png@01CF0F7B.7D5A55E0] However, as I mentioned these events are from the 9th so a few days ago. Any ideas please? I can restore the RRDs from backup but I’d like to know why it’s done this otherwise I’ll just be restoring them again tomorrow morning ☺ Cheers! Robert Williams Custodian Data Centre Email: Robert(a)CustodianDC.com http://www.CustodianDC.com

2 2