- observium - lists.observium.org

Re: [Observium] Everything is DOWN after svn UP :-)
by Richard Müller 08 Dec '15

08 Dec '15

Hy *, I also experienced this issue some minutes ago. My reason was that "someone" (svn?) created a .index file in the MIB Directory, which caused snmpwalk to die: root@horstname:/opt/observium# /usr/bin/snmpget -v2c -c '***' -Pu -OQUst -m SNMPv2-MIB -M /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp 'udp':'horstname2':'161' sysObjectID.0 sysUpTime.0 add_mibdir: strings scanned in from /opt/observium/mibs/rfc/.index are too large. count = 136 MIB search path: /opt/observium/mibs/rfc:/opt/observium/mibs/net-snmp Cannot find module (SNMPv2-MIB): At line 0 in (none) sysObjectID.0: Unknown Object Identifier (Sub-id not found: (top) -> sysObjectID) sysUpTime.0: Unknown Object Identifier (Sub-id not found: (top) -> sysUpTime) removing the /opt/observium/mibs/rfc/.index file fixed the glitch - does anybody know whats the purpose of these files and where do they come from? Thanks Richard Message: 2 Date: Fri, 4 Dec 2015 12:05:24 +0100 From: Gabriel Zamorski <gabriel.zamorski(a)domeny.pl> To: Observium Network Observation System <observium(a)observium.org> Subject: Re: [Observium] Everything is DOWN after svn UP :-) Message-ID: <5CBBE15E-ED0C-4B8C-B606-E5C5B73DE9DF(a)domeny.pl> Content-Type: text/plain; charset="utf-8" Debian 7.9, libsnmp-base 5.4.3~dfsg-2.8+deb7u1, libsnmp15 5.4.3~dfsg-2.8+deb7u1, php5-snmp 5.4.45-0+deb7u2, snmp 5.4.3~dfsg-2.8+deb7u1. It was updated from 7224 to 7226, then I did rollback. It is strange, today I updated to the latest version 7227 with no problem (without alerts). G. > Wiadomo?? napisana przez Adam Armstrong <adama(a)memetic.org> w dniu 04.12.2015, o godz. 08:54: > > Given that it's virtually impossible for this to be an actual bug in the SVN (hundreds of users would be complaining), it might help to have some additional information about your installation. > > Do you know what version you updated from? What are you running it on? What version of net-snmp? > > adam. >> On 04/12/2015 07:53:05, Gabriel Zamorski <gabriel.zamorski(a)domeny.pl> wrote: >> >> Hello, >> >> Yesterday after upgrading observium (like everyday morning) we got hundreds of alerts. It seems that observium could not connect to any machine using SNMP - I checked this from console via ./poller.php and every server was unreachable, so I had to rollback to the earlier revision. Do you know anything about this? >> >> Regards, >> G. >> >> >> -- 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 *** Bitte liken Sie uns auf Facebook: facebook.com/teamix *** _______________________________________________ >> observium mailing list >> observium(a)observium.org >> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium > _______________________________________________ > observium mailing list > observium(a)observium.org > http://postman.memetic.org/cgi-bin/mailman/listinfo/observium -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://postman.memetic.org/pipermail/observium/attachments/20151204/cc4b310…> -------------- next part -------------- A non-text attachment was scrubbed... Name: smime.p7s Type: application/pkcs7-signature Size: 3587 bytes Desc: not available URL: <http://postman.memetic.org/pipermail/observium/attachments/20151204/cc4b310…> ------------------------------ Message: 3 Date: Fri, 04 Dec 2015 11:58:55 +0000 From: Adam Armstrong <adama(a)observium.org> To: Observium Network Observation System <observium(a)observium.org> Subject: Re: [Observium] Everything is DOWN after svn UP :-) Message-ID: <1516cdbfc18.2779.11b54b3dd25b712395dab9818c67596f(a)observium.org> Content-Type: text/plain; charset="utf-8"; Format="flowed" I think this is perhaps, again, the pesky svn broken file issue. This problem seems to have gotten significantly worse since the svn database version changes. Adam. Sent with AquaMail for Android http://www.aqua-mail.com On 4 December 2015 11:05:41 am Gabriel Zamorski <gabriel.zamorski(a)domeny.pl> wrote: > Debian 7.9, libsnmp-base 5.4.3~dfsg-2.8+deb7u1, libsnmp15 > 5.4.3~dfsg-2.8+deb7u1, php5-snmp 5.4.45-0+deb7u2, snmp > 5.4.3~dfsg-2.8+deb7u1. It was updated from 7224 to 7226, then I did > rollback. It is strange, today I updated to the latest version 7227 > with no problem (without alerts). > > G. > > > > >> Wiadomo?? napisana przez Adam Armstrong <adama(a)memetic.org> w dniu >> 04.12.2015, o godz. 08:54: >> >> Given that it's virtually impossible for this to be an actual bug in >> the SVN (hundreds of users would be complaining), it might help to >> have some additional information about your installation. >> >> Do you know what version you updated from? What are you running it >> on? What version of net-snmp? >> >> adam. >>> On 04/12/2015 07:53:05, Gabriel Zamorski <gabriel.zamorski(a)domeny.pl> wrote: >>> >>> Hello, >>> >>> Yesterday after upgrading observium (like everyday morning) we got >>> hundreds of alerts. It seems that observium could not connect to any >>> machine using SNMP - I checked this from console via ./poller.php >>> and every server was unreachable, so I had to rollback to the >>> earlier revision. Do you know anything about this? >>> >>> Regards, >>> G. >>> >>> >>> _______________________________________________ >>> observium mailing list >>> observium(a)observium.org >>> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium >> _______________________________________________ >> observium mailing list >> observium(a)observium.org >> http://postman.memetic.org/cgi-bin/mailman/listinfo/observium > > > > > ---------- > _______________________________________________ > observium mailing list > observium(a)observium.org > http://postman.memetic.org/cgi-bin/mailman/listinfo/observium > -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://postman.memetic.org/pipermail/observium/attachments/20151204/661784e…>

