[RADIATOR] Oracle 10g client library configuration

[Dilliraj]

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.