Skip to content

Instantly share code, notes, and snippets.

@markuman
Last active October 3, 2021 17:50
Show Gist options
  • Save markuman/fe118b9389eb4376e21251dbf84b398e to your computer and use it in GitHub Desktop.
Save markuman/fe118b9389eb4376e21251dbf84b398e to your computer and use it in GitHub Desktop.
proxysql_mysql_users bug
---
- 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