77

When I create backup of all databases in MongoDB (version 3):

mongodump --username bacUser --password 12345

It's OK. But when I try to create backup of a selected db:

mongodump --username bacUser --password 12345 --db test

It gives me this error:

Failed: error connecting to db server: server returned error on SASL authentication step: Authentication failed.

shA.t
  • 16,580
  • 5
  • 54
  • 111
Vladislav Orillo
  • 2,147
  • 2
  • 11
  • 7

14 Answers14

136

work with this:

--authenticationDatabase admin

mongodump and mongorestore commands need the name of database where mongodb user's credentials are stored. (thanks @Zubair Alam)

Lyubomir
  • 19,615
  • 6
  • 55
  • 69
Vladislav Orillo
  • 2,147
  • 2
  • 11
  • 7
  • 9
    Can you add some explanation as to why this is a solution? – Nate Barbettini Aug 14 '15 at 16:03
  • 6
    mongodump and mongorestore commands need the name of database where mongodb user's credentials are stored. – Zubair Alam Apr 28 '16 at 08:51
  • usually the credentials are stored in the same database I want to backup/restore, am I wrong? – alfredopacino Nov 21 '16 at 00:26
  • @Nate if you don't specify authenticationDatabase, mongodump will use the database you want to back up as authentication database. If the user you are authenticating as belongs to other database than the one you want to back up, you will get authentication error – Maciej Krawczyk Nov 21 '17 at 11:59
  • 2
    This answer works for me, full command is like this: `mongodump -u admin -p pwdxxx --authenticationDatabase admin -d mydb -o mydb_backup` – zqcolor Jul 12 '19 at 00:14
34

This should work.

mongodump -h SERVER_NAME:PORT -d DATABASE_NAME -u DATABASE_USER -p PASSWORD

Also this error can popup if username or password are wrong.

Milos Matic
  • 1,899
  • 1
  • 15
  • 10
  • this worked for me thanks, as many suggested executing mongodump with authenticationDatabase param does not work for me – Naga Dec 21 '20 at 18:19
  • This simplified command worked perfectly. I tried the other options of using --authenticationMechanism and --authenticationDatabase setting the correct values but continued to get issues with authentication failed. – Ben Helleman Mar 28 '22 at 01:30
19
mongodump --host <host-ip> --port 27017 --db <database>  --authenticationDatabase admin --username <username> --password <password> --out ./Documents/

After all the trail, I found above working command to dump from mongdb.

Ganesh
  • 677
  • 8
  • 11
7
mongodump --collection coll_name --db DBname  -u UName -p *** 
          --authenticationDatabase <admin/privileged> --host ip  
          --port portNo  --out foldName
shA.t
  • 16,580
  • 5
  • 54
  • 111
Gyanendro Loitongbam
  • 71
  • 1
  • 1
7
mongodump   --authenticationDatabase admin -uroot -pyourpassword

here root is username and yourpassword is your password.

This command will backup/dump all database back-up in current directory.

Joshi
  • 2,730
  • 5
  • 36
  • 62
5

for dump and restore

mongodump --db nameDatabase --username userName --password password --authenticationDatabase admin --out mongodb\
mongorestore --db nameDatabase --username userName --password password --authenticationDatabase admin <path backup> --drop
pfnuesel
  • 14,093
  • 14
  • 58
  • 71
user3784566
  • 51
  • 1
  • 2
5

If you still get same error with --authenticationDatabase admin , than probably your username and password are incorrect. Try adding a user db.createUser() , with appropriate role ( i gave write permission as well)

than run below command : (ignore -h if you are running on local)

 mongodump -h <ip>:<port_number> -d db_name -u newUser -p newPassword -o /home/mongodump/

Hope this helps...

Shirish Singh
  • 797
  • 7
  • 17
  • mlabs has an online utility to create new users as well. the new user worked for me. – jsky Oct 20 '16 at 09:23
4

The following steps worked for me on MongoDB 3.2:

  1. Check of course if your admin username and pw are correct. You can do this with the mongo shell:

