- observium - lists.observium.org

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

I got alert mail in every 5 minutes. Bug? V2 :)
by Laszlo Nemeth 11 Mar '16

11 Mar '16

Hi All, Some week ago i wrote a mail because we found an alert bug and we got lot of mails (in every 5. minutes) instead of just 1 in 24 hours. This Observium was an updated from the 2015.07 CE to the latest (CE.0.16.1.7533). We thougth that the problem was because of the upgrade process and the alert function was new and something went bad.... Now i made a clear install of the latest Observium CE from .tgz. I added only one host, add the same alert, and i’m receiving again the alerts mail in every 5. minutes. I didn’t touch any file just the config.php because of the SQL access of the Observium! I added a host (emaussw01). It is a Cisco Nexus device with 7 FEX modules. I see the temperatures of FEXs (4 values from every FEX) all is under 50C but not one module. This module are the "FEX-111 Module-1 Die-1". This is over 50C. I add an alert, export is this: <?xml version="1.0"?> <templates> <template type="alert" description="Autogenerated observium template" version="0.91" created="Thu, 10 Mar 2016 15:29:04 +0100" observium="0.16.1.7533" id="73249fd2b23ef5f715d749ce2e98be41"> <entity_type>sensor</entity_type> <name>emaussw01 temp check</name> <message>Temp alarm!</message> <severity>crit</severity> <suppress_recovery>0</suppress_recovery> <delay>0</delay> <conditions_and>1</conditions_and> <conditions>sensor_value gt 50</conditions> <conditions_complex>sensor_value gt 50</conditions_complex> <associations> <device>hostname eq emaussw01</device> <entity>sensor_class is temperature</entity> </associations> </template> </templates> I associated one user for this check via email alert. Alert history is: Date Device Alert Check Entity Message Status 2016-03-10 15:38:26 emaussw01 emaUSSW01 temp check Fex-111 Module-1 Die-1 Alert notification sent ALERT_NOTIFY 2016-03-10 15:34:15 emaussw01 emaUSSW01 temp check Fex-111 Module-1 Die-1 Alert notification sent ALERT_NOTIFY 2016-03-10 15:29:12 emaussw01 emaUSSW01 temp check Fex-111 Module-1 Die-1 Alert notification sent ALERT_NOTIFY 2016-03-10 15:24:06 emaussw01 emaUSSW01 temp check Fex-111 Module-1 Die-1 Alert notification sent ALERT_NOTIFY 2016-03-10 15:18:29 emaussw01 emaUSSW01 temp check Fex-111 Module-1 Die-1 Alert notification sent ALERT_NOTIFY 2016-03-10 15:14:07 emaussw01 emaUSSW01 temp check Fex-111 Module-1 Die-1 Alert notification sent ALERT_NOTIFY 2016-03-10 15:08:29 emaussw01 emaUSSW01 temp check Fex-111 Module-1 Die-1 Alert notification sent ALERT_NOTIFY 2016-03-10 15:03:51 emaussw01 emaUSSW01 temp check Fex-111 Module-1 Die-1 Alert notification sent ALERT_NOTIFY And i got email allways (1 minutes earlier) when ALERT_NOTIFY is present in the log: # grep -i "Date: Thu” /var/spool/mail/obstestuser Date: Thu, 10 Mar 2016 15:02:50 +0100 Date: Thu, 10 Mar 2016 15:07:28 +0100 Date: Thu, 10 Mar 2016 15:13:07 +0100 Date: Thu, 10 Mar 2016 15:17:28 +0100 Date: Thu, 10 Mar 2016 15:23:06 +0100 Date: Thu, 10 Mar 2016 15:28:11 +0100 Date: Thu, 10 Mar 2016 15:33:14 +0100 Date: Thu, 10 Mar 2016 15:37:26 +0100 What can i debug for resolve this problem? Thanks! Regards Laszlo

3 6