3 2

Minor documentation typo
by Roland Hill 08 Dec '15

08 Dec '15

Hi team, There is a minor typo on this page: http://www.observium.org/docs/unix_agent/ Specifically this, scp /opt/observium/scripts/observium_agent_xinetd user@your_server:/etc/xinet.d/observium_agent_xinetd Note that /etc/xinet.d should be /etc/xinetd.d Very minor, but thought I'd let you know about it. -- Regards, Roland PGP Key 0xDA39319B = BCF0 1214 BAE9 5A3D 46FC 21A6 360D 9398 DA39 319B

2 1

Regex in an entity match not working right
by Spencer Ryan 07 Dec '15

07 Dec '15

Hi All, I'm trying to match ports with the name port-channel1 through 19, and the "match" keyword isn't doing what I want. What I think is correct is "ifName match port-channel([1-9]|1[0-9])" However that gives me 0 matches. If I change it to something like ifName match port-channel*" I get all the port channels, so it's matching the device properly, but for this alert checker I just need port channels 1-19. Any ideas? I've tried a bunch of combinations and nothing seems to work right. Even "port-channel." doesn't match the additional character. *Spencer Ryan* | Senior Systems Administrator | sryan(a)arbor.net *Arbor Networks* +1.734.794.5033 (d) | +1.734.846.2053 (m) www.arbornetworks.com

3 5

Arista switches environment sensors have stopped working
by Ben Maschke 07 Dec '15

07 Dec '15

Hi guys, after updating to the latest subscriber version all of our checks for environment sensors (Arista switches) have stopped working: [image: Inline images 1] It seems that it has stopped receiving proper sensor data: [image: Inline images 2] Thx -- *Ben Maschke* Senior System Engineer *Tel:* +44 (0) 20 8742 6820 *Shazam* 26-28 Hammersmith Grove, London, W6 7HA Please consider the environment before printing this document Shazam Entertainment Limited is incorporated in England and Wales under company number 3998831 and its registered office is at 26-28 Hammersmith Grove, London W6 7HA.

