- observium - lists.observium.org

New Admin User creation
by Sathish.I 17 Mar '16

17 Mar '16

Hello All, I lost my admin user password, and I have created new user as below with level10. But when I logged into GUI with observium user id and password I am not able to login. Error is Wrong username and password. Can you please help me. ~# ~# ~# cd /opt/observium/ /opt/observium# ./adduser.php observium Password@123 10 Observium 0.16.1.7535 Add User User observium added successfully. /opt/observium# Regards, Sath

3 7

Alerts x contacts
by Eduardo Schoedler 17 Mar '16

17 Mar '16

Hi, I registered a few contacts in Observium Alerts, but it's not using them. Can I specify a different contact for different alerts? Thank you. Regards, -- Eduardo Schoedler

2 2

Not able to add juniper router
by Ankit Dubey 16 Mar '16

16 Mar '16

Hi, Not able to add juniper routers( Juniper MX104 & Juniper ACX1100) to my License version observium . When we are trying to run SNMP walk from OBSERVIUM, Juniper is not giving full result. 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.

3 4

Recommendation to support 20K devices on observium
by Ruiz, Carlos 16 Mar '16

16 Mar '16

Good morning everyone, We're evaluating to use observium as hardware monitoring devices based on snmp protocol for devices located all around the world. We're talking about 20K devices and I believe that have one single host locate in SSF, getting all the info from all the devices, located on places like Shangai may not be the best scenario to get the best performance from the tool itself Does observium support the concept of Master of masters?, I mean have local master observium hosts (EMEA, APAC, NA) and consolidate all the info in one single Master Observium Instance If not what will be a recommended approach to cover an scenario like the one described Thanks in advance for your help and collaboration Kind Regards -- Carlos Ruiz Compute System Management Senior Engineer Roche Farma, S.A.Josefa Valcarcel, 40. ES-28027 Madrid (Spain) Phone: +34 91 305 99 25 Mobile: +34 662 10 46 14 * *

4 9

Netapp missing network data
by Louis Bailleul 16 Mar '16

16 Mar '16

Hi, I have a Netapp in cluster mode that I have added to Observium. It only display volume usage but no disk or network usage. Is it because the code expect a mode 7 device ? According to this document http://www.netapp.com/us/media/tr-4220.pdf (Table 27) it should expose some network stuff. I tried the .1.3.6.1.4.1.789.1.22.1 oid and it indeed returns data. I have attached discovery, poller and the snmpwalk of the OID mentioned. Best regards, Louis

1 0

Strange error
by Andrew Colin 16 Mar '16

16 Mar '16

Hi Guys Strange one When a device is down it always shows the downtime as per below Any ideas why it says 1year?

2 1

APC device detected as power instead of environment
by Louis Bailleul 15 Mar '16

15 Mar '16

Hi, I have a few APC AP9340 which are some environmental sensors collector. They are detected quite well but are categorized as Power device instead of Environmental. I have attached debug discovery and poller for one of them. Best regards, Louis

2 2

invalid args passed into function error @ r7676
by Rob VanHooren 15 Mar '16

15 Mar '16

