在Azure上调用Node.js API的连接关闭错误
我有一个nodejs Rest API调用我的本地SQL Server。它托管在Azure上,并使用Azure Hybrid Connection连接到我的SQL Server。所有操作均在本地计算机上按预期运行,但是在Azure上尝试调用以下“测试”路由时,出现ConnectionClosed错误(ECONNCLOSED):
这是我的代码示例:
var express = require('express');
var app = express();
var sql = require('mssql/msnodesqlv8');
// Connection string parameters.
var sqlConfig = {
user: 'restapi', //remove if using Windows Auth
password: 'restapi', //remove if using Windows Auth
database: 'dbname',
server: 'server\\instance',
driver: 'msnodesqlv8',
options: {
encrypt: true
}
}
var server = app.listen(process.env.PORT || 8081, function () {
var host = server.address().address
var port = server.address().port
console.log("app listening at http://%s:%s", host, port)
});
app.get('/', function(req, res) {
res.json({"message": "Welcome to the API"});
});
app.get('/Test', function (req, res) {
sql.connect(sqlConfig, function() {
var request = new sql.Request();
request.query("select 1 as number") //query
.then(result => {
let rows = result.recordset //first recordset
res.setHeader('Access-Control-Allow-Origin', '*')
res.status(200).json(rows);
sql.close();
}).catch(err => {
console.log(err);
res.status(500).send({
message: err
})
sql.close();
});
})
});
有什么想法吗?
回答如下:这是我可行的示例:
var express = require('express');
var app = express();
var sql = require('mssql');
var sqlConfig = {
user: 'jack',
password: 'password',
database: 'jackdemo',
server: 'jackdemo.database.windows',
options: {
encrypt: true
}
}
var server = app.listen(process.env.PORT || 8081, function () {
var host = server.address().address
var port = server.address().port
console.log("app listening at http://%s:%s", host, port)
});
app.get('/', function(req, res) {
res.json({"message": "Welcome to the API"});
});
app.get('/Test', function (req, res) {
sql.connect(sqlConfig, function() {
var request = new sql.Request();
request.query("select 1 as number")
.then(result => {
let rows = result.recordset //first recordset
res.setHeader('Access-Control-Allow-Origin', '*')
res.status(200).json(rows);
sql.close();
}).catch(err => {
console.log(err);
res.status(500).send({
message: err
})
sql.close();
});
})
});
您也可以使用官方教程中的方法:Use Node.js to query an Azure SQL database
顺便请确保您已经为Azure SQL正确配置了防火墙规则。您需要将客户端IP添加到允许的列表中,如下所示:https://docs.microsoft/en-us/azure/sql-database/sql-database-firewall-configure#create-and-manage-ip-firewall-rules