Need help on FreeRadius & CDR Tool

[Ivan Kalik]

You probably want VoIP schema. It's in sql/postgresql/.

Ivan Kalik
Kalik Informatika ISP


Dana 6/6/2008, "Do Nguyen Ha" <hadn at fpt.net> 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 ## YYYY Setup time in NTP format. 
>
>
>    26                          9                          28                          M-             h323-connect-time                  String                      hh:mm:ss.mmm  ZON DDD MMM ## YYYY 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-ID                    String                          Accounting Session ID 
>    55                                                                                  M+              Event-Timestamp                  Integer                          Event Time Stamp 
>    61                                                                                  M-                NAS-Port-Type                    Integer                          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`
>
>