Hi everyone.
We're having a small issues with a migration from nagios to icinga 1.5.0
which involves the START_TIME / END_TIME db entries for the host/service/etc
checks.
The icinga-core, and icinga-web are on a Ubuntu 10.04.3 LTS
# cat /etc/timezone
America/Montreal
The DB is Oracle 11.2.0 on an AIX 7 system.
cat /etc/environment
TZ=America/Montreal
My first question is does icinga/ido2db send UTC time to the database?
Basically, the system time is correct, and the timezone is set to
'America/Montreal' but the db entries are showing 4 hours fast.
Everything looks fine in the classic WebUI, times are all correct;
[09-22-2011 08:52:35] Finished daemonizing... (New PID=1143)
[09-22-2011 08:52:35] Event broker module '/usr/local/icinga/bin/idomod.o'
initialized successfully.
[09-22-2011 08:52:35] idomod: Successfully connected to data sink. 0 queued
items to flush.
[09-22-2011 08:52:35] idomod: IDOMOD 1.5.0 (08-24-2011) Copyright (c)
2005-2008 Ethan Galstad (nag...@nagios.org), Copyright (c) 2009-2011 Icinga
Development Team (http://www.icinga.org))
[09-22-2011 08:52:35] LOG VERSION: 2.0
[09-22-2011 08:52:35] Local time is Thu Sep 22 08:52:35 EDT 2011
Connecting to oracle as root, icinga, or oracle users show the correct time,
and timezone;
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Automatic Storage Management and OLAP options
SQL> SELECT SESSIONTIMEZONE FROM DUAL;
SESSIONTIMEZONE
---------------------------------------------------------------------------
-04:00
SQL> SELECT current_timestamp FROM DUAL;
CURRENT_TIMESTAMP
---------------------------------------------------------------------------
22-SEP-11 08.47.26.466994 AM -04:00
SQL> SELECT dbtimezone FROM DUAL;
DBTIME
------
-04:00
but rows from the host and servicecheck tables show +4 hours;
select ID,START_TIME from HOSTCHECKS ORDER BY ID;
ID START_TIME
---------- -------------------
1269 2011-09-22 12:50:08
Which leads to some time issues in icinga-web
I've started looking at the oracle ORA_SDTZ variable, but haven't had much
luck.
Is there anything I'm missing? I followed the Quick start guide.
------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure contains a
definitive record of customers, application performance, security
threats, fraudulent activity and more. Splunk takes this data and makes
sense of it. Business sense. IT sense. Common sense.
http://p.sf.net/sfu/splunk-d2dcopy1
_______________________________________________
icinga-users mailing list
icinga-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/icinga-users
