Playbook #3
/home/zuul/src/opendev.org/openstack/openstack-ansible/playbooks/setup-infrastructure.yml
Execution
Date 08 Dec 2025 13:50:33 +0000
Duration 00:06:27.80
Controller aio1.openstack.local
User root
Versions
Ansible 2.18.6
ara 1.7.4 / 1.7.4
Python 3.12.11
Summary
7 Hosts
589 Tasks
576 Results
37 Plays
222 Files
0 Records
check:False tags:all

Task result details


Field Value
changed 
True
cmd 
[
    "/usr/local/bin/galera_secure_node"
]
delta 
0:00:10.887419
end 
2025-12-08 13:53:53.185366
invocation 
{
    "module_args": {
        "_raw_params": "/usr/local/bin/galera_secure_node",
        "_uses_shell": false,
        "argv": null,
        "chdir": null,
        "creates": "/var/lib/mysql/osa_default_secured",
        "executable": null,
        "expand_argument_vars": true,
        "removes": null,
        "stdin": null,
        "stdin_add_newline": true,
        "strip_empty_ends": true
    }
}
msg
rc 
0
start 
2025-12-08 13:53:42.297947
stderr 
STOP_MYSQL=false

if ! systemctl status mariadb; then
  STOP_MYSQL=true
  systemctl set-environment MYSQLD_OPTS="--bind-address=127.0.0.1"
  systemctl start mariadb
  sleep 10
  systemctl status mariadb
fi

if mariadb-admin --no-defaults --port=3306 --socket=/var/run/mysqld/mysqld.sock --host=127.0.0.1 --user=root password "76b72de21ed40d2184d96b153cd0e3f2df5ba"; then
  mariadb -u root -h localhost -e "UPDATE mysql.user SET Password=PASSWORD('$rootpass') WHERE User='root';"
  mariadb -u root -h localhost -e "DELETE FROM mysql.user WHERE user='';"
  mariadb -u root -h localhost -e "DELETE FROM mysql.user WHERE User='root' AND Host NOT IN ('%', 'localhost', '127.0.0.1', '::1');"
  mariadb -u root -h localhost -e "DELETE FROM mysql.db WHERE Db='test' OR Db='test\_%';"
  mariadb -u root -h localhost -e "GRANT ALL PRIVILEGES ON *.* TO 'admin'@'localhost' IDENTIFIED BY '76b72de21ed40d2184d96b153cd0e3f2df5ba' WITH GRANT OPTION;"
  mariadb -u root -h localhost -e "GRANT ALL PRIVILEGES ON *.* TO 'admin'@'127.0.0.1' IDENTIFIED BY '76b72de21ed40d2184d96b153cd0e3f2df5ba' WITH GRANT OPTION;"
  mariadb -u root -h localhost -e "GRANT ALL PRIVILEGES ON *.* TO 'admin'@'::1' IDENTIFIED BY '76b72de21ed40d2184d96b153cd0e3f2df5ba' WITH GRANT OPTION;"
  mariadb -u root -h localhost -e "GRANT ALL PRIVILEGES ON *.* TO 'admin'@'%' IDENTIFIED BY '76b72de21ed40d2184d96b153cd0e3f2df5ba' WITH GRANT OPTION;"
  mariadb -u root -h localhost -e "FLUSH PRIVILEGES;"
fi
mariadb-admin: connect to server at '127.0.0.1' failed
error: 'Access denied for user 'root'@'localhost''

if [ "${STOP_MYSQL}" = true ]; then
  systemctl stop mariadb
fi

