(RADIATOR) Accounting Cisco Attributes

[Hugh Irvine]

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.