- observium - lists.observium.org

Re: [Observium] errors on upgrade
by Jeffrey d'Ambly 13 Apr '16

13 Apr '16

So starting with a 100% new db I’m still getting these errors mysql> CREATE DATABASE observium DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; Query OK, 1 row affected (0.00 sec) mysql> GRANT ALL PRIVILEGES ON observium.* TO 'observium'@'localhost' IDENTIFIED BY ‘*******'; Query OK, 0 rows affected (0.00 sec) mysql> exit Bye You have new mail in /var/spool/mail/root [root@sjc-corp-net01 observium]# ./discovery.php -u MySQL Error 1045: Access denied for user 'observium'@'localhost' (using password: YES) [root@sjc-corp-net01 observium]# vi config.php [root@sjc-corp-net01 observium]# ./discovery.php -u ___ _ _ / _ \ | |__ ___ ___ _ __ __ __(_) _ _ _ __ ___ | | | || '_ \ / __| / _ \| '__|\ \ / /| || | | || '_ ` _ \ | |_| || |_) |\__ \| __/| | \ V / | || |_| || | | | | | \___/ |_.__/ |___/ \___||_| \_/ |_| \__,_||_| |_| |_| Observium Professional 0.16.4.7747 http://www.observium.org Install initial database schema ... FALSE. -- Updating database/file schema 000 -> 001 ... (db) done. 001 -> 002 ... (db) done (13 errors). 002 -> 003 ... (db) done (6 errors). 003 -> 004 ... (db) done (22 errors). 004 -> 005 ... (db) done (8 errors). 005 -> 006 ... (db) done (2 errors). 006 -> 007 ... (db) done. 007 -> 008 ... (db) done (1 errors). 008 -> 009 ... (db) done (9 errors). 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 (5 errors). 016 -> 017 ... (db) done (1 errors). 017 -> 018 ... (db) done (3 errors). 018 -> 019 ... (db) done. 019 -> 020 ... (db) done (6 errors). 020 -> 021 ... (db) done (3 errors). 021 -> 022 ... (db) done (1 errors). 022 -> 023 ... (db) done (2 errors). 023 -> 024 ... (db) done (2 errors). 024 -> 025 ... (db) done (8 errors). 025 -> 026 ... (db) done. 026 -> 027 ... (db) done (1 errors). 027 -> 028 ... (db) done (8 errors). 028 -> 029 ... (db) done. 029 -> 030 ... (db) done. 030 -> 031 ... (db) done (1 errors). 031 -> 032 ... (db) done (2 errors). 032 -> 033 ... (db) done. 033 -> 034 ... (db) done. 034 -> 035 ... (db) done. 035 -> 036 ... (db) done (1 errors). 036 -> 037 ... (db) done (2 errors). 037 -> 038 ... (db) done (1 errors). 038 -> 039 ... (db) done (1 errors). 039 -> 040 ... (db) done. 040 -> 041 ... (db) done. 041 -> 042 ... (db) done (3 errors). 042 -> 043 ... (db) done (7 errors). 043 -> 044 ... (db) done (2 errors). 044 -> 045 ... (db) done (2 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 (1 errors). 050 -> 051 ... (db) done. 051 -> 052 ... (db) done (1 errors). 052 -> 053 ... (db) done (1 errors). 053 -> 054 ... (db) done (1 errors). 054 -> 055 ... (db) done (3 errors). 055 -> 056 ... (db) done (1 errors). 056 -> 057 ... (db) done (1 errors). 057 -> 058 ... (db) done (1 errors). 058 -> 059 ... (db) done (2 errors). 059 -> 060 ... (db) done (1 errors). 060 -> 061 ... (db) done (1 errors). 061 -> 062 ... (db) done (1 errors). 062 -> 063 ... (db) done (5 errors). 063 -> 064 ... (db) done (3 errors). 064 -> 065 ... (db) done (2 errors). 065 -> 066 ... (db) done (1 errors). 066 -> 067 ... (db) done (1 errors). 067 -> 068 ... (db) done (2 errors). 068 -> 069 ... (db) done (4 errors). 069 -> 070 ... (db) done (2 errors). 070 -> 071 ... (db) done (1 errors). 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 (3 errors). 077 -> 078 ... (db) done. 078 -> 079 ... (db) done. 079 -> 080 ... (db) done (35 errors). 080 -> 081 ... (db) done (2 errors). 081 -> 082 ... (db) done (9 errors). 082 -> 083 ... (db) done. 083 -> 084 ... (db) done (2 errors). 084 -> 085 ... (db) done (3 errors). 085 -> 086 ... (db) done (1 errors). 086 -> 087 ... (db) done (2 errors). 087 -> 088 ... (db) done (1 errors). 088 -> 089 ... (db) done (5 errors). 089 -> 090 ... (db) done (3 errors). 090 -> 091 ... (db) done (1 errors). 091 -> 092 ... (db) done (1 errors). 092 -> 093 ... (db) done (3 errors). 093 -> 094 ... (db) done (1 errors). 094 -> 095 ... (php) Converting alert serialize() arrays to JSON: 095 -> 096 ... (db) done (1 errors). 096 -> 097 ... (db) done. 097 -> 098 ... (db) done (1 errors). 098 -> 099 ... (db) done (1 errors). 099 -> 100 ... (db) done (1 errors). 100 -> 101 ... (db) done (1 errors). 101 -> 102 ... (db) done (1 errors). 102 -> 103 ... (db) done (1 errors). 103 -> 104 ... (db) done (2 errors). 104 -> 105 ... (db) done. 105 -> 106 ... (db) done (2 errors). 106 -> 107 ... (db) done (1 errors). 107 -> 108 ... (db) done (1 errors). 108 -> 109 ... (db) done (1 errors). 109 -> 110 ... (db) done (3 errors). 110 -> 111 ... (db) done. 111 -> 112 ... (db) done. 112 -> 113 ... (db) done. 113 -> 114 ... (db) done (1 errors). 114 -> 115 ... (db) done (1 errors). 115 -> 116 ... (db) done (1 errors). 116 -> 117 ... (db) done. 117 -> 118 ... (db) done (1 errors). 118 -> 119 ... (db) done (19 errors). 119 -> 120 ... (db) done (1 errors). 120 -> 121 ... (db) done. 121 -> 122 ... (db) done (3 errors). 122 -> 123 ... (db) done (4 errors). 123 -> 124 ... (db) done. 124 -> 125 ... (db) done. 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 (1 errors). 131 -> 132 ... (db) done (1 errors). 132 -> 133 ... (db) done. 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 (5 errors). 139 -> 140 ... (db) done (1 errors). 140 -> 141 ... (db) done (3 errors). 141 -> 142 ... (db) done (4 errors). 142 -> 143 ... (db) done (2 errors). 143 -> 144 ... (db) done (1 errors). 144 -> 145 ... (db) done. 145 -> 146 ... (db) done (1 errors). 146 -> 147 ... (db) done (1 errors). 147 -> 148 ... (db) done (3 errors). 148 -> 149 ... (db) done (3 errors). 149 -> 150 ... (db) done (7 errors). 150 -> 151 ... (db) done. 151 -> 152 ... (db) done. 152 -> 153 ... (php) 153 -> 154 ... (db) done. 154 -> 155 ... (db) done (1 errors). 155 -> 156 ... (db) done. 156 -> 157 ... (db) done (1 errors). 157 -> 158 ... (db) done (4 errors). 158 -> 159 ... (db) done (1 errors). 159 -> 160 ... (db) done (1 errors). 160 -> 161 ... (db) done. 161 -> 162 ... (db) done. 162 -> 163 ... (db) done (1 errors). 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 (2 errors). 167 -> 168 ... (db) done. 168 -> 169 ... (db) done (2 errors). 169 -> 170 ... (php) Move old GEO data if exist: 170 -> 171 ... (db) done (1 errors). 171 -> 172 ... (db) done. 172 -> 173 ... (db) done (1 errors). 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 (7 errors). 178 -> 179 ... (db) done (2 errors). 179 -> 180 ... (db) done. 180 -> 181 ... (db) done (1 errors). 181 -> 182 ... (db) done. 182 -> 183 ... (db) done. 183 -> 184 ... (db) done (17 errors). 184 -> 185 ... (db) done. 185 -> 186 ... (db) done (10 errors). 186 -> 187 ... (php) 187 -> 188 ... (db) done (2 errors). 188 -> 189 ... (db) done (2 errors). 189 -> 190 ... (db) done (1 errors). 190 -> 191 ... (php) Migrating state sensors to status entries: 191 -> 192 ... (db) done (3 errors). 192 -> 193 ... (db) done (1 errors). 193 -> 194 ... (db) done (1 errors). 194 -> 195 ... (db) done. 195 -> 196 ... (db) done (2 errors). 196 -> 197 ... (db) done (1 errors). 197 -> 198 ... (db) done (1 errors). 198 -> 199 ... (db) done. 199 -> 200 ... (db) done (6 errors). 200 -> 201 ... (db) done (1 errors). 201 -> 202 ... (db) done (7 errors). 202 -> 203 ... (db) done. 203 -> 204 ... (db) done. 204 -> 205 ... (db) done. 205 -> 206 ... (db) done. 206 -> 207 ... (db) done. 207 -> 208 ... (db) done (1 errors). 208 -> 209 ... (db) done (7 errors). 209 -> 210 ... (php) 210 -> 211 ... (db) done (1 errors). 211 -> 212 ... (php) 212 -> 213 ... (db) done (3 errors). 213 -> 214 ... (db) done (1 errors). 214 -> 215 ... (db) done. 215 -> 216 ... (db) done (1 errors). 216 -> 217 ... (db) done. 217 -> 218 ... (db) done. 218 -> 219 ... (db) done. 219 -> 220 ... (db) done (1 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 (2 errors). 225 -> 226 ... (db) done. 226 -> 227 ... (db) done (2 errors). 227 -> 228 ... (db) done (10 errors). 228 -> 229 ... (db) done. 229 -> 230 ... (db) done (1 errors). 230 -> 231 ... (db) done (1 errors). 231 -> 232 ... (db) done (1 errors). 232 -> 233 ... (db) done (2 errors). 233 -> 234 ... (db) done (1 errors). 234 -> 235 ... (db) done (2 errors). 235 -> 236 ... (db) done. 236 -> 237 ... (db) done. 237 -> 238 ... (db) done. 238 -> 239 ... (db) done (1 errors). 239 -> 240 ... (db) done (1 errors). 240 -> 241 ... (db) done. 241 -> 242 ... (db) done. 242 -> 243 ... (db) done. 243 -> 244 ... (db) done. 244 -> 245 ... (db) done (1 errors). 245 -> 246 ... (db) done. 246 -> 247 ... (db) done (1 errors). 247 -> 248 ... (db) done. 248 -> 249 ... (db) done (1 errors). 249 -> 250 ... (db) done (1 errors). 250 -> 251 ... (db) done. 251 -> 252 ... (db) done (5 errors). 252 -> 253 ... (db) done (1 errors). 253 -> 254 ... (db) done (1 errors). 254 -> 255 ... (db) done. 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 (9 errors). 264 -> 265 ... (db) done. 265 -> 266 ... (db) done. 266 -> 267 ... (db) done (1 errors). 267 -> 268 ... (php) 268 -> 269 ... (php) 269 -> 270 ... (db) done. 270 -> 271 ... (db) done (3 errors). 271 -> 272 ... (db) done. 272 -> 273 ... (db) done (1 errors). 273 -> 274 ... (php) -- Done. [root@sjc-corp-net01 observium]# df -h Filesystem Size Used Avail Use% Mounted on /dev/mapper/vg_sjccorpnet01-lv_root 50G 3.9G 43G 9% / tmpfs 127G 0 127G 0% /dev/shm /dev/sda1 477M 68M 384M 15% /boot /dev/mapper/vg_sjccorpnet01-lv_home 359G 282G 60G 83% /home [root@sjc-corp-net01 observium]# From: observium <observium-bounces(a)observium.org<mailto:observium-bounces@observium.org>> on behalf of Adam Armstrong <adama(a)memetic.org<mailto:adama@memetic.org>> Reply-To: Observium Network Observation System <observium(a)observium.org<mailto:observium@observium.org>> Date: Tuesday, April 12, 2016 at 11:48 PM To: Observium Network Observation System <observium(a)observium.org<mailto:observium@observium.org>> Subject: Re: [Observium] errors on upgrade Yes. That looks like everything failed, and your database is probably now not something observium can properly interact with. Adam. Sent from BlueMail<http://www.bluemail.me/r> On Apr 13, 2016, at 07:46, Jeffrey d'Ambly <jeffrey.dambly(a)jasper.com<mailto:jeffrey.dambly@jasper.com>> wrote: Should I be worried about these errors? [root@sjc-corp-net01 observium]# ./discovery.php -u ___ _ _ / _ \ | |__ ___ ___ _ __ __ __(_) _ _ _ __ ___ | | | || '_ \ / __| / _ \| '__|\ \ / /| || | | || '_ ` _ \ | |_| || |_) |\__ \| __/| | \ V / | || |_| || | | | | | \___/ |_.__/ |___/ \___||_| \_/ |_| \__,_||_| |_| |_| Observium Professional 0.16.4.7747 http://www.observium.org -- Updating database/file schema 195 -> 196 ... (db) done. 196 -> 197 ... (db) done. 197 -> 198 ... (db) done. 198 -> 199 ... (db) done. 199 -> 200 ... (db) done. 200 -> 201 ... (db) done. 201 -> 202 ... (db) done (1 errors). 202 -> 203 ... (db) done. 203 -> 204 ... (db) done. 204 -> 205 ... (db) done. 205 -> 206 ... (db) done. 206 -> 207 ... (db) done. 207 -> 208 ... (db) done. 208 -> 209 ... (db) done (4 errors). 209 -> 210 ... (php) 210 -> 211 ... (db) done (5 errors). 211 -> 212 ... (php) 212 -> 213 ... (db) done (11 errors). 213 -> 214 ... (db) done (2 errors). 214 -> 215 ... (db) done (3 errors). 215 -> 216 ... (db) done (1 errors). 216 -> 217 ... (db) done (1 errors). 217 -> 218 ... (db) done (1 errors). 218 -> 219 ... (db) done (1 errors). 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 (2 errors). 225 -> 226 ... (db) done. 226 -> 227 ... (db) done (2 errors). 227 -> 228 ... (db) done (10 errors). 228 -> 229 ... (db) done (3 errors). 229 -> 230 ... (db) done (1 errors). 230 -> 231 ... (db) done (1 errors). 231 -> 232 ... (db) done (1 errors). 232 -> 233 ... (db) done (2 errors). 233 -> 234 ... (db) done (1 errors). 234 -> 235 ... (db) done (3 errors). 235 -> 236 ... (db) done (1 errors). 236 -> 237 ... (db) done. 237 -> 238 ... (db) done (1 errors). 238 -> 239 ... (db) done (1 errors). 239 -> 240 ... (db) done (3 errors). 240 -> 241 ... (db) done (1 errors). 241 -> 242 ... (db) done (4 errors). 242 -> 243 ... (db) done (1 errors). 243 -> 244 ... (db) done (6 errors). 244 -> 245 ... (db) done (1 errors). 245 -> 246 ... (db) done (1 errors). 246 -> 247 ... (db) done (2 errors). 247 -> 248 ... (db) done (2 errors). 248 -> 249 ... (db) done (1 errors). 249 -> 250 ... (db) done (1 errors). 250 -> 251 ... (db) done (1 errors). 251 -> 252 ... (db) done (5 errors). 252 -> 253 ... (db) done. 253 -> 254 ... (db) done. 254 -> 255 ... (db) done (2 errors). 255 -> 256 ... (php) 256 -> 257 ... (php) 257 -> 258 ... (php) 258 -> 259 ... (db) done. 259 -> 260 ... (php) 260 -> 261 ... (db) done (6 errors). 261 -> 262 ... (php) 262 -> 263 ... (db) done (1 errors). 263 -> 264 ... (db) done (9 errors). 264 -> 265 ... (db) done (1 errors). 265 -> 266 ... (db) done (2 errors). 266 -> 267 ... (db) done (1 errors). 267 -> 268 ... (php) 268 -> 269 ... (php) 269 -> 270 ... (db) done (1 errors). 270 -> 271 ... (db) done (10 errors). 271 -> 272 ... (db) done (5 errors). 272 -> 273 ... (db) done (2 errors). 273 -> 274 ... (php) -- Done. You have new mail in /var/spool/mail/root [root@sjc-corp-net01 observium]# ________________________________ observium mailing list observium(a)observium.org<mailto:observium@observium.org> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium

