Re: [Observium] Eventlog stopped working after upgrade
From what version to what version?
What event log entries don't work?
What things that you expect to generate email alerts don't work?
You will not receive any help if you just whine rather than providing any useful information.
Adam.
Hynek Med hynek@prozeta.cz wrote:
Hi,
after upgrading Observium via svn there are no event logs and we are not getting e-mail alerts. Where should I look for problems, can you point me to a direction, what to look at?
Thanks,
Hynek
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
Unfortunately I have less information than wish for. :( After some digging in old backups, I think the change was from r3465 to r3981. After that update no new events were noticed (and no alerts sent).
Looking at a newer Observium installation, I found that the eventlog table fields got renamed, so the script couldn't insert new entries. After renaming host to device_id and datetime to timestamp it works.
Was there some other database structure change between r3465-r3981 or anything else I should take care of ?
Thanks,
Hynek
On 13.5.2013 12:33, Adam Armstrong wrote:
From what version to what version?
What event log entries don't work?
What things that you expect to generate email alerts don't work?
You will not receive any help if you just whine rather than providing any useful information.
Adam.
Hynek Medhynek@prozeta.cz wrote:
Hi,
after upgrading Observium via svn there are no event logs and we are not getting e-mail alerts. Where should I look for problems, can you point me to a direction, what to look at?
Thanks,
Hynek
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
On 2013-05-13 16:19, Hynek Med wrote:
Unfortunately I have less information than wish for. :( After some digging in old backups, I think the change was from r3465 to r3981. After that update no new events were noticed (and no alerts sent).
Looking at a newer Observium installation, I found that the eventlog table fields got renamed, so the script couldn't insert new entries. After renaming host to device_id and datetime to timestamp it works.
Was there some other database structure change between r3465-r3981 or anything else I should take care of ?
Database changes should all be performed automatically.
r3465 to r3981 is a very large jump, you shouldn't wait so long to upgrade.
I think the change in question was in r3710 and was performed by sql-schema/048.sql
Note that you /must/ run the discovery script after an SVN up to ensure that the database schema is updated.
r3981 was 2 weeks ago, I assume you've updated since then?
adam.
You are running the discovery for database updates every time you run svn up, right?
Tom
On Mon, 2013-05-13 at 17:19 +0200, Hynek Med wrote:
Unfortunately I have less information than wish for. :( After some digging in old backups, I think the change was from r3465 to r3981. After that update no new events were noticed (and no alerts sent).
Looking at a newer Observium installation, I found that the eventlog table fields got renamed, so the script couldn't insert new entries. After renaming host to device_id and datetime to timestamp it works.
Was there some other database structure change between r3465-r3981 or anything else I should take care of ?
Thanks,
Hynek
On 13.5.2013 12:33, Adam Armstrong wrote:
From what version to what version?
What event log entries don't work?
What things that you expect to generate email alerts don't work?
You will not receive any help if you just whine rather than providing any useful information.
Adam.
Hynek Medhynek@prozeta.cz wrote:
Hi,
after upgrading Observium via svn there are no event logs and we are not getting e-mail alerts. Where should I look for problems, can you point me to a direction, what to look at?
Thanks,
Hynek
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
participants (3)
-
Adam Armstrong -
Hynek Med -
Tom Laermans