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 if (!mysqli_query($link, 'SET @mysqli_change_user_test_var=1')) 45 printf("[010] Failed to set test variable: [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 46 47 if (!$res = mysqli_query($link, 'SELECT @mysqli_change_user_test_var AS test_var')) 48 printf("[011] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 49 $tmp = mysqli_fetch_assoc($res); 50 mysqli_free_result($res); 51 if (1 != $tmp['test_var']) 52 printf("[012] Cannot set test variable\n"); 53 54 if (true !== ($tmp = mysqli_change_user($link, $user, $passwd, $db))) 55 printf("[013] Expecting true, got %s/%s\n", gettype($tmp), $tmp); 56 57 if (!$res = mysqli_query($link, 'SELECT database() AS dbname, user() AS user')) 58 printf("[014] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 59 $tmp = mysqli_fetch_assoc($res); 60 mysqli_free_result($res); 61 62 if (substr($tmp['user'], 0, strlen($user)) !== $user) 63 printf("[015] Expecting user %s, got user() %s\n", $user, $tmp['user']); 64 if ($tmp['dbname'] != $db) 65 printf("[016] Expecting database %s, got database() %s\n", $db, $tmp['dbname']); 66 67 if (!$res = mysqli_query($link, 'SELECT @mysqli_change_user_test_var AS test_var')) 68 printf("[017] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 69 $tmp = mysqli_fetch_assoc($res); 70 mysqli_free_result($res); 71 if (NULL !== $tmp['test_var']) 72 printf("[019] Test variable is still set!\n"); 73 74 mysqli_close($link); 75 76 if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket)) { 77 printf("[020] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n", 78 $host, $user, $db, $port, $socket); 79 } 80 81 if (false !== ($tmp = mysqli_change_user($link, str_repeat('user', 16384), str_repeat('pass', 16384), str_repeat('dbase', 16384)))) 82 printf("[021] Expecting false, got %s/%s\n", gettype($tmp), $tmp); 83 84 mysqli_close($link); 85 86 if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket)) { 87 printf("[022] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n", 88 $host, $user, $db, $port, $socket); 89 } 90 91 /* silent protocol change if no db which requires workaround in mysqlnd/libmysql 92 (empty db = no db send with COM_CHANGE_USER) */ 93 if (true !== ($tmp = mysqli_change_user($link, $user, $passwd, ""))) 94 printf("[023] Expecting true, got %s/%s\n", gettype($tmp), $tmp); 95 96 if (!$res = mysqli_query($link, 'SELECT database() AS dbname, user() AS user')) 97 printf("[024] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); 98 $tmp = mysqli_fetch_assoc($res); 99 mysqli_free_result($res); 100 101 if ($tmp['dbname'] != "") 102 printf("[025] Expecting database '', got database() '%s'\n", $tmp['dbname']); 103 104 mysqli_close($link); 105 106 if (NULL !== ($tmp = @mysqli_change_user($link, $user, $passwd, $db))) 107 printf("[026] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp); 108 109 print "done!"; 110?> 111--EXPECTF-- 112done!
