how to read data from remote mongo database server by using shell script via ssh connection

Question

I would like to read data from remote mongo database server. I tried by below ways.

ssh username@hostname "mongo databaseName --eval 'db.collection.find({\"params1\":\"2\",\"params2\":\"2\"})'"

or

ssh username@hostname "mongo databaseName --eval 'printjson(db.collection.find({\"params1\":\"2\", \"params2\":\"2\"}))'"

I used both ways, but I can't get the correct result output from database server. How should I do ?

eoinbrazil · Accepted Answer · 2014-01-10 14:52:46Z

6

The following format should work, note that I specifically included the full path of the mongo executable on the remote database server. If this command does not work, you should ensure that SSH is running on the server and check to see if there is any authentication settings on your database.

ssh username@hostname "/usr/local/mongodb/bin/mongo --norc --eval 'db.collection.find().forEach(printjson)'"

edited Jan 10, 2014 at 14:52

answered Jan 9, 2014 at 17:26

eoinbrazil

4253 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Kyaw Min Thu L Over a year ago

Connection is OK but I don't get the result output. MongoDB shell version: 2.2.0 connecting to: test DBQuery: test.groups -> undefined

eoinbrazil Over a year ago

If you want to capture the output using a script (I'll use bash to illustrate) you will need to use a variable and you will also need to redirect the standard error (stderr) to the standard output (stdout) to get the result you want: result=$(ssh username@hostname "/usr/local/mongodb/bin/mongo --norc --eval 'db.collection.find().forEach(printjson)'" 2>&1)

Collectives™ on Stack Overflow

how to read data from remote mongo database server by using shell script via ssh connection

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related