Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

AttributeError: 'tuple' object has no attribute 'execute' #7

Open
charnet1019 opened this issue Jul 13, 2022 · 0 comments
Open

AttributeError: 'tuple' object has no attribute 'execute' #7

charnet1019 opened this issue Jul 13, 2022 · 0 comments

Comments

@charnet1019
Copy link

charnet1019 commented Jul 13, 2022

ansible version 2.13.1

Base info

[root@mysql ~]# cat /etc/redhat-release 
CentOS Linux release 7.9.2009 (Core)
[root@mysql ~]# python -V
Python 2.7.5

Error Info

TASK [proxysql : include_tasks] ************************************************************************************************************************************************************
task path: /home/ansible/roles/proxysql/tasks/config.yml:27
included: /home/ansible/roles/proxysql/tasks/config/proxysql_proxysql_servers.yml for proxysql_node001, proxysql_node002

TASK [proxysql : Manage ProxySQL cluster hosts] ********************************************************************************************************************************************
task path: /home/ansible/roles/proxysql/tasks/config/proxysql_proxysql_servers.yml:5
redirecting module_util ansible.module_utils.mysql to ansible_collections.community.mysql.plugins.module_utils.mysql
redirecting module_util ansible.module_utils.mysql to ansible_collections.community.mysql.plugins.module_utils.mysql
redirecting module_util ansible.module_utils.mysql to ansible_collections.community.mysql.plugins.module_utils.mysql
Using module file /home/ansible/roles/proxysql/library/proxysql_proxysql_servers.py
Pipelining is enabled.
<192.168.60.8> ESTABLISH SSH CONNECTION FOR USER: root
Using module file /home/ansible/roles/proxysql/library/proxysql_proxysql_servers.py
Pipelining is enabled.
<192.168.60.9> ESTABLISH SSH CONNECTION FOR USER: root
<192.168.60.8> SSH: EXEC sshpass -d11 ssh -C -o ControlMaster=auto -o ControlPersist=60s -o StrictHostKeyChecking=no -o Port=22 -o 'User="root"' -o ConnectTimeout=10 -o 'ControlPath="/root/.ansible/cp/9a07ef05c1"' 192.168.60.8 '/bin/sh -c '"'"'/usr/bin/python && sleep 0'"'"''
<192.168.60.9> SSH: EXEC sshpass -d12 ssh -C -o ControlMaster=auto -o ControlPersist=60s -o StrictHostKeyChecking=no -o Port=22 -o 'User="root"' -o ConnectTimeout=10 -o 'ControlPath="/root/.ansible/cp/a71210ddbc"' 192.168.60.9 '/bin/sh -c '"'"'/usr/bin/python && sleep 0'"'"''
<192.168.60.8> (1, b'', b'Traceback (most recent call last):\n  File "<stdin>", line 107, in <module>\n  File "<stdin>", line 99, in _ansiballz_main\n  File "<stdin>", line 48, in invoke_module\n  File "/usr/lib64/python2.7/runpy.py", line 176, in run_module\n    fname, loader, pkg_name)\n  File "/usr/lib64/python2.7/runpy.py", line 82, in _run_module_code\n    mod_name, mod_fname, mod_loader, pkg_name)\n  File "/usr/lib64/python2.7/runpy.py", line 72, in _run_code\n    exec code in run_globals\n  File "/tmp/ansible_proxysql_proxysql_servers_payload_QrjULu/ansible_proxysql_proxysql_servers_payload.zip/ansible/modules/proxysql_proxysql_servers.py", line 412, in <module>\n  File "/tmp/ansible_proxysql_proxysql_servers_payload_QrjULu/ansible_proxysql_proxysql_servers_payload.zip/ansible/modules/proxysql_proxysql_servers.py", line 374, in main\n  File "/tmp/ansible_proxysql_proxysql_servers_payload_QrjULu/ansible_proxysql_proxysql_servers_payload.zip/ansible/modules/proxysql_proxysql_servers.py", line 184, in check_server_config\nAttributeError: \'tuple\' object has no attribute \'execute\'\n')
<192.168.60.8> Failed to connect to the host via ssh: Traceback (most recent call last):
  File "<stdin>", line 107, in <module>
  File "<stdin>", line 99, in _ansiballz_main
  File "<stdin>", line 48, in invoke_module
  File "/usr/lib64/python2.7/runpy.py", line 176, in run_module
    fname, loader, pkg_name)
  File "/usr/lib64/python2.7/runpy.py", line 82, in _run_module_code
    mod_name, mod_fname, mod_loader, pkg_name)
  File "/usr/lib64/python2.7/runpy.py", line 72, in _run_code
    exec code in run_globals
  File "/tmp/ansible_proxysql_proxysql_servers_payload_QrjULu/ansible_proxysql_proxysql_servers_payload.zip/ansible/modules/proxysql_proxysql_servers.py", line 412, in <module>
  File "/tmp/ansible_proxysql_proxysql_servers_payload_QrjULu/ansible_proxysql_proxysql_servers_payload.zip/ansible/modules/proxysql_proxysql_servers.py", line 374, in main
  File "/tmp/ansible_proxysql_proxysql_servers_payload_QrjULu/ansible_proxysql_proxysql_servers_payload.zip/ansible/modules/proxysql_proxysql_servers.py", line 184, in check_server_config
