Hmm. What does your eventlog table look like?
I should have just killed the table and started again! :D
adam. On 03/02/2015 23:17:14, Simon Smith simonsmith5521@gmail.com wrote: No luck adam :(
Error Code: 1060. Duplicate column name 'severity'
and ive also come across this in update-errors.log
[2015/02/01 03:59:18 +0000] discovery.php(554): ====== Schema update 179 -> 180 ============== [2015/02/01 03:59:18 +0000] discovery.php(554): Query: ALTER TABLE `eventlog` ADD `severity` TINYINT NOT NULL DEFAULT '6' AFTER `entity_id`; [2015/02/01 03:59:18 +0000] discovery.php(554): Error: Unknown column 'entity_id' in 'eventlog' [2015/02/01 03:59:18 +0000] discovery.php(554): Query: UPDATE `eventlog` SET `severity` = 4 WHERE `message` LIKE '%above threshold%' [2015/02/01 03:59:18 +0000] discovery.php(554): Error: Unknown column 'severity' in 'field list' [2015/02/01 03:59:18 +0000] discovery.php(554): Query: UPDATE `eventlog` SET `severity` = 4 WHERE `message` LIKE '%under threshold%' [2015/02/01 03:59:18 +0000] discovery.php(554): Error: Unknown column 'severity' in 'field list' [2015/02/01 12:59:03 +0000] discovery.php(22292): ====== Schema update 181 -> 182 ============== [2015/02/01 12:59:03 +0000] discovery.php(22292): Query: UPDATE `eventlog` SET `severity` = 5 WHERE `message` REGEXP ' [.(.]by (user|cron|console)'; [2015/02/01 12:59:03 +0000] discovery.php(22292): Error: Unknown column 'severity' in 'field list' [2015/02/01 12:59:03 +0000] discovery.php(22292): Query: UPDATE `eventlog` SET `severity` = 3 WHERE `message` LIKE '%Device status changed to%'; [2015/02/01 12:59:03 +0000] discovery.php(22292): Error: Unknown column 'severity' in 'field list' [2015/02/01 12:59:03 +0000] discovery.php(22292): Query: UPDATE `eventlog` SET `severity` = 4 WHERE `message` LIKE '%probably the device was replaced%'; [2015/02/01 12:59:03 +0000] discovery.php(22292): Error: Unknown column 'severity' in 'field list' [2015/02/02 12:59:03 +0000] discovery.php(14299): ====== Schema update 182 -> 183 ============== [2015/02/02 12:59:03 +0000] discovery.php(14299): Query: UPDATE `eventlog` SET `severity` = 4 WHERE `entity_type` IN ('bgp_peer', 'sensor') AND `message` REGEXP ' (Up|Down|Alarm): '; [2015/02/02 12:59:03 +0000] discovery.php(14299): Error: Unknown column 'severity' in 'field list'
regards
Simon
On 3 Feb 2015, at 5:12 pm, Adam Armstrong <adama@memetic.org [mailto:adama@memetic.org]> wrote:
Seems you updated when there was a sql bug present.
Run this against your database :
ALTER TABLE `eventlog` ADD `severity` TINYINT NOT NULL DEFAULT '6' AFTER `entity_id`; UPDATE `eventlog` SET `severity` = 4 WHERE `message` REGEXP '(above|under) threshold'; UPDATE `eventlog` SET `severity` = 5 WHERE `message` REGEXP ' [.(.]by (user|cron|console)'; UPDATE `eventlog` SET `severity` = 3 WHERE `message` LIKE 'Device status changed to%'; UPDATE `eventlog` SET `severity` = 4 WHERE `message` LIKE '%probably the device was replaced%'; UPDATE `eventlog` SET `severity` = 4 WHERE `message` LIKE 'OS changed%'; UPDATE `eventlog` SET `severity` = 4 WHERE `message` LIKE 'Device rebooted%'; UPDATE `eventlog` SET `severity` = 4 WHERE `entity_type` IN ('bgp_peer', 'sensor') AND `message` REGEXP ' (Up|Down|Alarm): ';
And it should fix it.
adam. On 03/02/2015 22:52:58, Simon Smith <simonsmith5521@gmail.com [mailto:simonsmith5521@gmail.com]> wrote: Hi All
Ive had no Messages appear in my Event Logs panel for the past 2 days?
where would be the best place to start checking if ive got a code problem or maybe an SVN update has goofed it up?
Only reason I ask this is because we have had a few devices today go on and off alot and there are no entries in the Event Log Panel of them going off and on
but yet ive been getting the email alerts?
Regards
Simon
_______________________________________________ observium mailing list observium@observium.org [mailto:observium@observium.org] http://postman.memetic.org/cgi-bin/mailman/listinfo/observium [http://postman.memetic.org/cgi-bin/mailman/listinfo/observium]
_______________________________________________ observium mailing list observium@observium.org [mailto:observium@observium.org] http://postman.memetic.org/cgi-bin/mailman/listinfo/observium