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.
