Using R to connecting to MongoDB password with '@'

Question

This is similar to the question here: MongoDB password with "@" in it

However, I'm using the R package mongolite to connect so I can't apply that solution. Any recommendations on how to modify it so that it still works for the mongolite package

For example if my username is: user1, and my password is: p@ssword, how would I write:

mongodb://user1:p@ssword@myip

Thank you!

Nope -- it uses I think the %40 and says authentication failed :-( — user1357015, Aug 26 '16 at 19:43

score 2 · Answer 1 · edited Sep 13 '16 at 22:19

2

I used this structure and worked for me

newdb <- mongo(collection= "name_collection", 
               db = "name_db", 
               url = "mongodb://user:password@your_ip:port_number/name_db", 
               verbose = TRUE)

edited Sep 13 '16 at 22:19

SymbolixAU

25,502
4
67
139

answered Sep 11 '16 at 18:29

Francesco

21
1

The question asks for a password with the `@` symbol in it. I don't think your solution solves it. – SymbolixAU Sep 13 '16 at 22:20
how do you find your_ip:port_number? – AyeTown Feb 13 '20 at 21:51

rapture · Answer 2 · 2017-08-14T16:18:00.490

1

I just ran into this problem and solved it by escaping the @ in the password by using its corresponding percent-encoding, e.g. use%40 to ecape it. So in your case:

mongodb://user1:p%40ssword@myip

should work.

Edit: I did not see you already had the answer in a comment :) The escape worked in my case so I assume you may have a mistake in either your username or password.

edited Aug 14 '17 at 16:18

answered Aug 14 '17 at 16:09

rapture

403
6
8

score 0 · Answer 3 · answered Dec 14 '18 at 11:37

0

In your p@ssword @ character is creating problem so replace it by %40 as suggested by https://stackoverflow.com/users/4455096/rapture

answered Dec 14 '18 at 11:37

saurabh shah

48
3

Using R to connecting to MongoDB password with '@'

3 Answers3