Express.js中Passport会话存储配置报错（Sequelize+PostgreSQL）

安全阿岳

2026-6-15

Express.js 中使用 Passport + Sequelize 配置会话时的类型错误问题

错误信息

An error occurred for attribute sid on model Session.
[cause]: TypeError: Expected type to be a string, a DataType class, or a DataType instance, but got STRING {
options: { length: 36, binary: undefined },
_binary: undefined,
_length: 36

相关代码

app.js 代码

// passport
const passport = require('./config/auth/passport');
const session = require('express-session');
const SequelizeStore = require('connect-session-sequelize')(session.Store);
const { sequelize } = require('./config/database'); // Adjust the path to your Sequelize instance
const Session = require('./modules/auth/models/session'); // Adjust the path to your Session model


app.use(session({
    secret: process.env.SESSION_SECRET,
    resave: false,
    saveUninitialized: false,
    cookie: {
        //secure: process.env.NODE_ENV === "production",
        maxAge: 24 * 60 * 60 * 1000, // 24 hours
    },
    store: new SequelizeStore({
        db: sequelize,
        tableName: 'Session',
        checkExpirationInterval: parseInt(process.env.SESSION_EXPIRATION_INTERVAL, 10),
        expiration: parseInt(process.env.SESSION_EXPIRATION, 10)
    }),
}));

session.js 模型代码

const { DataTypes } = require('@sequelize/core');
const { sequelize } = require('../../../config/database');

const Session = sequelize.define('Session', {
    sid: {
        type: DataTypes.STRING(36),
        primaryKey: true,
        allowNull: false,
    },
    expires: {
        type: DataTypes.DATE,
        allowNull: false,
    },
    data: {
        type: DataTypes.STRING(50000),
        allowNull: false,
    },
}, {
    tableName: 'Session', // Custom table name
    timestamps: true, // Includes createdAt and updatedAt
});

module.exports = Session;