freeradius agent and "PHP Fatal error: Call-time pass-by-reference has been removed in" [SEC=UNCLASSIFIED]
by Peter.Hine＠familycourt.gov.au 11 Mar '16

11 Mar '16

ref 1: http://wiki.freeradius.org/config/Status ref 2: http://stackoverflow.com/questions/8971261/php-5-4-call-time-pass-by-refere… freeradius v3.0 php5 v5.5 I've updated $radmsg IAW ref 1 $radmsg = "Message-Authenticator = 0x00, FreeRADIUS-Statistics-Type = $ statstype, Response-Packet-Type = Access-Accept"; running radclient as noted in ref1 also works. So all setup and working. ref2 indicates the fault is easy to fix but i can't understand it. -------- dc2radius1:/usr/lib/observium_agent/local root $ ./freeradius PHP Fatal error: Call-time pass-by-reference has been removed in /usr/lib/observium_agent/local/freeradius on line 54 -------- line 54: exec("echo '$radmsg' | $radcmd", &$out, $retval); how might line 54 be altered to actually run. The alternatively is to rewrite it as a shell script (cause thats how programmers work, they rewrite in the language they know). thanks 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. **********************************************************************

4 6

Alert Checks on Observium reports device down when they are actually not
by Arya, Renuka [MED] 10 Mar '16

10 Mar '16

Hi Team, I have setup the following Alert on my Observium device. See attachment (Alert_DeviceDown). I sometimes get the alerts that the device is down . See attachment (Devices_Down). However, the devices were actually not down. So most likely it is the Server on which Observium is install, do not get a ping response from the switch(device we monitoring). I ran MTR tests between the Observium server and switch in question, I don't see any packet losses, but I do see average RTT of 0.2 ms and worst RTT as 3.8 ms. So, is it possible when Observium does not get a ping response from the switch in the desirable amount of time, it marks it DOWN. How this desirable amount is calculated. Is there way we can edit this? Or is there any other recommended way for monitoring the devices? Thanks! Regards Renuka ******************************************************************************** This e-mail is intended only for the use of the individual or entity to which it is addressed and may contain information that is privileged and confidential. If the reader of this e-mail message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is prohibited. If you have received this e-mail in error, please notify the sender and destroy all copies of the transmittal. Thank you University of Chicago Medicine and Biological Sciences ********************************************************************************

4 8

CE-edition; Sorting of Health-status columns?
by Pål Rydningen 09 Mar '16

09 Mar '16

Is it a design-choice to not being able to sort by columns in the Health page? As in ... Sort ascending/decending by Memory Usage, Toner usage, CPU etc. This is CE edition. -- Pål R.

2 2

db.log full after upgrade to Observium CE 0.16.1.7533
by Mike Driscoll 09 Mar '16

09 Mar '16

After upgrade, all seemed well until my disk filled up. db.log contains countless entries about unknown columns. A couple examples are below. I completed the schema update and full discovery at the end of the upgrade process per: http://www.observium.org/docs/updating/ <http://www.observium.org/docs/updating/>. Rerunning discovery.php -u says my schema is up to date. But something isn’t right. Is there a way to force the schema update to run again? Perhaps that will install all the missing columns? [2016/03/07 18:01:22 +0000] poller.php(9947): Failed dbQuery (#1054 - Unknown column 'port_label_short' in 'field list'), Query: UPDATE `ports` set `port_label` ='Vlan1',`port_label_short` ='Vlan1',`ifLastChange` ='2016-03-04 22:27:35' WHERE `port_id` = '2412' [2016/03/07 16:16:10 +0000] poller.php(23363): Failed dbQuery (#1054 - Unknown column 'entity_id' in 'field list'), Query: INSERT INTO `eventlog` (`device_id`,`entity_id`,`entity_type`,`timestamp`,`severity`,`message`) VALUES ('78','42018','port',NOW(),'6','Interface changed: [port_label] \'\' -> \'xe-0/1/1\'; [port_label_short] \'\' -> \'xe-0/1/1\'; [ifLastChange] \'2015-04-27 15:45:11\' -> \'2015-04-27 22:47:09\'')