mongo

use admin db.auth("admin", "yourpassword")

If this returns 1, the password is correct.

  1. Then add the role "backup" to your admin (or make sure this role is already added). db.grantRolesToUser("admin", [{ role: "backup", db: "admin" }])

  2. Finally, the mongodump command. It did not work for me when I tried to pass the password as an argument. Instead do this:

mongodump --username admin --authenticationDatabase admin --db yourmongodatabase

Then add your password when it promts for it.

This works for me...

user2996950
  • 439
  • 3
  • 8
  • It's critical that user has an appropriate role: backup or root – Ivan Gusev Jan 31 '18 at 07:54
  • 1
    This happened to me too, only when I remove the password and then type it on next line, it worked. The problem was because I had special characters then I had to use single quote instead of double quote... thanks @adeel for his answer. – user2503775 Apr 11 '19 at 11:17
3

In my case, mongodump was not correctly processing the password. The solution was to escape the password literal.

This did not work:

mongodump -p my$password -o <output directory>

This did work:

mongodump -p 'my$password' -o <output directory>

user2722165
  • 31
  • 1
  • 1
2

Use signle Quotation around password. if you are using any special character in your password. That will solve your issue. Use following command.

mongodump -d database_name -u userName -p 'password' --out directory_name

adeel
  • 321
  • 2
  • 8
2

If you use the --uri option, you need to add authSource=admin as a parameter to your connection string (assuming your user is on the admin database)

mongodump --uri="mongodb://user:pass@host1:27017,host2:27017,host3:27017/?replicaSet=rs0"

Becomes:

mongodump --db=test --uri="mongodb://user:pass@host1:27017,host2:27017,host3:27017/?replicaSet=rs0&authSource=admin"
Karthikeyan
  • 2,634
  • 5
  • 30
  • 51
Gert van den Berg
  • 2,448
  • 31
  • 41
2

userAdminAnyDatabase is not enough to do mongodump on all the dbs that's why you are getting this error. You will need a super user that has:

userAdminAnyDatabase
readWriteAnyDatabase
clusterAdmin

privileges to run mongodump on all dbs.

OR you just need 'backup' privilege

db.grantRolesToUser('username', [{
  role: 'backup',
  db: 'name of ur authentication db'
}])
Aero Wang
  • 8,382
  • 14
  • 63
  • 99
0

I was having this same problem when trying to dump my database info from mLab. It was happening because I had mongo 2.x locally and 3.x in mLab. Upgrading my local mongo to the same major version as mLab allowed me to do the dump, thus solving the problem.

Marcelo Lazaroni
  • 9,819
  • 3
  • 35
  • 41
-1

If you are using mLab then it could be the version in your local mongo is not match with mLab. By default, Ubuntu will install mongo v2.x and mLab is v3.x. You could check with this command:

mongo --version

Install new mongo version:

  1. Remove your old local mongo (be careful, it may remove all your local database)
sudo apt remove mongo-clients mongodb
  1. Import the public key used by the package management system.
sudo apt-key adv --keyserver hkp://keyserver.ubuntu.com:80 --recv D68FA50FEA312927

  1. Create a list file for MongoDB.

    • Ubuntu 14.04
echo "deb http://repo.mongodb.org/apt/ubuntu trusty/mongodb-org/3.2 multiverse" | sudo tee /etc/apt/sources.list.d/mongodb-org-3.2.list
  • Ubuntu 16.04
echo "deb http://repo.mongodb.org/apt/ubuntu xenial/mongodb-org/3.2 multiverse" | sudo tee /etc/apt/sources.list.d/mongodb-org-3.2.list
  1. Install the MongoDB packages
sudo apt-get install -y mongodb-org

Ref: https://docs.mongodb.com/v3.2/tutorial/install-mongodb-on-ubuntu/

Now you can dump your database with this command:

mongodump -h <host>:<port> -d <database-name> -u <user> -p <password> -o <output directory>
windyzboy
  • 1,358
  • 16
  • 20