Galera user creation fails

[Kai Bojens]

- Ubuntu 18.04
- Container: lxc
- Stein

The playbook "setup-infrastructure.yml" fails at creating MariaDB/Galera Users:

2019-04-16 14:04:17,730 p=12579 u=root | failed: [infra1_galera_container-4ab78163] (item={u'priv': u'*.*:USAGE', u'state': u'present', u'password': u'', u'host': u'localhost', u'name': u'monitoring'}) => {"ansible_loop_var": "item", "attempts": 3, "changed": false, "item": {"host": "localhost", "name": "monitoring", "password": "", "priv": "*.*:USAGE", "state": "present"}, "msg": "The PyMySQL (Python 2.7 and Python 3.X) or MySQL-python (Python 2.X) module is required."}

Installing "python3-pymysql" within the galera containers solves the problem and the second run of the playbook works fine.

[Rick Cano (canori01)]

Also happens on Ubuntu 16.04. I was running a Rocky to Stein upgrade and ran into this. Had to install the python2 version in my case(python-pymysql) but otherwise same behavior.

[Francois Deppierraz (francois-ctrlaltdel)]

Working on it, it first needs to be fixed in the openstack-ansible-galera_server:

https://review.opendev.org/#/c/684550/

[Dmitriy Rabotyagov (noonedeadpunk)]

https://review.opendev.org/#/c/717381/1 also should cover that specific issue. Marking as resolved