ansible command throwing error while running mysql query with where clause

[anaparthi naresh babu]

Tried running below query and throwing error. Looks issue with single/double quotes. Do we need to use any escape sequence like /"

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'

Thanks,

Naresh

[Kai Stian Olstad]

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