Execution
Date 18 Sep 2024 10:46:31 +0100
Duration 00:00:52.81
Controller ssh-gw-4.layershift.com
User root
Versions
Ansible 2.16.11
ara 1.7.2 / 1.7.2
Python 3.10.10
Summary
1 Hosts
6 Tasks
6 Results
1 Plays
1 Files
0 Records

Task result details


Field Value
changed
False
cmd
set -o pipefail
mysql -e "CREATE DATABASE powerdns"
mysql -e "CREATE USER 'powerdns'@'localhost' IDENTIFIED BY 'Lu6B1jvVEFvU'"
mysql -e "GRANT ALL PRIVILEGES ON powerdns.* TO 'powerdns'@'localhost'"
mysql -e "flush privileges"
mysql powerdns < /usr/share/doc/pdns-backend-mysql/schema.mysql.sql
delta
0:00:00.038742
end
2024-09-18 09:47:24.392909
invocation
{
    "module_args": {
        "_raw_params": "set -o pipefail\nmysql -e \"CREATE DATABASE powerdns\"\nmysql -e \"CREATE USER 'powerdns'@'localhost' IDENTIFIED BY 'Lu6B1jvVEFvU'\"\nmysql -e \"GRANT ALL PRIVILEGES ON powerdns.* TO 'powerdns'@'localhost'\"\nmysql -e \"flush privileges\"\nmysql powerdns < /usr/share/doc/pdns-backend-mysql/schema.mysql.sql\n",
        "_uses_shell": true,
        "argv": null,
        "chdir": null,
        "creates": null,
        "executable": "/bin/bash",
        "expand_argument_vars": true,
        "removes": null,
        "stdin": null,
        "stdin_add_newline": true,
        "strip_empty_ends": true
    }
}
msg
non-zero return code
rc
1
start
2024-09-18 09:47:24.354167
stderr
ERROR 1049 (42000): Unknown database 'powerdns'
ERROR 1049 (42000): Unknown database 'powerdns'
ERROR 1049 (42000): Unknown database 'powerdns'
ERROR 1049 (42000): Unknown database 'powerdns'
ERROR 1049 (42000): Unknown database 'powerdns'
stderr_lines
[
    "ERROR 1049 (42000): Unknown database 'powerdns'",
    "ERROR 1049 (42000): Unknown database 'powerdns'",
    "ERROR 1049 (42000): Unknown database 'powerdns'",
    "ERROR 1049 (42000): Unknown database 'powerdns'",
    "ERROR 1049 (42000): Unknown database 'powerdns'"
]
stdout

stdout_lines
[]