Getting errors like “/root/.virtualenvs/utils35/lib/python3.5/site-packages/pymysql/cursors.py:170: Warning: (1300, “Invalid utf8 character string: ‘9C1DCE’”) result = self._query(query)” when you run an ansible playbook with the ARA plugin? Change the mysql python lib to cymysql ie in $ANSIBLE_CONFIG [ara] database = mysql+cymysql://ara:dbpass@localhost/ara Seems like pymysql has issues with utf-8 & python v3
This is partly based on instructions from https://servercheck.in/blog/running-ansible-within-windows but uses a virtual environment and no checking out from Github / manually installing packages. Install Cygwin. Include following packages: python openssl / openssl-devel python-crypto python-openssl openssh Install & configure pip, virtualenv & virtualenvwrapper as per http://atbrox.com/2009/09/21/how-to-get-pipvirtualenvfabric-working-on-cygwin/ Create a virtual environment for ansible with mkvirtualenv –system-site-packages ansi …