scroveez

ansible

Dec 4th, 2021
101
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.59 KB | None | 0 0
  1. [root@docker devel]# ansible-playbook mysql.yml -vvv
  2. ansible-playbook 2.9.25
  3. config file = /etc/ansible/ansible.cfg
  4. configured module search path = [u'/root/.ansible/plugins/modules', u'/usr/share/ansible/plugins/modules']
  5. ansible python module location = /usr/lib/python2.7/site-packages/ansible
  6. executable location = /usr/bin/ansible-playbook
  7. python version = 2.7.5 (default, Nov 16 2020, 22:23:17) [GCC 4.8.5 20150623 (Red Hat 4.8.5-44)]
  8. Using /etc/ansible/ansible.cfg as config file
  9. host_list declined parsing /etc/ansible/hosts as it did not pass its verify_file() method
  10. script declined parsing /etc/ansible/hosts as it did not pass its verify_file() method
  11. auto declined parsing /etc/ansible/hosts as it did not pass its verify_file() method
  12. Parsed /etc/ansible/hosts inventory source with ini plugin
  13. Skipping callback 'actionable', as we already have a stdout callback.
  14. Skipping callback 'counter_enabled', as we already have a stdout callback.
  15. Skipping callback 'debug', as we already have a stdout callback.
  16. Skipping callback 'dense', as we already have a stdout callback.
  17. Skipping callback 'dense', as we already have a stdout callback.
  18. Skipping callback 'full_skip', as we already have a stdout callback.
  19. Skipping callback 'json', as we already have a stdout callback.
  20. Skipping callback 'minimal', as we already have a stdout callback.
  21. Skipping callback 'null', as we already have a stdout callback.
  22. Skipping callback 'oneline', as we already have a stdout callback.
  23. Skipping callback 'selective', as we already have a stdout callback.
  24. Skipping callback 'skippy', as we already have a stdout callback.
  25. Skipping callback 'stderr', as we already have a stdout callback.
  26. Skipping callback 'unixy', as we already have a stdout callback.
  27. Skipping callback 'yaml', as we already have a stdout callback.
  28.  
  29. PLAYBOOK: mysql.yml ***************************************************************************************************************************
  30. 1 plays in mysql.yml
  31.  
  32. PLAY [bigfoot] ********************************************************************************************************************************
  33. META: ran handlers
  34.  
  35. TASK [Set some values in the test db] *********************************************************************************************************
  36. task path: /root/devel/mysql.yml:5
  37. <192.168.58.120> ESTABLISH SSH CONNECTION FOR USER: root
  38. <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'"'"''
  39. <192.168.58.120> (0, '/root\n', '')
  40. <192.168.58.120> ESTABLISH SSH CONNECTION FOR USER: root
  41. <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'"'"''
  42. <192.168.58.120> (0, 'ansible-tmp-1638618926.38-3990-131702777483260=/root/.ansible/tmp/ansible-tmp-1638618926.38-3990-131702777483260\n', '')
  43. <192.168.58.120> Attempting python interpreter discovery
  44. <192.168.58.120> ESTABLISH SSH CONNECTION FOR USER: root
  45. <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'"'"''
  46. <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', '')
  47. <192.168.58.120> ESTABLISH SSH CONNECTION FOR USER: root
  48. <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'"'"''
  49. <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', '')
  50. Using module file /root/.ansible/collections/ansible_collections/community/general/plugins/modules/odbc.py
  51. <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
  52. <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]'
  53. <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', '')
  54. <192.168.58.120> ESTABLISH SSH CONNECTION FOR USER: root
  55. <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'"'"''
  56. <192.168.58.120> (0, '', '')
  57. <192.168.58.120> ESTABLISH SSH CONNECTION FOR USER: root
  58. <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'"'"''
  59. <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')
  60. <192.168.58.120> Failed to connect to the host via ssh: Shared connection to 192.168.58.120 closed.
  61. <192.168.58.120> ESTABLISH SSH CONNECTION FOR USER: root
  62. <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'"'"''
  63. <192.168.58.120> (0, '', '')
  64. The full traceback is:
  65. WARNING: The below traceback may *not* be related to the actual failure.
  66. 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
  67. fatal: [192.168.58.120]: FAILED! => {
  68. "ansible_facts": {
  69. "discovered_interpreter_python": "/usr/bin/python"
  70. },
  71. "changed": false,
  72. "invocation": {
  73. "module_args": {
  74. "commit": false,
  75. "dsn": "VALUE_SPECIFIED_IN_NO_LOG_PARAMETER",
  76. "params": [
  77. ""
  78. ],
  79. "query": "SELECT @@version;"
  80. }
  81. },
  82. "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)\")"
  83. }
  84.  
  85. PLAY RECAP ************************************************************************************************************************************
  86. 192.168.58.120 : ok=0 changed=0 unreachable=0 failed=1 skipped=0 rescued=0 ignored=0
  87.  
  88. [root@docker devel]#
Advertisement
Add Comment
Please, Sign In to add comment