mongoimport for MongoDB Atlas not working (connection string?)

Question

I am trying to import some data from a csv file on my computer to a cluster on Atlas. I cannot get it to work or find an answer here. I have imported the same file to my local DB on my computer, I just can't get it to work with Atlas. I think that the problem is my connection string, but I don't know what I am doing wrong.

Mongoimport command:

mongoimport --uri "mongodb://<username>:<password>@<clustername>-<string(private?)>.mongodb.net/<database>?authSource=admin&ssl=true" --collection <cname> --drop --type csv --file <path/to/file.csv --headerline

Connection string from MongoDB Atlas:

mongo "mongodb+srv://<clustername>-<string(private?)>.mongodb.net/test"  --username <username>

Error:

error connecting to host: could not connect to server: server selection error: server
selection timeout, current topology: { Type: Single, Servers: [{ Addr: <clustername>-
<string(private?)>.mongodb.net:27017, Type: Unknown, State: Connected, Average RTT: 0, Last error: 
connection() : dial tcp: lookup <clustername>-<string(private?)>.mongodb.net on 127.0.0.53:53: no such
host }, ] }

I have tried everything that I can think of and this seems to be the closest that I can get. It seems to me like I have the connection string wrong, but I don't know how to fix it. I am new to working with databases and MongoDB in particular. Any help is much appreciated.

Notes: I am running this in the terminal and not in the mongo shell. The import worked on my local machine with this same file.

at07 · Accepted Answer · 2020-04-05 06:51:43Z

1

Try removing the ssl=true parameter from the uri in mongoimport, since you are passing client and ca certs in the command.

And another suggestion, in the uri use all the hostnames of the cluster. If you have cluster with multiple nodes which is usually the case.

or Alternatively:

Find command line tools in the altas page. it as template command for mongoimport to the cluster.

Hope this helps.

Click in the expand button and then click on the command line tools

edited Apr 5, 2020 at 6:51

answered Apr 5, 2020 at 5:58

at07

665 bronze badges

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

3 Comments

Lee Morgan Over a year ago

How do I find/use all the hostnames? Could you give an example and tell me where I can find that? Sorry, I am still learning about how this works. I appreciate the help.

at07 Over a year ago

When you login into your atlas account, you will see connect, metrics, collections and "..." dropdown button. Click on the dropdown then select command line tools, you will get template for the mongoimport command.

Lee Morgan Over a year ago

OMG. It was right there. I spent hours trying to figure it out. Thank you so very much for your help.

Collectives™ on Stack Overflow

mongoimport for MongoDB Atlas not working (connection string?)

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related