Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [root@docker devel]# ansible-playbook mysql.yml -vvv
- ansible-playbook 2.9.25
- config file = /etc/ansible/ansible.cfg
- configured module search path = [u'/root/.ansible/plugins/modules', u'/usr/share/ansible/plugins/modules']
- ansible python module location = /usr/lib/python2.7/site-packages/ansible
- executable location = /usr/bin/ansible-playbook
- python version = 2.7.5 (default, Nov 16 2020, 22:23:17) [GCC 4.8.5 20150623 (Red Hat 4.8.5-44)]
- Using /etc/ansible/ansible.cfg as config file
- host_list declined parsing /etc/ansible/hosts as it did not pass its verify_file() method
- script declined parsing /etc/ansible/hosts as it did not pass its verify_file() method
- auto declined parsing /etc/ansible/hosts as it did not pass its verify_file() method
- Parsed /etc/ansible/hosts inventory source with ini plugin
- Skipping callback 'actionable', as we already have a stdout callback.
- Skipping callback 'counter_enabled', as we already have a stdout callback.
- Skipping callback 'debug', as we already have a stdout callback.
- Skipping callback 'dense', as we already have a stdout callback.
- Skipping callback 'dense', as we already have a stdout callback.
- Skipping callback 'full_skip', as we already have a stdout callback.
- Skipping callback 'json', as we already have a stdout callback.
- Skipping callback 'minimal', as we already have a stdout callback.
- Skipping callback 'null', as we already have a stdout callback.
- Skipping callback 'oneline', as we already have a stdout callback.
- Skipping callback 'selective', as we already have a stdout callback.
- Skipping callback 'skippy', as we already have a stdout callback.
- Skipping callback 'stderr', as we already have a stdout callback.
- Skipping callback 'unixy', as we already have a stdout callback.
- Skipping callback 'yaml', as we already have a stdout callback.
- PLAYBOOK: mysql.yml ***************************************************************************************************************************
- 1 plays in mysql.yml
- PLAY [bigfoot] ********************************************************************************************************************************
- META: ran handlers
- TASK [Set some values in the test db] *********************************************************************************************************
- task path: /root/devel/mysql.yml:5
- <192.168.58.120> ESTABLISH SSH CONNECTION FOR USER: root
- <192.168.58.120> SSH: EXEC sshpass -d8 ssh -C -o ControlMaster=auto -o ControlPersist=60s -o StrictHostKeyChecking=no -o Port=22 -o 'User="root"' -o ConnectTimeout=10 -o StrictHostKeyChecking=no -o ControlPath=/root/.ansible/cp/d735d34ed4 192.168.58.120 '/bin/sh -c '"'"'echo ~root && sleep 0'"'"''
- <192.168.58.120> (0, '/root\n', '')
- <192.168.58.120> ESTABLISH SSH CONNECTION FOR USER: root
- <192.168.58.120> SSH: EXEC sshpass -d8 ssh -C -o ControlMaster=auto -o ControlPersist=60s -o StrictHostKeyChecking=no -o Port=22 -o 'User="root"' -o ConnectTimeout=10 -o StrictHostKeyChecking=no -o ControlPath=/root/.ansible/cp/d735d34ed4 192.168.58.120 '/bin/sh -c '"'"'( umask 77 && mkdir -p "` echo /root/.ansible/tmp `"&& mkdir "` echo /root/.ansible/tmp/ansible-tmp-1638618926.38-3990-131702777483260 `" && echo ansible-tmp-1638618926.38-3990-131702777483260="` echo /root/.ansible/tmp/ansible-tmp-1638618926.38-3990-131702777483260 `" ) && sleep 0'"'"''
- <192.168.58.120> (0, 'ansible-tmp-1638618926.38-3990-131702777483260=/root/.ansible/tmp/ansible-tmp-1638618926.38-3990-131702777483260\n', '')
- <192.168.58.120> Attempting python interpreter discovery
- <192.168.58.120> ESTABLISH SSH CONNECTION FOR USER: root
- <192.168.58.120> SSH: EXEC sshpass -d8 ssh -C -o ControlMaster=auto -o ControlPersist=60s -o StrictHostKeyChecking=no -o Port=22 -o 'User="root"' -o ConnectTimeout=10 -o StrictHostKeyChecking=no -o ControlPath=/root/.ansible/cp/d735d34ed4 192.168.58.120 '/bin/sh -c '"'"'echo PLATFORM; uname; echo FOUND; command -v '"'"'"'"'"'"'"'"'/usr/bin/python'"'"'"'"'"'"'"'"'; command -v '"'"'"'"'"'"'"'"'python3.7'"'"'"'"'"'"'"'"'; command -v '"'"'"'"'"'"'"'"'python3.6'"'"'"'"'"'"'"'"'; command -v '"'"'"'"'"'"'"'"'python3.5'"'"'"'"'"'"'"'"'; command -v '"'"'"'"'"'"'"'"'python2.7'"'"'"'"'"'"'"'"'; command -v '"'"'"'"'"'"'"'"'python2.6'"'"'"'"'"'"'"'"'; command -v '"'"'"'"'"'"'"'"'/usr/libexec/platform-python'"'"'"'"'"'"'"'"'; command -v '"'"'"'"'"'"'"'"'/usr/bin/python3'"'"'"'"'"'"'"'"'; command -v '"'"'"'"'"'"'"'"'python'"'"'"'"'"'"'"'"'; echo ENDFOUND && sleep 0'"'"''
- <192.168.58.120> (0, 'PLATFORM\nLinux\nFOUND\n/usr/bin/python\n/usr/bin/python3.6\n/usr/bin/python2.7\n/usr/libexec/platform-python\n/usr/bin/python3\n/usr/bin/python\nENDFOUND\n', '')
- <192.168.58.120> ESTABLISH SSH CONNECTION FOR USER: root
- <192.168.58.120> SSH: EXEC sshpass -d8 ssh -C -o ControlMaster=auto -o ControlPersist=60s -o StrictHostKeyChecking=no -o Port=22 -o 'User="root"' -o ConnectTimeout=10 -o StrictHostKeyChecking=no -o ControlPath=/root/.ansible/cp/d735d34ed4 192.168.58.120 '/bin/sh -c '"'"'/usr/bin/python && sleep 0'"'"''
- <192.168.58.120> (0, '{"osrelease_content": "NAME=\\"CentOS Linux\\"\\nVERSION=\\"7 (Core)\\"\\nID=\\"centos\\"\\nID_LIKE=\\"rhel fedora\\"\\nVERSION_ID=\\"7\\"\\nPRETTY_NAME=\\"CentOS Linux 7 (Core)\\"\\nANSI_COLOR=\\"0;31\\"\\nCPE_NAME=\\"cpe:/o:centos:centos:7\\"\\nHOME_URL=\\"https://www.centos.org/\\"\\nBUG_REPORT_URL=\\"https://bugs.centos.org/\\"\\n\\nCENTOS_MANTISBT_PROJECT=\\"CentOS-7\\"\\nCENTOS_MANTISBT_PROJECT_VERSION=\\"7\\"\\nREDHAT_SUPPORT_PRODUCT=\\"centos\\"\\nREDHAT_SUPPORT_PRODUCT_VERSION=\\"7\\"\\n\\n", "platform_dist_result": ["centos", "7.9.2009", "Core"]}\n', '')
- Using module file /root/.ansible/collections/ansible_collections/community/general/plugins/modules/odbc.py
- <192.168.58.120> PUT /root/.ansible/tmp/ansible-local-3979udjQ7r/tmpFYnL_t TO /root/.ansible/tmp/ansible-tmp-1638618926.38-3990-131702777483260/AnsiballZ_odbc.py
- <192.168.58.120> SSH: EXEC sshpass -d8 sftp -o BatchMode=no -b - -C -o ControlMaster=auto -o ControlPersist=60s -o StrictHostKeyChecking=no -o Port=22 -o 'User="root"' -o ConnectTimeout=10 -o StrictHostKeyChecking=no -o ControlPath=/root/.ansible/cp/d735d34ed4 '[192.168.58.120]'
- <192.168.58.120> (0, 'sftp> put /root/.ansible/tmp/ansible-local-3979udjQ7r/tmpFYnL_t /root/.ansible/tmp/ansible-tmp-1638618926.38-3990-131702777483260/AnsiballZ_odbc.py\n', '')
- <192.168.58.120> ESTABLISH SSH CONNECTION FOR USER: root
- <192.168.58.120> SSH: EXEC sshpass -d8 ssh -C -o ControlMaster=auto -o ControlPersist=60s -o StrictHostKeyChecking=no -o Port=22 -o 'User="root"' -o ConnectTimeout=10 -o StrictHostKeyChecking=no -o ControlPath=/root/.ansible/cp/d735d34ed4 192.168.58.120 '/bin/sh -c '"'"'chmod u+x /root/.ansible/tmp/ansible-tmp-1638618926.38-3990-131702777483260/ /root/.ansible/tmp/ansible-tmp-1638618926.38-3990-131702777483260/AnsiballZ_odbc.py && sleep 0'"'"''
- <192.168.58.120> (0, '', '')
- <192.168.58.120> ESTABLISH SSH CONNECTION FOR USER: root
- <192.168.58.120> SSH: EXEC sshpass -d8 ssh -C -o ControlMaster=auto -o ControlPersist=60s -o StrictHostKeyChecking=no -o Port=22 -o 'User="root"' -o ConnectTimeout=10 -o StrictHostKeyChecking=no -o ControlPath=/root/.ansible/cp/d735d34ed4 -tt 192.168.58.120 '/bin/sh -c '"'"'/usr/bin/python /root/.ansible/tmp/ansible-tmp-1638618926.38-3990-131702777483260/AnsiballZ_odbc.py && sleep 0'"'"''
- <192.168.58.120> (1, '\r\n{"msg": "Failed to connect to DSN: (\'01000\', u\\"[01000] [unixODBC][Driver Manager]Can\'t open lib \'MySQL ODBC 8.0 Unicode Driver\' : file not found (0) (SQLDriverConnect)\\")", "failed": true, "exception": "WARNING: The below traceback may *not* be related to the actual failure.\\n File \\"/tmp/ansible_community.general.odbc_payload_2v_7Tk/ansible_community.general.odbc_payload.zip/ansible_collections/community/general/plugins/modules/odbc.py\\", line 113, in main\\n", "invocation": {"module_args": {"dsn": "VALUE_SPECIFIED_IN_NO_LOG_PARAMETER", "query": "SELECT @@version;", "params": [""], "commit": false}}}\r\n', 'Shared connection to 192.168.58.120 closed.\r\n')
- <192.168.58.120> Failed to connect to the host via ssh: Shared connection to 192.168.58.120 closed.
- <192.168.58.120> ESTABLISH SSH CONNECTION FOR USER: root
- <192.168.58.120> SSH: EXEC sshpass -d8 ssh -C -o ControlMaster=auto -o ControlPersist=60s -o StrictHostKeyChecking=no -o Port=22 -o 'User="root"' -o ConnectTimeout=10 -o StrictHostKeyChecking=no -o ControlPath=/root/.ansible/cp/d735d34ed4 192.168.58.120 '/bin/sh -c '"'"'rm -f -r /root/.ansible/tmp/ansible-tmp-1638618926.38-3990-131702777483260/ > /dev/null 2>&1 && sleep 0'"'"''
- <192.168.58.120> (0, '', '')
- The full traceback is:
- WARNING: The below traceback may *not* be related to the actual failure.
- File "/tmp/ansible_community.general.odbc_payload_2v_7Tk/ansible_community.general.odbc_payload.zip/ansible_collections/community/general/plugins/modules/odbc.py", line 113, in main
- fatal: [192.168.58.120]: FAILED! => {
- "ansible_facts": {
- "discovered_interpreter_python": "/usr/bin/python"
- },
- "changed": false,
- "invocation": {
- "module_args": {
- "commit": false,
- "dsn": "VALUE_SPECIFIED_IN_NO_LOG_PARAMETER",
- "params": [
- ""
- ],
- "query": "SELECT @@version;"
- }
- },
- "msg": "Failed to connect to DSN: ('01000', u\"[01000] [unixODBC][Driver Manager]Can't open lib 'MySQL ODBC 8.0 Unicode Driver' : file not found (0) (SQLDriverConnect)\")"
- }
- PLAY RECAP ************************************************************************************************************************************
- 192.168.58.120 : ok=0 changed=0 unreachable=0 failed=1 skipped=0 rescued=0 ignored=0
- [root@docker devel]#
Advertisement
Add Comment
Please, Sign In to add comment