Hello all,
On Thu, 11 Sep 2003 10:09 pm, Robert Blayzor wrote: > On 9/11/03 7:23 PM, "tracker" <[EMAIL PROTECTED]> wrote: > > Is it possible to use a formatted TIME_STAMP in AcctSQLStatement, like > > > > formatted-date,'%e %m %Y %H:%M:%S' > > Easier way may be to have your SQL server insert the time for you. That > is, if your SQL server and your RADIUS server's times are sync'd. (and > current date/time is what you want) You can do this several ways depending > on your backend, ie: > > MSSQL - getdate() > > Or PgSQL - timestamp 'now' > > More.. > > INSERT INTO tbl_radacct (recdate) values (timestamp 'now') Yes, but you really should take into account the Acct-Delay-Time in accounting requests, which is the amount of time the request has been sitting in the NAS waiting for successful transmission. The Timestamp attrtibute takes this into account, so its best to use that if possible. Cheers. > > -- > Robert Blayzor, BOFH > INOC, LLC > [EMAIL PROTECTED] > PGP: http://www.inoc.net/~dev/ > Key fingerprint = A445 7D1E 3D4F A4EF 6875 21BB 1BAA 10FE 5748 CFE9 > > I'm not sure. Try calling the Internet's head office -- it's in the book. > > > === > Archive at http://www.open.com.au/archives/radiator/ > Announcements on [EMAIL PROTECTED] > To unsubscribe, email '[EMAIL PROTECTED]' with > 'unsubscribe radiator' in the body of the message. -- 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, Active Directory, EAP, TLS, TTLS, PEAP etc on Unix, Windows, MacOS etc. === Archive at http://www.open.com.au/archives/radiator/ Announcements on [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
