[Backlogmanager] [FIWARE-JIRA] (HELP-14007) [fiware-stackoverflow] fiware keyrock installation failing migrate_db not working

[Alvaro Alonso (JIRA)]

     [ https://jira.fiware.org/browse/HELP-14007?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Alvaro Alonso updated HELP-14007:
---------------------------------
    Status: In Progress  (was: Open)

> [fiware-stackoverflow] fiware keyrock installation failing migrate_db not working
> ---------------------------------------------------------------------------------
>
>                 Key: HELP-14007
>                 URL: https://jira.fiware.org/browse/HELP-14007
>             Project: Help-Desk
>          Issue Type: Monitor
>          Components: FIWARE-TECH-HELP
>            Reporter: Backlog Manager
>            Assignee: Alvaro Alonso
>              Labels: fiware, npm
>
> Created question in FIWARE Q/A platform on 20-04-2018 at 12:04
> {color: red}Please, ANSWER this question AT{color} https://stackoverflow.com/questions/49939574/fiware-keyrock-installation-failing-migrate-db-not-working
> +Question:+
> fiware keyrock installation failing migrate_db not working
> +Description:+
> I followed the installation guide of keyrock (https://github.com/ging/fiware-idm) step by step and until step 6 everything works.
> The command 
> npm run-script create_db
> runs fine, but when executing afterwards
> npm run-script migrate_db
> it gives the following error:
>   idm at 0.0.0 migrate_db /home/user/keyrock/fiware-idm
>   sequelize --env database db:migrate
>   
>   Sequelize CLI [Node: 9.11.1, CLI: 4.0.0, ORM: 4.33.4]
>   
>   Loaded configuration file "config.js". Using environment "database".
>   sequelize deprecated String based operators are now deprecated. Please
>   use Symbol based operators for better security, read more at
>   http://docs.sequelizejs.com/manual/tutorial/querying.html#operators
>   node_modules/sequelize/lib/sequelize.js:242:13
>   == 201802190000-CreateUserTable: migrating =======
>   
>   ERROR: Specified key was too long; max key length is 767 bytes
>   
>   npm ERR! code ELIFECYCLE npm ERR! errno 1 npm ERR! idm at 0.0.0
>   migrate_db: sequelize --env database db:migrate npm ERR! Exit status
>   1 npm ERR!  npm ERR! Failed at the idm at 0.0.0 migrate_db script. npm
>   ERR! This is probably not a problem with npm. There is likely
>   additional logging output above.
>   
>   npm ERR! A complete log of this run can be found in: npm ERR!
>   /home/user/.npm/_logs/2018-04-20T10_17_49_553Z-debug.log
> and this is the log file it suggested to view
>   0 info it worked if it ends with ok
>   
>   1 verbose cli [ '/usr/bin/node','/usr/bin/npm', 'run-script', 'migrate_db' ]
>   
>   2 info using npm at 5.6.0
>   
>   3 info using node at v9.11.1 
>   
>   4 verbose run-script [ 'premigrate_db',
>   'migrate_db', 'postmigrate_db' ]
>   
>   5 info lifecycle
>   idm at 0.0.0~premigrate_db: idm at 0.0.0
>   
>   6 info lifecycle
>   idm at 0.0.0~migrate_db: idm at 0.0.0
>   
>   7 verbose lifecycle
>   idm at 0.0.0~migrate_db: unsafe-perm in lifecycle true 
>   
>   8 verbose
>    lifecycle idm at 0.0.0~migrate_db: PATH:
>   /usr/lib/node_modules/npm/node_modules/npm-lifecycle/node-gyp-bin:/home/user/keyrock/fiware-idm/node_modules/.bin:/usr/local/bin:/usr/bin:/bin:/usr/local/games:/usr/games:/usr/lib/jvm/java-9-oracle/bin:/usr/lib/jvm/java-9-oracle/db/bin
>   
>   9 verbose lifecycle idm at 0.0.0~migrate_db: CWD:
>   /home/user/keyrock/fiware-idm 
>   
>   10 silly lifecycle idm at 0.0.0~migrate_db:
>   Args: [ '-c', 'sequelize --env database db:migrate' ]
>   
>   11 silly
>   lifecycle idm at 0.0.0~migrate_db: Returned: code: 1  signal: null
>   
>   12
>   info lifecycle idm at 0.0.0~migrate_db: Failed to exec migrate_db script
>   
>   13 verbose stack Error: idm at 0.0.0 migrate_db: sequelize --env
>   database db:migrate 
>   
>   13 verbose stack Exit status 1
>   
>   13 verbose stack
>   at EventEmitter.
>   (/usr/lib/node_modules/npm/node_modules/npm-lifecycle/index.js:285:16)
>   
>   13 verbose stack     at EventEmitter.emit (events.js:180:13)
>   
>   13
>   verbose stack     at ChildProcess.
>   (/usr/lib/node_modules/npm/node_modules/npm-lifecycle/lib/spawn.js:55:14)
>   
>   13 verbose stack     at ChildProcess.emit (events.js:180:13)
>   
>   13
>   verbose stack     at maybeClose (internal/child_process.js:936:16)
>   
>   13
>   verbose stack     at Process.ChildProcess._handle.onexit
>   (internal/child_process.js:220:5) 
>   
>   14 verbose pkgid idm at 0.0.0
>   
>   15
>   verbose cwd /home/user/keyrock/fiware-idm
>   
>   16 verbose Linux
>   4.9.0-4-amd64 
>   
>   17 verbose argv "/usr/bin/node" "/usr/bin/npm" "run-script" "migrate_db"
>   
>   18 verbose node v9.11.1
>   
>   19 verbose npm v5.6.0
>   
>   20 error code ELIFECYCLE
>   
>   21 error errno 1 22 error idm at 0.0.0
>   
>   migrate_db: sequelize --env database db:migrate
>   
>   22 error Exit status
>   1 
>   
>   23 error Failed at the idm at 0.0.0 migrate_db script. 23 error This is
>   probably not a problem with npm. There is likely additional logging
>   output above.
>   
>   24 verbose exit [ 1, true ]
> Any help is highly appreciated.



--
This message was sent by Atlassian JIRA
(v6.4.1#64016)