NAS IP address for usergroup

[Alan DeKok]

On Sep 4, 2015, at 10:35 AM, Tevfik Ceydeliler <tevfik.ceydeliler at 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.