[ https://jira.fiware.org/browse/HELP-14007?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Fernando Lopez updated HELP-14007:
----------------------------------
HD-Chapter: Security
Description:
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.
was:
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.
HD-Enabler: KeyRock
> [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
> 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)
You can get more information about our cookies and privacy policies clicking on the following links: Privacy policy Cookies policy