2025-10-03T08:15:20.166665330+00:00 stderr F INFO:__main__:Loading config file at /var/lib/kolla/config_files/config.json 2025-10-03T08:15:20.167967490+00:00 stderr F INFO:__main__:Validating config file 2025-10-03T08:15:20.167967490+00:00 stderr F INFO:__main__:Kolla config strategy set to: COPY_ALWAYS 2025-10-03T08:15:20.167967490+00:00 stderr F INFO:__main__:Copying service configuration files 2025-10-03T08:15:20.167967490+00:00 stderr F INFO:__main__:Copying /dev/null to /etc/libqb/force-filesystem-sockets 2025-10-03T08:15:20.167967490+00:00 stderr F INFO:__main__:Setting permission for /etc/libqb/force-filesystem-sockets 2025-10-03T08:15:20.169508569+00:00 stderr F INFO:__main__:Deleting /etc/my.cnf.d/galera.cnf 2025-10-03T08:15:20.169508569+00:00 stderr F INFO:__main__:Copying /var/lib/kolla/config_files/src/etc/my.cnf.d/galera.cnf to /etc/my.cnf.d/galera.cnf 2025-10-03T08:15:20.169508569+00:00 stderr F INFO:__main__:Copying /var/lib/kolla/config_files/src/etc/sysconfig/clustercheck to /etc/sysconfig/clustercheck 2025-10-03T08:15:20.169508569+00:00 stderr F INFO:__main__:Copying /var/lib/kolla/config_files/src/root/.my.cnf to /root/.my.cnf 2025-10-03T08:15:20.169990595+00:00 stderr F INFO:__main__:Copying /var/lib/kolla/config_files/src-tls/etc/pki/tls/private/mysql.key to /etc/pki/tls/private/mysql.key 2025-10-03T08:15:20.170346736+00:00 stderr F INFO:__main__:Copying /var/lib/kolla/config_files/src-tls/etc/pki/tls/certs/mysql.crt to /etc/pki/tls/certs/mysql.crt 2025-10-03T08:15:20.173208986+00:00 stderr F INFO:__main__:Writing out command to execute 2025-10-03T08:15:20.173208986+00:00 stderr F INFO:__main__:Setting permission for /etc/pki/tls/certs/mysql.crt 2025-10-03T08:15:20.173208986+00:00 stderr F INFO:__main__:Setting permission for /etc/pki/tls/private/mysql.key 2025-10-03T08:15:20.190696208+00:00 stderr F sudo: unable to send audit message: Operation not permitted 2025-10-03T08:15:20.251441728+00:00 stderr P chown: 2025-10-03T08:15:20.251529841+00:00 stderr P cannot access '/auth_pam_tool_dir/auth_pam_tool' 2025-10-03T08:15:20.251604253+00:00 stderr P : No such file or directory 2025-10-03T08:15:20.251642555+00:00 stderr F 2025-10-03T08:15:20.252055588+00:00 stdout F Couldn't set an owner to '/auth_pam_tool_dir/auth_pam_tool'. 2025-10-03T08:15:20.252055588+00:00 stdout F It must be root, the PAM authentication plugin doesn't work otherwise.. 2025-10-03T08:15:20.252055588+00:00 stdout F 2025-10-03T08:15:20.263149918+00:00 stdout F Cannot change ownership of the '/auth_pam_tool_dir' directory 2025-10-03T08:15:20.263149918+00:00 stdout F to the 'mysql' user. Check that you have the necessary permissions and try again. 2025-10-03T08:15:20.263149918+00:00 stdout F 2025-10-03T08:15:20.263149918+00:00 stdout F Installing MariaDB/MySQL system tables in '/var/lib/mysql' ... 2025-10-03T08:15:20.263224450+00:00 stderr F chown: cannot access '/auth_pam_tool_dir': No such file or directory 2025-10-03T08:15:21.000221371+00:00 stdout F OK 2025-10-03T08:15:21.000221371+00:00 stdout F 2025-10-03T08:15:21.000221371+00:00 stdout F To start mariadbd at boot time you have to copy 2025-10-03T08:15:21.000221371+00:00 stdout F support-files/mariadb.service to the right place for your system 2025-10-03T08:15:21.000221371+00:00 stdout F 2025-10-03T08:15:21.000221371+00:00 stdout F 2025-10-03T08:15:21.000221371+00:00 stdout F Two all-privilege accounts were created. 2025-10-03T08:15:21.000221371+00:00 stdout F One is root@localhost, it has no password, but you need to 2025-10-03T08:15:21.000221371+00:00 stdout F be system 'root' user to connect. Use, for example, sudo mysql 2025-10-03T08:15:21.000221371+00:00 stdout F The second is mysql@localhost, it has no password either, but 2025-10-03T08:15:21.000221371+00:00 stdout F you need to be the system 'mysql' user to connect. 2025-10-03T08:15:21.000221371+00:00 stdout F After connecting you can set the password, if you would need to be 2025-10-03T08:15:21.000221371+00:00 stdout F able to connect as any of these users with a password and without sudo 2025-10-03T08:15:21.000221371+00:00 stdout F 2025-10-03T08:15:21.000221371+00:00 stdout F See the MariaDB Knowledgebase at https://mariadb.com/kb 2025-10-03T08:15:21.000221371+00:00 stdout F 2025-10-03T08:15:21.000221371+00:00 stdout F You can start the MariaDB daemon with: 2025-10-03T08:15:21.000221371+00:00 stdout F cd '/usr' ; /usr/bin/mariadb-safe --datadir='/var/lib/mysql' 2025-10-03T08:15:21.000221371+00:00 stdout F 2025-10-03T08:15:21.000221371+00:00 stdout F You can test the MariaDB daemon with mysql-test-run.pl 2025-10-03T08:15:21.000221371+00:00 stdout F cd '/usr/share/mysql-test' ; perl mariadb-test-run.pl 2025-10-03T08:15:21.000221371+00:00 stdout F 2025-10-03T08:15:21.000221371+00:00 stdout F Please report any problems at https://mariadb.org/jira 2025-10-03T08:15:21.000221371+00:00 stdout F 2025-10-03T08:15:21.000221371+00:00 stdout F The latest information about MariaDB is available at https://mariadb.org/. 2025-10-03T08:15:21.000221371+00:00 stdout F 2025-10-03T08:15:21.000221371+00:00 stdout F Consider joining MariaDB's strong and vibrant community: 2025-10-03T08:15:21.000221371+00:00 stdout F https://mariadb.org/get-involved/ 2025-10-03T08:15:21.000221371+00:00 stdout F 2025-10-03T08:15:21.264551274+00:00 stdout F 251003 08:15:21 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'. 2025-10-03T08:15:21.310946640+00:00 stdout F 251003 08:15:21 mysqld_safe Starting mariadbd daemon with databases from /var/lib/mysql 2025-10-03T08:15:22.015244098+00:00 stderr F sudo: unable to send audit message: Operation not permitted 2025-10-03T08:15:22.022858798+00:00 stdout F spawn mysql_secure_installation 2025-10-03T08:15:22.042365924+00:00 stdout F 2025-10-03T08:15:22.042365924+00:00 stdout F NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB 2025-10-03T08:15:22.042365924+00:00 stdout F SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY! 2025-10-03T08:15:22.042365924+00:00 stdout F 2025-10-03T08:15:22.042365924+00:00 stdout F In order to log into MariaDB to secure it, we'll need the current 2025-10-03T08:15:22.042365924+00:00 stdout F password for the root user. If you've just installed MariaDB, and 2025-10-03T08:15:22.042476297+00:00 stdout F haven't set the root password yet, you should just press enter here. 2025-10-03T08:15:22.042476297+00:00 stdout F 2025-10-03T08:15:22.045734031+00:00 stdout P Enter current password for root (enter for none): 2025-10-03T08:15:22.046018520+00:00 stdout F 2025-10-03T08:15:22.064100661+00:00 stdout F OK, successfully used password, moving on... 2025-10-03T08:15:22.064100661+00:00 stdout F 2025-10-03T08:15:22.064160593+00:00 stdout P Setting the root password or using the unix_socket ensures that nobody 2025-10-03T08:15:22.064255856+00:00 stdout F 2025-10-03T08:15:22.064620037+00:00 stdout F can log into the MariaDB root user without the proper authorisation. 2025-10-03T08:15:22.064620037+00:00 stdout F 2025-10-03T08:15:22.064871005+00:00 stdout F You already have your root account protected, so you can safely answer 'n'. 2025-10-03T08:15:22.064871005+00:00 stdout F 2025-10-03T08:15:22.064871005+00:00 stdout P Switch to unix_socket authentication [Y/n] 2025-10-03T08:15:22.064943247+00:00 stdout F n 2025-10-03T08:15:22.065264788+00:00 stdout F ... skipping. 2025-10-03T08:15:22.065264788+00:00 stdout F 2025-10-03T08:15:22.065299689+00:00 stdout P You already have your root account protected, so you can safely answer 'n'. 2025-10-03T08:15:22.065458364+00:00 stdout F 2025-10-03T08:15:22.065458364+00:00 stdout F 2025-10-03T08:15:22.065458364+00:00 stdout P Change the root password? [Y/n] 2025-10-03T08:15:22.065517806+00:00 stdout F y 2025-10-03T08:15:22.068797269+00:00 stdout P New password: 2025-10-03T08:15:22.069069098+00:00 stdout F 2025-10-03T08:15:22.069069098+00:00 stdout P Re-enter new password: 2025-10-03T08:15:22.069266194+00:00 stdout F 2025-10-03T08:15:22.090295738+00:00 stdout F Password updated successfully! 2025-10-03T08:15:22.090295738+00:00 stdout F Reloading privilege tables.. 2025-10-03T08:15:22.102169704+00:00 stdout F ... Success! 2025-10-03T08:15:22.102169704+00:00 stdout F 2025-10-03T08:15:22.106579543+00:00 stdout F 2025-10-03T08:15:22.106624234+00:00 stdout P By default, a MariaDB installation has an anonymous user, allowing anyone 2025-10-03T08:15:22.106787519+00:00 stdout F 2025-10-03T08:15:22.106787519+00:00 stdout F to log into MariaDB without having to have a user account created for 2025-10-03T08:15:22.106787519+00:00 stdout F them. This is intended only for testing, and to make the installation 2025-10-03T08:15:22.106964725+00:00 stdout F go a bit smoother. You should remove them before moving into a 2025-10-03T08:15:22.106964725+00:00 stdout F production environment. 2025-10-03T08:15:22.106964725+00:00 stdout F 2025-10-03T08:15:22.107190603+00:00 stdout P Remove anonymous users? [Y/n] 2025-10-03T08:15:22.107227894+00:00 stdout F y 2025-10-03T08:15:22.119075598+00:00 stdout F ... Success! 2025-10-03T08:15:22.119075598+00:00 stdout F 2025-10-03T08:15:22.119075598+00:00 stdout F Normally, root should only be allowed to connect from 'localhost'. This 2025-10-03T08:15:22.119317706+00:00 stdout F ensures that someone cannot guess at the root password from the network. 2025-10-03T08:15:22.119317706+00:00 stdout F 2025-10-03T08:15:22.119317706+00:00 stdout P Disallow root login remotely? [Y/n] 2025-10-03T08:15:22.119356647+00:00 stdout F n 2025-10-03T08:15:22.119641296+00:00 stdout F ... skipping. 2025-10-03T08:15:22.119641296+00:00 stdout F 2025-10-03T08:15:22.119707598+00:00 stdout F By default, MariaDB comes with a database named 'test' that anyone can 2025-10-03T08:15:22.119851363+00:00 stdout F access. This is also intended only for testing, and should be removed 2025-10-03T08:15:22.119851363+00:00 stdout F before moving into a production environment. 2025-10-03T08:15:22.119886174+00:00 stdout F 2025-10-03T08:15:22.120067139+00:00 stdout P Remove test database and access to it? [Y/n] 2025-10-03T08:15:22.120101371+00:00 stdout F y 2025-10-03T08:15:22.120334828+00:00 stdout F - Dropping test database... 2025-10-03T08:15:22.131090338+00:00 stdout F ... Success! 2025-10-03T08:15:22.131090338+00:00 stdout F - Removing privileges on test database... 2025-10-03T08:15:22.143641795+00:00 stdout F ... Success! 2025-10-03T08:15:22.143641795+00:00 stdout F 2025-10-03T08:15:22.143741998+00:00 stdout F Reloading the privilege tables will ensure that all changes made so far 2025-10-03T08:15:22.143888073+00:00 stdout F will take effect immediately. 2025-10-03T08:15:22.143888073+00:00 stdout F 2025-10-03T08:15:22.143924734+00:00 stdout P Reload privilege tables now? [Y/n] 2025-10-03T08:15:22.144070778+00:00 stdout F y 2025-10-03T08:15:22.155877571+00:00 stdout F ... Success! 2025-10-03T08:15:22.155877571+00:00 stdout F 2025-10-03T08:15:22.155877571+00:00 stdout F Cleaning up... 2025-10-03T08:15:22.159037191+00:00 stdout F 2025-10-03T08:15:22.159037191+00:00 stdout F All done! If you've completed all of the above steps, your MariaDB 2025-10-03T08:15:22.159037191+00:00 stdout F installation should now be secure. 2025-10-03T08:15:22.159037191+00:00 stdout F 2025-10-03T08:15:22.159037191+00:00 stdout F Thanks for using MariaDB! 2025-10-03T08:15:23.479903783+00:00 stdout F 251003 08:15:23 mysqld_safe Logging to '/var/log/mariadb/mariadb.log'. 2025-10-03T08:15:23.548891902+00:00 stdout F 251003 08:15:23 mysqld_safe Starting mariadbd daemon with databases from /var/lib/mysql 2025-10-03T08:15:24.444488605+00:00 stdout F mysqld is alive