(RADIATOR) MySQL + Radiator = Hang

[Hugh Irvine]

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 radiator-announce at open.com.au
> To unsubscribe, email 'majordomo at open.com.au' 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 radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.