- observium - lists.observium.org

Alerting - match multiple ASNs ?
by Robert Williams 10 Dec '15

10 Dec '15

Hi, What’s the correct syntax for an entity match which will match a selection of ASNs? I need an alert checker which will look for a specific set of ASNs and alert for any BGP session being not-up. Currently for our iBGP we use: [Conditions] bgpPeerState ne established bgpPeerAdminStatus notequals stop [Device] * [Entity Match] bgpPeerRemoteAs match <ourASN> This works perfectly. Now – what I’m after is that I need a new checker which will match eBGP ASNs like 174,3356,2914,5580 etc. all in one rule (the ‘important’ ASNs, for want of a better term). I have tried a selection of things but I’m obviously missing what the logical ‘or’ element should be in this case, as all my attempts at using multiple ASNs within a match just result in zero matches. Can someone point me in the right direction please? Cheers! Robert Williams Custodian Data Centre Email: Robert(a)CustodianDC.com http://www.CustodianDC.com

3 4

Clavister device as new OS
by Gregory Storme 10 Dec '15

10 Dec '15

Hi, I'm trying to add Clavister cOS as a supported OS, but without success.What I've done: - Edit includes/definitions/os.inc.php:$os = "clavister";$config['os'][$os]['vendor'] = "Clavister";$config['os'][$os]['text'] = "Clavister cOS";$config['os'][$os]['type'] = "network";$config['os'][$os]['icon'] = "clavister";$config['os'][$os]['graphs'][] = "device_bits";$config['os'][$os]['graphs'][] = "device_processor";$config['os'][$os]['graphs'][] = "device_mempool";$config['os'][$os]['sysObjectID'][] = ".1.3.6.1.4.1.5089.1";$config['os'][$os]['sysDescr'][] = "/^Clavister/";$config['os'][$os]['mibs'][] = "CLAVISTER-MIB";$config['os'][$os]['mibs'][] = "CLAVISTER-SMI-MIB"; - create includes/discovery/os/clavister.inc.php:<?php if (strstr($sysObjectId, ".1.3.6.1.4.1.5089.1")) { $os = "clavister"; } else if (preg_match("/^Clavister/", $sysDescr)) { $os = "clavister"; } - created the CLAVISTER-MIB & CLAVISTER-SMI-MIB (downloaded from the vendor website) under the mibs folder When I add such a device and run the discovery & poller, it seems as the Clavister MIBs are not used.The OS type is detected though? ##### devicename [338] ##### o OS clavister o Last poll duration 0.42 seconds o Last Polled 2015-12-10 01:28:30 o SNMP Version v2c o Device status Device is reachable by PING (0.36ms) and SNMP (7.20ms) o Modules Excluded ipmi, junose-atm-vp, cisco-ipsec-flow-monitor, cisco-remote-access-monitor, cisco-cef, arista-software-ip-forwarding,cipsec-tunnels, cisco-cbqos, cisco-eigrp, netscaler-vsvr, aruba-controller o Disabled Globally unix-agent, cisco-vpdn, wmi o Modules Enabled system, os, sensors, status, processors, mempools, storage, netstats, hr-mib, ucd-mib, ipSystemStats, ports, bgp-peers, toner,ucd-diskio, wifi, p2p-radios, ospf, sla, mac-accounting, loadbalancer, entity-physical, applications, fdb-table, graphs,oids ##### Module Start: system ##### o Uptime 8 days, 1h 57m 55s o sysObjectID .1.3.6.1.4.1.5089.1 o snmpEngineID o sysDescr Clavister cOS Core 10.21.02.01-25325 o sysName n/a o Location N/A o Module time 0.0578s ##### Module Start: os ##### o OS Poller Generic... What am I doing wrong?

3 3

Error after update to revision 7236
by Alex Winder ＠ M5i 09 Dec '15

09 Dec '15

Hi everyone, We've just updated to revision 7236 and got the following error. -- Updating database/file schema 251 -> 252 ... (db) done (1 errors). In /opt/observium/logs/update-errors.log we see the following error [2015/12/09 19:35:36 +0000] discovery.php(19989): Query: ALTER TABLE `authlog` CHANGE `user_agent` `user_agent` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL; [2015/12/09 19:35:36 +0000] discovery.php(19989): Error: (1054) Unknown column 'user_agent' in 'authlog' Should we do anything for this? Regards, Alex.

3 3

Cisco ASA - inaccurate traffic for one specific interface
by Ben Maschke 09 Dec '15

09 Dec '15

Hi guys, I've added a new ASA to Observium. The issue is that for one interface no packets have been collected so far: [image: Inline images 1] But in the details you can see that traffic has been collected: [image: Inline images 2] The result is that the overall traffic graph is inaccurate (traffic should be ~600Mbit/s): [image: Inline images 3] Cheers

3 3

Quagga with SNMP support.
by Gabriel Zamorski 08 Dec '15

08 Dec '15

Hello, Does anyone have a experience with snmp support in Quagga on Debian 7/8? I installed Quagga with SNMP support (smux or agentx) and configured Quagga to use snmp, but Observium doesn't see anything except an AS number. In Properties > MIBs section there are a couple of errors like: - bgpLocalAs.0 1m 28s ago SNMP error - .1.3.6.1.2.1.25.3.3.1.2.196608 (608 to 619) SNMP error On the other hand, in a similar configuration in VyOS everything works fine. I'm not sure if it depends on patched quagga on VyOS or a misconfiguration in my environment. Regards! Gabriel

4 5

Re: [Observium] Everything is DOWN after svn UP :-)
by Richard Müller 08 Dec '15

08 Dec '15

