import * as tedious from "tedious"
const { Sequelize } = require("sequelize");
const sequelize = new Sequelize({
"dialect": "mssql",
"dialectModule": tedious,
"dialectOptions": {
"driver": "SQL Server Native Client 11.0",
"trustedConnection": true
},
"username": process.env.USER_NAME,
"password": process.env.PASSWORD,
"database": process.env.DATABASE,
"host": process.env.SERVER,
"port": 1433,
"logging": console.log,
"pool": {}
})
(async () => {
await sequelize.authenticate()
console.log('authentication success')
})().catch(err => {
console.log("sequelize auth error:", err.message)
})
本地作業正常，但在部署到 aws 后，它會因以下錯誤而崩潰： INFO sequelize auth error: The "config.server" property is required and must be of type string.
uj5u.com熱心網友回復：
看起來 env 變數在您運行應用程式的環境中不可用。如果它是 Lambda 函式，請確保您在相關 CDK 構造中傳遞了環境變數。
PS 我還建議使用 AWS 機密管理器來存盤密碼等敏感變數。
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/517185.html