Bug #1902

instance status cronk - status age is calculated wrong with utc (minus 2 hours)

Added by dnsmichi over 2 years ago. Updated over 2 years ago.

Status:ResolvedStart date:09/15/2011
Priority:NormalDue date:
Assignee:mhein% Done:

100%

Category:-Estimated time:0.00 hour
Target version:Icinga 1.x - 1.6
Icinga Version: DB Type:
Icinga Web Version: DB Version:
IDO Version: Browser Version:
OS Version:

Description

using icinga-web 1.5.2 r1.5 git, 7990db3b3e4372c3d1126dcf4c6ed0f114aa0a85

time now is 16:15, server time in icinga-web shows 14:15

the instance status cronk now calculates that wrong, and says ~ minus 2 hours old. so my instance status is in the future?

i do think that the query is somehow wrong, in combination with the default timesettings - i'm not using any changes in icinga-web configs nor do i set the default timezone in php.ini as i always test fresh unmodified installs.

icinga_web_1.5.2_instance_status_data.png (18.5 KB) dnsmichi, 09/15/2011 04:18 pm

icinga_web_utc_oracle_timeproblems02.png (254 KB) dnsmichi, 11/16/2011 06:50 pm

icinga_web_utc_oracle_timeproblems01.png (250 KB) dnsmichi, 11/16/2011 06:50 pm

History

#1 Updated by mhein over 2 years ago

  • Status changed from New to Feedback
  • Depending on oracle issues #1954

#2 Updated by mhein over 2 years ago

  • Status changed from Feedback to Assigned
  • Assignee set to mhein

#3 Updated by mhein over 2 years ago

  • Status changed from Assigned to Feedback

Are there any news for this?

#4 Updated by dnsmichi over 2 years ago

servertime now thinks of 17:35, while localtime is 18:35

changing translation.xml to according timezone,

                 <available_locales default_locale="de" default_timezone="Europe/Berlin">
                        <available_locale identifier="de_DE">
                          <ae:parameter name="description">Deutsch</ae:parameter>
                        </available_locale>
                        <available_locale identifier="en">
                          <ae:parameter name="description">English</ae:parameter>
                        </available_locale>
                 </available_locales>

this adds another difference of 1 hour.

hm....

#5 Updated by jmosshammer over 2 years ago

Which timezone is defined in your oracle-db?

#6 Updated by Wolfgang over 2 years ago

That sounds as if servertime is set to UTC. MESZ is two hours ahead, MEZ
only one.

Am 16.11.2011 18:50, schrieb :

this reduces the difference to 1 hour.

hm....

#7 Updated by mhein over 2 years ago

  • Status changed from Feedback to Assigned
  • Estimated time set to 0.00

#8 Updated by mhein over 2 years ago

  • Status changed from Assigned to Feedback

Hi.

For oracle this error comes from the agent_version. "1.6.0-dev" is longer that 8 chars. Thanks thomas dressler to give that hint:

=== SCHNIPP ===

Gibt es evt. andere Oracle Fehler im Log (z.B. ist Versionsstring zu gross
und deshalb kommt das hello gar nicht so weit)? Das kommt von der
Erweiterung auf " 1.6.0-dev"
Dann z.b. mit "alter table conninfo modify (agent_version varchar2(10));"
das Schema ändern.

=== SCHNAPP ===

Can some one agree with that?

Kind regards,
Marius.

#9 Updated by mhein over 2 years ago

  • % Done changed from 0 to 100

#10 Updated by mhein over 2 years ago

  • Status changed from Feedback to Resolved

I'll close that bug. If there are any further problems / hints, please reopen at will.

Kind regards,
Marius.

Also available in: Atom PDF