- observium - lists.observium.org

Getting "DB schema not installed, first install it." After CE upgrade
by KA PDE 25 Feb '16

25 Feb '16

Hi everyone, Today I've upgraded a CE Observium from 0.15.6 to 0.16.1 and it broke. It only shows DB schema not installed. I've noticed some errors in update-errors.log [2016/02/25 07:37:08 +0000] discovery.php(29504): Error: (1046) No database selected [2016/02/25 07:37:08 +0000] discovery.php(29504): Query: ALTER TABLE `bgpPeers` ADD INDEX `bgp_cache` (`bgpPeer_id`, `device_id`, `bgpPeerState`, `bgpPeerAdminStatus`, `bgpPeerRemoteAs`); [2016/02/25 07:37:08 +0000] discovery.php(29504): Error: (1046) No database selected [2016/02/25 07:37:08 +0000] discovery.php(29504): Query: ALTER TABLE `ospf_instances` ADD INDEX `ospf_cache` (`device_id`, `ospf_instance_id`, `ospfAdminStat`); [2016/02/25 07:37:08 +0000] discovery.php(29504): Error: (1046) No database selected [2016/02/25 07:37:08 +0000] discovery.php(29504): Query: ALTER TABLE `vrfs` ADD INDEX `vrf_cache` (`vrf_id`, `device_id`, `mplsVpnVrfRouteDistinguisher`); [2016/02/25 07:37:08 +0000] discovery.php(29504): Error: (1046) No database selected [2016/02/25 07:37:08 +0000] discovery.php(29504): ====== Schema update 264 -> 265 ============== [2016/02/25 07:37:08 +0000] discovery.php(29504): Query: ALTER TABLE `alerts_maint` ADD INDEX `maint_cache` (`maint_start`, `maint_end`); [2016/02/25 07:37:08 +0000] discovery.php(29504): Error: (1046) No database selected [2016/02/25 07:37:08 +0000] discovery.php(29504): ====== Schema update 265 -> 266 ============== [2016/02/25 07:37:08 +0000] discovery.php(29504): Query: ALTER TABLE `snmp_errors` DROP INDEX `error_index`; [2016/02/25 07:37:08 +0000] discovery.php(29504): Error: (1046) No database selected [2016/02/25 07:37:08 +0000] discovery.php(29504): Query: ALTER TABLE `snmp_errors` ADD UNIQUE `error_index` (`device_id`, `error_code`, `snmp_cmd`, `mib`(50), `oid`(100)); [2016/02/25 07:37:08 +0000] discovery.php(29504): Error: (1046) No database selected The strange thing is that I recently upgraded another server with no issues. The only difference is that I added the following config line later as there was an alert in the GUI (and now I'm adding it from start): $config['db_extension'] = 'mysqli'; Any hint will be greatly appreciated. Best regards, Pau

2 2

hey thanks for "Reset Limits" [SEC=UNCLASSIFIED]
by Peter.Hine＠familycourt.gov.au 25 Feb '16

25 Feb '16

just found it thanks VM Peter Hine Senior Technical Support Engineer (Servers) FCoA ITS peter.hine(a)familycourt.gov.au ********************************************************************** The information contained in this e-mail (including any attachments) is for the exclusive use of the addressee. If you are not the intended recipient please notify the sender immediately and delete this e-mail. It is noted that legal privilege is not waived because you have read this e-mail. **********************************************************************

1 0

Possible bug
by Nagy Attila 24 Feb '16

24 Feb '16

Hi all, We are using a customized location rewrite function to split the SNMP location of devices into a human readable and a machine understandable format. We are using the community edition, and on updating to the recent version we were faced with thIS error message: PHP Fatal error: Cannot redeclare custom_rewrite_location() (previously declared in /opt/observium/config.php:87) in /opt/observium/config.php on line 102 This is a common error when a php file is included/required more than once, so I made a workaround by renaming config.php to config.user.php and using require_once() in the original config.php to load these directives (it needs absolute path otherways it cannot find the file). Shouldn't require_once/include_once be used in all the places where referencing config.php? Br, Tylla,

5 10

Observium syslog year -0001
by Jason Vanlandingham 24 Feb '16

24 Feb '16

Lately (Since last CE update, I think) I've been seeing syslog messages for my Cisco router with a date stamp of "-0001-11-30" with text reading just something like "1:1". A little searching reveals that there was a mail list post from July 2014 for the same thing happening with Netgear equipment, but the only way I could see that post was through Google's cached result, and I can't find any replies. Is anyone else getting this? Known issue, perhaps?

1 0

Cisco SB SFP DOM/DDM monitoring
by chott＠praha1.net 24 Feb '16

24 Feb '16

Hello team, today i find OID for SFP monitoring in Cisco SB in this case there is OID and CLI info from CISCO SG300-10 switch and SFP in slot GI9 with DOM support can you add to Observium ? like Catalyst switches? Only in CLI there is mW for Power in SNMPwalk there is dBm but same value dBm is right value for DOM monitoring iso.3.6.1.4.1.9.6.1.101.90.1.2.1.3.57.5 = INTEGER: 47 iso.3.6.1.4.1.9.6.1.101.90.1.2.1.3.57.6 = INTEGER: 3211700 iso.3.6.1.4.1.9.6.1.101.90.1.2.1.3.57.7 = INTEGER: 6289 iso.3.6.1.4.1.9.6.1.101.90.1.2.1.3.57.8 = INTEGER: -6809 iso.3.6.1.4.1.9.6.1.101.90.1.2.1.3.57.9 = INTEGER: -9626 iso.3.6.1.4.1.9.6.1.101.90.1.2.1.3.57.10 = INTEGER: 0 iso.3.6.1.4.1.9.6.1.101.90.1.2.1.3.57.11 = INTEGER: 0 iso.3.6.1.4.1.9.6.1.101.90.1.2.1.3.57.12 = INTEGER: 0 Port Temp Voltage Current Output Input LOS [C] [Volt] [mA] Power Power [mWatt] [mWatt] ----------- ------ ------- ------- ------- ------- --- gi1 Copper gi2 Copper gi3 Copper gi4 Copper gi5 Copper gi6 Copper gi7 Copper gi8 Copper gi9 47 3.20 6.28 0.20 0.10 No gi10 N/A N/A N/A N/A N/A N/A Temp - Internally measured transceiver temperature Voltage - Internally measured supply voltage Current - Measured TX bias current Output Power - Measured TX output power in milliWatts Input Power - Measured RX received power in milliWatts LOS - Loss of signal N/A - Not Available, N/S - Not Supported, W - Warning, E - Error Tom [email-header-praha1] Tomas Chott technický ředitel chott(a)praha1.net<mailto:chott@praha1.net> Phone: +420 245 004 005 Mobile: +420 733 123 135 Metropolitní síť Praha 1 z.s.p.o. Jindrisska 18 110 00 Praha 1 Czech Republic www.praha1.net<http://www.praha1.net> [Popis: Facebook]<http://www.facebook.com/praha1net> <http://www.linkedin.com/pub/tomas-chott/49/97a/1aa>

4 16

Rancid-Mail configuration
by Sathish.I 23 Feb '16

23 Feb '16

Hi All, I am very new to observium, I have successfully integrated rancid with Observium, taking backup ups. However, I am unable to receive the mail when config difference. Can any share the config template to integrate rancid and mail configuration for configuration changes. Thanks in advance. Regards, sathish

2 1

Correct version not shon after device(raouter) upgradation
by Rakesh Vyas 23 Feb '16

23 Feb '16

Hi, Observium is not showing correct version after router version up gradation. We have to delete and add that device again. Any process to get auto update. Best regards Rakesh Vyas Lead, Network Data Operations Division Network, CORPORATE CENTER Sistema Shyam Teleservices Limited MTS Tower1 Building No. 334, Udyog Vihar Phase IV,Gurgaon MTS +91 913 600 1375 Direct Email: Rakesh.Vyas(a)MTSIndia.in [cid:image001.jpg@01D16E23.17796F00]<http://www.mtsindia.in/> ________________________________ 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

EIGRP
by Jason Vanlandingham 23 Feb '16

23 Feb '16

I've been running OSPF but am changing to EIGRP. EIGRP isn't showing in the routing section when I look at devices.

13 22

Export/import hosts
by Laszlo Nemeth 23 Feb '16

23 Feb '16

Hello, Because we have a problem with the alerts (if i set up an alert the Observium send an alert in every 5 minutes instead of 1 alert / 24 hour ) i decided to reinstall the Observium (First i installed the 201506(?) CE and updated it to CE 0.16.1.7533) So the question is can i export the hosts and import back after the reinstall procedure? Currently i have more than 50 hosts, so it is faster if i can just do an export/import instead of add all host again…. Thanks Laszlo

1 0

losing device information after adding IP SLA
by Bastiaan Topper 23 Feb '16

23 Feb '16

Hi, We have a few devices in our Observium installation which lost some sensor en memory pools during discovery. See below. It looks like the problem started around 5 days ago. [cid:image004.png@01D16E44.AA924840] It looks like that after enabling a new IP SLA config on a new device, and running a discovery, first the new IP SLA entity appeared. But after waiting a few minutes, the IP SLA and more entities, disappeared. [cid:image005.png@01D16E46.CFB02A50] I attached the discovery debug information for both hosts. How can we get this back to work? Did anything change in the discovery and/or IP SLA around 5 days ago? Thanks and regards, Bastiaan

1 0

Mini-graphs not clickable?
by Jason Vanlandingham 23 Feb '16

23 Feb '16

I did the CE update a few days ago and now the minigraphs in the header of a device's overview aren't clickable anymore. I rather liked having that shortcut.

1 0

Normal Users not getting permissions using Active Directory
by Schrader, Spencer R 22 Feb '16

22 Feb '16

I have included the link at the bottom to where I described the issue which was marked “resolved” and I was pointed here for help. I have the professional version of observium where users are all successfully authenticating, but when normal users log in they can’t see anything. I edited there permissions and allowed them all to see multiple devices(screenshot in link),but they still can’t see anything. Observium recognizes they log in as normal users, but doesn’t let them see any of the other devices they have access to. Global Read, and administrators work fine. I posted my ldap config and a few screenshots in the link. http://jira.observium.org/browse/OBSERVIUM-1684 Thanks for your time! -Spencer

5 8

Dell ESXi v6 hosts RAM not reporting
by Pedrosi, Derek G. 22 Feb '16

22 Feb '16

I have a few host that were recently upgraded from ESXi5.1 to ESXi6.0. After upgrading, Observium no longer is reporting on physical RAM, at all. Host are Dell r810/r720; at time of upgrade their OpenManage was also upgraded to 8.2. The Observium event log for the servers say... "Memory pool removed: mib host-resources-mib, index 27, descr Real Memory" So I see it was removed, but why? I did an smptwalk on the box "snmpwalk -v2c -c XXXXX 10.X.X.X .1.3.6.1.2.1.25.2.2.0"--> HOST-RESOURCES-MIB::hrMemorySize.0 = INTEGER: 536857360 Kbytes It looks like the value it still there. Can anyone shed some light on this? Thanx in advance, derek

1 0

Alert Checker for Smokeping
by Lyndon Labuschagne 22 Feb '16

22 Feb '16

Hi All does anyone know if you can setup an alert checker for smokeping, say at 20ms etc send an email alert? Still trying to get my head around some of the alerting options, Is there a global list off all the Conditions somewhere?

3 4

Non-Critical - Device Allocation
by Cameron Murray 21 Feb '16

21 Feb '16

Guys, Thought you might want to add a definition for the Dell Networking X4012 10Gb Siwtch. Currently appears as a Generic Device. [cid:image001.png@01D16D4B.6B18B090] Regards, Cameron Murray Remote Support Engineer How am I doing? Please click here<http://www.techpath.com.au/contact-us/feedback/> to rate my work. [cid:image002.png@01D16D4B.6B18B090]<http://www.techpath.com.au/> P 1300 033 300 F 07 3809 3999 E cameron(a)techpath.com.au www.techpath.com.au<http://www.techpath.com.au> Unit 2/55 Tradelink Rd, Hillcrest QLD 4118 [Facebook]<http://www.facebook.com/techpathau> [Twitter]<http://twitter.com/techpathau> [LinkedIn]<http://www.linkedin.com/company/techpathau> 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.

2 1

Problens BGP peers
by Layon - NOC ISPNETWORK 20 Feb '16

20 Feb '16

Hello currently use to monitor my obsrvium BGP sessions with Cisco routers is the best monitoring system that already utilized it is exelente , I have some routers mikrotik and would like to know how to monitor sessions BGP , OSPF routers MikroTik could help me Thank you IT Manager Layon Santos Cota

2 2

Re: [Observium] mysqld: The table 'ports_cbqos' is full - solved, probably
by Fältman, Mikael 20 Feb '16

20 Feb '16

Hi again. Increased innodb_buffer_pool_size and restarted mysqld - solved the problem. Buffer_pool_size has probably nothing to do with this issue but I was also getting warnings about buffer pool is occupied by InnoDB: lock heaps or the adaptive hash index. It is a good thing to sometimes keep a peek into /var/log/mysqld.log file (or where ever it is stored). BR Mikael From: observium [mailto:observium-bounces@observium.org] On Behalf Of Fältman, Mikael Sent: den 18 februari 2016 10:27 To: Observium Network Observation System Subject: [Observium] mysqld: The table 'ports_cbqos' is full Hello. Running: Observium CE 0.16.1.7533 on RedHat 6.4 Keep getting this error msg in /var/log/mysqld.log 160218 10:21:28 [ERROR] /usr/libexec/mysqld: The table 'ports_cbqos' is full What can I do to fix it ? Disk space is available. BR Mikael

3 3

Development questions
by Philipp Griess 19 Feb '16

19 Feb '16

Dear all, I am currently developing a new application agent for Oracle databases and need some guidance on how to implement it properly. My first goal is to get the current and historical usage of each tablespace - a DB consists of multiple tablespaces. This would give a good overview of data growth inside a database. My application agent running on my DB is polling the data via SQL and returning it to observium as comma spaced values. The output looks as follows: CIT;600;596.63 COMPASS;28488;1406.5 COMPASS_IDX;27996;1568.06 CONFIG;1000;959.69 CONTROLLING;600;596.69 CSR;40960;4966 Now I'm almost at my question. All existing application agents I know are rather static, containing only certain fixed (and hard coded) entities. Tablespaces are much like storage in my point of view so I think it would be a good idea to implement them as a new storage-type in the storage table of the observium database. Is this a proper way to do it or do you suggest a different approach? I'd like to be as compatible as possible to future updates and would also contribute my code if anyone needs it. Please let me know your thoughts. Thanks and kind regards, Philipp

1 0

mysqld: The table 'ports_cbqos' is full
by Fältman, Mikael 18 Feb '16

18 Feb '16

Hello. Running: Observium CE 0.16.1.7533 on RedHat 6.4 Keep getting this error msg in /var/log/mysqld.log 160218 10:21:28 [ERROR] /usr/libexec/mysqld: The table 'ports_cbqos' is full What can I do to fix it ? Disk space is available. BR Mikael

1 0

Fwd: Removing Dashboard
by Andres P 18 Feb '16

18 Feb '16

Hi Guys! After do the observium upgrade appears in the frontpage on the left a Dashboard, there is any form to remove it and come back to the old template. Regards Andres

3 3

Unknown Locations in Device > Locations menu
by Jacob Bisby 18 Feb '16

18 Feb '16

Hi All I'm having some trouble with Observium's mapping - we have it configured to build the Location list and geolocation, etc automatically based on the address/location pulled via SNMP. This works for almost every device we have, but there are two devices which show up under Unknown Location, even though Observium has pulled correct and valid address data for them. It does not appear to successfully pull co-ordinates for the address either, as the two devices appear on the map in the middle of the ocean. I have tried switching from the Yahoo API to the Google API (with API key) but this has not changed the behaviour of the issue. Currently on version 0.16.2.7592, we update via SVN once a month and we were having this same issue on 0.16.1.x as-well. Hoping somebody here has seen this issue before and can help me out or point me in the right direction.

2 5

High CPU usage on Observium
by Jose Colin 17 Feb '16

17 Feb '16

Hello Guys i see a lot of php processes running on the server, do you have any idea about this behavior if it needs to change some configuration stuff? top - 23:43:36 up 1:33, 1 user, load average: 19.78, 18.44, 16.29 Tasks: 240 total, 24 running, 216 sleeping, 0 stopped, 0 zombie %Cpu(s): 82.7 us, 16.6 sy, 0.0 ni, 0.0 id, 0.0 wa, 0.0 hi, 0.7 si, 0.0 st KiB Mem: 3945832 total, 2334788 used, 1611044 free, 235988 buffers KiB Swap: 4194300 total, 0 used, 4194300 free. 954876 cached Mem PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 12364 root 20 0 136472 30692 10532 R 4.983 0.778 0:22.10 php 23927 root 20 0 139032 33248 10536 R 4.983 0.843 0:39.62 php 32704 root 20 0 145432 39780 10536 R 4.983 1.008 1:11.48 php 30112 root 20 0 134652 28824 10532 R 3.654 0.730 0:16.65 php 5722 root 20 0 155420 49628 10536 R 3.322 1.258 2:25.48 php 17915 root 20 0 133372 27524 10532 S 3.322 0.698 0:09.60 php 20140 root 20 0 152344 46608 10536 R 3.322 1.181 1:55.92 php 26947 root 20 0 136984 31220 10536 R 3.322 0.791 0:26.82 php 10380 root 20 0 154136 48280 10536 S 2.990 1.224 2:10.99 php 20593 root 20 0 142360 36632 10536 S 2.990 0.928 0:55.83 php 30207 root 20 0 151320 45408 10536 S 2.990 1.151 1:50.79 php 1680 mysql 20 0 979436 141336 7308 S 2.326 3.582 1:15.83 mysqld 17979 root 20 0 143896 38228 10536 R 2.326 0.969 1:06.13 php 530 root 20 0 133884 28112 10532 R 1.993 0.712 0:11.50 php 9628 root 20 0 138520 32664 10536 R 1.993 0.828 0:33.49 php 30062 root 20 0 148504 42712 10536 R 1.661 1.082 1:28.73 php 6361 root 20 0 141088 35480 10536 S 1.329 0.899 0:47.94 php 3407 root 20 0 142616 36804 10536 S 0.997 0.933 1:00.61 php 13068 root 20 0 150040 44220 10536 S 0.997 1.121 1:41.53 php 15851 root 20 0 152600 46744 10536 R 0.997 1.185 2:02.85 php 8427 root 20 0 154648 48844 10536 S 0.664 1.238 2:19.62 php 15440 root 20 0 146456 40572 10536 S 0.664 1.028 1:19.81 php 595 root 20 0 12032 3800 672 S 0.332 0.096 0:14.53 haveged 3474 root 20 0 133116 27260 10532 S 0.332 0.691 0:07.57 php 11900 root 20 0 16100 1692 1108 R 0.332 0.043 0:03.48 top 12576 root 20 0 153112 47328 10536 S 0.332 1.199 2:07.73 php thanks for your attention. Jose

3 5

Missing dBm in Cisco IOS
by chott＠praha1.net 17 Feb '16

17 Feb '16

Hello team, after some upgrade in history now missing SFP dBm in Cisco 3750 platform in Cisco Catalyst 6500 show dBm SFPs [email-header-praha1] Tomas Chott technický ředitel chott(a)praha1.net<mailto:chott@praha1.net> Phone: +420 245 004 005 Mobile: +420 733 123 135 Metropolitní síť Praha 1 z.s.p.o. Jindrisska 18 110 00 Praha 1 Czech Republic www.praha1.net<http://www.praha1.net> [Popis: Facebook]<http://www.facebook.com/praha1net> <http://www.linkedin.com/pub/tomas-chott/49/97a/1aa>

2 2

Device mix-up
by Laz C. Peterson 17 Feb '16

17 Feb '16

So, weird thing happened today … We had a network outage that lasted for maybe 45 minutes that kept Observium from monitoring one site. When Observium resumed its normal monitoring activities, it somehow added a whole bunch of inventory items for a Cisco router to a KVM virtual server. About 10 minutes ago, it deleted all of the Cisco items, and is now back to normal. Has anyone seen anything like this before? Does anyone know what might have caused this? ~ Laz Peterson Paravis, LLC

2 3

Traffic Accounting not updating
by Cameron Murray 16 Feb '16

16 Feb '16

Adam, It appears that our OBS isn't updating the accounting details such as 95%ile. The cron task is identical to the how-to. What command can we run to manually update these figures?

3 6