(RADIATOR) formatted TIME_STAMP in AcctSQLStatement

[Hugh Irvine]

Hello Robert -

The simplest thing is to write a little hook that will add a 
pseudo-attribute to the incoming request packet formatted however you 
need it to be. Then you can simply use the pseudo-attribute directly in 
the AcctSQLStatement.

You will find some example hooks in the file "goodies/hooks.txt".

regards

Hugh


On Friday, Sep 12, 2003, at 14:56 Australia/Melbourne, Robert Blayzor 
wrote:

>>> So lets say I'm using MSSQL...
>>>
>>>         DateFormat      %m/%d/%Y %X
>>>         AcctSQLStatement        EXEC 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 used in AuthBy SQL is to
>> format AcctColumnDefs
>> with integer-date types.
>>
>> Timestamp can be got in a number of formats usign special
>> characters like:
>>
>> %b, %o etc.
>>
>> I wonder if a new special character that means 'Timestamp in
>> standard SQL date
>> format' might be useful?
>
> Well that being said.  How am I able to easily pass in a "TimeStamp"
> field in the format I need so that my specific "AcctSQLStatement" can
> insert it however I need it. (see above).  Since stored procedurs use
> argument lists instead of direct insert column/value pairs.
>
> Given above, I need to get TimeStamp into the format above to pass it 
> in
> the argument list.
>
> --
> Robert Blayzor, BOFH
> INOC, LLC
> rblayzor at inoc.net
>
> Exclusive: We're the only ones who have the documentation.
>
>
>
> ===
> 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.
>
>

NB: have you included a copy of your configuration file (no secrets),
together with a trace 4 debug showing what is happening?

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.



NB: have you included a copy of your configuration file (no secrets),
together with a trace 4 debug showing what is happening?

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.

===
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.