{"action":"opened","issue":{"url":"https://api.github.com/repos/leucos/ansible-proxysql/issues/2","repository_url":"https://api.github.com/repos/leucos/ansible-proxysql","labels_url":"https://api.github.com/repos/leucos/ansible-proxysql/issues/2/labels{/name}","comments_url":"https://api.github.com/repos/leucos/ansible-proxysql/issues/2/comments","events_url":"https://api.github.com/repos/leucos/ansible-proxysql/issues/2/events","html_url":"https://github.com/leucos/ansible-proxysql/issues/2","id":298004248,"number":2,"title":"Please add the followings to the tasks/proxysql.yml","user":{"login":"devsecops-guru","id":6641365,"avatar_url":"https://avatars1.githubusercontent.com/u/6641365?v=4","gravatar_id":"","url":"https://api.github.com/users/devsecops-guru","html_url":"https://github.com/devsecops-guru","followers_url":"https://api.github.com/users/devsecops-guru/followers","following_url":"https://api.github.com/users/devsecops-guru/following{/other_user}","gists_url":"https://api.github.com/users/devsecops-guru/gists{/gist_id}","starred_url":"https://api.github.com/users/devsecops-guru/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/devsecops-guru/subscriptions","organizations_url":"https://api.github.com/users/devsecops-guru/orgs","repos_url":"https://api.github.com/users/devsecops-guru/repos","events_url":"https://api.github.com/users/devsecops-guru/events{/privacy}","received_events_url":"https://api.github.com/users/devsecops-guru/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-02-17T13:18:24Z","updated_at":"2018-02-17T13:18:24Z","closed_at":null,"author_association":"NONE","body":"Hi,\r\n\r\nFirst of all thanks for your work. I was wondering if you can make some modifications. \r\n- installing **python-mysqldb** next to mysql-common and mysql-client. It will enable users to use all the Ansible ProxySQL modules (http://docs.ansible.com/ansible/latest/list_of_database_modules.html)\r\n\r\nPlus you are creating the /etc/proxysql.cnf with proper values, but those are not loading into the ProxySQL runtime layer actually (at lest for me). For that I had to add the following tasks:\r\n\r\n```\r\n    - name: Load the ProxySQL MYSQL USERS configuration from the config file to memory\r\n      proxysql_manage_config:\r\n        action: LOAD\r\n        config_layer: CONFIG\r\n        config_settings: MYSQL USERS\r\n        direction: FROM\r\n        login_user: \"{{ proxysql_admin_user }}\"\r\n        login_password: \"{{ proxysql_admin_password }}\"\r\n      tags:\r\n        - configure_proxysql\r\n\r\n    - name: Load the ProxySQL MYSQL USERS configuration from the config file to memory\r\n      proxysql_manage_config:\r\n        action: LOAD\r\n        config_layer: MEMORY\r\n        config_settings: MYSQL USERS\r\n        direction: FROM\r\n        login_user: \"{{ proxysql_admin_user }}\"\r\n        login_password: \"{{ proxysql_admin_password }}\"\r\n      tags:\r\n        - configure_proxysql\r\n\r\n    - name: Load the ProxySQL MYSQL SERVERS configuration from the config file to memory\r\n      proxysql_manage_config:\r\n        action: LOAD\r\n        config_layer: CONFIG\r\n        config_settings: MYSQL SERVERS\r\n        direction: FROM\r\n        login_user: \"{{ proxysql_admin_user }}\"\r\n        login_password: \"{{ proxysql_admin_password }}\"\r\n      tags:\r\n        - configure_proxysql\r\n\r\n    - name: Load the ProxySQL MYSQL SERVERS configuration from the config file to memory\r\n      proxysql_manage_config:\r\n        action: LOAD\r\n        config_layer: MEMORY\r\n        config_settings: MYSQL SERVERS\r\n        direction: FROM\r\n        login_user: \"{{ proxysql_admin_user }}\"\r\n        login_password: \"{{ proxysql_admin_password }}\"\r\n      tags:\r\n        - configure_proxysql\r\n```\r\n\r\nIf you want  I can create a pull request for these modifications as well."}}
{"actor":{"display_login":"devsecops-guru"}}