test-mongodb.js

const { MongoClient } = require('mongodb');
require('dotenv').config();

const uri = process.env.MONGODB_URI || 'mongodb://localhost:27017/room-redesign';

async function testConnection() {
  const client = new MongoClient(uri);
  
  console.log(`Testing MongoDB connection to: ${uri.split('@').length > 1 ? uri.split('@')[1] : uri}`);
  
  try {
    // Connect to MongoDB
    await client.connect();
    console.log('✅ Successfully connected to MongoDB!');
    
    // List all databases (this will verify we have proper permissions)
    const dbs = await client.db().admin().listDatabases();
    console.log('\nAvailable databases:');
    dbs.databases.forEach(db => console.log(` - ${db.name}`));
    
    // Check if using Atlas or local
    const isAtlas = uri.includes('mongodb+srv');
    if (isAtlas) {
      console.log('\nYou are using MongoDB Atlas. Ensure your IP address is whitelisted in the Atlas dashboard.');
    } else {
      console.log('\nYou are using a local MongoDB instance.');
    }
    
  } catch (error) {
    console.error('❌ Error connecting to MongoDB:', error);
    
    if (uri.includes('mongodb+srv')) {
      console.log('\nSince you are using MongoDB Atlas, this error might be due to:');
      console.log('1. Your IP address is not whitelisted in Atlas');
      console.log('2. Incorrect username or password');
      console.log('3. Atlas cluster is not running or is being maintained');
      console.log('\nTo fix IP whitelisting:');
      console.log('- Log in to MongoDB Atlas: https://cloud.mongodb.com/');
      console.log('- Select your cluster (Cluster0)');
      console.log('- Click on "Network Access" in the left sidebar');
      console.log('- Click "Add IP Address" button and add your current IP address');
      
      console.log('\nAlternatively, you can use a local MongoDB instance by changing your .env file:');
      console.log('MONGODB_URI=mongodb://localhost:27017/room-redesign');
    } else {
      console.log('\nSince you are using a local MongoDB instance, this error might be due to:');
      console.log('1. MongoDB service is not running');
      console.log('2. MongoDB is running on a different port');
      
      console.log('\nTo start MongoDB:');
      console.log('- macOS: brew services start mongodb-community');
      console.log('- Windows: Ensure the MongoDB service is running');
      console.log('- Linux: sudo systemctl start mongod');
    }
  } finally {
    // Close the connection
    await client.close();
    console.log('\nConnection closed.');
  }
}

testConnection();