Different Way Mongoose Connection

https://stackoverflow.com/questions/37695147/connect-mongo-creating-new-session-every-second
var express = require(‘express’);
var fs = require(‘fs’);
var mongoose = require(‘mongoose’);
var passport = require(‘passport’);
var flash = require(‘connect-flash’);

var morgan = require(‘morgan’);
var cookieParser = require(‘cookie-parser’);
var bodyParser = require(‘body-parser’);

var MongoStore = require(‘connect-mongo/es5’)(express);

var app = express();

var server_port = process.env.OPENSHIFT_NODEJS_PORT || 8080;
var server_ip_address = process.env.OPENSHIFT_NODEJS_IP || ‘0.0.0.0’;

//MongoD
mongodb_connection_string = process.env.OPENSHIFT_MONGODB_DB_URL + “tenders”;
mongoose.connect(mongodb_connection_string);
var dbconn = mongoose.connection;
dbconn.on(‘error’, console.error.bind(console, ‘connection error:’));
dbconn.once(‘open’, function(){
console.log(‘Connected to Mongoose Database.’);
});

// Close MongoD connection when app is terminated
process.on(‘SIGINT’, function (){
mongoose.disconnect();
dbconn.close(function (){
console.log(“Server halted: Mongoose default connection disconnected.”);
process.exit(0);
});
});

/* Configuration */
app.set(‘view engine’, ‘ejs’); // set up ejs for templating

/* Middlewares */
app.use(express.static(__dirname + “/views”));
app.use(express.static(__dirname + “/public”));

// set up our express application
app.use(morgan(‘dev’)); // log every request to the console
app.use(bodyParser()); // get information from html forms
app.use(cookieParser()); // read cookies (needed for auth)

/** Persistent database backed session **/
app.use(express.session({
secret: process.env.SECRET,
store: new MongoStore({mongooseConnection : mongoose.connection})
}));

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

require(‘./routes/routes’)(app, passport);
require(‘./config/passport’)(passport); configuration

app.use(function(req, res) {
res.redirect(‘/’)
});

app.use(function (err, req, res, next) {
if (err.name === ‘UnauthorizedError’) {
res.status(401);
res.json({“message” : err.name + “: ” + err.message});
}
});

/* Start server */
app.listen(server_port, server_ip_address, function(){
console.log(“Listening on ” + server_ip_address + “:” + server_port);
});

Answer :
// Configuring sessions
var session = require(‘express-session’);
var MongoStore = require(‘connect-mongo’)(session);
app.use(session({
secret: ‘JohnSecret’,
saveUninitialized: false, // don’t create session until something stored
resave: false, //don’t save session if unmodified
store: new MongoStore({
url: ‘mongodb://localhost/John’,
autoRemove: ‘interval’,
autoRemoveInterval: 10 // In minutes. Default
})
}));
—–
Okay, it is the issue with HAProxy continuously checking the backend server to see that its up and working. In doing so it is creating a session a second and cluttering my database. So here is my (dirty) fix:

Create an api /ping that handles HAProxy’s httpchk by destroying each session

app.get(‘/ping’, function(req, res){
req.session.destroy();
res.send(200);
});

Configure haproxy/conf to change option httpchk GET / to option httpchk GET /ping

Restart HAProxy cartridge using RHC rhc cartridge-restart –cartridge haproxy

Leave a Reply

Your email address will not be published. Required fields are marked *