connect2.inc 977 Bytes
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56
# include/connect2.inc
#
# SUMMARY
# 
#   Make several attempts to connect.
#
# USAGE
#
# EXAMPLE
# 
#   connect.test
#

--disable_query_log

let $wait_counter= 300;
if ($wait_timeout)
{
  let $wait_counter= `SELECT $wait_timeout * 10`;
}
# Reset $wait_timeout so that its value won't be used on subsequent
# calls, and default will be used instead.
let $wait_timeout= 0;

--echo # -- Establishing connection '$con_name' (user: $con_user_name)...

while ($wait_counter)
{
    --disable_abort_on_error
    --disable_result_log
    --connect ($con_name,localhost,$con_user_name)
    --enable_result_log
    --enable_abort_on_error

    let $error = $mysql_errno;

    if (!$error)
    {
        let $wait_counter= 0;
    }
    if ($error)
    {
        real_sleep 0.1;
        dec $wait_counter;
    }
}
if ($error)
{
  --echo # -- Error: can not establish connection '$con_name'.
}
if (!$error)
{
  --echo # -- Connection '$con_name' has been established.
}

--enable_query_log