greetings. I’m seeing this when running discovery of a c3750 ipbase v12.2(35)SE5 thoughts? thx. R. ##### Module Start: vlans ##### VLANs: CISCO-VTP-MIB (Domain 1) 1 172 192 666 999 1002 1003 1004 1005 1011 1020 1023 1024 1025 1027 1030 1031 1033 1035 1037 1039 1101 1102 1103 1104 1106 1107 1108 1110 2000 2008 2009 2010 2011 2012 2015 2016 2017 2019 2020 2021 2022 2023 2025 2026 2027 2030 2031 2032 2033 2034 2035 2037 2038 2039 2040 2045 2046 2047 2048 2049 2050 2051 2210 2221 4001 Q-BRIDGE-MIB Invalid arguments passed into function get_port_by_index_cache(). Please report to developers. Invalid arguments passed into function get_port_by_index_cache(). Please report to developers. Invalid arguments passed into function get_port_by_index_cache(). Please report to developers. Invalid arguments passed into function get_port_by_index_cache(). Please report to developers. Invalid arguments passed into function get_port_by_index_cache(). Please report to developers. Invalid arguments passed into function get_port_by_index_cache(). Please report to developers. Invalid arguments passed into function get_port_by_index_cache(). Please report to developers. Invalid arguments passed into function get_port_by_index_cache(). Please report to developers. Invalid arguments passed into function get_port_by_index_cache(). Please report to developers. Invalid arguments passed into function get_port_by_index_cache(). Please report to developers. Invalid arguments passed into function get_port_by_index_cache(). Please report to developers. Invalid arguments passed into function get_port_by_index_cache(). Please report to developers. Invalid arguments passed into function get_port_by_index_cache(). Please report to developers. Invalid arguments passed into function get_port_by_index_cache(). Please report to developers. Invalid arguments passed into function get_port_by_index_cache(). Please report to developers. Invalid arguments passed into function get_port_by_index_cache(). Please report to developers. Invalid arguments passed into function get_port_by_index_cache(). Please report to developers. Invalid arguments passed into function get_port_by_index_cache(). Please report to developers. Invalid arguments passed into function get_port_by_index_cache(). Please report to developers. Invalid arguments passed into function get_port_by_index_cache(). Please report to developers. Invalid arguments passed into function get_port_by_index_cache(). Please report to developers. Invalid arguments passed into function get_port_by_index_cache(). Please report to developers. Invalid arguments passed into function get_port_by_index_cache(). Please report to developers. Invalid arguments passed into function get_port_by_index_cache(). Please report to developers. Invalid arguments passed into function get_port_by_index_cache(). Please report to developers. Invalid arguments passed into function get_port_by_index_cache(). Please report to developers. Invalid arguments passed into function get_port_by_index_cache(). Please report to developers. Invalid arguments passed into function get_port_by_index_cache(). Please report to developers. Invalid arguments passed into function get_port_by_index_cache(). Please report to developers. Invalid arguments passed into function get_port_by_index_cache(). Please report to developers. Invalid arguments passed into function get_port_by_index_cache(). Please report to developers. Invalid arguments passed into function get_port_by_index_cache(). Please report to developers. Invalid arguments passed into function get_port_by_index_cache(). Please report to developers. ERROR: Device does not support per-VLAN community. Module [ vlans ] stats: 1[V+] 172[V+] 192[V+] 666[V+] 999[V+] 1002[V+] 1003[V+] 1004[V+] 1005[V+] 1011[V+] 1020[V+] 1023[V+] 1024[V+] 1025[V+] 1027[V+] 1030[V+] 1031[V+] 1033[V+] 1035[V+] 1037[V+] 1039[V+] 1101[V+] 1102[V+] 1103[V+] 1104[V+] 1106[V+] 1107[V+] 1108[V+] 1110[V+] 2000[V+] 2008[V+] 2009[V+] 2010[V+] 2011[V+] 2012[V+] 2015[V+] 2016[V+] 2017[V+] 2019[V+] 2020[V+] 2021[V+] 2022[V+] 2023[V+] 2025[V+] 2026[V+] 2027[V+] 2030[V+] 2031[V+] 2032[V+] 2033[V+] 2034[V+] 2035[V+] 2037[V+] 2038[V+] 2039[V+] 2040[V+] 2045[V+] 2046[V+] 2047[V+] 2048[V+] 2049[V+] 2050[V+] 2051[V+] 2210[V+] 2221[V+] 4001[V+] o Duration 11.076s

1 0

multi site support?
by Bernd Kammlott | kaneo GmbH - green IT solutions 15 Mar '16

15 Mar '16

hey, currently we are using cacti to collect snmp data but your solutions looks much better :) Currently we are collecting data from all our customers into one centralized system on one of our servers. Would it be possible to have some kind of "multi site" installation with observium to give our customers access to their data? We dont want to setup Observium for each of our customers, but want them to be able to have a look at the current state their systems. I could not find any documentation about this feature, is is possible? Maybe with groups or locations? -- Mit freundlichen Grüßen Bernd Kammlott Systemintegration kaneo GmbH - green IT solutions | Lüner Weg 32a | D-21337 Lüneburg Tel.: +49 4131 22 700 73 | Mobil: +49 170 833 32 67 | E-Mail: bernd.kammlott(a)kaneo-gmbh.de Internet: www.kaneo-gmbh.de | www.facebook.com/kaneo.green.solutions Geschäftsführung: Andreas Kammlott, Nele Lübberstedt | Amtsgericht Lüneburg: HRB 205201 B | USt-ID: DE815486812 | Bitte prüfen Sie der Umwelt zuliebe, ob der Ausdruck dieser E-Mail erforderlich ist.|

5 8

