lux icon indicating copy to clipboard operation
lux copied to clipboard

db:create with mysql : unknown database

Open fiftoine opened this issue 7 years ago • 0 comments

  • Platform: Windows 10 64-bit
  • Database: Mysql
  • Lux Version: 1.2.2
  • Node Version: 8.9.3

Hi,

I created a new app

$ lux new myapp --database mysql
$ cd myapp

When I want to create the database:

$ lux db:create

I got an error :

Error: Unknown database 'myapp_dev'
    at Packet.asError (F:\workspace\lux\testApp6\node_modules\mysql2\lib\packets\packet.js:713:13)
    at ClientHandshake.Command.execute (F:\workspace\lux\testApp6\node_modules\mysql2\lib\commands\command.js:28:22)
    at Connection.handlePacket (F:\workspace\lux\testApp6\node_modules\mysql2\lib\connection.js:515:28)
    at PacketParser.onPacket (F:\workspace\lux\testApp6\node_modules\mysql2\lib\connection.js:94:16)
    at PacketParser.executeStart (F:\workspace\lux\testApp6\node_modules\mysql2\lib\packet_parser.js:77:14)
    at Socket.<anonymous> (F:\workspace\lux\testApp6\node_modules\mysql2\lib\connection.js:102:29)
    at emitOne (events.js:116:13)
    at Socket.emit (events.js:211:7)
    at addChunk (_stream_readable.js:263:12)
    at readableAddChunk (_stream_readable.js:250:11)
    at Socket.Readable.push (_stream_readable.js:208:10)
    at TCP.onread (net.js:594:20)
From previous event:
    at Client_MySQL2.acquireRawConnection (F:\workspace\lux\testApp6\node_modules\knex\lib\dialects\mysql2\index.js:74:12)
    at Object.create (F:\workspace\lux\testApp6\node_modules\knex\lib\client.js:231:16)
    at Pool._createResource (F:\workspace\lux\testApp6\node_modules\generic-pool\lib\generic-pool.js:354:17)
    at Pool._ensureMinimum (F:\workspace\lux\testApp6\node_modules\generic-pool\lib\generic-pool.js:408:12)
    at new Pool (F:\workspace\lux\testApp6\node_modules\generic-pool\lib\generic-pool.js:157:8)
    at Client_MySQL2.initializePool (F:\workspace\lux\testApp6\node_modules\knex\lib\client.js:261:17)
    at Client_MySQL2.Client (F:\workspace\lux\testApp6\node_modules\knex\lib\client.js:108:12)
    at Client_MySQL2.Client_MySQL (F:\workspace\lux\testApp6\node_modules\knex\lib\dialects\mysql\index.js:62:20)
    at new Client_MySQL2 (F:\workspace\lux\testApp6\node_modules\knex\lib\dialects\mysql2\index.js:50:19)
    at Knex (F:\workspace\lux\testApp6\node_modules\knex\lib\index.js:60:34)
    at connect (E:\Users\Antoine\AppData\Roaming\npm\node_modules\lux-framework\src\packages\database\utils\connect.js:54:3
    at dbcreate (E:\Users\Antoine\AppData\Roaming\npm\node_modules\lux-framework\src\packages\cli\commands\dbcreate.js:32:2
    at exec (E:\Users\Antoine\AppData\Roaming\npm\node_modules\lux-framework\bin\lux:56:10)
    at exec.then (E:\Users\Antoine\AppData\Roaming\npm\node_modules\lux-framework\bin\lux:179:19)
    at <anonymous>

It's like Knex try to connect to the myapp_dev database but as it doesn't exist, there is an error.

Is it a bug or something I do wrong?

If a create manually the database myapp_dev, db:migrate and db:seed wotk well.

fiftoine avatar Dec 31 '17 10:12 fiftoine