如何修复Multer Gridfs Storage错误：必须提供url或db选项之一

完整错误信息 #

[nodemon] restarting due to changes...
[nodemon] starting `node server.js`
K:\Development\MindFuel\Backend\node_modules\multer-gridfs-storage\lib\gridfs.js:71
            throw new Error('Error creating storage engine. At least one of url or db option must be provided.');
            ^

Error: Error creating storage engine. At least one of url or db option must be provided.
    at new GridFsStorage (K:\Development\MindFuel\Backend\node_modules\multer-gridfs-storage\lib\gridfs.js:71:19)
    at Object.<anonymous> (K:\Development\MindFuel\Backend\Helpers\Libraries\imageUpload.js:9:18)      
    at Module._compile (node:internal/modules/cjs/loader:1376:14)
    at Module._extensions..js (node:internal/modules/cjs/loader:1435:10)
    at Module.load (node:internal/modules/cjs/loader:1207:32)
    at Module._load (node:internal/modules/cjs/loader:1023:12)
    at Module.require (node:internal/modules/cjs/loader:1235:19)
    at require (node:internal/modules/helpers:176:18)
    at Object.<anonymous> (K:\Development\MindFuel\Backend\Routers\story.js:2:21)
    at Module._compile (node:internal/modules/cjs/loader:1376:14)

Node.js v20.11.1
[nodemon] app crashed - waiting for file changes before starting...

问题代码 #

数据库连接文件 #

const Grid = require("gridfs-stream");
const mongoose = require("mongoose");

const connectDatabase = async () => {    
    const conn = await mongoose.createConnection(process.env.MONGO_URI, { useNewUrlParser: true });
    let gfs;
    
    conn.once('open', ()=>{
        // Init stream
        gfs = Grid(conn.db, mongoose.mongo);
        gfs.collection('images');
    })
    console.log("Connected database successfully");
}
module.exports = connectDatabase;

图片上传处理文件 #

const CustomError = require("../error/CustomError")
const crypto = require('crypto');
const multer = require("multer")
const { GridFsStorage } = require("multer-gridfs-storage")
const path = require("path")

// create storage engine
const storage = new GridFsStorage({
    url: process.env.MONGO_URI,
    file: (req, file) => {
      return new Promise((resolve, reject) => {
        crypto.randomBytes(16, (err, buf) => {
          if (err) {
            return reject(err);
          }
          const filename = buf.toString("hex") + path.extname(file.originalname);
          const fileInfo = {
            filename: filename,
            bucketName: "images"
          };
          resolve(fileInfo);
        });
      });
    }
  });

const fileFilter = (req, file, cb) => {
    allowedMimeTypes = ["image/jpeg", "image/jpg", "image/png", "image/gif"]
    if (!allowedMimeTypes.includes(file.mimetype)) {
        return (new CustomError("Please provide a valid image file ", 400), null)
    }
    cb(null, true);
}

const imageUpload = multer({ storage, fileFilter })
module.exports = imageUpload; 

错误原因 #

• 环境变量名称不匹配：你的.env文件中变量名是URI=mongodb+srv://...，但代码中调用的是process.env.MONGO_URI，导致url参数获取到undefined，触发multer-gridfs-storage的必填项校验错误。
• 重复数据库连接：数据库连接文件中已通过mongoose.createConnection建立连接，但multer-gridfs-storage又通过url参数重新创建连接，既浪费资源也可能引发连接冲突。
• 文件过滤器错误处理不当：原代码中return (new CustomError(...), null)的写法无法正确传递错误，会导致校验逻辑失效。

解决方案 #

步骤1：修正环境变量名称 #

将.env文件中的变量名改为MONGO_URI=mongodb+srv://...，确保代码能正确读取数据库连接字符串。

步骤2：复用已有的数据库连接 #

避免重复创建连接，直接将已建立的mongoose连接实例传给GridFsStorage：

修改数据库连接文件，导出连接实例

const Grid = require("gridfs-stream");
const mongoose = require("mongoose");

let conn;
let gfs;

const connectDatabase = async () => {    
    conn = await mongoose.createConnection(process.env.MONGO_URI, { useNewUrlParser: true });
    
    conn.once('open', ()=>{
        // Init stream
        gfs = Grid(conn.db, mongoose.mongo);
        gfs.collection('images');
        console.log("Connected database successfully");
    })
}

module.exports = { connectDatabase, getConn: () => conn, getGfs: () => gfs };

修改图片上传文件，复用连接并修正错误处理

const CustomError = require("../error/CustomError")
const crypto = require('crypto');
const multer = require("multer")
const { GridFsStorage } = require("multer-gridfs-storage")
const path = require("path")
// 替换为你数据库连接文件的实际路径
const { getConn } = require("../path/to/your/database/connection/file"); 

// 使用已建立的连接创建存储引擎
const storage = new GridFsStorage({
    db: () => getConn().db,
    file: (req, file) => {
      return new Promise((resolve, reject) => {
        crypto.randomBytes(16, (err, buf) => {
          if (err) {
            return reject(err);
          }
          const filename = buf.toString("hex") + path.extname(file.originalname);
          const fileInfo = {
            filename: filename,
            bucketName: "images"
          };
          resolve(fileInfo);
        });
      });
    }
  });

const fileFilter = (req, file, cb) => {
    allowedMimeTypes = ["image/jpeg", "image/jpg", "image/png", "image/gif"]
    if (!allowedMimeTypes.includes(file.mimetype)) {
        // 通过回调正确传递错误
        return cb(new CustomError("Please provide a valid image file ", 400), false);
    }
    cb(null, true);
}

const imageUpload = multer({ storage, fileFilter })
module.exports = imageUpload; 

步骤3：确保启动顺序正确 #

在服务器入口文件中，先调用connectDatabase()建立数据库连接，再加载路由和上传中间件，避免连接未就绪时使用存储引擎。

验证 #

1. 确认.env文件中MONGO_URI配置正确。
2. 重启服务，测试图片上传功能。

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