Useful sqlippool script

[Roy Walker]

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20070703/ed8d511b/attachment.html>