Ethernet Service Instance Interface Names Truncated
by Mailing Lists 15 Mar '16

15 Mar '16

Am I imagining things, or did Observium previously correctly display Ethernet service instance interfaces in the GUI? I've noticed recently that all the interfaces names for service instance interfaces seem to be truncated in a few of the views Picture speaks a thousand words, where these show GigabitEthernet0/16. now, I am sure they previously would have been listed as GigabitEthernet0/16.ServiceInstance.1234 etc; [image: Inline images 1] [image: Inline images 4] Discovery debug example from the device shows the interfaces captured as the full name: ( [ifDescr] => GigabitEthernet0/1.ServiceInstance.206 [ifAlias] => Description [ifName] => Gi0/1.SI.206 [ifType] => l2vlan [ifOperStatus] => up ) If you search in the ports for for the full interface name it knows it as the right thing; [image: Inline images 2] Looks like the GUI just truncates the names? Obviously this makes it harder than it should be to identify the correct interface in the list. Any chance we can have this show the whole thing? :) Thanks, Tim C

6 11

Reporting Devices down when they are up
by Andrew Colin 15 Mar '16

15 Mar '16

Hi Guys I am getting a strange issue Observium is reporting certain devices as down when they are up. I can snmpwalk to them from the server but the gui says they are down Any ideas? Thanks Andrew

2 2

Cisco SG350 as Generic device
by chott＠praha1.net 15 Mar '16

15 Mar '16

Hello, please can you help me with new Cisco SG350XG switches? Snmpwalk attached Observium recognize this Cisco switch as Generic device Tom

2 2

SNMP access via poller issues
by Cameron Murray 15 Mar '16

15 Mar '16

Guys, Overnight we received a lot of alerts for device going offline however these were false positives. We've found that the poller is having issues connecting to some devices. Brocade ICX Switch Cisco 2900 series RouterOS SNMP is working via snmpwalk on the machine running obs and also from other test locations however the poller times out on them. We've reset the configuration for the devices in obs however access still fails. Access appears to come and go. We've confirmed obs is up to date and have rebooted the services. Regards, Cameron Murray Senior Communications Manager How am I doing? Please click here<http://www.techpath.com.au/contact-us/feedback/> to rate my work. [cid:image001.png@01D1739A.5BC99370]<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.

4 9

Reset password tool on main website
by Gavin Henry 15 Mar '16

15 Mar '16

Hi, Been waiting for a while now with two emails I know to work. Can someone check? Trying to get my subscription username as a renewed one still has the old one and it's just timed out now. Thanks. -- Kind Regards, Gavin Henry. http://www.surevoip.co.uk

4 23

cannot find device
by Jeffrey d'Ambly 14 Mar '16

14 Mar '16

I have a device that I cannot discover or delete, in observium Professional How can I fix this? mysql> select hostname, device_id FROM devices WHERE hostname LIKE 'ams-sw121'; +-----------+-----------+ | hostname | device_id | +-----------+-----------+ | ams-sw121 | 176 | +-----------+-----------+ 1 row in set (0.00 sec) mysql> exit Bye [root@sjc-corp-net01 ~]# /home/observium/discovery.php -h 176 Observium 0.15.5.6406 Discovery Current Revision : 6406 New Revision : 7674 WARNING: 0 devices discovered. Did you specify a device that does not exist? Memory usage: 4.5MB (peak: 4.5MB) MySQL: Cell[21/0.03s] Row[0/0s] Rows[2/0s] Column[0/0s] Update[0/0s] Insert[0/0s] Delete[0/0s] [root@sjc-corp-net01 ~]# [root@sjc-corp-net01 ~]# /home/observium/delete_device.php -h 176 Observium 0.15.5.6406 Remove Device Device -h doesn't exist! [root@sjc-corp-net01 ~]#

3 5

Is there a way to reset all interface errors
by Ron Culler 14 Mar '16

14 Mar '16

Looking to see if there is an easy way to reset all the interface errors across a device or devices? I'm trying to zero them out for a baseline Ron

1 0

Housekeeping - invalid RRD files
by Sean Pedersen 14 Mar '16

14 Mar '16

