Re: MYSQL timeout

2010-10-01 Thread Bob Sneidar
No offense, but how in the HECK did this get stuck in the middle of the IPad's competitor from RIM thread? Bob On Sep 28, 2010, at 6:20 PM, Terry Judd wrote: The problem of lengthy timeouts when trying to connect to a MSQL server that is down/offline is bugging me again. It seems like the

Re: MYSQL timeout

2010-10-01 Thread stephen barncard
perhaps only in your mailer. On 1 October 2010 11:28, Bob Sneidar b...@twft.com wrote: No offense, but how in the HECK did this get stuck in the middle of the IPad's competitor from RIM thread? Bob On Sep 28, 2010, at 6:20 PM, Terry Judd wrote: The problem of lengthy timeouts when

Re: MYSQL timeout

2010-10-01 Thread Bob Sneidar
Aye. Methinks that when someone replies to an email from the list, there is some kind of identifier in the email that tells a mailer it belongs to a particular thread. So if someone replies to one thread, but substitutes the subject with an entirely new subject, some mailers might just think

Re: MYSQL timeout

2010-10-01 Thread Terry Judd
That's what I did, so it makes sense. Terry... On 02/10/2010, at 4:56 AM, Bob Sneidar b...@twft.com wrote: Aye. Methinks that when someone replies to an email from the list, there is some kind of identifier in the email that tells a mailer it belongs to a particular thread. So if someone

Re: MYSQL timeout

2010-10-01 Thread stephen barncard
google mail seems to keep the threads straignt. Better than any other mailer I've used. On 1 October 2010 17:19, Terry Judd t...@unimelb.edu.au wrote: That's what I did, so it makes sense. Terry... On 02/10/2010, at 4:56 AM, Bob Sneidar b...@twft.com wrote: Aye. Methinks that when

Re: MYSQL timeout

2010-09-29 Thread Devin Asay
On Sep 28, 2010, at 7:20 PM, Terry Judd wrote: The problem of lengthy timeouts when trying to connect to a MSQL server that is down/offline is bugging me again. It seems like the default timeout is 60 seconds which is way too long to wait for a response but there's no obvious way to override

Re: MYSQL timeout

2010-09-29 Thread Terry Judd
Yep - tried on LiveCode - no joy there so far. Cheers, Terry... On 30/09/2010, at 3:54 AM, Devin Asay devin_a...@byu.edu wrote: On Sep 28, 2010, at 7:20 PM, Terry Judd wrote: The problem of lengthy timeouts when trying to connect to a MSQL server that is down/offline is bugging me

Re: MYSQL timeout

2010-09-29 Thread Malte Pfaff-Brill
Hi Terry, had the same problem. I settled to ping the IP first before trying to connect to the DB: switch case mac is in the platform get shell(ping -q -o -c3 -t3tIP) if the result is not empty then put the result into tError end if

Re: MYSQL timeout

2010-09-29 Thread Terry Judd
Thanks Malte - that seems like a good solution. My issues have mainly been with the server itself rather than with MySQL. Terry... On 30/09/2010, at 7:12 AM, Malte Pfaff-Brill revolut...@derbrill.de wrote: Hi Terry, had the same problem. I settled to ping the IP first before trying to

MYSQL timeout

2010-09-28 Thread Terry Judd
The problem of lengthy timeouts when trying to connect to a MSQL server that is down/offline is bugging me again. It seems like the default timeout is 60 seconds which is way too long to wait for a response but there's no obvious way to override it. The socketTimeoutInterval has no effect and

Re: MySQL timeout

2008-07-16 Thread Malte Brill
Hi Terry, I experienced the same. The problem was only the case, if the machine running the mySQL server is not found on the Network though. If the machine is there, but the server is down it times out immediately, so I went for pinging the server first using shell and if that was

Re: MySQL timeout

2008-07-16 Thread Terry Judd
On 16/7/08 11:56 PM, Malte Brill [EMAIL PROTECTED] wrote: Hi Terry, I experienced the same. The problem was only the case, if the machine running the mySQL server is not found on the Network though. If the machine is there, but the server is down it times out immediately, so I went for

MySQL timeout

2008-07-15 Thread Terry Judd
I have a 'startup' routine that checks to see whether my mySQL database is online. The problem if that when it isn't it hangs for 75 seconds. Is there a way to specify a (much) shorter timeout interval? Terry... ___ use-revolution mailing list

Re: MySQL timeout

2008-07-15 Thread Ken Ray
On 7/15/08 4:13 PM, Terry Judd [EMAIL PROTECTED] wrote: I have a 'startup' routine that checks to see whether my mySQL database is online. The problem if that when it isn't it hangs for 75 seconds. Is there a way to specify a (much) shorter timeout interval? How are you checking? Are you

Re: MySQL timeout

2008-07-15 Thread Terry Judd
On 16/7/08 7:50 AM, Ken Ray [EMAIL PROTECTED] wrote: On 7/15/08 4:13 PM, Terry Judd [EMAIL PROTECTED] wrote: I have a 'startup' routine that checks to see whether my mySQL database is online. The problem if that when it isn't it hangs for 75 seconds. Is there a way to specify a (much)

Re: MySQL timeout

2008-07-15 Thread Terry Judd
On 16/7/08 7:59 AM, Terry Judd [EMAIL PROTECTED] wrote: On 16/7/08 7:50 AM, Ken Ray [EMAIL PROTECTED] wrote: On 7/15/08 4:13 PM, Terry Judd [EMAIL PROTECTED] wrote: I have a 'startup' routine that checks to see whether my mySQL database is online. The problem if that when it isn't it

Re: MySQL timeout

2008-07-15 Thread Ken Ray
Hi Ken - Nothing as fancy as that. I'm just using revOpenDatabase to get a connection ID. If either I or the database are offline I get the spinning pizza (Mac OSX) for a full 75 seconds before it returns a 'Can't connect to Mysql' error. There's an environment variable called

Re: MySQL timeout

2008-07-15 Thread Terry Judd
On 16/7/08 9:51 AM, Ken Ray [EMAIL PROTECTED] wrote: Hi Ken - Nothing as fancy as that. I'm just using revOpenDatabase to get a connection ID. If either I or the database are offline I get the spinning pizza (Mac OSX) for a full 75 seconds before it returns a 'Can't connect to Mysql' error.

MySQL Timeout

2007-08-15 Thread Bridger Maxwell
Hey, Is there a way to set a maximum time for a MySQL query to execute before it times out? As it is right now, if the MySQL server is having problems or something then my application will hang indefinitely waiting for a response. Is there a way to set a timeout? Thank You, Bridger