Radiator 3.3.1 stalls

[Riza Kamalie]

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

-------------------------------------------------------

-- 
Mike McCauley                               mikem at open.com.au
Open System Consultants Pty. Ltd            Unix, Perl, Motif, C++, WWW
24 Bateman St Hampton, VIC 3188 Australia   http://www.open.com.au
Phone +61 3 9598-0985                       Fax   +61 3 9598-0955

Radiator: the most portable, flexible and configurable RADIUS server 
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, 
Platypus, Freeside, TACACS+, PAM, external, Active Directory, EAP, TLS, 
TTLS, PEAP etc on Unix, Windows, MacOS etc.

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