Hello Robert,
OK, to make things easy, we have now added a new special character.
%A is replaced by the Timestamp in standard SQL
date format eg: Sep 12, 2003 15:48.
(Also %B is replaced by the current time in standard SQL date format eg: Sep
12, 2003 15:48.)
New patch for Util.pm is
Hello Jaws -
You can only use formatted-date or integer-date (preferably) in an
AcctColumnDef.
See section 6.28.14 in the Radiator 3.6 reference manual
(doc/ref.html).
regards
Hugh
On Friday, Sep 12, 2003, at 09:23 Australia/Melbourne, tracker wrote:
Is it possible to use a formatted
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
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
On 9/11/03 7:19 PM, Mike McCauley [EMAIL PROTECTED] wrote:
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
Hello,
On Fri, 12 Sep 2003 09:49 am, Robert Blayzor wrote:
On 9/11/03 7:19 PM, Mike McCauley [EMAIL PROTECTED] wrote:
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
So lets say I'm using MSSQL...
DateFormat %m/%d/%Y %X
AcctSQLStatementEXEC sp_acctinsert '%{Acct-S
ession-Id}','%{Acct-Status-Type}','%{User-Name}','%{TimeStamp}'
Should insert the TimeStamp as '9/11/2003 21:21:21' ???
The only time the DateFormat is