-
-
Save markuman/fe118b9389eb4376e21251dbf84b398e to your computer and use it in GitHub Desktop.
proxysql_mysql_users bug
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
--- | |
- name: > | |
start proxysql container | |
hosts: localhost | |
connection: local | |
tasks: | |
- name: > | |
start proxysql container | |
community.docker.docker_container: | |
name: proxysql | |
image: proxysql/proxysql:2.3.0 | |
state: started | |
auto_remove: yes | |
recreate: yes | |
container_default_behavior: no_defaults | |
- name: add proxysql container temporary host group testing | |
add_host: hostname=proxysql groups=testing | |
- name: > | |
prepare proxysql container | |
and run tasks against it | |
hosts: testing | |
connection: docker | |
vars: | |
ansible_python_interpreter: /usr/bin/python3 | |
tasks: | |
- name: install pymysql requirements in docker container | |
apt: | |
name: | |
- python3-pymysql | |
- python3-apt | |
- mariadb-client | |
state: present | |
update_cache: yes | |
- name: add user to proxysql | |
proxysql_mysql_users: | |
state: present | |
username: someuser | |
password: password | |
default_hostgroup: 0 | |
login_user: admin | |
login_password: admin | |
load_to_runtime: yes | |
- name: idempotent add user to proxysql | |
proxysql_mysql_users: | |
state: present | |
username: someuser | |
password: password | |
default_hostgroup: 0 | |
login_user: admin | |
login_password: admin | |
load_to_runtime: yes | |
- name: load users back to memory because they are hashed in runtime | |
proxysql_manage_config: | |
login_user: admin | |
login_password: admin | |
action: "SAVE" | |
config_settings: MYSQL USERS | |
direction: "FROM" | |
config_layer: "RUNTIME" | |
- name: save hashed users also to disk | |
proxysql_manage_config: | |
login_user: admin | |
login_password: admin | |
action: "SAVE" | |
config_settings: MYSQL USERS | |
direction: "TO" | |
config_layer: "DISK" | |
- name: idempotent add user to proxysql | |
proxysql_mysql_users: | |
state: present | |
username: someuser | |
password: password | |
default_hostgroup: 0 | |
login_user: admin | |
login_password: admin | |
load_to_runtime: yes | |
- name: > | |
stop docker container / clean up local environment | |
hosts: localhost | |
connection: local | |
tasks: | |
- name: stop proxysql container | |
community.docker.docker_container: | |
name: proxysql | |
state: stopped | |
container_default_behavior: no_defaults |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment