[RADIATOR] Radiator not reconnecting to database.

[Hugh Irvine]

Hello Ricardo -

The most recent version is Radiator 4.5.1.

You should probably test with Radiator 4.5.1 and you should also test the the Perl DBD-Oracle module you are using.

We have had reports of problems with various versions of the Perl DBD-Oracle module.

regards

Hugh


On 4 Dec 2009, at 01:40, Ricardo Martinez wrote:

> Hello list.
> I wonder why the next situation is happening.
> The Radiator is inserting accounting records in a Oracle DB.  At certain point the ORACLE database stop answering and is down.  This is what I see :
>  
> FF 06:02:53 2009: ERR: do failed for 'insert into ACCT (ACCESS_DEVICE,...',sysdate,0,'0')': SQL Timeout
> FF 06:02:55 2009: ERR: do failed for 'insert into ACCT (ACCESS_DEVICE,...',sysdate,0,'0')': ORA-03113: end-of-file on communication channel (DBD ERROR: OCIStmtExecute)
> FF 06:02:55 2009: DEBUG: AuthBy SQL result: IGNORE, Database failure
> FF 06:02:55 2009: DEBUG: Packet dump:
>  
> Radiator stop answering any accounting packets and it stay freeze until the process is restarted.
> I have the command “FailureBackoffTime      60” set in the configuration file.
>  
> I was expecting something like a radiator reconnection to the database and start to see logs like this :
>  
> FF 06:04:41 2009: ERR: Could not connect to any SQL database. Request is ignored. Backing off for 60 seconds
>  
> Instead I have Radiator not answering any request.
>  
> BTW, I’m using Radiator 3.13
>  
> Can someone help me here?
> Thanks
>  
> Regards,
> Ricardo Martinez.-
>  
> _______________________________________________
> 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?

-- 
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.