Hi, I can assign IP address to user from sql ip pool But Cant assign static IP address to user mysql> select * from radcheck where username like 'kivanccepel1' ; +-----+--------------+--------------------+----+---------+ | id | username | attribute | op | value | +-----+--------------+--------------------+----+---------+ | 211 | kivanccepel1 | Cleartext-Password | := | test | | 212 | kivanccepel1 | Proxy-to-Realm | := | secovid | +-----+--------------+--------------------+----+---------+ and mysql> select *from radreply; +----+--------------+-------------------+----+--------------+ | id | username | attribute | op | value | +----+--------------+-------------------+----+--------------+ | 1 | kivanccepel1 | Framed-IP-Address | := | 172.30.80.50 | | 2 | kivanccepel1 | Service-Type | := | Framed-User | +----+--------------+-------------------+----+--------------+ and log is like that: [sql] expand: SELECT id, username, attribute, value, op FROM radreply WHERE username = '%{SQL-User-Name}' ORDER BY id -> SELECT id, username, attribute, value, op FROM radreply WHERE username = 'kivanccepel1' ORDER BY id [sql] expand: SELECT groupname FROM radusergroup WHERE username = '%{SQL-User-Name}' ORDER BY priority -> SELECT groupname FROM radusergroup WHERE username = 'kivanccepel1' ORDER BY priority rlm_sql (sql): Released sql socket id: 2 ++[sql] returns ok ++[expiration] returns noop ++[logintime] returns noop ++[pap] returns noop WARNING: Empty pre-proxy section. Using default return values. Sending Access-Request of id 184 to 10.1.1.51 port 1812 User-Name = "kivanccepel1" User-Password = "475210071074" NAS-IP-Address = 10.65.8.117 Proxy-State = 0x30 Proxying request 2 to home server 10.1.1.51 port 1812 Sending Access-Request of id 184 to 10.1.1.51 port 1812 User-Name = "kivanccepel1" User-Password = "475210071074" NAS-IP-Address = 10.65.8.117 Proxy-State = 0x30 Going to the next request Waking up in 0.9 seconds. rad_recv: Access-Accept packet from host 10.1.1.51 port 1812, id=184, length=23 Proxy-State = 0x30 # Executing section post-proxy from file /etc/freeradius/sites-enabled/default +- entering group post-proxy {...} [eap] No pre-existing handler found ++[eap] returns noop Found Auth-Type = Accept Auth-Type = Accept, accepting the user # Executing section post-auth from file /etc/freeradius/sites-enabled/default +- entering group post-auth {...} [sqlippool] No Pool-Name defined. [sqlippool] expand: No Pool-Name defined (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name}) -> No Pool-Name defined (did cli port user kivanccepel1) No Pool-Name defined (did cli port user kivanccepel1) ++[sqlippool] returns noop ++[exec] returns noop Sending Access-Accept of id 0 to 10.65.8.117 port 54732 Finished request 2. Going to the next request Waking up in 4.9 seconds. Cleaning up request 2 ID 0 with timestamp +230 Ready to process requests. What is missing? Regards... <br> <img src="http://www.yasar.com.tr/banner/yhbanner.jpg"> </img> <br><br> Bu elektronik postada bulunan tum fikir ve gorusler ve ekindeki dosyalar sadece adres sahip/sahiplerine ait olup, Yasar Toplulugu Sirketleri bu mesajin icerigi ile ilgili olarak hic bir hukuksal sorumlulugu kabul etmez. Eger gonderilmesi dusunulen kisi veya kurulus degilseniz, lutfen gonderen kisiyi derhal haberdar ediniz ve mesaji sisteminizden siliniz.The information contained in this e-mail and any files transmitted with it are intended solely for the use of the individual or entity to whom they are addressed and Yasar Group Companies do not accept legal responsibility for the contents. If you are not the intended recipient, please immediately notify the sender and delete it from your system.