AttributeError: 'module' object has no attribute 'cursors'

Archives Ansible Project
1

This is the error I get when using proxysql_manage_config module as documented here: https://docs.ansible.com/ansible/2.5/modules/proxysql_manage_config_module.html

Anyone know how I get around this issue?

2

Without showing the actual playbook, that’s going to be difficult.

So, what does the playbook look like?

Dick

3

Not much, the task in the playbook was simplified as per example:

  • name: Create proxysql user in proxy database
    proxysql_mysql_users:
    login_user: “{{ proxysql_admin_user }}”
    login_password: “{{ proxysql_admin_password }}”
    username: “{{ test_user }}”

password: “{{ test_user_pass }}”
state: present
load_to_runtime: true
save_to_disk: true

But this still errors with that message: attributeError: ‘module’ object has no attribute ‘cursors’. Googling around, I found this article: http://www.gadzmo.com/python/using-pythons-dictcursor-in-mysql-to-return-a-dict-with-keys/

I wonder if this a simple fix in the module code to 'import MySQLdb.cursors'..?

4

Did you find the solution?
I have the same issue after ansible 2.7 upgrade.

5

No, I had to perform task using ‘shell’.