(RADIATOR) Radiator not emptying RADPOOL

[Ayotunde Itayemi]

Hi All, Hi Hugh,

Radiator is not deleting entries in the RADPOOL table when users log off, hence it runs
out of IP addresses after about 30 successful logons based on a particular pool of 30 IP addresses.
I have tried both from a Patton RAS and also a windows 2K server
I have also tried it with  commenting out the DefaultLeasePeriod  and LeaseReclaimInterval
config options - no difference.

My config is as below (I have deleted a few sections):

Another question - I am authenticating my web server against radiator on the same box (separate
database table though) - anything I should know? Any problems?

================================================================
# Auth & Acct ports
AuthPort		1645
AcctPort		1646
# --- RADAR -------------------------
<Monitor>
	Username radpasswd
	Password radpasswd
</Monitor>
# Online users
<SessionDatabase SQL>
	Identifier SDB1
	DBSource	dbi:Oracle:myOraDB
	DBUsername 	orauser
	DBAuth 		orauser
</SessionDatabase>
# =======================================================
<AddressAllocator SQL>
        Identifier mySQLallocator
	DBSource	dbi:Oracle:myOraDB
	DBUsername 	orauser
	DBAuth 		orauser
        DefaultLeasePeriod     86400
#       LeaseReclaimInterval 86400
        <AddressPool pool1>
                Subnetmask      255.255.255.0
                Range   a.b.c.d a.b.c.z
        </AddressPool>
        <AddressPool pool2>
                Subnetmask      255.255.255.0
                Range   192.168.10.21 192.168.10.50
        </AddressPool>
        <AddressPool pool3>
                Subnetmask      255.255.255.0
                Range   a.b.e.a a.b.e.u
        </AddressPool>
</AddressAllocator>
# =================== CLIENTs   =================================
<Client a.b.c.a>
        Secret asecret
        DupInterval 0
        Identifier myras
	IdenticalClients a.b.c.c a.b.a.b a.b.k.c b.b.c.d c.d.a.c
</Client>
<Client a.d.d.a>
        Secret another
        DupInterval 0
        Identifier myras
</Client>
<Client 127.0.0.1>
# web server on this box
	Secret myapache
	DupInterval 0
	Identifier anapache
</Client>
# =================== AUTH BYs =================================
<AuthBy SQL>
        Identifier SQLStaffauth
        NoDefault
	DBSource	dbi:Oracle:myOraDB
	DBUsername 	orauser
	DBAuth 		orauser
        AuthSelect select PASSWORD, CHECKATTR from STAFF \
                where USERNAME = '%n' and STATUS = 'Enabled'
        AuthColumnDef   0,      User-Password,  check
        AuthColumnDef   1,      GENERIC,        check
        AuthColumnDef   2,      GENERIC,        reply
</Auth>
<AuthBy SQL>
	Identifier SQLClientauth
	NoDefault
	DBSource	dbi:Oracle:myOraDB
	DBUsername 	orauser
	DBAuth 		orauser
	AuthSelect select PASSWORD, CHECKATTR, REPLYATTR \
		from SUBSCRIBERS where USERNAME = '%n'
	AuthColumnDef	0,	User-Password,	check
	AuthColumnDef	1,	GENERIC,	check
	AuthColumnDef	2,	GENERIC,	reply
</Auth>
<AuthBy DYNADDRESS>
	Identifier myIPADDRESSauth
	Allocator mySQLallocator
	PoolHint %{Reply:PoolHint}
	MapAttribute   yiaddr, Framed-IP-Address
	MapAttribute   subnetmask, Framed-IP-Netmask
	StripFromReply PoolHint
	DefaultSimultaneousUse 1
</AuthBy>
#=================== HANDLERs   ================================
<Handler Client-Identifier=viruse2>
	AuthByPolicy ContinueWhileAccept
	RewriteUsername s/^([^@]+).*/$1/
	UsernameCharset a-zA-Z0-9\._ at -
	MaxSessions 1
	AcctLogFileName		%L/account.log
	PasswordLogFileName	%L/password.log
	SessionDatabase SDB1
	AuthBy SQLClientauth
	AuthBy myIPADDRESSauth
</Handler>
<Handler Client-Identifier=apache>
        AuthByPolicy ContinueWhileAccept
        RewriteUsername s/^([^@]+).*/$1/
        UsernameCharset a-zA-Z0-9\._ at -
        MaxSessions 1
        AuthBy SQLStaffauth
</Handler> 
<Handler>
	# default handler
	<AuthBy RADIUS>
	# Default values for all hosts. You can change them for a 
	# single host in a Host clause
	Secret mysecret
	RetryTimeout 1
	Retries 3
	# Hosts to send to are listed below
	<Host 203.63.154.2>
	</Host>
	<Host 203.63.154.3>
		BogoMips 2
	</Host>
	# This host has non-standard ports
	<Host 203.63.154.4>
		AuthPort 1647
		AcctPort 1648
	</Host>
</AuthBy>
</Handler>


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.open.com.au/pipermail/radiator/attachments/20020725/5de47c33/attachment.html>