On Sep 4, 2015, at 10:35 AM, Tevfik Ceydeliler <tevfik.ceydeliler@astron.yasar.com.tr> wrote:
... rad_recv: Access-Request packet from host 10.1.1.27 port 1457, id=6, length=56 User-Name = "tevfikceydeliler" User-Password = "Test01" # Executing section authorize from file /etc/freeradius/sites-enabled/default +- entering group authorize {...} sql_xlat expand: %{User-Name} -> tevfikceydeliler sql_set_user escaped user --> 'tevfikceydeliler' expand: SELECT groupname FROM radhuntgroup WHERE nasipaddress='%{NAS-IP-Address}' -> SELECT groupname FROM radhuntgroup WHERE nasipaddress='' rlm_sql (sql): Reserving sql socket id: 4 SQL query did not return any results rlm_sql (sql): Released sql socket id: 4 expand: %{sql:SELECT groupname FROM radhuntgroup WHERE nasipaddress='%{NAS-IP-Address}'} -> ++[reply] returns notfound
Why nasipaddress comes empty?
Is there a NAS-IP-Address in the packet? I suggest reading the debug output you post to the list. Alan DeKok.