app.js


var expressValidator = require('express-validator');
var flash = require('connect-flash');
var session = require('express-session');
var passport = require('passport');
var LocalStrategy = require('passport-local');
var mysql = require('mysql');
var connection = mysql.createConnection({
    host: 'mysql.stud.iie.ntnu.no',
    user: 'markuma',
    password: 'lflVg4Nc',
    database: 'markuma'
})
connection.connect(function (err){
    if(err) throw err
    console.log('connected');

});

//New pages goes here
var users = require('./router/users');

// uncomment after placing your favicon in /public
app.use('/users', users);

// ******** LOG IN ********

//LOGINGREIER EXPRESS SESSIONS
app.use(session({
    secret: 'secret',
    saveUninitialized: true,
    resave: true
}));

//Passport init
app.use(passport.initialize());
app.use(passport.session());

//Express Validator
app.use(expressValidator({
    errorFormatter: function(param, msg, value){
        var namespace = param.split('.')
            , root = namespace.shift()
            , formParam = root;

        while (namespace.length){
            formParam += '[' + namespace.shift() + ']';
        }
        return{
            param: formParam,
            msg : msg,
            value : value
        };
    }
}));

//Connect flash
app.use(flash());

//Global vars
app.use(function(req, res, next){
    res.locals.success_msg = req.flash('success_msg');
    res.locals.error_msg = req.flash ('error_msg');
    res.locals.error = req.flash('error');
    next();
});
// ******** END LOG IN ********