- observium - lists.observium.org

Query optimization
by Eduardo Schoedler 02 Sep '15

02 Sep '15

# User@Host: observium[observium] @ localhost [] # Query_time: 0.003876 Lock_time: 0.000048 Rows_sent: 0 Rows_examined: **2836** SET timestamp=1441208020; SELECT `device_id` FROM `ports` WHERE `deleted` = '0' AND `ifPhysAddress` = '001ec9943fdd' LIMIT 1; ALTER TABLE `observium`.`ports` ADD INDEX `ports_ifPhysAddress` USING BTREE(`ifPhysAddress`, `deleted`); OPTIMIZE TABLE `observium`.`ports`; Same query, now using index. ;) Thanks! -- Eduardo Schoedler

1 0

windows servers not showing under servers
by Casper Allerslev Jensen 02 Sep '15

02 Sep '15

Hi all, When i go to Device -> servers I only see my linux servers My windows servers doesn't show.. Only when i remove server option in device type and click search do i see them. Why is that? the windows server has the type=server so i don't get why i don't see it when searching for servers?

1 0

Override IfAlias
by Jarno Tensen 01 Sep '15

01 Sep '15

Hi all, Does anyone know how to override the ‘ifAlias’ setting? Just like the ‘sysLocation’? We have a lot of network devices which are not able to give a port description, what is very annoying cause we have to go physical to a switch to find out which device is behind the port. I know a lot of settings can be configured in config.php, does anyone know a configline to manual setup a portdescription (ifAlias)? Many thanks in advance! Regards, Jarno Met vriendelijke groet, Kind regards, Jarno Tensen Systeem- en Netwerkbeheerder [cid:imagecff646.JPG@12e175e4.45946183] Savannahweg 8 3542 AW Utrecht T 030 - 261 91 96 F 030 - 261 69 77 E Jarno.Tensen(a)A2SP.nl W http://www.a2sp.nl<http://www.a2sp.nl/> [cid:image7c3561.JPG@8d03535a.49a528e9] DISCLAIMER Op deze e-mail is de disclaimer van A2SP van toepassing: http://www.a2sp.nl/disclaimer

4 8

Debian 8
by Andrew Colin 01 Sep '15

01 Sep '15

Hi Guys Will we have any issues if we do an apt-get dist-upgrade to debian 8?

4 7

Multiple CPU
by Cameron Murray 01 Sep '15

01 Sep '15

Guys, I have checked the guides however Not seeing how to configure CPU alerting based on multiple CORE CPU's. We have quite a number of windows virtual machines with 2 - 16+ cores and currently use "processor_usage greater 65" however this is alerting when a single core reaches >65% What is the best way to manage this? Regards, Cameron Murray

3 13

Introduction, polling time questions, other bits
by Aaron Finney 01 Sep '15

01 Sep '15

Hello, We've just started a POC project to determine if Observium is a good fit for our environment, and so far have been very pleased with the feature-richness and general usability of the entire system. In fact, we've discovered several things in our environment that were immediately addressable. Cheers! One thing that's been a head-scratcher for us so far is the length of the polling time for our Juniper switches...anywhere from ~2 mins for a 48 port EX ToR switch, to 8 minutes for a two-member QFX aggregate switch. It's the port polling that's so costly according to the output of the poller script, around 450 seconds on the QFXs. I've tried some basic troubleshooting...disabling MAC accounting, disabling all ports for polling/alerting, etc...but it hasn't helped. Is there something simple I'm missing in the config that's causing it to bog down on the port module? Aside from the time, it's not hurting the QFXs, but our poor EX4500s sometimes spike to 90% CPU during polling. For context, the Observium POC system is located in the same datacenter as the devices we're polling against, and the QFXs are 96 port 5ks, with uplinks to our EX ToR switches. Any ideas/suggestions you have would be much appreciated! Also, I did add support for Baytech PDUs; if there's interest, I'd be happy to provide the code. Aaron

2 3

APC Power aggregate graphs
by Cameron Murray 01 Sep '15

01 Sep '15

Guys, Is there a way to aggregate graphs for Power consumption? We use Billing for Data aggregate however would like to see similar for other fields. Regards, Cameron Murray

1 0

Device shown as down after change of ip address - DNS works.
by ecaroh 31 Aug '15

31 Aug '15

Hello, i had to change the ip address of one server from 192.168.102.21 to 192.168.102.40. After that the server is shown as down. DNS works so far, dns resolution from observium gives me the new address. Im sure it is a small problem, but i have no clue. Do i have to make a rediscover and if so how? THX in advance ecaroh

3 4

Syslog Filter Cisco ASA messages
by Andre Geißler 31 Aug '15

31 Aug '15

Hi When trying to filter syslog messages by program for Cisco ASA messages (%ASA-2-106017) I get an bad request from apache due to the % sign. The url called is http://observium/syslog/program=%25ASA-2-106017/ Regards Andre

1 0

Re: [Observium] Alert Emails Not sending
by Tom Laermans 30 Aug '15

30 Aug '15

I'm no expert on this but maybe because you set default_only to true in the config? On Aug 27, 2015 7:05 AM, Casper Allerslev Jensen <casper(a)dingit.dk> wrote: > > Hi, > > I can confirm that installing postfix and hardcode the reciving mailbox in config.php works. But it doesn't use the contacts im making in the observium gui which seems to be the same issue Cameron has. > > the funny thing is my spam filter blocks the email, well to be expected, but it shows it comming from root@observium even though my config.php says: > > // Set up a default alerter (email to a single address) > $config['email']['default'] = "it(a)dingit.dk"; > $config['email']['from'] = "Observium <observium(a)dingit.dk>"; > $config['email']['default_only'] = TRUE; > > any ideas? > > Also i couldn't find any documentation on how to set up email service in observium. I figured it out from Adams and Cameron conversation on the mail list. > > > ________________________________ > Fra: "Adam Armstrong" <adama(a)memetic.org> > Til: "Observium Network Observation System" <observium(a)observium.org> > Sendt: torsdag, 27. august 2015 01:30:22 > Emne: Re: [Observium] Alert Emails Not sending > > Does the alert log show them as being sent? > > They will only be sent when they first occur, so you'll need to have new ones for any new alerts to be sent. > > Adam. > > Sent with AquaMail for Android > http://www.aqua-mail.com > > On 26 August 2015 11:46:40 pm Cameron Murray <cameron(a)techpath.com.au> wrote: >> >> Adam, >> >> >> >> Thanks yes – When I test with the ./test_mail.php -h bne-b1-lvl4-r1-apc2 I receive the email correctly however none of the alerts come through. >> >> >> >> Regards, >> >> Cameron Murray >> Remote Support Engineer >> >> How am I doing? Please click here to rate my work. >> >> >> >> P 1300 033 300 >> F 07 3809 3999 >> E cameron(a)techpath.com.au >> >> www.techpath.com.au >> >> Unit 2/55 Tradelink Rd, Hillcrest QLD 4118 >> Formerly Betta Computer Services Pty Ltd >> >> Note: This message may contain privileged and confidential information that is the property of the intended recipient. The information herein is intended only for use of the addressee. If you are not the intended recipient, then you are requested to return e-mail to TechPath Pty Ltd and destroy any copies made. Copying or disseminating any of this message is prohibited. Any views expressed in this message are those of the individual sender and may not necessarily reflect the views of TechPath Pty Ltd. >> >> From: observium [mailto:observium-bounces@observium.org] On Behalf Of Adam Armstrong >> Sent: Thursday, 27 August 2015 8:41 AM >> To: Observium Network Observation System >> Subject: Re: [Observium] Alert Emails Not sending >> >> >> >> Ahh indeed, that's true. You never actually tell it to use SMTP, even though you set the SMTP options! >> >> In that case, make sure the local mail relay is installed and configured (probably just apt-get install postfix) and check /var/log/mail.log >> >> Adam. >> >> Sent with AquaMail for Android >> http://www.aqua-mail.com >> >> On 26 August 2015 11:28:51 pm Cameron Murray <cameron(a)techpath.com.au> wrote: >>> >>> Thanks Adam, >>> >>> >>> >>> It appears to already be using the php backend to send emails: >>> >>> >>> >>> E-mails ENABLED globally ($config['email']['enable']) >>> >>> E-mails use PHP-builtin MAIL backend ($config['email']['backend']) >>> >>> E-mails send only to default email ($config['email']['default_only']) >>> >>> E-mails use these default recipient(s) ($config['email']['default']): >>> >>> >>> >>> Regards, >>> >>> Cameron Murray >>> >>> >>> From: observium [mailto:observium-bounces@observium.org] On Behalf Of Adam Armstrong >>> Sent: Thursday, 27 August 2015 8:20 AM >>> To: Observium Network Observation System >>> Subject: Re: [Observium] Alert Emails Not sending >>> >>> >>> >>> Remove all of the SMTP configutation and just let php send the mail using the local MTA itself. >>> >>> You'll need to make sure one is installed, but its fairly straightforward with Debian/Ubuntu. >>> >>> Adam. >>> >>> Sent with AquaMail for Android >>> http://www.aqua-mail.com >>> >>> On 26 August 2015 11:18:57 pm Cameron Murray <cameron(a)techpath.com.au> wrote: >>>> >>>> Adam, >>>> >>>> >>>> >>>> Can you recommend a working configuration? >>>> >>>> >>>> >>>> Regards, >>>> >>>> Cameron Murray >>>> >>>> >>>> >>>> From: observium [mailto:observium-bounces@observium.org] On Behalf Of Adam Armstrong >>>> Sent: Thursday, 27 August 2015 8:08 AM >>>> To: Observium Network Observation System >>>> Subject: Re: [Observium] Alert Emails Not sending >>>> >>>> >>>> >>>> Don't use remote SMTP It never works properly. >>>> >>>> Adam. >>>> >>>> Sent with AquaMail for Android >>>> http://www.aqua-mail.com >>>> >>>> On 26 August 2015 10:47:42 pm Cameron Murray <cameron(a)techpath.com.au> wrote: >>>>> >>>>> Guys, >>>>> >>>>> >>>>> >>>>> Only new to Observium and it’s a great product! >>>>> >>>>> >>>>> >>>>> Setting up the email alerts and testing from the cli works perfectly however automated alerts configured via the interface do not send. The alerts trigger in the interface and the contact groups are configured. >>>>> >>>>> >>>>> >>>>> Test Email from cli: >>>>> >>>>> >>>>> >>>>> [root@obs observium]# ./test_mail.php -h bne-b1-lvl4-r1-apc2 >>>>> >>>>> Observium 0.15.8.6920 >>>>> >>>>> Test E-mail Configuration >>>>> >>>>> >>>>> >>>>> ##### Software versions ##### >>>>> >>>>> >>>>> >>>>> o OS Linux 2.6.32-504.23.4.el6.x86_64 [amd64] (CentOS 6.7) >>>>> >>>>> o Apache 2.2.15 >>>>> >>>>> o PHP 5.5.28 >>>>> >>>>> o Python 2.6.6 >>>>> >>>>> o MySQL 5.1.73 (extension: mysqli 5.1.73) >>>>> >>>>> o SNMP NET-SNMP 5.5 >>>>> >>>>> o RRDtool 1.3.8 >>>>> >>>>> >>>>> >>>>> ##### Charset info ##### >>>>> >>>>> >>>>> >>>>> o PHP UTF-8 >>>>> >>>>> o MySQL utf8 >>>>> >>>>> >>>>> >>>>> ##### Timezones info ##### >>>>> >>>>> >>>>> >>>>> o Date Wednesday, 26-Aug-15 21:43:01 UTC >>>>> >>>>> o PHP +10:00 >>>>> >>>>> o MySQL +10:00 >>>>> >>>>> >>>>> >>>>> See mail backend options here: http://www.observium.org/wiki/Configuration_Options#Email_backend_settings >>>>> >>>>> >>>>> >>>>> My Hostname: obs.tech….. >>>>> >>>>> E-mails ENABLED globally ($config['email']['enable']) >>>>> >>>>> E-mails use PHP-builtin MAIL backend ($config['email']['backend']) >>>>> >>>>> E-mails send only to default email ($config['email']['default_only']) >>>>> >>>>> E-mails use these default recipient(s) ($config['email']['default']): >>>>> >>>>> alert-infrastructure@tech...... >>>>> >>>>> E-mails send from ($config['email']['from']): >>>>> >>>>> monitoring@tech...... >>>>> >>>>> E-mails send to recipients based on default recipient from config and/or device sysContact. >>>>> >>>>> Try send test notification for bne-b1-lvl4-r1-apc2 to these email(s): >>>>> >>>>> alert-infrastructure@tech...... >>>>> >>>>> EMAILINGNotification for bne-b1-lvl4-r1-apc2 SENT. >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> Config.php > Email Config >>>>> >>>>> >>>>> >>>>> // Enable alerter >>>>> >>>>> $config['poller-wrapper']['alerter'] = TRUE; >>>>> >>>>> >>>>> >>>>> $config['billing']['customer_autoadd'] = 0; # Enable Auto-add bill per customer >>>>> >>>>> $config['billing']['circuit_autoadd'] = 0; # Enable Auto-add bill per circuit_id >>>>> >>>>> $config['billing']['bill_autoadd'] = 0; # Enable Auto-add bill per bill_id >>>>> >>>>> >>>>> >>>>> $config['email']['sendmail_path'] = '/usr/sbin/sendmail'; >>>>> >>>>> >>>>> >>>>> $config['alerts']['alerter']['default']['descr'] = "System Alert Change"; >>>>> >>>>> $config['alerts']['alerter']['default']['type'] = "email"; >>>>> >>>>> $config['alerts']['alerter']['default']['contact'] = "monitoring@tech......"; >>>>> >>>>> $config['alerts']['alerter']['default']['enable'] = TRUE; >>>>> >>>>> >>>>> >>>>> $config['email']['default'] = "alert-infrastructure@tech...... "; >>>>> >>>>> $config['alerts']['email']['from'] = "monitoring@tech....."; >>>>> >>>>> $config['email']['default_only'] = TRUE; >>>>> >>>>> >>>>> >>>>> $config['email']['from'] = "monitoring@tech....."; >>>>> >>>>> >>>>> >>>>> $config['email']['smtp_host'] = 'mx01…….; >>>>> >>>>> $config['email']['smtp_port'] = 587; >>>>> >>>>> $config['email']['smtp_timeout'] = 10; >>>>> >>>>> $config['email']['smtp_secure'] = tls; >>>>> >>>>> $config['email']['smtp_auth'] = FALSE; >>>>> >>>>> >>>>> >>>>> Contact List configuration: >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> Any pointers are appreciated. >>>>> >>>>> >>>>> >>>>> Regards >>>>> >>>>> >>>>> >>>>> Cameron >>>>> >>>>> _______________________________________________ >>>>> 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

4 48