5 10

Alert by CustomOID
by chott＠praha1.net 09 Mar '16

09 Mar '16

Hello everybody,§ Can i create Alert check for CustomOID value ? Tom

2 2

freeradius agent and "PHP Fatal error: Call-time pass-by-reference has been removed in" [SEC=UNCLASSIFIED]
by Peter.Hine＠familycourt.gov.au 08 Mar '16

08 Mar '16

ref 1: http://wiki.freeradius.org/config/Status ref 2: http://stackoverflow.com/questions/8971261/php-5-4-call-time-pass-by-refere… freeradius v3.0 php5 v5.5 I've updated $radmsg IAW ref 1 $radmsg = "Message-Authenticator = 0x00, FreeRADIUS-Statistics-Type = $ statstype, Response-Packet-Type = Access-Accept"; running radclient as noted in ref1 also works. So all setup and working. ref2 indicates the fault is easy to fix but i can't understand it. -------- dc2radius1:/usr/lib/observium_agent/local root $ ./freeradius PHP Fatal error: Call-time pass-by-reference has been removed in /usr/lib/observium_agent/local/freeradius on line 54 -------- line 54: exec("echo '$radmsg' | $radcmd", &$out, $retval); how might line 54 be altered to actually run. The alternatively is to rewrite it as a shell script (cause thats how programmers work, they rewrite in the language they know). thanks 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

ZFS on Linux
by Ximena Cardinali 08 Mar '16

08 Mar '16

Hello there, is there anyone around here using ZFS on Linux (more precisely Debian) and made it work with Observium and SNMP? We just implemented ZFS on some Servers and we would like to monitor the pools within Observium. Regards, Ximena.

3 2

Poller-wrapper - get_http_request() exit with timeout
by Ivan Biasi 08 Mar '16

08 Mar '16

Hi all does anyone ever met the following timeout error message during the polling cycle ? Any idea on what's the impact and how to solve ? Here following a section of the log file made by the output of: */5 * * * * root /opt/observium/poller-wrapper.py 5 >> /opt/observium/logs/poller-wrapper.log 2>&1 ================================================== .... [2016/03/07 15:15:34 +0100] poller.php(29544): /opt/observium/poller.php: <hostname...> - 1 devices polled in 1.546 secs [2016/03/07 15:15:38 +0100] poller.php(29402): /opt/observium/poller.php: <hostname...> - 1 devices polled in 6.969 secs [2016/03/07 15:15:39 +0100] poller-wrapper.py(27564): /opt/observium/poller-wrapper.py: polled 25 devices in 37 seconds with 5 workers [2016/03/07 15:20:05 +0100] poller.php(29849): get_http_request() exit with timeout. Access to outside localnet is blocked by firewall or network problems. Check pr oxy settings. ... ... [2016/03/07 15:20:50 +0100] poller-wrapper.py(29826): /opt/observium/poller-wrapper.py: polled 25 devices in 47 seconds with 5 workers [2016/03/07 15:25:02 +0100] poller.php(816): get_http_request() exit with timeout. Access to outside localnet is blocked by firewall or network problems. Check proxy settings. ================================================== The system is apparently collecting data but, being a new test/evaluation activation, I don't known if something is missing. Thanks a lot, regards I.

3 5

Problem with new Cisco switches
by chott＠praha1.net 07 Mar '16

07 Mar '16

