For those working with sqlippool, I made a quick script which will make it easy for you to create the ip blocks in the radippool table. Might be nice for new users if this was included in the scripts directory. #!/bin/sh # This script will output the necessary INSERT commands # for the sqlippool module in freeradius # Enter the pool name attribute POOL_NAME=your_pool_name # Set the first 2 octets of the IP network NETWORK=1.1 # Set the starting point of the third octet START_RANGE=1 # Set the ending point of the third octet END_RANGE=254 # Set the starting point of the fourth octet MIN_IP=1 # Set the ending point of the fourth octet MAX_IP=254 ######################################################################## # ######################################################################## # # Make sure that END_RANGE is higher than START_RANGE if [ $START_RANGE -gt $END_RANGE ] ; then echo "ERROR: Then ending range must be higher than the starting range." exit 1 fi SUBNET=$START_RANGE IP=$MIN_IP count=0 while [ true ]; do if [ $IP -gt $MAX_IP ] ; then if [ $SUBNET -eq $END_RANGE ] ; then exit 0; else SUBNET=$(( $SUBNET + 1 )) IP=$MIN_IP fi fi echo "INSERT INTO radippool (pool_name, FramedIPAddress) VALUES ('$POOL_NAME', '$NETWORK.$SUBNET.$IP');" IP=$(( $IP + 1 )) done; exit 0