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 [EMAIL PROTECTED]
Exclusive: We're the only ones who have the documentation.
=== 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.
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 [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
