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

Je n'ai jamais utilisé flask_pymongo, mais vous pouvez utiliser pymongo comme référence

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

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

Answer 2

Il est recommandé d'utiliser pymongo ou flask-mongoalchemy

directement

Answer 3

J'ai trouvé la raison moi-même.
L'erreur signalée ici : Authentication failed. C'est parce que mon utilisateur connecté n'a pas les autorisations d'exploitation pour la base de données correspondante.
Voir la table des utilisateurs du système, 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"
        }
    ]
}

Vous pouvez voir qu'il n'y a ici que admin autorisations de base de données, mais aucune mongo_test autorisations d'opération de base de données. Vous pouvez ajouter les autorisations de bibliothèque correspondantes dans la table des utilisateurs.
est comme ça dans flask_pymongo et flask_mongoengine, mais je ne comprends toujours pas pourquoi pymongo n'a pas besoin de répondre aux autorisations de la base de données. J'espère que quelqu'un qui sait pourra m'éclairer. . .