Can't add server(Atlas Cluster) in Mongo Explorer

Question

How can I add and connect to this Atlas Cluster from Mongo Explorer?:

mongo "mongodb://cluster0-shard-00-00-jxeqq.mongodb.net:27017,cluster0-shard-00-01-jxeqq.mongodb.net:27017,cluster0-shard-00-02-jxeqq.mongodb.net:27017/aggregations?replicaSet=Cluster0-shard-0" --authenticationDatabase admin --ssl -u m121 -p aggregations --norc

PS: I need to add and run this from Mongo Explorer (Plugin for IntelliJ IDEA) not from shell.

github.com/dboissier/mongo4idea

Boozy

hi @Yellowfun, I have added the valid connection string to connect to your mongodb deployments as answer. However, it is not recommended to share your DB credentials in the community. Please change the username and passwords of this deployment – Hijacker

Answer 1

Add a new server as on the image:

• Server url: cluster0-shard-00-00-jxeqq.mongodb.net:27017,cluster0-shard-00-01-jxeqq.mongodb.net:27017,cluster0-shard-00-02-jxeqq.mongodb.net:27017
• SSL: checked
• User Database: aggregations

Then go to Authentication tab and set credentials:

• Username: m121
• Password: aggregations
• Auth. database: admin
• Auth. mechanism: SCRAM-SHA-1

Bitterroot

I've tested out and it is working! Thank you very much! @Alex Blex – Boozy

Hey @Yellowfun, you forgot to reset the password. It is violation of Atlas' T&C. Please do it now, even if you have nothing to hide there. Your cluster is wide open to anyone in the internet - it can be misused, and you are the one to blame: You are responsible for all activities that occur under your account, regardless of whether undertaken by you – Bitterroot

Answer 2

@Yellowfun: Try this with mongo shell:

mongo --host "mongodb://m121:[email protected]:27017,cluster0-shard-00-01-jxeqq.mongodb.net:27017,cluster0-shard-00-02-jxeqq.mongodb.net:27017/aggregations?replicaSet=Cluster0-shard-0&ssl=true&authSource=admin

• Server url: mongodb://cluster0-shard-00-00-jxeqq.mongodb.net:27017,cluster0-shard-00-01-jxeqq.mongodb.net:27017,cluster0-shard-00-02-jxeqq.mongodb.net:27017?replicaSet=Cluster0-shard-0
• Select SSL connection
• In Authentication settings:
  • Username: m121
  • Password: aggregations
  • Auth.database: admin
  • Authe mechanism: Default
• User database: aggregations

Hijacker

Hi @Astro! I need to add and run this from Mongo Explorer (Plugin for IntelliJ IDEA) not from shell. plugins.jetbrains.com/plugin/7141-mongo-plugin – Boozy

Are you able to open a window in intellij from Mongo explorer to 'Add a mongo Server' ? – Hijacker

Updated answer for Mongo Explorer and fields to be added in Add a mongo server. Check if that helps – Hijacker

Thank you! But Connectoin Test Failed - For input string: "//cluster0-shard-00-00-jxeqq.mongodb.net" – Boozy

are you using same mongo shell version as that of your server: 3.6.5 ? – Hijacker

My MongoDB shell is v3.6.4 – Boozy

But it's working from cmd shell (with v3.6.4 ) why it's not working from plugin? – Boozy

not sure if this is issue with connector. You can check if there are any know issue noted or you can create one. – Hijacker

3.6.4 should be good enough. You can get it from here: mongodb.com/download-center?#community and set path – Hijacker

I've also created here an issue github.com/dboissier/mongo4idea/issues/215 but no one is answering. I think it is not support the clusters. @Astro – Boozy

Maybe you know some good shell for mongoDB maybe even with integration with IntelliJ IDEA? @ Astro – Boozy

I would recommend using mongo shell if you want to interact with Altas cluster. :) – Hijacker

Answer 3

I think this can help you (use in in Mongo Shell)

mongo "mongodb://username:[email protected]:27017,cluster-shard-00-01-6666.mongodb.net:27017,cluster-shard-00-02-6666.mongodb.net:27017/databaseName?ssl=true&replicaSet=replicaName&authSource=admin"

Boanerges

github.com/dboissier/mongo4idea Mongo Explorer is a Plugin for IntelliJ IDEA – Boozy