1--TEST-- 2mysqli_change_user() 3--SKIPIF-- 4<?php 5require_once('skipif.inc'); 6require_once('skipifemb.inc'); 7require_once('skipifconnectfailure.inc'); 8?> 9--FILE-- 10<?php 11 require_once("connect.inc"); 12 13 $tmp = NULL; 14 $link = NULL; 15 16 if (!is_null($tmp = @mysqli_change_user())) 17 printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); 18 19 if (!is_null($tmp = @mysqli_change_user($link))) 20 printf("[002] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); 21 22 if (!is_null($tmp = @mysqli_change_user($link, $link))) 23 printf("[003] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); 24 25 if (!is_null($tmp = @mysqli_change_user($link, $link, $link))) 26 printf("[004] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); 27 28 if (!is_null($tmp = @mysqli_change_user($link, $link, $link, $link, $link))) 29 printf("[005] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); 30 31 if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket)) 32 printf("[006] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n", 33 $host, $user, $db, $port, $socket); 34 35 if (false !== ($tmp = mysqli_change_user($link, $user . '_unknown_really', $passwd . 'non_empty', $db))) 36 printf("[007] Expecting false, got %s/%s\n", gettype($tmp), $tmp); 37 38 if (false !== ($tmp = mysqli_change_user($link, $user, $passwd . '_unknown_really', $db))) 39 printf("[008] Expecting false, got %s/%s\n", gettype($tmp), $tmp); 40 41 if (false !== ($tmp = mysqli_change_user($link, $user, $passwd, $db . '_unknown_really'))) 42 printf("[009] Expecting false, got %s/%s\n", gettype($tmp), $tmp); 43 44 // Reconnect because after 3 failed change_user attempts, the server blocks you off. 45 if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket)) 46 printf("[006] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n", 47 $host, $user, $db, $port, $socket); 48 49 if (!mysqli_query($link, 'SET @mysqli_change_user_test_var=1')) 50 printf("[010] Failed to set test variable: [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 51 52 if (!$res = mysqli_query($link, 'SELECT @mysqli_change_user_test_var AS test_var')) 53 printf("[011] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 54 $tmp = mysqli_fetch_assoc($res); 55 mysqli_free_result($res); 56 if (1 != $tmp['test_var']) 57 printf("[012] Cannot set test variable\n"); 58 59 if (true !== ($tmp = mysqli_change_user($link, $user, $passwd, $db))) 60 printf("[013] Expecting true, got %s/%s\n", gettype($tmp), $tmp); 61 62 if (!$res = mysqli_query($link, 'SELECT database() AS dbname, user() AS user')) 63 printf("[014] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 64 $tmp = mysqli_fetch_assoc($res); 65 mysqli_free_result($res); 66 67 if (substr($tmp['user'], 0, strlen($user)) !== $user) 68 printf("[015] Expecting user %s, got user() %s\n", $user, $tmp['user']); 69 if ($tmp['dbname'] != $db) 70 printf("[016] Expecting database %s, got database() %s\n", $db, $tmp['dbname']); 71 72 if (!$res = mysqli_query($link, 'SELECT @mysqli_change_user_test_var AS test_var')) 73 printf("[017] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 74 $tmp = mysqli_fetch_assoc($res); 75 mysqli_free_result($res); 76 if (NULL !== $tmp['test_var']) 77 printf("[019] Test variable is still set!\n"); 78 79 mysqli_close($link); 80 81 if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket)) { 82 printf("[020] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n", 83 $host, $user, $db, $port, $socket); 84 } 85 86 if (false !== ($tmp = mysqli_change_user($link, str_repeat('user', 16384), str_repeat('pass', 16384), str_repeat('dbase', 16384)))) 87 printf("[021] Expecting false, got %s/%s\n", gettype($tmp), $tmp); 88 89 mysqli_close($link); 90 91 if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket)) { 92 printf("[022] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n", 93 $host, $user, $db, $port, $socket); 94 } 95 96 /* silent protocol change if no db which requires workaround in mysqlnd/libmysql 97 (empty db = no db send with COM_CHANGE_USER) */ 98 if (true !== ($tmp = mysqli_change_user($link, $user, $passwd, ""))) 99 printf("[023] Expecting true, got %s/%s\n", gettype($tmp), $tmp); 100 101 if (!$res = mysqli_query($link, 'SELECT database() AS dbname, user() AS user')) 102 printf("[024] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 103 $tmp = mysqli_fetch_assoc($res); 104 mysqli_free_result($res); 105 106 if ($tmp['dbname'] != "") 107 printf("[025] Expecting database '', got database() '%s'\n", $tmp['dbname']); 108 109 mysqli_close($link); 110 111 if (NULL !== ($tmp = @mysqli_change_user($link, $user, $passwd, $db))) 112 printf("[026] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); 113 114 print "done!"; 115?> 116--EXPECTF-- 117done! 118
