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 ## 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` > > - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
