Hello Tony -
I will need to see a copy of your configuration file (no secrets) together with a trace 4 debug from Radiator showing what is happening. I will also need to know what hardware/software platform you are running on and what version of Radiator, Perl, DBI, DBD, etc. you are using.
BTW - the latest version is Radiator 3.5.
Radiator should not hang waiting for the connection.
regards
Hugh
On Saturday, Dec 28, 2002, at 03:30 Australia/Melbourne, Tony Bunce wrote:
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 [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
-- 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 [EMAIL PROTECTED] To unsubscribe, email '[EMAIL PROTECTED]' with 'unsubscribe radiator' in the body of the message.