Hy *, I also experienced this issue some minutes ago. My reason was that "someone" (svn?) created a .index file in the MIB Directory, which caused snmpwalk to die: root@horstname:/opt/observium# /usr/bin/snmpget -v2c -c '***' -Pu -OQUst -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'horstname2':'161' sysObjectID.0 sysUpTime.0 add_mibdir: strings scanned in from /opt/observium/mibs/rfc/.index are too large. count = 136 MIB search path: /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp Cannot find module (SNMPv2-MIB): At line 0 in (none) sysObjectID.0: Unknown Object Identifier (Sub-id not found: (top) -> sysObjectID) sysUpTime.0: Unknown Object Identifier (Sub-id not found: (top) -> sysUpTime) removing the /opt/observium/mibs/rfc/.index file fixed the glitch - does anybody know whats the purpose of these files and where do they come from? Thanks Richard Message: 2 Date: Fri, 4 Dec 2015 12:05:24 +0100 From: Gabriel Zamorski <gabriel.zamorski(a)domeny.pl> To: Observium Network Observation System <observium(a)observium.org> Subject: Re: [Observium] Everything is DOWN after svn UP :-) Message-ID: <5CBBE15E-ED0C-4B8C-B606-E5C5B73DE9DF(a)domeny.pl> Content-Type: text/plain; charset="utf-8" Debian 7.9, libsnmp-base 5.4.3~dfsg-2.8+deb7u1, libsnmp15 5.4.3~dfsg-2.8+deb7u1, php5-snmp 5.4.45-0+deb7u2, snmp 5.4.3~dfsg-2.8+deb7u1. It was updated from 7224 to 7226, then I did rollback. It is strange, today I updated to the latest version 7227 with no problem (without alerts). G. > Wiadomo?? napisana przez Adam Armstrong <adama(a)memetic.org> w dniu 04.12.2015, o godz. 08:54: > > Given that it's virtually impossible for this to be an actual bug in the SVN (hundreds of users would be complaining), it might help to have some additional information about your installation. > > Do you know what version you updated from? What are you running it on? What version of net-snmp? > > adam. >> On 04/12/2015 07:53:05, Gabriel Zamorski <gabriel.zamorski(a)domeny.pl> wrote: >> >> Hello, >> >> Yesterday after upgrading observium (like everyday morning) we got hundreds of alerts. It seems that observium could not connect to any machine using SNMP - I checked this from console via ./poller.php and every server was unreachable, so I had to rollback to the earlier revision. Do you know anything about this? >> >> Regards, >> G. >> >> >> -- Richard Müller | Geschäftsführer teamix GmbH Südwestpark 43 90449 Nürnberg Tel.: +49 911 30999 0 | Fax: +49 911 30999 99 mail: rm(a)teamix.de | web: http://www.teamix.de | blog: http://blog.teamix.de Amtsgericht Nürnberg, HRB 18320 | Geschäftsführer: Oliver Kügow, Richard Müller *** Bitte liken Sie uns auf Facebook: facebook.com/teamix *** _______________________________________________ >> 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 -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://postman.memetic.org/pipermail/observium/attachments/20151204/cc4b310…> -------------- next part -------------- A non-text attachment was scrubbed... Name: smime.p7s Type: application/pkcs7-signature Size: 3587 bytes Desc: not available URL: <http://postman.memetic.org/pipermail/observium/attachments/20151204/cc4b310…> ------------------------------ Message: 3 Date: Fri, 04 Dec 2015 11:58:55 +0000 From: Adam Armstrong <adama(a)observium.org> To: Observium Network Observation System <observium(a)observium.org> Subject: Re: [Observium] Everything is DOWN after svn UP :-) Message-ID: <1516cdbfc18.2779.11b54b3dd25b712395dab9818c67596f(a)observium.org> Content-Type: text/plain; charset="utf-8"; Format="flowed" I think this is perhaps, again, the pesky svn broken file issue. This problem seems to have gotten significantly worse since the svn database version changes. Adam. Sent with AquaMail for Android http://www.aqua-mail.com On 4 December 2015 11:05:41 am Gabriel Zamorski <gabriel.zamorski(a)domeny.pl> wrote: > Debian 7.9, libsnmp-base 5.4.3~dfsg-2.8+deb7u1, libsnmp15 > 5.4.3~dfsg-2.8+deb7u1, php5-snmp 5.4.45-0+deb7u2, snmp > 5.4.3~dfsg-2.8+deb7u1. It was updated from 7224 to 7226, then I did > rollback. It is strange, today I updated to the latest version 7227 > with no problem (without alerts). > > G. > > > > >> Wiadomo?? napisana przez Adam Armstrong <adama(a)memetic.org> w dniu >> 04.12.2015, o godz. 08:54: >> >> Given that it's virtually impossible for this to be an actual bug in >> the SVN (hundreds of users would be complaining), it might help to >> have some additional information about your installation. >> >> Do you know what version you updated from? What are you running it >> on? What version of net-snmp? >> >> adam. >>> On 04/12/2015 07:53:05, Gabriel Zamorski <gabriel.zamorski(a)domeny.pl> wrote: >>> >>> Hello, >>> >>> Yesterday after upgrading observium (like everyday morning) we got >>> hundreds of alerts. It seems that observium could not connect to any >>> machine using SNMP - I checked this from console via ./poller.php >>> and every server was unreachable, so I had to rollback to the >>> earlier revision. Do you know anything about this? >>> >>> Regards, >>> G. >>> >>> >>> _______________________________________________ >>> 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 > -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://postman.memetic.org/pipermail/observium/attachments/20151204/661784e…>

3 2

Minor documentation typo
by Roland Hill 08 Dec '15

08 Dec '15

Hi team, There is a minor typo on this page: http://www.observium.org/docs/unix_agent/ Specifically this, scp /opt/observium/scripts/observium_agent_xinetd user@your_server:/etc/xinet.d/observium_agent_xinetd Note that /etc/xinet.d should be /etc/xinetd.d Very minor, but thought I'd let you know about it. -- Regards, Roland PGP Key 0xDA39319B = BCF0 1214 BAE9 5A3D 46FC 21A6 360D 9398 DA39 319B

2 1

Regex in an entity match not working right
by Spencer Ryan 07 Dec '15

07 Dec '15

Hi All, I'm trying to match ports with the name port-channel1 through 19, and the "match" keyword isn't doing what I want. What I think is correct is "ifName match port-channel([1-9]|1[0-9])" However that gives me 0 matches. If I change it to something like ifName match port-channel*" I get all the port channels, so it's matching the device properly, but for this alert checker I just need port channels 1-19. Any ideas? I've tried a bunch of combinations and nothing seems to work right. Even "port-channel." doesn't match the additional character. *Spencer Ryan* | Senior Systems Administrator | sryan(a)arbor.net *Arbor Networks* +1.734.794.5033 (d) | +1.734.846.2053 (m) www.arbornetworks.com

3 5

Arista switches environment sensors have stopped working
by Ben Maschke 07 Dec '15

07 Dec '15

Hi guys, after updating to the latest subscriber version all of our checks for environment sensors (Arista switches) have stopped working: [image: Inline images 1] It seems that it has stopped receiving proper sensor data: [image: Inline images 2] Thx -- *Ben Maschke* Senior System Engineer *Tel:* +44 (0) 20 8742 6820 *Shazam* 26-28 Hammersmith Grove, London, W6 7HA Please consider the environment before printing this document Shazam Entertainment Limited is incorporated in England and Wales under company number 3998831 and its registered office is at 26-28 Hammersmith Grove, London W6 7HA.

4 8

toggles and pop ups have stopped working
by observium＠istar.net.nz 05 Dec '15

05 Dec '15

Hello We've recently updated Observium (now 0.15.12.7230) and enabled SSH and the on/off switches are not being shown and the date popups don't work. If I browse to it on http it seems to be fine. I've checked the apache config and it looks identical, any thoughts? Thanks SHANE lE <mailto:shanson@istar.net.nz> shanson(a)istar.net.nz lW <https://istar.net.nz/> istar.net.nz lA PO Box 911507, Victoria St West, Auckland lM +64 21 623 903

2 2

UNIX Agent
by Alex Winder ＠ M5i 05 Dec '15

05 Dec '15