2 3

errors on upgrade
by Jeffrey d'Ambly 13 Apr '16

13 Apr '16

Should I be worried about these errors? [root@sjc-corp-net01 observium]# ./discovery.php -u ___ _ _ / _ \ | |__ ___ ___ _ __ __ __(_) _ _ _ __ ___ | | | || '_ \ / __| / _ \| '__|\ \ / /| || | | || '_ ` _ \ | |_| || |_) |\__ \| __/| | \ V / | || |_| || | | | | | \___/ |_.__/ |___/ \___||_| \_/ |_| \__,_||_| |_| |_| Observium Professional 0.16.4.7747 http://www.observium.org -- Updating database/file schema 195 -> 196 ... (db) done. 196 -> 197 ... (db) done. 197 -> 198 ... (db) done. 198 -> 199 ... (db) done. 199 -> 200 ... (db) done. 200 -> 201 ... (db) done. 201 -> 202 ... (db) done (1 errors). 202 -> 203 ... (db) done. 203 -> 204 ... (db) done. 204 -> 205 ... (db) done. 205 -> 206 ... (db) done. 206 -> 207 ... (db) done. 207 -> 208 ... (db) done. 208 -> 209 ... (db) done (4 errors). 209 -> 210 ... (php) 210 -> 211 ... (db) done (5 errors). 211 -> 212 ... (php) 212 -> 213 ... (db) done (11 errors). 213 -> 214 ... (db) done (2 errors). 214 -> 215 ... (db) done (3 errors). 215 -> 216 ... (db) done (1 errors). 216 -> 217 ... (db) done (1 errors). 217 -> 218 ... (db) done (1 errors). 218 -> 219 ... (db) done (1 errors). 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 (2 errors). 225 -> 226 ... (db) done. 226 -> 227 ... (db) done (2 errors). 227 -> 228 ... (db) done (10 errors). 228 -> 229 ... (db) done (3 errors). 229 -> 230 ... (db) done (1 errors). 230 -> 231 ... (db) done (1 errors). 231 -> 232 ... (db) done (1 errors). 232 -> 233 ... (db) done (2 errors). 233 -> 234 ... (db) done (1 errors). 234 -> 235 ... (db) done (3 errors). 235 -> 236 ... (db) done (1 errors). 236 -> 237 ... (db) done. 237 -> 238 ... (db) done (1 errors). 238 -> 239 ... (db) done (1 errors). 239 -> 240 ... (db) done (3 errors). 240 -> 241 ... (db) done (1 errors). 241 -> 242 ... (db) done (4 errors). 242 -> 243 ... (db) done (1 errors). 243 -> 244 ... (db) done (6 errors). 244 -> 245 ... (db) done (1 errors). 245 -> 246 ... (db) done (1 errors). 246 -> 247 ... (db) done (2 errors). 247 -> 248 ... (db) done (2 errors). 248 -> 249 ... (db) done (1 errors). 249 -> 250 ... (db) done (1 errors). 250 -> 251 ... (db) done (1 errors). 251 -> 252 ... (db) done (5 errors). 252 -> 253 ... (db) done. 253 -> 254 ... (db) done. 254 -> 255 ... (db) done (2 errors). 255 -> 256 ... (php) 256 -> 257 ... (php) 257 -> 258 ... (php) 258 -> 259 ... (db) done. 259 -> 260 ... (php) 260 -> 261 ... (db) done (6 errors). 261 -> 262 ... (php) 262 -> 263 ... (db) done (1 errors). 263 -> 264 ... (db) done (9 errors). 264 -> 265 ... (db) done (1 errors). 265 -> 266 ... (db) done (2 errors). 266 -> 267 ... (db) done (1 errors). 267 -> 268 ... (php) 268 -> 269 ... (php) 269 -> 270 ... (db) done (1 errors). 270 -> 271 ... (db) done (10 errors). 271 -> 272 ... (db) done (5 errors). 272 -> 273 ... (db) done (2 errors). 273 -> 274 ... (php) -- Done. You have new mail in /var/spool/mail/root [root@sjc-corp-net01 observium]#

