Failed to deserialize user out of session

285 views
Skip to first unread message

Farah Javed

unread,
Apr 26, 2016, 1:54:47 PM4/26/16
to Express

12:41 PM (7 minutes ago)
Hi-

My session is stored in database table.  When i use multiple workers (cluster middleware), i get "Failed to deserialize error".  I am using express js framework and "connect-mssql" middleware to persist or serialize session information in database.  Can someone please help me with this issue?

Thanks
Farah

Session related Code
var express=require('express');
var expressSession=require('express-session')
var MSSQLStore = require('connect-mssql')(expressSession);
var bodyParser=require('body-parser')
var cookieParser=require('cookie-parser')
var passport = require('passport');

router.use(cookieParser())

//config for db that stores session info
var config = {   
    user: 'user',
    password: 'password',
    server: 'server',
    database: 'database name',
    options: {
        table: 'sessions' ,

    }  
   
}

router.use(expressSession({
secret: process.env.SESSION_SECRET || 'test',
  store:new MSSQLStore(config),
resave:false,
saveUninitialized: false,
cookie:{secure:false,maxAge:10 * 90 * 1000},
  rolling: true,

}))
router.use(passport.initialize());
router.use(passport.session());
Auto Generated Inline Image 1
Reply all
Reply to author
Forward
0 new messages