Install role need some maintenance

[markuman]

• drop xenial and add focal https://github.com/ansible-collections/community.proxysql/blob/main/roles/proxysql/meta/main.yml#L13
  • xenial EOL April 2021

Futhermore the role runs in sevaral errors on both, ubuntu 20.04 (focal) and 18.04 (bionic)

---
- hosts: localhost
  become: yes
  roles:
    - proxysql

bump version

it depends on percona repository and 2.0.10 is not available anymore.

fatal: [localhost]: FAILED! => {"changed": false, "msg": "Failure downloading https://github.com/sysown/proxysql/releases/download/v2.0.10/proxysql_2.0.10-ubuntu20_amd64.deb, HTTP Error 404: Not Found"}

alternatively, fetch packages from releases https://github.com/sysown/proxysql ?

lack of permissions

somewhere a become: yes is missing

TASK [proxysql : proxysql | config | copy proxysql config] **********************************************************************************************************************************************************
fatal: [localhost]: FAILED! => {"changed": false, "checksum": "4695d525ec65790820423a3051bd8fb8e5419675", "msg": "Destination /etc not writable"}

undefined variables

there are three undefined variables using proxysql_version: 2.3.2

failed: [localhost] (item={'key': 'default_sql_mode', 'value': {'variable': 'default_sql_mode', 'variable_value': None}}) => {"ansible_loop_var": "item", "changed": false, "item": {"key": "default_sql_mode", "value": {"variable": "default_sql_mode", "variable_value": null}}, "msg": "The variable \"mysql-default_sql_mode\" was not found"}
failed: [localhost] (item={'key': 'default_time_zone', 'value': {'variable': 'default_time_zone', 'variable_value': 'SYSTEM'}}) => {"ansible_loop_var": "item", "changed": false, "item": {"key": "default_time_zone", "value": {"variable": "default_time_zone", "variable_value": "SYSTEM"}}, "msg": "The variable \"mysql-default_time_zone\" was not found"}
failed: [localhost] (item={'key': 'forward_autocommit', 'value': {'variable': 'forward_autocommit', 'variable_value': 'false'}}) => {"ansible_loop_var": "item", "changed": false, "item": {"key": "forward_autocommit", "value": {"variable": "forward_autocommit", "variable_value": "false"}}, "msg": "The variable \"mysql-forward_autocommit\" was not found"}

[markuman]

@mrpk1906 do you have some time to help here and clean up the installation issues?

[Andersson007]

cc @mrpk1906 ^

[markuman]

Closed by #92
Thanks @mrpk1906