Hi, Can someone please clarify the new behavior mentioned here:
--------------------------------------------------------
From: http://docs.icinga.org/latest/en/quickstart-idoutils.html
*Timezone support*
Starting with Icinga 1.6 all dates are stored as local timestamps in the
database. Before that there was a different behaviour storing and
retrieving dates for each database system which was difficult to handle for
frontend apps. Therefore datatypes have been changed for MySQL from
DATETIME to TIMESTAMP and for Oracle from DATE to LOCAL TIMESTAMP (0).
PostgreSQL was already using TIMESTAMP but has been changed to TIMESTAMP
WITH TIME ZONE. IDO2DB will set session timezone to UTC and store all unix
timestamps (which are UTC per definition) as UTC based values. Please make
sure your system returns unix timestamps as real UTC based values (like
"date -u '+%s'").
[image: [Note]] Note
Make sure your database session runs in the same timezone in which the
existing dates have been stored (check your local timezone e.g.
Oracle:"select sessiontimezone from dual;") if you are running the upgrade
script. Additionally for your convenience in Oracle you should set your
session timestamp format to the value you want, e.g "alter session set
nls_timestamp_format='YYYY-MM-DD HH24:MI:SS';" or similar. Now you can view
entries from different Icinga installations in different time zones which
are stored in the same database and regardless from where you accessing it,
all entries are returned in your local time zone.
--------------------------------------------------------
There are notes about setting TZ in apache in the icinga.cfg that confuse
this issue even more.
Do I need to set the system time to UTC? ie., the hardware and system
clock? If I do that, then do I need to set the TZ setting in my apache
config? If I have the TZ set in the apache config, then status maps don't
work now.
It would be great if someone could post a short check list of what exactly
needs to be set to make everything work.
I'm currently using ubuntu 10.x and my timezone is CDT.
Also there is mention in other docs of setting the time in php.ini. If I
do a phpinfo now, it shows the timezone as CDT, but my icinga-web logs are
all 6 hours ahead.
Any help will be greatly appreciated.
Thanks!
Pete
------------------------------------------------------------------------------
Learn Windows Azure Live! Tuesday, Dec 13, 2011
Microsoft is holding a special Learn Windows Azure training event for
developers. It will provide a great way to learn Windows Azure and what it
provides. You can attend the event by watching it streamed LIVE online.
Learn more at http://p.sf.net/sfu/ms-windowsazure
_______________________________________________
icinga-users mailing list
icinga-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/icinga-users
