Marek Bartnikowski <[EMAIL PROTECTED]> wrote: > and this is ok. user john, has cable modem which IP is 10.23.31.101. > > BUT! > > in next lines I see query like that: > > SELECT id,UserName,Attribute,Value,op, ip FROM v_wifi_auth WHERE > Username = 'john' and ip='127.0.0.1' ORDER BY id ;
Yes. The NAS-IP-Address is put into the RADIUS packet by the NAS, and it can have ANY value. > I don't want 127.0.0.1 in my db queries. > where can I 'disable' asking for ip 127.0.0.1? You can't. It's the value of NAS-IP-Address. If you look at the debug log, you will see that the NAS is sending that value to the server. The solution is to NOT use NAS-IP-Address, but Client-IP-Address. It's the IP address that the packet came from, and it's generated by FreeRADIUS, so you know it's correct. Alan DeKok. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
