MongoDB db.copyDatabase fail on unauthorized

Question

I'm trying to copy between two different DBs on MongoLab using the mongo CLI. I followed the docs - http://docs.mongodb.org/manual/reference/method/db.copyDatabase/

Connected to the target DB.
Ran the following:

db.copyDatabase('source-db', 'target-db', 'source-host', 'source-user', 'source-pwd')

But I always getting:

{ "ok" : 0, "errmsg" : "unauthorized" }

Are you on a shared plan? I don't think you can copyDatabase() to a shared destination database there. — Joachim Isaksson
– Joachim Isaksson, Commented May 31, 2013 at 11:01
Then no, I have no idea, only have a shared plan to test with :) — Joachim Isaksson
– Joachim Isaksson, Commented May 31, 2013 at 22:00
silly question: did you auth to the database with username that has appropriate permissions to run this command? — Asya Kamsky
– Asya Kamsky, Commented Jun 1, 2013 at 7:50
MongoLab has two options User and Read-Only User. How can IC check the permissions? — Guy Korland
– Guy Korland, Commented Jun 1, 2013 at 8:44

Yuval Adam · Accepted Answer · 2013-07-24 11:18:45Z

2

I am getting the same error, but when trying to copy a collection:

> db.coll1.copyTo("coll2");
Wed Jul 24 13:32:05 uncaught exception: { "ok" : 0, "errmsg" : "unauthorized" }

My database is on a shared server managed by MongoHQ, so there definitely might be some permission problem there that the service does not allow copyTo or other commands to run.

A simple workaround is to manually fetch all the objects in the collection and insert them to the second collection. This is how things were done prior to copyTo being implemented:

db.coll1.find().forEach(function(o) { db.coll2.insert(o); });

answered Jul 24, 2013 at 11:18

Yuval Adam

166k95 gold badges318 silver badges406 bronze badges

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

2 Comments

Guy Korland Over a year ago

yes, this is how I solved it, but I don't think it's the most efficient way.

Yuval Adam Over a year ago

Not efficient, true, but gets the job done. And that's what counts :)

Avinash · Accepted Answer · 2014-10-26 08:48:47Z

1

you can use mongodump and mongorestore commands instead.

mongodump -h <source_host>:<source_port> -d <source_db> -o ~/tmp/mongodump

mongorestore -h <destination_host>:<destination_port> -d <destination_db> -u <username> -p <password> ~/tmp/mongodump/<source_db>

answered Oct 26, 2014 at 8:48

Avinash

7797 silver badges18 bronze badges

Collectives™ on Stack Overflow

MongoDB db.copyDatabase fail on unauthorized

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related