Mongoose连接报错：openUri()的uri参数必须为字符串求助

Let's work through this connection error step by step. The core issue here is that process.env.MONGO_URL is returning undefined—this means dotenv isn't successfully loading your environment variables. Here's how to fix it:

1. Correct your environment variable file's name and format #

• First, dotenv defaults to loading a file named .env in your project root, but you're using env.txt. Rename your file to .env so dotenv can locate it automatically.
• Second, dotenv only recognizes the KEY=VALUE format for variables. Your PORT line uses a colon (:) instead of an equals sign (=), which breaks the parsing process.

Your revised .env file should look like this:

MONGO_URL=mongodb+srv://blur:blur@nodeapi-pfnvf8.mongodb.net/test?retryWrites=true
PORT=8080

2. Verify dotenv is loading variables correctly #

Add a quick validation step to confirm your variables are being read before connecting to MongoDB. This helps you narrow down if the issue is with dotenv or Mongoose itself:

const mongoose = require('mongoose');
const dotenv = require('dotenv');

// Load the .env file (add a path parameter if your file isn't in the root)
const loadResult = dotenv.config();

// Check for loading errors
if (loadResult.error) {
  throw loadResult.error;
}

// Print loaded variables to confirm MONGO_URL exists
console.log('Loaded environment variables:', loadResult.parsed);

// Connect to MongoDB with proper error handling
mongoose.connect(process.env.MONGO_URL)
  .then(() => console.log("DB connected!"))
  .catch(err => console.error('Failed to connect to DB:', err));

mongoose.connection.on('error', (err) => {
  console.error("DB connection error:", err); // Make sure to log the actual error object
});

If your .env file isn't in your project's root directory, specify its path explicitly:

dotenv.config({ path: './path/to/your/.env' });

3. Optimize your Mongoose connection code (optional but recommended) #

Using async/await makes error handling cleaner and more readable:

const mongoose = require('mongoose');
const dotenv = require('dotenv');
dotenv.config();

const connectToDB = async () => {
  try {
    await mongoose.connect(process.env.MONGO_URL);
    console.log("DB connected successfully!");
  } catch (err) {
    console.error('DB connection failed:', err);
    process.exit(1); // Exit the process if connection fails
  }
};

connectToDB();

mongoose.connection.on('error', (err) => {
  console.error('DB runtime error:', err);
});

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