(RADIATOR) [BUG] radiator diing on sql db timeout

[Hugh Irvine]

Hello Alexander -

I suggest you use the restartWrapper utility we supply with Radiator  
to make sure that radiusd gets restarted in case of a crash.

You can also configure restartWrapper to send mail with any Perl  
error messages so you can see what caused the crash.

See section 15.1 in the Radiator 3.17.1 refrerence manual ("doc/ 
ref.html").

You will find restartWrapper in the "goodies" directory of the  
distribution.

To say any more I will need to see a trace 4 debug from Radiator  
together with any error messages from radiusd.

I will also need to see your configuration file and any other  
relevant information such as hardware/software platform and so on.

regards

Hugh


On 10 Jun 2007, at 19:44, Hartmaier Alexander wrote:

> Hi!
>
>
>
> The Radiator processes on our radius servers died yesterday night  
> after this message (different timestamp on both servers):
>
>
>
> Sat Jun  9 22:09:56 2007: ERR: do failed for 'DELETE FROM radonline  
> WHERE nasidentifier='x.x.x.x' AND nasport='954'': SQL Timeout
>
>
>
> It seems that the SQL Timeout triggered it.
>
>
>
> With best regards
>
> Alexander Hartmaier
>
>
>
> T-Systems Austria GesmbH
>
> Rennweg 97-99
>
> A-1030 Vienna
>
>
>
> phone: +43-(0)57057-4320
>
> mobile: +43-(0)676-8642-4320
>
>
>
> *"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*" 
> *"*"*"*
> T-Systems Austria GesmbH Rennweg 97-99, 1030 Wien
> Handelsgericht Wien, FN 79340b
> *"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*" 
> *"*"*"*
> Notice: This e-mail contains information that is confidential and  
> may be privileged.
> If you are not the intended recipient, please notify the sender and  
> then delete this e-mail immediately.
> *"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*" 
> *"*"*"*



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.


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