(RADIATOR) Question about Acct-Session-Id in Cisco AS5300

Ricardo Martinez rmartinez at redvoiss.net
Fri Feb 20 10:05:40 CST 2004


I found out how to solve this problem.. and it is more related with AS5300
Cisco configuration.  I found a way how to send the H323 VSA attributes
separate, and not all of them in the Acct-Session-Id.

Thanks anyway.

> Ricardo Javier Martinez Ogalde
> Ingeniero de Desarrollo
> VOISS NET S.A.
> Cisco Certified Network Associate ,CCNA (CSCO 10643101)
> *   :  rmartinez at redvoiss.net
> 
> 
> 
> -----Mensaje original-----
> De:	Ricardo Martinez [SMTP:rmartinez at redvoiss.net]
> Enviado el:	Miércoles, 18 de Febrero de 2004 05:13 p.m.
> Para:	'radiator at open.com.au'
> Asunto:	(RADIATOR) Question about Acct-Session-Id in Cisco AS5300
> 
> Hi.
> I'm new using RADIATOR.  I have several question and i hope that someone
> coud give me a hand.  
> The test scenario is as following :
> 
> Two NAS (Cisco AS5300 and other NAS device) and Radiator receiving the
> Radius accounting packets from both of them.
> 
> I'm using Radiator 3.7.1  interacting with a SQL database.  The next is my
> radius.cfg  file
> 
> Foreground
> LogStdout
> LogDir          .
> DbDir           .
> 
> # This will log at DEBUG level: very verbose
> # User a lower trace level in production systems, typically use 3
> Trace           4
> 
> <Client 10.0.0.1>
> #AS5300
>     Secret mysecret
> </Client>
> 
> <Client 10.0.0.3>
> #NAS2
>     Secret mysecret2
> </Client>
> 
> <ClientListSQL>
>         DBSource        dbi:Oracle:desadb
>         DBUsername      radius
>         DBAuth          radius
> </ClientListSQL>
> 
> # Authenticate all realms with this
> <Realm DEFAULT>
>         <AuthBy SQL>
>                 DBSource        dbi:Oracle:desadb
>                 DBUsername      radius
>                 DBAuth          radius
> 
>                
>                 AccountingTable ACCOUNTING
>                 AcctColumnDef   USERNAME,User-Name
>                 AcctColumnDef   CALLINGSTATIONID,Calling-Station-Id
>                 AcctColumnDef   CALLEDSTATIONIDE,Calling-Station-Id
>                 AcctColumnDef   ACCTSTATUSTYPE,Calling-Station-Id
>                 AcctColumnDef   ACCTSESSIONID,Acct-Session-Id
>                 AcctColumnDef   ACCTSESSIONTIME,Acct-Session-Time,integer
>                 AcctColumnDef   NASIPADDRESS,NAS-IP-Address
>                 AcctColumnDef   ACCTINPUTOCT,Acct-Input-Octets,integer
>                 AcctColumnDef   ACCTOUTPUTOCT,Acct-Output-Octets,integer
>                 AcctColumnDef   ACCTINPUTPKTS,Acct-Input-Packets,integer
>                 AcctColumnDef   ACCTOUTPUTPKTS,Acct-Output-Packets,integer
>                 AcctColumnDef   ACCTDELAYTIME,Acct-Dealy-Time,integer
>                 AcctColumnDef   ACCTAUTHENTIC,Acct-Authentic
>         </AuthBy>
> 
>         AcctLogFileName %D/detail
> </Realm>
> 
> Questions :
> 
> 1. How can i do to create a log file with my own format. For example i
> want
> that the local log file like this:
> User-Name	Calling-Station-Id		Calling-Station-Id	
> 
> One line per radius request. (maybe with more attributes in each line, but
> this is just an example)
> 
> 2.  Each NAS device sends different formats of radius packets.  Beside the
> typical radius attributes, the AS5300 sends in the Acct-Session-Id all the
> VSA information, as you can see in next lines : 
> 
> Code:       Accounting-Request
> Identifier: 41
> Authentic:  <236><235><224><202><189><183>_ <185>]<180><147>/<151><244>|
> Attributes:
>         Acct-Session-Id = "560/15:13:44.504 CHILE Wed Feb 18
> 2004/AS5300_GW./51AB3340 8EEDE127 804E0002
> A4003761/originate/Telephony/15:13:48.054 CHILE Wed Feb 18
> 2004/15:13:53.154
> CHILE Wed Feb 18 2004/10/51AB3340 8EEDE127 804E0002 A4003761"
>         Acct-Input-Octets = 7860
>         Acct-Output-Octets = 770
>         Acct-Input-Packets = 393
>         Acct-Output-Packets = 40
>         Acct-Session-Time = 5
>         Acct-Authentic = 0
>         User-Name = "AP2"
>         Acct-Status-Type = Stop
>         NAS-Port-Type = Async
>         NAS-Port = 0
>         Calling-Station-Id = "111"
>         Called-Station-Id = "005622408196"
>         Service-Type = Login-User
>         NAS-IP-Address = 64.76.148.243
>         Acct-Delay-Time = 0
> 
> So, all the information that i want to hadle is in the Acct-Session-Id.  
> Is there a way to parse all the information in the Acct-Session-Id to
> different "new" attributes, and then this attributes send them to the SQL.
> For example i want to map this attributes in the Acct-Session-Id in the
> new
> Cisco VSA attributes.. and then send it to the SQL Database..
> 
>          cisco-h323-call-origin = "h323-call-origin=originate"
>         cisco-h323-call-type = "h323-call-type=Telephony"
>         cisco-h323-setup-time = "h323-setup-time=15:13:44.504 CHILE Wed
> Feb
> 18 2004"
>         cisco-h323-connect-time = "h323-connect-time=15:13:48.054 CHILE
> Wed
> Feb 18 2004/"
>         cisco-h323-disconnect-time = "h323-disconnect-time=15:13:53.154
> CHILE Wed Feb 18 2004"
>         cisco-h323-disconnect-cause = "h323-disconnect-cause=10"
>         
> Is this posible?..
> 
> For the other hand the NAS2 device send the attributes one per line, as
> you
> can see in the next extract : 
> Cisco-NAS-Port = "FXS 0/0/0"
>         NAS-Port-Type = Async
>         User-Name = "111"
>         Called-Station-Id = "005622408196"
>         Calling-Station-Id = "111"
>         Acct-Status-Type = Stop
>         Service-Type = Login-User
>         cisco-h323-gw-id = "h323-gw-id=AP200"
>         cisco-avpair = "h323-incoming-conf-id=CAAB3340 C428A942 80500002
> A4003761"
>         cisco-h323-call-origin = "h323-call-origin=answer"
>         cisco-h323-call-type = "h323-call-type=Telephony"
>         cisco-h323-setup-time = "h323-setup-time=18:15:38.000 UTC Wed Feb
> 18
> 2004"
>         cisco-h323-connect-time = "h323-connect-time=18:15:48.000 UTC Wed
> Feb 18 2004"
>         cisco-h323-disconnect-time = "h323-disconnect-time=18:15:58.000
> UTC
> Wed Feb 18 2004"
>         cisco-h323-disconnect-cause = "h323-disconnect-cause=10"
>         cisco-h323-voice-quality = "h323-voice-quality=0"
>         cisco-h323-conf-id = "h323-conf-id=CAAB3340 C428A942 80500002
> A4003761"
>         Acct-Session-Id = "00000002"
>         Acct-Input-Octets = 3710
>         Acct-Output-Octets = 7780
>         Acct-Input-Packets = 192
>         Acct-Output-Packets = 389
>         Acct-Session-Time = 10
> 
> So i have no problem to fill this attributes in the SQL database... But if
> i'm receiving the two kinds of radius packet format, can i hadle the two
> packets with the same instance of  Radiator?, maybe with different
> REALMS?..
> how can i do that... ?  Suppose that not only have one of each NAS device,
> instead i have 3 AS5300 and 2 NAS2 devices... ..
> 
> I really hope that someone can help me!..
> Thanks in advance.
> Best regards 
> 
>  
> 
> > Ricardo Javier Martinez Ogalde
> > Ingeniero de Desarrollo
> > VOISS NET S.A.
> > Cisco Certified Network Associate ,CCNA (CSCO 10643101)
> > *   :  (56 2) 240 81 96
> > *    :  (56 2) 245 74 95
> > *   :  rmartinez at redvoiss.net
> > 
> > 
> > 
> ===
> 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.
===
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