Peter . as per your postgres 1.1.7 sqlippool queries, I changed the MySQL ones to use %{SQL-User-Name} instead of %{User-Name} . only it doesn't seem to pick up a value, so the UserName is coming up blank in the radippool table.
Example: sqlippool_expand: 'UPDATE radippool SET expiry_time = NOW() + INTERVAL 3600 SECOND WHERE NASIPAddress = '%{Nas-IP-Address}' AND pool_key = '%{Calling-Station-Id}' AND UserName = '%{SQL-User-Name}' AND CallingStationId = '%{Calling-Station-Id}' AND FramedIPAddress = '%{Framed-IP-Address}'' radius_xlat: 'UPDATE radippool SET expiry_time = NOW() + INTERVAL 3600 SECOND WHERE NASIPAddress = '216.108.219.36' AND pool_key = '00:14:6C:37:16:49' AND UserName = '' AND CallingStationId = '00:14:6C:37:16:49' AND FramedIPAddress = '172.168.124.120'' This happens on both 1.1.6 and 1.1.7. Should that be something like %{control:SQL-User-Name} ? My apologies - I don't know how I missed this when testing yesterday. I guess it returned an IP just fine, so I didn't actually look at what it was doing too closely! -- hugh
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html