Root password not set properly about ansible-role-mysql HOT 10 CLOSED

Can you confirm the .my.cnf file doesn't yet exist? Usually the cause of that error is something else previously created the file, or the task completed once, but if you change the root password outside the the playbook, or between runs, it might fail after that happens.

Log in via SSH and ls -lah inside /root/ or /home/username, if you're not using sudo/root for the playbook run.

from ansible-role-mysql.

My playbook is simply

---
- hosts: db
  sudo: yes

  vars_files:
    - vars.yml

  roles:
    - geerlingguy.firewall
    - geerlingguy.mysql

I can confirm the .my.cnf does not exist in /root/

I just purged mysql from the server and am running the playbook again.

from ansible-role-mysql.

Okay, thanks - let me know how it goes. I'm going to try a few configurations on my local setup with CentOS/Ubuntu and see if there's a difference. What OS/version are you using?

from ansible-role-mysql.

Ahh sorry. I'm running this on a Ubuntu 12.04 server.

from ansible-role-mysql.

It happened again. I'm curious if a difference in 12.04 is the issue here since I've recently used this role with 14.04 or debian 7 without issue.

from ansible-role-mysql.

I just ran the role against 12.04 on two different VMs - one from my role testing configuration (https://github.com/geerlingguy/ansible-role-test-vms), and another from the LAMP example here (https://github.com/geerlingguy/ansible-vagrant-examples/tree/master/lamp). Additionally, Travis (which is running this role's automated tests) seems to be passing currently, so I'm thinking it's something environment-specific.

When you run the playbook, does it report changes the first time it installs MySQL? (Actually, could you run the playbook with -vvvv and paste in the output for the MySQL section? Sanitize anything that shouldn't be seen, of course).

from ansible-role-mysql.

Thanks for the info, I'm running it now.

from ansible-role-mysql.

Some people like it here / others in a gist. Just let me know if you want me to move this to a gist

mconnerton@local:/opt/projects/remoteserver$ ansible-playbook -vvvv -i inventories/production/inventory playbooks/db/main.yml

PLAY [db] *********************************************************************

GATHERING FACTS ***************************************************************
mconnerton@remoteserver ESTABLISH CONNECTION FOR USER: matthew
mconnerton@remoteserver REMOTE_MODULE setup
mconnerton@remoteserver EXEC ssh -C -tt -vvv -o ControlMaster=auto -o ControlPersist=60s -o ControlPath="/home/matthew/.ansible/cp/ansible-ssh-%h-%p-%r" -o KbdInteractiveAuthentication=no -o PreferredAuthentications=gssapi-with-mic,gssapi-keyex,hostbased,publickey -o PasswordAuthentication=no -o ConnectTimeout=10 mconnerton@remoteserver /bin/sh -c 'mkdir -p $HOME/.ansible/tmp/ansible-tmp-1422031629.36-260140826386458 && chmod a+rx $HOME/.ansible/tmp/ansible-tmp-1422031629.36-260140826386458 && echo $HOME/.ansible/tmp/ansible-tmp-1422031629.36-260140826386458'
mconnerton@remoteserver PUT /tmp/tmp08WnQ4 TO /home/mconnerton/.ansible/tmp/ansible-tmp-1422031629.36-260140826386458/setup
mconnerton@remoteserver EXEC ssh -C -tt -vvv -o ControlMaster=auto -o ControlPersist=60s -o ControlPath="/home/matthew/.ansible/cp/ansible-ssh-%h-%p-%r" -o KbdInteractiveAuthentication=no -o PreferredAuthentications=gssapi-with-mic,gssapi-keyex,hostbased,publickey -o PasswordAuthentication=no -o ConnectTimeout=10 mconnerton@remoteserver /bin/sh -c 'sudo -k && sudo -H -S -p "[sudo via ansible, key=euyvcqaypnayzgtlexdcaslgynodtkfk] password: " -u root /bin/sh -c '"'"'echo SUDO-SUCCESS-euyvcqaypnayzgtlexdcaslgynodtkfk; LANG=en_US.UTF-8 LC_CTYPE=en_US.UTF-8 /usr/bin/python /home/mconnerton/.ansible/tmp/ansible-tmp-1422031629.36-260140826386458/setup; rm -rf /home/mconnerton/.ansible/tmp/ansible-tmp-1422031629.36-260140826386458/ >/dev/null 2>&1'"'"''
ok: [mconnerton@remoteserver]

TASK: [geerlingguy.firewall | Ensure iptables is installed (RedHat).] *********
skipping: [mconnerton@remoteserver]

TASK: [geerlingguy.firewall | Ensure iptables is installed (Debian).] *********
mconnerton@remoteserver ESTABLISH CONNECTION FOR USER: matthew
mconnerton@remoteserver REMOTE_MODULE apt pkg=iptables state=installed
mconnerton@remoteserver EXEC ssh -C -tt -vvv -o ControlMaster=auto -o ControlPersist=60s -o ControlPath="/home/matthew/.ansible/cp/ansible-ssh-%h-%p-%r" -o KbdInteractiveAuthentication=no -o PreferredAuthentications=gssapi-with-mic,gssapi-keyex,hostbased,publickey -o PasswordAuthentication=no -o ConnectTimeout=10 mconnerton@remoteserver /bin/sh -c 'mkdir -p $HOME/.ansible/tmp/ansible-tmp-1422031631.73-184809163938641 && chmod a+rx $HOME/.ansible/tmp/ansible-tmp-1422031631.73-184809163938641 && echo $HOME/.ansible/tmp/ansible-tmp-1422031631.73-184809163938641'
mconnerton@remoteserver PUT /tmp/tmptniEuq TO /home/mconnerton/.ansible/tmp/ansible-tmp-1422031631.73-184809163938641/apt
mconnerton@remoteserver EXEC ssh -C -tt -vvv -o ControlMaster=auto -o ControlPersist=60s -o ControlPath="/home/matthew/.ansible/cp/ansible-ssh-%h-%p-%r" -o KbdInteractiveAuthentication=no -o PreferredAuthentications=gssapi-with-mic,gssapi-keyex,hostbased,publickey -o PasswordAuthentication=no -o ConnectTimeout=10 mconnerton@remoteserver /bin/sh -c 'sudo -k && sudo -H -S -p "[sudo via ansible, key=rmxgpnwvdwilhfrtnfaawzvvwdosluyr] password: " -u root /bin/sh -c '"'"'echo SUDO-SUCCESS-rmxgpnwvdwilhfrtnfaawzvvwdosluyr; LANG=en_US.UTF-8 LC_CTYPE=en_US.UTF-8 /usr/bin/python /home/mconnerton/.ansible/tmp/ansible-tmp-1422031631.73-184809163938641/apt; rm -rf /home/mconnerton/.ansible/tmp/ansible-tmp-1422031631.73-184809163938641/ >/dev/null 2>&1'"'"''
ok: [mconnerton@remoteserver] => {"changed": false}

TASK: [geerlingguy.firewall | Flush iptables the first time playbook runs.] ***
mconnerton@remoteserver ESTABLISH CONNECTION FOR USER: matthew
mconnerton@remoteserver REMOTE_MODULE command iptables -F creates=/etc/init.d/firewall
mconnerton@remoteserver EXEC ssh -C -tt -vvv -o ControlMaster=auto -o ControlPersist=60s -o ControlPath="/home/matthew/.ansible/cp/ansible-ssh-%h-%p-%r" -o KbdInteractiveAuthentication=no -o PreferredAuthentications=gssapi-with-mic,gssapi-keyex,hostbased,publickey -o PasswordAuthentication=no -o ConnectTimeout=10 mconnerton@remoteserver /bin/sh -c 'mkdir -p $HOME/.ansible/tmp/ansible-tmp-1422031633.38-194375764382057 && chmod a+rx $HOME/.ansible/tmp/ansible-tmp-1422031633.38-194375764382057 && echo $HOME/.ansible/tmp/ansible-tmp-1422031633.38-194375764382057'
mconnerton@remoteserver PUT /tmp/tmpNXw5gM TO /home/mconnerton/.ansible/tmp/ansible-tmp-1422031633.38-194375764382057/command
mconnerton@remoteserver EXEC ssh -C -tt -vvv -o ControlMaster=auto -o ControlPersist=60s -o ControlPath="/home/matthew/.ansible/cp/ansible-ssh-%h-%p-%r" -o KbdInteractiveAuthentication=no -o PreferredAuthentications=gssapi-with-mic,gssapi-keyex,hostbased,publickey -o PasswordAuthentication=no -o ConnectTimeout=10 mconnerton@remoteserver /bin/sh -c 'sudo -k && sudo -H -S -p "[sudo via ansible, key=pfqrqakopjatbaafauanvqhovhkozusa] password: " -u root /bin/sh -c '"'"'echo SUDO-SUCCESS-pfqrqakopjatbaafauanvqhovhkozusa; LANG=en_US.UTF-8 LC_CTYPE=en_US.UTF-8 /usr/bin/python /home/mconnerton/.ansible/tmp/ansible-tmp-1422031633.38-194375764382057/command; rm -rf /home/mconnerton/.ansible/tmp/ansible-tmp-1422031633.38-194375764382057/ >/dev/null 2>&1'"'"''
ok: [mconnerton@remoteserver] => {"changed": false, "cmd": "iptables -F", "rc": 0, "stderr": false, "stdout": "skipped, since /etc/init.d/firewall exists"}

TASK: [geerlingguy.firewall | Copy firewall script into place.] ***************
mconnerton@remoteserver ESTABLISH CONNECTION FOR USER: matthew
mconnerton@remoteserver EXEC ssh -C -tt -vvv -o ControlMaster=auto -o ControlPersist=60s -o ControlPath="/home/matthew/.ansible/cp/ansible-ssh-%h-%p-%r" -o KbdInteractiveAuthentication=no -o PreferredAuthentications=gssapi-with-mic,gssapi-keyex,hostbased,publickey -o PasswordAuthentication=no -o ConnectTimeout=10 mconnerton@remoteserver /bin/sh -c 'mkdir -p $HOME/.ansible/tmp/ansible-tmp-1422031634.37-199729040673685 && chmod a+rx $HOME/.ansible/tmp/ansible-tmp-1422031634.37-199729040673685 && echo $HOME/.ansible/tmp/ansible-tmp-1422031634.37-199729040673685'
mconnerton@remoteserver EXEC ssh -C -tt -vvv -o ControlMaster=auto -o ControlPersist=60s -o ControlPath="/home/matthew/.ansible/cp/ansible-ssh-%h-%p-%r" -o KbdInteractiveAuthentication=no -o PreferredAuthentications=gssapi-with-mic,gssapi-keyex,hostbased,publickey -o PasswordAuthentication=no -o ConnectTimeout=10 mconnerton@remoteserver /bin/sh -c 'sudo -k && sudo -H -S -p "[sudo via ansible, key=sggvjvhkpgptxxkturuqkrtdznmnlwsq] password: " -u root /bin/sh -c '"'"'echo SUDO-SUCCESS-sggvjvhkpgptxxkturuqkrtdznmnlwsq; rc=flag; [ -r "/etc/firewall.bash" ] || rc=2; [ -f "/etc/firewall.bash" ] || rc=1; [ -d "/etc/firewall.bash" ] && rc=3; python -V 2>/dev/null || rc=4; [ x"$rc" != "xflag" ] && echo "${rc} /etc/firewall.bash" && exit 0; (python -c '"'"'"'"'"'"'"'"'import hashlib; print(hashlib.sha1(open("/etc/firewall.bash", "rb").read()).hexdigest())'"'"'"'"'"'"'"'"' 2>/dev/null) || (python -c '"'"'"'"'"'"'"'"'import sha; print(sha.sha(open("/etc/firewall.bash", "rb").read()).hexdigest())'"'"'"'"'"'"'"'"' 2>/dev/null) || (echo "0 /etc/firewall.bash")'"'"''
mconnerton@remoteserver PUT /tmp/tmpPaM0vy TO /home/mconnerton/.ansible/tmp/ansible-tmp-1422031634.37-199729040673685/file
mconnerton@remoteserver EXEC ssh -C -tt -vvv -o ControlMaster=auto -o ControlPersist=60s -o ControlPath="/home/matthew/.ansible/cp/ansible-ssh-%h-%p-%r" -o KbdInteractiveAuthentication=no -o PreferredAuthentications=gssapi-with-mic,gssapi-keyex,hostbased,publickey -o PasswordAuthentication=no -o ConnectTimeout=10 mconnerton@remoteserver /bin/sh -c 'sudo -k && sudo -H -S -p "[sudo via ansible, key=fpjloulasjnpakxgrvdiebxleaiapbcs] password: " -u root /bin/sh -c '"'"'echo SUDO-SUCCESS-fpjloulasjnpakxgrvdiebxleaiapbcs; LANG=en_US.UTF-8 LC_CTYPE=en_US.UTF-8 /usr/bin/python /home/mconnerton/.ansible/tmp/ansible-tmp-1422031634.37-199729040673685/file; rm -rf /home/mconnerton/.ansible/tmp/ansible-tmp-1422031634.37-199729040673685/ >/dev/null 2>&1'"'"''
ok: [mconnerton@remoteserver] => {"changed": false, "gid": 0, "group": "root", "mode": "0744", "owner": "root", "path": "/etc/firewall.bash", "size": 1541, "state": "file", "uid": 0}

TASK: [geerlingguy.firewall | Copy firewall init script into place.] **********
mconnerton@remoteserver ESTABLISH CONNECTION FOR USER: matthew
mconnerton@remoteserver EXEC ssh -C -tt -vvv -o ControlMaster=auto -o ControlPersist=60s -o ControlPath="/home/matthew/.ansible/cp/ansible-ssh-%h-%p-%r" -o KbdInteractiveAuthentication=no -o PreferredAuthentications=gssapi-with-mic,gssapi-keyex,hostbased,publickey -o PasswordAuthentication=no -o ConnectTimeout=10 mconnerton@remoteserver /bin/sh -c 'mkdir -p $HOME/.ansible/tmp/ansible-tmp-1422031635.77-64566321159230 && chmod a+rx $HOME/.ansible/tmp/ansible-tmp-1422031635.77-64566321159230 && echo $HOME/.ansible/tmp/ansible-tmp-1422031635.77-64566321159230'
mconnerton@remoteserver EXEC ssh -C -tt -vvv -o ControlMaster=auto -o ControlPersist=60s -o ControlPath="/home/matthew/.ansible/cp/ansible-ssh-%h-%p-%r" -o KbdInteractiveAuthentication=no -o PreferredAuthentications=gssapi-with-mic,gssapi-keyex,hostbased,publickey -o PasswordAuthentication=no -o ConnectTimeout=10 mconnerton@remoteserver /bin/sh -c 'sudo -k && sudo -H -S -p "[sudo via ansible, key=jperytcpgeoienwpwuiygayejjtbwqev] password: " -u root /bin/sh -c '"'"'echo SUDO-SUCCESS-jperytcpgeoienwpwuiygayejjtbwqev; rc=flag; [ -r "/etc/init.d/firewall" ] || rc=2; [ -f "/etc/init.d/firewall" ] || rc=1; [ -d "/etc/init.d/firewall" ] && rc=3; python -V 2>/dev/null || rc=4; [ x"$rc" != "xflag" ] && echo "${rc} /etc/init.d/firewall" && exit 0; (python -c '"'"'"'"'"'"'"'"'import hashlib; print(hashlib.sha1(open("/etc/init.d/firewall", "rb").read()).hexdigest())'"'"'"'"'"'"'"'"' 2>/dev/null) || (python -c '"'"'"'"'"'"'"'"'import sha; print(sha.sha(open("/etc/init.d/firewall", "rb").read()).hexdigest())'"'"'"'"'"'"'"'"' 2>/dev/null) || (echo "0 /etc/init.d/firewall")'"'"''
mconnerton@remoteserver PUT /tmp/tmp9X9o6w TO /home/mconnerton/.ansible/tmp/ansible-tmp-1422031635.77-64566321159230/file
mconnerton@remoteserver EXEC ssh -C -tt -vvv -o ControlMaster=auto -o ControlPersist=60s -o ControlPath="/home/matthew/.ansible/cp/ansible-ssh-%h-%p-%r" -o KbdInteractiveAuthentication=no -o PreferredAuthentications=gssapi-with-mic,gssapi-keyex,hostbased,publickey -o PasswordAuthentication=no -o ConnectTimeout=10 mconnerton@remoteserver /bin/sh -c 'sudo -k && sudo -H -S -p "[sudo via ansible, key=uvkjjmppqddxstkvtegpxfkgrdjdyxyi] password: " -u root /bin/sh -c '"'"'echo SUDO-SUCCESS-uvkjjmppqddxstkvtegpxfkgrdjdyxyi; LANG=en_US.UTF-8 LC_CTYPE=en_US.UTF-8 /usr/bin/python /home/mconnerton/.ansible/tmp/ansible-tmp-1422031635.77-64566321159230/file; rm -rf /home/mconnerton/.ansible/tmp/ansible-tmp-1422031635.77-64566321159230/ >/dev/null 2>&1'"'"''
ok: [mconnerton@remoteserver] => {"changed": false, "gid": 0, "group": "root", "mode": "0755", "owner": "root", "path": "/etc/init.d/firewall", "size": 862, "state": "file", "uid": 0}

TASK: [geerlingguy.firewall | Ensure the firewall is enabled and will start on boot.] ***
mconnerton@remoteserver ESTABLISH CONNECTION FOR USER: matthew
mconnerton@remoteserver REMOTE_MODULE service name=firewall state=started enabled=yes
mconnerton@remoteserver EXEC ssh -C -tt -vvv -o ControlMaster=auto -o ControlPersist=60s -o ControlPath="/home/matthew/.ansible/cp/ansible-ssh-%h-%p-%r" -o KbdInteractiveAuthentication=no -o PreferredAuthentications=gssapi-with-mic,gssapi-keyex,hostbased,publickey -o PasswordAuthentication=no -o ConnectTimeout=10 mconnerton@remoteserver /bin/sh -c 'mkdir -p $HOME/.ansible/tmp/ansible-tmp-1422031637.2-223233716070001 && chmod a+rx $HOME/.ansible/tmp/ansible-tmp-1422031637.2-223233716070001 && echo $HOME/.ansible/tmp/ansible-tmp-1422031637.2-223233716070001'
mconnerton@remoteserver PUT /tmp/tmpYBp8aX TO /home/mconnerton/.ansible/tmp/ansible-tmp-1422031637.2-223233716070001/service
mconnerton@remoteserver EXEC ssh -C -tt -vvv -o ControlMaster=auto -o ControlPersist=60s -o ControlPath="/home/matthew/.ansible/cp/ansible-ssh-%h-%p-%r" -o KbdInteractiveAuthentication=no -o PreferredAuthentications=gssapi-with-mic,gssapi-keyex,hostbased,publickey -o PasswordAuthentication=no -o ConnectTimeout=10 mconnerton@remoteserver /bin/sh -c 'sudo -k && sudo -H -S -p "[sudo via ansible, key=xxhkoisdxajgiduljyageyvxhgggezde] password: " -u root /bin/sh -c '"'"'echo SUDO-SUCCESS-xxhkoisdxajgiduljyageyvxhgggezde; LANG=en_US.UTF-8 LC_CTYPE=en_US.UTF-8 /usr/bin/python /home/mconnerton/.ansible/tmp/ansible-tmp-1422031637.2-223233716070001/service; rm -rf /home/mconnerton/.ansible/tmp/ansible-tmp-1422031637.2-223233716070001/ >/dev/null 2>&1'"'"''
ok: [mconnerton@remoteserver] => {"changed": false, "enabled": true, "name": "firewall", "state": "started"}

TASK: [geerlingguy.mysql | Include OS-specific variables.] ********************
mconnerton@remoteserver ESTABLISH CONNECTION FOR USER: matthew
ok: [mconnerton@remoteserver] => {"ansible_facts": {"__mysql_packages": ["mysql-common", "mysql-server", "python-mysqldb"], "mysql_config_file": "/etc/mysql/my.cnf", "mysql_daemon": "mysql", "mysql_socket": "/var/run/mysqld/mysqld.sock"}}

TASK: [geerlingguy.mysql | Define mysql_packages.] ****************************
mconnerton@remoteserver ESTABLISH CONNECTION FOR USER: matthew
ok: [mconnerton@remoteserver] => {"ansible_facts": {"mysql_packages": ["mysql-common", "mysql-server", "python-mysqldb"]}}

TASK: [geerlingguy.mysql | Update postfix to the latest version (if extra repositories enabled).] ***
skipping: [mconnerton@remoteserver]

TASK: [geerlingguy.mysql | Ensure MySQL packages are installed.] **************
skipping: [mconnerton@remoteserver]

TASK: [geerlingguy.mysql | Check if MySQL is already installed.] **************
mconnerton@remoteserver ESTABLISH CONNECTION FOR USER: matthew
mconnerton@remoteserver REMOTE_MODULE stat path=/etc/init.d/mysql
mconnerton@remoteserver EXEC ssh -C -tt -vvv -o ControlMaster=auto -o ControlPersist=60s -o ControlPath="/home/matthew/.ansible/cp/ansible-ssh-%h-%p-%r" -o KbdInteractiveAuthentication=no -o PreferredAuthentications=gssapi-with-mic,gssapi-keyex,hostbased,publickey -o PasswordAuthentication=no -o ConnectTimeout=10 mconnerton@remoteserver /bin/sh -c 'mkdir -p $HOME/.ansible/tmp/ansible-tmp-1422031638.38-251730114324349 && chmod a+rx $HOME/.ansible/tmp/ansible-tmp-1422031638.38-251730114324349 && echo $HOME/.ansible/tmp/ansible-tmp-1422031638.38-251730114324349'
mconnerton@remoteserver PUT /tmp/tmpKZhXUJ TO /home/mconnerton/.ansible/tmp/ansible-tmp-1422031638.38-251730114324349/stat
mconnerton@remoteserver EXEC ssh -C -tt -vvv -o ControlMaster=auto -o ControlPersist=60s -o ControlPath="/home/matthew/.ansible/cp/ansible-ssh-%h-%p-%r" -o KbdInteractiveAuthentication=no -o PreferredAuthentications=gssapi-with-mic,gssapi-keyex,hostbased,publickey -o PasswordAuthentication=no -o ConnectTimeout=10 mconnerton@remoteserver /bin/sh -c 'sudo -k && sudo -H -S -p "[sudo via ansible, key=bgtkzfkrmuvwottteemayykmdbboxljp] password: " -u root /bin/sh -c '"'"'echo SUDO-SUCCESS-bgtkzfkrmuvwottteemayykmdbboxljp; LANG=en_US.UTF-8 LC_CTYPE=en_US.UTF-8 /usr/bin/python /home/mconnerton/.ansible/tmp/ansible-tmp-1422031638.38-251730114324349/stat; rm -rf /home/mconnerton/.ansible/tmp/ansible-tmp-1422031638.38-251730114324349/ >/dev/null 2>&1'"'"''
ok: [mconnerton@remoteserver] => {"changed": false, "stat": {"exists": false}}

TASK: [geerlingguy.mysql | Update apt cache if MySQL is not yet installed.] ***
mconnerton@remoteserver ESTABLISH CONNECTION FOR USER: matthew
mconnerton@remoteserver REMOTE_MODULE apt update_cache=yes
mconnerton@remoteserver EXEC ssh -C -tt -vvv -o ControlMaster=auto -o ControlPersist=60s -o ControlPath="/home/matthew/.ansible/cp/ansible-ssh-%h-%p-%r" -o KbdInteractiveAuthentication=no -o PreferredAuthentications=gssapi-with-mic,gssapi-keyex,hostbased,publickey -o PasswordAuthentication=no -o ConnectTimeout=10 mconnerton@remoteserver /bin/sh -c 'mkdir -p $HOME/.ansible/tmp/ansible-tmp-1422031639.33-119061556829911 && chmod a+rx $HOME/.ansible/tmp/ansible-tmp-1422031639.33-119061556829911 && echo $HOME/.ansible/tmp/ansible-tmp-1422031639.33-119061556829911'
mconnerton@remoteserver PUT /tmp/tmpntlqfR TO /home/mconnerton/.ansible/tmp/ansible-tmp-1422031639.33-119061556829911/apt
mconnerton@remoteserver EXEC ssh -C -tt -vvv -o ControlMaster=auto -o ControlPersist=60s -o ControlPath="/home/matthew/.ansible/cp/ansible-ssh-%h-%p-%r" -o KbdInteractiveAuthentication=no -o PreferredAuthentications=gssapi-with-mic,gssapi-keyex,hostbased,publickey -o PasswordAuthentication=no -o ConnectTimeout=10 mconnerton@remoteserver /bin/sh -c 'sudo -k && sudo -H -S -p "[sudo via ansible, key=xsywbihenxauympfcegjkznjkmdtoqtg] password: " -u root /bin/sh -c '"'"'echo SUDO-SUCCESS-xsywbihenxauympfcegjkznjkmdtoqtg; LANG=en_US.UTF-8 LC_CTYPE=en_US.UTF-8 /usr/bin/python /home/mconnerton/.ansible/tmp/ansible-tmp-1422031639.33-119061556829911/apt; rm -rf /home/mconnerton/.ansible/tmp/ansible-tmp-1422031639.33-119061556829911/ >/dev/null 2>&1'"'"''
ok: [mconnerton@remoteserver] => {"changed": false}

TASK: [geerlingguy.mysql | Ensure MySQL packages are installed.] **************
mconnerton@remoteserver ESTABLISH CONNECTION FOR USER: matthew
mconnerton@remoteserver REMOTE_MODULE apt name=mysql-common,mysql-server,python-mysqldb state=installed
mconnerton@remoteserver EXEC ssh -C -tt -vvv -o ControlMaster=auto -o ControlPersist=60s -o ControlPath="/home/matthew/.ansible/cp/ansible-ssh-%h-%p-%r" -o KbdInteractiveAuthentication=no -o PreferredAuthentications=gssapi-with-mic,gssapi-keyex,hostbased,publickey -o PasswordAuthentication=no -o ConnectTimeout=10 mconnerton@remoteserver /bin/sh -c 'mkdir -p $HOME/.ansible/tmp/ansible-tmp-1422031649.48-273806540856715 && chmod a+rx $HOME/.ansible/tmp/ansible-tmp-1422031649.48-273806540856715 && echo $HOME/.ansible/tmp/ansible-tmp-1422031649.48-273806540856715'
mconnerton@remoteserver PUT /tmp/tmp7KiPDF TO /home/mconnerton/.ansible/tmp/ansible-tmp-1422031649.48-273806540856715/apt
mconnerton@remoteserver EXEC ssh -C -tt -vvv -o ControlMaster=auto -o ControlPersist=60s -o ControlPath="/home/matthew/.ansible/cp/ansible-ssh-%h-%p-%r" -o KbdInteractiveAuthentication=no -o PreferredAuthentications=gssapi-with-mic,gssapi-keyex,hostbased,publickey -o PasswordAuthentication=no -o ConnectTimeout=10 mconnerton@remoteserver /bin/sh -c 'sudo -k && sudo -H -S -p "[sudo via ansible, key=gpuiqhyxyvxzyashngzrlxwqbsmqhtyg] password: " -u root /bin/sh -c '"'"'echo SUDO-SUCCESS-gpuiqhyxyvxzyashngzrlxwqbsmqhtyg; LANG=en_US.UTF-8 LC_CTYPE=en_US.UTF-8 /usr/bin/python /home/mconnerton/.ansible/tmp/ansible-tmp-1422031649.48-273806540856715/apt; rm -rf /home/mconnerton/.ansible/tmp/ansible-tmp-1422031649.48-273806540856715/ >/dev/null 2>&1'"'"''
changed: [mconnerton@remoteserver] => (item=mysql-common,mysql-server,python-mysqldb) => {"changed": true, "item": "mysql-common,mysql-server,python-mysqldb", "stderr": "", "stdout": "Reading package lists...\nBuilding dependency tree...\nReading state information...\nThe following extra packages will be installed:\n libdbd-mysql-perl libdbi-perl libmysqlclient18 libnet-daemon-perl\n libplrpc-perl libterm-readkey-perl mysql-client-5.5 mysql-client-core-5.5\n mysql-server-5.5 mysql-server-core-5.5\nSuggested packages:\n tinyca python-egenix-mxdatetime python-mysqldb-dbg\nThe following NEW packages will be installed:\n libdbd-mysql-perl libdbi-perl libmysqlclient18 libnet-daemon-perl\n libplrpc-perl libterm-readkey-perl mysql-client-5.5 mysql-client-core-5.5\n mysql-common mysql-server mysql-server-5.5 mysql-server-core-5.5\n python-mysqldb\nPreconfiguring packages ...\n0 upgraded, 13 newly installed, 0 to remove and 114 not upgraded.\nNeed to get 0 B/27.3 MB of archives.\nAfter this operation, 97.6 MB of additional disk space will be used.\nSelecting previously unselected package mysql-common.\r\n(Reading database ... \r(Reading database ... 5%\r(Reading database ... 10%\r(Reading database ... 15%\r(Reading database ... 20%\r(Reading database ... 25%\r(Reading database ... 30%\r(Reading database ... 35%\r(Reading database ... 40%\r(Reading database ... 45%\r(Reading database ... 50%\r(Reading database ... 55%\r(Reading database ... 60%\r(Reading database ... 65%\r(Reading database ... 70%\r(Reading database ... 75%\r(Reading database ... 80%\r(Reading database ... 85%\r(Reading database ... 90%\r(Reading database ... 95%\r(Reading database ... 100%\r(Reading database ... 73676 files and directories currently installed.)\r\nUnpacking mysql-common (from .../mysql-common_5.5.41-0ubuntu0.12.04.1_all.deb) ...\r\nSelecting previously unselected package libmysqlclient18.\r\nUnpacking libmysqlclient18 (from .../libmysqlclient18_5.5.41-0ubuntu0.12.04.1_amd64.deb) ...\r\nSelecting previously unselected package libnet-daemon-perl.\r\nUnpacking libnet-daemon-perl (from .../libnet-daemon-perl_0.48-1_all.deb) ...\r\nSelecting previously unselected package libplrpc-perl.\r\nUnpacking libplrpc-perl (from .../libplrpc-perl_0.2020-2_all.deb) ...\r\nSelecting previously unselected package libdbi-perl.\r\nUnpacking libdbi-perl (from .../libdbi-perl_1.616-1build2_amd64.deb) ...\r\nSelecting previously unselected package libdbd-mysql-perl.\r\nUnpacking libdbd-mysql-perl (from .../libdbd-mysql-perl_4.020-1build2_amd64.deb) ...\r\nSelecting previously unselected package mysql-client-core-5.5.\r\nUnpacking mysql-client-core-5.5 (from .../mysql-client-core-5.5_5.5.41-0ubuntu0.12.04.1_amd64.deb) ...\r\nSelecting previously unselected package libterm-readkey-perl.\r\nUnpacking libterm-readkey-perl (from .../libterm-readkey-perl_2.30-4build3_amd64.deb) ...\r\nSelecting previously unselected package mysql-client-5.5.\r\nUnpacking mysql-client-5.5 (from .../mysql-client-5.5_5.5.41-0ubuntu0.12.04.1_amd64.deb) ...\r\nSelecting previously unselected package mysql-server-core-5.5.\r\nUnpacking mysql-server-core-5.5 (from .../mysql-server-core-5.5_5.5.41-0ubuntu0.12.04.1_amd64.deb) ...\r\nProcessing triggers for man-db ...\r\nSetting up mysql-common (5.5.41-0ubuntu0.12.04.1) ...\r\nSelecting previously unselected package mysql-server-5.5.\r\n(Reading database ... \r(Reading database ... 5%\r(Reading database ... 10%\r(Reading database ... 15%\r(Reading database ... 20%\r(Reading database ... 25%\r(Reading database ... 30%\r(Reading database ... 35%\r(Reading database ... 40%\r(Reading database ... 45%\r(Reading database ... 50%\r(Reading database ... 55%\r(Reading database ... 60%\r(Reading database ... 65%\r(Reading database ... 70%\r(Reading database ... 75%\r(Reading database ... 80%\r(Reading database ... 85%\r(Reading database ... 90%\r(Reading database ... 95%\r(Reading database ... 100%\r(Reading database ... 74054 files and directories currently installed.)\r\nUnpacking mysql-server-5.5 (from .../mysql-server-5.5_5.5.41-0ubuntu0.12.04.1_amd64.deb) ...\r\nSelecting previously unselected package mysql-server.\r\nUnpacking mysql-server (from .../mysql-server_5.5.41-0ubuntu0.12.04.1_all.deb) ...\r\nSelecting previously unselected package python-mysqldb.\r\nUnpacking python-mysqldb (from .../python-mysqldb_1.2.3-1ubuntu0.1_amd64.deb) ...\r\nProcessing triggers for man-db ...\r\nProcessing triggers for ureadahead ...\r\nSetting up libmysqlclient18 (5.5.41-0ubuntu0.12.04.1) ...\r\nSetting up libnet-daemon-perl (0.48-1) ...\r\nSetting up libplrpc-perl (0.2020-2) ...\r\nSetting up libdbi-perl (1.616-1build2) ...\r\nSetting up libdbd-mysql-perl (4.020-1build2) ...\r\nSetting up mysql-client-core-5.5 (5.5.41-0ubuntu0.12.04.1) ...\r\nSetting up libterm-readkey-perl (2.30-4build3) ...\r\nSetting up mysql-client-5.5 (5.5.41-0ubuntu0.12.04.1) ...\r\nSetting up mysql-server-core-5.5 (5.5.41-0ubuntu0.12.04.1) ...\r\nSetting up mysql-server-5.5 (5.5.41-0ubuntu0.12.04.1) ...\r\nmysql start/running, process 25906\r\nSetting up mysql-server (5.5.41-0ubuntu0.12.04.1) ...\r\nSetting up python-mysqldb (1.2.3-1ubuntu0.1) ...\r\nProcessing triggers for libc-bin ...\r\nldconfig deferred processing now taking place\r\nadding apparmor.d/local/usr.sbin.mysqld\nadding apparmor.d/usr.sbin.mysqld\nadding init.d/mysql\nadding init/mysql.conf\nadding logcheck/ignore.d.paranoid/mysql-server-5_5\nadding logcheck/ignore.d.server/mysql-server-5_5\nadding logcheck/ignore.d.workstation/mysql-server-5_5\nadding logrotate.d/mysql-server\nadding mysql/conf.d/mysqld_safe_syslog.cnf\nadding mysql/debian-start\nadding mysql/my.cnf\n"}

TASK: [geerlingguy.mysql | Ensure MySQL is stopped after initial install.] ****
mconnerton@remoteserver ESTABLISH CONNECTION FOR USER: matthew
mconnerton@remoteserver REMOTE_MODULE service name=mysql state=stopped
mconnerton@remoteserver EXEC ssh -C -tt -vvv -o ControlMaster=auto -o ControlPersist=60s -o ControlPath="/home/matthew/.ansible/cp/ansible-ssh-%h-%p-%r" -o KbdInteractiveAuthentication=no -o PreferredAuthentications=gssapi-with-mic,gssapi-keyex,hostbased,publickey -o PasswordAuthentication=no -o ConnectTimeout=10 mconnerton@remoteserver /bin/sh -c 'mkdir -p $HOME/.ansible/tmp/ansible-tmp-1422032065.4-165830880301445 && chmod a+rx $HOME/.ansible/tmp/ansible-tmp-1422032065.4-165830880301445 && echo $HOME/.ansible/tmp/ansible-tmp-1422032065.4-165830880301445'
mconnerton@remoteserver PUT /tmp/tmp8VkiZ7 TO /home/mconnerton/.ansible/tmp/ansible-tmp-1422032065.4-165830880301445/service
mconnerton@remoteserver EXEC ssh -C -tt -vvv -o ControlMaster=auto -o ControlPersist=60s -o ControlPath="/home/matthew/.ansible/cp/ansible-ssh-%h-%p-%r" -o KbdInteractiveAuthentication=no -o PreferredAuthentications=gssapi-with-mic,gssapi-keyex,hostbased,publickey -o PasswordAuthentication=no -o ConnectTimeout=10 mconnerton@remoteserver /bin/sh -c 'sudo -k && sudo -H -S -p "[sudo via ansible, key=lgyanpmagiaqvgrvvhimgpmdsrrgkeni] password: " -u root /bin/sh -c '"'"'echo SUDO-SUCCESS-lgyanpmagiaqvgrvvhimgpmdsrrgkeni; LANG=en_US.UTF-8 LC_CTYPE=en_US.UTF-8 /usr/bin/python /home/mconnerton/.ansible/tmp/ansible-tmp-1422032065.4-165830880301445/service; rm -rf /home/mconnerton/.ansible/tmp/ansible-tmp-1422032065.4-165830880301445/ >/dev/null 2>&1'"'"''
changed: [mconnerton@remoteserver] => {"changed": true, "name": "mysql", "state": "stopped"}

TASK: [geerlingguy.mysql | Delete innodb log files created by apt package after initial install.] ***
mconnerton@remoteserver ESTABLISH CONNECTION FOR USER: matthew
mconnerton@remoteserver REMOTE_MODULE command rm -f /var/lib/mysql/ib_logfile[01] #USE_SHELL
mconnerton@remoteserver EXEC ssh -C -tt -vvv -o ControlMaster=auto -o ControlPersist=60s -o ControlPath="/home/matthew/.ansible/cp/ansible-ssh-%h-%p-%r" -o KbdInteractiveAuthentication=no -o PreferredAuthentications=gssapi-with-mic,gssapi-keyex,hostbased,publickey -o PasswordAuthentication=no -o ConnectTimeout=10 mconnerton@remoteserver /bin/sh -c 'mkdir -p $HOME/.ansible/tmp/ansible-tmp-1422032161.89-165617975921510 && chmod a+rx $HOME/.ansible/tmp/ansible-tmp-1422032161.89-165617975921510 && echo $HOME/.ansible/tmp/ansible-tmp-1422032161.89-165617975921510'
mconnerton@remoteserver PUT /tmp/tmpI2VSyU TO /home/mconnerton/.ansible/tmp/ansible-tmp-1422032161.89-165617975921510/command
mconnerton@remoteserver EXEC ssh -C -tt -vvv -o ControlMaster=auto -o ControlPersist=60s -o ControlPath="/home/matthew/.ansible/cp/ansible-ssh-%h-%p-%r" -o KbdInteractiveAuthentication=no -o PreferredAuthentications=gssapi-with-mic,gssapi-keyex,hostbased,publickey -o PasswordAuthentication=no -o ConnectTimeout=10 mconnerton@remoteserver /bin/sh -c 'sudo -k && sudo -H -S -p "[sudo via ansible, key=lsvtbseupqnnuocmswhsxrytzkcelsrx] password: " -u root /bin/sh -c '"'"'echo SUDO-SUCCESS-lsvtbseupqnnuocmswhsxrytzkcelsrx; LANG=en_US.UTF-8 LC_CTYPE=en_US.UTF-8 /usr/bin/python /home/mconnerton/.ansible/tmp/ansible-tmp-1422032161.89-165617975921510/command; rm -rf /home/mconnerton/.ansible/tmp/ansible-tmp-1422032161.89-165617975921510/ >/dev/null 2>&1'"'"''
changed: [mconnerton@remoteserver] => {"changed": true, "cmd": "rm -f /var/lib/mysql/ib_logfile[01]", "delta": "0:00:00.003515", "end": "2015-01-23 10:56:03.383010", "rc": 0, "start": "2015-01-23 10:56:03.379495", "stderr": "", "stdout": "", "warnings": ["Consider using file module with state=absent rather than running rm"]}

TASK: [geerlingguy.mysql | Copy my.cnf global MySQL configuration.] ***********
mconnerton@remoteserver ESTABLISH CONNECTION FOR USER: matthew
mconnerton@remoteserver EXEC ssh -C -tt -vvv -o ControlMaster=auto -o ControlPersist=60s -o ControlPath="/home/matthew/.ansible/cp/ansible-ssh-%h-%p-%r" -o KbdInteractiveAuthentication=no -o PreferredAuthentications=gssapi-with-mic,gssapi-keyex,hostbased,publickey -o PasswordAuthentication=no -o ConnectTimeout=10 mconnerton@remoteserver /bin/sh -c 'mkdir -p $HOME/.ansible/tmp/ansible-tmp-1422032163.09-273247545059956 && chmod a+rx $HOME/.ansible/tmp/ansible-tmp-1422032163.09-273247545059956 && echo $HOME/.ansible/tmp/ansible-tmp-1422032163.09-273247545059956'
mconnerton@remoteserver EXEC ssh -C -tt -vvv -o ControlMaster=auto -o ControlPersist=60s -o ControlPath="/home/matthew/.ansible/cp/ansible-ssh-%h-%p-%r" -o KbdInteractiveAuthentication=no -o PreferredAuthentications=gssapi-with-mic,gssapi-keyex,hostbased,publickey -o PasswordAuthentication=no -o ConnectTimeout=10 mconnerton@remoteserver /bin/sh -c 'sudo -k && sudo -H -S -p "[sudo via ansible, key=wqtlchacwfnyvmxlswemjongwqtadujp] password: " -u root /bin/sh -c '"'"'echo SUDO-SUCCESS-wqtlchacwfnyvmxlswemjongwqtadujp; rc=flag; [ -r "/etc/mysql/my.cnf" ] || rc=2; [ -f "/etc/mysql/my.cnf" ] || rc=1; [ -d "/etc/mysql/my.cnf" ] && rc=3; python -V 2>/dev/null || rc=4; [ x"$rc" != "xflag" ] && echo "${rc} /etc/mysql/my.cnf" && exit 0; (python -c '"'"'"'"'"'"'"'"'import hashlib; print(hashlib.sha1(open("/etc/mysql/my.cnf", "rb").read()).hexdigest())'"'"'"'"'"'"'"'"' 2>/dev/null) || (python -c '"'"'"'"'"'"'"'"'import sha; print(sha.sha(open("/etc/mysql/my.cnf", "rb").read()).hexdigest())'"'"'"'"'"'"'"'"' 2>/dev/null) || (echo "0 /etc/mysql/my.cnf")'"'"''
mconnerton@remoteserver PUT /tmp/tmpCziqqO TO /home/mconnerton/.ansible/tmp/ansible-tmp-1422032163.09-273247545059956/source
mconnerton@remoteserver PUT /tmp/tmpeTcdVK TO /home/mconnerton/.ansible/tmp/ansible-tmp-1422032163.09-273247545059956/copy
mconnerton@remoteserver EXEC ssh -C -tt -vvv -o ControlMaster=auto -o ControlPersist=60s -o ControlPath="/home/matthew/.ansible/cp/ansible-ssh-%h-%p-%r" -o KbdInteractiveAuthentication=no -o PreferredAuthentications=gssapi-with-mic,gssapi-keyex,hostbased,publickey -o PasswordAuthentication=no -o ConnectTimeout=10 mconnerton@remoteserver /bin/sh -c 'sudo -k && sudo -H -S -p "[sudo via ansible, key=eqlkiujboreagkhuszrvwewmpuoayyie] password: " -u root /bin/sh -c '"'"'echo SUDO-SUCCESS-eqlkiujboreagkhuszrvwewmpuoayyie; LANG=en_US.UTF-8 LC_CTYPE=en_US.UTF-8 /usr/bin/python /home/mconnerton/.ansible/tmp/ansible-tmp-1422032163.09-273247545059956/copy; rm -rf /home/mconnerton/.ansible/tmp/ansible-tmp-1422032163.09-273247545059956/ >/dev/null 2>&1'"'"''
changed: [mconnerton@remoteserver] => {"changed": true, "checksum": "c50458435f7c285fd2cb9056f464b3267bf68cc8", "dest": "/etc/mysql/my.cnf", "gid": 0, "group": "root", "md5sum": "5452effc80bfc214b597b1243c796789", "mode": "0644", "owner": "root", "size": 1199, "src": "/home/mconnerton/.ansible/tmp/ansible-tmp-1422032163.09-273247545059956/source", "state": "file", "uid": 0}

TASK: [geerlingguy.mysql | Ensure MySQL is started and enabled on boot.] ******
mconnerton@remoteserver ESTABLISH CONNECTION FOR USER: matthew
mconnerton@remoteserver REMOTE_MODULE service name=mysql state=started enabled=True
mconnerton@remoteserver EXEC ssh -C -tt -vvv -o ControlMaster=auto -o ControlPersist=60s -o ControlPath="/home/matthew/.ansible/cp/ansible-ssh-%h-%p-%r" -o KbdInteractiveAuthentication=no -o PreferredAuthentications=gssapi-with-mic,gssapi-keyex,hostbased,publickey -o PasswordAuthentication=no -o ConnectTimeout=10 mconnerton@remoteserver /bin/sh -c 'mkdir -p $HOME/.ansible/tmp/ansible-tmp-1422032165.04-2701998201948 && chmod a+rx $HOME/.ansible/tmp/ansible-tmp-1422032165.04-2701998201948 && echo $HOME/.ansible/tmp/ansible-tmp-1422032165.04-2701998201948'
mconnerton@remoteserver PUT /tmp/tmp3MQwAe TO /home/mconnerton/.ansible/tmp/ansible-tmp-1422032165.04-2701998201948/service
mconnerton@remoteserver EXEC ssh -C -tt -vvv -o ControlMaster=auto -o ControlPersist=60s -o ControlPath="/home/matthew/.ansible/cp/ansible-ssh-%h-%p-%r" -o KbdInteractiveAuthentication=no -o PreferredAuthentications=gssapi-with-mic,gssapi-keyex,hostbased,publickey -o PasswordAuthentication=no -o ConnectTimeout=10 mconnerton@remoteserver /bin/sh -c 'sudo -k && sudo -H -S -p "[sudo via ansible, key=sckfnrrtyeahmsufltattlqgllielnao] password: " -u root /bin/sh -c '"'"'echo SUDO-SUCCESS-sckfnrrtyeahmsufltattlqgllielnao; LANG=en_US.UTF-8 LC_CTYPE=en_US.UTF-8 /usr/bin/python /home/mconnerton/.ansible/tmp/ansible-tmp-1422032165.04-2701998201948/service; rm -rf /home/mconnerton/.ansible/tmp/ansible-tmp-1422032165.04-2701998201948/ >/dev/null 2>&1'"'"''
changed: [mconnerton@remoteserver] => {"changed": true, "enabled": true, "name": "mysql", "state": "started"}

TASK: [geerlingguy.mysql | Check if .my.cnf file already exists.] *************
mconnerton@remoteserver ESTABLISH CONNECTION FOR USER: matthew
mconnerton@remoteserver REMOTE_MODULE stat path=/root/.my.cnf
mconnerton@remoteserver EXEC ssh -C -tt -vvv -o ControlMaster=auto -o ControlPersist=60s -o ControlPath="/home/matthew/.ansible/cp/ansible-ssh-%h-%p-%r" -o KbdInteractiveAuthentication=no -o PreferredAuthentications=gssapi-with-mic,gssapi-keyex,hostbased,publickey -o PasswordAuthentication=no -o ConnectTimeout=10 mconnerton@remoteserver /bin/sh -c 'mkdir -p $HOME/.ansible/tmp/ansible-tmp-1422032166.2-18875320569536 && chmod a+rx $HOME/.ansible/tmp/ansible-tmp-1422032166.2-18875320569536 && echo $HOME/.ansible/tmp/ansible-tmp-1422032166.2-18875320569536'
mconnerton@remoteserver PUT /tmp/tmphUcfu7 TO /home/mconnerton/.ansible/tmp/ansible-tmp-1422032166.2-18875320569536/stat
mconnerton@remoteserver EXEC ssh -C -tt -vvv -o ControlMaster=auto -o ControlPersist=60s -o ControlPath="/home/matthew/.ansible/cp/ansible-ssh-%h-%p-%r" -o KbdInteractiveAuthentication=no -o PreferredAuthentications=gssapi-with-mic,gssapi-keyex,hostbased,publickey -o PasswordAuthentication=no -o ConnectTimeout=10 mconnerton@remoteserver /bin/sh -c 'sudo -k && sudo -H -S -p "[sudo via ansible, key=qmaizicltjuozsqnqqwasamtstdkdjuo] password: " -u root /bin/sh -c '"'"'echo SUDO-SUCCESS-qmaizicltjuozsqnqqwasamtstdkdjuo; LANG=en_US.UTF-8 LC_CTYPE=en_US.UTF-8 /usr/bin/python /home/mconnerton/.ansible/tmp/ansible-tmp-1422032166.2-18875320569536/stat; rm -rf /home/mconnerton/.ansible/tmp/ansible-tmp-1422032166.2-18875320569536/ >/dev/null 2>&1'"'"''
ok: [mconnerton@remoteserver] => {"changed": false, "stat": {"exists": false}}

TASK: [geerlingguy.mysql | Update MySQL root password for all root accounts.] ***
mconnerton@remoteserver ESTABLISH CONNECTION FOR USER: matthew
mconnerton@remoteserver REMOTE_MODULE mysql_user name=root password=VALUE_HIDDEN host=127.0.0.1
mconnerton@remoteserver EXEC ssh -C -tt -vvv -o ControlMaster=auto -o ControlPersist=60s -o ControlPath="/home/matthew/.ansible/cp/ansible-ssh-%h-%p-%r" -o KbdInteractiveAuthentication=no -o PreferredAuthentications=gssapi-with-mic,gssapi-keyex,hostbased,publickey -o PasswordAuthentication=no -o ConnectTimeout=10 mconnerton@remoteserver /bin/sh -c 'mkdir -p $HOME/.ansible/tmp/ansible-tmp-1422032167.16-218378890971328 && chmod a+rx $HOME/.ansible/tmp/ansible-tmp-1422032167.16-218378890971328 && echo $HOME/.ansible/tmp/ansible-tmp-1422032167.16-218378890971328'
mconnerton@remoteserver PUT /tmp/tmpf2yAQa TO /home/mconnerton/.ansible/tmp/ansible-tmp-1422032167.16-218378890971328/mysql_user
mconnerton@remoteserver EXEC ssh -C -tt -vvv -o ControlMaster=auto -o ControlPersist=60s -o ControlPath="/home/matthew/.ansible/cp/ansible-ssh-%h-%p-%r" -o KbdInteractiveAuthentication=no -o PreferredAuthentications=gssapi-with-mic,gssapi-keyex,hostbased,publickey -o PasswordAuthentication=no -o ConnectTimeout=10 mconnerton@remoteserver /bin/sh -c 'sudo -k && sudo -H -S -p "[sudo via ansible, key=wceofqnhprhadfztmiloyepmgqadbxta] password: " -u root /bin/sh -c '"'"'echo SUDO-SUCCESS-wceofqnhprhadfztmiloyepmgqadbxta; LANG=en_US.UTF-8 LC_CTYPE=en_US.UTF-8 /usr/bin/python /home/mconnerton/.ansible/tmp/ansible-tmp-1422032167.16-218378890971328/mysql_user; rm -rf /home/mconnerton/.ansible/tmp/ansible-tmp-1422032167.16-218378890971328/ >/dev/null 2>&1'"'"''
failed: [mconnerton@remoteserver] => (item=127.0.0.1) => {"failed": true, "item": "127.0.0.1"}
msg: unable to connect to database, check login_user and login_password are correct or ~/.my.cnf has the credentials
mconnerton@remoteserver ESTABLISH CONNECTION FOR USER: matthew
mconnerton@remoteserver REMOTE_MODULE mysql_user name=root password=VALUE_HIDDEN host=::1
mconnerton@remoteserver EXEC ssh -C -tt -vvv -o ControlMaster=auto -o ControlPersist=60s -o ControlPath="/home/matthew/.ansible/cp/ansible-ssh-%h-%p-%r" -o KbdInteractiveAuthentication=no -o PreferredAuthentications=gssapi-with-mic,gssapi-keyex,hostbased,publickey -o PasswordAuthentication=no -o ConnectTimeout=10 mconnerton@remoteserver /bin/sh -c 'mkdir -p $HOME/.ansible/tmp/ansible-tmp-1422032168.13-73117499944748 && chmod a+rx $HOME/.ansible/tmp/ansible-tmp-1422032168.13-73117499944748 && echo $HOME/.ansible/tmp/ansible-tmp-1422032168.13-73117499944748'
mconnerton@remoteserver PUT /tmp/tmpfMgwdZ TO /home/mconnerton/.ansible/tmp/ansible-tmp-1422032168.13-73117499944748/mysql_user
mconnerton@remoteserver EXEC ssh -C -tt -vvv -o ControlMaster=auto -o ControlPersist=60s -o ControlPath="/home/matthew/.ansible/cp/ansible-ssh-%h-%p-%r" -o KbdInteractiveAuthentication=no -o PreferredAuthentications=gssapi-with-mic,gssapi-keyex,hostbased,publickey -o PasswordAuthentication=no -o ConnectTimeout=10 mconnerton@remoteserver /bin/sh -c 'sudo -k && sudo -H -S -p "[sudo via ansible, key=ojxxpwxyvwegcwdmckxkyyufxajtatek] password: " -u root /bin/sh -c '"'"'echo SUDO-SUCCESS-ojxxpwxyvwegcwdmckxkyyufxajtatek; LANG=en_US.UTF-8 LC_CTYPE=en_US.UTF-8 /usr/bin/python /home/mconnerton/.ansible/tmp/ansible-tmp-1422032168.13-73117499944748/mysql_user; rm -rf /home/mconnerton/.ansible/tmp/ansible-tmp-1422032168.13-73117499944748/ >/dev/null 2>&1'"'"''
failed: [mconnerton@remoteserver] => (item=::1) => {"failed": true, "item": "::1"}
msg: unable to connect to database, check login_user and login_password are correct or ~/.my.cnf has the credentials
mconnerton@remoteserver ESTABLISH CONNECTION FOR USER: matthew
mconnerton@remoteserver REMOTE_MODULE mysql_user name=root password=VALUE_HIDDEN host=localhost
mconnerton@remoteserver EXEC ssh -C -tt -vvv -o ControlMaster=auto -o ControlPersist=60s -o ControlPath="/home/matthew/.ansible/cp/ansible-ssh-%h-%p-%r" -o KbdInteractiveAuthentication=no -o PreferredAuthentications=gssapi-with-mic,gssapi-keyex,hostbased,publickey -o PasswordAuthentication=no -o ConnectTimeout=10 mconnerton@remoteserver /bin/sh -c 'mkdir -p $HOME/.ansible/tmp/ansible-tmp-1422032169.14-33170918638174 && chmod a+rx $HOME/.ansible/tmp/ansible-tmp-1422032169.14-33170918638174 && echo $HOME/.ansible/tmp/ansible-tmp-1422032169.14-33170918638174'
mconnerton@remoteserver PUT /tmp/tmpGdIfIE TO /home/mconnerton/.ansible/tmp/ansible-tmp-1422032169.14-33170918638174/mysql_user
mconnerton@remoteserver EXEC ssh -C -tt -vvv -o ControlMaster=auto -o ControlPersist=60s -o ControlPath="/home/matthew/.ansible/cp/ansible-ssh-%h-%p-%r" -o KbdInteractiveAuthentication=no -o PreferredAuthentications=gssapi-with-mic,gssapi-keyex,hostbased,publickey -o PasswordAuthentication=no -o ConnectTimeout=10 mconnerton@remoteserver /bin/sh -c 'sudo -k && sudo -H -S -p "[sudo via ansible, key=zjyreqadtgbreaffgobuprcggvtpnfqo] password: " -u root /bin/sh -c '"'"'echo SUDO-SUCCESS-zjyreqadtgbreaffgobuprcggvtpnfqo; LANG=en_US.UTF-8 LC_CTYPE=en_US.UTF-8 /usr/bin/python /home/mconnerton/.ansible/tmp/ansible-tmp-1422032169.14-33170918638174/mysql_user; rm -rf /home/mconnerton/.ansible/tmp/ansible-tmp-1422032169.14-33170918638174/ >/dev/null 2>&1'"'"''
failed: [mconnerton@remoteserver] => (item=localhost) => {"failed": true, "item": "localhost"}
msg: unable to connect to database, check login_user and login_password are correct or ~/.my.cnf has the credentials

FATAL: all hosts have already failed -- aborting

PLAY RECAP ********************************************************************
to retry, use: --limit @/home/matthew/main.retry

mconnerton@remoteserver : ok=16 changed=5 unreachable=0 failed=1

from ansible-role-mysql.

I think you are right that it was environmental. This time I did a really deep purge and made sure all config and mysql related directories were fully removed and now it runs perfect.

I really appreciate the work you do and the quick response.

from ansible-role-mysql.

Great! Glad I could help today :)

from ansible-role-mysql.