Wrong Called-station-id in Mysql

Marco Ramian myxmail1919 at yahoo.com
Fri Dec 22 10:54:40 CET 2017


Hi Guys,

Need your help please.
i see the right called-station-id  in freeradius Logs. but in Mysql table the wrong one,
almost all the time (90%) see the same Mac address ( 28-6f-7f-ef-f3-33 ) as called station id in mysql ! but see right one in freeradius logs ! 
what can be the problem ? 

FreeRadius Logs :

Fri Dec 22 10:10:00 2017 : Auth: Login OK: [  "e05f45657d2d/e05f45657d2d] (from client BUS port 1 cli e0-5f-45-65-7d-2d) 04-62-73-9b-19-e0:@MobiConnect-freeWiFi

 Mysql:
"radacctid" "acctsessionid" "acctuniqueid" "username" "groupname" "realm" "nasipaddress" "nasportid" "nasporttype" "acctstarttime" "acctstoptime" "acctsessiontime" "acctauthentic" "connectinfo_start" "connectinfo_stop" "acctinputoctets" "acctoutputoctets" "calledstationid" "callingstationid" "acctterminatecause" "servicetype" "framedprotocol" "framedipaddress" "acctstartdelay" "acctstopdelay" "xascendsessionsvrkey""789" "5a3cd47c/e0:5f:45:65:7d:2d/568133" "86da51b5fbcb4136" "e0-5f-45-65-7d-2d" "" "" "172.25.31.68" "1" "Wireless-802.11" "2017-12-22 10:46:39" \N "0" "RADIUS" "" "" "0" "0" "28-6f-7f-ef-f3-33" "e0-5f-45-65-7d-2d" "" "" "" "172.16.67.157" "0" "0" ""

Thank you 


More information about the Freeradius-Users mailing list