4 8

toggles and pop ups have stopped working
by observium＠istar.net.nz 06 Dec '15

06 Dec '15

Hello We've recently updated Observium (now 0.15.12.7230) and enabled SSH and the on/off switches are not being shown and the date popups don't work. If I browse to it on http it seems to be fine. I've checked the apache config and it looks identical, any thoughts? Thanks SHANE lE <mailto:shanson@istar.net.nz> shanson(a)istar.net.nz lW <https://istar.net.nz/> istar.net.nz lA PO Box 911507, Victoria St West, Auckland lM +64 21 623 903

2 2

UNIX Agent
by Alex Winder ＠ M5i 05 Dec '15

05 Dec '15

Hi all, I'm currently trying to get the UNIX agent for Observium working with some of our hosts so that we can obtain more data for applications, primarily NGINX. We are now seeing data on the agent execution time graph. We are getting responses from the Observium host to the NGINX host via Telnet, and receiving information about NGINX. We are getting the NGINX status information through Lynx on the localhost. We are using the following configs. /etc/xinetd.d/observium_agent_xinetd service observium_agent { type = UNLISTED port = 36602 socket_type = stream protocol = tcp wait = no user = root server = /usr/bin/observium_agent # configure the IPv[4|6] address(es) of your Observium server here: only_from = [IPs removed] 127.0.0.1 ::1 # Don't be too verbose. Don't log every check. This might be # commented out for debugging. If this option is commented out # the default options will be used for this service. log_on_success = disable = no } /usr/lib/observium_agent/local/nginx !/usr/bin/env python import urllib2 import re data = urllib2.urlopen('http://localhost/nginx-status').read() params = {} for line in data.split("\n"): smallstat = re.match(r"\s?Reading:\s(.*)\sWriting:\s(.*)\sWaiting:\s(.*)$", line) req = re.match(r"\s+(\d+)\s+(\d+)\s+(\d+)", line) if smallstat: params["Reading"] = smallstat.group(1) params["Writing"] = smallstat.group(2) params["Waiting"] = smallstat.group(3) elif req: params["Requests"] = req.group(3) else: pass dataorder = [ "Active", "Reading", "Writing", "Waiting", "Requests" ] print "<<<nginx>>>\n"; for param in dataorder: if param == "Active": Active = int(params["Reading"]) + int(params["Writing"]) + int(params["Waiting"]) print Active else: print params[param] /etc/nginx/sites-automatic/localhost.conf server { listen 80; listen [::]:80; server_name localhost; server_name_in_redirect off; charset utf-8; log_not_found on; access_log /var/log/nginx/localhost_combined-access.log combined buffer=128k flush=5m; error_log /var/log/nginx/localhost_error.log; location / { root /local-storage/localhost/nginx-hosted/public_html; } location /nginx-status { stub_status on; access_log off; allow 127.0.0.1; allow ::1; deny all; } } Any help with this would be much appreciated. Where can we expect to see logs? Any tips on how we can resolve this? Regards, Alex.

3 4

Problems with fresh installation - svn revision 7229 (and stable too)
by Eduardo Schoedler 05 Dec '15

05 Dec '15

