Skip to content

Instantly share code, notes, and snippets.

@manjeshpv

manjeshpv/passport.js

Last active July 5, 2025 14:15
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save manjeshpv/84446e6aa5b3689e8b84 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save manjeshpv/84446e6aa5b3689e8b84 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. manjeshpv revised this gist Sep 1, 2021. No changes.
  2. manjeshpv revised this gist Sep 23, 2020. No changes.
  3. Manjesh V revised this gist May 6, 2020. No changes.
  4. manjeshpv renamed this gist May 22, 2014. 1 changed file with 0 additions and 0 deletions.
    0 gistfile1.txt → passport.js
    View file
    File renamed without changes.
  5. manjeshpv created this gist May 22, 2014.
    115 changes: 115 additions & 0 deletions gistfile1.txt
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,115 @@
    // config/passport.js

    // load all the things we need
    var LocalStrategy = require('passport-local').Strategy;

    var mysql = require('mysql');

    var connection = mysql.createConnection({
    host : 'localhost',
    user : 'root',
    password : ''
    });

    connection.query('USE vidyawxx_build2');

    // expose this function to our app using module.exports
    module.exports = function(passport) {

    // =========================================================================
    // passport session setup ==================================================
    // =========================================================================
    // required for persistent login sessions
    // passport needs ability to serialize and unserialize users out of session

    // used to serialize the user for the session
    passport.serializeUser(function(user, done) {
    done(null, user.id);
    });

    // used to deserialize the user
    passport.deserializeUser(function(id, done) {
    connection.query("select * from users where id = "+id,function(err,rows){
    done(err, rows[0]);
    });
    });


    // =========================================================================
    // LOCAL SIGNUP ============================================================
    // =========================================================================
    // we are using named strategies since we have one for login and one for signup
    // by default, if there was no name, it would just be called 'local'

    passport.use('local-signup', new LocalStrategy({
    // by default, local strategy uses username and password, we will override with email
    usernameField : 'email',
    passwordField : 'password',
    passReqToCallback : true // allows us to pass back the entire request to the callback
    },
    function(req, email, password, done) {

    // find a user whose email is the same as the forms email
    // we are checking to see if the user trying to login already exists
    connection.query("select * from users where email = '"+email+"'",function(err,rows){
    console.log(rows);
    console.log("above row object");
    if (err)
    return done(err);
    if (rows.length) {
    return done(null, false, req.flash('signupMessage', 'That email is already taken.'));
    } else {

    // if there is no user with that email
    // create the user
    var newUserMysql = new Object();

    newUserMysql.email = email;
    newUserMysql.password = password; // use the generateHash function in our user model

    var insertQuery = "INSERT INTO users ( email, password ) values ('" + email +"','"+ password +"')";
    console.log(insertQuery);
    connection.query(insertQuery,function(err,rows){
    newUserMysql.id = rows.insertId;

    return done(null, newUserMysql);
    });
    }
    });
    }));

    // =========================================================================
    // LOCAL LOGIN =============================================================
    // =========================================================================
    // we are using named strategies since we have one for login and one for signup
    // by default, if there was no name, it would just be called 'local'

    passport.use('local-login', new LocalStrategy({
    // by default, local strategy uses username and password, we will override with email
    usernameField : 'email',
    passwordField : 'password',
    passReqToCallback : true // allows us to pass back the entire request to the callback
    },
    function(req, email, password, done) { // callback with email and password from our form

    connection.query("SELECT * FROM `users` WHERE `email` = '" + email + "'",function(err,rows){
    if (err)
    return done(err);
    if (!rows.length) {
    return done(null, false, req.flash('loginMessage', 'No user found.')); // req.flash is the way to set flashdata using connect-flash
    }

    // if the user is found but the password is wrong
    if (!( rows[0].password == password))
    return done(null, false, req.flash('loginMessage', 'Oops! Wrong password.')); // create the loginMessage and save it to session as flashdata

    // all is well, return successful user
    return done(null, rows[0]);

    });



    }));

    };