使用MongoDB API连接到CosmosDB时出现超时错误

Question

我目前正在通过以下教程学习如何通过mongodb API使用Azure的cosmosdb：https://docs.microsoft.com/en-us/azure/cosmos-db/tutorial-develop-mongoDB-react

本教程的最终repo在这里:https://github.com/azure-samples/react-cosmosdb，但到目前为止，我只是在第5部分中尝试连接到cosmos数据库。

我在mongoose版本中遇到了一个问题，并用以下代码替换了repo代码：连接到Azure的错误：mongoose 5.0.1的密码中存在非法字符，但在4.13.9中工作

我还将我所需的mongodb版本降级到2.2.33，因为新版本的mongo似乎不起作用。（请参见下面的注释：https://docs.microsoft.com/en-us/azure/cosmos-db/mongoDb-mongoose）

这两个问题似乎解决了我的一些错误，但我仍然无法解决以下问题：

    { MongoError: failed to connect to server [react-cosmos-db-tori.documents.azure.com:10255] on first connect [MongoError: connection 0 to react-cosmos-db-tori.documents.azure.com:10255 timed out]
[1]     at Pool.<anonymous> (/Users/vhenri/Documents/dev/azure-app-service/azure-heros/server/node_modules/mongoose/node_modules/mongodb-core/lib/topologies/server.js:336:35)
[1]     at emitOne (events.js:116:13)
[1]     at Pool.emit (events.js:211:7)
[1]     at Connection.<anonymous> (/Users/vhenri/Documents/dev/azure-app-service/azure-heros/server/node_modules/mongoose/node_modules/mongodb-core/lib/connection/pool.js:280:12)
[1]     at Object.onceWrapper (events.js:317:30)
[1]     at emitTwo (events.js:126:13)
[1]     at Connection.emit (events.js:214:7)
[1]     at TLSSocket.<anonymous> (/Users/vhenri/Documents/dev/azure-app-service/azure-heros/server/node_modules/mongoose/node_modules/mongodb-core/lib/connection/connection.js:199:10)
[1]     at Object.onceWrapper (events.js:313:30)
[1]     at emitNone (events.js:106:13)
[1]     at TLSSocket.emit (events.js:208:7)
[1]     at TLSSocket.Socket._onTimeout (net.js:407:8)
[1]     at ontimeout (timers.js:475:11)
[1]     at tryOnTimeout (timers.js:310:5)
[1]     at Timer.listOnTimeout (timers.js:270:5)
[1]   name: 'MongoError',
[1]   message: 'failed to connect to server [react-cosmos-db-tori.documents.azure.com:10255] on first connect [MongoError: connection 0 to react-cosmos-db-tori.documents.azure.com:10255 timed out]' }

据我所知，这只是一个超时，因为它不能连接到我的数据库。

const mongoose = require('mongoose');
const env = require('./env/environment');

mongoose.Promise = global.Promise;

function connect() {
return(
    mongoose.connect('mongodb://react-cosmos-db-tori.documents.azure.com:10255/react-cosmos-db-tori?ssl=true', {
        auth: {
        user: 'react-cosmos-db-tori',
        password: '<mypasswordhere>'
        }
    })
    .then(() => console.log('connection successful'))
    .catch((err) => console.log(err))
 )
}
module.exports = {
  connect,
  mongoose
};

{
  "name": "express-react-starter",
  "version": "0.1.0",
  "private": true,
  "dependencies": {
    "body-parser": "^1.17.2",
    "cookie-parser": "^1.4.3",
    "debug": "~2.6.3",
    "express": "^4.15.3",
    "jade": "^1.11.0",
    "mongodb": "^2.2.33",
    "mongoose": "^5.0.7",
    "morgan": "^1.8.2",
    "react": "^15.6.1",
    "react-dom": "^15.6.1"
  },
  "devDependencies": {
    "concurrently": "^3.5.0",
    "nodemon": "^1.12.0",
    "react-scripts": "1.0.10"
  },
  "scripts": {
    "start": "concurrently \"react-scripts start\" \"nodemon server/server.js\"",
    "build": "react-scripts build && mv build server",
    "test": "react-scripts test --env=jsdom",
    "eject": "react-scripts eject"
  },
  "proxy": "http://localhost:3001"
}

DeprecationWarning: `open()` is deprecated in mongoose >= 4.11.0, use `openUri()` instead, or set the `useMongoClient` option if using `connect()` or `createConnection()`. See http://mongoosejs.com/docs/connections.html#use-mongo-client

我想这可能是连接url中的databasename的问题，所以我创建了一个名为heroes_test的集合，并尝试使用mongoDB://react-cosmos-db-tori.documents.azure.com:10255/heroes_test？ssl=true，但发生了同样的事情。

有人知道这是怎么回事吗？我是不是用错了promise？任何帮助都将不胜感激！

Answer 1

对于任何可能遇到类似问题的人来说，我终于想通了！问题出在我工作时的防火墙上--它阻止了我与COSMOSDB的连接。当我从家里的互联网上尝试它时，它工作得很好。