- observium - lists.observium.org

Postgresql fails to execute?
by Kaya Saman 19 Aug '14

19 Aug '14

Hi, I'm running Observium on a FreeBSD 10.0-RELEASE x64 system. For some reason the Postgresql script isn't working; I have turned debugging on: set 0 -> 1 The output however just seems to be: ./postgresql.pl Execute Failed The odd thing is that other Perl based scripts are working on the same box. eg. Apache. the postgresql.conf file has the correct details: db_driver set to: Pg db_host is set to the IP address of the database Jail etc.... These modules are installed which I'm sure are the relevant ones: perl5-5.16.3_11 Practical Extraction and Report Language perl5-5.16.3_11 Practical Extraction and Report Language p5-Class-DBI-3.0.17_1 Simple Database Abstraction p5-Class-DBI-Pg-0.09_1 Extensions to Class::DBI for PostgreSQL p5-DBD-Pg-3.2.1 Provides access to PostgreSQL databases through the DBI p5-DBI-1.631 Perl5 Database Interface, required for DBD::* modules p5-DBIx-ContextualFetch-1.03 Add contextual fetches to DBI p5-Ima-DBI-0.35 Database connection caching and organization Would anyone be able to suggest anything? I have been looking at this: http://www.observium.org/wiki/Application/Postgresql but unfortunately it's not very helpful in my case. Permissions are also set properly. Thanks. Kaya ./postgresql.pl Execute failed ./postgresql.pl Execute failed root@Alpha-Ray: ./postgresql.pl Execute failed ./postgresql.pl Execute failed

1 0

Syslog msg empty temporary fix
by Pavelas Sokolovas 19 Aug '14

19 Aug '14

Hi, all. After dist upgrade from Ubuntu 12.04 to 14.04 syslog messages from cisco IOS devices became empty. There is a similar thread/bug: http://jira.observium.org/browse/OBSERVIUM-850 http://postman.memetic.org/pipermail/observium/2014-August/007527.html We’ve managed to work around it by changing: template ("$HOST||$FACILITY||$PRIORITY||$LEVEL||$TAG||$YEAR-$MONTH-$DAY $HOUR:$MIN:$SEC||$MSG||$PROGRAM\n") to: template ("$HOST||$FACILITY||$PRIORITY||$LEVEL||$TAG||$YEAR-$MONTH-$DAY $HOUR:$MIN:$SEC||:: : :: $MSG||$PROGRAM\n") in syslog config. For the developers: it happened after update of syslog/php to 3.5.3-1 [@9695e81] / PHP 5.5.9-1ubuntu4.3 from whatever was current on Ubuntu 12.04 LTS , worked fine before that. Also, the data examplesyslog sends to the script is: 10.x.x.x||local7||notice||notice||bd||2014-08-19 20:21:10||%SYS-5-CONFIG_I: Configured from console by xx on vty3 (10.x.x.xx)||BST Hope this helps! Pav Pavelas Sokolovas Custodian Data Centre Email: ps(a)CustodianDC.com http://www.CustodianDC.com

1 0

Billing history
by Simon Schmitz 19 Aug '14

19 Aug '14

hello, there is a plan for a billing history with over the last month? Greetings Simon

3 4

Question octets to Mbps conversion.
by Senses0 19 Aug '14

19 Aug '14

Hi, I am using below query to convert ifInOctets_rate to Mbps value. mysql> SELECT ifInOctets_rate, CONCAT(ROUND((ifInOctets_rate*8)/1024/1024,2), " Mbps") ConvertedValue FROM `ports-state` WHERE port_id=105; +-----------------+----------------+ | ifInOctets_rate | ConvertedValue | +-----------------+----------------+ | 55014356 | 419.73 Mbps | +-----------------+----------------+ The value I get different from the value printed on the graph for the same port_id. On the graph I got 427Mbps, while this conversion gives me 419. Since I don't know where in the code this conversion happens, I couldn't figure out if this is the way to go about it or not. Could someone shed some light? Thanks

