diff options
Diffstat (limited to 'ext/mysqli/tests/mysqli_expire_password.phpt')
-rw-r--r-- | ext/mysqli/tests/mysqli_expire_password.phpt | 130 |
1 files changed, 65 insertions, 65 deletions
diff --git a/ext/mysqli/tests/mysqli_expire_password.phpt b/ext/mysqli/tests/mysqli_expire_password.phpt index f193add0be..8d80ec4a5e 100644 --- a/ext/mysqli/tests/mysqli_expire_password.phpt +++ b/ext/mysqli/tests/mysqli_expire_password.phpt @@ -50,71 +50,71 @@ if (!mysqli_query($link, sprintf("GRANT SELECT ON TABLE %s.test TO expiretest@'% ?> --FILE-- <?php - require_once('connect.inc'); - require_once('table.inc'); - - /* default */ - if (!$link = my_mysqli_connect($host, 'expiretest', "", $db, $port, $socket)) { - printf("[001] Cannot connect [%d] %s\n", - mysqli_connect_errno(), mysqli_connect_error()); - } else { - $link->query("SELECT id FROM test WHERE id = 1"); - printf("[002] Connect should fail, [%d] %s\n", $link->errno, $link->error); - } - /* explicitly requesting default */ - $link = mysqli_init(); - $link->options(MYSQLI_OPT_CAN_HANDLE_EXPIRED_PASSWORDS, 0); - if (!my_mysqli_real_connect($link, $host, 'expiretest', "", $db, $port, $socket)) { - printf("[003] Cannot connect [%d] %s\n", - mysqli_connect_errno(), mysqli_connect_error()); - } else { - $link->query("SELECT id FROM test WHERE id = 1"); - printf("[004] Connect should fail, [%d] %s\n", $link->errno, $link->error); - } - - /* allow connect */ - $link = mysqli_init(); - $link->options(MYSQLI_OPT_CAN_HANDLE_EXPIRED_PASSWORDS, 1); - if (!my_mysqli_real_connect($link, $host, 'expiretest', "", $db, $port, $socket)) { - printf("[005] Cannot connect [%d] %s\n", - mysqli_connect_errno(), mysqli_connect_error()); - } else { - $link->query("SELECT id FROM test WHERE id = 1"); - printf("[006] Connect allowed, query fail, [%d] %s\n", $link->errno, $link->error); - $link->close(); - } - - /* allow connect, fix pw */ - $link = mysqli_init(); - $link->options(MYSQLI_OPT_CAN_HANDLE_EXPIRED_PASSWORDS, 1); - if (!my_mysqli_real_connect($link, $host, 'expiretest', "", $db, $port, $socket)) { - printf("[007] Cannot connect [%d] %s\n", - mysqli_connect_errno(), mysqli_connect_error()); - } else { - if (!$link->query("SET PASSWORD='expiretest'")) { - $link->query("SET PASSWORD=PASSWORD('expiretest')"); - } - printf("[008] Connect allowed, pw set, [%d] %s\n", $link->errno, $link->error); - if ($res = $link->query("SELECT id FROM test WHERE id = 1")) - var_dump($res->fetch_assoc()); - $link->close(); - } - - - /* check login */ - if (!$link = my_mysqli_connect($host, 'expiretest', "expiretest", $db, $port, $socket)) { - printf("[001] Cannot connect [%d] %s\n", - mysqli_connect_errno(), mysqli_connect_error()); - } else { - $link->query("SELECT id FROM test WHERE id = 1"); - if ($res = $link->query("SELECT id FROM test WHERE id = 1")) - var_dump($res->fetch_assoc()); - $link->close(); - } - - - - print "done!"; + require_once('connect.inc'); + require_once('table.inc'); + + /* default */ + if (!$link = my_mysqli_connect($host, 'expiretest', "", $db, $port, $socket)) { + printf("[001] Cannot connect [%d] %s\n", + mysqli_connect_errno(), mysqli_connect_error()); + } else { + $link->query("SELECT id FROM test WHERE id = 1"); + printf("[002] Connect should fail, [%d] %s\n", $link->errno, $link->error); + } + /* explicitly requesting default */ + $link = mysqli_init(); + $link->options(MYSQLI_OPT_CAN_HANDLE_EXPIRED_PASSWORDS, 0); + if (!my_mysqli_real_connect($link, $host, 'expiretest', "", $db, $port, $socket)) { + printf("[003] Cannot connect [%d] %s\n", + mysqli_connect_errno(), mysqli_connect_error()); + } else { + $link->query("SELECT id FROM test WHERE id = 1"); + printf("[004] Connect should fail, [%d] %s\n", $link->errno, $link->error); + } + + /* allow connect */ + $link = mysqli_init(); + $link->options(MYSQLI_OPT_CAN_HANDLE_EXPIRED_PASSWORDS, 1); + if (!my_mysqli_real_connect($link, $host, 'expiretest', "", $db, $port, $socket)) { + printf("[005] Cannot connect [%d] %s\n", + mysqli_connect_errno(), mysqli_connect_error()); + } else { + $link->query("SELECT id FROM test WHERE id = 1"); + printf("[006] Connect allowed, query fail, [%d] %s\n", $link->errno, $link->error); + $link->close(); + } + + /* allow connect, fix pw */ + $link = mysqli_init(); + $link->options(MYSQLI_OPT_CAN_HANDLE_EXPIRED_PASSWORDS, 1); + if (!my_mysqli_real_connect($link, $host, 'expiretest', "", $db, $port, $socket)) { + printf("[007] Cannot connect [%d] %s\n", + mysqli_connect_errno(), mysqli_connect_error()); + } else { + if (!$link->query("SET PASSWORD='expiretest'")) { + $link->query("SET PASSWORD=PASSWORD('expiretest')"); + } + printf("[008] Connect allowed, pw set, [%d] %s\n", $link->errno, $link->error); + if ($res = $link->query("SELECT id FROM test WHERE id = 1")) + var_dump($res->fetch_assoc()); + $link->close(); + } + + + /* check login */ + if (!$link = my_mysqli_connect($host, 'expiretest', "expiretest", $db, $port, $socket)) { + printf("[001] Cannot connect [%d] %s\n", + mysqli_connect_errno(), mysqli_connect_error()); + } else { + $link->query("SELECT id FROM test WHERE id = 1"); + if ($res = $link->query("SELECT id FROM test WHERE id = 1")) + var_dump($res->fetch_assoc()); + $link->close(); + } + + + + print "done!"; ?> --CLEAN-- <?php |