Dears, I am using freeradius with wichorus ASN-GW (WiMAX), I have problem with Calling-Station-Id value
The ASN-GW sent Calling-Station-Id in binary format like this "\000&\031\001\000K" I checked the debug radius -X result and I found the AAA got the correct value for Calling-Station-Id but when insert it to database it's will be empty value like Calling-Station-Id='' (Empty Value) What's the problem? And how can insert the Calling-Station-Id value to radacct table? The SQL statement for accounting_start_query for example is: accounting_start_query = "INSERT into ${acct_table1} (AccStatusType, AcctSessionId, AcctUniqueId, UserName, \ NASIPAddress, NASPortId, NASPortType, WiMAXGMTTimezoneoffset, WiMAXBSId, EventTimestamp, CallingStationId, \ AcctStartTime, AcctStopTime, AcctSessionTime, AcctInputOctets, \ AcctOutputOctets, AcctTerminateCause, FramedIPAddress ) \ select '%{Acct-Status-Type}', '%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', \ '%{SQL-User-Name}', '%{NAS-IP-Address}', '%{NAS-Port}', '%{NAS-Port-Type}', '%{WiMAX-GMT-Timezone-offset}', \ '%{WiMAX-BS-Id}', '%{Event-Timestamp}', '%{Calling-Station-Id}', '%S', '0', '0', '0', '0','', \ '%{Framed-IP-Address}' from dual where not exists (select * from ${acct_table1} where UserName='%{SQL-User-Name}' and AcctSessionId='%{Acct-Session-Id}' \ and AcctStartTime='%S')" Regards, Moayad
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html