The instructions for the housekeeping script mention the cleanup of invalid RRD files and that doing so "requires $config['file'] to be set correctly to the path of the file magic utility." I can't find any reference to $config['file'], magic file utilities, etc. in the default config.php, my current config.php, or anywhere online, mailing list archives, etc. What is this in reference to? It doesn't seem to be set anywhere. Did I miss something? Consequently, whenever I run `housekeeping.php -r` with that option defaulted to TRUE, the process hangs and doesn't seem to do anything. Setting it to FALSE immediately deletes stale RRD files (by time via $config['housekeeping']['rrd']['age'] = timeInSeconds;) and completes the process. I checked housekeeping.log and there are no entries for 'invalid' (what I assume an invalid RRD file would log based on the rrd.inc.php module) and my log file goes back to 2014, so I know I’m not missing something that has rotated out. I'm running 0.16.3.7663 for reference.

4 4

Database schema out of whack
by Sean Pedersen 14 Mar '16

14 Mar '16

I’m not sure how this happened. I ran into some seemingly unrelated issues and one of the many issues I’ve been troubleshooting since is the apparent destruction of my database schema. Here’s the output of `discovery.php -u`: 000 -> 001 ... (db) done. 001 -> 002 ... (db) done (5 errors). 002 -> 003 ... (db) done (2 errors). 003 -> 004 ... (db) done (3 errors). 004 -> 005 ... (db) done (4 errors). 005 -> 006 ... (db) done. 006 -> 007 ... (db) done (1 errors). 007 -> 008 ... (db) done (1 errors). 008 -> 009 ... (db) done. 009 -> 010 ... (db) done (1 errors). 010 -> 011 ... (db) done. 011 -> 012 ... (db) done. 012 -> 013 ... (db) done (1 errors). 013 -> 014 ... (db) done. 014 -> 015 ... (db) done (1 errors). 015 -> 016 ... (db) done (4 errors). 016 -> 017 ... (db) done. 017 -> 018 ... (db) done (2 errors). 018 -> 019 ... (db) done. 019 -> 020 ... (db) done (6 errors). 020 -> 021 ... (db) done (1 errors). 021 -> 022 ... (db) done (1 errors). 022 -> 023 ... (db) done (5 errors). 023 -> 024 ... (db) done (2 errors). 024 -> 025 ... (db) done (10 errors). 025 -> 026 ... (db) done. 026 -> 027 ... (db) done. 027 -> 028 ... (db) done (11 errors). 028 -> 029 ... (db) done. 029 -> 030 ... (db) done (2 errors). 030 -> 031 ... (db) done (1 errors). 031 -> 032 ... (db) done (2 errors). 032 -> 033 ... (db) done. 033 -> 034 ... (db) done. 034 -> 035 ... (db) done (1 errors). 035 -> 036 ... (db) done (1 errors). 036 -> 037 ... (db) done. 037 -> 038 ... (db) done (2 errors). 038 -> 039 ... (db) done. 039 -> 040 ... (db) done. 040 -> 041 ... (db) done (2 errors). 041 -> 042 ... (db) done. 042 -> 043 ... (db) done (4 errors). 043 -> 044 ... (db) done (1 errors). 044 -> 045 ... (db) done (4 errors). 045 -> 046 ... (db) done. 046 -> 047 ... (db) done. 047 -> 048 ... (db) done (1 errors). 048 -> 049 ... (db) done (1 errors). 049 -> 050 ... (db) done. 050 -> 051 ... (db) done. 051 -> 052 ... (db) done. 052 -> 053 ... (db) done. 053 -> 054 ... (db) done (1 errors). 054 -> 055 ... (db) done (4 errors). 055 -> 056 ... (db) done (1 errors). 056 -> 057 ... (db) done (1 errors). 057 -> 058 ... (db) done (1 errors). 058 -> 059 ... (db) done (1 errors). 059 -> 060 ... (db) done (1 errors). 060 -> 061 ... (db) done (1 errors). 061 -> 062 ... (db) done (1 errors). 062 -> 063 ... (db) done (4 errors). 063 -> 064 ... (db) done. 064 -> 065 ... (db) done. 065 -> 066 ... (db) done. 066 -> 067 ... (db) done. 067 -> 068 ... (db) done (1 errors). 068 -> 069 ... (db) done. 069 -> 070 ... (db) done (1 errors). 070 -> 071 ... (db) done. 071 -> 072 ... (db) done (1 errors). 072 -> 073 ... (db) done. 073 -> 074 ... (php) Updating netscaler service RRDs 074 -> 075 ... (db) done (1 errors). 075 -> 076 ... (db) done (1 errors). 076 -> 077 ... (db) done. 077 -> 078 ... (db) done. 078 -> 079 ... (db) done. 079 -> 080 ... (db) done. 080 -> 081 ... (db) done. 081 -> 082 ... (db) done (1 errors). 082 -> 083 ... (db) done. 083 -> 084 ... (db) done. 084 -> 085 ... (db) done (1 errors). 085 -> 086 ... (db) done. 086 -> 087 ... (db) done (1 errors). 087 -> 088 ... (db) done. 088 -> 089 ... (db) done (5 errors). 089 -> 090 ... (db) done (3 errors). 090 -> 091 ... (db) done (1 errors). 091 -> 092 ... (db) done (2 errors). 092 -> 093 ... (db) done (2 errors). 093 -> 094 ... (db) done. 094 -> 095 ... (php) Converting alert serialize() arrays to JSON: ........................................ 095 -> 096 ... (db) done (1 errors). 096 -> 097 ... (db) done. 097 -> 098 ... (db) done. 098 -> 099 ... (db) done (1 errors). 099 -> 100 ... (db) done (1 errors). 100 -> 101 ... (db) done (1 errors). 101 -> 102 ... (db) done. 102 -> 103 ... (db) done (1 errors). 103 -> 104 ... (db) done (1 errors). 104 -> 105 ... (db) done. 105 -> 106 ... (db) done (2 errors). 106 -> 107 ... (db) done. 107 -> 108 ... (db) done (1 errors). 108 -> 109 ... (db) done. 109 -> 110 ... (db) done (1 errors). 110 -> 111 ... (db) done (2 errors). 111 -> 112 ... (db) done (1 errors). 112 -> 113 ... (db) done. 113 -> 114 ... (db) done (1 errors). 114 -> 115 ... (db) done (1 errors). 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 (3 errors). 122 -> 123 ... (db) done. 123 -> 124 ... (db) done (1 errors). 124 -> 125 ... (db) done (1 errors). 125 -> 126 ... (db) done (2 errors). 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 (1 errors). 133 -> 134 ... (db) done (1 errors). 134 -> 135 ... (db) done (1 errors). 135 -> 136 ... (db) done (1 errors). 136 -> 137 ... (db) done. 137 -> 138 ... (db) done. 138 -> 139 ... (db) done (4 errors). 139 -> 140 ... (db) done. 140 -> 141 ... (db) done (3 errors). 141 -> 142 ... (db) done (1 errors). 142 -> 143 ... (db) done. 143 -> 144 ... (db) done. 144 -> 145 ... (db) done (1 errors). 145 -> 146 ... (db) done. 146 -> 147 ... (db) done. 147 -> 148 ... (db) done (3 errors). 148 -> 149 ... (db) done. 149 -> 150 ... (db) done (6 errors). 150 -> 151 ... (db) done. 151 -> 152 ... (db) done. 152 -> 153 ... (php) Converting RRD ds type for tcpCurrEstab COUNTER->GAUGE: ....................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................... 153 -> 154 ... (db) done (1 errors). 154 -> 155 ... (db) done (1 errors). 155 -> 156 ... (db) done (1 errors). 156 -> 157 ... (db) done (1 errors). 157 -> 158 ... (db) done (1 errors). 158 -> 159 ... (db) done. 159 -> 160 ... (db) done. 160 -> 161 ... (db) done (1 errors). 161 -> 162 ... (db) done. 162 -> 163 ... (db) done. 163 -> 164 ... (php) Superseded by update 165 164 -> 165 ... (php) Adding MIN RRA to very old RRD files: * hr_processes: ..... * hr_users: ..... * ucd_contexts: ... * ucd_load: ... * ucd_interrupts: ... 165 -> 166 ... (db) done (1 errors). 166 -> 167 ... (db) done. 167 -> 168 ... (db) done. 168 -> 169 ... (db) done. 169 -> 170 ... (php) Move old GEO data if exist: ---------------- 170 -> 171 ... (db) done. 171 -> 172 ... (db) done. 172 -> 173 ... (db) done. 173 -> 174 ... (db) done (3 errors). 174 -> 175 ... (db) done (2 errors). 175 -> 176 ... (php) Clean incorrect syslog entries: 176 -> 177 ... (php) Clean incorrect manual geolocation: 177 -> 178 ... (db) done (5 errors). 178 -> 179 ... (db) done (2 errors). 179 -> 180 ... (db) done. 180 -> 181 ... (db) done. 181 -> 182 ... (db) done. 182 -> 183 ... (db) done. 183 -> 184 ... (db) done (3 errors). 184 -> 185 ... (db) done. 185 -> 186 ... (db) done (9 errors). 186 -> 187 ... (php) 187 -> 188 ... (db) done. 188 -> 189 ... (db) done (2 errors). 189 -> 190 ... (db) done (2 errors). 190 -> 191 ... (php) Migrating state sensors to status entries: 191 -> 192 ... (db) done (2 errors). 192 -> 193 ... (db) done (1 errors). 193 -> 194 ... (db) done (1 errors). 194 -> 195 ... (db) done (3 errors). 195 -> 196 ... (db) done (1 errors). 196 -> 197 ... (db) done. 197 -> 198 ... (db) done. 198 -> 199 ... (db) done. 199 -> 200 ... (db) done (2 errors). 200 -> 201 ... (db) done. 201 -> 202 ... (db) done. 202 -> 203 ... (db) done (1 errors). 203 -> 204 ... (db) done. 204 -> 205 ... (db) done. 205 -> 206 ... (db) done (4 errors). 206 -> 207 ... (db) done (1 errors). 207 -> 208 ... (db) done (1 errors). 208 -> 209 ... (db) done (5 errors). 209 -> 210 ... (php) 210 -> 211 ... (db) done (3 errors). 211 -> 212 ... (php) 212 -> 213 ... (db) done (11 errors). 213 -> 214 ... (db) done. 214 -> 215 ... (db) done (1 errors). 215 -> 216 ... (db) done (2 errors). 216 -> 217 ... (db) done. 217 -> 218 ... (db) done. 218 -> 219 ... (db) done. 219 -> 220 ... (db) done (4 errors). 220 -> 221 ... (db) done (1 errors). 221 -> 222 ... (db) done. 222 -> 223 ... (db) done (1 errors). 223 -> 224 ... (db) done. 224 -> 225 ... (db) done. 225 -> 226 ... (db) done. 226 -> 227 ... (db) done (2 errors). 227 -> 228 ... (db) done (10 errors). 228 -> 229 ... (db) done (1 errors). 229 -> 230 ... (db) done (1 errors). 230 -> 231 ... (db) done. 231 -> 232 ... (db) done. 232 -> 233 ... (db) done (2 errors). 233 -> 234 ... (db) done (1 errors). 234 -> 235 ... (db) done. 235 -> 236 ... (db) done (1 errors). 236 -> 237 ... (db) done. 237 -> 238 ... (db) done. 238 -> 239 ... (db) done (1 errors). 239 -> 240 ... (db) done (3 errors). 240 -> 241 ... (db) done. 241 -> 242 ... (db) done. 242 -> 243 ... (db) done. 243 -> 244 ... (db) done (3 errors). 244 -> 245 ... (db) done. 245 -> 246 ... (db) done (1 errors). 246 -> 247 ... (db) done (1 errors). 247 -> 248 ... (db) done. 248 -> 249 ... (db) done (1 errors). 249 -> 250 ... (db) done. 250 -> 251 ... (db) done (1 errors). 251 -> 252 ... (db) done (1 errors). 252 -> 253 ... (db) done. 253 -> 254 ... (db) done. 254 -> 255 ... (db) done (1 errors). 255 -> 256 ... (php) 256 -> 257 ... (php) 257 -> 258 ... (php) 258 -> 259 ... (db) done. 259 -> 260 ... (php) 260 -> 261 ... (db) done (5 errors). 261 -> 262 ... (php) 262 -> 263 ... (db) done (1 errors). 263 -> 264 ... (db) done (8 errors). 264 -> 265 ... (db) done (1 errors). 265 -> 266 ... (db) done. 266 -> 267 ... (db) done. 267 -> 268 ... (php) 268 -> 269 ... (php) 269 -> 270 ... (db) done. 270 -> 271 ... (db) done (11 errors). -- Done. So…there are a couple of errors. I grabbed a few samples of db.log and found several examples where columns are missing. Pretty much 99% of the log is failed queries to nonexistent database fields, columns, etc. Here’s two: [2016/03/11 21:39:25 -0700] poller.php(22166): Failed dbQuery (#1054 - Unknown column 'attrib_value' in 'field list'), Query: SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'dbSchema'; mysql> describe observium_attribs; +---------+---------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+---------+------+-----+---------+-------+ | version | int(11) | NO | PRI | NULL | | +---------+---------+------+-----+---------+-------+ 1 row in set (0.00 sec) [2016/03/11 21:43:34 -0700] poller.php(18006): Failed dbQuery (#1054 - Unknown column 'device_id' in 'where clause'), Query: SELECT * FROM `devices_attribs` WHERE `device_id` = '136' mysql> describe devices_attribs; +--------------+--------------+------+-----+-------------------+-----------------------------+ | Field | Type | Null | Key | Default | Extra | +--------------+--------------+------+-----+-------------------+-----------------------------+ | attrib_id | int(11) | NO | PRI | NULL | auto_increment | | entity_type | varchar(32) | NO | | NULL | | | entity_id | int(11) | NO | MUL | NULL | | | attrib_type | varchar(128) | NO | | NULL | | | attrib_value | text | NO | | NULL | | | updated | timestamp | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | +--------------+--------------+------+-----+-------------------+-----------------------------+ 6 rows in set (0.00 sec) Outside of `discovery.php -u` that is failing, is it possible to recover the schema? I would imagine doing it manually is the only way. Is it worth it?

2 7

Newbie with a question
by Daniel Martín Mayo 14 Mar '16

14 Mar '16

Hello everybody, Im new to this mailing list and also to Observium. Im just another SysAdmin trying to monitor as many devices as we can in our company (Nagios is still doing his job fine), so we started trying Observium just to see if it was worthy or not. I got installed the Community version using the OVA, so first question is: If I switch to the Pro version, do I need to rebuild all the work Ive done? Greetings from Spain, Dani Martin

5 8

Delay on down devices
by Louis Bailleul 14 Mar '16

14 Mar '16

Hi, Is it possible to add a delay for the built in down device alert ? Or even better, can I replace the built in alert with custom checkers ? So I can add a delay on specifics sets of devices. Best regards, Louis [http://www.pgs.com/mediaFiles/Exclaimer%20graphics/PGS_LOGO_RGB_42x53px.jpg]<http://www.pgs.com> Louis Bailleul Computer Systems Engineer Imaging & Engineering | Imaging Telephone: +44 1932 376000 Direct: +44 1932 376842 VOIP: 74416842 Mobile: +44 7786 525307 Email: louis.bailleul(a)pgs.com<mailto:Louis.Bailleul@pgs.com> A Clearer Image | www.pgs.com<http://www.pgs.com> [http://www.pgs.com/mediaFiles/Exclaimer%20graphics/150731-ColourWave-660x14…] Address: 4 The Heights, Brooklands, Weybridge, Surrey, KT13 0NY, United Kingdom This e-mail, including any attachments and response string, may contain proprietary information which is confidential and may be legally privileged. It is for the intended recipient only. If you are not the intended recipient or transmission error has misdirected this e-mail, please notify the author by return e-mail and delete this message and any attachment immediately. If you are not the intended recipient you must not use, disclose, distribute, forward, copy, print or rely on this e-mail in any way except as permitted by the author.

4 8

backup script for db, config.php, rrd/
by Nick Schmalenberger 14 Mar '16

14 Mar '16

Hi all, I spent my Sunday afternoon (on-call, luckily quiet though :) writing this backup script for Observium. It takes a backup destination directory and number of backups to keep using rotation which is 0 by default. Then it makes a tmp directory. It copies config.php there, does a mysql dump, and copies rrd/ into the tmp directory. It tars up the tmp directory into a tarball in the backup directory and deletes the tmp directory. It is meant to run from the scripts/ directory, it maybe isnt as polished as the other main scripts or compatible with all systems because of different options with the commands it runs. Its working for me though on my Ubuntu 14.04 test system. Please offer suggestions! Thanks. -Nick

1 1

How to reset the Admin password
by Sathish.I 12 Mar '16

12 Mar '16

Hello All, Can you please let me know how to reset GUI admin password. I have lost the password. Regards, sathish

3 6

Changing the Mysql connections graph format
by Louis Bailleul 11 Mar '16

11 Mar '16

Hi, I found the Mysql connections graph a little difficult to read. So I changed it to use lines instead of stacked area. It is still not perfect because of the huge scale imposed by drawing the maximum number of connection and maximum number of connection reached. But at least you can actually read the value of your spikes of connections instead of working out the difference between the number of connection + max number of connection reached. Before : [cid:image001.png@01D17BB3.BAD5C7F0] After : [cid:image002.png@01D17BB3.BAD5C7F0] The diff of the file : svn diff -r HEAD /opt/observium/html/includes/graphs/application/mysql_connections.inc.php Index: /opt/observium/html/includes/graphs/application/mysql_connections.inc.php =================================================================== --- /opt/observium/html/includes/graphs/application/mysql_connections.inc.php (revision 7661) +++ /opt/observium/html/includes/graphs/application/mysql_connections.inc.php (working copy) @@ -40,6 +40,6 @@ $nototal = 1; $unit_text = "Connections"; -include("includes/graphs/generic_multi_simplex_separated.inc.php"); +include("includes/graphs/generic_multi_line.inc.php"); // EOF Best regards, Louis [http://www.pgs.com/mediaFiles/Exclaimer%20graphics/PGS_LOGO_RGB_42x53px.jpg]<http://www.pgs.com> Louis Bailleul Computer Systems Engineer Imaging & Engineering | Imaging Telephone: +44 1932 376000 Direct: +44 1932 376842 VOIP: 74416842 Mobile: +44 7786 525307 Email: louis.bailleul(a)pgs.com<mailto:Louis.Bailleul@pgs.com> A Clearer Image | www.pgs.com<http://www.pgs.com> [http://www.pgs.com/mediaFiles/Exclaimer%20graphics/150731-ColourWave-660x14…] Address: 4 The Heights, Brooklands, Weybridge, Surrey, KT13 0NY, United Kingdom This e-mail, including any attachments and response string, may contain proprietary information which is confidential and may be legally privileged. It is for the intended recipient only. If you are not the intended recipient or transmission error has misdirected this e-mail, please notify the author by return e-mail and delete this message and any attachment immediately. If you are not the intended recipient you must not use, disclose, distribute, forward, copy, print or rely on this e-mail in any way except as permitted by the author.

1 0

Howto Integrate observium alerts with external event monitoring tool
by Ruiz, Carlos 11 Mar '16

11 Mar '16

good morning everyone, We're evaluating to use observium as our hardware monitoring solution for some datacenters, but we need to clearly understand how can we integrate the generated alerts in the tool with external event monitoring solutions that are the ones used by our Operation Center guys. I guess that we can run queries against the mysql table hosting such events, is there any other possibilities? Maybe interact with mysql DB is the recommended way, that way can any of you share with me the data model of such table? Thanks in advance for your help and sorry for the generic questions, but we're starting with the evaluation activity and we're at observium rookie level Kind Regards -- Carlos Ruiz Compute System Management Senior Engineer Roche Farma, S.A.Josefa Valcarcel, 40. ES-28027 Madrid (Spain) Phone: +34 91 305 99 25 Mobile: +34 662 10 46 14 * *

2 1

Avoid adding round robin dns devices
by Louis Bailleul 11 Mar '16

11 Mar '16

Hi, I have some devices that are configured with a round robin DNS entry. I believe that as we are running lldp on servers too, the auto discovery pick them up and add them. But as the picture below shows, this is pretty much useless as each polling end up on a different server. (You can see that the sysdescr and sysname contains contradictory data : lxfer01 and lxfer02) Would it be possible to detect that the FQDN is a round robin alias and avoid adding it as a new device ? And it would be perfect if it could be the same for CNAME as well, as it is not really worthwhile having Observium polling a node for each of its aliases. [cid:image001.png@01D17B91.B4998790] Best regards, Louis [http://www.pgs.com/mediaFiles/Exclaimer%20graphics/PGS_LOGO_RGB_42x53px.jpg]<http://www.pgs.com> Louis Bailleul Computer Systems Engineer Imaging & Engineering | Imaging Telephone: +44 1932 376000 Direct: +44 1932 376842 VOIP: 74416842 Mobile: +44 7786 525307 Email: louis.bailleul(a)pgs.com<mailto:Louis.Bailleul@pgs.com> A Clearer Image | www.pgs.com<http://www.pgs.com> [http://www.pgs.com/mediaFiles/Exclaimer%20graphics/150731-ColourWave-660x14…] Address: 4 The Heights, Brooklands, Weybridge, Surrey, KT13 0NY, United Kingdom This e-mail, including any attachments and response string, may contain proprietary information which is confidential and may be legally privileged. It is for the intended recipient only. If you are not the intended recipient or transmission error has misdirected this e-mail, please notify the author by return e-mail and delete this message and any attachment immediately. If you are not the intended recipient you must not use, disclose, distribute, forward, copy, print or rely on this e-mail in any way except as permitted by the author.

3 4