Calling-Station-Id Empty value

[Moayad Mohammad]

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20101013/273d4a7e/attachment.html>