mirror of
https://github.com/php/pecl-database-mysql_xdevapi.git
synced 2026-04-27 17:03:39 +02:00
Darek Slusarczyk
65 lines
2.0 KiB
PHP
65 lines
2.0 KiB
PHP
--TEST--
|
|
mysqlx authentication mechanisms - secure mysql_native_password
|
|
--SKIPIF--
|
|
--INI--
|
|
error_reporting=1
|
|
default_socket_timeout=4
|
|
--FILE--
|
|
<?php
|
|
require_once(__DIR__."/auth_utils.inc");
|
|
|
|
// setup
|
|
$test_user = $Test_user_native;
|
|
|
|
$ssl_query = prepare_ssl_query();
|
|
|
|
// ----------
|
|
reset_test_user($test_user, 'mysql_native_password');
|
|
|
|
// will login with PLAIN
|
|
test_secure_connection($test_user, null);
|
|
test_secure_connection($test_user, 'MYSQL41');
|
|
test_secure_connection($test_user, 'shA256_Memory');
|
|
test_secure_connection($test_user, 'PLAIN');
|
|
test_secure_connection($test_user, 'SHA256_MEMORY');
|
|
test_secure_connection($test_user, 'EXTERNAL', false);
|
|
test_secure_connection($test_user, 'UNSUPPORTED', false);
|
|
|
|
// ----------
|
|
reset_test_user($test_user, 'mysql_native_password');
|
|
|
|
test_secure_connection($test_user, 'mysql41');
|
|
test_secure_connection($test_user, 'sha256_memory', false);
|
|
test_secure_connection($test_user, 'plain');
|
|
test_secure_connection($test_user, 'sha256_memory');
|
|
test_secure_connection($test_user, 'external', false);
|
|
test_secure_connection($test_user, 'nonworking', false);
|
|
test_secure_connection($test_user, null);
|
|
|
|
// ----------
|
|
reset_test_user($test_user, 'mysql_native_password');
|
|
|
|
test_secure_connection($test_user, 'mySQL41');
|
|
test_secure_connection($test_user, 'PlAiN');
|
|
test_secure_connection($test_user, 'ShA256_meMorY');
|
|
test_secure_connection($test_user, 'ExtERnAl', false);
|
|
test_secure_connection($test_user, 'NonSupported', false);
|
|
|
|
verify_expectations();
|
|
print "done!\n";
|
|
?>
|
|
--CLEAN--
|
|
<?php
|
|
require_once(__DIR__."/auth_utils.inc");
|
|
clean_test_db();
|
|
?>
|
|
--EXPECTF--
|
|
[1251][HY000] Invalid authentication method EXTERNAL
|
|
[10046][HY000] Invalid authentication mechanism UNSUPPORTED
|
|
[1045][HY000] Access denied for user 'mysql_xdevapi_test_user_native'@'localhost' (using password: YES)
|
|
[1251][HY000] Invalid authentication method EXTERNAL
|
|
[10046][HY000] Invalid authentication mechanism nonworking
|
|
[1251][HY000] Invalid authentication method EXTERNAL
|
|
[10046][HY000] Invalid authentication mechanism NonSupported
|
|
done!%A
|