使用Mongoose连接MongoDB失败，求助解决uri参数未定义错误

报错信息 #

MongooseError: The uriparameter toopenUri()must be a string, got "undefined". Make sure the first parameter tomongoose.connect()ormongoose.createConnection() is a string.

相关配置代码 #

package.json #

{
  "dependencies": {
    "bcrypt": "^5.1.0",
    "body-parser": "^1.20.1",
    "cors": "^2.8.5",
    "dotenv": "^16.0.3",
    "express": "^4.18.2",
    "gridfs-stream": "^1.1.1",
    "helmet": "^6.0.1",
    "jsonwebtoken": "^9.0.0",
    "mongoose": "^6.7.0",
    "morgan": "^1.10.0",
    "multer": "^1.4.4",
    "multer-gridfs-storage": "^5.0.2"
  },
  "name": "server",
  "version": "1.0.0",
  "main": "index.js",
  "type": "module",
  "devDependencies": {},
  "scripts": {
    "test": "echo \"Error: no test specified\" && exit 1"
  },
  "keywords": [],
  "author": "",
  "license": "ISC",
  "description": ""
}

index.js #

import express from "express";
import bodyParser from "body-parser";
import mongoose from "mongoose";
import cors from "cors";
import dotenv from "dotenv";
import multer from "multer";
import helmet from "helmet";
import morgan from "morgan";
import path from "path";
import { fileURLToPath } from "url";

/* CONFIGURATIONS */
const __filename = fileURLToPath(import.meta.url);
const __dirname = path.dirname(__filename);
dotenv.config();
const app = express();
app.use(express.json());
app.use(helmet());
app.use(helmet.crossOriginResourcePolicy({ policy: "cross-origin" }));
app.use(morgan("common"));
app.use(bodyParser.json({ limit: "30mb", extended: true }));
app.use(bodyParser.urlencoded({ limit: "30mb", extended: true }));
app.use(cors());
app.use("/assets", express.static(path.join(__dirname, "public/assets")));

/* FILE STORAGE */
const storage = multer.diskStorage({
  destination: function (req, file, cb) {
    cb(null, "public/assets");
  },
  filename: function (req, file, cb) {
    cb(null, file.originalname);
  },
});
const upload = multer({ storage });


/* MONGOOSE SETUP */
const PORT = process.env.PORT || 6001;
mongoose
  .connect(process.env.MONGO_URL, {
    useNewUrlParser: true,
    useUnifiedTopology: true,
  })
  .then(() => {
    app.listen(PORT, () => console.log(`Server Port: ${PORT}`));

  })
  .catch((error) => console.log(`${error} did not connect`));

.env #

MONGO_URL = 'the connection string'
PORT = 3001

排查与解决步骤 #

• 修正.env文件格式：.env中变量定义不能有多余空格和引号，正确写法应为MONGO_URL=你的MongoDB连接字符串（等号前后无空格，连接字符串不需要用单引号包裹），否则dotenv会把空格和引号解析到变量值中，导致读取失败。
• 指定dotenv加载路径：在调用dotenv.config()时明确指定.env文件路径，避免因文件位置问题导致加载失败，修改为：

  dotenv.config({ path: path.resolve(__dirname, '.env') });
  

• 验证变量读取结果：在mongoose连接代码前添加日志，确认process.env.MONGO_URL是否正确读取：

  console.log('当前MONGO_URL值:', process.env.MONGO_URL);
  

  如果输出为undefined，说明.env文件未被正确加载，需检查文件位置、权限或格式。
• 重新安装依赖：执行npm install重新安装所有依赖，确保dotenv模块正常安装且无损坏。
• 检查ES模块兼容性：由于项目设置了"type": "module"，dotenv 16.x版本完全兼容，无需额外配置，但需确保所有导入语句正确使用ES模块语法。

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