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
Thx in advance!
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-----
===
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.
