[OpenSER-Users] need help on FreeRadius & CDRTools

[Do Nguyen Ha]

hi 
 
i manage the Cisco BTS 10200 system, and now i am assigned a task to work with the Radius
i choose the FreeRadius to work with Cisco BTS system

modify some config in radiusd.conf & clients.conf 
first, BTS send message Access Request to FreeRadius and then Freeradius send message Access Accept, they working properly
when BTS send message Account Start to Radius, there are a lot attribute and freeradius save them in the radacct table

the messages flow:

	BTS				FreeRadius

	-----Service Authorize------>   
	<-------Access Accept--------  
	-----Service Start----------->   
	<-----Account Respone ----
	----Service ReAuthorize---->
	<-------Account Accept------>
	-----Service Stop------------->
	<-------Account Respone----

but in radacct , there some columm doesn't match with the message Account Start, i want to change the name of some columm to match the message 
 
Should i need to edit the sql.conf for this issue
On the CDR Tool, should i need to edit to working properly

Attribute
Vendo
Sub 
Status
Attribute Name 
Type 
Value 
ID 
ID 
Attribut
 M- 
 User-Name  
 String  
ANI 
1
   
ID 
 M- 
 NAS-IP-Address  
 IP ddres
BTS IP address 
4
   
   
 M- 
 Service-Type  
 Integer  
Service Type = Outbound 
6
   
   
 C+ 
 Class  
 String  
CLASS Attribute 
25
   
   
 M- 
h323-incoming-conf-id=value 

String  
A unique number for identifying a calling session on a gateway, where a session is closed when the calling party hangs up.
26
9
1
 M- 
 h323-conf-id  
 String  
Unique call identifier generated by 
the BTS. Used to distinguish the separate billable events (calls) within a single calling session.
26
9
24
 M- 
 h323-setup-time  
 String  
hh:mm:ss.mmm  ZON DDD MMM 
## YYYY Setup time in NTP format. 
26
9
25
 M+ 
 h323-connect-time  
String  
hh:mm:ss.mmm  ZON DDD MMM 
## YYYY Connect time in NTP format.
26
9
28
 C-  
h323-call-type 
 String  
Telephony,VOIP 
30
   
27
 C+ 
 Called-Station-ID  
 String  
DNIS 
31
   
   
 M+ 
 Calling-Station-ID  
 Integer  
ANI 
40
   
   
 M+ 
 Acct-Status-Type  
 String  
Acct-Status-Type = Start (1)
44
   
   
 M+ 
 Acct-Session-ID  
 Integer  
Accounting Session ID 
55
   
   
 M- 
 Event-Timestamp  
 Integer  
Event Time Stamp
61
   
   
M-
 NAS-Port-Type  
Integer 
Ethernet (15)



























Thanks

Ha`
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.kamailio.org/pipermail/users/attachments/20080605/20e1f4f8/attachment.htm