如何在使用aws cdk部署项目后修复错误

Question

    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之后，它会因以下错误而崩溃：信息将导致auth错误："config.server“属性是必需的，必须是string.类型。

Answer 1

看起来env变量在运行应用程序的环境中是不可用的。如果是Lambda函数，请确保在相关的CDK构造中传递env变量。

我建议也使用AWS秘密管理器来存储诸如密码这样的敏感变量。