'Ansible couldn't resolve module/action 'mssql_script'?
I'm running an ansible role which updates DB tables according to the DB type (using SQL queries).
As for DB type MSSQL I'm trying to use the
community.general.mssql_script module, but can't seem to find it and getting the following error message when running the playbook:
ERROR! couldn't resolve module/action 'mssql_script'. This often indicates a misspelling, missing collection, or incorrect module path.
I've tried modifying the script to use the community.general.mssql_db module, instead, just to test that the community.general's modules exist and are installed.
Also I've installed the python dependency for the module pip install pymssql as stated in the module documentation page.
Additionally, I've tried reinstalling ansible-galaxy collection install community.general and, this still did not work.
Is there any other way to explicitly install the community.general.mssql_script module or some other module which will be used to run the update queries?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|