已开启全IP访问仍无法连接MongoDB Atlas集群求助

已在MongoDB Atlas集群的网络访问设置中开启“允许所有IP访问”，但仍持续收到MongooseServerSelectionError错误，无法连接集群。以下是错误栈信息、数据库连接代码及设置说明：

错误栈信息 #

MongooseServerSelectionError: Could not connect to any servers in your MongoDB Atlas cluster. One common reason is that you're trying to access the database from an IP that isn't whitelisted. Make sure your current IP address is on your Atlas cluster's IP whitelist: https://docs.atlas.mongodb.com/security-whitelist/
    at NativeConnection.Connection.openUri (/home/runner/store-cipher-backend-1/node_modules/mongoose/lib/connection.js:824:32)
    at /home/runner/store-cipher-backend-1/node_modules/mongoose/lib/index.js:380:10
    at /home/runner/store-cipher-backend-1/node_modules/mongoose/lib/helpers/promiseOrCallback.js:32:5
    at new Promise (<anonymous>)
    at promiseOrCallback (/home/runner/store-cipher-backend-1/node_modules/mongoose/lib/helpers/promiseOrCallback.js:31:10)
    at Mongoose._promiseOrCallback (/home/runner/store-cipher-backend-1/node_modules/mongoose/lib/index.js:1225:10)
    at Mongoose.connect (/home/runner/store-cipher-backend-1/node_modules/mongoose/lib/index.js:379:20)
    at intialDbConnection (/home/runner/store-cipher-backend-1/db/db.connect.js:5:20)
    at Object.<anonymous> (/home/runner/store-cipher-backend-1/index.js:15:1) {
  reason: TopologyDescription {
    type: 'ReplicaSetNoPrimary',
    servers: Map(3) {
      'cluster0-shard-00-00.fkvic.mongodb.net:27017' => [ServerDescription],
      'cluster0-shard-00-01.fkvic.mongodb.net:27017' => [ServerDescription],
      'cluster0-shard-00-02.fkvic.mongodb.net:27017' => [ServerDescription]
    },
    stale: false,
    compatible: true,
    heartbeatFrequencyMS: 10000,
    localThresholdMS: 15,
    setName: 'atlas-on2j4f-shard-0',
    logicalSessionTimeoutMinutes: undefined
  },
  code: undefined
}

数据库连接代码 #

const mongoose = require('mongoose');
const mySecret = process.env['mongoUrl']
const intialDbConnection = async () => {
  try {
    await mongoose.connect(mySecret, {
      useNewUrlParser: true,
      useUnifiedTopology: true
    })
    console.log("db connected")
    
  }
  catch (error) {
    console.error(error);
  }
}

module.exports = { intialDbConnection }

集群设置说明 #

网络访问已配置为“允许所有IP访问”（全局访问权限已开启）。

• 验证连接字符串正确性
  确认环境变量mongoUrl中的连接字符串是从Atlas控制台复制的完整内容，需包含：

  • 正确的用户名和密码（密码含特殊字符时需做URL编码）
  • 末尾的?retryWrites=true&w=majority参数（Atlas默认生成的字符串包含该参数，缺失会导致副本集连接异常）

• 修复Mongoose版本与配置兼容性
  若使用Mongoose 6.x及以上版本，useNewUrlParser和useUnifiedTopology已默认启用，保留这些配置可能引发兼容性问题。建议升级Mongoose到最新稳定版，并简化连接代码：

  1. 执行升级命令：

     npm install mongoose@latest
     

  2. 修改连接代码：

     const mongoose = require('mongoose');
     const mySecret = process.env['mongoUrl']
     const intialDbConnection = async () => {
       try {
         await mongoose.connect(mySecret);
         console.log("db connected")
       } catch (error) {
         console.error(error);
       }
     }
     
     module.exports = { intialDbConnection }
     

• 检查运行环境网络限制
  即使Atlas开启全局IP访问，代码运行环境（如在线编辑器）可能存在出站网络限制，导致无法访问MongoDB的27017端口。可尝试在本地环境运行代码测试，若本地能正常连接，需联系平台客服排查网络权限。

• 确认Atlas集群状态
  登录Atlas控制台查看集群是否处于正常运行状态，维护或异常状态的集群会导致连接失败。

• 验证环境变量加载情况
  在连接代码前添加打印语句，确认mySecret的值是否完整：

  console.log('MongoDB连接字符串:', mySecret);
  

  若输出为空或不完整，需检查环境变量的配置是否正确。

内容的提问来源于stack exchange，提问作者KUMARASWAMY A