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`