python - flask_pymongo 连接Mongodb认证失败

Question

在使用flask的flask_pymongo模块时，出现认证错误。
但可以确定用户名和密码没有错。

from flask import Flask
from flask_pymongo import PyMongo
app = Flask(__name__)

app.config['MONGO_URI'] = 'mongodb://root:aaa2016@localhost:27017/mongo_test'
mongo = PyMongo(app, config_prefix='MONGO')


@app.route('/')
def hello_world():
    mongo.db.user.insert({'username': "aaa"})
    return 'Hello World!'


if __name__ == '__main__':
    app.run()

访问127.0.0.1：5000时，报出Authentication failed.

raceback (most recent call last):
  File "C:\Python27\lib\site-packages\flask\app.py", line 1988, in wsgi_app
    response = self.full_dispatch_request()
  File "C:\Python27\lib\site-packages\flask\app.py", line 1641, in full_dispatch_request
    rv = self.handle_user_exception(e)
  File "C:\Python27\lib\site-packages\flask\app.py", line 1544, in handle_user_exception
    reraise(exc_type, exc_value, tb)
  File "C:\Python27\lib\site-packages\flask\app.py", line 1639, in full_dispatch_request
    rv = self.dispatch_request()
  File "C:\Python27\lib\site-packages\flask\app.py", line 1625, in dispatch_request
    return self.view_functions[rule.endpoint](**req.view_args)
  File "F:/PycharmProjects/flask_/flask_.py", line 11, in hello_world
    mongo.db.sitelist.insert({'ss': "ss"})
  File "C:\Python27\lib\site-packages\pymongo\collection.py", line 2203, in insert
    with self._socket_for_writes() as sock_info:
  File "C:\Python27\lib\contextlib.py", line 17, in __enter__
    return self.gen.next()
  File "C:\Python27\lib\site-packages\pymongo\mongo_client.py", line 718, in _get_socket
    with server.get_socket(self.__all_credentials) as sock_info:
  File "C:\Python27\lib\contextlib.py", line 17, in __enter__
    return self.gen.next()
  File "C:\Python27\lib\site-packages\pymongo\server.py", line 152, in get_socket
    with self.pool.get_socket(all_credentials, checkout) as sock_info:
  File "C:\Python27\lib\contextlib.py", line 17, in __enter__
    return self.gen.next()
  File "C:\Python27\lib\site-packages\pymongo\pool.py", line 541, in get_socket
    sock_info.check_auth(all_credentials)
  File "C:\Python27\lib\site-packages\pymongo\pool.py", line 306, in check_auth
    auth.authenticate(credentials, self)
  File "C:\Python27\lib\site-packages\pymongo\auth.py", line 436, in authenticate
    auth_func(credentials, sock_info)
  File "C:\Python27\lib\site-packages\pymongo\auth.py", line 416, in _authenticate_default
    return _authenticate_scram_sha1(credentials, sock_info)
  File "C:\Python27\lib\site-packages\pymongo\auth.py", line 188, in _authenticate_scram_sha1
    res = sock_info.command(source, cmd)
  File "C:\Python27\lib\site-packages\pymongo\pool.py", line 213, in command
    read_concern)
  File "C:\Python27\lib\site-packages\pymongo\network.py", line 99, in command
    helpers._check_command_response(response_doc, None, allowable_errors)
  File "C:\Python27\lib\site-packages\pymongo\helpers.py", line 196, in _check_command_response
    raise OperationFailure(msg % errmsg, code, response)
OperationFailure: Authentication failed.
127.0.0.1 - - [21/Jun/2016 20:23:19] "GET / HTTP/1.1" 500 -

求教。。。

Answer 1

I haven’t used flask_pymongo, but you can use pymongo as a reference

import pymongo
client = pymongo.MongoClient('mongodb://root:aaa2016@localhost:27017/')
user = client.mongo_test['user']

user.insert({'username': "aaa"})

Answer 2

Recommended to use directlypymongo或者flask-mongoalchemy

Answer 3

I found the reason myself.
The error reported here: Authentication failed. It’s because my logged-in user does not have the operating permissions for the corresponding database. Authentication failed.是因为我的登录用户没有相应数据库的操作权限。
查看系统的user表，db.getCollection('system.users').find({})View the user table of the system, db.getCollection('system.users').find({}):

{
    "_id" : "admin.root",
    "user" : "root",
    "db" : "admin",
    "credentials" : {
        "SCRAM-SHA-1" : {
            "iterationCount" : 10000,
            "salt" : "*****************",
            "storedKey" : "*****************",
            "serverKey" : "*****************"
        }
    },
    "roles" : [ 
        {
            "role" : "userAdminAnyDatabase",
            "db" : "admin"
        }
    ]
}

You can see that there are only admin database permissions here, but no mongo_test database operation permissions. You can add the corresponding library permissions in the user table. admin数据库的权限，而没有mongo_test数据库的操作权限。可以在user表中添加相应的库的权限。
在flask_pymongo, flask_mongoengine中都是这样，但为什么pymongoThis is the case in flask_pymongo, flask_mongoengine, but I still don’t understand why pymongo does not need to respond to database permissions. I hope someone knows. Give me some advice. . .