2 1

Adding an OS
by David Snowdon 13 Apr '16

13 Apr '16

Dear Observium, My apologies if this is not posted to the right place— this question must have been covered many times but the archives of this list don’t seem to be accessible. I am looking for how to add an OS for our devices ( https://www.metamako.com ). I found this documentation ( http://www.observium.org/docs/developing/add_os/ <http://www.observium.org/docs/developing/add_os/> ) but it seems to be out of date, since there doesn’t appear to be an includes/definitions/os.inc.php file. There’s a definitions.dat file, but this is a binary. Any assistance would be much appreciated. Do I need to be paid up for the subscription edition to make contributions? This seems backward as we would be able to promote Observium for use by our customers. Cheers, David Snowdon CTO, Metamako

2 1

More sensor issues with Dell equipment
by Martin 12 Apr '16

12 Apr '16

More sensor issues with Dell equipment: (S4810) SFP receive power reading returns only 0's (In cli reasonable values are shown), but I guess I have to yell at Dell for this one... CMD[/usr/bin/snmpbulkwalk -v2c -c *** -Pu -OQUs -m F10-S-SERIES-CHASSIS-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp:/opt/observium/mibs/force10 'udp':'***':'161' chSysPortXfpRecvPower] EXITCODE[0] CMD RUNTIME[0.0695s] STDOUT[ chSysPortXfpRecvPower.1.0 = .00 chSysPortXfpRecvPower.1.1 = .00 chSysPortXfpRecvPower.1.2 = .00 chSysPortXfpRecvPower.1.3 = .00 ... chSysPortXfpRecvPower.1.47 = .00 chSysPortXfpRecvPower.1.48 = .00 chSysPortXfpRecvPower.1.49 = .00 chSysPortXfpRecvPower.1.53 = .00 chSysPortXfpRecvPower.1.57 = .00 chSysPortXfpRecvPower.1.61 = .00 Same for chSysPortXfpTxPower. Anyone seen reasonable values for these variables in SNMP? Regards, Martin

1 0

Issue wih temperature reporting from Dell 7000 series switch
by Ric Davis 11 Apr '16

11 Apr '16

Hi All There's a small problem with temperature reporting from the Dell 7000 (specifically 7048 in this case) switch. The device page reports the stack unit internal temperature multiple times (I'd estimate >100), none of which look correct: I've copied and pasted the top and bottom of the reports, to show the way three of them read 0. The current firmware version is 5.1.8.2 - It was also present on the previous version of switch firmware we were running (from memory something like 5.1.0.1). I'd presume this is the result of the Dell SNMP response, but is there any kind of a workaround available? The devices web interface does report at least plausible temperature values, so it's unlikely to be a failing sensor. This is on the current CE, but was also present on the previous CE. The device event log has "3h 46m 57s Sensor deleted: temperature fastpath-boxservices-private-mib boxServicesStackTempSensorTemperature.1.1604 Stack Unit Internal Temperature 3h 46m 57s Sensor deleted: temperature fastpath-boxservices-private-mib boxServicesStackTempSensorTemperature.1.1603 Stack Unit Internal Temperature 3h 46m 57s Sensor deleted: temperature fastpath-boxservices-private-mib boxServicesStackTempSensorTemperature.1.1602 Stack Unit Internal Temperature 3h 46m 57s Sensor deleted: temperature fastpath-boxservices-private-mib boxServicesStackTempSensorTemperature.1.1601 Stack Unit Internal Temperature 3h 46m 57s Sensor deleted: temperature fastpath-boxservices-private-mib boxServicesStackTempSensorTemperature.1.1600 Stack Unit Internal Temperature 3h 46m 57s Sensor deleted: temperature fastpath-boxservices-private-mib boxServicesStackTempSensorTemperature.1.1599 Stack Unit Internal Temperature 3h 46m 57s Stack Unit Internal Temperature <http://observium/device/device=11/tab=health/metric=temperature/id=17570/> Sensor added: temperature fastpath-boxservices-private-mib boxServicesStackTempSensorTemperature.1.1772 Stack Unit Internal Temperature 3h 46m 57s Stack Unit Internal Temperature <http://observium/device/device=11/tab=health/metric=temperature/id=17569/> Sensor added: temperature fastpath-boxservices-private-mib boxServicesStackTempSensorTemperature.1.1771 Stack Unit Internal Temperature 3h 46m 57s Stack Unit Internal Temperature <http://observium/device/device=11/tab=health/metric=temperature/id=17568/> Sensor added: temperature fastpath-boxservices-private-mib boxServicesStackTempSensorTemperature.1.1770 Stack Unit Internal Temperature 3h 46m 57s Stack Unit Internal Temperature <http://observium/device/device=11/tab=health/metric=temperature/id=17567/> Sensor added: temperature fastpath-boxservices-private-mib boxServicesStackTempSensorTemperature.1.1769 Stack Unit Internal Temperature 3h 46m 57s Stack Unit Internal Temperature <http://observium/device/device=11/tab=health/metric=temperature/id=17566/> Sensor added: temperature fastpath-boxservices-private-mib boxServicesStackTempSensorTemperature.1.1768 Stack Unit Internal Temperature 3h 46m 57s Stack Unit Internal Temperature <http://observium/device/device=11/tab=health/metric=temperature/id=17565/> Sensor added: temperature fastpath-boxservices-private-mib boxServicesStackTempSensorTemperature.1.1767 Stack Unit Internal Temperature [image: Inline images 1] [image: Inline images 2] -- Ric

2 3

Run Alerts Checks
by Kevin Wormington 11 Apr '16

11 Apr '16

Hi, Is it possible to run the alert checks outside of the normal poll cycle? I have a simple perl script that receives SNMP traps and calls the snmptrap.php observium script and the interface is correctly marked down/up but the alert does not happen until the next poll cycle. Thanks, Kevin

2 1

Radwin 2000c as p2p-radios
by Luiz Gustavo Fernandes 11 Apr '16

11 Apr '16

I'm trying to monitor Radwin 2000c radios, but I'm having some difficulties, could someone tell me which files are needed for the Observium identify as p2p-radios? I've done to identify the OS, and set as $ type = "p2p-radios" Tks

