mersenneforum.org llrnet Server Date/Time stamps in logs
 Register FAQ Search Today's Posts Mark Forums Read

 2008-11-12, 23:34 #1 IronBits I ♥ BOINC!     Oct 2002 Glendale, AZ. (USA) 3×7×53 Posts llrnet Server Date/Time stamps in logs Ok, we need to make a decision on how we want the date and time formats to be shown forever in the llrnet results.txt files, AND, instructions on exactly how to make it that way for both Linux and Windows servers. Default in llrserver-config.txt we have [Sat Mar 1 06:51:02 2008] With a slight modification to the config file In Linux we have [08/11/2008 07:16:36 AM] [08/11/2008 12:00:06 PM] In Windows we have [09/16/08 13:10:35] Someone sent me an awk script to change the time format from 12 hour to 24 hour, when I changed the llrnet server from Windows to Linux. What we need is a consistent agreed upon date / time stamp format so we can convert to .csv files with the least amount of effort and to reduce errors for importing the data into the database. I personally don't care what it's going to be, just so long as we decide on and agree on the format we will be using from here on out. I believe the below would be the best and easiest to work with and time conversion is a snap if need be. [yyyy/mm/dd 24hr time] Windows uses the last two yy, but that's easy enough to add in the first two yy. So what say ye all? Last fiddled with by gd_barnes on 2008-11-13 at 05:11 Reason: change recommended date/time format per David
 2008-11-13, 00:54 #2 IronBits I ♥ BOINC!     Oct 2002 Glendale, AZ. (USA) 3·7·53 Posts I make the above format as part of the filenames so it's easier to sort by date/time Last fiddled with by gd_barnes on 2008-11-13 at 05:12 Reason: remove part changed in 1st post
2008-11-13, 05:15   #3
gd_barnes

May 2007
Kansas; USA

5×2,017 Posts

Quote:
 Originally Posted by IronBits I make the above format as part of the filenames so it's easier to sort by date/time

I completely agree with using the yyyy/mm/dd format on both the results and in the results file names. Karsten and I have gone to that as a more standard date format for reservation and status dates on our k<300 and CRUS web pages.

This format works best in the file name for keeping them in correct date order.

 2008-11-13, 12:06 #4 kar_bon     Mar 2006 Germany 22×691 Posts agree too. all dates on www.rieselprime.org are changed to this format YYYY/MM/DD. for my personal verification tools for the drive stats pages i used an awk-script that can handle different formats depending on it (Adam's server got ohters than David's,...) a unique format for all resultfiles would be best! Last fiddled with by kar_bon on 2008-11-13 at 12:06
 2008-11-13, 12:11 #5 Mini-Geek Account Deleted     "Tim Sorbera" Aug 2006 San Antonio, TX USA 17·251 Posts http://www.cl.cam.ac.uk/~mgk25/iso-time.html The international ISO standard is "YYYY-MM-DD HH:MM:SS" (24 hour) e.g. 2008-09-16 13:10:35 I think that should be used to avoid confusion about whether it's YYYY/MM/DD or YYYY/DD/MM. If it looks like the ISO standard, people are more likely to know it's YYYY-MM-DD instead of any other variation (at least, if people know about the ISO standard...even if they don't, I think it's better than something separated by slashes, which are used in many different ways).
 2008-11-13, 13:23 #6 IronBits I ♥ BOINC!     Oct 2002 Glendale, AZ. (USA) 3·7·53 Posts Well heck, if it's an ISO standard YYYY-MM-DD HH:MM:SS" (24 hour) it is! Now, does anyone know how to tweak what file so llrnet Server will output that by default? For both Linux and Windows and any other flavors that might be out there? Then we can create new Section 'Everything you need to know to run an LLRNET Server' and make it a sticky so we don't lose it... Then we can provide all the links to the Server software, a corrected config files they need to use so they are ISO compliant and all the Scripts we use to generate web pages, stats and .csv files etc. One stop shopping for Servers Last fiddled with by IronBits on 2008-11-13 at 13:24
