Hey guys,
All I'm trying to do, is import a schema in case a database does not exist
yet
ansible --version
ansible 1.9.1
remote host is running centos 7 (fully updated) with mysql and mysql-python
packages installed.
I have found only one person with this error, but in his case, the error
was gone on second run, but for me it always fails.
### tasks/main.yml
- name: ensure databases exist
mysql_db:
name: "{{ item.name }}"
login_host: "{{ item.login_host }}"
login_user: "{{ item.login_user }}"
login_password: "{{ item.login_password }}"
state: present
register: current_db
notify: import schema
with_items:
- { name: "{{ first_dbname }}",
login_host: "{{ first_dberver }}",
login_user: "{{ root_user }}",
login_password: "{{ root_pass }}" }
- { name: "{{ UNPUB_DBName }}",
login_host: "{{ second_dbserver }}",
login_user: "{{ root_user }}",
login_password: "{{ root_pass }}" }
- { name: "{{ third_dbname }}",
login_host: "{{ third_server }}",
login_user: "{{ root_user }}",
login_password: "{{ root_pass }}" }
### handlers/main.yml
- name: import schema
mysql_db:
name: "{{ item.item.name }}"
login_host: "{{ item.item.login_host }}"
login_user: "{{ item.item.login_user }}"
login_password: "{{ item.item.login_password }}"
state: import
target: "{{ temp_path }}/install/db/mysql/schema.sql"
with_items: current_db.results
Error received:
>
> NOTIFIED: install | import schema
>
>
failed: [host] => (item={'invocation': {'module_name': u'mysql_db',
> 'module_args': ''}, 'item': {'login_user': u'root', 'login_host': u'host',
> 'na
>
me': u'db_name', 'login_password': u'pass'}, u'changed': True, u'db':
> u'db_name'}) => {"failed": true, "item": {"changed": true, "db": "db_name",
> "invocatio
> n": {"module_args": "", "module_name": "mysql_db"}, "item": {"login_host":
> "host", "login_password": "pass", "login_user": "root", "name":
> "db_name"}}}
>
>
>
>
> msg: Failed to find required executable mysql
>
>
* note: changed some names to not disclose my company things..
--
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/eab19059-2f1f-47a3-a312-2b9d18e2de17%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