# Create a marker file to ensure this script is not run again
systemctl unset-environment MYSQLD_OPTS
touch "/var/lib/mysql/osa_default_secured"
stderr_lines 
[
    "",
    "STOP_MYSQL=false",
    "",
    "if ! systemctl status mariadb; then",
    "  STOP_MYSQL=true",
    "  systemctl set-environment MYSQLD_OPTS=\"--bind-address=127.0.0.1\"",
    "  systemctl start mariadb",
    "  sleep 10",
    "  systemctl status mariadb",
    "fi",
    "",
    "if mariadb-admin --no-defaults --port=3306 --socket=/var/run/mysqld/mysqld.sock --host=127.0.0.1 --user=root password \"76b72de21ed40d2184d96b153cd0e3f2df5ba\"; then",
    "  mariadb -u root -h localhost -e \"UPDATE mysql.user SET Password=PASSWORD('$rootpass') WHERE User='root';\"",
    "  mariadb -u root -h localhost -e \"DELETE FROM mysql.user WHERE user='';\"",
    "  mariadb -u root -h localhost -e \"DELETE FROM mysql.user WHERE User='root' AND Host NOT IN ('%', 'localhost', '127.0.0.1', '::1');\"",
    "  mariadb -u root -h localhost -e \"DELETE FROM mysql.db WHERE Db='test' OR Db='test\\_%';\"",
    "  mariadb -u root -h localhost -e \"GRANT ALL PRIVILEGES ON *.* TO 'admin'@'localhost' IDENTIFIED BY '76b72de21ed40d2184d96b153cd0e3f2df5ba' WITH GRANT OPTION;\"",
    "  mariadb -u root -h localhost -e \"GRANT ALL PRIVILEGES ON *.* TO 'admin'@'127.0.0.1' IDENTIFIED BY '76b72de21ed40d2184d96b153cd0e3f2df5ba' WITH GRANT OPTION;\"",
    "  mariadb -u root -h localhost -e \"GRANT ALL PRIVILEGES ON *.* TO 'admin'@'::1' IDENTIFIED BY '76b72de21ed40d2184d96b153cd0e3f2df5ba' WITH GRANT OPTION;\"",
    "  mariadb -u root -h localhost -e \"GRANT ALL PRIVILEGES ON *.* TO 'admin'@'%' IDENTIFIED BY '76b72de21ed40d2184d96b153cd0e3f2df5ba' WITH GRANT OPTION;\"",
    "  mariadb -u root -h localhost -e \"FLUSH PRIVILEGES;\"",
    "fi",
    "\u0007mariadb-admin: connect to server at '127.0.0.1' failed",
    "error: 'Access denied for user 'root'@'localhost''",
    "",
    "if [ \"${STOP_MYSQL}\" = true ]; then",
    "  systemctl stop mariadb",
    "fi",
    "",
    "# Create a marker file to ensure this script is not run again",
    "systemctl unset-environment MYSQLD_OPTS",
    "touch \"/var/lib/mysql/osa_default_secured\""
]
stdout 
○ mariadb.service - MariaDB 11.8.3 database server
     Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; preset: disabled)
    Drop-In: /etc/systemd/system/mariadb.service.d
             └─migrated-from-my.cnf-settings.conf, override.conf
     Active: inactive (dead)
       Docs: man:mariadbd(8)
             https://mariadb.com/kb/en/library/systemd/
● mariadb.service - MariaDB 11.8.3 database server
     Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; preset: disabled)
    Drop-In: /etc/systemd/system/mariadb.service.d
             └─migrated-from-my.cnf-settings.conf, override.conf
     Active: active (running) since Mon 2025-12-08 13:53:42 UTC; 10s ago
 Invocation: 6f3c0c1e74e848489803b79823ce3709
       Docs: man:mariadbd(8)
             https://mariadb.com/kb/en/library/systemd/
    Process: 1491 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ]   && echo _WSREP_START_POSITION=$VAR > /var/lib/mysql/wsrep-start-position || exit 1 (code=exited, status=0/SUCCESS)
    Process: 1511 ExecStartPost=/bin/rm -f /var/lib/mysql/wsrep-start-position (code=exited, status=0/SUCCESS)
   Main PID: 1499 (mariadbd)
     Status: "Taking your SQL requests now..."
      Tasks: 12 (limit: 62147)
        CPU: 534ms
     CGroup: /galera.slice/mariadb.service
             └─1499 /usr/sbin/mariadbd --bind-address=127.0.0.1

