I've moved all of these statements to a new sql update file, so they will fix issues people who were hit by the initial issue.
People without issues will get a couple of errors in logs, but nothing to worry about :)
adam. On 03/02/2015 23:42:42, Adam Armstrong adama@memetic.org wrote: Yup, seems the original commit was in the wrong order.
adam. On 03/02/2015 23:38:36, Matt Ladewig matt@univoip.com wrote: Hey Adam – I’m on 6239 and appear to be in the same boat. mysql> desc eventlog; +-------------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+-------------+------+-----+---------+----------------+ | event_id | int(11) | NO | PRI | NULL | auto_increment | | device_id | int(11) | NO | MUL | 0 | | | timestamp | datetime | YES | MUL | NULL | | | message | text | YES | | NULL | | | entity_type | varchar(64) | YES | MUL | NULL | | | entity_id | int(64) | YES | | NULL | | +-------------+-------------+------+-----+---------+----------------+ 6 rows in set (0.00 sec) Can you confirm that the script you mentioned below will take care of this?
Thanks,
Matt From: observium [mailto:observium-bounces@observium.org] On Behalf Of Adam Armstrong Sent: Tuesday, February 3, 2015 9:25 AM To: observium@observium.org Subject: Re: [Observium] no messages in event log for 2 days Your table should look like : http://alpha.memetic.org/~adama/snaps/dev.observium.org___localhost___observ... [http://alpha.memetic.org/~adama/snaps/dev.observium.org___localhost___observ...] adam. On 03/02/2015 23:22:35, Simon Smith <simonsmith5521@gmail.com [mailto:simonsmith5521@gmail.com]> wrote: ignore my last email adam, my bad, i checked the table `eventlog` and it already had the column severity in for some reason? the other commands completed with loads and loads of updates… however if i goto the EventLog now its still not showing any new information for last two days :( am i just going to have to wait for something to happen for the DB to be updated? 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 [http://postman.memetic.org/cgi-bin/mailman/listinfo/observium]