Hi all, I'm currently trying to get the UNIX agent for Observium working with some of our hosts so that we can obtain more data for applications, primarily NGINX. We are now seeing data on the agent execution time graph. We are getting responses from the Observium host to the NGINX host via Telnet, and receiving information about NGINX. We are getting the NGINX status information through Lynx on the localhost. We are using the following configs. /etc/xinetd.d/observium_agent_xinetd service observium_agent { type = UNLISTED port = 36602 socket_type = stream protocol = tcp wait = no user = root server = /usr/bin/observium_agent # configure the IPv[4|6] address(es) of your Observium server here: only_from = [IPs removed] 127.0.0.1 ::1 # Don't be too verbose. Don't log every check. This might be # commented out for debugging. If this option is commented out # the default options will be used for this service. log_on_success = disable = no } /usr/lib/observium_agent/local/nginx !/usr/bin/env python import urllib2 import re data = urllib2.urlopen('http://localhost/nginx-status').read() params = {} for line in data.split("\n"): smallstat = re.match(r"\s?Reading:\s(.*)\sWriting:\s(.*)\sWaiting:\s(.*)$", line) req = re.match(r"\s+(\d+)\s+(\d+)\s+(\d+)", line) if smallstat: params["Reading"] = smallstat.group(1) params["Writing"] = smallstat.group(2) params["Waiting"] = smallstat.group(3) elif req: params["Requests"] = req.group(3) else: pass dataorder = [ "Active", "Reading", "Writing", "Waiting", "Requests" ] print "<<<nginx>>>\n"; for param in dataorder: if param == "Active": Active = int(params["Reading"]) + int(params["Writing"]) + int(params["Waiting"]) print Active else: print params[param] /etc/nginx/sites-automatic/localhost.conf server { listen 80; listen [::]:80; server_name localhost; server_name_in_redirect off; charset utf-8; log_not_found on; access_log /var/log/nginx/localhost_combined-access.log combined buffer=128k flush=5m; error_log /var/log/nginx/localhost_error.log; location / { root /local-storage/localhost/nginx-hosted/public_html; } location /nginx-status { stub_status on; access_log off; allow 127.0.0.1; allow ::1; deny all; } } Any help with this would be much appreciated. Where can we expect to see logs? Any tips on how we can resolve this? Regards, Alex.

3 4

Problems with fresh installation - svn revision 7229 (and stable too)
by Eduardo Schoedler 05 Dec '15

05 Dec '15

# php includes/update/update.php -- Updating database/file schema 000 -> 001 ... (db) done. 001 -> 002 ... (db) done. 002 -> 003 ... (db) done. 003 -> 004 ... (db) done. 004 -> 005 ... (db) done. 005 -> 006 ... (db) done. 006 -> 007 ... (db) done. 007 -> 008 ... (db) done. 008 -> 009 ... (db) done. 009 -> 010 ... (db) done. 010 -> 011 ... (db) done. 011 -> 012 ... (db) done. 012 -> 013 ... (db) done. 013 -> 014 ... (db) done. 014 -> 015 ... (db) done. 015 -> 016 ... (db) done. 016 -> 017 ... (db) done. 017 -> 018 ... (db) done. 018 -> 019 ... (db) done. 019 -> 020 ... (db) done. 020 -> 021 ... (db) done. 021 -> 022 ... (db) done. 022 -> 023 ... (db) done. 023 -> 024 ... (db) done. 024 -> 025 ... (db) done. 025 -> 026 ... (db) done. 026 -> 027 ... (db) done. 027 -> 028 ... (db) done. 028 -> 029 ... (db) done. 029 -> 030 ... (db) done. 030 -> 031 ... (db) done. 031 -> 032 ... (db) done. 032 -> 033 ... (db) done. 033 -> 034 ... (db) done. 034 -> 035 ... (db) done. 035 -> 036 ... (db) done. 036 -> 037 ... (db) done. 037 -> 038 ... (db) done. 038 -> 039 ... (db) done. 039 -> 040 ... (db) done. 040 -> 041 ... (db) done. 041 -> 042 ... (db) done. 042 -> 043 ... (db) done. 043 -> 044 ... (db) done. 044 -> 045 ... (db) done. 045 -> 046 ... (db) done. 046 -> 047 ... (db) done. 047 -> 048 ... (db) done. 048 -> 049 ... (db) done. 049 -> 050 ... (db) done. 050 -> 051 ... (db) done. 051 -> 052 ... (db) done. 052 -> 053 ... (db) done. 053 -> 054 ... (db) done. 054 -> 055 ... (db) done. 055 -> 056 ... (db) done. 056 -> 057 ... (db) done. 057 -> 058 ... (db) done. 058 -> 059 ... (db) done. 059 -> 060 ... (db) done. 060 -> 061 ... (db) done. 061 -> 062 ... (db) done. 062 -> 063 ... (db) done. 063 -> 064 ... (db) done. 064 -> 065 ... (db) done. 065 -> 066 ... (db) done. 066 -> 067 ... (db) done. 067 -> 068 ... (db) done. 068 -> 069 ... (db) done. 069 -> 070 ... (db) done. 070 -> 071 ... (db) done. 071 -> 072 ... (db) done. 072 -> 073 ... (db) done. 073 -> 074 ... (php) Updating netscaler service RRDs 074 -> 075 ... (db) done. 075 -> 076 ... (db) done. 076 -> 077 ... (db) done. 077 -> 078 ... (db) done. 078 -> 079 ... (db) done. 079 -> 080 ... (db) done. 080 -> 081 ... (db) done. 081 -> 082 ... (db) done. 082 -> 083 ... (db) done. 083 -> 084 ... (db) done. 084 -> 085 ... (db) done. 085 -> 086 ... (db) done. 086 -> 087 ... (db) done. 087 -> 088 ... (db) done. 088 -> 089 ... (db) done. 089 -> 090 ... (db) done. 090 -> 091 ... (db) done. 091 -> 092 ... (db) done. 092 -> 093 ... (db) done. 093 -> 094 ... (db) done. 094 -> 095 ... (php) Converting alert serialize() arrays to JSON: 095 -> 096 ... (db) done. 096 -> 097 ... (db) done. 097 -> 098 ... (db) done. 098 -> 099 ... (db) done. 099 -> 100 ... (db) done. 100 -> 101 ... (db) done. 101 -> 102 ... (db) done. 102 -> 103 ... (db) done. 103 -> 104 ... (db) done. 104 -> 105 ... (db) done. 105 -> 106 ... (db) done. 106 -> 107 ... (db) done. 107 -> 108 ... (db) done. 108 -> 109 ... (db) done. 109 -> 110 ... (db) done. 110 -> 111 ... (db) done. 111 -> 112 ... (db) done. 112 -> 113 ... (db) done. 113 -> 114 ... (db) done. 114 -> 115 ... (db) done. 115 -> 116 ... (db) done. 116 -> 117 ... (db) done. 117 -> 118 ... (db) done. 118 -> 119 ... (db) done. 119 -> 120 ... (db) done. 120 -> 121 ... (db) done. 121 -> 122 ... (db) done. 122 -> 123 ... (db) done. 123 -> 124 ... (db) done. 124 -> 125 ... (db) done. 125 -> 126 ... (db) done. 126 -> 127 ... (php) Converting FDB count RRD ds fdb->value: 127 -> 128 ... (php) Rename old storage RRDs and DB: 128 -> 129 ... (php) Rename old mempools RRDs and DB: 129 -> 130 ... (db) done. 130 -> 131 ... (db) done. 131 -> 132 ... (db) done. 132 -> 133 ... (db) done. 133 -> 134 ... (db) done. 134 -> 135 ... (db) done. 135 -> 136 ... (db) done. 136 -> 137 ... (db) done. 137 -> 138 ... (db) done. 138 -> 139 ... (db) done. 139 -> 140 ... (db) done. 140 -> 141 ... (db) done. 141 -> 142 ... (db) done. 142 -> 143 ... (db) done. 143 -> 144 ... (db) done. 144 -> 145 ... (db) done. 145 -> 146 ... (db) done. 146 -> 147 ... (db) done. 147 -> 148 ... (db) done. 148 -> 149 ... (db) done. 149 -> 150 ... (db) done (2 errors). # svn update && ./discovery.php -h none Updating '.': At revision 7229. ___ _ _ / _ \ | |__ ___ ___ _ __ __ __(_) _ _ _ __ ___ | | | || '_ \ / __| / _ \| '__|\ \ / /| || | | || '_ ` _ \ | |_| || |_) |\__ \| __/| | \ V / | || |_| || | | | | | \___/ |_.__/ |___/ \___||_| \_/ |_| \__,_||_| |_| |_| Observium Professional 0.15.12.7229 http://www.observium.org -- Updating database/file schema 149 -> 150 ... (db) done (10 errors). # cat update-errors.log [2015/12/04 23:06:38 +0000] discovery.php(68419): ====== Schema update 149 -> 150 ============== [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: ALTER TABLE `alert_assoc` CHANGE `device_attributes` `device_attribs` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1054) Unknown column 'device_attributes' in 'alert_assoc' [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: ALTER TABLE `alert_assoc` CHANGE `attributes` `entity_attribs` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1054) Unknown column 'attributes' in 'alert_assoc' [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: ALTER TABLE `ports_perms` ADD `entity_type` VARCHAR( 32 ) NOT NULL AFTER `user_id` ; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1146) Table 'observium.ports_perms' doesn't exist [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: ALTER TABLE `ports_perms` CHANGE `port_id` `entity_id` INT( 11 ) NOT NULL ; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1146) Table 'observium.ports_perms' doesn't exist [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: UPDATE `ports_perms` SET `entity_type` = 'port' WHERE 1; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1146) Table 'observium.ports_perms' doesn't exist [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: RENAME TABLE `ports_perms` TO `entity_permissions` ; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1050) Table 'entity_permissions' already exists [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: INSERT `entity_permissions` (user_id,entity_id,entity_type) SELECT `bill_perms`.`user_id`,`bill_perms`.`bill_id`,'bill' AS `entity_type` FROM `bill_perms`; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1146) Table 'observium.bill_perms' doesn't exist [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: INSERT `entity_permissions` (user_id,entity_id,entity_type) SELECT `devices_perms`.`user_id`,`devices_perms`.`device_id`, 'device' AS `entity_type` FROM `devices_perms`; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1146) Table 'observium.devices_perms' doesn't exist [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: DROP TABLE `bill_perms`; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1051) Unknown table 'observium.bill_perms' [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: DROP TABLE `devices_perms`; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1051) Unknown table 'observium.devices_perms' # cat db.log [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1146 - Table 'observium.observium_attribs' doesn't exist), Query: SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'dbSchema'; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1054 - Unknown column 'device_attributes' in 'alert_assoc'), Query: ALTER TABLE `alert_assoc` CHANGE `device_attributes` `device_attribs` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1054 - Unknown column 'attributes' in 'alert_assoc'), Query: ALTER TABLE `alert_assoc` CHANGE `attributes` `entity_attribs` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1146 - Table 'observium.ports_perms' doesn't exist), Query: ALTER TABLE `ports_perms` ADD `entity_type` VARCHAR( 32 ) NOT NULL AFTER `user_id` ; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1146 - Table 'observium.ports_perms' doesn't exist), Query: ALTER TABLE `ports_perms` CHANGE `port_id` `entity_id` INT( 11 ) NOT NULL ; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1146 - Table 'observium.ports_perms' doesn't exist), Query: UPDATE `ports_perms` SET `entity_type` = 'port' WHERE 1; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1050 - Table 'entity_permissions' already exists), Query: RENAME TABLE `ports_perms` TO `entity_permissions` ; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1146 - Table 'observium.bill_perms' doesn't exist), Query: INSERT `entity_permissions` (user_id,entity_id,entity_type) SELECT `bill_perms`.`user_id`,`bill_perms`.`bill_id`,'bill' AS `entity_type` FROM `bill_perms`; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1146 - Table 'observium.devices_perms' doesn't exist), Query: INSERT `entity_permissions` (user_id,entity_id,entity_type) SELECT `devices_perms`.`user_id`,`devices_perms`.`device_id`, 'device' AS `entity_type` FROM `devices_perms`; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1051 - Unknown table 'observium.bill_perms'), Query: DROP TABLE `bill_perms`; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1051 - Unknown table 'observium.devices_perms'), Query: DROP TABLE `devices_perms`; -- Eduardo Schoedler