1 0

APC PDU alert question
by Laszlo Nemeth 11 Apr '16

11 Apr '16

Hello I have some APC PDU with two lines of plugs. The name of the first row of plugs are: "Bank 1" and the second row's name is Bank 2. The two banks have a summarized current value, this is the "Bank Total". I would like to create an alert for the Bank 1 and Bank 2 (if the current ge 7 send an alert) but not for Bank Total. Device Entity Status Checked Changed Alerted pdu05 Bank 2 OK 2m 40s 14m 34s Never pdu05 Bank 1 OK 2m 40s 14m 34s Never pdu05 Bank Total OK 2m 40s 14m 35s Never pdu06 Bank 2 OK 2m 52s 14m 26s Never pdu06 Bank 1 OK 2m 52s 14m 26s Never pdu06 Bank Total OK 2m 52s 14m 26s Never If I add an alert where “Check conditions” is "sensor_value ge 7” and Associations “Device Match” is “hostname match pdu0*” it will be true for the Bank Total Entity too. There is any solution for alerting only for the Bank 1 and Bank2? Thanks Laszlo

2 1

Issues getting the unix-agent to work
by Lewis E. Bogan 10 Apr '16

10 Apr '16

After setting up my target host per instructions, I get this error: [2016/04/10 04:26:47 +0000] poller.php(6436): UNIX-AGENT: Connection on tcp://gitserver:33602 failed. ERROR: 111 Connection refused Selinux is disabled, firewall is disabled. I tried searching the mailing list archives but all I get is a 'not found' error. My server is running on CentOs7. I also tried Ubuntu14. My clients vary from Fedora, Centos7, and Ubuntu. I appreciate any and all assistance offered. Lewis

2 2

Syslog timestamps
by Jason Vanlandingham 09 Apr '16

09 Apr '16

