heroku cleardb client missing error

Question

I am trying to migrate mysql database into heroku cleardb. I'm doing node service.
My tried code is,
knexfile.js

production: {
client: "mysql",
connection: {
  host:     "us-cdbr-iron-east-04.cleardb.net",
  user:     "bcf521a*******",
  password: "9282****",
  database: "heroku_9c9d767dbb*****"
}    
}

in heroku, set the config with CLEARDB_DATABASE_URL.it done. When I try to run

heroku run node_modules/.bin/knex migrate:latest
Running node_modules/.bin/knex migrate:latest on ⬢ hidden-taiga-65640
... up, run.7007 (Free)
Using environment: production

The terminal error shows,

knex: Required configuration option 'client' is missing

How to resolve this?

Do you have NODE_ENV=production set in heroku environment? Also you didnt show the whole knex file so there might ve some problems too. — Mikael Lepistö, May 09 '18 at 09:43
@MikaelLepistö, when I run the migration, it takes the env as production. — Prabha, May 09 '18 at 11:16
I try to import manually, that gives the current_timestamp error. coz of version — Prabha, May 09 '18 at 11:17

score 0 · Answer 1 · answered Nov 17 '21 at 21:06

Take a good, hard look at your env variables. Make sure that these match your variables in the Heroku app settings. Also, on your knexfile, make sure you're not using || to declare your environment:

const environment = process.env.ENV || 'development';

just leave the process.env.ENV.

heroku cleardb client missing error

1 Answers1