# Connection delay tests for unauthenticated connections # (with or without control exemption) # ---------------------------------------------------------------------- # Setup # Install connection_control plugin INSTALL PLUGIN connection_control SONAME 'CONNECTION_CONTROL_LIB'; INSTALL PLUGIN connection_control_failed_login_attempts SONAME 'CONNECTION_CONTROL_LIB'; # Save original values of connection_control variables SET @saved_connections_threshold = @@global.connection_control_failed_connections_threshold; SET @saved_max_delay = @@global.connection_control_max_connection_delay; SET @saved_exempt= @@global.connection_control_exempt_unknown_users; # Set small values for connection_control variables SET @@global.connection_control_failed_connections_threshold = 2; SET @global.connection_control_max_connection_delay = 1000; # Check initial Connection_control_exempted_unknown_users - Should be 0 SHOW STATUS LIKE 'Connection_control_exempted_unknown_users'; Variable_name Value Connection_control_exempted_unknown_users 0 # ---------------------------------------------------------------------- # Following attempt will not experience any delay in server response (exempt enabled) SET @@global.connection_control_exempt_unknown_users= 1; closing connection closing connection closing connection Connection_control_delay_generated should be 0 SHOW STATUS LIKE 'Connection_control_delay_generated'; Variable_name Value Connection_control_delay_generated 0 # Connection_control_exempted_unknown_users should be 3 SHOW STATUS LIKE 'Connection_control_exempted_unknown_users'; Variable_name Value Connection_control_exempted_unknown_users 3 # Following attempt will experience delay in server response (exempt disabled) SET @@global.connection_control_exempt_unknown_users= 0; closing connection closing connection closing connection Connection_control_delay_generated should be 1 SHOW STATUS LIKE 'Connection_control_delay_generated'; Variable_name Value Connection_control_delay_generated 1 # Connection_control_exempted_unknown_users should still be 3 SHOW STATUS LIKE 'Connection_control_exempted_unknown_users'; Variable_name Value Connection_control_exempted_unknown_users 3 # ---------------------------------------------------------------------- # Cleanup # Restore original values of connection_control variables SET @@global.connection_control_failed_connections_threshold = @saved_connections_threshold; SET @@global.connection_control_max_connection_delay = @saved_max_delay; SET @@global.connection_control_exempt_unknown_users= @saved_exempt; # Uninstall connection_control plugin UNINSTALL PLUGIN connection_control; UNINSTALL PLUGIN connection_control_failed_login_attempts; # ----------------------------------------------------------------------