Hi there!
Got it.
Thx!
Cheers!
*************************
Sajari Bin Sarkan *
SingNet Network Support *
*************************
-----BEGIN PGP PUBLIC KEY BLOCK-----
Version: 2.6.i
mQBtAjc9fI4AAAEDAMx6kkJcuhMq9TJEecb3JaiHe6fHRMlaVX/5Om7eCi2xdONO
HfVeuTUryabhb7J2mRgKo7z4YWoNxOdNdDtRVaMfD7H18mdV0KYvlR/+9NAgKGxi
UEaOYPJsKNHWCAKV1QAFEbQeU2FKYVJpIDxzYWphcmlAc2luZ25ldC5jb20uc2c+
=gG2n
-----END PGP PUBLIC KEY BLOCK-----
On Fri, 6 Oct 2000, Hugh Irvine wrote:
>
> 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.
