Hello,
I have an old task that works on an previous system but fail to work in the
new system. I am certain it hasn't changed through git log but I have
updated ansible on control system. I don't see other people raising the
issue so not confident it's a bug. Have anyone observed something similar?
Version:
control machine: Centos 7
managed system: RHEL 7
ansible: ansible-2.7.9-1.el7.noarch
Task currently:
- name: create projectsend database schema
mysql_db: name={{database_name}} encoding=utf8mb4
collation=utf8mb4_bin state=present state=present login_user=root
login_password="{{root_db_password}}"
Task previously:
- name: create projectsend database schema
mysql_db: name={{database_name}} encoding=utf8mb4
collation=utf8mb4_bin state=present state=present
None of the above tasks works on a new system, they work fine though on a
previous system. I can login fine to mysql without having to use the
password, so details on /root/.my.cnf are fine. What could be causing this?
The full traceback is:
WARNING: The below traceback may *not* be related to the actual failure.
File "/tmp/ansible_mysql_db_payload_bZdCNZ/__main__.py", line 316, in main
connect_timeout=connect_timeout)
File
"/tmp/ansible_mysql_db_payload_bZdCNZ/ansible_mysql_db_payload.zip/ansible/module_utils/mysql.py",
line 79, in mysql_connect
db_connection = mysql_driver.connect(**config)
File "/usr/lib/python2.7/site-packages/pymysql/__init__.py", line 94, in
Connect
return Connection(*args, **kwargs)
File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 327,
in __init__
self.connect()
File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 598,
in connect
self._request_authentication()
File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 862,
in _request_authentication
auth_packet = self._process_auth(plugin_name, auth_packet)
File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 933,
in _process_auth
pkt = self._read_packet()
File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 683,
in _read_packet
packet.check_error()
File "/usr/lib/python2.7/site-packages/pymysql/protocol.py", line 220, in
check_error
err.raise_mysql_exception(self._data)
File "/usr/lib/python2.7/site-packages/pymysql/err.py", line 109, in
raise_mysql_exception
raise errorclass(errno, errval)
fatal: [projectsend.eng.example.com]: FAILED! => {
"changed": false,
"invocation": {
"module_args": {
"collation": "utf8mb4_bin",
"config_file": "/root/.my.cnf",
"connect_timeout": 30,
"encoding": "utf8mb4",
"ignore_tables": [],
"login_host": "localhost",
"login_password": "VALUE_SPECIFIED_IN_NO_LOG_PARAMETER",
"login_port": 3306,
"login_unix_socket": null,
"login_user": "root",
"name": "projectsend_db",
"quick": true,
"single_transaction": false,
"ssl_ca": null,
"ssl_cert": null,
"ssl_key": null,
"state": "present",
"target": null
}
},
"msg": "unable to connect to database, check login_user and
login_password are correct or /root/.my.cnf has the credentials. Exception
message: (1045, u\"Access denied for user 'root'@'localhost' (using
password: YES)\")"
}
to retry, use: --limit @/etc/ansible/site.retry
PLAY RECAP
********************************************************************************************************************************************************************************************************
projectsend.eng.example.com : ok=3 changed=0 unreachable=0 failed=1
Regard,
William
--
You received this message because you are subscribed to the Google Groups
"Ansible Project" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to ansible-project+unsubscr...@googlegroups.com.
To post to this group, send email to ansible-project@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/ansible-project/CAE9rU%2B5N2BMbfjoet3VDnn_9JhViZ0msKbso9KwApcxsSfCRpw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
