Remote command: Unterminated quoted string

[bashman]

I have a remote command that executes a query on zabbix server host:

{HOSTNAME}: mysql -uzabbix --password="password" --execute 'use zabbix;update hosts_profiles,hosts set hosts_profiles.hardware="{ITEM.LASTVALUE}" where (select hosts_profiles.hostid from hosts where hosts.ip="{IPADDRESS}" and hosts.hostid=hosts_profiles.hostid)'

But it doesn't work, and I can see in zabbix agent log:

sh: Syntax error: Unterminated quoted string

But, this remote command works:

{HOSTNAME}: mysql -uzabbix --password="password" --execute 'use zabbix;update hosts_profiles,hosts set hosts_profiles.os="{ITEM.LASTVALUE}" where (select hosts_profiles.hostid from hosts where hosts.ip="{IPADDRESS}" and hosts.hostid=hosts_profiles.hostid)'

The differences are the {ITEM.LASTVALUE}, the first case is:

Nº process: 1 Model process: Mem: 885 MB HDD(/dev/sda:): 500.1 GB HDD(/dev/sdb:): 500.1 GB ISDN: 00:08.0 Network controller: Cologne Chip Designs GmbH ISDN network controller [HFC-PCI] (rev 02)

and the second case:

Linux Debian 5.0.3 ( i686)

I think the string in the first case is too long, but if I execute the command locally, it works fine.

I need confirmation. Has anybody had this same problem?.

[bashman]

The problem is the {ITEM.LAST} has a "/n" in the last item string.

Getting this "/n", the problem was solved.

[beretests]

How did you get the "/n"? I'm facing a similar issue with zabbix_sender?

[beretests]

Nvm, figured it out. I needing to escape special characters from my output in perl using quotemeta. Thanks!