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

[Hartmaier Alexander]

I upped the trace level to 4 last time and it happened again this night.
The only error message is the SQL Timeout like last time.
FYI the database is Oracle 10.2 so I use DBD::Oracle 1.16.
The linux is RedHat 9, will be soon reinstalled on VMWare with RedHat Server 5.0.

I tried to use restartwrapper but wasn't able to make it work.
The init script for RedHat uses daemon which seems to not like restartwrapper.
Do you have a complete linux init script example using restartwrapper?

Thanks, Alex

> -----Original Message-----
> From: Hugh Irvine [mailto:hugh at open.com.au]
> Sent: Tuesday, June 12, 2007 1:28 AM
> To: Hartmaier Alexander
> Cc: radiator at open.com.au
> Subject: Re: (RADIATOR) [BUG] radiator diing on sql db timeout
> 
> 
> Hello Alexander -
> 
> Yes you can use restartWrapper with an init script - keep in mind
> that restartWrapper remains attached to radiusd, but from the init
> script point of view restartWrapper detaches itself.
> 
> See the example in section 15.1 of the Radiator 3.17.1 reference
> manual ("doc/ref.html").
> 
> To test your database connectivity problem I suggest you set up a
> test machine with Radiator and a copy of the database, then Radiator
> like this:
> 
> 	cd /your/Radiator/distribution
> 
> 	perl radiusd -foreground -log_stdout -trace 4 -config_file /your/
> configuration/file
> 
> You can then use radpwtst to generate test requests and stop the
> database to see what happens.
> 
> Please let us know what you discover.
> 
> regards
> 
> Hugh
> 
> 
> On 11 Jun 2007, at 19:31, Hartmaier Alexander wrote:
> 
> > 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.
> >>
> >>
> >
> 
> 
> 
> 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.
> 
> 

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

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