netclic
commented
3 weeks ago I've got the same error, did you manage to find a way to fix it somehow ? Franck.
Open raindog308 opened 6 months ago
netclic
commented
3 weeks ago I've got the same error, did you manage to find a way to fix it somehow ? Franck.
An exception occurred during task execution. To see the full traceback, use -vvv. The error was: TypeError: Value of unknown type: <class 'pymysql.err.OperationalError'>, (1356, "View 'mysql.user' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them") fatal: [XXXXX]: FAILED! => {"changed": false, "module_stderr": "Shared connection to XXX closed.\r\n", "module_stdout": "Traceback (most recent call last):\r\n File \"/root/.ansible/tmp/ansible-tmp-1709422622.129737-239635-205872561331651/AnsiballZ_mysql_secure_installation.py\", line 107, in <module>\r\n _ansiballz_main()\r\n File \"/root/.ansible/tmp/ansible-tmp-1709422622.129737-239635-205872561331651/AnsiballZ_mysql_secure_installation.py\", line 99, in _ansiballz_main\r\n invoke_module(zipped_mod, temp_path, ANSIBALLZ_PARAMS)\r\n File \"/root/.ansible/tmp/ansible-tmp-1709422622.129737-239635-205872561331651/AnsiballZ_mysql_secure_installation.py\", line 47, in invoke_module\r\n runpy.run_module(mod_name='ansible.modules.mysql_secure_installation', init_globals=dict(_module_fqn='ansible.modules.mysql_secure_installation', _modlib_path=modlib_path),\r\n File \"<frozen runpy>\", line 226, in run_module\r\n File \"<frozen runpy>\", line 98, in _run_module_code\r\n File \"<frozen runpy>\", line 88, in _run_code\r\n File \"/tmp/ansible_mysql_secure_installation_payload_2gy9mw8c/ansible_mysql_secure_installation_payload.zip/ansible/modules/mysql_secure_installation.py\", line 478, in <module>\r\n File \"/tmp/ansible_mysql_secure_installation_payload_2gy9mw8c/ansible_mysql_secure_installation_payload.zip/ansible/modules/mysql_secure_installation.py\", line 474, in main\r\n File \"/tmp/ansible_mysql_secure_installation_payload_2gy9mw8c/ansible_mysql_secure_installation_payload.zip/ansible/module_utils/basic.py\", line 1519, in exit_json\r\n File \"/tmp/ansible_mysql_secure_installation_payload_2gy9mw8c/ansible_mysql_secure_installation_payload.zip/ansible/module_utils/basic.py\", line 1512, in _return_formatted\r\n File \"/tmp/ansible_mysql_secure_installation_payload_2gy9mw8c/ansible_mysql_secure_installation_payload.zip/ansible/module_utils/common/parameters.py\", line 890, in remove_values\r\n File \"/tmp/ansible_mysql_secure_installation_payload_2gy9mw8c/ansible_mysql_secure_installation_payload.zip/ansible/module_utils/common/parameters.py\", line 461, in _remove_values_conditions\r\nTypeError: Value of unknown type: <class 'pymysql.err.OperationalError'>, (1356, \"View 'mysql.user' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them\")\r\n", "msg": "MODULE FAILURE\nSee stdout/stderr for the exact error", "rc": 1}