4 6

Observium SNMP VMware Hosts
by Darian Jimenez 18 Aug '14

18 Aug '14

Hello, I am able to monitor pretty much everything from firewalls to switches but I am having problems with my vmware hosts. It will add the devices fine via SNMP but when it comes to polling them it will give an "SNMP UnreachableMySQL" after running the poller.php -h 'vmware host' It will show as down on the site and every now and then it comes back online. Then it will show as down again.Attached is a screenshot of the polling information.[image: Inline image 1]

2 1

Accessing our subscription
by Richard Berndt 18 Aug '14

18 Aug '14

We did purchase the subscription edition of Observium. How do we access the SVN?

2 1

Add_device fails at SNMP
by Richard Berndt 18 Aug '14

18 Aug '14

I am a little confused and looking for suggestions on what I can do to troubleshoot this issue. On the machine that I am running Observium on I can use snmpwalk to view the device’s system information. ubuntu@mgh-netmon:/opt/observium$ snmpwalk -Os -v 2c -c communitystring mx-hospital system sysDescr.0 = STRING: Meraki MX80 Cloud Managed Security Appliance sysObjectID.0 = OID: enterprises.29671.2.103 sysName.0 = STRING: MX-HOSPITAL sysORID.1 = OID: snmpMIB sysORID.2 = OID: vacmBasicGroup sysORID.3 = OID: ifMIB sysORDescr.1 = STRING: The MIB module for SNMPv2 entities sysORDescr.2 = STRING: View-based Access Control Model for SNMP. sysORDescr.3 = STRING: The MIB module to describe generic objects for network interface sub-layers sysORUpTime.1 = Timeticks: (1) 0:00:00.01 sysORUpTime.2 = Timeticks: (1) 0:00:00.01 sysORUpTime.3 = Timeticks: (16) 0:00:00.16 However when I use add_device it tells me that it cannot add the device. ubuntu@mgh-netmon:/opt/observium$ ./add_device.php mx-hospital communitystring v2c 161 udp Observium v0.14.4.5229 Add Device(s) Try to add mx-hospital: Trying v2c community communitystring ... No reply on community communitystring using v2c. Could not reach mx-hospital with given SNMP community using v2c. Devices skipped: 1. Any ideas? I know it Is not a network/firewall related issue since SNMPWALK can access the device. I know it is not an SNMP string issue because both SNMPWALK and another monitoring system is able to access this device using the provided SNMP string.

3 4

Up/Down Monitoring
by Lane Eckley 18 Aug '14

18 Aug '14

Hi Guys, I am attempting to setup an alert checker for when a server goes into a "down" state for either SNMP or Ping - ideally I would like to create one alert checker for each (ping & snmp). Reviewing the metrics documentation I believe I should be using a combination of the following two: device_status (0 = down, 1 = up) device_status_type (reason for down, 'snmp'/'ping') Using the above I am failing miserably it seems as I am unable to get the alert checker to "match" a machine I turned off to do the testing. Can anyone share a quick step by step on how to setup this alert checker correctly? Thanks! -Lane

3 4

Remove WiFi errors from dashboard
by Franjo Posavec 18 Aug '14

18 Aug '14

Is posible to remove wifi errors from dashboard, like on atachment? -- Franjo Posavec system administrator entitas d.o.o. M: +385 (0)98 8808 72 S: franjo.posavec

2 2

Observium Remote Poller Option
by Ben House 17 Aug '14

17 Aug '14

Hello There, Does Observium have an ability to deploy poller nodes. We currently support a number of fixed wireless networks in which we don't have visibility into. We are looking to deploy a remote node to poll/monitor remote network devices i.e deploy a VM into network and have necessary ports open back to master node and have single display? Let me what's possible for the above requirement. -- Message protected by MailGuard: e-mail anti-virus, anti-spam and content filtering. http://www.mailguard.com.au

2 1

http-auth
by John P Arends 17 Aug '14

17 Aug '14

