我正在尝试运行quelize-cli,特别是 npx sequelize db:migrate
。
我已经在config/config.js
中创建了一个看起来像这样的配置文件(显然具有正确的凭据(:
module.exports = {
development: {
username: "USER",
password: "PASSWORD",
database: "DB_NAME",
host: "HOST.net",
dialect: 'mssql',
dialectOptions: {
encrypt: "true" // bool - true - doesn't work either
}
}
};
但是我收到以下错误:
ERROR: Server requires encryption, set 'encrypt' config option to true.
您可以从我的配置中看到,我相信我已经将加密设置为true。这是我对如何从文档设置此选项的理解。
如何成功将encrypt
设置为true?
这应该解决问题,
module.exports = {
development: {
username: "USER",
password: "PASSWORD",
database: "DB_NAME",
host: "HOST.net",
dialect: 'mssql',
dialectOptions: {
options: {
encrypt: true
}
}
}
};
编辑 config.js
module.exports = {
url: process.env.DATABASE_URL,
dialectOptions: {
ssl: {
require: true,
rejectUnauthorized: false,
},
},
};