Arguments and configuration
Argument Value
version None
verbosity 1
ask_pass False
private_key_file None
remote_user None
connection smart
timeout 10
ssh_common_args
sftp_extra_args
scp_extra_args
ssh_extra_args
force_handlers True
flush_cache False
become False
become_method sudo
become_user None
become_ask_pass False
tags ['all']
skip_tags []
check False
syntax False
diff False
inventory ['/root/.ansible/test/tmp/mysql_user-dw1eeyxt-ÅÑŚÌβŁÈ/test/integration/inventory']
listhosts False
subset None
extra_vars Not saved by ARA as configured by 'ignored_arguments'
vault_ids []
ask_vault_pass False
vault_password_files []
forks 5
module_path None
listtasks False
listtags False
step False
start_at_task None
args ['mysql_user-5wacm7b7.yml']
Records No records have been saved with ara_record for this playbook.
Files
Hosts
Host Changed Failed Ok Skipped Unreachable
testhost 102 0 198 23 0
Play: testhost
Task: Gathering Facts (gather_facts)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:06 +0000
Task: setup_mysql_db : python 2 (set_fact)
Host Status Changed ignore_errors Duration Ended
testhost skipped False False 0:00:00 Fri, 31 May 2019 14:57:06 +0000
Task: setup_mysql_db : python 3 (set_fact)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:07 +0000
Task: setup_mysql_db : include_vars (include_vars)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:07 +0000
Task: setup_mysql_db : install mysqldb_test rpm dependencies (yum)
Host Status Changed ignore_errors Duration Ended
testhost skipped False False 0:00:00 Fri, 31 May 2019 14:57:07 +0000
Task: setup_mysql_db : install mysqldb_test rpm dependencies (dnf)
Host Status Changed ignore_errors Duration Ended
testhost skipped False False 0:00:00 Fri, 31 May 2019 14:57:07 +0000
Task: setup_mysql_db : install mysqldb_test debian dependencies (apt)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:01 Fri, 31 May 2019 14:57:08 +0000
Task: setup_mysql_db : install mysqldb_test FreeBSD dependencies (pkgng)
Host Status Changed ignore_errors Duration Ended
testhost skipped False False 0:00:00 Fri, 31 May 2019 14:57:09 +0000
Task: setup_mysql_db : install mysql-python package via pip (FreeBSD) (pip)
Host Status Changed ignore_errors Duration Ended
testhost skipped False False 0:00:00 Fri, 31 May 2019 14:57:09 +0000
Task: setup_mysql_db : enable mysql-server service (FreeBSD) (lineinfile)
Host Status Changed ignore_errors Duration Ended
testhost skipped False False 0:00:00 Fri, 31 May 2019 14:57:09 +0000
Task: setup_mysql_db : apply work-around for OverlayFS issue (command)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:10 +0000
Task: setup_mysql_db : restart mysql_db service (service)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:02 Fri, 31 May 2019 14:57:12 +0000
Task: setup_mysql_db : Detect socket path (shell)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:12 +0000
Task: setup_mysql_db : Set socket path (set_fact)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:12 +0000
Task: setup_remote_tmp_dir : make sure we have the ansible_os_family and ansible_distribution_version facts (setup)
Host Status Changed ignore_errors Duration Ended
testhost skipped False False 0:00:00 Fri, 31 May 2019 14:57:12 +0000
Task: setup_remote_tmp_dir : include_tasks (include_tasks)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:13 +0000
Task: setup_remote_tmp_dir : create temporary directory (tempfile)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:13 +0000
Task: setup_remote_tmp_dir : record temporary directory (set_fact)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:13 +0000
Task: mysql_user : create mysql user db_user1 (mysql_user)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:14 +0000
Task: mysql_user : assert output message mysql user was created (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:14 +0000
Task: mysql_user : run command to query for mysql user (command)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:14 +0000
Task: mysql_user : assert mysql user is present (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:14 +0000
Task: mysql_user : run command to show privileges for user (expect privileges in stdout) (command)
Host Status Changed ignore_errors Duration Ended
testhost skipped False False 0:00:00 Fri, 31 May 2019 14:57:14 +0000
Task: mysql_user : assert user has giving privileges (assert)
Host Status Changed ignore_errors Duration Ended
testhost skipped False False 0:00:00 Fri, 31 May 2019 14:57:15 +0000
Task: mysql_user : remove mysql user db_user1 (mysql_user)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:15 +0000
Task: mysql_user : assert output message mysql user was removed (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:15 +0000
Task: mysql_user : create blank mysql user to be removed later (mysql_user)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:16 +0000
Task: mysql_user : remove blank mysql user with hosts=all (expect changed) (mysql_user)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:16 +0000
Task: mysql_user : assert changed is true for removing all blank users (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:16 +0000
Task: mysql_user : remove blank mysql user with hosts=all (expect ok) (mysql_user)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:16 +0000
Task: mysql_user : assert changed is true for removing all blank users (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:17 +0000
Task: mysql_user : run command to query for mysql user (command)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:18 +0000
Task: mysql_user : assert mysql user is not present (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:18 +0000
Task: mysql_user : create mysql user db_user1 (mysql_user)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:18 +0000
Task: mysql_user : assert output message mysql user was created (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:19 +0000
Task: mysql_user : create mysql user that already exist (expect changed=false) (mysql_user)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:19 +0000
Task: mysql_user : assert output message mysql user was not created (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:19 +0000
Task: mysql_user : remove mysql user state=absent (expect changed=true) (mysql_user)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:19 +0000
Task: mysql_user : assert output message mysql user was removed (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:20 +0000
Task: mysql_user : run command to query for mysql user (command)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:20 +0000
Task: mysql_user : assert mysql user is not present (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:20 +0000
Task: mysql_user : remove mysql user that does not exist state=absent (expect changed=false) (mysql_user)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:20 +0000
Task: mysql_user : assert output message mysql user that does not exist (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:21 +0000
Task: mysql_user : run command to query for mysql user (command)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:21 +0000
Task: mysql_user : assert mysql user is not present (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:21 +0000
Task: mysql_user : create user with select privilege state=present (expect changed=true) (mysql_user)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:21 +0000
Task: mysql_user : run command to query for mysql user (command)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:22 +0000
Task: mysql_user : assert mysql user is present (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:22 +0000
Task: mysql_user : run command to show privileges for user (expect privileges in stdout) (command)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:22 +0000
Task: mysql_user : assert user has giving privileges (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:22 +0000
Task: mysql_user : remove mysql user db_user1 (mysql_user)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:23 +0000
Task: mysql_user : assert output message mysql user was removed (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:23 +0000
Task: mysql_user : create blank mysql user to be removed later (mysql_user)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:23 +0000
Task: mysql_user : remove blank mysql user with hosts=all (expect changed) (mysql_user)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:24 +0000
Task: mysql_user : assert changed is true for removing all blank users (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:24 +0000
Task: mysql_user : remove blank mysql user with hosts=all (expect ok) (mysql_user)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:24 +0000
Task: mysql_user : assert changed is true for removing all blank users (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:24 +0000
Task: mysql_user : run command to query for mysql user (command)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:25 +0000
Task: mysql_user : assert mysql user is not present (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:25 +0000
Task: mysql_user : create user with select privilege state=present (expect changed=true) (mysql_user)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:25 +0000
Task: mysql_user : run command to query for mysql user (command)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:25 +0000
Task: mysql_user : assert mysql user is present (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:26 +0000
Task: mysql_user : run command to show privileges for user (expect privileges in stdout) (command)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:26 +0000
Task: mysql_user : assert user has giving privileges (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:26 +0000
Task: mysql_user : remove mysql user db_user2 (mysql_user)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:26 +0000
Task: mysql_user : assert output message mysql user was removed (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:27 +0000
Task: mysql_user : create blank mysql user to be removed later (mysql_user)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:01 Fri, 31 May 2019 14:57:28 +0000
Task: mysql_user : remove blank mysql user with hosts=all (expect changed) (mysql_user)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:28 +0000
Task: mysql_user : assert changed is true for removing all blank users (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:28 +0000
Task: mysql_user : remove blank mysql user with hosts=all (expect ok) (mysql_user)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:29 +0000
Task: mysql_user : assert changed is true for removing all blank users (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:29 +0000
Task: mysql_user : run command to query for mysql user (command)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:29 +0000
Task: mysql_user : assert mysql user is not present (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:29 +0000
Task: mysql_user : give users access to multiple databases (mysql_user)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:01 Fri, 31 May 2019 14:57:31 +0000
Task: mysql_user : show grants access for user1 on multiple database (command)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:31 +0000
Task: mysql_user : assert grant access for user1 on multiple database (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:31 +0000
Task: mysql_user : show grants access for user2 on multiple database (command)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:32 +0000
Task: mysql_user : assert grant access for user2 on multiple database (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:32 +0000
Task: mysql_user : remove mysql user db_user1 (mysql_user)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:32 +0000
Task: mysql_user : assert output message mysql user was removed (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:32 +0000
Task: mysql_user : create blank mysql user to be removed later (mysql_user)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:33 +0000
Task: mysql_user : remove blank mysql user with hosts=all (expect changed) (mysql_user)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:33 +0000
Task: mysql_user : assert changed is true for removing all blank users (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:33 +0000
Task: mysql_user : remove blank mysql user with hosts=all (expect ok) (mysql_user)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:33 +0000
Task: mysql_user : assert changed is true for removing all blank users (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:34 +0000
Task: mysql_user : remove mysql user db_user2 (mysql_user)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:34 +0000
Task: mysql_user : assert output message mysql user was removed (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:34 +0000
Task: mysql_user : create blank mysql user to be removed later (mysql_user)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:34 +0000
Task: mysql_user : remove blank mysql user with hosts=all (expect changed) (mysql_user)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:35 +0000
Task: mysql_user : assert changed is true for removing all blank users (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:35 +0000
Task: mysql_user : remove blank mysql user with hosts=all (expect ok) (mysql_user)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:35 +0000
Task: mysql_user : assert changed is true for removing all blank users (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:35 +0000
Task: mysql_user : give user access to database via wildcard (mysql_user)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:36 +0000
Task: mysql_user : show grants access for user1 on multiple database (command)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:36 +0000
Task: mysql_user : assert grant access for user1 on multiple database (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:36 +0000
Task: mysql_user : change user access to database via wildcard (mysql_user)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:37 +0000
Task: mysql_user : show grants access for user1 on multiple database (command)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:37 +0000
Task: mysql_user : assert grant access for user1 on multiple database (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:37 +0000
Task: mysql_user : remove mysql user db_user1 (mysql_user)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:37 +0000
Task: mysql_user : assert output message mysql user was removed (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:38 +0000
Task: mysql_user : create blank mysql user to be removed later (mysql_user)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:38 +0000
Task: mysql_user : remove blank mysql user with hosts=all (expect changed) (mysql_user)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:38 +0000
Task: mysql_user : assert changed is true for removing all blank users (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:39 +0000
Task: mysql_user : remove blank mysql user with hosts=all (expect ok) (mysql_user)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:39 +0000
Task: mysql_user : assert changed is true for removing all blank users (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:39 +0000
Task: mysql_user : create user with basic select privileges (mysql_user)
Host Status Changed ignore_errors Duration Ended
testhost skipped False False 0:00:00 Fri, 31 May 2019 14:57:39 +0000
Task: mysql_user : run command to query for mysql user (command)
Host Status Changed ignore_errors Duration Ended
testhost skipped False False 0:00:00 Fri, 31 May 2019 14:57:39 +0000
Task: mysql_user : assert mysql user is present (assert)
Host Status Changed ignore_errors Duration Ended
testhost skipped False False 0:00:00 Fri, 31 May 2019 14:57:39 +0000
Task: mysql_user : run command to show privileges for user (expect privileges in stdout) (command)
Host Status Changed ignore_errors Duration Ended
testhost skipped False False 0:00:00 Fri, 31 May 2019 14:57:40 +0000
Task: mysql_user : assert user has giving privileges (assert)
Host Status Changed ignore_errors Duration Ended
testhost skipped False False 0:00:00 Fri, 31 May 2019 14:57:40 +0000
Task: mysql_user : create user with current privileges (expect changed=true) (mysql_user)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:40 +0000
Task: mysql_user : assert output message for current privileges (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:40 +0000
Task: mysql_user : run command to show privileges for user (expect privileges in stdout) (command)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:41 +0000
Task: mysql_user : assert user has correct privileges (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:41 +0000
Task: mysql_user : assert user has correct privileges (assert)
Host Status Changed ignore_errors Duration Ended
testhost skipped False False 0:00:00 Fri, 31 May 2019 14:57:41 +0000
Task: mysql_user : create database using user current privileges (mysql_db)
Host Status Changed ignore_errors Duration Ended
testhost ignored False True 0:00:00 Fri, 31 May 2019 14:57:41 +0000
Task: mysql_user : run command to test that database was not created (command)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:42 +0000
Task: mysql_user : assert database was not created (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:42 +0000
Task: mysql_user : Add privs to a specific table (expect changed) (mysql_user)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:42 +0000
Task: mysql_user : Assert that priv changed (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:42 +0000
Task: mysql_user : Add privs to a specific table (expect ok) (mysql_user)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:43 +0000
Task: mysql_user : Assert that priv did not change (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:43 +0000
Task: mysql_user : update user with all privileges (mysql_user)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:43 +0000
Task: mysql_user : run command to query for mysql user (command)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:44 +0000
Task: mysql_user : assert mysql user is present (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:44 +0000
Task: mysql_user : run command to show privileges for user (expect privileges in stdout) (command)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:44 +0000
Task: mysql_user : assert user has giving privileges (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:44 +0000
Task: mysql_user : create database using user (mysql_db)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:45 +0000
Task: mysql_user : run command to test database was created using user new privileges (command)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:45 +0000
Task: mysql_user : drop database using user (mysql_db)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:45 +0000
Task: mysql_user : remove username (mysql_user)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:46 +0000
Task: mysql_user : create user with basic select privileges (mysql_user)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:46 +0000
Task: mysql_user : run command to query for mysql user (command)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:46 +0000
Task: mysql_user : assert mysql user is present (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:46 +0000
Task: mysql_user : run command to show privileges for user (expect privileges in stdout) (command)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:47 +0000
Task: mysql_user : assert user has giving privileges (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:47 +0000
Task: mysql_user : create user with current privileges (expect changed=true) (mysql_user)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:47 +0000
Task: mysql_user : assert output message for current privileges (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:47 +0000
Task: mysql_user : run command to show privileges for user (expect privileges in stdout) (command)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:48 +0000
Task: mysql_user : assert user has correct privileges (assert)
Host Status Changed ignore_errors Duration Ended
testhost skipped False False 0:00:00 Fri, 31 May 2019 14:57:48 +0000
Task: mysql_user : assert user has correct privileges (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:48 +0000
Task: mysql_user : create database using user current privileges (mysql_db)
Host Status Changed ignore_errors Duration Ended
testhost ignored False True 0:00:00 Fri, 31 May 2019 14:57:48 +0000
Task: mysql_user : run command to test that database was not created (command)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:49 +0000
Task: mysql_user : assert database was not created (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:49 +0000
Task: mysql_user : Add privs to a specific table (expect changed) (mysql_user)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:49 +0000
Task: mysql_user : Assert that priv changed (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:49 +0000
Task: mysql_user : Add privs to a specific table (expect ok) (mysql_user)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:50 +0000
Task: mysql_user : Assert that priv did not change (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:50 +0000
Task: mysql_user : update user with all privileges (mysql_user)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:50 +0000
Task: mysql_user : run command to query for mysql user (command)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:51 +0000
Task: mysql_user : assert mysql user is present (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:51 +0000
Task: mysql_user : run command to show privileges for user (expect privileges in stdout) (command)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:51 +0000
Task: mysql_user : assert user has giving privileges (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:51 +0000
Task: mysql_user : create database using user (mysql_db)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:52 +0000
Task: mysql_user : run command to test database was created using user new privileges (command)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:52 +0000
Task: mysql_user : drop database using user (mysql_db)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:52 +0000
Task: mysql_user : remove username (mysql_user)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:53 +0000
Task: mysql_user : create user with basic select privileges (mysql_user)
Host Status Changed ignore_errors Duration Ended
testhost skipped False False 0:00:00 Fri, 31 May 2019 14:57:53 +0000
Task: mysql_user : run command to query for mysql user (command)
Host Status Changed ignore_errors Duration Ended
testhost skipped False False 0:00:00 Fri, 31 May 2019 14:57:53 +0000
Task: mysql_user : assert mysql user is present (assert)
Host Status Changed ignore_errors Duration Ended
testhost skipped False False 0:00:00 Fri, 31 May 2019 14:57:53 +0000
Task: mysql_user : run command to show privileges for user (expect privileges in stdout) (command)
Host Status Changed ignore_errors Duration Ended
testhost skipped False False 0:00:00 Fri, 31 May 2019 14:57:53 +0000
Task: mysql_user : assert user has giving privileges (assert)
Host Status Changed ignore_errors Duration Ended
testhost skipped False False 0:00:00 Fri, 31 May 2019 14:57:53 +0000
Task: mysql_user : create user with current privileges (expect changed=true) (mysql_user)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:54 +0000
Task: mysql_user : assert output message for current privileges (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:54 +0000
Task: mysql_user : run command to show privileges for user (expect privileges in stdout) (command)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:54 +0000
Task: mysql_user : assert user has correct privileges (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:54 +0000
Task: mysql_user : assert user has correct privileges (assert)
Host Status Changed ignore_errors Duration Ended
testhost skipped False False 0:00:00 Fri, 31 May 2019 14:57:55 +0000
Task: mysql_user : create database using user current privileges (mysql_db)
Host Status Changed ignore_errors Duration Ended
testhost ignored False True 0:00:00 Fri, 31 May 2019 14:57:56 +0000
Task: mysql_user : run command to test that database was not created (command)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:56 +0000
Task: mysql_user : assert database was not created (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:56 +0000
Task: mysql_user : Add privs to a specific table (expect changed) (mysql_user)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:57 +0000
Task: mysql_user : Assert that priv changed (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:57 +0000
Task: mysql_user : Add privs to a specific table (expect ok) (mysql_user)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:57 +0000
Task: mysql_user : Assert that priv did not change (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:57 +0000
Task: mysql_user : update user with all privileges (mysql_user)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:58 +0000
Task: mysql_user : run command to query for mysql user (command)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:58 +0000
Task: mysql_user : assert mysql user is present (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:58 +0000
Task: mysql_user : run command to show privileges for user (expect privileges in stdout) (command)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:59 +0000
Task: mysql_user : assert user has giving privileges (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:57:59 +0000
Task: mysql_user : create database using user (mysql_db)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:59 +0000
Task: mysql_user : run command to test database was created using user new privileges (command)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:57:59 +0000
Task: mysql_user : drop database using user (mysql_db)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:58:00 +0000
Task: mysql_user : remove username (mysql_user)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:58:00 +0000
Task: mysql_user : create user with basic select privileges (mysql_user)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:58:00 +0000
Task: mysql_user : run command to query for mysql user (command)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:58:01 +0000
Task: mysql_user : assert mysql user is present (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:58:01 +0000
Task: mysql_user : run command to show privileges for user (expect privileges in stdout) (command)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:58:01 +0000
Task: mysql_user : assert user has giving privileges (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:58:01 +0000
Task: mysql_user : create user with current privileges (expect changed=true) (mysql_user)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:58:02 +0000
Task: mysql_user : assert output message for current privileges (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:58:02 +0000
Task: mysql_user : run command to show privileges for user (expect privileges in stdout) (command)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:58:02 +0000
Task: mysql_user : assert user has correct privileges (assert)
Host Status Changed ignore_errors Duration Ended
testhost skipped False False 0:00:00 Fri, 31 May 2019 14:58:02 +0000
Task: mysql_user : assert user has correct privileges (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:58:03 +0000
Task: mysql_user : create database using user current privileges (mysql_db)
Host Status Changed ignore_errors Duration Ended
testhost ignored False True 0:00:00 Fri, 31 May 2019 14:58:03 +0000
Task: mysql_user : run command to test that database was not created (command)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:58:03 +0000
Task: mysql_user : assert database was not created (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:58:03 +0000
Task: mysql_user : Add privs to a specific table (expect changed) (mysql_user)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:58:04 +0000
Task: mysql_user : Assert that priv changed (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:58:04 +0000
Task: mysql_user : Add privs to a specific table (expect ok) (mysql_user)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:58:04 +0000
Task: mysql_user : Assert that priv did not change (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:58:04 +0000
Task: mysql_user : update user with all privileges (mysql_user)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:58:05 +0000
Task: mysql_user : run command to query for mysql user (command)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:58:05 +0000
Task: mysql_user : assert mysql user is present (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:58:05 +0000
Task: mysql_user : run command to show privileges for user (expect privileges in stdout) (command)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:58:06 +0000
Task: mysql_user : assert user has giving privileges (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:58:06 +0000
Task: mysql_user : create database using user (mysql_db)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:58:06 +0000
Task: mysql_user : run command to test database was created using user new privileges (command)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:58:06 +0000
Task: mysql_user : drop database using user (mysql_db)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:58:07 +0000
Task: mysql_user : remove username (mysql_user)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:58:07 +0000
Task: mysql_user : Issue test setup - drop database (mysql_db)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:58:08 +0000
Task: mysql_user : Issue test setup - create database (mysql_db)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:58:08 +0000
Task: mysql_user : Copy SQL scripts to remote (copy)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:58:09 +0000
Task: mysql_user : Create function for test (shell)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:58:10 +0000
Task: mysql_user : Create procedure for test (shell)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:58:10 +0000
Task: mysql_user : Create user with FUNCTION and PROCEDURE privileges (mysql_user)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:58:10 +0000
Task: mysql_user : Assert Create user with FUNCTION and PROCEDURE privileges (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:58:10 +0000
Task: mysql_user : Create user with FUNCTION and PROCEDURE privileges - Idempotent check (mysql_user)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:58:11 +0000
Task: mysql_user : Assert Create user with FUNCTION and PROCEDURE privileges (assert)
Host Status Changed ignore_errors Duration Ended
testhost ok False False 0:00:00 Fri, 31 May 2019 14:58:11 +0000
Task: mysql_user : Remove user (mysql_user)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:58:11 +0000
Task: mysql_user : Issue test teardown - cleanup databases (mysql_db)
Host Status Changed ignore_errors Duration Ended
testhost changed True False 0:00:00 Fri, 31 May 2019 14:58:12 +0000
testhost changed True False 0:00:00 Fri, 31 May 2019 14:58:12 +0000