I configured observium to use the http-auth method combined with our web sso system. I believe it is OpenAM, but I’m a consumer of the service and not someone who maintains it. I’m mentioning this because the docs state there are no known users of http-auth. It works well, and required no configuration on my part. I just have to create users for each person that match their campus NetIDs. This is incredibly useful.

2 1

Traffic Accounting > Accurate Graphs
by Spencer Gaw 15 Aug '14

15 Aug '14

Anyone else getting a jpgraph error 25008 when trying to view Accurate Graphs in Traffic Accounting? I don't frequent this area very often and just noticed it today. Regards, SG

1 1

Setting Alerts
by Darian Jimenez 15 Aug '14

15 Aug '14

hello, I want to setup alerts inside of observium to notify us if any links go down basically. Nothing fancy but just link connectivity/ping tests maybe. Is the alerting feature only available on the paid version? Thanks, Darian

1 0

Deleting Device
by Mike Glass 15 Aug '14

15 Aug '14

I have deleted a router that we no longer have in Observium, it is now back and replicates multiple times throughout the week, how can I keep this from happening, I have used both command line and web interface to delete. Thanks Mike

3 3

Harddisk email alerts
by Tech8 otelafrica 15 Aug '14

15 Aug '14

Hi guys I want to set up email alerts for harddrive space how would I set that up? Regards Anton

2 1

paid version not reporting any data
by Anthony Polselli 14 Aug '14

14 Aug '14

Got something very odd going on...after testing Observium, I purchased it and installed it onto a clean Ubuntu VM. Everything went fine, I added devices, cron job, etc and started to get some graphs. But yesterday and todays graphs are all blank. When I drill-down to a specific interface and click on real-time, I get these odd spikes where it shows 31Mbps In (which is high for this port). I did a side-by-side comparison to the test VM I setup with the free version of Observium and the real-time is working correctly there. [cid:image001.jpg@01CFB7C1.2D1F4970] __________________________________________ Anthony Polselli, Chief Technology Officer Natural Networks, Inc. 10225 Barnes Canyon Rd. Suite A105 San Diego, CA 92121 anthony(a)naturalnetworks.com<mailto:anthony@naturalnetworks.com> http://www.naturalnetworks.com<http://www.naturalnetworks.com/> (619) 222-3232 office (858) 202-0301 fax

1 0

Observium Syslog-NG and Cisco Catalyst
by Tomasz Karczewski 14 Aug '14

14 Aug '14

Hi, I've got one problem with logs from cisco catalyst switches. On switches logs looks fine but in observium i have something like that "% :" Other vendors looks fine in logs. Where could be the problem? Tomasz Karczewski Administrator Sieci 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 3

Observium constantly device down and up by ping
by Chris Pelling 14 Aug '14

14 Aug '14

Hi Guys, Our observium (latest) 0.14.8.5749 has for some time been showing devices up and down in the event log, graphs missing chucks of information as well. As an example, here is the memory usage on one ubnt box, but, its the same for others too (network / memory ) http://gyazo.com/18db347a5d49e557c082f343b8e96ea5 Here is the copy of the event log for the device : http://gyazo.com/4324c896e6cc268a8869d17c80964340 I can't seem to narrow it down. The machine is running Ubuntu 12.04.5 LTS and as mentioned above, latest Observium. Any ideas where to poke ? Its not a single device, its multiple devices. The only thing so far I have not swapped out is the server observium sits on. -- Kind regards, Chris

2 1

CBQoS 'drop' vs 'policed-transmit'
by Robert Williams 14 Aug '14

14 Aug '14

