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

[Dominic J. Eidson]

You could also use the instructions for running Radiator out of 
/etc/inittab - seems to work very well here.

(It also makes reloading configs easy - just kill radiator, and it 
restarts automatically :)


  - d.

-- 
Dominic J. Eidson
Network Engineer
Seton Family of Hospitals
512-324-1000 x18711



Hartmaier Alexander wrote:
> 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.

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