# php includes/update/update.php -- Updating database/file schema 000 -> 001 ... (db) done. 001 -> 002 ... (db) done. 002 -> 003 ... (db) done. 003 -> 004 ... (db) done. 004 -> 005 ... (db) done. 005 -> 006 ... (db) done. 006 -> 007 ... (db) done. 007 -> 008 ... (db) done. 008 -> 009 ... (db) done. 009 -> 010 ... (db) done. 010 -> 011 ... (db) done. 011 -> 012 ... (db) done. 012 -> 013 ... (db) done. 013 -> 014 ... (db) done. 014 -> 015 ... (db) done. 015 -> 016 ... (db) done. 016 -> 017 ... (db) done. 017 -> 018 ... (db) done. 018 -> 019 ... (db) done. 019 -> 020 ... (db) done. 020 -> 021 ... (db) done. 021 -> 022 ... (db) done. 022 -> 023 ... (db) done. 023 -> 024 ... (db) done. 024 -> 025 ... (db) done. 025 -> 026 ... (db) done. 026 -> 027 ... (db) done. 027 -> 028 ... (db) done. 028 -> 029 ... (db) done. 029 -> 030 ... (db) done. 030 -> 031 ... (db) done. 031 -> 032 ... (db) done. 032 -> 033 ... (db) done. 033 -> 034 ... (db) done. 034 -> 035 ... (db) done. 035 -> 036 ... (db) done. 036 -> 037 ... (db) done. 037 -> 038 ... (db) done. 038 -> 039 ... (db) done. 039 -> 040 ... (db) done. 040 -> 041 ... (db) done. 041 -> 042 ... (db) done. 042 -> 043 ... (db) done. 043 -> 044 ... (db) done. 044 -> 045 ... (db) done. 045 -> 046 ... (db) done. 046 -> 047 ... (db) done. 047 -> 048 ... (db) done. 048 -> 049 ... (db) done. 049 -> 050 ... (db) done. 050 -> 051 ... (db) done. 051 -> 052 ... (db) done. 052 -> 053 ... (db) done. 053 -> 054 ... (db) done. 054 -> 055 ... (db) done. 055 -> 056 ... (db) done. 056 -> 057 ... (db) done. 057 -> 058 ... (db) done. 058 -> 059 ... (db) done. 059 -> 060 ... (db) done. 060 -> 061 ... (db) done. 061 -> 062 ... (db) done. 062 -> 063 ... (db) done. 063 -> 064 ... (db) done. 064 -> 065 ... (db) done. 065 -> 066 ... (db) done. 066 -> 067 ... (db) done. 067 -> 068 ... (db) done. 068 -> 069 ... (db) done. 069 -> 070 ... (db) done. 070 -> 071 ... (db) done. 071 -> 072 ... (db) done. 072 -> 073 ... (db) done. 073 -> 074 ... (php) Updating netscaler service RRDs 074 -> 075 ... (db) done. 075 -> 076 ... (db) done. 076 -> 077 ... (db) done. 077 -> 078 ... (db) done. 078 -> 079 ... (db) done. 079 -> 080 ... (db) done. 080 -> 081 ... (db) done. 081 -> 082 ... (db) done. 082 -> 083 ... (db) done. 083 -> 084 ... (db) done. 084 -> 085 ... (db) done. 085 -> 086 ... (db) done. 086 -> 087 ... (db) done. 087 -> 088 ... (db) done. 088 -> 089 ... (db) done. 089 -> 090 ... (db) done. 090 -> 091 ... (db) done. 091 -> 092 ... (db) done. 092 -> 093 ... (db) done. 093 -> 094 ... (db) done. 094 -> 095 ... (php) Converting alert serialize() arrays to JSON: 095 -> 096 ... (db) done. 096 -> 097 ... (db) done. 097 -> 098 ... (db) done. 098 -> 099 ... (db) done. 099 -> 100 ... (db) done. 100 -> 101 ... (db) done. 101 -> 102 ... (db) done. 102 -> 103 ... (db) done. 103 -> 104 ... (db) done. 104 -> 105 ... (db) done. 105 -> 106 ... (db) done. 106 -> 107 ... (db) done. 107 -> 108 ... (db) done. 108 -> 109 ... (db) done. 109 -> 110 ... (db) done. 110 -> 111 ... (db) done. 111 -> 112 ... (db) done. 112 -> 113 ... (db) done. 113 -> 114 ... (db) done. 114 -> 115 ... (db) done. 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. 122 -> 123 ... (db) done. 123 -> 124 ... (db) done. 124 -> 125 ... (db) done. 125 -> 126 ... (db) done. 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. 133 -> 134 ... (db) done. 134 -> 135 ... (db) done. 135 -> 136 ... (db) done. 136 -> 137 ... (db) done. 137 -> 138 ... (db) done. 138 -> 139 ... (db) done. 139 -> 140 ... (db) done. 140 -> 141 ... (db) done. 141 -> 142 ... (db) done. 142 -> 143 ... (db) done. 143 -> 144 ... (db) done. 144 -> 145 ... (db) done. 145 -> 146 ... (db) done. 146 -> 147 ... (db) done. 147 -> 148 ... (db) done. 148 -> 149 ... (db) done. 149 -> 150 ... (db) done (2 errors). # svn update && ./discovery.php -h none Updating '.': At revision 7229. ___ _ _ / _ \ | |__ ___ ___ _ __ __ __(_) _ _ _ __ ___ | | | || '_ \ / __| / _ \| '__|\ \ / /| || | | || '_ ` _ \ | |_| || |_) |\__ \| __/| | \ V / | || |_| || | | | | | \___/ |_.__/ |___/ \___||_| \_/ |_| \__,_||_| |_| |_| Observium Professional 0.15.12.7229 http://www.observium.org -- Updating database/file schema 149 -> 150 ... (db) done (10 errors). # cat update-errors.log [2015/12/04 23:06:38 +0000] discovery.php(68419): ====== Schema update 149 -> 150 ============== [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: ALTER TABLE `alert_assoc` CHANGE `device_attributes` `device_attribs` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1054) Unknown column 'device_attributes' in 'alert_assoc' [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: ALTER TABLE `alert_assoc` CHANGE `attributes` `entity_attribs` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1054) Unknown column 'attributes' in 'alert_assoc' [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: ALTER TABLE `ports_perms` ADD `entity_type` VARCHAR( 32 ) NOT NULL AFTER `user_id` ; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1146) Table 'observium.ports_perms' doesn't exist [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: ALTER TABLE `ports_perms` CHANGE `port_id` `entity_id` INT( 11 ) NOT NULL ; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1146) Table 'observium.ports_perms' doesn't exist [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: UPDATE `ports_perms` SET `entity_type` = 'port' WHERE 1; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1146) Table 'observium.ports_perms' doesn't exist [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: RENAME TABLE `ports_perms` TO `entity_permissions` ; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1050) Table 'entity_permissions' already exists [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: INSERT `entity_permissions` (user_id,entity_id,entity_type) SELECT `bill_perms`.`user_id`,`bill_perms`.`bill_id`,'bill' AS `entity_type` FROM `bill_perms`; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1146) Table 'observium.bill_perms' doesn't exist [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: INSERT `entity_permissions` (user_id,entity_id,entity_type) SELECT `devices_perms`.`user_id`,`devices_perms`.`device_id`, 'device' AS `entity_type` FROM `devices_perms`; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1146) Table 'observium.devices_perms' doesn't exist [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: DROP TABLE `bill_perms`; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1051) Unknown table 'observium.bill_perms' [2015/12/04 23:06:38 +0000] discovery.php(68419): Query: DROP TABLE `devices_perms`; [2015/12/04 23:06:38 +0000] discovery.php(68419): Error: (1051) Unknown table 'observium.devices_perms' # cat db.log [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1146 - Table 'observium.observium_attribs' doesn't exist), Query: SELECT `attrib_value` FROM `observium_attribs` WHERE `attrib_type` = 'dbSchema'; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1054 - Unknown column 'device_attributes' in 'alert_assoc'), Query: ALTER TABLE `alert_assoc` CHANGE `device_attributes` `device_attribs` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1054 - Unknown column 'attributes' in 'alert_assoc'), Query: ALTER TABLE `alert_assoc` CHANGE `attributes` `entity_attribs` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1146 - Table 'observium.ports_perms' doesn't exist), Query: ALTER TABLE `ports_perms` ADD `entity_type` VARCHAR( 32 ) NOT NULL AFTER `user_id` ; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1146 - Table 'observium.ports_perms' doesn't exist), Query: ALTER TABLE `ports_perms` CHANGE `port_id` `entity_id` INT( 11 ) NOT NULL ; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1146 - Table 'observium.ports_perms' doesn't exist), Query: UPDATE `ports_perms` SET `entity_type` = 'port' WHERE 1; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1050 - Table 'entity_permissions' already exists), Query: RENAME TABLE `ports_perms` TO `entity_permissions` ; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1146 - Table 'observium.bill_perms' doesn't exist), Query: INSERT `entity_permissions` (user_id,entity_id,entity_type) SELECT `bill_perms`.`user_id`,`bill_perms`.`bill_id`,'bill' AS `entity_type` FROM `bill_perms`; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1146 - Table 'observium.devices_perms' doesn't exist), Query: INSERT `entity_permissions` (user_id,entity_id,entity_type) SELECT `devices_perms`.`user_id`,`devices_perms`.`device_id`, 'device' AS `entity_type` FROM `devices_perms`; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1051 - Unknown table 'observium.bill_perms'), Query: DROP TABLE `bill_perms`; [2015/12/04 23:06:38 +0000] discovery.php(68419): Failed dbQuery (#1051 - Unknown table 'observium.devices_perms'), Query: DROP TABLE `devices_perms`; -- Eduardo Schoedler

