Uh...sorry for bothering you again and maybe I don't get it...
But first of all I have installed 2.14.1 allready. And the Readme only has a
comment about the %y and %e parameters. While in my case its about the %H,
%M and %S paramaters for the time. And they seem to report just one digit
only for the Session table while the accounting info is correctly filled
with two digits for each of those parameters.
Arjen Jansen
-----Original Message-----
From: Mike McCauley [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 07, 2000 03:27
To: [EMAIL PROTECTED]
Subject: Re: When are time formatting chars prefixed by zero's?
Hello,
This problem has been fixed by a recent patch. Check
http://www.open.com.au/radiator/downloads/patches-2.14.1/patches.README
Hope that helps.
BTW, the address for the mailing list is [EMAIL PROTECTED]
Cheers.
On Jan 6, 10:50am, Glasshouse Beheer wrote:
> Subject: When are time formatting chars prefixed by zero's?
> Hello,
>
> I have added in the config for my accounting table (SQL) a datetime string
> using :
> AcctColumnDef DATE_TIME,Timestamp,formatted-date,'%Y%m%d%H%M%S'
>
> And I have added to the Sessiontable:
> <SessionDatabase SQL>
> AddQuery INSERT INTO RADIUSSESSION ( ..., DATE_TIME, ...)
> VALUES ( ... '%Y%m%d%H%M%S', ... )
>
> Now the fun thing is that in the Session table the Date_Time column gets
> filled with the date and time where the time fields are not always 2
digits.
> For instance:
> Time 06 Jan 2000 09.05.13 results in: 200001069513
> And in the Accounting database the same field with the same format string
> the time fields do get correctly prefixed by zero's. For instance:
> Time 06 Jan 2000 09.05.13 results in: 20000106090513
>
> Is this cause the formatted-date function does it right while the code for
> the sessiondatabase does not? Is there a fix for this cause I need them
> prefixed so I can compare and sort it properly.
>
> Thanx!
> Arjen Jansen
>
>
>
>
>-- End of excerpt from Glasshouse Beheer
--
Mike McCauley [EMAIL PROTECTED]
Open System Consultants Pty. Ltd Unix, Perl, Motif, C++, WWW
24 Bateman St Hampton, VIC 3188 Australia http://www.open.com.au
Phone +61 3 9598-0985 Fax +61 3 9598-0955
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, TACACS+, PAM, external, etc etc on Unix, Win95/8,
NT, Rhapsody
===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
