Remote ssh commad with variables, quotes and single quotes

Question

I need to execute a command on a remote MongoDB server, using variables declared on the shell script.

Command:

ssh [email protected] "mongo mydb --host 10.1.1.1 --port 27017 -u user -p password --authenticationDatabase admin --eval 'db.mycollection.update({}, {$push: {'"$ENTITY"': NumberInt('"$CODE"')}})' --quiet"

Note that if I use the command outside the shell script, substituting the variables, a bash -c syntax error comes up. Example:

ssh [email protected] "mongo mydb --host 10.1.1.1 --port 27017 -u user -p password --authenticationDatabase admin --eval 'db.mycollection.update({}, {$push: {foo: NumberInt(123)}})' --quiet"

bash: -c: line 0: syntax error near unexpected token `('

It's working now! Solution:

DBUPDATE="db.mycollection.update({}, {\$push: {${ENTITY}: NumberInt(${CODE})}})"

ssh [email protected] mongo mydb --host 10.1.1.1 --port 27017 -u user -p password --authenticationDatabase admin --eval "'$DBUPDATE'" --quiet

It returns an error from MongoDB: `SyntaxError: invalid property id @(shell eval)`. — Daniel Pinto, Oct 11 '17 at 16:39
@sebasth those variables are arguments of the script (e.g. test.sh foo 123). Note that the mongo command works as intended, just not working when I use it with ssh due to the quotes. — Daniel Pinto, Oct 11 '17 at 23:13
Put the shell commands in a script on the remote host and call that script through SSH. — Kusalananda, Oct 12 '17 at 11:12
Yes @Kusalananda that would be a solution, but I did not want to create unnecessary dependencies. I already found out the solution. — Daniel Pinto, Oct 12 '17 at 13:05

score 1 · Answer 1 · answered Oct 11 '17 at 16:50

1

ssh [email protected] 'mongo mydb --host 10.1.1.1 --port 27017 -u user -p password --authenticationDatabase admin --eval "db.mycollection.update({}, {$push: {'"$ENTITY"': NumberInt('"$CODE"')}})" --quiet'

I switched the double quotes with single quotes at the beginning and end and put your --eval input in double quotes.

answered Oct 11 '17 at 16:50

Hunter.S.Thompson

8,839
7
26
41

It returns the same error: `SyntaxError: invalid property id @(shell eval)` – Daniel Pinto Oct 11 '17 at 17:00

Remote ssh commad with variables, quotes and single quotes

1 Answers1