Hi, Just noticed that the CBQoS stuff has gone active recently (which is very cool) - currently we get all this via (very) painful integration with Cacti. On looking closer I've found what I think is an issue, but stand ready to be corrected. What I think is happening is that Observium is considering packets the Cisco counted as "Exceeded" to have been "Dropped" where in reality they were just re-marked and transmitted normally. As an example, here is the graph for gi3/1 (class-default) on a 6500 chassis: Here is the output of the show policy-map int gi3/1: GigabitEthernet3/1 Service-policy input: <name> class-map: <Class A> (match-any) Match: protocol arp Match: access-group name <ACL A1> Match: access-group name <ACL A2> police : 32000 bps 102400 limit 102400 extended limit Earl in slot 3 : 1377162657 bytes 5 minute offered rate 2280 bps aggregate-forwarded 1377162657 bytes action: transmit exceeded 0 bytes action: drop <- Zero drops aggregate-forward 2520 bps exceed 0 bps class-map: class-default (match-any) Match: any police : 40000000 bps 3200000 limit 3200000 extended limit 1000000000 pir-bps Earl in slot 3 : 10562039041987 bytes 5 minute offered rate 11748848 bps aggregate-forwarded 10562039041987 bytes action: set-dscp-transmit exceeded 297846881624 bytes action: policed-dscp-transmit violated 0 bytes action: drop <- Zero drops aggregate-forward 13842064 bps exceed 0 bps violate 0 bps So in summary, there have never been any actual drops on the port, only re-marking of the DSCP (incrementing the exceeded counter) and then a transmit. Since the re-marking occurs in the "exceeded" counter, I think Observium is considering them as dropped, instead of just exceeded. This also messes up the pre-policy and post-policy counters, because it implies that traffic didn't make it through when in reality it all did. We use re-marking extensively and so all of the CBQoS graphs show incorrect drop and post-policy information. Either that or we've got a bug/misconfiguration (or I just don't get it), so maybe someone else can confirm? Let me know what debug info is needed if it helps :) Cheers! Robert Williams Custodian Data Centre Email: Robert(a)CustodianDC.com http://www.CustodianDC.com

3 9

Possible bug in BGP Prefixes graphs?
by Erwin Heringa 14 Aug '14

14 Aug '14

Hi Observium team, Earlier this week the global route table hit 512k prefixes, so I was looking in Observium how many prefixes each peer announces. But there is something wrong that I can't explain and it could be a bug. This morning I upgraded to the latest (paid) version r5747, that didn't change this. For peer 195.69.144.192 my Juniper router shows 89 received prefixes: rtr1> show bgp neighbor 195.69.144.192 | match prefixes Active prefixes: 47 Received prefixes: 89 Accepted prefixes: 89 Advertised prefixes: 7 Via snmp on the router: This peer has index 155, and Peer with index 155 has 89 prefixes: rtr1> show snmp mib wal decimal 1.3.6.1.4.1.2636.5.1.1.2.1.1 | match 144.192 | match PeerIndex jnxBgpM2PeerIndex.0.1.195.69.144.49.1.195.69.144.192 = 155 rtr1> show snmp mib wal decimal 1.3.6.1.4.1.2636.5.1.1.2.6.2 | match \.155\. | match Prefixes jnxBgpM2PrefixInPrefixes.155.1.1 = 89 jnxBgpM2PrefixInPrefixesAccepted.155.1.1 = 89 jnxBgpM2PrefixInPrefixesRejected.155.1.1 = 42 jnxBgpM2PrefixOutPrefixes.155.1.1 = 7 Via snmp on the Observium server: snmpwalk -v3 -l authPriv -u ***** -a SHA -A ****** -x AES -X ******* rtr1 1.3.6.1.4.1.2636.5.1.1.2.6.2 | grep \.155\. iso.3.6.1.4.1.2636.5.1.1.2.6.2.1.7.155.1.1 = Gauge32: 89 iso.3.6.1.4.1.2636.5.1.1.2.6.2.1.8.155.1.1 = Gauge32: 89 iso.3.6.1.4.1.2636.5.1.1.2.6.2.1.9.155.1.1 = Gauge32: 42 iso.3.6.1.4.1.2636.5.1.1.2.6.2.1.10.155.1.1 = Gauge32: 7 But the graphs looks like this, with only 8 prefixes: [cid:image001.png@01CFB7A9.99364360] And even worse for our transit provider: rtr1> show bgp neighbor 195.69.144.34 | match prefixes Active prefixes: 158327 Received prefixes: 505071 Accepted prefixes: 505070 Advertised prefixes: 7 snmpwalk -v3 -l authPriv -u ***** -a SHA -A ***** -x AES -X ****** rtr1 1.3.6.1.4.1.2636.5.1.1.2.6.2.1 | grep '\.4\.1\.1' iso.3.6.1.4.1.2636.5.1.1.2.6.2.1.7.4.1.1 = Gauge32: 505068 iso.3.6.1.4.1.2636.5.1.1.2.6.2.1.8.4.1.1 = Gauge32: 505066 iso.3.6.1.4.1.2636.5.1.1.2.6.2.1.9.4.1.1 = Gauge32: 346727 iso.3.6.1.4.1.2636.5.1.1.2.6.2.1.10.4.1.1 = Gauge32: 7 [cid:image002.png@01CFB7AC.69D3A650] This behavior seems to have changed around March 1st. Any thoughts? Met vriendelijke groet, kind regards, Erwin Heringa SIDN | Meander 501 | 6825 MD | Postbus 5022 | 6802 EA | ARNHEM T +31 (0)26 352 55 59 | F +31 (0)26 352 55 05 erwin.heringa(a)sidn.nl | www.sidn.nl

