我有一个 MySQL、Express、Angular、NodeJS 应用程序,有时当我登录时,我的节点控制台中会出现以下错误:
类型错误:无法读取未定义的属性“查询”
错误发生在我的passport.local.js
文件,这是行:
connection.query('SELECT * FROM users WHERE username LIKE ?', [username], function (err, user) {
这是护照功能
passport.use(new LocalStrategy(
function(username, password, done) {
console.log('app.js');
pool.getConnection(function(err, connection) {
console.log('err: ' + err);
console.log(connection);
connection.query('SELECT * FROM users WHERE username LIKE ?', [username], function (err, user) {
if (err) throw err;
for (var i = user.length - 1; i >= 0; i--) {
var current = user[i];
}
if(current){
if(bcrypt.compareSync(password, current.password)){
return done(null, user);
} else {
return done(null, false);
}
} else {
console.log('no user');
return done(null, false);
}
});
connection.release();
});
}
));
我需要我的pool
在我的文件顶部
var pool = require('../../config/connection');
当错误发生时:
console.log(connection);
Gets:
不明确的
我还记录了错误:
console.log('err: ' + err);
Shows:
err: Error: ER_USER_LIMIT_REACHED: User 'bfe4a8980ede74' has exceeded the 'max_user_connections' resource (current value: 10)