Dec 08 13:53:42 aio1-galera-container-077c7d39 mariadbd[1499]: 2025-12-08 13:53:42 0 [Note] InnoDB: log sequence number 46300; transaction id 14
Dec 08 13:53:42 aio1-galera-container-077c7d39 mariadbd[1499]: 2025-12-08 13:53:42 0 [Note] Plugin 'FEEDBACK' is disabled.
Dec 08 13:53:42 aio1-galera-container-077c7d39 mariadbd[1499]: 2025-12-08 13:53:42 0 [Note] Plugin 'wsrep-provider' is disabled.
Dec 08 13:53:42 aio1-galera-container-077c7d39 mariadbd[1499]: 2025-12-08 13:53:42 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
Dec 08 13:53:42 aio1-galera-container-077c7d39 mariadbd[1499]: 2025-12-08 13:53:42 0 [Note] InnoDB: Buffer pool(s) load completed at 251208 13:53:42
Dec 08 13:53:42 aio1-galera-container-077c7d39 mariadbd[1499]: 2025-12-08 13:53:42 0 [Note] Server socket created on IP: '127.0.0.1', port: '3306'.
Dec 08 13:53:42 aio1-galera-container-077c7d39 mariadbd[1499]: 2025-12-08 13:53:42 0 [Note] mariadbd: Event Scheduler: Loaded 0 events
Dec 08 13:53:42 aio1-galera-container-077c7d39 mariadbd[1499]: 2025-12-08 13:53:42 0 [Note] /usr/sbin/mariadbd: ready for connections.
Dec 08 13:53:42 aio1-galera-container-077c7d39 mariadbd[1499]: Version: '11.8.3-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
Dec 08 13:53:42 aio1-galera-container-077c7d39 systemd[1]: Started mariadb.service - MariaDB 11.8.3 database server.
stdout_lines 
[
    "\u25cb mariadb.service - MariaDB 11.8.3 database server",
    "     Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; preset: disabled)",
    "    Drop-In: /etc/systemd/system/mariadb.service.d",
    "             \u2514\u2500migrated-from-my.cnf-settings.conf, override.conf",
    "     Active: inactive (dead)",
    "       Docs: man:mariadbd(8)",
    "             https://mariadb.com/kb/en/library/systemd/",
    "\u25cf mariadb.service - MariaDB 11.8.3 database server",
    "     Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; preset: disabled)",
    "    Drop-In: /etc/systemd/system/mariadb.service.d",
    "             \u2514\u2500migrated-from-my.cnf-settings.conf, override.conf",
    "     Active: active (running) since Mon 2025-12-08 13:53:42 UTC; 10s ago",
    " Invocation: 6f3c0c1e74e848489803b79823ce3709",
    "       Docs: man:mariadbd(8)",
    "             https://mariadb.com/kb/en/library/systemd/",
    "    Process: 1491 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ]   && echo _WSREP_START_POSITION=$VAR > /var/lib/mysql/wsrep-start-position || exit 1 (code=exited, status=0/SUCCESS)",
    "    Process: 1511 ExecStartPost=/bin/rm -f /var/lib/mysql/wsrep-start-position (code=exited, status=0/SUCCESS)",
    "   Main PID: 1499 (mariadbd)",
    "     Status: \"Taking your SQL requests now...\"",
    "      Tasks: 12 (limit: 62147)",
    "        CPU: 534ms",
    "     CGroup: /galera.slice/mariadb.service",
    "             \u2514\u25001499 /usr/sbin/mariadbd --bind-address=127.0.0.1",
    "",
    "Dec 08 13:53:42 aio1-galera-container-077c7d39 mariadbd[1499]: 2025-12-08 13:53:42 0 [Note] InnoDB: log sequence number 46300; transaction id 14",
    "Dec 08 13:53:42 aio1-galera-container-077c7d39 mariadbd[1499]: 2025-12-08 13:53:42 0 [Note] Plugin 'FEEDBACK' is disabled.",
    "Dec 08 13:53:42 aio1-galera-container-077c7d39 mariadbd[1499]: 2025-12-08 13:53:42 0 [Note] Plugin 'wsrep-provider' is disabled.",
    "Dec 08 13:53:42 aio1-galera-container-077c7d39 mariadbd[1499]: 2025-12-08 13:53:42 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool",
    "Dec 08 13:53:42 aio1-galera-container-077c7d39 mariadbd[1499]: 2025-12-08 13:53:42 0 [Note] InnoDB: Buffer pool(s) load completed at 251208 13:53:42",
    "Dec 08 13:53:42 aio1-galera-container-077c7d39 mariadbd[1499]: 2025-12-08 13:53:42 0 [Note] Server socket created on IP: '127.0.0.1', port: '3306'.",
    "Dec 08 13:53:42 aio1-galera-container-077c7d39 mariadbd[1499]: 2025-12-08 13:53:42 0 [Note] mariadbd: Event Scheduler: Loaded 0 events",
    "Dec 08 13:53:42 aio1-galera-container-077c7d39 mariadbd[1499]: 2025-12-08 13:53:42 0 [Note] /usr/sbin/mariadbd: ready for connections.",
    "Dec 08 13:53:42 aio1-galera-container-077c7d39 mariadbd[1499]: Version: '11.8.3-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server",
    "Dec 08 13:53:42 aio1-galera-container-077c7d39 systemd[1]: Started mariadb.service - MariaDB 11.8.3 database server."
]