(RADIATOR) Re: Radiator 3.3.1 stalls

[Hugh Irvine]

Hello Riza -

You should probably upgrade to Radiator 3.5 which has improved SQL  
timeout handling.

There are also a number of parameters available to modify SQL behaviour  
including:

	Timeout

	FailureBackoffTime

See sections 6.28.4 and 6.28.5 in the Radiator 3.5 reference manual  
("doc/ref.html").

regards

Hugh


On Wednesday, Jan 8, 2003, at 21:24 Australia/Melbourne, Riza Kamalie  
wrote:

> guys,
>
> We are using Radiator 3.3.1 and have the radclietlist and Session  
> database
> login to external Oracle databases like the config shows below, what is
> happening is that Radiator stalls completely when it receives SQL  
> timeouts
> when the database doesn't respond in time, now it has been identified  
> to be
> a performance issue on the database server side as this handles allot  
> better
> on better performing hardware. The concern here is that radiator  
> stalls with
> this SQL timeout error and doesn't reconnect when the database server
> becomes very busy with some sort of maintance on the server etc. which
> results in obvious downtime and requires a restart etc. is there way to
> increase this SQL timeout to within reasonable limits? what the  
> current SQL
> timeout limit? or make it able to back off and reconnect? like the  
> scenario
> where is backs off when it is unable to connect to a SQL database the  
> first
> time?
>
> Anyone body had similar issues like this?
>
> Any comments/suggestions/ideas would be great?
>
>
> ----------------------------------------------------------------------- 
> -----
> ------------------------------------
> <ClientListSQL>
>         DBSource        dbi:Oracle:xxxx
>         DBUsername      xxxxx
>         DBAuth          xxxxx
> </ClientListSQL>
>
> <SessionDatabase SQL>
>         DBSource        dbi:Oracle:xxxx
>         DBUsername      xxxxx
>         DBAuth          xxxxx
>         AddQuery        insert into RADONLINE (USERNAME, USERID,
> NASIDENTIFIER, NASPORT, \
>                         ACCTSESSIONID, TIME_STAMP, FRAMEDIPADDRESS,
> NASPORTTYPE, \
>                         SERVICETYPE, CLI, RECEIVED_TIME,  
> CALLING_STATION_ID)
> \
>                         values ('%u', '%U', '%N', %{NAS-Port},
> '%{Acct-Session-Id}', \
>                         '%{Timestamp}', '%{Framed-IP-Address}',
> '%{NAS-Port-Type}', '%{Service-Type}', \
>                         '%{Called-Station-Id}', to_date('%l', 'DY MON  
> DD
> HH24:MI:SS YYYY'), '%{Calling-Station-Id}')
> </SessionDatabase SQL>
> ----------------------------------------------------------------------- 
> -----
> -----------------------------------------
>
> Thanks
>
>
> Riza Kamalie
> Technical Systems Manager
> Engineering
>
> Worldonline
> A Division of Tiscali (Pty) Ltd
> +27 (21) 940 9954
> +27(0) 82 992 2027
> riza at za.tiscali.com
> http://www.worldonline.co.za
>
>
> Disclaimer: This email is considered a business record and is therefore
> property of Tiscali. This email, and any files transmitted with it are
> confidential and are intended solely for the use of the individual or  
> entity
> to whom they are addressed. This communication represents the  
> originator's
> personal views and opinions, which do not necessarily reflect those of
> Tiscali. If you are not the original recipient or the person  
> responsible for
> delivering the email to the intended recipient, be advised that you  
> have
> this email in error, and that any use, dissemination, forwarding,  
> printing,
> or copying of this email is strictly prohibited. If you received this  
> email
> in error, please immediately notify mailto:disclaimer at za.tiscali.com.
> Very funny Scotty... Now beam down my clothes!!
>
>

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.

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