Upgraded to 3.5 (from 3.3)....works fine now 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
-----Original Message----- From: Hugh Irvine [mailto:[EMAIL PROTECTED]] Sent: Friday, December 27, 2002 3:24 PM To: Tony Bunce Cc: [EMAIL PROTECTED] Subject: Re: (RADIATOR) MySQL + Radiator = Hang 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.
