如何实现请求身份验证?

Question

我想实现请求身份验证，但一直出现此错误：

错误：参数传递给 findByPk 无效：[对象对象] at Function.findByPk (/home/admin/Desktop/project/node_modules/sequelize/lib/model.js：1714：13( at Function.Model.findById (/home/admin/Desktop/project/node_modules/sequelize/lib/model.js：4209：25( at JwtStrategy.passport.use.JwtStrategy [as _verify] (/home/admin/Desktop/project/middleware/passport.js：16：41( at/home/admin/Desktop/project/node_modules/passport-jwt/lib/strategy.js：123：34 at/home/admin/Desktop/project/node_modules/jsonwebtoken/verify.js：196：12 at getSecret (/home/admin/Desktop/project/node_modules/jsonwebtoken/verify.js：76：14( at Object.module.exports [as verify] (/home/admin/Desktop/project/node_modules/jsonwebtoken/verify.js：80：10( at Function.module.exports [as JwtVerifier] (/home/admin/Desktop/project/node_modules/passport-jwt/lib/verify_jwt.js：4：16( at/home/admin/Desktop/project/node_modules/passport-jwt/lib/strategy.js：104：25 at JwtStrategy._secretOrKeyProvider (/home/admin/Desktop/project/node_modules/passport-jwt/lib/strategy.js：40：13( at JwtStrategy.authenticate (/home/admin/Desktop/project/node_modules/passport-jwt/lib/strategy.js：99：10( 尝试(/home/admin/Desktop/project/node_modules/passport/lib/middleware/authenticate.js：361：16( at authenticate (/home/admin/Desktop/project/node_modules/passport/lib/middleware/authenticate.js：362：7( at Layer.handle [as handle_request] (/home/admin/Desktop/project/node_modules/express/lib/router/layer.js：95：5( at next (/home/admin/Desktop/project/node_modules/express/lib/router/route.js：137：13( at Route.dispatch (/home/admin/Desktop/project/node_modules/express/lib/router/route.js：112：3( at Layer.handle [as handle_request] (/home/admin/Desktop/project/node_modules/express/lib/router/layer.js：95：5( at/home/admin/Desktop/project/node_modules/express/lib/router/index.js：281：22 at Function.process_params (/home/admin/Desktop/project/node_modules/express/lib/router/index.js：335：12( at next (/home/admin/Desktop/project/node_modules/express/lib/router/index.js：275：10( at Function.handle (/home/admin/Desktop/project/node_modules/express/lib/router/index.js：174：3( at router (/home/admin/Desktop/project/node_modules/express/lib/router/index.js：47：12(

我使用PostgreSQL作为数据库，Sequelize作为ORM。

路线：

const express = require('express')
const router = express.Router()
const controller = require('../controllers/user')
const passport = require('passport')

// localhost:5000/api/admin/users
router.get('/users', passport.authenticate('jwt', {session: false}), controller.getAll)
module.exports = router

护照：

const JwtStrategy = require('passport-jwt').Strategy
const ExtractJwt = require('passport-jwt').ExtractJwt
const db = require('../config/db.config.js')
const User = db.user

const options = {
jwtFromRequest: ExtractJwt.fromAuthHeaderAsBearerToken(), 
secretOrKey: process.env.SECRET_OR_KEY
}
module.exports = passport => {
passport.use(
new JwtStrategy(options, async (payload, done) => {
try {
const user = await User.findById({
where: {
id:  payload.id
}
}).select('username id')
if (user) {
done(null, user)
} else {
done(null, false)
}
} catch(e) {
console.log(e)
}
})
)
}

控制器：

const db = require('../config/db.config.js')
const User = db.user
const errorHandler = require('../utils/errorHandler')
module.exports.getAll = async function(req, res) {
try {
const users = await User.findAll({user: req.user.id})
res.status(200).json(users)
} catch(e) {
errorHandler(req, e)
}
}

Answer 1

在您的护照代码中，您正在调用User.findById并传递 where 子句。

我相信它应该只是User.findById(payload.id)