Hi there!
Nope.
The problem was not with oracle. It just that all the necessary oracle env
need to in place like ORACLA_HOME and ORACLE_SID before running radiator.
Now the error still appear but only for the very first assign of IP
address and do not appear anymore for the subsequent ip address assigment.
Not sure why but i guess i can live with that.
The pointer was givin by one of the mailing list member Alexey A.
Shavaldin. Thank You very much.
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 19 Jan 2001, Mike McCauley wrote:
> Hello,
> this looks very odd. It seems as if your Oracle is trying to print an error,
> and some problem in the Oracle configuration is preventing the error message
> being found.
> I suggest you try running the query:
> select YIADDR, SUBNETMASK,
> DNSSERVER from RADPOOL where POOL='pool' and STATE=0 order by TIME_STAMP
>
> by hand in sqlplus to see what it says. If you get the same error message
> there may be a problem with your Oracle installation.
>
> Hope that helps.
> Cheers.
>
> ----------------------------------------------------------------------------
> ---------------
> Mike McCauley [EMAIL PROTECTED]
> Open System Consultants +61 3 9598 0985
>
> I am travelling right now, and there may be delays
> in our correspondence.
> -----Original Message-----
> From: Hugh Irvine <[EMAIL PROTECTED]>
> To: SaJaRi <[EMAIL PROTECTED]>; [EMAIL PROTECTED]
> <[EMAIL PROTECTED]>
> Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
> Date: Friday, January 19, 2001 5:40 AM
> Subject: Re: (RADIATOR) AuthBy DYNADDRESS
>
>
> >
> >Hello SaJaRi -
> >
> >I have forwarded this mail to Mike, as I don't have the answer.
> >
> >regards
> >
> >Hugh
> >
> >At 17:32 +0800 01/1/18, SaJaRi wrote:
> >>Hi there!
> >>
> >>I've setup the radiator to assigned ip address upon successful
> >>authentication using the AuthBy DYNADDRESS & AddressAllocator.
> >>I'mm using Oracle database for the Radpool table.
> >>Everything seems to work perfect but there seems to be an error on the
> >>logfile each time it goes through the AuthBy DYNADDRESS.
> >>Below is what appear on the log:
> >>
> >>Thu Jan 18 16:35:39 2001: DEBUG: Handling with Radius::AuthDYNADDRESS
> >>Thu Jan 18 16:35:39 2001: DEBUG: Query is: select YIADDR, SUBNETMASK,
> >>DNSSERVER from RADPOOL where POOL='pool' and STATE=0 order by TIME_STAMP
> >>
> >>Thu Jan 18 16:35:39 2001: ERR: Execute failed for 'select YIADDR,
> >>SUBNETMASK, DNSSERVER from RADPOOL where POOL='pool' and STATE=0 order by
> >>TIME_STAMP': Error while trying to retrieve text for error ORA-03113 (DBD
> >>ERROR: OCIStmtExecute/Describe)
> >>
> >>Thu Jan 18 16:35:39 2001: DEBUG: do query is: update RADPOOL set STATE=1,
> >>TIME_STAMP=979864539,
> >>EXPIRY=979950939, USERNAME='96672513' where YIADDR='10.250.247.10'
> >>
> >
> >
> >
> >
> >--
> >
> >NB: I am travelling this week, so there may be delays in our
> correspondence.
> >
> >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.
>
===
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.
