On 12. april 2017 11:59, anaparthi naresh babu wrote:
Tried running below query and throwing error. Looks issue with
single/double quotes. Do we need to use any escape sequence like /"
Escape is backslash \ not slash /.
ansible EM7DBVIPTEST -m shell -a 'silo_mysql -e "update
master.system_settings_backup set backup_start_time = "2011-01-01 05:00:00"
where id=1"' -c paramiko
Customer0 | FAILED | rc=1 >>
ERROR 1049 (42000): Unknown database '05:00:00 where id=1'
Are you trying to run this command?
silo_mysql -e "update master.system_settings_backup set
backup_start_time = "2011-01-01 05:00:00" where id=1"
If so you'll need to escape the double quotes around the date.
--
Kai Stian Olstad
--
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/54154e14-8680-b27b-7e61-84bfec1ffc77%40olstad.com.
For more options, visit https://groups.google.com/d/optout.
