Activity Log shows wrong times

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
S54326
Posts: 31
Joined: Fri Mar 28, 2014 9:30 am

Activity Log shows wrong times

Post by S54326 »

Hi, just noticed that the activity log is showing the wrong times. I first checked the system time and that was correct. Then I realised that it was the minutes figure that was not changing and for todays log it was stuck at 11 minutes. Today is a day in November, the eleventh month! So I went back to an October log and, yep, evey minute entry was 10.
Has anyone else noticed this issue?

For the account I'm logged in with the date setting is (as selected from the drop down list) YYY-MM-DD HH:MM:SS
Currently Nagios XI 2014R1.5

Steve
Steve
slansing
Posts: 7698
Joined: Mon Apr 23, 2012 4:28 pm
Location: Travelling through time and space...

Re: Activity Log shows wrong times

Post by slansing »

Which activity log is this that you speak of?
S54326
Posts: 31
Joined: Fri Mar 28, 2014 9:30 am

Re: Activity Log shows wrong times

Post by S54326 »

Oops, I meant the Audit Log.
From the Admin tab -> Audit Log
Steve
User avatar
lmiltchev
Bugs find me
Posts: 13589
Joined: Mon May 23, 2011 12:15 pm

Re: Activity Log shows wrong times

Post by lmiltchev »

...every minute entry was 10.
Can you show us a screenshot of this?
Also, go to Admin->System Profile, copy/paste the "Date/Time" section in your next post.
Be sure to check out our Knowledgebase for helpful articles and solutions!
S54326
Posts: 31
Joined: Fri Mar 28, 2014 9:30 am

Re: Activity Log shows wrong times

Post by S54326 »

Here is a screen shot of the issue (Screenshot.png attachment)

And the "Date/Time" section is

Code: Select all

Date/Time
PHP Timezone: Europe/London
PHP Time: Fri, 21 Nov 2014 12:05:52 +0000
System Time: Fri, 21 Nov 2014 12:05:52 +0000
You do not have the required permissions to view the files attached to this post.
Steve
sreinhardt
-fno-stack-protector
Posts: 4366
Joined: Mon Nov 19, 2012 12:10 pm

Re: Activity Log shows wrong times

Post by sreinhardt »

I am not seeing this on a 2014R2.0 system, and will install a new 1.5 system just to see, but I have not heard of this before. Could you do the following:

Code: Select all

tail -f /var/log/httpd/error_log
** generate an auditlog report **
ctrl+c to cancel the tail.
Please post all output here.
Nagios-Plugins maintainer exclusively, unless you have other C language bugs with open-source nagios projects, then I am happy to help! Please pm or use other communication to alert me to issues as I no longer track the forum.
S54326
Posts: 31
Joined: Fri Mar 28, 2014 9:30 am

Re: Activity Log shows wrong times

Post by S54326 »

OK, I've done that. But no extra errors were appended to the error_log file.

Code: Select all

 date
Tue Nov 25 10:56:21 GMT 2014
[root@hisis116 ~]# tail -f /var/log/httpd/error_log
[Tue Nov 25 10:14:42 2014] [error] [client 10.96.151.73] File does not exist: /usr/local/nagiosxi/html/includes/components/nagioscore/ui/images/logos/windows_server.png, referer: http://nagiosxi.sussex.nhs.uk/nagiosxi/includes/components/xicore/status.php?host=5P6AS010
...
... more lines moaning about missing images
...
[Tue Nov 25 10:16:35 2014] [error] [client 10.96.151.73] File does not exist: /usr/local/nagiosxi/html/includes/components/nagioscore/ui/images/logos/windows_server.png, referer: http://nagiosxi.sussex.nhs.uk/nagiosxi/includes/components/xicore/status.php?show=servicedetail&host=ATESTSVR&service=Test+plugin+-+pl&dest=auto
^C
(BTW I've sorted out the missing logo images!)

And the Audit Log web page is still showing 11 for all the minute values just like my previous screen shot shows.
Steve
User avatar
lmiltchev
Bugs find me
Posts: 13589
Joined: Mon May 23, 2011 12:15 pm

Re: Activity Log shows wrong times

Post by lmiltchev »

Run the following command and show us the output:

Code: Select all

echo 'show timezone;' | psql nagiosxi nagiosxi
Also, run:

Code: Select all

echo 'select * from xi_auditlog;' | psql nagiosxi nagiosxi | tee &> /tmp/auditlog.txt
then open the "auditlog.txt" file that was created in the "/tmp/" directory from running the above command and review the timestamps. Is the minute entry "10" for all of them?
Be sure to check out our Knowledgebase for helpful articles and solutions!
S54326
Posts: 31
Joined: Fri Mar 28, 2014 9:30 am

Re: Activity Log shows wrong times

Post by S54326 »

Code: Select all

 echo 'show timezone;' | psql nagiosxi nagiosxi
 TimeZone
----------
 GB
(1 row)

In the "auditlog.txt" file, ALL entries created during November have a minute entry of "11". Also, ALL entries created during October have a minute entry of "10".
Steve
S54326
Posts: 31
Joined: Fri Mar 28, 2014 9:30 am

Re: Activity Log shows wrong times

Post by S54326 »

Also, to look into another issue that I've raised, I created a separate test VM 2014R1.5 and that is showing exactly the same problem.
Looks like the issue originates from the VM image downloded from your web site.
http://assets.nagios.com/downloads/nagi ... 1.5-64.ova is the one I used for the test VM.
Steve
Locked