4 4

monitor tmpfs storage
by Simon Smith 04 Dec '15

04 Dec '15

Hi All, just moved our RRDs to tmpfs storage, and WOW I noticed a speed difference, not only in the graphs, but also in the IO load should of looked at http://observium.org/docs/persistent_ramdisk/ in the past DOH! however i’ve just noticed the observium isn’t showing it as a storage mount? can observium monitor actually monitor it at all ? also I’ve set my limit at 10GB as the server has 12GB of RAM, and the RRD folder is currently at 6.8GB bit of a stupid question but what happens if I’m close to the limit? as i knackered? more RAM server? regards Simon - Hestor Ltd

3 3

Update db schema error
by Tomasz Karczewski 04 Dec '15

04 Dec '15

I wanted to update db-schema but I got this error, [2015/12/04 13:14:32 +0100] discovery.php(2635): ====== Schema update 251 -> 252 ============== [2015/12/04 13:14:32 +0100] discovery.php(2635): Query: ALTER TABLE `eventlog` CHANGE `timestamp` `timestamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP; [2015/12/04 13:14:32 +0100] discovery.php(2635): Error: (1114) The table '#sql-ae4_bf3697' is full Tomasz Karczewski Administrator Sieci olman tkarczewski(a)man.olsztyn.pl http://www.man.olsztyn.pl http://www.uwm.edu.pl tel. (89) 523 45 55 fax. (89) 523 43 47 Ośrodek Eksploatacji i Zarządzania Miejską Siecią Komputerową OLMAN w Olsztynie Uniwersytet Warmińsko-Mazurski w Olsztynie

3 2

Alert Threshold for CBQoS drops
by Robert Williams 04 Dec '15

04 Dec '15

Hi, Is it possible to have alert elements/metrics which use data collected from CBQoS, like drops for example? Reason for request - we would like to get alerting for certain types of port (CORE for example) where QoS is performing drops. Currently (in another system) we poll a global statistic which gives us the 'total' number of drops per chassis or LC, but this does nothing more than point towards a chassis or line-card. A human then have to pick their way through the CBQoS stats to try to see where it was (if it was big), which very time consumptive. The statistics and framework all appear to be in place within Observium, just need to know if there are some metric conditions which can use CBQoS as a trigger, like ifCBQoSDrops_rate > 10 for example? So, is this already possible? Or should I make a feature request? Cheers all! Robert Williams Custodian Data Centre Email: Robert(a)CustodianDC.com http://www.CustodianDC.com

2 2