mysql password containing @ generates a syntax error

[jase_t]

$ monit reload
/usr/local/etc/monit/includes/mysql:9: syntax error 'dSUgn@x5dnSXivY'

$ grep -C2 'dSUgn@x5dnSXivY' /usr/local/etc/monit/includes/mysql
  group database
  depends mysql_init, mysql_bin
  if failed unixsocket /tmp/mysql.sock protocol mysql username monit password dSUgn@x5dnSXivY for 2 cycles then restart
  if not exist 2 cycles then restart
  if 5 restarts within 15 cycles then unmonitor

Upon changing the password to something that doesn't contain @, monit reloads the config file successfully.

[Tildeslash]

You need to use quotes:

if failed unixsocket /tmp/mysql.sock protocol mysql username monit password "dSUgn@x5dnSXivY" for 2 cycles then restart

[jase_t]

Ah, that does indeed work. Not sure why I didn't try that in the first place. Thanks for the quick response!

Any chance the documentation for mysql protocol could be updated to reflect this please, as I did check and there's no mention of the need for quoting. Only mention I can see for quoting non-alphanumerics is in the web interface Authentication section.

[Tildeslash]

fix Issue #258 : document that password has to be quoted if non-alphanumeric characters are used

→ <<cset 64ba81f71133>>

[jase_t]

Thanks.

[Tildeslash]

Removing version: 5.14 (automated comment)