Hello all,
I have downloaded and compiled rlm_sqlippool from
http://www.onlinebilling.ru/freeradius/rlm_sqlippool.tar.gz on the
freeradius-1.0.1-platform.
Unzip the tar-file to the freeradius-1.0.1-catalog and run rlm_sqlippool.sh.
Then only one modification has to be made:
change all references of PW_NAS_PORT_ID to PW_NAS_PORT in rlm_sqlippool.c
The tar-ball also includes some example config files.
Remarks: the subnet-declaration in radiusd.conf is not
the subnet returned to the client (usually 255.255.255.255, as with
rlm_ippool(?)) but the subnet for the IP-segment you wish to have in the
IP-pool. It took me some wild guessing to figure this one out :)
My radiusd.conf contains:
sqlippool main_pool_1 {
$INCLUDE ${confdir}/sqlippool.conf
sql-server = "192.168.1.10"
sql-login = "login"
sql-password = "password"
sql-db = "radius"
range-start = 192.168.10.0
range-stop = 192.168.13.255
netmask = 255.255.252.0
lease-duration = 86400
}
This way one can have several radius-servers working towards one or more
sql-servers, with all the essential information stored in the central database.
The "lease-duration" specifies how long an IP-address will "live" in the
database, in case the accounting-stop-packet is lost. After "lease-duration"
seconds, the IP-address will be unlocked.
More installation-tips can be found at
http://lists.cistron.nl/pipermail/freeradius-devel/2004-March/006951.html
Thanks to Ruslan A Dautkhanov for great work on this module. It saved my day :)
--
Med vennlig hilsen/Sincerely
Alfred H. Dahl
Hostmaster
Élla Kommunikasjon
Tlf: +47 3860 8575 Fax: +47 3860 8501
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
