(RADIATOR) Could not connect to SQL database

[Hugh Irvine]

Hello Andrew -

This is likely to be a problem with freeTDS, but have you checked  
that the SQL FailureBackoffTime is being respected? By default  
Radiator waits for 600 seconds (10 minutes) before retrying the  
database. If the problem is indeed freeTDS, you may want to check if  
a different version runs better. Otherwise I suggest you run an  
instance of Radiator on Windows and proxy requests from the other  
machine to it.

regards

Hugh



On 14 Jun 2005, at 06:48, Andrew Reeves wrote:

> Hi guys,
>
> I'm running Radiator 3.12 on CentOS 4, with perl 5.6.2, DBI::DBD,  
> DBD::ODBC, unixODBC and freeTDS.
>
>
> I have the following problem with radiator 3.12.
>
> After loss of connectivity to the MSSQL Sever 2000 radiator is  
> unable to connect after the connectivity is restored.. It logs the  
> following information:
> ERR: Could not connect to SQL database with DBI->connect  
> dbi:ODBC:datasource, user, password
>
> After connectivity is restored I can connect via isql but not  
> radiator. With radiator on Windows 2000 the problem doesn't occur.
> Has anyone experienced this before or have any suggestions?
>
> TIA
> Andrew
>
> --
> 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.
>


NB:

Have you read the reference manual ("doc/ref.html")?
Have you searched the mailing list archive (www.open.com.au/archives/ 
radiator)?
Have you had a quick look on Google (www.google.com)?
Have you included a copy of your configuration file (no secrets),
together with a trace 4 debug showing what is happening?

-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
-
CATool: Private Certificate Authority for Unix and Unix-like systems.


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