AttributeError: 'tuple' object has no attribute 'execute'
The full traceback is:
Traceback (most recent call last):
  File "<stdin>", line 107, in <module>
  File "<stdin>", line 99, in _ansiballz_main
  File "<stdin>", line 48, in invoke_module
  File "/usr/lib64/python2.7/runpy.py", line 176, in run_module
    fname, loader, pkg_name)
  File "/usr/lib64/python2.7/runpy.py", line 82, in _run_module_code
    mod_name, mod_fname, mod_loader, pkg_name)
  File "/usr/lib64/python2.7/runpy.py", line 72, in _run_code
    exec code in run_globals
  File "/tmp/ansible_proxysql_proxysql_servers_payload_QrjULu/ansible_proxysql_proxysql_servers_payload.zip/ansible/modules/proxysql_proxysql_servers.py", line 412, in <module>
  File "/tmp/ansible_proxysql_proxysql_servers_payload_QrjULu/ansible_proxysql_proxysql_servers_payload.zip/ansible/modules/proxysql_proxysql_servers.py", line 374, in main
  File "/tmp/ansible_proxysql_proxysql_servers_payload_QrjULu/ansible_proxysql_proxysql_servers_payload.zip/ansible/modules/proxysql_proxysql_servers.py", line 184, in check_server_config
AttributeError: 'tuple' object has no attribute 'execute'
failed: [proxysql_node001] (item={'key': 'proxysql-srv-1', 'value': {'comment': 'proxysql-srv-1', 'hostname': '192.168.60.8', 'login_host': '127.0.0.1', 'login_password': 'admin', 'login_port': 6032, 'login_user': 'admin', 'port': 6032, 'weight': 0}}) => {
    "ansible_loop_var": "item",
    "changed": false,
    "item": {
        "key": "proxysql-srv-1",
        "value": {
            "comment": "proxysql-srv-1",
            "hostname": "192.168.60.8",
            "login_host": "127.0.0.1",
            "login_password": "admin",
            "login_port": 6032,
            "login_user": "admin",
            "port": 6032,
            "weight": 0
        }
    },
    "module_stderr": "Traceback (most recent call last):\n  File \"<stdin>\", line 107, in <module>\n  File \"<stdin>\", line 99, in _ansiballz_main\n  File \"<stdin>\", line 48, in invoke_module\n  File \"/usr/lib64/python2.7/runpy.py\", line 176, in run_module\n    fname, loader, pkg_name)\n  File \"/usr/lib64/python2.7/runpy.py\", line 82, in _run_module_code\n    mod_name, mod_fname, mod_loader, pkg_name)\n  File \"/usr/lib64/python2.7/runpy.py\", line 72, in _run_code\n    exec code in run_globals\n  File \"/tmp/ansible_proxysql_proxysql_servers_payload_QrjULu/ansible_proxysql_proxysql_servers_payload.zip/ansible/modules/proxysql_proxysql_servers.py\", line 412, in <module>\n  File \"/tmp/ansible_proxysql_proxysql_servers_payload_QrjULu/ansible_proxysql_proxysql_servers_payload.zip/ansible/modules/proxysql_proxysql_servers.py\", line 374, in main\n  File \"/tmp/ansible_proxysql_proxysql_servers_payload_QrjULu/ansible_proxysql_proxysql_servers_payload.zip/ansible/modules/proxysql_proxysql_servers.py\", line 184, in check_server_config\nAttributeError: 'tuple' object has no attribute 'execute'\n",
    "module_stdout": "",
    "msg": "MODULE FAILURE\nSee stdout/stderr for the exact error",
    "rc": 1
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant