-
Notifications
You must be signed in to change notification settings - Fork 9
/
app.js
125 lines (104 loc) · 3.73 KB
/
app.js
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
var express = require('express');
var path = require('path');
var favicon = require('serve-favicon');
var logger = require('morgan');
var cookieParser = require('cookie-parser');
var bodyParser = require('body-parser');
var index = require('./routes/index');
var users = require('./routes/users');
var app = express();
// view engine setup
app.set('views', path.join(__dirname, 'views'));
app.set('view engine', 'pug');
//login script from here
var flash = require('connect-flash');
var crypto = require('crypto');
/* Login script */
var passport = require('passport');
var LocalStrategy = require('passport-local').Strategy;
var connection = require('./lib/dbconn');
var sess = require('express-session');
var Store = require('express-session').Store
var BetterMemoryStore = require(__dirname + '/memory')
var store = new BetterMemoryStore({ expires: 60 * 60 * 1000, debug: true })
app.use(sess({
name: 'JSESSION',
secret: 'MYSECRETISVERYSECRET',
store: store,
resave: true,
saveUninitialized: true
}));
// uncomment after placing your favicon in /public
app.use(logger('dev'));
app.use(bodyParser.json());
app.use(bodyParser.urlencoded({ extended: false }));
app.use(cookieParser());
app.use(express.static(path.join(__dirname, 'public')));
app.use(flash());
app.use(passport.initialize());
app.use(passport.session());
app.use('/', index);
app.use('/users', users);
//passport Strategy -- the express session middleware before calling passport.session()
passport.use('local', new LocalStrategy({
usernameField: 'username',
passwordField: 'password',
passReqToCallback: true //passback entire req to call back
} , function (req, username, password, done){
console.log(username+' = '+ password);
if(!username || !password ) { return done(null, false, req.flash('message','All fields are required.')); }
var salt = '7fa73b47df808d36c5fe328546ddef8b9011b2c6';
connection.query("select * from tbl_users where username = ?", [username], function(err, rows){
console.log(err);
if (err) return done(req.flash('message',err));
if(!rows.length){ return done(null, false, req.flash('message','Invalid username or password.')); }
salt = salt+''+password;
var encPassword = crypto.createHash('sha1').update(salt).digest('hex');
var dbPassword = rows[0].password;
if(!(dbPassword == encPassword)){
return done(null, false, req.flash('message','Invalid username or password.'));
}
req.session.user = rows[0];
return done(null, rows[0]);
});
}
));
passport.serializeUser(function(user, done){
done(null, user.id);
});
passport.deserializeUser(function(id, done){
connection.query("select * from tbl_users where id = "+ id, function (err, rows){
done(err, rows[0]);
});
});
app.get('/signin', function(req, res){
res.render('login/index',{'message' :req.flash('message')});
});
app.post("/signin", passport.authenticate('local', {
successRedirect: '/users',
failureRedirect: '/signin',
failureFlash: true
}), function(req, res, info){
res.render('login/index',{'message' :req.flash('message')});
});
app.get('/logout', function(req, res){
req.session.destroy();
req.logout();
res.redirect('/signin');
});
// catch 404 and forward to error handler
app.use(function(req, res, next) {
var err = new Error('Not Found');
err.status = 404;
next(err);
});
// error handler
app.use(function(err, req, res, next) {
// set locals, only providing error in development
res.locals.message = err.message;
res.locals.error = req.app.get('env') === 'development' ? err : {};
// render the error page
res.status(err.status || 500);
res.render('error');
});
module.exports = app;