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