(RADIATOR) Ip Allocator error

[dave_vill]

sir,

 I was trying to set-up the radiator radius server as the one who will assign the ip address to the clients (dial-in-users) and im having a problem on error messages during the authentication process and i hope that you can help me regarding this matter. I am using a mssql database for storing the user names and passwords and already created a table for the RADPOOL. Pasted below is the error message and my config file.

Error Message:

Tue Oct 23 16:46:40 2001: DEBUG: Handling request with Handler 'Realm=DEFAULT'
Tue Oct 23 16:46:40 2001: DEBUG:  Deleting session for supercom, 192.168.254.1, 268435458
Tue Oct 23 16:46:40 2001: DEBUG: Handling with Radius::AuthSQL
Tue Oct 23 16:46:40 2001: DEBUG: Handling with Radius::AuthSQL: 
Tue Oct 23 16:46:40 2001: DEBUG: Query is: select PASSWORD from SUBSCRIBERS where USERNAME='test

Tue Oct 23 16:46:40 2001: DEBUG: Radius::AuthSQL looks for match with supercom
Tue Oct 23 16:46:40 2001: DEBUG: Radius::AuthSQL ACCEPT: 
Tue Oct 23 16:46:40 2001: DEBUG: Handling with Radius::AuthDYNADDRESS
Tue Oct 23 16:46:40 2001: DEBUG: Query is: select TIME_STAMP, YIADDR, SUBNETMASK, DNSSERVER from RADPOOL 
where POOL='' and STATE=0 order by TIME_STAMP

Tue Oct 23 16:46:40 2001: INFO: Access rejected for test: No available addresses
Tue Oct 23 16:46:40 2001: DEBUG: Packet dump:
*** Sending to 192.168.254.1 port 50000.......
Code:       Access-Reject
Identifier: 26
Authentic:  %<172>y<29>j<149>|<151>j<183>0c<11><195>;<163>
Attributes:
	Reply-Message = "Request Denied"


Config File:

<Client DEFAULT>
	Secret	mysecret
	DupInterval 0    
	IgnoreAcctSignature     
</Client>


<ClientListSQL>
	DBSource	dbi:ODBC:radius
	DBUsername	radius
	DBAuth		radius
</ClientListSQL>

<AddressAllocator SQL>
	
	Identifier ipallocator
	DBSource	dbi:ODBC:radius
	DBUsername	radius	
	DBAuth		radius

	DefaultLeasePeriod	86400
	LeaseReclaimInterval 86400

	#<AddressPool pool>
	#	Subnetmask	255.255.255.0
	#	Range	192.1.1.1 192.1.1.10
	#</AddressPool>
</AddressAllocator>



<Realm DEFAULT>

	AuthByPolicy ContinueWhileAccept
    <AuthBy SQL>
 	DBSource	dbi:ODBC:radius	
 	DBUsername	radius
 	DBAuth		radius

 	DefaultSimultaneousUse 1

 	AccountingTable	ACCOUNTING
	AcctColumnDef	USERNAME,User-Name
	AcctColumnDef	TIME_STAMP,Timestamp,integer-date
	AcctColumnDef	ACCTSTATUSTYPE,Acct-Status-Type
	AcctColumnDef	ACCTDELAYTIME,Acct-Delay-Time,integer
	AcctColumnDef	ACCTSESSIONID,Acct-Session-Id
	AcctColumnDef	ACCTSESSIONTIME,Acct-Session-Time,integer-date
	AcctColumnDef	ACCTTERMINATECAUSE,Acct-Terminate-Cause
	AcctColumnDef	NASIDENTIFIER,NAS-Identifier
	AcctColumnDef	NASPORT,NAS-Port
	AcctColumnDef	FRAMEDIPADDRESS,Framed-IP-Address
     </AuthBy>
	
<AuthBy DYNADDRESS>
		
	Allocator ipallocator		

</AuthBy>
	

</Realm>


<Log SQL>
	DBSource	dbi:ODBC:radius	
	DBUsername	radius
	DBAuth		radius

</Log SQL>



regards,
dave
, , 001029200011 ,
e-mail: davevill at cdo.philcom.com.ph


--
Do you VisualMail?

Grab a copy of the best WebMailer right now!

http://www.mintersoft.com/visualmail


===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.