Fix ARA warnings with mysql

Getting errors like “/root/.virtualenvs/utils35/lib/python3.5/site-packages/pymysql/ 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

Add tracking IDs to your web application

With a complex multi-tier stack with HTTP requests getting proxied it can be difficult to track a request as it goes around the system. One thing you can do is enable mod_unique_id in apache – this creates a distinct environment variable UNIQUE_ID in the web server context for each incoming request. Simply loading the module …

Continue reading ‘Add tracking IDs to your web application’ »

Getting pam_ssh_agent_auth to work with Ansible

pam_ssh_agent_auth lets you use your ssh keys inside ssh-agent, that you forward in your ssh client connections to subsequently give you passwordless sudo via a destination side list of trusted public keys. This can be used with ansible which often needs root permissions, details below: There is a good (ubuntu specific) guide to setting pam_ssh_agent_auth up …

Continue reading ‘Getting pam_ssh_agent_auth to work with Ansible’ »