Re: Need help on FreeRadius CDR Tool

2008-06-06 Thread Ivan Kalik
You probably want VoIP schema. It's in sql/postgresql/.

Ivan Kalik
Kalik Informatika ISP


Dana 6/6/2008, Do Nguyen Ha [EMAIL PROTECTED] piše:

Hi 

 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


this is the account start message structure:

Attribute ID Vendor ID Sub Attribute ID Status 
  Attribute Name  Type  Value 
1  
 M-  User-Name  String 
  ANI 
4  
 M-  NAS-IP-Address  IP Address
   BTS IP address 
6  
 M-  Service-Type   Integer
 Service Type = Outbound 
25 
C+  Class String   
  CLASS Attribute 


26  9  1   
   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  24  
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  25  
M-  h323-setup-time  String
   hh:mm:ss.mmm  ZON DDD MMM ##  Setup time in NTP format. 


26  9  28  
 M- h323-connect-time  String  
 hh:mm:ss.mmm  ZON DDD MMM ##  Connect time in NTP format. 


26  9  27  
 M+  h323-call-type  String
  Telephony,VOIP 
30 
   C-Called-Station-ID  String 
  DNIS 
31 
   C+  Calling-Station-ID  String  
 ANI 
40 
  M+   Acct-Status-Type Integer
   Acct-Status-Type = Start (1) 
44 
  M+  Acct-Session-IDString
   Accounting Session ID 
55 
  M+  Event-Timestamp  Integer 
  Event Time Stamp 
61 
  M-NAS-Port-TypeInteger   
Ethernet (15) 

 

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 

what should i need to edit the sql.conf for this issue

On the CDR Tool, what should i need to edit to working properly

 

 

Thanks

 

Ha`



-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html


Need help on FreeRadius CDR Tool

2008-06-05 Thread Do Nguyen Ha
Hi 

 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


this is the account start message structure:

Attribute ID Vendor ID Sub Attribute ID Status  
Attribute Name  Type  Value 
1   
   M-  User-Name  String
  ANI 
4   
   M-  NAS-IP-Address  IP Address   
   BTS IP address 
6   
   M-  Service-Type   Integer   
 Service Type = Outbound 
25  
  C+  Class String  
  CLASS Attribute 


26  9  1
 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  24   
  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  25   
  M-  h323-setup-time  String   
   hh:mm:ss.mmm  ZON DDD MMM ##  Setup time in NTP format. 


26  9  28   
   M- h323-connect-time  String 
 hh:mm:ss.mmm  ZON DDD MMM ##  Connect time in NTP format. 


26  9  27   
   M+  h323-call-type  String   
  Telephony,VOIP 
30  
 C-Called-Station-ID  String
  DNIS 
31  
 C+  Calling-Station-ID  String 
 ANI 
40  
M+   Acct-Status-Type Integer   
   Acct-Status-Type = Start (1) 
44  
M+  Acct-Session-IDString   
   Accounting Session ID 
55  
M+  Event-Timestamp  Integer
  Event Time Stamp 
61  
M-NAS-Port-TypeInteger  
Ethernet (15) 

 

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 

what should i need to edit the sql.conf for this issue

On the CDR Tool, what should i need to edit to working properly

 

 

Thanks

 

Ha`
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html