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 [email protected].
To post to this group, send email to [email protected].
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.