1 0

syslog no msg
by Vilberg Eiríksson 14 Aug '14

14 Aug '14

Hi All, I have just set up observium now and successfulli integrated it with syslog-ng but i am not seeing anything in the message column. I have tried the patch from her: http://jira.observium.org/browse/OBSERVIUM-850?jql=text%20~%20%22msg%22 but it did not work. If i go to mysql and check the msg field in the syslog table it is just empy (or just has %). All my devices are cisco devices running IOS. Any ideas? Regards Vilberg

2 1

process list WMI
by Simon Smith 13 Aug '14

13 Aug '14

Hi all, just a quick question is the currently a WMI module that checks out for number of running Processes for a windows machine? or even a table I can look at to see the currently running processes on observium? I’ve seen your able to get ahold of the processes via WMI just not sure if the is one already integrated? if the isn’t, can anyone point me in the direction as to create the module ? regards Simon

2 1

Internet 512k global routes
by KENNETH D MILLER II 13 Aug '14

13 Aug '14

With the Internet hitting 512k routes, I was looking in observium for the IPv4 prefixes for our Brocade XMR routers. I'm getting a draw error on all prefix updates. graphs/type=bgp_updates is working ok. graphs/type=bgp_prefixes_ipv4unicast or any of the prefix graphs are not. I've tried on observium version 5728 and CE version 5229. Is anyone else using XMR, CES/CER, or MLX routers getting the same thing? Thanks, Ken

1 0

Description in CentOS Interfaces
by Andres Pugawko 13 Aug '14

13 Aug '14

Hi ! Somebody know if it is possible to add description in CentOS interfaces? There is a script for adding description in Debian interfaces, Is there another for centOS or somebody developed one? Regards Andres Pugawko Network Engineer Description: cid:image001.jpg@01CEAF1A.D081C8A0 Cámara Argentina de Internet – CABASE IXP Suipacha 128 - Piso 3° F (C1008AAD) Buenos Aires - Argentina Tel: (54-11) 4326-0777 int 9112 Cel: 11-6915-7866 <http://www.cabase.org.ar/> www.cabase.org.ar

2 1

Billing
by Mike Grant 13 Aug '14

13 Aug '14

I have the subscription version and have the billing working. What I am trying to do is work out if I can only bill certain traffic. i.e. I only want to charge for international traffic at a $ per MB rate but charge nothing for local traffic. I'm using a Mikrotik Cloudcore router, the international data goes out one gateway and the domestic out another. So I really only want to bill the data for a port that goes in and out one particular gateway. Anyone doing anything like this? Thanks, Mike.

4 5