(RADIATOR) formatted TIME_STAMP in AcctSQLStatement

Mike McCauley mikem at open.com.au
Thu Sep 11 18:19:38 CDT 2003


Hello all,


On Thu, 11 Sep 2003 10:09 pm, Robert Blayzor wrote:
> On 9/11/03 7:23 PM, "tracker" <jaws at skyinet.net> 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
> rblayzor at inoc.net
> 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 radiator-announce at open.com.au
> To unsubscribe, email 'majordomo at open.com.au' with
> 'unsubscribe radiator' in the body of the message.

-- 
Mike McCauley                               mikem at open.com.au
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 radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.


More information about the radiator mailing list