(RADIATOR) MySQL + Radiator = Hang

[Tony Bunce]

We have radiator setup on two servers using a MS SQL server for user
authentication and mysql for accounting.

The problem that we are having is that if the mysql server stops
responding or go off line etc radiator will hang waiting for the
connection.

The log files show

Thu Dec 26 18:40:07 2002: DEBUG: do query is: insert into
AccountingStop....
Thu Dec 26 18:41:07 2002: ERR: do failed for 'insert...': SQL Timeout
Thu Dec 26 18:43:07 2002: ERR: do failed for 'insert...': SQL Timeout

I currently don't have a timeout specified for the mysql server so I
assume it is the 60sec that radiator defaults to.  If so why is there a
2 minute gap between attempts and shouldn't radiator back off for
FailureBackoffTime (defaults to 600 sec) before trying to contact the
sql server again?

Here is part of my conf

<AuthBy SQL>
DateFormat %Y-%m-%d %T
Identifier MySQL
DBSource dbi:mysql:radius:xxx.xxx.xxx.xxx
DBUsername username
DBAuth  password


AuthSelect  

AccountingTable Accounting%{Acct-Status-Type}
#AccountingTable Accounting
AcctColumnDef   Username,%U,formatted
AcctColumnDef   TIME_STAMP,Timestamp,integer
AcctColumnDef   AcctStatusType,Acct-Status-Type
AcctColumnDef   SessionID,Acct-Session-Id
AcctColumnDef   SessionTime,Acct-Session-Time,integer
AcctColumnDef   DisconnectCause,Ascend-Disconnect-Cause,integer
AcctColumnDef   ConnectProgress,Ascend-Connect-Progress,integer
AcctColumnDef   NASIdentifier,NAS-Identifier
AcctColumnDef   NASPort,NAS-Port,integer
AcctColumnDef   ModemPort,Ascend-Modem-PortNo,integer
AcctColumnDef   ModemSlot,Ascend-Modem-SlotNo,integer
AcctColumnDef   IPAddress,Framed-IP-Address
AcctColumnDef   XmitRate,Ascend-Xmit-Rate
AcctColumnDef   DataRate,Ascend-Data-Rate
AcctColumnDef   Protocol,Framed-Protocol
AcctColumnDef   CallerID,Caller-Id
AcctColumnDef   Date,Timestamp,integer-date
</AuthBy SQL>


Thanks,
Tony B, CCNA, Network+
Systems Administration
GO Concepts, Inc. / www.go-concepts.com
Are you on the GO yet?
What about those you know, are they on the GO?
513.934.2800
1.888.ON.GO.YET


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