(RADIATOR) ORA-03113 when first FindQuery is prepared / is "foreground" a solution?
mikem at open.com.au
Thu Jun 26 05:42:30 CDT 2003
Hello Rainer ,
On Thu, 26 Jun 2003 08:05 pm, Huber, Rainer wrote:
> Hi List!
> I've played around with IP-Addressassignement by RADIUS - I've used
> Addressallocator SQL
> The Environment is
> Solaris 8
> Perl 5.6.1
> Perl DBI 1.21
> DBD-Oracle-1.12 (Problem with java stuff solved by preloading the
> Radiator 2.19
> Since the first time I started my config, I got a ORA-03113, when the first
> request arrived that triggers a FindQuery (sql prepare is the problem). All
> following requests work well and there are no problems with the database
> connection at all. At first I integrated the IP-Assignment into an existing
> config and I thought that the error is in one of the hooks or in modules
> set up, but then I also got the error with a quite simple setup
> On startup of the process, the reclaimquerie is executed, which works well
> (lets say with Handler A). As already mentionened, only the first SELECT
> failes (Handler A is available (Hash), but it seems to be unuseable for any
> I also took a look at the DBI-Trace 5, but I could not find a reason for
> the unuseable dbh.
> I've played around with the parameters in the config file and suddenly
> there was no ORA any more, after I've enabled the "Foreground" parameter.
> => Surprise
> Hugh pointed me to the List archive and I've found the following thread
> covering my problem
> I see three possibilities to "solve" the problem:
> *) ignore the ORA
> *) start radiator with the "Foregroud" option set and with
> a & and nohup in the init script
> Due to the messages I found I assume that you (who have also this problem)
> ignore the ORA - am i right?
> @High/Mike: Is there any differece in the behaviour of radiator when
> Foreground is acivated (performance, ...)
Should be no difference, providing there is no logging to stdout.
> I'll also try to extract the radius part of the oracle client libraries,
> which is implented in java and which needs the libthread.so.1 => maybe this
> has a side effect on radiator (=> see README.java in the DBD-Oracle CPAN
> module for more information about this)
> Any other suggestions?
> Rainer Huber
> Archive at http://www.open.com.au/archives/radiator/
> Announcements on radiator-announce at open.com.au
> To unsubscribe, email 'majordomo at open.com.au' with
> 'unsubscribe radiator' in the body of the message.
Mike McCauley mikem at open.com.au
Open System Consultants Pty. Ltd Unix, Perl, Motif, C++, WWW
24 Bateman St Hampton, VIC 3188 Australia http://www.open.com.au
Phone +61 3 9598-0985 Fax +61 3 9598-0955
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, TACACS+, PAM, external, Active Directory, EAP, TLS,
TTLS, PEAP etc on Unix, Windows, MacOS etc.
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.
More information about the radiator