Hello team, we have new Cisco SG350XG 10gbit switches, but we have problem with Discovery because Observium resolve as "Generic device" iso.3.6.1.2.1.1.1.0 = STRING: "SG350XG-2F10 12-Port 10G Stackable Managed Switch" iso.3.6.1.2.1.1.2.0 = OID: iso.3.6.1.4.1.9.6.1.91.12.9 iso.3.6.1.2.1.1.3.0 = Timeticks: (3550400) 9:51:44.00 iso.3.6.1.2.1.1.4.0 = STRING: "" iso.3.6.1.2.1.1.5.0 = STRING: "" iso.3.6.1.2.1.1.6.0 = STRING: "" iso.3.6.1.2.1.1.7.0 = INTEGER: 6 iso.3.6.1.2.1.1.8.0 = Timeticks: (0) 0:00:00.00 iso.3.6.1.2.1.1.9.1.2.1 = OID: iso.3.6.1.4.1.89.73 iso.3.6.1.2.1.1.9.1.3.1 = STRING: "RS capabilities" iso.3.6.1.2.1.1.9.1.4.1 = Timeticks: (0) 0:00:00.00 [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>

1 2

Create an alert checker on a custom OID
by Fredrik Winäs 07 Mar '16

07 Mar '16

Hi I have a couple of custom OID that I track, is it possible to make an alert checker on these? [cid:image001.png@01D1788A.29969750] thanks Med Vänlig Hälsning Fredrik Winäs tel +46 31 762 02 43 fredrik.winas(a)cgit.se<mailto:fredrik.winas@cgit.se> www.cgit.se<http://www.cgit.se/> CGit AB Taljegårdsgatan 11C SE-431 53 Mölndal

2 1

PPPoE session graphs on ASR1000
by Senses0 07 Mar '16

07 Mar '16

Hi, PPPoE graphs on our Cisco ASR1000 boxes no longer has any value. This is starting from a little over a week ago. Are these MIBS removed or these graphs have been removed? Have a look at the attached screenshot.

1 0

Re: [Observium] Set fixed scale of Y-axis on mini-graphs?
by Henrik Cednert (Filmlance) 06 Mar '16

06 Mar '16

Impossibruuu? -- Henrik Cednert cto | td | compositor Filmlance International mobile [ + 46 (0)704 71 89 54 ] skype [ cednert ] On 04/02/16 09:40, "observium on behalf of Henrik Cednert (Filmlance)" <observium-bounces(a)observium.org on behalf of henrik.cednert(a)filmlance.se> wrote: >Hello > >I'd like to set fixed values of the Y axis on the minigraphs. Is that possible? I don't find much value of the adaptive scaling since it means I have to read the AXIS and not only throw a quick eye at it to see anomalies. > >Cheers and thans > >-- >Henrik Cednert >cto | td | compositor > >Filmlance International >Direct + 46 (0)704 71 89 54 > > >_______________________________________________ >observium mailing list >observium(a)observium.org >http://postman.memetic.org/cgi-bin/mailman/listinfo/observium

3 5

Observium-Rancid Integration
by Sathish.I 05 Mar '16

05 Mar '16

Hello All, I have integrated the rancid with observium. In the initial stage for 2 days it worked well, backup are pulled as per cronjob. After some days, I observed backup are happening few devices rest are shown in GUI. However, when I checked the status in /var/lib/rancid/observium/configs/ the backup files are successfully taken And when checked the rancid logs in /var/log/rancid/ I have seen for few devices (which shown in GUI) the Sending configs/xxxx Sending configs/yyyy Transmitting file data .. Committed revision 216. NOTE: The list varies from time to time. Please suggest what could be the issue and solution if any. Regards, sathish

2 1

Cannot add CAB 4+ printer
by Ronald 05 Mar '16

05 Mar '16

I'm working for a small company in the floral sector. We have several types of printers. From conventional multifunctionals to label printers (CAB, Zebra). I can add the Zebra printers, but not the cab printers. It appears that Observium is looking for objects with a different suffix. I searched around the site and did some Googling. But I was not able to sort this out myself. [root@bl-bug01 bl]# tcpdump -i ens32 host 192.168.0.153 tcpdump: verbose output suppressed, use -v or -vv for full protocol decode listening on ens32, link-type EN10MB (Ethernet), capture size 65535 bytes 11:29:00.627323 IP bl-bug01.bloominess.nl.54058 > bl_planten_artikel.snmp: GetRequest(42) system.sysObjectID.0 system.sysUpTime.0 11:29:00.628053 IP bl_planten_artikel.snmp > bl-bug01.bloominess.nl.54058: GetResponse(48) system.sysObjectID.0=[noSuchObject] system.sysUpTime.0=[noSuchObject] 11:29:00.651719 IP bl-bug01.bloominess.nl.36372 > bl_planten_artikel.snmp: GetRequest(31) E:39165.1.1.0 11:29:00.652297 IP bl_planten_artikel.snmp > bl-bug01.bloominess.nl.36372: GetResponse(35) E:39165.1.1.0=[noSuchObject] 11:29:05.643513 ARP, Request who-has bl_planten_artikel tell bl-bug01.bloominess.nl, length 28 11:29:05.643808 ARP, Reply bl_planten_artikel is-at 00:02:e7:05:47:66 (oui Unknown), length 46 11:29:06.332982 ARP, Request who-has bl_planten_artikel tell bl_planten_artikel, length 46 ^C 7 packets captured 7 packets received by filter 0 packets dropped by kernel [root@bl-bug01 bl]# [root@bl-bug01 bl]# [root@bl-bug01 bl]# [root@bl-bug01 bl]# snmpwalk -v2c -c public 192.168.0.153 SNMPv2-MIB::sysDescr.1 = STRING: A4+/300 (3.38/May 8 2015) SNMPv2-MIB::sysObjectID.1 = OID: SNMPv2-SMI::enterprises.15865.1.1 SNMPv2-MIB::sysUpTime.1 = Timeticks: (190538900) 22 days, 1:16:29.00 Am I missing something? Ronald

2 1

Alerts rrd in wrong directory
by Louis Bailleul 04 Mar '16

04 Mar '16

Hi all, I just noticed that the rrd for my alerts have been created in the root rrd directoy instead of in each device directory. Is this a known issue ? The alerts availability graphs don’t work as they look for the rrd in the wrong place : RRDTool Output: ERROR: opening '/data/observium/rrd/lswc11u21 /alert-3375.rrd': No such file or directory Total time: 0.012 | RRDtool time: 0.011s # ls -l rrd/alert-337* | head -rw-r--r-- 1 root root 233120 Feb 29 12:25 rrd/alert-3370.rrd -rw-r--r-- 1 root root 233120 Feb 29 12:25 rrd/alert-3371.rrd -rw-r--r-- 1 root root 233120 Feb 29 12:25 rrd/alert-3372.rrd -rw-r--r-- 1 root root 233120 Feb 29 12:25 rrd/alert-3373.rrd -rw-r--r-- 1 root root 233120 Feb 29 12:25 rrd/alert-3374.rrd -rw-r--r-- 1 root root 233120 Feb 29 12:25 rrd/alert-3375.rrd -rw-r--r-- 1 root root 233120 Feb 29 12:25 rrd/alert-3376.rrd -rw-r--r-- 1 root root 233120 Feb 29 12:25 rrd/alert-3377.rrd -rw-r--r-- 1 root root 233120 Feb 29 12:25 rrd/alert-3378.rrd -rw-r--r-- 1 root root 233120 Feb 29 12:25 rrd/alert-3379.rrd It looks like only the visualization code is looking for the rrd in the wrong place. As If I copy the rrd into the right directory the graph is displayed correctly and it shows that it has been updated when the alert failed. I am using the stable svn version : # svn info Path: . Working Copy Root Path: /data/observium URL: http://svn.observium.org/svn/observium/branches/stable Repository Root: http://svn.observium.org/svn Repository UUID: 61d68cd4-352d-0410-923a-c4978735b2b8 Revision: 7599 Node Kind: directory Schedule: normal Last Changed Author: adama Last Changed Rev: 7535 Last Changed Date: 2016-01-27 13:11:02 +0000 (Wed, 27 Jan 2016) 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.

2 4