(RADIATOR) Could not connect to SQL database

[Frank Danielson]

You can test perl and the associated DBI/DBD modules with the dbish tool. It
should be in the directory with your perl binaries.

-Frank

-----Original Message-----
From: Andrew Reeves [mailto:andrew.reeves at sunbeach.net]
Sent: Tuesday, June 14, 2005 8:29 AM
To: radiator at open.com.au
Subject: Re: (RADIATOR) Could not connect to SQL database


Yes, the SQL FailureBackoffTime is being respected. Also, since I'm able 
to connect with isql via unixODBC and freeTDS I'm thinking that rules 
out freeTDS. I was wondering if it could be perl or one of the perl modules?

regards
Andrew

Hugh Irvine wrote:

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

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

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