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

[Hartmaier Alexander]

Hi Hugh!

Thanks for the quick response and the hint at the restartWrapper.
Does the restartWrapper play nice with the init script?

As this was on our production radius servers I only have a trace 3 logfile 
from that time period.
I don't really know how to reproduce the problem, maybe you can look in the 
DBI code and see something obvious around the session DBI execute.

-Alex

> -----Original Message-----
> From: Hugh Irvine [mailto:hugh at open.com.au]
> Sent: Sunday, June 10, 2007 12:14 PM
> To: Hartmaier Alexander
> Cc: radiator at open.com.au
> Subject: Re: (RADIATOR) [BUG] radiator diing on sql db timeout
>
>
> 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.
>
>

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 5611 bytes
Desc: not available
URL: <http://www.open.com.au/pipermail/radiator/attachments/20070611/954f2303/attachment.bin>