TsutomuNakamura
commented
2 years ago Instructions of mysql_secure_installation chould be changed to apply the version grater 10.4 for mariadb.
TASK [sql : Make sure that NOBODY can access the server without a password] *******************************************************************************************************************************************************************
fatal: [dev-controller01]: FAILED! => {"changed": true, "cmd": ["mysql", "-e", "UPDATE mysql.user SET Password=PASSWORD('YourPassword') WHERE User='root';"], "delta": "0:00:00.008499", "end": "2022-07-03 00:07:57.380822", "msg": "non-zero return code", "rc": 1, "start": "2022-07-03 00:07:57.372323", "stderr": "ERROR 1356 (HY000) at line 1: View 'mysql.user' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them", "stderr_lines": ["ERROR 1356 (HY000) at line 1: View 'mysql.user' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them"], "stdout": "", "stdout_lines": []}
build-server-ansible currently supports only Ubuntu 20.04. It should supports Ubuntu 22.04 now.