CODEWITHSUNDEEP
mongodb
user7422128
user7422128

Reputation: 932

JSON import error MONGOdb

I'm trying to import a JSON file to MongoDB but getting the below errors

VK360@VK360:~$ mongoimport --db cstore --collection stores --drop --file /home/kuliza360/Desktop/Office/Cstoredemo/my_data.json
2018-04-04T10:37:41.545+0530    connected to: localhost
2018-04-04T10:37:41.545+0530    dropping: cstore.stores
2018-04-04T10:37:41.545+0530    Failed: not authorized on cstore to execute command { drop: "stores" }
2018-04-04T10:37:41.545+0530    imported 0 documents

I Followed the Link and performed the steps mentioned below in the mongo shell but still have the same error.

use admin
db.createUser(
  {
    user: "admin",
    pwd: "password",
    roles: [ { role: "root", db: "admin" } ]
  }
);
exit;

Error after aove execution

2018-04-04T10:33:58.124+0530 E QUERY    [thread1] Error: couldn't add user: not authorized on admin to execute command { createUser: "admin", pwd: "xxx", roles: [ { role: "root", db: "admin" } ], digestPassword: false, writeConcern: { w: "majority", wtimeout: 60000.0 } } :
_getErrorWithCode@src/mongo/shell/utils.js:25:13
DB.prototype.createUser@src/mongo/shell/db.js:1267:15
@(shell):1:1

Upvotes: 0

Views: 989

Answers (2)

dweb
dweb

Reputation: 11

Add --jsonArray before --file

mongoimport --db cstore --collection stores --drop --jsonArray --file /home/kuliza360/Desktop/Office/Cstoredemo/my_data.json

Hopefully this can help other people as well!

Upvotes: 1

Rilwan
Rilwan

Reputation: 88

Use the query,

mongoimport --db cstore --collection stores --drop --file /home/kuliza360/Desktop/Office/Cstoredemo/my_data.json --username admin --password password

instead of

mongoimport --db cstore --collection stores --drop --file /home/kuliza360/Desktop/Office/Cstoredemo/my_data.json

Upvotes: 0

Related Questions