Hello SaJaRi -
On Thu, 05 Oct 2000, SaJaRi wrote:
> Hi there!
>
> We are trying to dynamically assign IP address by using the <AuthBy
> DYNADDRESS> and the <AddressAllocator>.
> We are using oracle database for the RADPOOL.
> The problem we facing is that the it can't seems to allocate an IP address
> from the radpool table.
> What we seeing is the select statement to retrive the (YIADDR> column
> always failed.
> He's what appear on the logfile:
>
> DEBUG: Query is: select YIADDR, SUBNETMASK,
> DNSSERVER from RADPOOL where POOL='' and STATE=0 order by TIME_STAMP
>
> ERR: Execute failed for 'select YIADDR,
> SUBNETMASK, DNSSERVER from RADPOOL where
> POOL='' and STATE=0 order by TIME_STAMP': ORA-03113: end-of-file on
> communication channel (DBD ERROR: OCIStmtExecute)
> Thu Oct 5 11:44:44 2000: INFO: Access rejected for gprs: No available
> addresses
>
> It's seems the POOL where statement is not right. On my configuration i
> gave the name as "pool" but the select statement is shows as pool=''.
> SO the result will always be "no row selected".
> Below is my configuration file. Anyone can spot a problem:
>
> <AddressAllocator SQL>
> Identifier SQLAllocator
> DBSource dbi:Oracle:xxxx
> DBUsername xxxxxxx
> DBAuth xxxxxxx
> <AddressPool pool>
> Subnetmask 255.255.255.255
> DNSServer xxx.xxx.xxx.xxx
> Range 192.168.1.1 192.168.1.10
> </AddressPool>
> </AddressAllocator>
>
> <Realm DEFAULT>
> AuthByPolicy ContinueWhileAccept
> <AuthBy FILE>
> Filename %D/users
> </AuthBy>
> # Log accounting to the detail file in LogDir
> AcctLogFileName %D/detail
> <AuthBy DYNADDRESS>
> Allocator SQLAllocator
> </AuthBy>
> </Realm>
>
> The users file :
>
> userid Password = "xxxxx"
> Service-Type = Framed-User,
> Framed-Protocol = PPP
>
You must tell the allocator which address pool to use, so
you will need to add the following to your user definition:
userid Password = "xxxxx"
Service-Type = Framed-User,
Framed-Protocol = PPP,
PoolHint = pool
And add this to your AuthBy DYNADDRESS clause:
<AuthBy DYNADDRESS>
Allocator SQLAllocator
StripFromReply PoolHint
</AuthBy>
Have a look at sections 6.39 and 6.40 in the Radiator 2.16.3 manual, as well as
the example configuration file in "goodies/addressallocator.cfg".
hth
Hugh
--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, Interbiller, TACACS+, PAM, external, etc, etc.
Available on Unix, Linux, FreeBSD, Windows 95/98/2000, NT, MacOS X.
===
Archive at http://www.starport.net/~radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
