mongodb如何链接远程数据库

Question

想本地文件链接线上mongodb数据库，但是始终链接不成，还望指点

---

经检查 mongodb配置文件 ip 已是 0.0.0.0

服务器端口也开启了

---

尝试运行

mongoose.connect('mongodb://106.12.140.76:27017/writeOff?authSource=admin', {
  useNewUrlParser: true,
  useUnifiedTopology: true
}).then(() => console.log('数据库连接成功')).catch((err) => console.log('数据库连接失败', err))

报错

    at E:\MyWork\bd-node\2022-user-administration\node_modules\mongoose\lib\index.js:380:10
    at E:\MyWork\bd-node\2022-user-administration\node_modules\mongoose\lib\helpers\promiseOrCallback.js:41:5
    at new Promise (<anonymous>)
    at promiseOrCallback (E:\MyWork\bd-node\2022-user-administration\node_modules\mongoose\lib\helpers\promiseOrCallback.js:40:10)
    at Mongoose._promiseOrCallback (E:\MyWork\bd-node\2022-user-administration\node_modules\mongoose\lib\index.js:1225:10)
    at Mongoose.connect (E:\MyWork\bd-node\2022-user-administration\node_modules\mongoose\lib\index.js:379:20)
    at Object.<anonymous> (E:\MyWork\bd-node\2022-user-administration\change_integral.js:5:10)
    at Module._compile (node:internal/modules/cjs/loader:1105:14)
    at Object.Module._extensions..js (node:internal/modules/cjs/loader:1159:10) {
  reason: TopologyDescription {
    type: 'Unknown',
    servers: Map(1) { '106.12.140.76:27017' => [ServerDescription] },
    stale: false,
    compatible: true,
    heartbeatFrequencyMS: 10000,
    localThresholdMS: 15,
    logicalSessionTimeoutMinutes: undefined
  },
  code: undefined
}

---

尝试运行

mongoose.connect('mongodb://root:password@106.12.140.76:27017/writeOff?authSource=admin', {
  useNewUrlParser: true,
  useUnifiedTopology: true
}).then(() => console.log('数据库连接成功')).catch((err) => console.log('数据库连接失败', err))

报错

数据库连接失败 MongooseServerSelectionError: connect ETIMEDOUT 106.12.140.76:27017
    at NativeConnection.Connection.openUri (E:\MyWork\bd-node\2022-user-administration\node_modules\mongoose\lib\connection.js:824:32)
    at E:\MyWork\bd-node\2022-user-administration\node_modules\mongoose\lib\index.js:380:10
    at E:\MyWork\bd-node\2022-user-administration\node_modules\mongoose\lib\helpers\promiseOrCallback.js:41:5
    at new Promise (<anonymous>)
    at promiseOrCallback (E:\MyWork\bd-node\2022-user-administration\node_modules\mongoose\lib\helpers\promiseOrCallback.js:40:10)    
    at Mongoose._promiseOrCallback (E:\MyWork\bd-node\2022-user-administration\node_modules\mongoose\lib\index.js:1225:10)
    at Mongoose.connect (E:\MyWork\bd-node\2022-user-administration\node_modules\mongoose\lib\index.js:379:20)
    at Object.<anonymous> (E:\MyWork\bd-node\2022-user-administration\change_integral.js:4:10)
    at Module._compile (node:internal/modules/cjs/loader:1105:14)
    at Object.Module._extensions..js (node:internal/modules/cjs/loader:1159:10) {
  reason: TopologyDescription {
    type: 'Unknown',
    servers: Map(1) { '106.12.140.76:27017' => [ServerDescription] },
    stale: false,
    compatible: true,
    heartbeatFrequencyMS: 10000,
    localThresholdMS: 15,
    logicalSessionTimeoutMinutes: undefined
  },
  code: undefined
}

Answer 1

从报错来看，是连接超时了；可以检查一下本地到主机的网络，主机有没有设置白名单。
在本地可以使用mongo的客户端连接一下，如compass或navicat premium。