MongoError: cannot do raw queries on admin in atlas for advanced node and express challenge

MongoError: cannot do raw queries on admin in atlas for advanced node and express challenge

I get a MongoError: cannot do raw queries on admin in atlas for the Advanced Node and Express - Registration of New Users challenge when I try to register or login as a user and no data is displayed in my database. Would anybody know what is going on? I already changed the user access to read and write. It does say that database is connected. Please help.

server.js code:

'use strict';

const express     = require('express');
const bodyParser  = require('body-parser');
const fccTesting  = require('./freeCodeCamp/fcctesting.js');
/****my code****/
const session = require('express-session');
const passport = require('passport');
const ObjectID = require('mongodb').ObjectID;
const mongo = require('mongodb').MongoClient;
const LocalStrategy = require('passport-local');
/****my code****/
const app = express();
fccTesting(app); //For FCC testing purposes
app.use('/public', express.static(process.cwd() + '/public'));
app.use(bodyParser.urlencoded({ extended: true }));

/****my code****/
//set up template engine
app.set('view engine', 'pug');

//encrpyt cookie
  secret: process.env.SESSION_SECRET,
  resave: true,
  saveUninitialized: true,

//use passport init
//and passport session

//connect to db
mongo.connect(process.env.DATABASE, (err, db) => {
    if(err) {
        console.log('Database error: ' + err);
    else {
        console.log('Successful database connection');
        //serialization and app.listen
        //serialize id
        passport.serializeUser((user, done) => {
           done(null, user._id);

        //deserialize without db
        passport.deserializeUser((id, done)=>{
            {_id: new ObjectID(id)},
            (err, doc) => {
        //local strategy
        passport.use(new LocalStrategy(
          function(username, password, done) {
            db.collection('users').findOne({ username: username }, function (err, user) {
              console.log('User '+ username +' attempted to log in.');
              if (err) { return done(err); }
              if (!user) { return done(null, false); }
              if (password !== user.password) { return done(null, false); }
              return done(null, user);
        //ENSURE authenticated middleware for /profile link
        function ensureAuthenticated(req, res, next) {
          if (req.isAuthenticated()) {
              return next();
        //index route
          .get((req, res) => {
            let homePageObjects = {
              title: 'Home Page',
              message: 'Please login',
              showLogin: true,
              showRegistration: true
            res.render(process.cwd() + '/views/pug/index.pug', homePageObjects);
        //authenticate user
        let authenticateUser = passport.authenticate('local', {failureRedirect: "/"});

        //login route
          .post(authenticateUser,(req, res) => {
        //profile route
          .get(ensureAuthenticated, (req, res) => {
            let profilePageObject = {
              username: req.user.username
            res.render(process.cwd() + '/views/pug/profile', profilePageObject);
          .post((req, res, next) => {
              db.collection('users').findOne({ username: req.body.username }, function (err, user) {
                  if(err) {
                  } else if (user) {
                  } else {
                        {username: req.body.username,
                         password: req.body.password},
                        (err, doc) => {
                            if(err) {
                            } else {
                                next(null, user);
            //authenticate new user
            authenticateUser, (req, res, next) => {
          .get((req, res) => {
        //middleware for pages not found
        app.use((req, res, next) => {
            .send('Not Found');
        /****my code****/

        app.listen(process.env.PORT || 3000, () => {
          console.log("Listening on port " + process.env.PORT);

I was able to solve my own problem. Here is what I did.

  1. mongoDB Atlas -> connect: driver node.js, version: 2.2.12 or later-> copy connection string below.
  2. .env file on glitch-> make sure to wrap your string in quotations. Like this: DATABASE=‘mongodb://username:[email protected]:27017,,

Note: In version 3.0 or later it wasn’t important to wrap it in quotation but apparently in 2.2.12 it is. So keep that in mind.

1 Like

hey cowboyLad I came across the same problem, I’m glad to see you came up with a solution but I’m confused I don’t understand the instructions you provided, especially step 1. would appreciate your response thanks.

Don’t worry its sorted now thanks a lot:

DATABASE='mongodb://username:[email protected]:27017,,'

I tested with mongodb it works fine, but there is a problem with mongoose which I can’t resolved it, anyone has idea?

Here is my code

    const connector = mongoose.connect(
    .then(() => {
        const Listing = mongoose.model(
            new mongoose.Schema({
                name: String,
                summary: String,
        Listing.findOne({}).then((r) => {