[hobbit] RE: BBWin V.12 filesystem epoch time and local time conflict
McGraw, Robert P
rmcgraw at purdue.edu
Tue Jun 24 23:06:11 CEST 2008
A follow up to Tom Kuffmans comments below.
The problem is that you have to convert local time to GMT to get the correct
epoch time for the time zone you are in.
As you suggested I looked at my time zone on my BBWIN client and it reports;
"GMT-05:00) Eastern (US & Canada and I have automatically adjust clock for
daylight saving changes". I also run Cygwin on my BBWin client and when I
enter the command "date" I get "Tue Jun 24 16:42:37 EDT 2008". So I believe
my date and timezone are set correctly.
So my next test was to create "file:" test for my BBWin client and a Solaris
UNIX client and touch the test files on both clients at the same time so
they would have approximately the same mtime.
For the BBWin client the client data returned
[file:c:\Alligate\AAATEST]
type:0x00020 (file)
mode:777 (not implemented)
linkcount:1
owner:0 (not implemented)
group:0 (not implemented)
size:0
atime:1214324279 (2008/06/24-16:17:59)
ctime:1213796626 (2008/06/18-13:43:46)
mtime:1214324279 (2008/06/24-16:17:59)
And for UNIX client the client data returned
[file:/AAATEST]
type:100000 (file)
mode:644 (-rw-r--r--)
linkcount:1
owner:0 (root)
group:1 (other)
size:0
clock:1214338710 (2008/06/24-16:18:30)
atime:1214338680 (2008/06/24-16:18:00)
ctime:1214338680 (2008/06/24-16:18:00)
mtime:1214338680 (2008/06/24-16:18:00)
As you can see the mtime YMD are within a second of each other but the epoch
number is off by four hours plus one second.
For BBWin mtime epoch time 1214324279 I get the following returned from
http://www.epochconverter.com/.
GMT: Tue, 24 Jun 2008 16:17:59 GM
Your timezone: Tue Jun 24 12:17:59 2008
For UNIX mtime epoch time 1214338680 I get the following retuned
http://www.epochconverter.com/
GMT: Tue, 24 Jun 2008 20:18:00 GMT
Your timezone: Tue Jun 24 16:18:00 2008
I believe BBWin is using local time as GMT time and calculating the epoch
time which is off by 4 hours which is the different between EDT and GMT.
The code needs to convert local time to GMT and then calculate epoch time.
Robert
> -----Original Message-----
> From: Kauffman, Tom [mailto:KauffmanT at nibco.com]
> Sent: Tuesday, June 24, 2008 1:36 PM
> To: hobbit at hswn.dk
> Subject: [hobbit] RE: BBWin V.12 filesystem epoch time and local time
> conflict
>
>
> I think you're looking for something that doesn't exist, unless the
> windows epoch handling is non-posix. In the Unix/posix environment, the
> epoch is always UTC and the conversion to local time-zone value occurs as
> part of the time formatting - there's no such animal as 'local epoch'. I'd
> look at the system returning these values and make sure the time zone is
> set correctlyraw, Robert P [mailto:rmcgraw at purdue.edu]
> Sent: Tuesday, June 24, 2008 11:46 AM
> To: hobbit at hswn.dk
> Subject: [hobbit] RE: BBWin V.12 filesystem epoch time and local time
> conflict
>
>
>
> A little more digging and I see
>
>
> > -----Original Message-----
> > From: McGraw, Robert P
> > Sent: Tuesday, June 24, 2008 10:40 AM
> > To: 'hobbit at hswn.dk'; 'bbwin-users at lists.sourceforge.net'
> > Subject: BBWin V.12 filesystem epoch time and local time conflict
> >
> > I have the [file:] set up in central mode on our BBWin V.12 client and
> it
> > returns the following client data to the Hobbit server.
> >
> > [file:c:\Alligate\AAATEST]
> > type:0x00020 (file)
> > mode:777 (not implemented)
> > linkcount:1
> > owner:0 (not implemented)
> > group:0 (not implemented)
> > size:0
> > atime:1214222069 (2008/06/23-11:54:29)
> > ctime:1213796626 (2008/06/18-13:43:46)
> > mtime:1214222069 (2008/06/23-11:54:29)
> >
> > On my hobbit server hobbit-clients.cfg I have
> >
> > FILE c:\Alligate\AAATEST red MTIME<88200
> >
> > The YYYY/MM/DD-HH:MM:SS atime, ctime and mtime are local time.
> >
> > During testing I noticed that the red icon would come on before I had
> > expected.
> >
> > I decided to do a little checking and using a web epoch time calculator.
> >
> > If I enter 2008/06/23-11:54:29 it returns the epoch time of 1214236469,
> > which
> > does not match mtime epoch time above.
> >
> > If I enter the epoch mtime 1214222069 I get Mon Jun 23 2008 07:54:29
> > GMT-0400 (EDT) which does not match the date.
> >
> > If I enter epoch time 1214236469 I get Mon Jun 23 2008 11:54:29 GMT-0400
> > (EDT)
> >
> > It seems that the YYYY/MM/DD-HH:MM:SS time is reported in local time and
> > the
> > epoch time is reported in GMT time which throws things off by four
> hours.
> >
> >
> > The following is the code in filesystem
> >
> > 325 reportData << format("type:0x%05x ") %
> > handle_file_info.dwFileAttributes;
> > 326 if (handle_file_info.dwFileAttributes &
> > FILE_ATTRIBUTE_DIRECTORY)
> > 327 reportData << "(dir)" << endl;
> > 328 else
> > 329 reportData << "(file)" << endl;
> > 330 reportData << "mode:777 (not implemented)" << endl;
> > 331 reportData << format("linkcount:%u") %
> > handle_file_info.nNumberOfLinks
> > << endl;
> > 332 reportData << "owner:0 (not implemented)" << endl;
> > 333 reportData << "group:0 (not implemented)" << endl;
> > 334 reportData << format("size:%lu") % fsize << endl;
> > 335 string output;
> > 336 GetTimeString(handle_file_info.ftLastAccessTime, output);
> > 337 reportData << "atime:" << output << endl;
> > 338 GetTimeString(handle_file_info.ftCreationTime, output);
> > 339 reportData << "ctime:" << output << endl;
> > 340 GetTimeString(handle_file_info.ftLastWriteTime, output);
> > 341 reportData << "mtime:" << output << endl;
> > 342 fclose(f);
> > 343 return true;
>
> GetTimeString is a function in the filesystem code which follows.
>
> bool AgentFileSystem::GetTimeString(const FILETIME & filetime,
> string & output) {
> 255 __int64 ftime = (filetime.dwHighDateTime * MAXDWORD) +
> filetime.dwLowDateTime;
> 256 SYSTEMTIME fsystime;
> 257 FILETIME floctime;
> 258 time_t epoch;
> 259
> 260 if (::FileTimeToLocalFileTime(&filetime, &floctime) == 0) {
> 261 return false;
> 262 }
> 263 if (::FileTimeToSystemTime(&floctime, &fsystime) == 0) {
> 264 return false;
> 265 }
> 266 utils::SystemTimeToTime_t(&fsystime, &epoch);
> 267 stringstream reportData;
> 268 reportData << format("%llu (%02d/%02d/%d-%02d:%02d:%02d)")
> 269 % (unsigned __int64)epoch
> 270 % fsystime.wYear
> 271 % fsystime.wMonth
> 272 % fsystime.wDay
> 273 % fsystime.wHour
> 274 % fsystime.wMinute
> 275 % fsystime.wSecond;
> 276 output = reportData.str();
> 277 return true;
> 278 }
>
> It seems to me that after line 266 there needs to be a couple lines that
> converts the GMT epoch to local epoch.
>
>
>
> >
> >
> > The function GetTimeString seems to be the code that is returning the
> time
> > information. I have not been able to find this code in the BBWin svn so
> I
> > am
> > not sure if this is a local function or a system function.
> >
> > I am not a Window type guy and no very little about such things. Can a
> > super
> > duper window type person peruse this and see what they can find.
> >
> > Tanks
> >
> >
> >
> > Thanks
> >
> > Robert
> >
> >
> >
> >
> >
> > --------------------------------------------------------------------
> > Robert P. McGraw, Jr.
> > Manager, Computer System EMAIL: rmcgraw at purdue.edu
> > Purdue University ROOM: MATH-807
> > Department of Mathematics PHONE: (765) 494-6055
> > 150 N. University Street
> > West Lafayette, IN 47907-2067
>
> CONFIDENTIALITY NOTICE: This email and any attachments are for the
> exclusive and confidential use of the intended recipient. If you are not
> the intended recipient, please do not read, distribute or take action in
> reliance upon this message. If you have received this in error, please
> notify us immediately by return email and promptly delete this message
> and its attachments from your computer system. We do not waive
> attorney-client or work product privilege by the transmission of this
> message.
>
>
>
> To unsubscribe from the hobbit list, send an e-mail to
> hobbit-unsubscribe at hswn.dk
>
>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 3105 bytes
Desc: not available
URL: <http://lists.xymon.com/pipermail/xymon/attachments/20080624/43e5a4a6/attachment.bin>
More information about the Xymon
mailing list