I receive "ERROR: Port should be >= 0 and < 65536. Received NaN." on Elastic Beanstalk

[jsindos]

What you are doing?

I'm trying to run npx sequelize-cli db:migrate --env production on an Elastic Beanstalk Node.js instance. The database settings are

  "production": {
    "username": "process.env.RDS_USERNAME",
    "password": "process.env.RDS_PASSWORD",
    "database": "process.env.RDS_DB_NAME",
    "host": "process.env.RDS_HOSTNAME",
    "port": "process.env.RDS_PORT",

What is actually happening?

When I attempt to run the command, I get the following output

npx sequelize-cli db:migrate --env production

Sequelize CLI [Node: 14.18.1, CLI: 6.6.0, ORM: 6.21.0]

Loaded configuration file "settings.json".
Using environment "production".

ERROR: Port should be >= 0 and < 65536. Received NaN.

I've logged process.env.RDS_PORT and am getting the following

console.log('process.env.RDS_PORT', process.env.RDS_PORT)
process.env.RDS_PORT 5432

Dialect: postgres
Sequelize CLI version: 6.6.0
Sequelize version: 6.21.0

[WikiRik]

You are passing a string called "process.env.RDS_PORT", not the actual process.env.RDS_PORT value. Try the following;

  "production": {
    "username": process.env.RDS_USERNAME,
    "password": process.env.RDS_PASSWORD,
    "database": process.env.RDS_DB_NAME,
    "host": process.env.RDS_HOSTNAME,
    "port": process.env.RDS_PORT,