MySQL has gone away

[TEKNE informatica & comunicazione]

I have tried with a ping in a 'send in time' script but I get the same error
after a few minutes.
The mysql server is on my LAN; the server has also a WAN static IP.
When I am connected from the LAN to the server local IP, I don't get errors.
But if I am connected to the server WAN IP, after a few minutes of
inactivity, I get the error 'MySQL has gone away'



> Da: Stephen Barncard <stephenREVOLUTION at barncard.com>
> Risposta: How to use Revolution <use-revolution at lists.runrev.com>
> Data: Thu, 8 Mar 2007 16:47:08 -0600
> A: How to use Revolution <use-revolution at lists.runrev.com>
> Oggetto: Re: MySQL has gone away
> 
> this is more likely about the SQL server timeouts -- the server end,
> not your end. Some ISPs put short timeouts on their servers.
> 
> Even Dreamhost will drop after a few hours. I built a 'send in time'
> routine to ping the server every 3600 seconds to keep it alive. It
> basically calls itself forever until the app stops or it is told to
> stop. Works great.
> 
> 
>> Do you know if there is a relationship between the socket timeout and the
>> connection to a MySQL server with the revOpenDatabase function?
>> When I am connected to a remote server machine and I don't send a query for
>> more than 5 minutes, I obtain the error  "MySQL has gone away".
>> PS
>> I have tuned the server system variables in order to have a good connection
>> (wait_timeout, max_allowad_packets, etc.).
>> If I make the connection from the LAN I don't have this error!
>> 
>> Thank you for your suggestions.
>> 
>> Riccardo
>> 
>> _______________________________________________
>> use-revolution mailing list
>> use-revolution at lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your
>> subscription preferences:
>> http://lists.runrev.com/mailman/listinfo/use-revolution
> 
> 
> -- 
> 
> 
> stephen barncard
> s a n  f r a n c i s c o
> - - -  - - - - - - - - -
> 
> 
> 
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution