(RADIATOR) no timeout on database query

[Hugh Irvine]

Hello Ruud -

Thanks for your mail.

The latest version is Radiator 4.0, which you may want to test to see  
if you still have the same issues.

Please let us know what you discover.

regards

Hugh


On 21 Jan 2008, at 20:39, Ruud Besseling wrote:

> Hello,
>
> We use a mysql database to save all accounting data. Normally when  
> the database is not available the insert query
> times out, the data is saved in a local file and radiator is ready  
> for the next request.
>
> However, when the network interface of the database server is going  
> down
> unexpectedly, the timeout does not occur
> and radiator hangs.
>
> Has anyone experienced the same problems and -more important- does  
> anyone have a solution?
>
>
> We are using Radiator 3.13, MySQL 5.0.41, DBI 1.6 and DBD 4.005
> We use several servers and on each server there are several  
> accounting radius processes running.
>
>
> <AuthBy SQL>
>        Identifier              SQLlog_0
>
>        DBSource                dbi:mysql:host=host;database=database
>        DBUsername              %{GlobalVar:DBuser}
>        DBAuth                  %{GlobalVar:DBpass}
>        Timeout                 3
>        FailureBackoffTime      60
>
>        AuthSelect
>
>        AcctInsertQuery         replace into %0 (%1) values (%2)
>
>        AccountingTable         %{GlobalVar:TableName}
>        AcctColumnDef           USERNAME,User-Name
>        AcctColumnDef           CLASS,Class
>        AcctColumnDef           ACCTSTATUSTYPE,Acct-Status-Type
>        ...
>        AcctFailedLogFileName   %L/data/failed-% 
> {Server:BindAddress}.log
> </AuthBy>
>
>
> kind regards,
> Ruud Besseling
>
> --
> 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.



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.


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