(RADIATOR) Accounting Cisco Attributes
Hugh Irvine
hugh at open.com.au
Wed May 14 17:32:46 CDT 2003
Hello Richard -
The simplest way to deal with the "cisco-h323-WHATEVER" is to write a
PreClientHook that will parse the attributes and add the inner
attributes as pseudo-attributes to the current request. You will find
an example hook that does something similar in the file
"goodies/hooks.txt". Then you can use simple AcctColumnDef's for the
pseudo-attributes.
For the Oracle sequence you should just use an AcctSQLStatement.
regards
Hugh
On Wednesday, May 14, 2003, at 23:20 Australia/Melbourne, Richard
Grantham wrote:
> Hi all,
>
> We know that Cisco, in all their wisdom, decided that their VSA would
> take the form
>
> cisco-h323-WHATEVER = "h323-WHATEVER=something"
>
> I'm trying to log just the 'somthing' part of that attribute in our
> Oracle database and was wondering on the best way to do it. At the
> moment I'm using an ugly klude using the AcctSQLStatement parameter:
>
> AcctSQLStatement \
> update raw_accounting_log set \
> h323_gw_id = substr('%{cisco-h323-gw-id}', 12), \
> h323_call_origin = substr('%{cisco-h323-call-origin}', 18), \
> h323_call_type = substr('%{cisco-h323-call-type}', 16), \
> h323_conf_id = substr('%{cisco-h323-conf-id}', 14), \
> h323_disconnect_cause =
> substr('%{cisco-h323-disconnect-cause}',
> 23), \
> h323_remote_address = substr('%{cisco-h323-remote-address}',
> 21)
> \
> where log_id = %{Timestamp}
>
> The other question was how can I specify the primary key of the
> accounting record using AcctColumnDef? As is shown in the example
> above
> I'm using the Timestamp integer - which is not ideal! I'd like to use
> an Oracle sequence which, to those of you who don't know the syntax,
> would allow me to specify the PK as log_id.nextval.
>
> TIA,
>
> Richard
> --
> ===
> 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 95/98/2000, NT, 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.
More information about the radiator
mailing list