I have a local database (SQL Server) and I want to connect to it to do the login validations to my app, I even followed the example provided by Auth0 but it doesn’t connect and it only says “Request to Webtask exceeded allowed execution time”, and it doesn’t I understand what the problem is because even adding the connection parameters wrong gives me the same message, it’s as if it doesn’t matter that my connection data is wrong, it still gives me the same error, I leave my code in case there is something wrong I contemplated:
function login(email, password, callback) {
const bcrypt = require(‘bcrypt’);
const sqlserver = require(‘mssql’);
const Connection = sqlserver.Connection;
const Request = sqlserver.Request;
const TYPES = sqlserver.TYPES;
const connection = new Connection({
userName: ‘sa’,
password: ‘12345’,
server: ‘DESKTOP-XXXX\SQLEXPRESS’, #I already tried with localhost and with the ip
options: {
database: ‘pruebaDj’
}
});
const query = ‘SELECT id, nombreUsuario, Email, pwd FROM dbo.Login_nuevousuario WHERE Email = @Email’;
connection.on(‘debug’, function (text) {
console.log(text);
}).on(‘errorMessage’, function (text) {
console.log(JSON.stringify(text, null, 2));
}).on(‘infoMessage’, function (text) {
console.log(JSON.stringify(text, null, 2));
});
connection.on(‘connect’, function (err) {
if (err) return callback(err);
const request = new Request(query, function (err, rowCount, rows) {
if (err || rowCount < 1) return callback(err || new WrongUsernameOrPasswordError(email));
bcrypt.compare(password, rows[0][3].value, function (err, isValid) {
if (err || !isValid) return callback(err || new WrongUsernameOrPasswordError(email));
callback(null, {
user_id: rows[0][0].value,
nickname: rows[0][1].value,
email: rows[0][2].value
});
});
});
request.addParameter(‘Email’, TYPES.VarChar, email);
connection.execSql(request);
});
}