MYSQL timeout

[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" <revolution at derbrill.de> wrote:

> 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 -t3"&&tIP)
>            if the result is not empty then
>               put the result into tError
>            end if
>            break 
>         case "win" is in the platform
>            set the hideConsoleWindows to true
>            local tShell
>            put ("ping -n 1 -w 100 "&tIP) into tShell
>            get shell(tShell)
>            if the result is not empty then
>               put the result into tError
>            end if
>            break
>      end switch
> 
>      if tError is not empty then
>      -- can not connect to server
>      end if
> 
> Even though you can not be sure, that mySQL is really up and running, you will at least know if the server is there. Hope that helps a little.
> 
> Cheers,
> 
> Malte_______________________________________________
> 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