Execution
Date 15 Apr 2025 12:38:41 +0100
Duration 00:01:02.32
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
2 Hosts
17 Tasks
34 Results
1 Plays
1 Files
0 Records

Task result details

  • Status
    OK
  • Duration
    00:00:00.58
  • Play
    Playbook to install SuperDNS PDNS on alma8
  • Task
    Create powertdns database
  • Host
    ns4

Field Value
changed
False
cmd
set -o pipefail
pwgen -s 20 | head -1 > /root/pdns_pass.txt
mysql -e "CREATE DATABASE powerdns"
mysql -e "CREATE USER 'powerdns'@'localhost' IDENTIFIED BY '$(cat /root/pdns_pass.txt)'"
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
echo -e "database=\"powerdns\"" >> /root/.my.cnf
delta
0:00:00.210385
end
2025-04-15 11:39:31.376004
invocation
{
    "module_args": {
        "_raw_params": "set -o pipefail\npwgen -s 20 | head -1 > /root/pdns_pass.txt\nmysql -e \"CREATE DATABASE powerdns\"\nmysql -e \"CREATE USER 'powerdns'@'localhost' IDENTIFIED BY '$(cat /root/pdns_pass.txt)'\"\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\necho -e \"database=\\\"powerdns\\\"\" >> /root/.my.cnf\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

rc
0
start
2025-04-15 11:39:31.165619
stderr

stderr_lines
[]
stdout

stdout_lines
[]