Sequelize db:migrate throw TypeError: Data must be a string or a buffer

Question

crypto.js:74
  this._handle.update(data, encoding);
               ^
TypeError: Data must be a string or a buffer
at TypeError (native)
at Hash.update (crypto.js:74:16)
at sha1 (/mnt/projects/Nodejs/develda/node_modules/mysql2/lib/auth_41.js:30:8)
at Object.token [as calculateToken] (/mnt/projects/Nodejs/develda/node_modules/mysql2/lib/auth_41.js:64:16)
at new HandshakeResponse (/mnt/projects/Nodejs/develda/node_modules/mysql2/lib/packets/handshake_response.js:25:24)
at ClientHandshake.sendCredentials (/mnt/projects/Nodejs/develda/node_modules/mysql2/lib/commands/client_handshake.js:46:27)
at ClientHandshake.handshakeInit (/mnt/projects/Nodejs/develda/node_modules/mysql2/lib/commands/client_handshake.js:122:10)
at ClientHandshake.Command.execute (/mnt/projects/Nodejs/develda/node_modules/mysql2/lib/commands/command.js:39:20)
at Connection.handlePacket (/mnt/projects/Nodejs/develda/node_modules/mysql2/lib/connection.js:417:28)
at PacketParser.onPacket (/mnt/projects/Nodejs/develda/node_modules/mysql2/lib/connection.js:93:16)
at PacketParser.executeStart (/mnt/projects/Nodejs/develda/node_modules/mysql2/lib/packet_parser.js:73:14)
at Socket.<anonymous> (/mnt/projects/Nodejs/develda/node_modules/mysql2 /lib/connection.js:101:29)
at emitOne (events.js:96:13)
at Socket.emit (events.js:188:7)
at readableAddChunk (_stream_readable.js:176:18)
at Socket.Readable.push (_stream_readable.js:134:10)
at TCP.onread (net.js:547:20)

I'm getting this error when I try to migrate with node_modules/.bin/sequelize db:migrate

I think the mysql2 package causes this error

I'm appreciate for your help

Tomer Barak · Accepted Answer · 2017-11-09 09:42:23Z

11

First, please make sure your config.json does not contain any unquoted values like the password in this example:

{
 "my_env": {
    "username": "root",
    "password": 1234,
    "database": "my_db",
    "host"    : "localhost",
    "dialect" : "mysql"
  }
}

If that doesn't solve your problem and you have a strong reason to believe it has something to do with mysql2 package, try downgrading your sequelize package to v3 and which uses mysql rather than mysql2

answered Nov 9, 2017 at 9:42

Tomer Barak

1261 silver badge4 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Idan Gozlan Over a year ago

god bless u achinu :)

JanS · Accepted Answer · 2018-01-10 13:47:53Z

0

If you use the command "sequelize init" to init the project,then you should check your config.json.Because by default "port" field don't include. Meanwhile，please make sure your config.json does not contain any unquoted like the password in this example.

{
 "my_env": {
    "username": "root",
    "password": 1234,
    "database": "my_db",
    "host"    : "localhost",
    "dialect" : "mysql"
  }
}

edited Jan 10, 2018 at 13:47

JanS

2,0653 gold badges29 silver badges30 bronze badges

answered Jan 10, 2018 at 12:12

zhangke

11 bronze badge

Comments

Richard · Accepted Answer · 2022-01-22 16:28:32Z

0

In my case, I had an empty object in my database.json file:

{
  "dev": {
    "driver": "pg",
    "user": {"ENV": "DB_USER"},
    "password": {"ENV": "DB_PASS"},
    "host": {"ENV": "DB_HOST"},
    "database": {},              <-- THIS LINE
    "port": {"ENV": "DB_PORT"}
  }
}

The line: "database": {}, was causing the issue.

"database" should be a string.

answered Jan 22, 2022 at 16:28

Richard

2,67127 silver badges27 bronze badges

Collectives™ on Stack Overflow

Sequelize db:migrate throw TypeError: Data must be a string or a buffer

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related