I have deployed an app on Digital Ocean, I want to be able to have some GUI manage the collections. On my localhost I use Robomongo, but I dont know how to connect Robomongo to Digital Ocean.
Does anyone use a GUI to manage their collections?
A free option. I see people us compose which is $18monthly.
If you can connect to you Digital Ocean Mongo instance remotely, you can use Robomongo as well with the same connection settings.
Are you getting any error messages when trying this?
To connect using robomongo, create a new connection with your ip address and mongo port (27017 by default). Then, in the connection settings window, head to the ‘ssh’ tab. Use your ip, 22 as the port, your ssh user name (root), auth method: private key, and then find your private key and paste the location in. Depending on whether you set up a passphrase, enter it also…
manrashids way is how I do it, It tunnels you through SSH and then connects you via loopback so you don’t have to worry about allowing access from another interface.
You can always give MongoChef a try, if you give up on Robomongo I did that myself a few months back. Can’t help you with your problem though, I’ve only ever connected remotely to Compose, which was straight forward…
Are you exposing your DB on a particular port? - beyond getting the right port and server address, it shouldn’t be any harder than passing authentication you’ve setup for yourself…
Since you have deployed on DO. You must be accessing it using userid/password or ssh keys.
On RoboMongo on setting connection options, use SSH tab with ssh tunnel tunnel. use the userid/password with password option. if you have keys, I have found that private key selection causes problem, instead copy the complete path where the keys are located and paste in the box - for me that has worked.
So it bothered me that you haven’t been able to get this to work. I just tried duplicating the exact same connection I’ve been using for months on robomongo and I haven’t been able to get it to work. As a workaround, try this:
ssh -L 4001:localhost:27017 root@your.drop.let.ip
localhost:27017 is the location of the mongo instance running on your droplet, so if you’ve changed the port or are running the meteor command directly (which puts the mongo at 3001) you will have to change this.
4001 is the port you want to forward to on your local machine. Then, you can use your robomongo to connect to localhost:4001, and the connection will be tunneled over ssh, giving you access to your remote db. I just tried this with the same connection and it worked right away. Let me know if this doesn’t help…
On my guest I removed the SSH to put in a new one. Then realised you cant add a SSH to a droplet after droplet launched. Then my MUP wouldnt deploy. So I messed up the project big style.
So I made a new droplet. Luckily the project isnt publicly launched yet so it doesnt matter about losing all the data.