(RADIATOR) no timeout on database query

[Ruud Besseling]

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.