When I look at a device's page, the syslog entries shown below are odd... Things that just happened will say "5h 20s". Hovering the mouse pointer over them shows the correct time on the entry. The Observium server and client I'm on both have the correct time. Are those time marks done using GMT? (I'm on Central DST, so that would make sense.) Can that be changed?

1 0

Help with Alert Check
by Eduardo Schoedler 08 Apr '16

08 Apr '16

Hi, I'm unable to make an alert checker work. As you can see, red alarm was triggered 1h12m ago. [image: Imagem inline 1] But the checker was not triggered: [image: Imagem inline 2] What I'm doing wrong? Thank you. Regards, -- Eduardo Schoedler

2 2

Zhone MXK Support on Observium
by ChanTy 08 Apr '16

08 Apr '16

Hi Does Observium support Zhone (http://www.zhone.com) ? Thanks, chanty

1 0

snmp.conf change for r7728 and up on Debian/Ubuntu
by Tom Laermans 07 Apr '16

07 Apr '16

Hi all, Due to a MIB move, if you svn up to the latest release, you might encounter silly output from the SNMP library in PHP. This is the case if you have the php5-snmp module installed, and have added our mib directory to /etc/snmp/snmp.conf. To fix this, replace: mibdirs /opt/observium/mibs by mibdirs /opt/observium/mibs:/opt/observium/mibs/net-snmp I've updated the install docs to reflect this. Tom

1 0

Fwd: Front Page incorrectly displaying ports - Subscription Edition
by Serghei Golipad 07 Apr '16

07 Apr '16

Hi Guys, No-one has responded to me so far, I have 5 ports DOWN yet main page is displaying 37 of them are: [cid:F145DDEA-98D9-4D97-AAC7-3A23EC58D7D8] [cid:F5C88FDC-C740-49AF-BCFC-47830781078A] Any ideas? Thank you PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS EMAIL. CDW Limited is a Company registered in England and Wales. This email is sent for and on behalf of CDW Finance Holdings Limited. CDW Finance Holdings Limited is the UK holding company for CDW Limited trading as CDW. The registered office for CDW Finance Holdings Limited (Company Number 05872067) and its UK group undertakings is 10 Fleet Place, London, EC4M 7RB. VAT Registration 902 1949 39. Confidentiality: This e-mail contains proprietary information, some or all of which may be confidential and/or legally privileged. It is for the intended recipient only. If an addressing or transmission error has misdirected this e-mail, please notify the author by replying to this e-mail and then delete the original. If you are not the intended recipient you may not use, disclose, distribute, copy, print or rely on any information contained in this e-mail. You must not inform any other person other than CDW or the sender of its existence. For more information about CDW please visit www.uk.cdw.com

2 6

No Auth_Mechanisms defined to add user
by David Shirk 06 Apr '16

06 Apr '16

All, So I followed the install process to a T, and it was going very well until I hit this: ./adduser.php <my username> <my Password> 10Observium CE 0.16.1.7533Add User ERROR: no valid auth_mechanism defined. I am running Debian 7 VM, and all dependencies are there. $config['auth_mechanism] = "mysql"; is in the config.php Anyone else run into this before?

1 0

Re: [Observium] Question Regarding CISCO and TX Discards
by Richard Müller 06 Apr '16

06 Apr '16

Hy Guys, thanks to all your feedback. I thought there is some "special black magic command" the guy from the ISP does not know (and me either) - "show int..." is of course known to me and should be known to everybody working on an ISP - but reality looks different. ;-) @Adam: Thanks for the Reference, to sort out the kind of error, this really helps me out. Richard -- Richard Müller | Geschäftsführer teamix GmbH Südwestpark 43 90449 Nürnberg Tel.: +49 911 30999 0 | Fax: +49 911 30999 99 mail: rm(a)teamix.de | web: http://www.teamix.de | blog: http://blog.teamix.de Amtsgericht Nürnberg, HRB 18320 | Geschäftsführer: Oliver Kügow, Richard Müller Systemhaus Check 2016 – wie zufrieden sind Sie? http://umfragen.idgmedia.de/uc/cw/sys2016/

1 0

Question Regarding CISCO and TX Discards
by Richard Müller 06 Apr '16

06 Apr '16

Hy Observium Community I have a router, which is only accessible via SNMP from my company, and it shows up some TX-Discards Just look on this picture: [cid:image001.png@01D1903E.84B547A0] Unfortunately the company who is administering the Router tells me that they do not see any error. I really do not have a clue which kind of Tx Discards these are and how they can be shown in CLI. Does anybody have a clue which “show” Command I have to tell the guy from the ISP that he is seeing these kinds of errors, also. It is a CISCO2911/K9 and it is a Gigabit Ethernet Interface. Thanks in advance. Richard -- <http://www.teamix.de>[teamix]<http://www.teamix.de> Richard Müller Geschäftsführer teamix GmbH Südwestpark 43 90449 Nürnberg Tel.: +49 911 30999 0 Fax: +49 911 30999 99 mail: rm(a)teamix.de web: http://www.teamix.de blog: http://blog.teamix.de Amtsgericht Nürnberg, HRB 18320 | Geschäftsführer: Oliver Kügow, Richard Müller Systemhaus Check 2016 – wie zufrieden sind Sie? http://umfragen.idgmedia.de/uc/cw/sys2016/

3 3

Monitoring job status
by Mark Creamer 06 Apr '16

06 Apr '16

Hi, is there a way within Observium to monitor a file system to check that a new file appears at a given time, or alternatively to monitor a log for an entry to appear? The idea is, there are some scheduled tasks running on a Linux server. We can have each task do something on completion, like write a file somewhere, write to a log, post to a database, etc. We want to see if Observium can watch for something like that and alert if it doesn't occur. Method is completely undecided at this point so any ideas are much appreciated. Thanks, -- Mark

1 0

Mail list archives.
by Luiz Gustavo Fernandes 06 Apr '16

06 Apr '16

Hello guys, where can I find the file from the email list? The link to the archive is broken. http://postman.memetic.org/cgi-bin/mailman/listinfo/observium -> http://postman.memetic.org/pipermail/observium/ Thanks

1 0

Observium detected as spam
by Simon Smith 06 Apr '16

06 Apr '16

Hi All, not sure if this is an issue with our mailcleaners or observium emails ? but our mailcleaners are now picking up observium emails as spam ? Score Description 2.0 TO_NO_BRKTS_HTML_IMG 2.0 XPRIO 1.3 HTML: images with 2000-2400 bytes of words 0.0 HTML included in message 5.3 we have a score of 5 set, so sadly just passes it the emails where never being detected with these TO_NO_BRKTS_HTML_IMG ? or XPIRO ? in the past, only recently? has the been any changes in the email alerts code at all ? Regards Simon - Hestor Ltd

2 2

Alert Notifications when Alerting is Disabled
by Müller, Gabriel 05 Apr '16

05 Apr '16

For devices I recently have added to my Observium installation, I receive interface / port ALERT and RECOVERY notifications emails even though I did disable Alerting under Properties > Ports, selecting no in the Alerts column. Version: 0.16.3.7653 Professional Any idea? Many thanks, Br Gabriel

1 0

Fwd: The archives are broken
by ovizii 05 Apr '16

05 Apr '16

I am getting a 404 error when visiting your archives: http://postman.memetic.org/pipermail/observium/ <http://postman.memetic.org/pipermail/observium/> -- The information in this email and attachments hereto may contain legally privileged, proprietary or confidential information that is intended for a particular recipient. If you are not the intended recipient(s), or the employee or agent responsible for delivery of this message to the intended recipient(s), you are hereby notified that any disclosure, copying, distribution, retention or use of the contents of this e-mail information is prohibited and may be unlawful. When addressed to customers or vendors, any information contained in this e-mail is subject to the terms and conditions in the governing contract, if applicable. If you have received this communication in error, please immediately notify us by return e-mail, permanently delete any electronic copies of this communication and destroy any paper copies.

3 3

Fwd: snmp stopped on all monitored devices at once
by ovizii 05 Apr '16

05 Apr '16

To start off, I have read the FAQ and tried the points described there to fix this exact problem but it didn't help. I have one Proxmox host running a fe w LXC c o ntainers, Observium is installed on one of them and successfully gathered data from all of them for a few days then stopped and shows all of them as down. Here is what I tried and do not understand: ferguson is the Observium container snmpwalk -c XXX -v 2c ferguson gives results, I can see stats and numbers so its working querying itself. snmpwalk -Os -c XXX -v 2c fergusona iso.3.6.1.2.1.1.1 sysDescr.0 = STRING: Linux ferguson 4.2.8-1-pve #1 SMP Sat Mar 19 10:44:29 CET 2016 x86_64 cd /opt/observium/ ./poller.php -d -h ferguson CMD[/usr/bin/snmpget -t '5' -r '10' -v2c -c *** -Pu -OQUst -m SNMPv2-MIB -M /opt/obse rvium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'ferguson':'161' sysObje ctID.0 sysUpTime.0] EXITCODE[1] CMD RUNTIME[55.0381s] STDOUT[ ] STDERR[ Timeout: No Response from udp:ferguson:161. ] SNMP_STATUS[FALSE] o Device status Device is not responding to SNMP requests Any ideas how to debug or fix this? -- The information in this email and attachments hereto may contain legally privileged, proprietary or confidential information that is intended for a particular recipient. If you are not the intended recipient(s), or the employee or agent responsible for delivery of this message to the intended recipient(s), you are hereby notified that any disclosure, copying, distribution, retention or use of the contents of this e-mail information is prohibited and may be unlawful. When addressed to customers or vendors, any information contained in this e-mail is subject to the terms and conditions in the governing contract, if applicable. If you have received this communication in error, please immediately notify us by return e-mail, permanently delete any electronic copies of this communication and destroy any paper copies.

1 0

sample config for pps alerts to monitor
by Sathish.I 05 Apr '16

05 Apr '16

Hello All, I want to create alert for packet/sec (PPS), please let me know the sample config to configure it on observium. Regards, sathish Description: Description: Description: Description: Description: Description: http://www.ctrls.com/email-signature/images/devider.jpg

4 7

Re: [Observium] Graph PPPoE Session
by ChanTy 04 Apr '16

04 Apr '16

Any comment ? From: observium <observium-bounces(a)observium.org> on behalf of Ty Chan <ty.chan(a)corp.mekongnet.com.kh> Reply-To: Observium Network Observation System <observium(a)observium.org> Date: Monday, April 4, 2016 at 11:43 AM To: Observium Network Observation System <observium(a)observium.org> Subject: [Observium] Graph PPPoE Session Hi , Is it possible to graph PPPoE session/Interface? Is the feature there or I need to add on ? Regards, chanty _______________________________________________ observium mailing list observium(a)observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium

2 1

Cisco WS-C3850-48P
by Christopher N Callison 04 Apr '16

04 Apr '16

I have a pair of Cisco 3850 switches (stacked) that I'm using as a core for our relatively small office. I have added them to my Observium system and the normal Cisco L2 & L3 interfaces have been detected and are now in monitoring but the wireless features of the devices are not showing up. I would like to graph the number of active users for each WLAN. I see from Cisco's site (ftp://ftp.cisco.com/pub/mibs/supportlists/cat3850/cat3850-supportlist.html) , that there are a few wireless-oriented MIBs that are supported, but I don't see them in the list of MIBs on my Observium server. AIRESPACE-WIRELESS-MIB CISCO-LWAPP-IDS-MIB CISCO-LWAPP-AP-MIB CISCO-LWAPP-CCX-RM-MIB CISCO-LWAPP-CLIENT-ROAMING-MIB CISCO-LWAPP-DOT11-CCX-CLIENT-DIAG-MIB CISCO-LWAPP-DOT11-CCX-CLIENT-MIB CISCO-LWAPP-DOT11-CLIENT-CCX-REPORTS-MIB CISCO-LWAPP-DOT11-CLIENT-MIB CISCO-LWAPP-DOT11-MIB CISCO-LWAPP-DOWNLOAD-MIB CISCO-LWAPP-LINKTEST-MIB CISCO-LWAPP-MFP-MIB CISCO-LWAPP-MOBILITY-EXT-MIB CISCO-LWAPP-QOS-MIB CISCO-LWAPP-REAP-MIB CISCO-LWAPP-ROGUE-MIB CISCO-LWAPP-RRM-MIB CISCO-LWAPP-SI-MIB CISCO-LWAPP-TSM-MIB CISCO-LWAPP-WLAN-MIB CISCO-LWAPP-WLAN-SECURITY-MIB Is there a procedure for configuring the devices to start using the new MIBs once they have been copied to the appropriate directory or do I need to play around with a SNMP walker to find them myself? Chris Callison

2 3

Re: [Observium] Traffic Graph
by RackEnd 04 Apr '16

04 Apr '16

1 0

Re: [Observium] Traffic Graph
by RackEnd 04 Apr '16

04 Apr '16

3 6

Re: [Observium] Traffic Graph
by RackEnd 04 Apr '16

04 Apr '16

3 2

Traffic Graph
by RackEnd 04 Apr '16

04 Apr '16

2 1

Juniper BGP description
by Eduardo Schoedler 04 Apr '16

04 Apr '16

Hi, Is there a way to get bgp neigbor's description from Juniper? Their MIB support it? Thanks. -- Eduardo Schoedler

2 1

SNMP Trap Import
by Kevin Wormington 04 Apr '16

04 Apr '16

Hi, I’m new to Observium (paid version) and am working toward replacing Zabbix completely with it. I see that there is some old/unsupported support for importing LinkUp/LinkDown traps from snmptt in snmptrap.php. I’m going to be testing it out in the next few days and making any required fixes to get it going with current versions. I have also though about implementing some type of mechanism to log/alert on various traps other than LinkUp/LinkDown such as ColdStart, etc. I am curious if there is any interest in that from other users and any input on how people would like to see it implemented and if anyone else is currently using it. Thanks, Kevin

1 0

Graph PPPoE Session
by ChanTy 04 Apr '16

04 Apr '16

Hi , Is it possible to graph PPPoE session/Interface? Is the feature there or I need to add on ? Regards, chanty

1 0

Missing TenGigabit interfaces on Cisco WC-C4900M
by Per Jorgensen 03 Apr '16

03 Apr '16

Hi all First of all thank to the team of developer for making this program, and making it better and better everyday, love the look and ease of use. But I have run into a problem with a Tengigabit ethernet device I newly added into my Observium v. 0.12.8.3360. it seems that every thing get detected alright, except all the TenGigabitEthernet, interfaces dont show up anywhere in Observium, all other interfaces on that device gets detectet allright, and I can see the interfaces in the ports tab on the device, but not the TenGengigabit interfaces. btw: the device is a Cisco WS-C4900M Is that because Cisco WS-C4900M is not a supported device , or should I do some config changes to get TenGigabitEthernet to work ? if the WC-C4900M is not supported, how can I then contribute with information on the device , and help to then this device supported ? Best Regards Per Jorgensen

7 8

How to add support for new device/type?
by Jens Bürger 02 Apr '16

02 Apr '16

Hello everyone, first: the mailing list archive is somehow not online: http://postman.memetic.org/pipermail/observium/ So I couldn’t have look at the archive to see if my question was answered recently. I would like to add support for my PBX (Siemens HiPath 3000 series, model 3800) to Observium. There this a file containing MIBs available and someone also did preliminary support for Nagios: https://exchange.nagios.org/directory/Plugins/Hardware/Network-Gear/Siemens… So I had a look at this site: http://www.observium.org/docs/developing/add_os/ The file os.inc.php doesn’t exist, but a definitions.dat instead which is a binary file. So I wonder where to start i.e. getting some kind of device template I can start with? Thanks a lot, Jens

1 0

switchmap re: host<-->port L2/L3 matrix
by Rob VanHooren 02 Apr '16

02 Apr '16

indeed, it would be quite handy to have information about the end hosts. obviously not a full scrape of them for monitoring, but that they exist, what they are, and where. ideally, there could be some observium-style SPoG embrace of Pete Siemsen’s switchmap ( https://sourceforge.net/projects/switchmap/ ) his is a wonderfully useful tool in terms of how much information it packs onto one page, but visually … it’s rather archaic. $0.02 R. > On Apr 2, 2016, at 02:47, observium-request(a)observium.org wrote: > >> Adam / Tom / Justin / David /etc/ >> >> {various discussion about port matrix L2 L3 presentation etc…} >>

1 0

patch: show ip associated with mac
by Justin Cinkelj 02 Apr '16

02 Apr '16

Hi I here and there search for IP address belonging to certain MAC address. Below is a tiny patch to show that info in observium. Data is read from arpwatch datafile (path to datafile is set in config.php): // enable arpwatch $config['arpwatch']['datafile'] = "/var/lib/arpwatch/arp.dat"; And once IP is known, reverse DNS name is informative too. Patch acceptable for inclusion? BR Justin diff --git a/html/ajax/entity_popup.php b/html/ajax/entity_popup.php index 86c2b43..ef2fe18 100644 --- a/html/ajax/entity_popup.php +++ b/html/ajax/entity_popup.php @@ -73,6 +73,25 @@ switch ($vars['entity_type']) } else { echo 'Not Found'; } + // search for mac in arpwatch datafile + $aw_on = array_key_exists("arpwatch", $config) && + array_key_exists("datafile", $config["arpwatch"]) && + $config["arpwatch"]["datafile"]; + if ($aw_on) { + // lines are formated: mac ip timestamp name + $aw_file = "/var/lib/arpwatch/arp.dat"; + $aw_data = file_get_contents($aw_file); + $aw_data = explode("\n", $aw_data); + for ($line = 0; $line < count($aw_data); $line++) { + if (strpos($aw_data[$line], $vars['entity_id']) !== false) { + list($aw_mac, $aw_ip, $aw_timestamp, $aw_name) = preg_split("/\s+/", $aw_data[$line]); + echo "<br>arpwatch: " . $aw_ip . " " . $aw_name; + // with IP, rev DNS can be tried + $rdns_name = gethostbyaddr($aw_ip ); + echo "<br>rDNS: " . $rdns_name; + } + } + } } else { echo 'Not correct MAC address'; }

5 12

Raspberry Pi Chrome Kiosk
by Simon Smith 01 Apr '16

01 Apr '16

Hi All I just thought I would show off my Raspberry Pi Chrome Kiosk running Observium, monitoring one of our sites main Internet LAN port :D Raspberry Pi 3 being powered by USB off the TV, HDMI to TV and using built in WiFi, so no network leads! :D Regards Simon

2 3

Observium Error
by Sathish.I 31 Mar '16

31 Mar '16

Hello All, When I am logging to Observium via GUI, I am receiving below error. Please let us what is the error exactly?. MySQL Error 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) -Sathish

2 1

Alerts based on a sudden increase of packets per second
by Stephen Fulton 31 Mar '16

31 Mar '16

Hi all, Is there a way to generate an alert when an interface has a significant increase of packets per second, compared to a previous recorded amount? Is there a way to compare deltas? I'm looking to identify interfaces which may be experience a DoS situation. Thanks, -- Stephen

2 2

LDAP/AD Groups
by Spencer Ryan 31 Mar '16

31 Mar '16

Hey Tom, Can you log into an AD setup you have with /debug/ and tell me what this says? LDAP[UserID][XXXXX] In our environment I had to patch ldap.inc.php to get the UID to map properly (and thus apply groups). Before that the UserID would always be -1. I'm trying to figure out if I had some bad config.php settings, or if it's actually broken and I can send you guys the patch I wrote. Thanks! *Spencer Ryan* | Senior Systems Administrator | sryan(a)arbor.net *Arbor Networks* +1.734.794.5033 (d) | +1.734.846.2053 (m) www.arbornetworks.com

1 0

Solaris Filesystems not being read correctly
by Dano, Leo 31 Mar '16

31 Mar '16

Good morning all, Linux nodes read fine, but Solaris is not reading the partition size correctly. Example: / partition going directly onto the Solaris host shows is to be 5.7TB Observium shows it as much smaller 1.78tb Any thoughts? Or is Solaris not fully supported? Thanks, ----------------------- Leo Dano

3 2

Device Offline Alerts missing graph
by Jason Macri 30 Mar '16

30 Mar '16

Our alerts for device offline are showing the following, any tips on how to get the graph to display correctly? [cid:image005.jpg@01D18A5F.F2256C00] FYI we are running Observium 0.16.2.7635 (29th February 2016) Regards, Jason Macri Onsite Support Engineer How am I doing? Please click here<http://www.techpath.com.au/contact-us/feedback/> to rate my work. [cid:image001.png@01D18A5F.66443F90]<http://www.techpath.com.au/> P 1300 033 300 F 07 3809 3999 E jason(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 3

Going from Community to Subscription Edition?
by Dano, Leo 30 Mar '16

30 Mar '16

Hello all, Is the process painless in going from the Community Edition to the Subscription Version? Thanks, ----------------------- Leo Dano

4 5

Scheduled Maintenance problem
by Cody Cook 30 Mar '16

30 Mar '16

0.16.3.7712 When I am trying to schedule maintenance, I select the dates. On appy, it sets the dates to 1969. Before [image: Inline image 1] After [image: Inline image 2]

2 1

db.log errors
by Jason Lixfeld 30 Mar '16

30 Mar '16

Hi! Running 7229 on Debian 8.0, MySQL 5.5.43 I was seeing these errors filling up db.log: [2015/12/24 08:10:19 -0500] poller.php(32567): Failed dbQuery (#1062 - Duplicate entry '251-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('251','','3304742660','65536','input') [2015/12/24 08:10:19 -0500] poller.php(32567): Failed dbQuery (#1062 - Duplicate entry '251-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('251','','3304742676','65536','input') [2015/12/24 08:10:19 -0500] poller.php(1068): Failed dbQuery (#1062 - Duplicate entry '210-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('210','','3304742660','65536','input') [2015/12/24 08:10:19 -0500] poller.php(1068): Failed dbQuery (#1062 - Duplicate entry '210-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('210','','3304742676','65536','input') [2015/12/24 08:10:20 -0500] poller.php(1615): Failed dbQuery (#1062 - Duplicate entry '285-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('285','','3304742660','65536','input') [2015/12/24 08:10:20 -0500] poller.php(1615): Failed dbQuery (#1062 - Duplicate entry '285-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('285','','3304742676','65536','input') [2015/12/24 08:10:21 -0500] poller.php(26382): Failed dbQuery (#1062 - Duplicate entry '245-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('245','','3304742660','65536','input') [2015/12/24 08:10:21 -0500] poller.php(26382): Failed dbQuery (#1062 - Duplicate entry '245-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('245','','3304742676','65536','input') [2015/12/24 08:10:22 -0500] poller.php(26381): Failed dbQuery (#1062 - Duplicate entry '246-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('246','','3304742660','65536','input') [2015/12/24 08:10:22 -0500] poller.php(26381): Failed dbQuery (#1062 - Duplicate entry '246-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('246','','3304742676','65536','input’) After upgrading to 7338, running ./discovery.php -u, seeing the DB upgrades happen without incident, I’m still seeing the same: root@monitor:/opt/observium# svn update Updating '.’: … stuff … … things … Updated to revision 7338. root@monitor:/opt/observium# ./discovery.php -u ___ _ _ / _ \ | |__ ___ ___ _ __ __ __(_) _ _ _ __ ___ | | | || '_ \ / __| / _ \| '__|\ \ / /| || | | || '_ ` _ \ | |_| || |_) |\__ \| __/| | \ V / | || |_| || | | | | | \___/ |_.__/ |___/ \___||_| \_/ |_| \__,_||_| |_| |_| Observium Professional 0.15.12.7338 http://www.observium.org -- Updating database/file schema 252 -> 253 ... (db) done. 253 -> 254 ... (db) done. 254 -> 255 ... (db) done. -- Done. root@monitor:/opt/observium# [2015/12/24 08:20:06 -0500] poller.php(13878): Failed dbQuery (#1062 - Duplicate entry '209-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('209','','3304742660','65536','input') [2015/12/24 08:20:06 -0500] poller.php(13878): Failed dbQuery (#1062 - Duplicate entry '209-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('209','','3304742676','65536','input') [2015/12/24 08:20:06 -0500] poller.php(13870): Failed dbQuery (#1062 - Duplicate entry '228-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('228','','3304742660','65536','input') [2015/12/24 08:20:06 -0500] poller.php(13870): Failed dbQuery (#1062 - Duplicate entry '228-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('228','','3304742676','65536','input') [2015/12/24 08:20:06 -0500] poller.php(13881): Failed dbQuery (#1062 - Duplicate entry '243-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('243','','3304742660','65536','input') [2015/12/24 08:20:06 -0500] poller.php(13881): Failed dbQuery (#1062 - Duplicate entry '243-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('243','','3304742676','65536','input') [2015/12/24 08:20:06 -0500] poller.php(13880): Failed dbQuery (#1062 - Duplicate entry '203-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('203','','3304742660','65536','input') [2015/12/24 08:20:06 -0500] poller.php(13880): Failed dbQuery (#1062 - Duplicate entry '203-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('203','','3304742676','65536','input') [2015/12/24 08:20:06 -0500] poller.php(13879): Failed dbQuery (#1062 - Duplicate entry '276-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('276','','3304742660','65536','input') [2015/12/24 08:20:06 -0500] poller.php(13879): Failed dbQuery (#1062 - Duplicate entry '276-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('276','','3304742676','65536','input') [2015/12/24 08:20:07 -0500] poller.php(13890): Failed dbQuery (#1062 - Duplicate entry '250-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('250','','3304742660','65536','input') [2015/12/24 08:20:07 -0500] poller.php(13890): Failed dbQuery (#1062 - Duplicate entry '250-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('250','','3304742676','65536','input') [2015/12/24 08:20:07 -0500] poller.php(13895): Failed dbQuery (#1062 - Duplicate entry '241-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('241','','3304742660','65536','input') [2015/12/24 08:20:07 -0500] poller.php(13895): Failed dbQuery (#1062 - Duplicate entry '241-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('241','','3304742676','65536','input') [2015/12/24 08:20:10 -0500] poller.php(13860): Failed dbQuery (#1062 - Duplicate entry '229-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('229','','3304742660','65536','input') [2015/12/24 08:20:10 -0500] poller.php(13860): Failed dbQuery (#1062 - Duplicate entry '229-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('229','','3304742676','65536','input') [2015/12/24 08:20:10 -0500] poller.php(13883): Failed dbQuery (#1062 - Duplicate entry '230-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('230','','3304742660','65536','input') [2015/12/24 08:20:10 -0500] poller.php(13883): Failed dbQuery (#1062 - Duplicate entry '230-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('230','','3304742676','65536','input') [2015/12/24 08:20:10 -0500] poller.php(13864): Failed dbQuery (#1062 - Duplicate entry '162-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('162','','3304742660','65536','input') [2015/12/24 08:20:10 -0500] poller.php(13864): Failed dbQuery (#1062 - Duplicate entry '162-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('162','','3304742676','65536','input') [2015/12/24 08:20:10 -0500] poller.php(13854): Failed dbQuery (#1062 - Duplicate entry '244-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('244','','3304742660','65536','input') [2015/12/24 08:20:10 -0500] poller.php(13854): Failed dbQuery (#1062 - Duplicate entry '244-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('244','','3304742676','65536','input') [2015/12/24 08:20:11 -0500] poller.php(13834): Failed dbQuery (#1062 - Duplicate entry '184-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('184','','3304742660','65536','input') [2015/12/24 08:20:11 -0500] poller.php(13834): Failed dbQuery (#1062 - Duplicate entry '184-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('184','','3304742676','65536','input') [2015/12/24 08:20:11 -0500] poller.php(13793): Failed dbQuery (#1062 - Duplicate entry '163-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('163','','3304742660','65536','input') [2015/12/24 08:20:11 -0500] poller.php(13793): Failed dbQuery (#1062 - Duplicate entry '163-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('163','','3304742676','65536','input') [2015/12/24 08:20:11 -0500] poller.php(13779): Failed dbQuery (#1062 - Duplicate entry '193-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('193','','3304742660','65536','input') [2015/12/24 08:20:11 -0500] poller.php(13779): Failed dbQuery (#1062 - Duplicate entry '193-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('193','','3304742676','65536','input') [2015/12/24 08:20:11 -0500] poller.php(13771): Failed dbQuery (#1062 - Duplicate entry '239-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('239','','3304742660','65536','input') [2015/12/24 08:20:11 -0500] poller.php(13771): Failed dbQuery (#1062 - Duplicate entry '239-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('239','','3304742676','65536','input') [2015/12/24 08:20:11 -0500] poller.php(13832): Failed dbQuery (#1062 - Duplicate entry '270-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('270','','3304742660','65536','input') [2015/12/24 08:20:11 -0500] poller.php(13832): Failed dbQuery (#1062 - Duplicate entry '270-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('270','','3304742676','65536','input') [2015/12/24 08:20:11 -0500] poller.php(13799): Failed dbQuery (#1062 - Duplicate entry '161-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('161','','3304742660','65536','input') [2015/12/24 08:20:11 -0500] poller.php(13799): Failed dbQuery (#1062 - Duplicate entry '161-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('161','','3304742676','65536','input') [2015/12/24 08:20:11 -0500] poller.php(13756): Failed dbQuery (#1062 - Duplicate entry '204-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('204','','3304742660','65536','input') [2015/12/24 08:20:11 -0500] poller.php(13756): Failed dbQuery (#1062 - Duplicate entry '204-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('204','','3304742676','65536','input') [2015/12/24 08:20:12 -0500] poller.php(13765): Failed dbQuery (#1062 - Duplicate entry '222-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('222','','3304742660','65536','input') [2015/12/24 08:20:12 -0500] poller.php(13765): Failed dbQuery (#1062 - Duplicate entry '222-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('222','','3304742676','65536','input') [2015/12/24 08:20:13 -0500] poller.php(16864): Failed dbQuery (#1062 - Duplicate entry '273-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('273','','3304742660','65536','input') [2015/12/24 08:20:13 -0500] poller.php(16864): Failed dbQuery (#1062 - Duplicate entry '273-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('273','','3304742676','65536','input') [2015/12/24 08:20:13 -0500] poller.php(17012): Failed dbQuery (#1062 - Duplicate entry '281-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('281','','3304742660','65536','input') [2015/12/24 08:20:13 -0500] poller.php(17012): Failed dbQuery (#1062 - Duplicate entry '281-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('281','','3304742676','65536','input') [2015/12/24 08:20:13 -0500] poller.php(17032): Failed dbQuery (#1062 - Duplicate entry '181-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('181','','3304742660','65536','input') [2015/12/24 08:20:13 -0500] poller.php(17032): Failed dbQuery (#1062 - Duplicate entry '181-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('181','','3304742676','65536','input') [2015/12/24 08:20:13 -0500] poller.php(17217): Failed dbQuery (#1062 - Duplicate entry '278-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('278','','3304742660','65536','input') [2015/12/24 08:20:13 -0500] poller.php(17217): Failed dbQuery (#1062 - Duplicate entry '278-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('278','','3304742676','65536','input') [2015/12/24 08:20:13 -0500] poller.php(17345): Failed dbQuery (#1062 - Duplicate entry '211-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('211','','3304742660','65536','input') [2015/12/24 08:20:13 -0500] poller.php(17345): Failed dbQuery (#1062 - Duplicate entry '211-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('211','','3304742676','65536','input') [2015/12/24 08:20:14 -0500] poller.php(13737): Failed dbQuery (#1062 - Duplicate entry '232-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('232','','3304742660','65536','input') [2015/12/24 08:20:14 -0500] poller.php(13737): Failed dbQuery (#1062 - Duplicate entry '232-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('232','','3304742676','65536','input') [2015/12/24 08:20:14 -0500] poller.php(13735): Failed dbQuery (#1062 - Duplicate entry '226-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('226','','3304742660','65536','input') [2015/12/24 08:20:14 -0500] poller.php(13735): Failed dbQuery (#1062 - Duplicate entry '226-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('226','','3304742676','65536','input') [2015/12/24 08:20:18 -0500] poller.php(19456): Failed dbQuery (#1062 - Duplicate entry '210-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('210','','3304742660','65536','input') [2015/12/24 08:20:18 -0500] poller.php(19456): Failed dbQuery (#1062 - Duplicate entry '210-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('210','','3304742676','65536','input') [2015/12/24 08:20:18 -0500] poller.php(19111): Failed dbQuery (#1062 - Duplicate entry '238-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('238','','3304742660','65536','input') [2015/12/24 08:20:18 -0500] poller.php(19111): Failed dbQuery (#1062 - Duplicate entry '238-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('238','','3304742676','65536','input') [2015/12/24 08:20:18 -0500] poller.php(19948): Failed dbQuery (#1062 - Duplicate entry '285-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('285','','3304742660','65536','input') [2015/12/24 08:20:18 -0500] poller.php(19948): Failed dbQuery (#1062 - Duplicate entry '285-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('285','','3304742676','65536','input') [2015/12/24 08:20:18 -0500] poller.php(20215): Failed dbQuery (#1062 - Duplicate entry '279-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('279','','3304742660','65536','input') [2015/12/24 08:20:18 -0500] poller.php(20215): Failed dbQuery (#1062 - Duplicate entry '279-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('279','','3304742676','65536','input') [2015/12/24 08:20:18 -0500] poller.php(20315): Failed dbQuery (#1062 - Duplicate entry '242-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('242','','3304742660','65536','input') [2015/12/24 08:20:18 -0500] poller.php(20315): Failed dbQuery (#1062 - Duplicate entry '242-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('242','','3304742676','65536','input') [2015/12/24 08:20:18 -0500] poller.php(20298): Failed dbQuery (#1062 - Duplicate entry '284-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('284','','3304742660','65536','input') [2015/12/24 08:20:18 -0500] poller.php(20298): Failed dbQuery (#1062 - Duplicate entry '284-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('284','','3304742676','65536','input') [2015/12/24 08:20:18 -0500] poller.php(19663): Failed dbQuery (#1062 - Duplicate entry '172-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('172','','3304742660','65536','input') [2015/12/24 08:20:18 -0500] poller.php(19663): Failed dbQuery (#1062 - Duplicate entry '172-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('172','','3304742676','65536','input') [2015/12/24 08:20:19 -0500] poller.php(19825): Failed dbQuery (#1062 - Duplicate entry '277-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('277','','3304742660','65536','input') [2015/12/24 08:20:19 -0500] poller.php(19825): Failed dbQuery (#1062 - Duplicate entry '277-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('277','','3304742676','65536','input') [2015/12/24 08:20:19 -0500] poller.php(20333): Failed dbQuery (#1062 - Duplicate entry '251-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('251','','3304742660','65536','input') [2015/12/24 08:20:19 -0500] poller.php(20333): Failed dbQuery (#1062 - Duplicate entry '251-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('251','','3304742676','65536','input') [2015/12/24 08:20:19 -0500] poller.php(20258): Failed dbQuery (#1062 - Duplicate entry '283-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('283','','3304742660','65536','input') [2015/12/24 08:20:19 -0500] poller.php(20258): Failed dbQuery (#1062 - Duplicate entry '283-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('283','','3304742676','65536','input') [2015/12/24 08:20:20 -0500] poller.php(13725): Failed dbQuery (#1062 - Duplicate entry '245-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('245','','3304742660','65536','input') [2015/12/24 08:20:20 -0500] poller.php(13725): Failed dbQuery (#1062 - Duplicate entry '245-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('245','','3304742676','65536','input') [2015/12/24 08:20:21 -0500] poller.php(13719): Failed dbQuery (#1062 - Duplicate entry '246-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('246','','3304742660','65536','input') [2015/12/24 08:20:21 -0500] poller.php(13719): Failed dbQuery (#1062 - Duplicate entry '246-0-2147483647-65536' for key 'device_id'), Query: INSERT INTO `ports_cbqos` (`device_id`,`port_id`,`policy_index`,`object_index`,`direction`) VALUES ('246','','3304742676','65536','input’) A previous post regarding DB errors requested column output from the DB for the affected table. I trust this might be useful in this case as well? mysql> show columns from ports_cbqos; +---------------------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------------+-------------+------+-----+---------+----------------+ | cbqos_id | int(11) | NO | PRI | NULL | auto_increment | | device_id | int(11) | NO | MUL | NULL | | | port_id | int(11) | NO | MUL | NULL | | | direction | varchar(16) | NO | | NULL | | | PrePolicyPkt | int(11) | NO | | NULL | | | PrePolicyPkt_rate | int(11) | NO | | NULL | | | PrePolicyByte | int(11) | NO | | NULL | | | PrePolicyByte_rate | int(11) | NO | | NULL | | | PostPolicyByte | int(11) | NO | | NULL | | | PostPolicyByte_rate | int(11) | NO | | NULL | | | DropPkt | int(11) | NO | | NULL | | | DropPkt_rate | int(11) | NO | | NULL | | | DropByte | int(11) | NO | | NULL | | | DropByte_rate | int(11) | NO | | NULL | | | NoBufDropPkt | int(11) | NO | | NULL | | | NoBufDropPkt_rate | int(11) | NO | | NULL | | | cbqos_lastpolled | int(11) | NO | | NULL | | | policy_index | int(11) | NO | | NULL | | | object_index | int(11) | NO | | NULL | | | policy_name | varchar(64) | NO | | NULL | | | object_name | varchar(64) | NO | | NULL | | +---------------------+-------------+------+-----+---------+----------------+ 21 rows in set (0.00 sec) mysql> Any ideas? Thanks in advance!

2 3

Transfer Historical data to another instance of Observium?
by Dano, Leo 30 Mar '16

30 Mar '16

Good morning all, I was wondering if there was a way to move some historical data from one Observium to another? Or is there mysql issues with ID's, etc? Thanks, ----------------------- Leo Dano

5 8

Telegram Bot Alerter
by Cody Cook 29 Mar '16

29 Mar '16

Hi, Noticed an alert checker for Telegram bots. Just recently got into Telegram. Is there any information on this? I setup my username (both with and without @) and put in the token from BotFather in the config and used test_alert.php -a 9 and it says it sends an alert. Do I need something to customize my bot to make it send messages? Thanks

4 13

Guest User Access
by Cameron Murray 29 Mar '16

29 Mar '16

Morning Everyone, Is it possible to setup a user with limited access to a specific customer group? Eg. IBM User can only see IBM devices? 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@01D18A56.403FF950]<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.

1 0

syslog issue with Palo Alto Firewalls ?
by Bradley, Jim 29 Mar '16

29 Mar '16

Hey, So I’ve got a new installation of Observium pro up and running with 160+ devices, and everything is working as expected, with a minor exception: Syslog messages from Palo Alto boxes arrive successfully at the Centos 7 box, but are not added to the devices logging/syslog page in Observium. So far syslog messages for all other vendors are correctly added to the devices. Is there anything you can advise me to do to further diagnose whats wrong? or is there a problem with the format of Palo messages ? This is not critical to me, but i have 6 PA’s all of which are in the audit, and having the syslog of all the config changes right in the web gui along with the events and stats is a nice simple way for the auditors to get the warm and fuzzys about me not just making it all up.. it’d be great to have. I temporarily disabled the forward of syslog to Observium by commenting out “$IncludeConfig /etc/rsyslog.d/*.conf” and restarting rsyslog, at which point the below example messages successfully drop into /var/log/messages. Mar 28 16:10:42 Location-PA-200.usa.neopost.com 1,2016/03/28 16:10:42,001606058055,SYSTEM,routing,0,2016/03/28 16:10:42,,routed-config-p2-success,,0,0,general,informational,Route daemon configuration load phase-2 succeeded.,15787,0x0,0,0,0,0,,Location-PA-200 Mar 28 16:10:42 Location-PA-200.usa.neopost.com 1,2016/03/28 16:10:42,001606058055,SYSTEM,vpn,0,2016/03/28 16:10:42,,ike-config-p2-success,,0,0,general,informational,IKE daemon configuration load phase-2 succeeded.,15788,0x0,0,0,0,0,,Location-PA-200 Mar 28 16:10:42 Location-PA-200.usa.neopost.com 1,2016/03/28 16:10:42,001606058055,SYSTEM,ras,0,2016/03/28 16:10:42,,rasmgr-config-p2-success,,0,0,general,informational,RASMGR daemon configuration load phase-2 succeeded.,15789,0x0,0,0,0,0,,Location-PA-200 Mar 28 16:10:42 Location-PA-200.usa.neopost.com 1,2016/03/28 16:10:42,001606058055,SYSTEM,satd,0,2016/03/28 16:10:42,,satd-config-p2-success,,0,0,general,informational,SATD daemon configuration load phase-2 succeeded.,15790,0x0,0,0,0,0,,Location-PA-200 Mar 28 16:10:42 Location-PA-200.usa.neopost.com 1,2016/03/28 16:10:42,001606058055,SYSTEM,sslmgr,0,2016/03/28 16:10:42,,sslmgr-config-p2-success,,0,0,general,informational,SSLMGR daemon configuration load phase-2 succeeded.,15791,0x0,0,0,0,0,,Location-PA-200 The only caveat i can think of, is that i don’t have all my devices names in DNS, instead i cheated and built them in /etc/hosts. This seems to work for everything else, so I’m not sure thats whats causing this. My hunch is that the Observium syslog parser doesn’t like the string from the Palo’s, is there a way to see logs for that (without breaking everything else) ? [root@observium ~]# ping Location-PA-200.usa.neopost.com PING Location-PA-200.usa.neopost.com (10.10.10.2) 56(84) bytes of data. 64 bytes from Location-PA-200.usa.neopost.com (10.10.10.2): icmp_seq=1 ttl=52 time=44.3 ms 64 bytes from Location-PA-200.usa.neopost.com (10.10.10.2): icmp_seq=2 ttl=52 time=44.6 ms ^C --- Location-PA-200.usa.neopost.com ping statistics --- 2 packets transmitted, 2 received, 0% packet loss, time 1001ms rtt min/avg/max/mdev = 44.373/44.532/44.691/0.159 ms [root@observium ~]# Appreciate your help, Thanks -- Jim Bradley IT Network Engineer and Security Officer Phone: +1 203 301 3749<tel://+1%20203%20301%203749> Mobile: +1 203 308 3047<tel://+1%20203%20308%203047> Neopost USA - 478 Wheelers Farms Rd - 06461 Milford CT - United States www.neopost.com<http://www.neopost.com/>

1 0