{"id":2917,"status":"changed","playbook":{"id":3,"items":{"plays":37,"tasks":589,"results":576,"hosts":7,"files":222,"records":0},"arguments":{"version":null,"verbosity":0,"private_key_file":null,"remote_user":null,"connection":"openstack.osa.ssh","timeout":null,"ssh_common_args":null,"sftp_extra_args":null,"scp_extra_args":null,"ssh_extra_args":null,"ask_pass":false,"connection_password_file":null,"force_handlers":true,"flush_cache":false,"become":false,"become_method":"sudo","become_user":null,"become_ask_pass":false,"become_password_file":null,"tags":["all"],"skip_tags":[],"check":false,"diff":false,"inventory":["/home/zuul/src/opendev.org/openstack/openstack-ansible/inventory/dynamic_inventory.py","/home/zuul/src/opendev.org/openstack/openstack-ansible/inventory/inventory.ini","/etc/openstack_deploy/inventory.ini"],"listhosts":false,"subset":null,"extra_vars":"Not saved by ARA as configured by 'ignored_arguments'","vault_ids":[],"ask_vault_pass":false,"vault_password_files":[],"forks":4,"module_path":null,"syntax":false,"listtasks":false,"listtags":false,"step":false,"start_at_task":null,"args":["setup-infrastructure.yml"]},"labels":[{"id":1,"name":"check:False"},{"id":2,"name":"tags:all"}],"started":"2025-12-08T13:50:33.014895Z","ended":"2025-12-08T13:57:00.819740Z","duration":"00:06:27.804845","name":null,"ansible_version":"2.18.6","client_version":"1.7.4","python_version":"3.12.11","server_version":"1.7.4","status":"completed","path":"/home/zuul/src/opendev.org/openstack/openstack-ansible/playbooks/setup-infrastructure.yml","controller":"aio1.openstack.local","user":"root"},"play":{"id":35,"items":{"tasks":105,"results":102},"started":"2025-12-08T13:53:05.056868Z","ended":"2025-12-08T13:54:17.817545Z","duration":"00:01:12.760677","name":"Install galera server","status":"completed"},"task":{"id":1119,"items":{"results":1},"path":"/home/zuul/src/opendev.org/openstack/openstack-ansible-galera_server/tasks/galera_server_post_install.yml","tags":["skip_ansible_lint","molecule-idempotence-notest","galera_server-config","galera-server","galera"],"started":"2025-12-08T13:53:41.999668Z","ended":"2025-12-08T13:53:53.220592Z","duration":"00:00:11.220924","name":"galera_server : Run galera secure","uuid":"fa163eb8-f9d2-9afb-4f6b-000000001654","action":"command","lineno":57,"handler":false,"status":"completed","warnings":[],"deprecations":[],"exceptions":[],"file":385},"host":{"id":21,"name":"aio1-galera-container-077c7d39","changed":41,"failed":0,"ok":83,"skipped":24,"unreachable":0},"delegated_to":[],"content":{"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":"\nSTOP_MYSQL=false\n\nif ! systemctl status mariadb; then\n  STOP_MYSQL=true\n  systemctl set-environment MYSQLD_OPTS=\"--bind-address=127.0.0.1\"\n  systemctl start mariadb\n  sleep 10\n  systemctl status mariadb\nfi\n\nif mariadb-admin --no-defaults --port=3306 --socket=/var/run/mysqld/mysqld.sock --host=127.0.0.1 --user=root password \"76b72de21ed40d2184d96b153cd0e3f2df5ba\"; then\n  mariadb -u root -h localhost -e \"UPDATE mysql.user SET Password=PASSWORD('$rootpass') WHERE User='root';\"\n  mariadb -u root -h localhost -e \"DELETE FROM mysql.user WHERE user='';\"\n  mariadb -u root -h localhost -e \"DELETE FROM mysql.user WHERE User='root' AND Host NOT IN ('%', 'localhost', '127.0.0.1', '::1');\"\n  mariadb -u root -h localhost -e \"DELETE FROM mysql.db WHERE Db='test' OR Db='test\\_%';\"\n  mariadb -u root -h localhost -e \"GRANT ALL PRIVILEGES ON *.* TO 'admin'@'localhost' IDENTIFIED BY '76b72de21ed40d2184d96b153cd0e3f2df5ba' WITH GRANT OPTION;\"\n  mariadb -u root -h localhost -e \"GRANT ALL PRIVILEGES ON *.* TO 'admin'@'127.0.0.1' IDENTIFIED BY '76b72de21ed40d2184d96b153cd0e3f2df5ba' WITH GRANT OPTION;\"\n  mariadb -u root -h localhost -e \"GRANT ALL PRIVILEGES ON *.* TO 'admin'@'::1' IDENTIFIED BY '76b72de21ed40d2184d96b153cd0e3f2df5ba' WITH GRANT OPTION;\"\n  mariadb -u root -h localhost -e \"GRANT ALL PRIVILEGES ON *.* TO 'admin'@'%' IDENTIFIED BY '76b72de21ed40d2184d96b153cd0e3f2df5ba' WITH GRANT OPTION;\"\n  mariadb -u root -h localhost -e \"FLUSH PRIVILEGES;\"\nfi\n\u0007mariadb-admin: connect to server at '127.0.0.1' failed\nerror: 'Access denied for user 'root'@'localhost''\n\nif [ \"${STOP_MYSQL}\" = true ]; then\n  systemctl stop mariadb\nfi\n\n# Create a marker file to ensure this script is not run again\nsystemctl unset-environment MYSQLD_OPTS\ntouch \"/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":"\u25cb mariadb.service - MariaDB 11.8.3 database server\n     Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; preset: disabled)\n    Drop-In: /etc/systemd/system/mariadb.service.d\n             \u2514\u2500migrated-from-my.cnf-settings.conf, override.conf\n     Active: inactive (dead)\n       Docs: man:mariadbd(8)\n             https://mariadb.com/kb/en/library/systemd/\n\u25cf mariadb.service - MariaDB 11.8.3 database server\n     Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; preset: disabled)\n    Drop-In: /etc/systemd/system/mariadb.service.d\n             \u2514\u2500migrated-from-my.cnf-settings.conf, override.conf\n     Active: active (running) since Mon 2025-12-08 13:53:42 UTC; 10s ago\n Invocation: 6f3c0c1e74e848489803b79823ce3709\n       Docs: man:mariadbd(8)\n             https://mariadb.com/kb/en/library/systemd/\n    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)\n    Process: 1511 ExecStartPost=/bin/rm -f /var/lib/mysql/wsrep-start-position (code=exited, status=0/SUCCESS)\n   Main PID: 1499 (mariadbd)\n     Status: \"Taking your SQL requests now...\"\n      Tasks: 12 (limit: 62147)\n        CPU: 534ms\n     CGroup: /galera.slice/mariadb.service\n             \u2514\u25001499 /usr/sbin/mariadbd --bind-address=127.0.0.1\n\nDec 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\nDec 08 13:53:42 aio1-galera-container-077c7d39 mariadbd[1499]: 2025-12-08 13:53:42 0 [Note] Plugin 'FEEDBACK' is disabled.\nDec 08 13:53:42 aio1-galera-container-077c7d39 mariadbd[1499]: 2025-12-08 13:53:42 0 [Note] Plugin 'wsrep-provider' is disabled.\nDec 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\nDec 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\nDec 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'.\nDec 08 13:53:42 aio1-galera-container-077c7d39 mariadbd[1499]: 2025-12-08 13:53:42 0 [Note] mariadbd: Event Scheduler: Loaded 0 events\nDec 08 13:53:42 aio1-galera-container-077c7d39 mariadbd[1499]: 2025-12-08 13:53:42 0 [Note] /usr/sbin/mariadbd: ready for connections.\nDec 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\nDec 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."]},"created":"2025-12-08T13:53:53.213256Z","updated":"2025-12-08T13:53:53.213279Z","started":"2025-12-08T13:53:42.046209Z","ended":"2025-12-08T13:53:53.205967Z","duration":"00:00:11.159758","changed":true,"ignore_errors":false}