2008-11-13, 16:49   #7
mdettweiler
A Sunny Moo

Aug 2007
USA (GMT-5)

624910 Posts

Quote:
 Originally Posted by IronBits Well heck, if it's an ISO standard YYYY-MM-DD HH:MM:SS" (24 hour) it is! Now, does anyone know how to tweak what file so llrnet Server will output that by default? For both Linux and Windows and any other flavors that might be out there? Then we can create new Section 'Everything you need to know to run an LLRNET Server' and make it a sticky so we don't lose it... Then we can provide all the links to the Server software, a corrected config files they need to use so they are ISO compliant and all the Scripts we use to generate web pages, stats and .csv files etc. One stop shopping for Servers
Hmm...well, the way we've got the servers' llr-serverconfig.txt's fixed right now is:

function DisplayDate()
return date("%d/%m/%Y\ %r")
end

Presumably, to have them output in ISO format, we'd have to change the date string to:

return date("%d-%m-%Y\ %r")

Of course, we'd still have to do some minor conversions in the scripts that generate the CSV files--namely, converting the two-digit year in the Windows "ISO-ish" format to four-digit, and converting the 12-hour time in the Linux one to 24-hour time, thus making our CSV times fully ISO compatible.

2008-11-13, 16:59   #8
Mini-Geek
Account Deleted

"Tim Sorbera"
Aug 2006
San Antonio, TX USA

17·251 Posts

Quote:
 Originally Posted by mdettweiler return date("%d-%m-%Y\ %r")
I think you mean
Code:
return date("%F\ %R")

http://astrostatistics.psu.edu/datas.../strptime.html
%F is equiv. to %Y-%m-%d, the ISO standard (note Y-m-d, not d-m-Y as you entered), and %R is 24 hour time.

Last fiddled with by Mini-Geek on 2008-11-13 at 17:04

2008-11-13, 17:01   #9
mdettweiler
A Sunny Moo

Aug 2007
USA (GMT-5)

3×2,083 Posts

Quote:
 Originally Posted by Mini-Geek I think you mean Code: return date("%Y-%m-%d\ %r")
Oops, yeah that's what I meant. Thanks.

 2008-11-13, 23:55 #10 IronBits I ♥ BOINC!     Oct 2002 Glendale, AZ. (USA) 3×7×53 Posts Max, give return date("%F\ %R") a try, let me know how that works out! If that works out as it sounds like it should, then we won't have to convert date/time anymore :D Does that work for both Linux and Windows Mini-Geek ??? and I'm going to assume it has to be in CAPS correct??? Last fiddled with by IronBits on 2008-11-13 at 23:56
2008-11-14, 00:04   #11
mdettweiler
A Sunny Moo

Aug 2007
USA (GMT-5)

3·2,083 Posts

Quote:
 Originally Posted by IronBits Max, give return date("%F\ %R") a try, let me know how that works out! If that works out as it sounds like it should, then we won't have to convert date/time anymore :D Does that work for both Linux and Windows Mini-Geek ??? and I'm going to assume it has to be in CAPS correct???
Okay, I've changed the llr-serverconfig.txt file, now I've just got to wait for a result to come in to check it. (I've got one client working steadily on G4000, so I imagine something should come in with the next 5-10 minutes.)

 Similar Threads Thread Thread Starter Forum Replies Last Post E_tron Lounge 68 2013-10-03 06:23 joblack PrimeNet 5 2010-07-02 22:31 garo Forum Feedback 3 2007-09-11 20:31 richs Forum Feedback 6 2007-09-11 14:51 Molnar Prime Sierpinski Project 4 2006-10-19 14:32

All times are UTC. The time now is 02:10.

Tue Mar 31 02:10:12 UTC 2020 up 5 days, 23:43, 0 users, load averages: 1.62, 1.66, 1.63