[RADIATOR] Oracle 10g client library configuration

[Hugh Irvine]

Hello Dilliraj -

The best thing to do is configure restartWrapper to send you mail when  
the crash occurs so you can see the reason.

You can also configure restartWrapper for a shorter delay than the  
default 10 seconds.

See section 16.1 in the Radiator 4.31. reference manual ("doc/ref.pdf").

regards

Hugh


On 7 Dec 2008, at 01:43, Dilliraj wrote:

>
> Hello Hugh,
> I was having same problem. I was using DBI-1.607, DBD-Oracle-1.22,  
> Oracle10g
> instant client and radiator version 4.3.1 on my Linux server.  
> Previously as
> my backend database become unavailable I use to get error as
> " Could not connect to any SQL database. Request is ignored. Backing  
> off for
> 600 seconds"
> and my radius never restores although database become online.
>
> I downgraded DBI and DBD-oracle as you have mentioned. I noticed one  
> thing.
> On the first radius request after my database is offline the radius  
> process
> get killed. I checked with ps ax and I could not find the process  
> running
> and I checked with netstat -an I did not find my port listening. Few  
> minute
> later, radius process is get restarted by restartwrapper.
>
> Is there any method to get the service restored on such situation  
> beside the
> wrapper?
> Can't we restore the service on availability of database immediately?
>
>
> Hugh Irvine wrote:
>>
>>
>> Hello Everyone -
>>
>> Following up to this, I have discovered that the most recent versions
>> of DBI/DBD-Oracle were the problem.
>>
>> I have gone back from DBI-1.607 to DBI-1.46 and DBD-Oracle-1.22 to
>> DBD-Oracle-1.16 and the problem has been resolved.
>>
>> Hope this is useful to someone.
>>
>> regards
>>
>> Hugh
>>
>>
>> On 22 Sep 2008, at 11:25, Hugh Irvine wrote:
>>
>>>
>>> Hello Everyone -
>>>
>>> I am currently working on a customer site and we are having some
>>> problems with connecting Radiator 4.3.1 to Oracle 10g on Solaris 10.
>>>
>>> Radiator connects and runs fine as long as the database is  
>>> available.
>>>
>>> The Oracle database runs on a Solaris 10 cluster backend, with
>>> Radiator running on multiple separate Solaris 10 frontends.
>>>
>>> DBI and DBD-Oracle are the latest versions available from CPAN.
>>>
>>> The problem manifests itself when the backend database becomes
>>> unavailable and Radiator times out and backs off - but then never
>>> recovers.
>>>
>>> We have tested the same Radiator version on a different host with
>>> Solaris 9 and the Oracle 9i client libraries against the same
>>> Oracle 10g backend and this works correctly.
>>>
>>> Does anyone have a similar installation who can give me the magic
>>> required to successfully use the Oracle 10g client libraries?
>>>
>>> Otherwise we will have to install the Oracle 9i libraries, which is
>>> not really ideal.
>>>
>>> I'll post a followup to let you know the eventual outcome.
>>>
>>> many thanks
>>>
>>> Hugh
>>>
>>>
>>>
>>> NB:
>>>
>>> Have you read the reference manual ("doc/ref.html")?
>>> Have you searched the mailing list archive (www.open.com.au/
>>> archives/radiator)?
>>> Have you had a quick look on Google (www.google.com)?
>>> Have you included a copy of your configuration file (no secrets),
>>> together with a trace 4 debug showing what is happening?
>>> Have you checked the RadiusExpert wiki:
>>> http://www.open.com.au/wiki/index.php/Main_Page
>>>
>>> -- 
>>> Radiator: the most portable, flexible and configurable RADIUS server
>>> anywhere. Available on *NIX, *BSD, Windows, MacOS X.
>>> Includes support for reliable RADIUS transport (RadSec),
>>> and DIAMETER translation agent.
>>> -
>>> Nets: internetwork inventory and management - graphical, extensible,
>>> flexible with hardware, software, platform and database  
>>> independence.
>>> -
>>> CATool: Private Certificate Authority for Unix and Unix-like  
>>> systems.
>>>
>>>
>>> _______________________________________________
>>> radiator mailing list
>>> radiator at open.com.au
>>> http://www.open.com.au/mailman/listinfo/radiator
>>
>>
>>
>> NB:
>>
>> Have you read the reference manual ("doc/ref.html")?
>> Have you searched the mailing list archive (www.open.com.au/archives/
>> radiator)?
>> Have you had a quick look on Google (www.google.com)?
>> Have you included a copy of your configuration file (no secrets),
>> together with a trace 4 debug showing what is happening?
>> Have you checked the RadiusExpert wiki:
>> http://www.open.com.au/wiki/index.php/Main_Page
>>
>> -- 
>> Radiator: the most portable, flexible and configurable RADIUS server
>> anywhere. Available on *NIX, *BSD, Windows, MacOS X.
>> Includes support for reliable RADIUS transport (RadSec),
>> and DIAMETER translation agent.
>> -
>> Nets: internetwork inventory and management - graphical, extensible,
>> flexible with hardware, software, platform and database independence.
>> -
>> CATool: Private Certificate Authority for Unix and Unix-like systems.
>>
>>
>> _______________________________________________
>> radiator mailing list
>> radiator at open.com.au
>> http://www.open.com.au/mailman/listinfo/radiator
>>
>>
>
> -- 
> View this message in context: http://www.nabble.com/-RADIATOR--Oracle-10g-client-library-configuration-tp19603743p20852464.html
> Sent from the Radiator - General mailing list archive at Nabble.com.
>
> _______________________________________________
> radiator mailing list
> radiator at open.com.au
> http://www.open.com.au/mailman/listinfo/radiator



NB:

Have you read the reference manual ("doc/ref.html")?
Have you searched the mailing list archive (www.open.com.au/archives/radiator)?
Have you had a quick look on Google (www.google.com)?
Have you included a copy of your configuration file (no secrets),
together with a trace 4 debug showing what is happening?
Have you checked the RadiusExpert wiki:
http://www.open.com.au/wiki/index.php/Main_Page

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows, MacOS X.
Includes support for reliable RADIUS transport (RadSec),
and DIAMETER translation agent.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
-
CATool: Private Certificate Authority for Unix and Unix-like systems.