<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2180" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hi </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> manage the Cisco
BTS 10200 system, and now i am assigned a task to work with the
Radius</SPAN><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman'"><?xml:namespace prefix =
o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p></SPAN></FONT>
<P class=MsoNormal><SPAN class=GramE><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">i</SPAN></FONT></SPAN><FONT
face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> choose the
FreeRadius to work with Cisco BTS system</SPAN></FONT><FONT
face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman'"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face=UVnTime size=4><o:p><SPAN class=GramE><FONT
face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">modify</SPAN></FONT></SPAN><FONT
face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> some config
in radiusd.conf & clients.conf </SPAN></FONT><FONT face="Times New Roman"
size=3><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman'"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><SPAN class=GramE><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">first</SPAN></FONT></SPAN><FONT
face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">, BTS send
message Access Request to FreeRadius and then Freeradius send message Access
Accept, they working properly</SPAN></FONT><FONT face="Times New Roman"
size=3><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman'"><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><SPAN class=GramE><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">when</SPAN></FONT></SPAN><FONT
face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"> BTS send
message Account Start to Radius, there are a lot attribute and freeradius save
them in the radacct table<o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman'"><o:p></P>
<P class=MsoNormal><SPAN class=GramE><FONT face=UVnTime size=4><SPAN
style="FONT-SIZE: 13pt"><SPAN
style="mso-bidi-font-size: 12.0pt">this</SPAN></SPAN></FONT></SPAN> is the
account start message structure:</P>
<P class=MsoNormal><FONT face=Arial size=2> Attribute
ID Vendor
ID Sub Attribute
ID Status
Attribute Name
Type
Value
<BR> 1
M- User-Name
String
ANI <BR> 4
M-
NAS-IP-Address
IP Address
BTS IP address <BR>
6
M-
Service-Type
Integer Service
Type = Outbound <BR>
25 C+ Class String CLASS
Attribute <BR></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2> 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.<BR></FONT></P>
<P class=MsoNormal><FONT face=Arial
size=2> <BR> <BR> 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.<BR><BR> <BR> 26
9
25 M-
h323-setup-time
String
hh:mm:ss.mmm ZON
DDD MMM ## YYYY Setup time in NTP format. </FONT></P><FONT face=Arial size=2>
<P class=MsoNormal><BR> 26
9
28
M- h323-connect-time
String
hh:mm:ss.mmm ZON DDD MMM ## YYYY
Connect time in NTP format. </P>
<P class=MsoNormal><BR> 26
9
27
M+
h323-call-type
String Telephony,VOIP
<BR>
30 C- Called-Station-ID
String
DNIS
<BR>
31 C+
Calling-Station-ID
String
ANI <BR> 40
M+
Acct-Status-Type
Integer
Acct-Status-Type =
Start (1) <BR> 44
M+
Acct-Session-ID
String
Accounting Session ID
<BR>
55 M+
Event-Timestamp
Integer
Event Time Stamp
<BR> 61
M- NAS-Port-Type Integer
Ethernet (15)
</FONT></P></o:p></SPAN></FONT>
<P class=MsoNormal><FONT face=UVnTime size=4><o:p> </o:p></FONT></P>
<P class=MsoNormal><SPAN class=GramE><FONT face=UVnTime size=4><SPAN
style="FONT-SIZE: 13pt"><SPAN
style="mso-bidi-font-size: 12.0pt">but</SPAN></SPAN></FONT></SPAN> 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 </P>
<P class=MsoNormal><FONT face=UVnTime size=4><SPAN style="FONT-SIZE: 13pt"><SPAN
style="mso-bidi-font-size: 12.0pt">what should i need to edit the sql.conf for
this <SPAN class=GramE>issue</SPAN></SPAN></SPAN></FONT></P>
<P class=MsoNormal><FONT face=UVnTime size=4><SPAN style="FONT-SIZE: 13pt"><SPAN
style="mso-bidi-font-size: 12.0pt">On the CDR Tool, what should i need to edit
to working properly</SPAN></SPAN></FONT></P>
<P class=MsoNormal><FONT face=UVnTime size=4><o:p> </o:p></FONT></P>
<P class=MsoNormal><FONT face=UVnTime size=4><o:p> </o:p></FONT></P>
<P class=MsoNormal><FONT face=UVnTime size=4><SPAN style="FONT-SIZE: 13pt"><SPAN
style="mso-bidi-font-size: 12.0pt">Thanks</SPAN></SPAN></FONT></P>
<P class=MsoNormal><FONT face=UVnTime size=4><o:p> </o:p></FONT></P>
<P class=MsoNormal><FONT face=UVnTime size=4><SPAN style="FONT-SIZE: 13pt"><SPAN
style="mso-bidi-font-size: 12.0pt">Ha`</SPAN></SPAN></FONT></P></o:p></FONT></DIV></BODY></HTML>