var express = require('express');
var session = require('express-session');
var SessionStore = require('express-mysql-session');
var http = require('http');
var path = require('path');

var app = express();

// all environments
app.set('port', process.env.PORT || 3000);
app.set('views', path.join(__dirname, 'theme'));
app.set('view engine', 'ejs');

app.use(express.bodyParser());
app.use(express.favicon());
app.use(express.logger('dev'));
app.use(express.json());
app.use(express.urlencoded());
app.use(express.methodOverride());
app.use(app.router);
app.use(express.static(path.join(__dirname, 'public')));
app.use(express.cookieParser());

var options = {
    host: '127.0.0.1',
    port: 3000,
    user: 'nodejs',
    password: 'c5c58f',
    database: 'nodejs'
}

app.use(session({
    key: 'session_cookie_name',
    secret: 'session_cookie_secret',
    store: new SessionStore(options)
}))

app.get('/', function(req, res, next) {
    req.session.number = req.session.number + 1 || 1;
    console.log(req.session.number)
})

http.createServer(app).listen(app.get('port'), function(){
  console.log('Express server listening on port ' + app.get('port'));
});

var express = require('express');
var session = require('express-session');
var SessionStore = require('express-mysql-session');
var http = require('http');
var connect = require('connect');
var path = require('path');

var app = express();

// all environments
app.set('port', process.env.PORT || 3000);
app.set('views', path.join(__dirname, 'theme'));
app.set('view engine', 'ejs');

app.use(connect.bodyParser());
app.use(connect.favicon());
app.use(connect.logger('dev'));
app.use(connect.json());
app.use(connect.urlencoded());
app.use(connect.methodOverride());
app.use(express.static(path.join(__dirname, 'public')));
app.use(connect.cookieParser());

var options = {
    host: 'localhost',
    user: 'root',
    password: '',
    database: 'test'
}

app.use(session({
    key: 'session_cookie_name',
    secret: 'session_cookie_secret',
    store: new SessionStore(options)
}))

app.get('/', function(req, res, next) {
    console.log("aaa");
    req.session.number = req.session.number + 1 || 1;
    console.log(req.session.number)
    res.end("You saw this "+req.session.number.toString()+" times");
    next();
})

http.createServer(app).listen(app.get('port'), function(){
  console.log('Express server listening on port ' + app.get('port'));
});

{
  "name": "sample1",
  "version": "0.0.1",
  "private": true,
  "dependencies": {
    "connect": "^2.25.7",
    "express": "^4.8.5",
    "express-mysql-session": "^0.2.0",
    "express-session": "^1.7.6"
  }
}

npm install

node app.js

var app = express();

app.use(session({
  secret: 'your secret here',
  resave: true,
  saveUninitialized: true,
  key: 'jsessionid',
  store: new MongoStore({ mongooseConnection: mongoose.connection })
}));

passport.serializeUser(function (user, done) {
   // console.log("serializeUser", user);
   done(null, user.id);
});

passport.deserializeUser(function (id, done) {
   User.findById(id).exec(function (err, user) {
     // console.log("deserializeUser", user);
     done(err, user);
   });
});

app.use(passport.initialize());
app.use(passport.session());

app.post('/api/login', passport.authenticate('local'), function (req,
res, next) {
  res.cookie('user', JSON.stringify(req.user._id));
  res.send(req.user);
});

app.post('/api/logout', function (req, res, next) {
   req.logout();
   res.clearCookie('user');
   res.send(200).end();
});

app.get('/api/user', function (req, res, next) {
   if (req.user)
      res.send(req.user);
   else
      res.send(false);
});