4 4

monitor tmpfs storage
by Simon Smith 04 Dec '15

04 Dec '15

Hi All, just moved our RRDs to tmpfs storage, and WOW I noticed a speed difference, not only in the graphs, but also in the IO load should of looked at http://observium.org/docs/persistent_ramdisk/ in the past DOH! however i’ve just noticed the observium isn’t showing it as a storage mount? can observium monitor actually monitor it at all ? also I’ve set my limit at 10GB as the server has 12GB of RAM, and the RRD folder is currently at 6.8GB bit of a stupid question but what happens if I’m close to the limit? as i knackered? more RAM server? regards Simon - Hestor Ltd

3 3

Update db schema error
by Tomasz Karczewski 04 Dec '15

04 Dec '15

I wanted to update db-schema but I got this error, [2015/12/04 13:14:32 +0100] discovery.php(2635): ====== Schema update 251 -> 252 ============== [2015/12/04 13:14:32 +0100] discovery.php(2635): Query: ALTER TABLE `eventlog` CHANGE `timestamp` `timestamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP; [2015/12/04 13:14:32 +0100] discovery.php(2635): Error: (1114) The table '#sql-ae4_bf3697' is full Tomasz Karczewski Administrator Sieci olman tkarczewski(a)man.olsztyn.pl http://www.man.olsztyn.pl http://www.uwm.edu.pl tel. (89) 523 45 55 fax. (89) 523 43 47 Ośrodek Eksploatacji i Zarządzania Miejską Siecią Komputerową OLMAN w Olsztynie Uniwersytet Warmińsko-Mazurski w Olsztynie

3 2

Alert Threshold for CBQoS drops
by Robert Williams 04 Dec '15

04 Dec '15

Hi, Is it possible to have alert elements/metrics which use data collected from CBQoS, like drops for example? Reason for request - we would like to get alerting for certain types of port (CORE for example) where QoS is performing drops. Currently (in another system) we poll a global statistic which gives us the 'total' number of drops per chassis or LC, but this does nothing more than point towards a chassis or line-card. A human then have to pick their way through the CBQoS stats to try to see where it was (if it was big), which very time consumptive. The statistics and framework all appear to be in place within Observium, just need to know if there are some metric conditions which can use CBQoS as a trigger, like ifCBQoSDrops_rate > 10 for example? So, is this already possible? Or should I make a feature request? Cheers all! Robert Williams Custodian Data Centre Email: Robert(a)CustodianDC.com http://www.CustodianDC.com

2 2

Everything is DOWN after svn UP :-)
by Gabriel Zamorski 04 Dec '15

04 Dec '15

Hello, Yesterday after upgrading observium (like everyday morning) we got hundreds of alerts. It seems that observium could not connect to any machine using SNMP - I checked this from console via ./poller.php and every server was unreachable, so I had to rollback to the earlier revision. Do you know anything about this? Regards, G.

4 4

CBQOS does not appear to work under NX-OS
by Stephen Fulton 04 Dec '15

04 Dec '15

Hi there, I have a Cisco Nexus 7k running the NX-OS 6.2 train, and I've noticed that while Observium picks up on CBQOS for interfaces, there is no data being graphed. Observium does detect the class-maps/policy-maps, but no results in the graphs. There are errors on one port that should be picked up, but I'm not seeing it reflected. What can be done? BTW, I'm using the subscription version, latest stable (0.15.11.7203). -- Stephen

3 3

Zenoss Integration Sync
by Rudy Pancaro 03 Dec '15

03 Dec '15

Has anyone every integrated Observium and Zenoss together. Zenoss is another networking monitoring platform, but the platform could use a more friendly GUI. The Observium GUI is very nice. Please let me know if this is possible. I believe that Observium and Nagios integrates with one another, but our organization uses Zenoss. Thank you.

4 8

Device check and down alert question
by Ron Culler 03 Dec '15

03 Dec '15

I have noticed that I see down notices in Observium often when the snmp check fails (I have only seen this when checking servers (Windows/Linux). The device is up and a ping/icmp check would see this but because the snmp check had a problem I get a down indication. Sometimes it has to deal with the snmp service on the host being checked hanging or crashing, other times I have seen load or congestion cause it. Is there an option or would it make sense to add a feature that would check snmp first and in the event of an error fall back and do a ping/icmp check to see if the device is up or not? It would be beneficial to see if the server is up and get a notice about a snmp check failure. I could also see a check flow that would check snmp first, if it errored it would check with a ping, if the ping returns wait for the next snmp check before sending the notice or marking the device down. Ron Culler

2 1

recreate interface to down/up -event
by Geno 03 Dec '15

03 Dec '15

Hallo, i have the following problem. I server of mine a VPN-Service. This vpn-service restart some times (and with it it recreate a network interface with the same name "vpn-interface"). Observium delete the interface and create a new one (with the same name). The Question, is it possible to detect it and make a down up event out of it (and a mac change)? So it will use the same rrds, graphs and so on. Nice Wishes Geno

3 4

Creating a table with Unix-agent
by Daniel Kasen 02 Dec '15

02 Dec '15

Using the unix agent I can create graphs, but what if I wanted to just add a table to the apps tab? Basically what I am trying to do is keep an up-to-date table of custom strings for linux servers. *Daniel Kasen | REDFIN | Data Center Operations Engineerdaniel.kasen(a)redfin.com <daniel.kasen(a)redfin.com> | Tel: 206-859-2826 2025 1st Ave, Ste 500 | Seattle, WA 98121*

4 3

CAMBIUM ePMP 1000 shown as Generic MIPS
by Federico Olivieri 02 Dec '15

02 Dec '15

Hi All, I have just received from the vendor the MIBs for the CAMBIUM ePMP for FW version 2.5.1 and 2.4.2 (renamed CAMBIUM-ePMP-2.5.1-MIB and CAMBIUM-ePMP-2.4.2-MIB) I put them under the MIB folder root@T1000:/opt/observium/mibs/cambium# ls -l total 944 -rwxrwxr-x 1 user user 222338 Dec 2 15:06 CAMBIUM-ePMP-2.4.2-MIB -rwxrwxr-x 1 user user 215949 Dec 2 15:06 CAMBIUM-ePMP-2.5.1-MIB -rw-rw-r-- 1 user user 164656 Nov 20 2014 CAMBIUM-PTP800-V2-MIB -rw-rw-r-- 1 user user 13857 Nov 20 2014 MOTOROLA-PTP-MIB -rwxrwxr-x 1 user user 121942 Nov 4 2014 WHISP-APS-MIB -rwxrwxr-x 1 user user 107218 Nov 4 2014 WHISP-BOX-MIBV2-MIB -rwxrwxr-x 1 user user 3715 Nov 4 2014 WHISP-GLOBAL-REG-MIB -rwxrwxr-x 1 user user 96040 Nov 4 2014 WHISP-SM-MIB -rwxrwxr-x 1 user user 2416 Nov 4 2014 WHISP-TCV2-MIB root@T1000:/opt/observium/mibs/cambium# but OBSERVIUM still shows the antennas as generic "Linux server" [image: Immagine incorporata 1] Maybe I missed a step. There is something else that I need to do? Thanks for your help Federico

2 4

Webpage Display
by Aaron Hite 02 Dec '15

02 Dec '15

I upgrade to 0.15.11.7224 (30th November 2015) today and noticed that my webpage doesn’t display widescreen anymore. Both the normal and widescreen display the same way. My graphs now wrap and create multiple rows for display. Anyone else have this problem, or any thoughts on a solution? Thanks, Aaron

3 4

Cannot get nginx perf graphs to show up
by Tsvetan Blagoev (c) 01 Dec '15

01 Dec '15

>From observium box, I try telnet 192.168.10.101 36602 which is my remote nginx server, dumps system info plus nginx section with some counters; Application section and graphs never show for this host. I have also enabled explicitly unix agent from the agents tab of the configuration page. Am I missing something ? Regards, Tsener [PS CoE] Tsvetan Blagoev / Tsener Infrastructure and Tools Engineer, PS CoE +359 2 80 41627 -- Office +359 889 850 359 -- Mobile

1 0

API Details
by Kyle Hunter 30 Nov '15

30 Nov '15

Hey, I’ve been looking around and there appears to be 2 different APIs in observium. Is there a specific one which will be removed and the other updated? Thanks, Kyle Kyle Hunter | Network Engineer | The Summit Group E: khunter(a)thesummitgroup.com.au<mailto:khunter@thesummitgroup.com.au> | W: The Summit Group (Australia) Pty Ltd | P: | Level 1, 39 Railway Road, Blackburn VIC 3130 The Summit Group (USA) LLC | P: 321 216 3844 | Suite 1003, 364E Main Street, Middletown DE 19709 Postal: P.O. Box 3225, Doncaster East VIC 3109 Follow us on Facebook<http://www.facebook.com/thesummitgroup/> | LinkedIn<http://www.linkedin.com/company/1942329> | Twitter<http://twitter.com/summitgroupau/>

2 1

Memory utilization increasing continuously .......................!
by Chaman Rathee 30 Nov '15

30 Nov '15

Hi Team, I am monitoring 200 devices. But my memory utilization of server is continuously increasing. When my available physical memory comes near 20%, then my observium server starts dropouts/gaps in graph. Please help me . ......... With Best Regards, Chaman Rathee Mob. No:- +91-9560055816 [Fabrikam] Privileged or confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), please delete this message and kindly notify the sender by an emailed reply. Opinions, conclusions and other information in this message that do not relate to the official business of Progression and its associate entities shall be understood as neither given nor endorsed by them.

4 4

Disable CDP neighbour discovery?
by Ulrik Ivers 30 Nov '15

30 Nov '15

Hi, Is it possible to disable neighbour discovery via CDP but still leave it enabled for LLDP? The reason for asking is that we are a 100% LLDP shop, but some equipment run both CDP and LLDP. When looking at the tab "Neighbours" of such a device the neighbours are listed twice, one with protocol LLDP and one with protocol CDP. We would like to only do neighbour discovery via LLDP, if possible. I've looked through the options files and the documentation but haven't been able to find a setting to disable CDP. Regards, /Ulrik Ivers

3 2

Location menu - hierarchical without GeoLocation?
by Ulrik Ivers 29 Nov '15

29 Nov '15

Hi again, Corrected some typos to make the explanation a bit more understandable ... /Ulrik Hi, Trying to figure out whether it's possible to have the Location menu on the front page being hierarchical with GeoLocation DISABLED. Is this possible? Running version 7203. Our snmp location strings in our devices are on the format of: City, Building, Floor We'd like to have the Location menu on the frontpage being displayed hierarchical something like this: Location City A [3] Building A [3] Floor X [2] Floor Y [1] At the moment the menu looks like this with THREE devices of which TWO have the same location string Location City A, Building A, Floor X City A, Building A, Floor Y Any suggestions would be welcome. Regards, /Ulrik Ivers

2 2

Location menu - hierarchical without GeoLocation?
by Ulrik Ivers 29 Nov '15

29 Nov '15

Hi, Trying to figure out whether it's possible to have the Location menu on the front page being hierarchical with GeoLocation DISABLED. Is this possible? Running version 7203. Our snmp location strings in our devices are on the format of: City, Building, Floor We'd like to have the Location menu on the frontpage being displayed hierarchical something like this: Location City A [3] Building A [3] Floor X [2] Floor Y [1] At the moment the menu looks like this with tree devices of which to have the same location string Location City A, Building A, Floor X City A, Building A, Floor Y Any suggestions would be welcome. Regards, /Ulrik Ivers

1 0

Map error?
by linuxthefish 27 Nov '15

27 Nov '15

Hi, Why does my Observium show a blue sea and not the normal location markers? Thanks!

2 1

App monitoring - What am I missing??
by Scott A. Davis 27 Nov '15

27 Nov '15

Hello - Trying to set up the apache monitor on the same server where Observium is running (I figured that would be easiest). I can't seem to figure out what I am missing. Sorry for being verbose ... Just need to make sure I am covering all my bases. Any suggestions are appreciated. Version Information *Observium CE* 0.15.6.6430 *OS* Linux 2.6.32-573.8.1.el6.x86_64 [amd64] (CentOS 6.7) *Apache* 2.2.15 *PHP* 5.4.44 *Python* Python 2.6.6 *MySQL* 5.5.45 *SNMP* NET-SNMP 5.5 *RRDtool* 1.3.8 * Copied /opt/observium/scripts/observium_agent_xinetd -> /etc/xinetd.d/ [root@zen xinet.d]# ls -la observium_agent_xinetd -rw-r--r-- 1 root root 650 Nov 26 18:33 observium_agent_xinetd * Copied /opt/observium/scripts/observium_agent -> /usr/bin [root@zen bin]# ls -la observium_agent -rwxrwxrwx 1 root root 12K Nov 26 18:31 observium_agent* * Made directories: mkdir /usr/lib/observium_agent /usr/lib/observium_agent/local * Copied /opt/observium/scripts/agent-local/apache -> /usr/lib/observium_agent/local [root@zen local]# ls -la total 64K drwxr-xr-x 2 root root 4.0K Nov 26 17:46 ./ drwxr-xr-x 3 root root 4.0K Nov 26 17:43 ../ -rwxrw-rw- 1 1000 1000 2.9K Nov 26 18:31 apache* -rwxrw-rw- 1 1000 1000 51K Nov 26 19:12 mysql* * Edited /etc/xinetd.d/observium_agent_xinetd only_from = 127.0.0.01 ::1 (Also added my reap IPv4 address to that line for good posterity) * Made sure I had port 33602 open on the firewall (and even disabled firewall at times) service xinetd restart [root@zen conf]# service xinetd restart Stopping xinetd: [ OK ] Starting xinetd: [ OK ] * _httpd.conf says:_ ExtendedStatus On <Location /server-status> SetHandler server-status Order deny,allow Deny from all Allow from 127.0.0.1 Allow from ::1 Allow from <my real IPv4 address> Allow from <my home address> </Location> I can access that just fine. * Ensured the agent port setting in Device Settings->Agent was correct * Ensured the unix-agent module was enabled in Settings->Modules What am I missing? Help. Thank you!!

2 2

GeoLocation not correct
by Scott A. Davis 26 Nov '15

26 Nov '15

Hi - Not sure if this is an Observium issue or not, but in all the time I've used the community version, I've never had this problem. My screen shot is here: http://imgur.com/D9waqhG I have 3 servers. Two in TX, which show up accurately, and one in Atlanta, which shows up in the middle of the Atlantic ocean. Observium shows its location as "Unknown" my snmpd.conf is as follows (with XXXXX marking non-relevant info) syslocation Atlanta, Georgia rocommunity XXXXXX sysname tsundoku.XXXXXXX.XXX syscontact scott.a.davis(a)gmail.com I have other servers with similar snmpd.conf on that map showing up fine. For syslocation, I have also tried Atlanta, Atlanta, GA, etc ... Nothing changes. Any reason why this would happen? Any suggestions would be appreciated. Thanks in advance!

2 2

Custom OIDs are fantastic
by Tim Vaughan 26 Nov '15

26 Nov '15

Just wanted to say thankyou for adding support for Custom OIDs. Using a combination of this article http://www.maartenmoerman.nl/?p=649 and this one http://awesomeadmin.blogspot.co.uk/2009/11/monitoring-cisco-wireless-contro… I was able to add graphs to track how many clients are on each of our individual access points. So far I think it's working, even if it is a pain to calculate which AP MAC address translates to which OID....

3 8

dell UPS and PDU
by BROSSEAU Benoit 26 Nov '15

26 Nov '15

Hello, We are a new observium customer and we are trilled with what we see. Our instance just detected about everything on our pretty extensive network BUT we have a couple of items showing up as GENERIC DEVICE thoses are Dell 6606 PDU and Dell 10000w UPS. Since the pdu are just rebranded APC and the UPS rebranded EATON is there a way to make thoses work ? thanks

2 1

enquiry about invoice
by Ankit Dubey 26 Nov '15

26 Nov '15

Hi, Please let me know - will I get an invoice when I will pay to get the subscription as that invoice will be required for reimbursement of invoice amount from my organization. Best regards Ankit Dubey ________________________________ This E-Mail may contain Confidential and/or legally privileged Information and is meant for the intended recipient(s) only. If you have received this e-mail in error and are not the intended recipient/s, Kindly notify the sender and then delete this e-mail immediately from your system. You are also hereby notified that any use, any form of reproduction, dissemination, copying, disclosure, modification, distribution and/or publication of this e-mail, its contents or its attachment/s other than by its intended recipient/s is strictly prohibited and may be unlawful. Internet Communications cannot be guaranteed to be secure or error-free as information could be delayed, intercepted, corrupted, lost, or contain viruses. Sistema Shyam Teleservices Limited does not accept any liability for any errors, omissions, viruses or computer problems experienced by any recipient as a result of this e-mail.

2 1

Custom Contacts
by lom＠digitelitalia.com 26 Nov '15

26 Nov '15

How to associate a custom contact in an alert checker? I create the contacts, but I don't know how to associate to an alert checker. I'm using Professional version, upgraded from SVN at 7221 release. Thank you. digitel Ing. Lorenzo Mainardi Via della Fortezza 6 - 50129 Firenze <http://www.digitelitalia.com/> www.digitelitalia.com - 800 901 669 Tel +39 055 4624933 Fax +39 055 4624 947 lom(a)digitelitalia.com <mailto:lom@digitelitalia.com>

2 1

Contacts / Alert Checks
by Spencer Ryan 26 Nov '15

26 Nov '15

I see I can create custom contacts, but I don't see a way to associate an alert check to that contact. Am I just missing this? I saw an old post from adam saying there was no way to do it in the UI but that was a few months ago. I'd really like to define a destination email address for specific alert checks in our use case. Any help? *Spencer Ryan* | Senior Systems Administrator | sryan(a)arbor.net *Arbor Networks* +1.734.794.5033 (d) | +1.734.846.2053 (m) www.arbornetworks.com

7 10

MySQL application
by Geoff Johnson 25 Nov '15

25 Nov '15

The instructions for configuring the MySQL application at https://observium.org/w/Application/MySQL are unclear about where the database user must be created. Do the user create steps need to be done on every host running MySQL that you want to monitor, or just once on the Observium server? I assume that it's the former, just looking for clarification. Thanks, Geoff

3 6

Lot of DB errors
by Bastiaan Topper 24 Nov '15

24 Nov '15

Hi, I receive a lot of DB errors on my Observium server every polling interval. [2015/11/22 13:11:31 +0100] poller.php(14640): Failed dbQuery (#1062 - Duplicate entry '10471' for key 'PRIMARY'), Query: INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('10471') [2015/11/22 13:11:31 +0100] poller.php(14640): Failed dbQuery (#1062 - Duplicate entry '10472' for key 'PRIMARY'), Query: INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('10472') [2015/11/22 13:11:31 +0100] poller.php(14640): Failed dbQuery (#1062 - Duplicate entry '10473' for key 'PRIMARY'), Query: INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('10473') [2015/11/22 13:11:31 +0100] poller.php(14640): Failed dbQuery (#1062 - Duplicate entry '10474' for key 'PRIMARY'), Query: INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('10474') [2015/11/22 13:11:31 +0100] poller.php(14640): Failed dbQuery (#1062 - Duplicate entry '10476' for key 'PRIMARY'), Query: INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('10476') [2015/11/22 13:11:31 +0100] poller.php(14640): Failed dbQuery (#1062 - Duplicate entry '10477' for key 'PRIMARY'), Query: INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('10477') [2015/11/22 13:11:31 +0100] poller.php(14640): Failed dbQuery (#1062 - Duplicate entry '10478' for key 'PRIMARY'), Query: INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('10478') [2015/11/22 13:11:31 +0100] poller.php(14640): Failed dbQuery (#1062 - Duplicate entry '10480' for key 'PRIMARY'), Query: INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('10480') [2015/11/22 13:11:31 +0100] poller.php(14640): Failed dbQuery (#1062 - Duplicate entry '10481' for key 'PRIMARY'), Query: INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('10481') [2015/11/22 13:11:31 +0100] poller.php(14640): Failed dbQuery (#1062 - Duplicate entry '10482' for key 'PRIMARY'), Query: INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('10482') [2015/11/22 13:11:31 +0100] poller.php(14640): Failed dbQuery (#1062 - Duplicate entry '10484' for key 'PRIMARY'), Query: INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('10484') [2015/11/22 13:11:31 +0100] poller.php(14640): Failed dbQuery (#1062 - Duplicate entry '10485' for key 'PRIMARY'), Query: INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('10485') [2015/11/22 13:11:31 +0100] poller.php(14640): Failed dbQuery (#1062 - Duplicate entry '10486' for key 'PRIMARY'), Query: INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('10486') [2015/11/22 13:11:31 +0100] poller.php(14640): Failed dbQuery (#1062 - Duplicate entry '10488' for key 'PRIMARY'), Query: INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('10488') [2015/11/22 13:11:31 +0100] poller.php(14640): Failed dbQuery (#1062 - Duplicate entry '10489' for key 'PRIMARY'), Query: INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('10489') [2015/11/22 13:11:31 +0100] poller.php(14640): Failed dbQuery (#1062 - Duplicate entry '10490' for key 'PRIMARY'), Query: INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('10490') [2015/11/22 13:11:31 +0100] poller.php(14640): Failed dbQuery (#1062 - Duplicate entry '10491' for key 'PRIMARY'), Query: INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('10491') [2015/11/22 13:11:31 +0100] poller.php(14640): Failed dbQuery (#1062 - Duplicate entry '10493' for key 'PRIMARY'), Query: INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('10493') [2015/11/22 13:11:31 +0100] poller.php(14640): Failed dbQuery (#1062 - Duplicate entry '10494' for key 'PRIMARY'), Query: INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('10494') [2015/11/22 13:11:31 +0100] poller.php(14640): Failed dbQuery (#1062 - Duplicate entry '10495' for key 'PRIMARY'), Query: INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('10495') [2015/11/22 13:11:31 +0100] poller.php(14640): Failed dbQuery (#1062 - Duplicate entry '67419' for key 'PRIMARY'), Query: INSERT INTO `alert_table-state` (`alert_table_id`) VALUES ('67419') Every 5 minutes I have thousands of these errors in my error log (db.log in the observium logs folder). What could cause this? And how can I troubleshoot this? I already tried to delete a few from the mentioned entries from the database, but it recreates them and still returns the errors. Almost all errors are for the alert_table-state table. Thanks and regards, Bastiaan

6 15

Debugging rsyslog
by Tim Vaughan 24 Nov '15

24 Nov '15

I have a number of devices on separate VLANs to my Observium server. They are configured to send their logs via syslog to Observium. I have firewall rules in place on our router to allow this traffic between VLANs and I can see the traffic being passed in firewall logs. However, the log messages never seem to make it into Observium. How can I go about debugging rsyslog to see whether the logs arrive correctly at the server and are correctly processed by rsyslogd?

1 0

PHP Weathermap
by Serghei Golipad 24 Nov '15

24 Nov '15

Guys, Anyone minds sharing Observium version of Weathermap please? Cheers PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS EMAIL. Kelway (UK) Ltd is a Company registered in England and Wales. This email is sent for and on behalf of Kelway Holdings Limited. Kelway Holdings Limited is the UK holding company for Kelway (UK) Limited trading as Kelway. The registered office for Kelway Holdings Limited (Company Number 05872067) and its UK group undertakings is 10 Fleet Place, London, EC4M 7RB. VAT Registration 902 1949 39. Confidentiality: This e-mail contains proprietary information, some or all of which may be confidential and/or legally privileged. It is for the intended recipient only. If an addressing or transmission error has misdirected this e-mail, please notify the author by replying to this e-mail and then delete the original. If you are not the intended recipient you may not use, disclose, distribute, copy, print or rely on any information contained in this e-mail. You must not inform any other person other than Kelway or the sender of its existence. For more information about Kelway please visit www.kelway.co.uk

3 3

Dlink DES-1210-28
by Support 24 Nov '15

24 Nov '15

Hi, we have added a brand new Dlink (DES 1210-28) under monitor with last release of Observium (update just yesterday) the discover is ok but the data of interfaces (packets, bandwith, etc..) is not collect the devices is been delete e added more times any ideas? saluti, Giuseppe Caputo _____________________________________________________________________ NUCKLEO Information Technology Solutions Support & Delivery Team http://www.nuckleo.com _____________________________________________________________________

1 0

upgrade community version to paid version
by Ankit Dubey 23 Nov '15

23 Nov '15

Hi, I have installed community version and wish to upgrade it to paid version. What is the process? Do I need to provide internet connectivity to already installed server which is having community version and there is some process to upgrade the same to paid version directly? Best regards Ankit Dubey Lead, Packet Core Planning Division Network, CORPORATE CENTER ________________________________ This E-Mail may contain Confidential and/or legally privileged Information and is meant for the intended recipient(s) only. If you have received this e-mail in error and are not the intended recipient/s, Kindly notify the sender and then delete this e-mail immediately from your system. You are also hereby notified that any use, any form of reproduction, dissemination, copying, disclosure, modification, distribution and/or publication of this e-mail, its contents or its attachment/s other than by its intended recipient/s is strictly prohibited and may be unlawful. Internet Communications cannot be guaranteed to be secure or error-free as information could be delayed, intercepted, corrupted, lost, or contain viruses. Sistema Shyam Teleservices Limited does not accept any liability for any errors, omissions, viruses or computer problems experienced by any recipient as a result of this e-mail.

3 2

Arista "sensors" module taking a very long time
by Spencer Ryan 23 Nov '15

23 Nov '15

I'm hoping the answer isn't "make arista fix their SNMP engine" Polling a 7280 (64 ports of 10G) takes about 180 second, with 99% of that time in the sensors module. Running it in debug I see a lot of stalls, and this effectively repeating CMD[/usr/bin/snmpget -v2c -c *** -Pu -OUqnv -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':' core-1.aa.it.arbor.net':'161' aristaEntSensorThresholdHighWarning] EXITCODE[1] CMD RUNTIME[0.005s] STDOUT[ ] STDERR[ aristaEntSensorThresholdHighWarning: Unknown Object Identifier (Sub-id not found: (top) -> aristaEntSensorThresholdHighWarning) ] SNMP_STATUS[FALSE] SQL[SELECT * FROM `snmp_errors` WHERE `device_id` = '96' AND `error_code` = '1002' AND `snmp_cmd` = 'snmpget' AND `snmp_options` = '-OUqnv' AND `mib` = 'SNMPv2-MIB' AND `oid` = 'aristaEntSensorThresholdHighWarning';] SQL RUNTIME[0.00026798s] SQL[UPDATE `snmp_errors` set `error_count` ='471101',`updated` ='1448318766' WHERE `error_id` = '802'] SQL RUNTIME[0.00107193s] Array ( [sensor_value] => ) [RRD Disabled - update /opt/observium/rrd/ core-1.aa.it.arbor.net/sensor-power-entity-sensor-100315212.rrd N:0] Any idea if that's something you can fix? *Spencer Ryan* | Senior Systems Administrator | sryan(a)arbor.net *Arbor Networks* +1.734.794.5033 (d) | +1.734.846.2053 (m) www.arbornetworks.com

3 4

Re: [Observium] How to delete ports of devices?
by Tim Toepp 20 Nov '15

20 Nov '15

Chaman, Are they actually down? Meaning not being used? Or are you saying they are being incorrectly reported? So if they are actually down and you are asking how to NOT see the down ports in your listing: when you are on the GUI and you are looking at the Ports of a specific Device, click under Quick Filter you can hide different ports based on their status and one of the option is 'Hide Down'. The downside is that it doesn't retain and I haven't found a system wide setting/preference. If this works for you, what you could do is submit a feature request to make it a global setting not just a Quick Filter. But you really do not want to delete ports that are down as then you'll have to add them later when they become in use. HTH, Tim Date: Wed, 18 Nov 2015 10:32:07 +0530 From: Chaman Rathee <chaman.rathee(a)progression.com> To: 'Observium Network Observation System' <observium(a)observium.org> Subject: [Observium] How to delete ports of devices? Message-ID: <000001d121be$462b9820$d282c860$(a)progression.com> Content-Type: text/plain; charset="us-ascii" Hi Team, I have many ports that are showing down at observium monitoring system. So, please suggest how to delete "Down Ports" in observium. ......... With Best Regards, Chaman Rathee Mob. No:- +91-9560055816 --------------------------------------------------------------------------------------------------------------------- This e-mail and any attachments are from a sender at the Metropolitan School District of Washington Township in Indianapolis, Indiana. They are intended for the named recipients and may contain information that is confidential or privileged under Indiana and Federal Law. Any error in addressing or sending this e-mail is not a waiver of confidentiality and does not consent to copying or distribution of this e-mail or attachments. If you receive this e-mail in error, please notify the sender of the error by return e-mail and delete this e-mail and its attachments. If there is a need to speak to the sender, please call [317] 845-9400 and they can provide you with contact information.

1 0

front page editing
by Josh Bierman 20 Nov '15

20 Nov '15

Hello All, I want to keep the default layout of the front page with one change: replace the map with a traffic graph. When I tried this using the [frontpage][order] line (removed map from order and put in a custom graph, included EVERYTHING else) , the "Devices,Ports,Sensors" table at the top diapered. How do i get it back? Even if the answer is as simple as RTFM-pages #-## that would help. Thanks, Joshua Bierman Director of Technology Yeshivat Noam

3 4

Hoosekeeping Biling/Groups
by Robin Douine 20 Nov '15

20 Nov '15

Hello, We have users who have billing and groups permission but when we launch /opt/observium/housekeeping.php -b, the users loose their rights. It seems the problem is linked to this log : 1 entity entries in tables 'entity_permissions' for non-existing devices will be deleted [y/N]: Indeed, billing and groups doesn't be directly linked to devices. Best regards -- Robin DOUINE

1 1

Monitoring Snom phones
by Tim Vaughan 19 Nov '15

19 Nov '15

Hi, I'm trying to add several Snom 710 phones. The documentation says they will accept SNMP requests (http://wiki.snom.com/Category:HowTo:SNMP). However, I can't add it from Observium even if I enter my installation's IP address as trusted in the phone config. Checking the phone logs after trying to add them, I see: 17/11/2015 11:19:53 [NOTICE] TOOLS: SNMP: Received unknown object identifier 06082b06010201010200 17/11/2015 11:19:53 [NOTICE] TOOLS: SNMP: Received unknown object identifier 06082b06010201010300 17/11/2015 11:20:03 [NOTICE] TOOLS: SNMP: Received unknown object identifier 06082b06010201010200 17/11/2015 11:20:03 [NOTICE] TOOLS: SNMP: Received unknown object identifier 06082b06010201010300 Has anyone managed to get their Snom phones talking to Observium? -- Mobile: 07868246225 Skype: tvaughan Twitter: twitter.com/tvaughan

9 30

Re: [Observium] Who's running Observium on distros that aren't Ubuntu/Debian/RHEL/CentOS?
by T-MONT Administrator 19 Nov '15

19 Nov '15

Hi Guys, My installation is running smoothly on Slackware Linux ver. 14.1 (x86_64). No special, dedicated actions performed to launch Observium beside of manual installation of RRDTool and few requires dependencies. Regards, Pawel On 19.11.2015 01:46, Ciro Iriarte wrote: > 2015-07-25 16:42 GMT-04:00 Adam Armstrong <adama(a)memetic.org>: > >> Hi Guys, >> >> Are any of you running Observium on distros which aren't the ones we >> recommend? >> >> Did you have to do anything special? >> >> I think we're probably way more friendly to non-debian distros now >> that >> we've lost a lot of legacy stuff! >> >> Thanks, >> adam. >> >> _______________________________________________ >> observium mailing list >> observium(a)observium.org >> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium >> >> > Running it on SLES11: > > https://iriarte.it/?p=158&lang=es > > Post can be improved after migration though :D > > > > > _______________________________________________ > observium mailing list > observium(a)observium.org > http://postman.memetic.org/cgi-bin/mailman/listinfo/observium >

1 0

Setting Location
by Josh Hopper 19 Nov '15

19 Nov '15

Is there a way via command line to set the Location of a device? For example, in the GUI you click on a given device and hover over the Gear in the far right. Then click Properties. Under the Device Settings tab there is a Custom Location. This is the location I would like to set. I ran an SNMP Enabler tool and enabled, set and added 100 devices today to Observium. Rather than set this individually, I was hoping I could do it in bulk via SSH. -- Sincerely, Joshua Hopper, A+ CE Sr. Network Administrator [cid:image001.jpg@01D11BAA.500B4080] 420 3rd Ave NW Hickory NC 28601 Office: 828-449-1839x2160 | Cell: 828-855-7565

9 24