Mongo DB connection via pymongo in Python
I am newbie in MongoDB and tried to implement a code for connecting mongo via Python. I used pymongo package from standard python user manual. And choose mlab for this purpose.
from pymongo import MongoClient
client = MongoClient('mongodb://test:test@account.mlab.com:port',
connectTimeoutMS=300000,maxPoolSize=50)
print(client)
MongoClient(host=['account.mlab.com:port'],
document_class=dict, tz_aware=False, connect=True, maxpoolsize=50, connecttimeoutms=300000)
Clearly, i can see connection is successful. Now, lets check database
db=client.get_database(test) // Specifying a DB
print(db)
Database(MongoClient(host=['account.mlab.com:port'],
document_class=dict, tz_aware=False,
connect=True, connecttimeoutms=300000), u'test')
Confirming connection is successful with selected test DB.
users = db.users // Selecting a collection
print(users)
Collection(Database(MongoClient(host=['ds024778.mlab.com:24778'],
document_class=dict, tz_aware=False,
connect=True, connecttimeoutms=300000), u'test'), u'users')
Now, I am trying to get a document in users where username = 'admin'
r = users.find_one({"username":'admin'})
But, Error
OperationFailure: Authentication failed.
python mongodb pymongo
asked Nov 26 '18 at 8:35
Saqib MujtabaSaqib Mujtaba
336212
|
show 2 more comments
I am newbie in MongoDB and tried to implement a code for connecting mongo via Python. I used pymongo package from standard python user manual. And choose mlab for this purpose.
from pymongo import MongoClient
client = MongoClient('mongodb://test:test@account.mlab.com:port',
connectTimeoutMS=300000,maxPoolSize=50)
print(client)
MongoClient(host=['account.mlab.com:port'],
document_class=dict, tz_aware=False, connect=True, maxpoolsize=50, connecttimeoutms=300000)
Clearly, i can see connection is successful. Now, lets check database
db=client.get_database(test) // Specifying a DB
print(db)
Database(MongoClient(host=['account.mlab.com:port'],
document_class=dict, tz_aware=False,
connect=True, connecttimeoutms=300000), u'test')
Confirming connection is successful with selected test DB.
users = db.users // Selecting a collection
print(users)
Collection(Database(MongoClient(host=['ds024778.mlab.com:24778'],
document_class=dict, tz_aware=False,
connect=True, connecttimeoutms=300000), u'test'), u'users')
Now, I am trying to get a document in users where username = 'admin'
r = users.find_one({"username":'admin'})
But, Error
OperationFailure: Authentication failed.
python mongodb pymongo
asked Nov 26 '18 at 8:35
Saqib MujtabaSaqib Mujtaba
336212
Is your user allowed to perform specified action onuserscollection? Check collection level access control for more info!
– bro-grammer
Nov 26 '18 at 8:40
under user, "roles": [ { "role": "dbOwner", "db": "test" } ]
– Saqib Mujtaba
Nov 26 '18 at 8:46
What server logs say? Do you escape login/password? Can you find the user from mongo shell?mongo "mongodb://test:test@ds024778.mlab.com:24778"doesn't work.
– Alex Blex
Nov 26 '18 at 9:46
sorry, i am connecting to cloud and can't install mongo client on system
– Saqib Mujtaba
Nov 26 '18 at 9:48
install it locally, or in a docker
– Alex Blex
Nov 26 '18 at 9:49
|
show 2 more comments
I am newbie in MongoDB and tried to implement a code for connecting mongo via Python. I used pymongo package from standard python user manual. And choose mlab for this purpose.
from pymongo import MongoClient
client = MongoClient('mongodb://test:test@account.mlab.com:port',
connectTimeoutMS=300000,maxPoolSize=50)
print(client)
MongoClient(host=['account.mlab.com:port'],
document_class=dict, tz_aware=False, connect=True, maxpoolsize=50, connecttimeoutms=300000)
Clearly, i can see connection is successful. Now, lets check database
db=client.get_database(test) // Specifying a DB
print(db)
Database(MongoClient(host=['account.mlab.com:port'],
document_class=dict, tz_aware=False,
connect=True, connecttimeoutms=300000), u'test')
Confirming connection is successful with selected test DB.
users = db.users // Selecting a collection
print(users)
Collection(Database(MongoClient(host=['ds024778.mlab.com:24778'],
document_class=dict, tz_aware=False,
connect=True, connecttimeoutms=300000), u'test'), u'users')
Now, I am trying to get a document in users where username = 'admin'
r = users.find_one({"username":'admin'})
But, Error
OperationFailure: Authentication failed.
python mongodb pymongo
asked Nov 26 '18 at 8:35
Saqib MujtabaSaqib Mujtaba
336212
I am newbie in MongoDB and tried to implement a code for connecting mongo via Python. I used pymongo package from standard python user manual. And choose mlab for this purpose.
from pymongo import MongoClient
client = MongoClient('mongodb://test:test@account.mlab.com:port',
connectTimeoutMS=300000,maxPoolSize=50)
print(client)
MongoClient(host=['account.mlab.com:port'],
document_class=dict, tz_aware=False, connect=True, maxpoolsize=50, connecttimeoutms=300000)
Clearly, i can see connection is successful. Now, lets check database
db=client.get_database(test) // Specifying a DB
print(db)
Database(MongoClient(host=['account.mlab.com:port'],
document_class=dict, tz_aware=False,
connect=True, connecttimeoutms=300000), u'test')
Confirming connection is successful with selected test DB.
users = db.users // Selecting a collection
print(users)
Collection(Database(MongoClient(host=['ds024778.mlab.com:24778'],
document_class=dict, tz_aware=False,
connect=True, connecttimeoutms=300000), u'test'), u'users')
Now, I am trying to get a document in users where username = 'admin'
r = users.find_one({"username":'admin'})
But, Error
OperationFailure: Authentication failed.
python mongodb pymongo
python mongodb pymongo
asked Nov 26 '18 at 8:35
Saqib MujtabaSaqib Mujtaba
336212
asked Nov 26 '18 at 8:35
Saqib MujtabaSaqib Mujtaba
336212
asked Nov 26 '18 at 8:35
Saqib MujtabaSaqib Mujtaba
336212
asked Nov 26 '18 at 8:35
Saqib MujtabaSaqib Mujtaba
336212
asked Nov 26 '18 at 8:35
Saqib MujtabaSaqib Mujtaba
336212
336212
Is your user allowed to perform specified action onuserscollection? Check collection level access control for more info!
– bro-grammer
Nov 26 '18 at 8:40
under user, "roles": [ { "role": "dbOwner", "db": "test" } ]
– Saqib Mujtaba
Nov 26 '18 at 8:46
What server logs say? Do you escape login/password? Can you find the user from mongo shell?mongo "mongodb://test:test@ds024778.mlab.com:24778"doesn't work.
– Alex Blex
Nov 26 '18 at 9:46
sorry, i am connecting to cloud and can't install mongo client on system
– Saqib Mujtaba
Nov 26 '18 at 9:48
install it locally, or in a docker
– Alex Blex
Nov 26 '18 at 9:49
|
show 2 more comments
Is your user allowed to perform specified action onuserscollection? Check collection level access control for more info!
– bro-grammer
Nov 26 '18 at 8:40
under user, "roles": [ { "role": "dbOwner", "db": "test" } ]
– Saqib Mujtaba
Nov 26 '18 at 8:46
What server logs say? Do you escape login/password? Can you find the user from mongo shell?mongo "mongodb://test:test@ds024778.mlab.com:24778"doesn't work.
– Alex Blex
Nov 26 '18 at 9:46
sorry, i am connecting to cloud and can't install mongo client on system
– Saqib Mujtaba
Nov 26 '18 at 9:48
install it locally, or in a docker
– Alex Blex
Nov 26 '18 at 9:49
Is your user allowed to perform specified action on
users collection? Check collection level access control for more info!– bro-grammer
Nov 26 '18 at 8:40
Is your user allowed to perform specified action on
users collection? Check collection level access control for more info!– bro-grammer
Nov 26 '18 at 8:40
under user, "roles": [ { "role": "dbOwner", "db": "test" } ]
– Saqib Mujtaba
Nov 26 '18 at 8:46
under user, "roles": [ { "role": "dbOwner", "db": "test" } ]
– Saqib Mujtaba
Nov 26 '18 at 8:46
What server logs say? Do you escape login/password? Can you find the user from mongo shell?
mongo "mongodb://test:test@ds024778.mlab.com:24778" doesn't work.– Alex Blex
Nov 26 '18 at 9:46
What server logs say? Do you escape login/password? Can you find the user from mongo shell?
mongo "mongodb://test:test@ds024778.mlab.com:24778" doesn't work.– Alex Blex
Nov 26 '18 at 9:46
sorry, i am connecting to cloud and can't install mongo client on system
– Saqib Mujtaba
Nov 26 '18 at 9:48
sorry, i am connecting to cloud and can't install mongo client on system
– Saqib Mujtaba
Nov 26 '18 at 9:48
install it locally, or in a docker
– Alex Blex
Nov 26 '18 at 9:49
install it locally, or in a docker
– Alex Blex
Nov 26 '18 at 9:49
|
show 2 more comments
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53477276%2fmongo-db-connection-via-pymongo-in-python%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53477276%2fmongo-db-connection-via-pymongo-in-python%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Is your user allowed to perform specified action on
userscollection? Check collection level access control for more info!– bro-grammer
Nov 26 '18 at 8:40
under user, "roles": [ { "role": "dbOwner", "db": "test" } ]
– Saqib Mujtaba
Nov 26 '18 at 8:46
What server logs say? Do you escape login/password? Can you find the user from mongo shell?
mongo "mongodb://test:test@ds024778.mlab.com:24778"doesn't work.– Alex Blex
Nov 26 '18 at 9:46
sorry, i am connecting to cloud and can't install mongo client on system
– Saqib Mujtaba
Nov 26 '18 at 9:48
install it locally, or in a docker
– Alex Blex
Nov 26 '18 at 9:49