MySQL timeout

[Terry Judd]

On 16/7/08 9:51 AM, "Ken Ray" <kray at sonsothunder.com> 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. 
> 
> There's an environment variable called "$MYSQL_CLIENT_TIMEOUT" that you can
> set... I'm reading the value from a preference and executing:
>  
>   put gPrefsData["MySQLTimeout"] into $MYSQL_CLIENT_TIMEOUT
> 
> The timeout value is in seconds, btw...

I set it to 3 seconds but the revOpenDatabase function still blocks for 75
seconds :(

Terry...
> 
> 
> Ken Ray
> Sons of Thunder Software, Inc.
> Email: kray at sonsothunder.com
> Web Site: http://www.sonsothunder.com/
> 
> 
> _______________________________________________
> 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

-- 
Dr Terry Judd
Lecturer in Educational Technology (Design)
Biomedical Multimedia Unit
Faculty of Medicine, Dentistry & Health Sciences
The University of Melbourne
Parkville VIC 3052
AUSTRALIA

61-3 8344 0187