(RADIATOR) MySQL connections

[Fred Leeflang]

Hi Hugh,

Well the problem is the following, we've observed this before:

- A connection gets set up, our Nokia firewall creates a session
- over the weekend or so, when there's little activity, the Nokia
  times out the idle session. Neither client nor server get proper
  notification of that, in other words, both still think the TCP
  connection exists.
- Then on monday, activity picks up, but since it's not a *new*
  connection the Nokia will not create a new session and discard
  any packets sent on that connection.

Either way, I've fixed the problem by adjusting MySQL's
interactive_timeout value to be lower than the Nokia's,
not a very good solution but then at least MySQL will
properly disconnect so radiator will know the socket has
disconnected.

regards,
Fred

Hugh Irvine wrote:

>
> Hello Fred -
>
> Radiator keeps a persistent connection to the SQL server, however if 
> connectivity is lost Radiator will automatically reconnect to the 
> database. You should check the log file for any error messages if 
> Radiator loses the database connection.
>
> regards
>
> Hugh
>
>
> On 19 Jul 2004, at 18:05, Fred Leeflang wrote:
>
>> Hi,
>>
>> We have our radiator servers talking to a MySQL
>> database (sessions, clients etc). There's a statefull
>> firewall between this.
>>
>> Does radiator keep a persistant connection for
>> any MySQL server or can I tell it somehow
>> to make a new connection every single time?
>>
>> Regards,
>> Fred Leeflang
>>
>> -- 
>> 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 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.