zeroxbt
commented
2 years ago Error: Cannot find module '@comunica/query-sparql' appears because you didn't install dependencies after pulling the latest update. You can run npm install --omit=dev to solve that issue.
sqlMessage: "Access denied for user 'root'@'localhost'" happened because mysql automatically updated a few days ago and the authentication plugin was changed. You can solve that error by running : mysql -u root -e "update mysql.user set plugin = 'mysql_native_password' where User='root';flush privileges;" && systemctl restart otnode.service
Issue description
Unable to start node because of : Error occurred while starting new version, error message: Error: Cannot find module '@comunica/query-sparql'
Expected behavior
Node starting without error.
Actual behavior
Node is not starting
Steps to reproduce the problem
Specifications
Contact details
Error logs
May 05 13:15:30 vps-169bb237 node[3821]: [2022-05-05 13:15:27] USERLVL: level-change May 05 13:15:30 vps-169bb237 node[3821]: [2022-05-05 13:15:27] INFO: ██████╗ ████████╗███╗ ██╗ ██████╗ ██████╗ ███████╗ May 05 13:15:30 vps-169bb237 node[3821]: [2022-05-05 13:15:27] INFO: ██╔═══██╗╚══██╔══╝████╗ ██║██╔═══██╗██╔══██╗██╔════╝ May 05 13:15:30 vps-169bb237 node[3821]: [2022-05-05 13:15:27] INFO: ██║ ██║ ██║ ██╔██╗ ██║██║ ██║██║ ██║█████╗ May 05 13:15:30 vps-169bb237 node[3821]: [2022-05-05 13:15:27] INFO: ██║ ██║ ██║ ██║╚██╗██║██║ ██║██║ ██║██╔══╝ May 05 13:15:30 vps-169bb237 node[3821]: [2022-05-05 13:15:27] INFO: ╚██████╔╝ ██║ ██║ ╚████║╚██████╔╝██████╔╝███████╗ May 05 13:15:30 vps-169bb237 node[3821]: [2022-05-05 13:15:27] INFO: ╚═════╝ ╚═╝ ╚═╝ ╚═══╝ ╚═════╝ ╚═════╝ ╚══════╝ May 05 13:15:30 vps-169bb237 node[3821]: [2022-05-05 13:15:27] INFO: ====================================================== May 05 13:15:30 vps-169bb237 node[3821]: [2022-05-05 13:15:27] INFO: OriginTrail Node v6.0.0-beta.1.36 May 05 13:15:30 vps-169bb237 node[3821]: [2022-05-05 13:15:27] INFO: ====================================================== May 05 13:15:30 vps-169bb237 node[3821]: [2022-05-05 13:15:27] INFO: Node is running in testnet environment May 05 13:15:30 vps-169bb237 systemd[1]: otnode.service: Main process exited, code=exited, status=1/FAILURE May 05 13:15:30 vps-169bb237 systemd[1]: otnode.service: Failed with result 'exit-code'. May 05 13:15:30 vps-169bb237 systemd[1]: otnode.service: Scheduled restart job, restart counter is at 81. May 05 13:15:30 vps-169bb237 systemd[1]: Stopped OriginTrail V6 Stage 1 Beta Node. May 05 13:15:30 vps-169bb237 systemd[1]: Started OriginTrail V6 Stage 1 Beta Node. May 05 13:15:31 vps-169bb237 node[3833]: Error occurred while starting new version, error message: Error: Cannot find module '@comunica/query-sparql' May 05 13:15:31 vps-169bb237 node[3833]: Require stack: May 05 13:15:31 vps-169bb237 node[3833]: - /root/ot-node/external/sparqlquery-service.js May 05 13:15:31 vps-169bb237 node[3833]: - /root/ot-node/external/graphdb-service.js May 05 13:15:31 vps-169bb237 node[3833]: - /root/ot-node/modules/service/data-service.js May 05 13:15:31 vps-169bb237 node[3833]: - /root/ot-node/node_modules/awilix/lib/container.js May 05 13:15:31 vps-169bb237 node[3833]: - /root/ot-node/node_modules/awilix/lib/awilix.js May 05 13:15:31 vps-169bb237 node[3833]: - /root/ot-node/modules/service/dependency-injection.js May 05 13:15:31 vps-169bb237 node[3833]: - /root/ot-node/ot-node.js May 05 13:15:31 vps-169bb237 node[3833]: - /root/ot-node/index.js. Error: Cannot find module '@comunica/query-sparql' May 05 13:15:31 vps-169bb237 node[3833]: Require stack: May 05 13:15:31 vps-169bb237 node[3833]: - /root/ot-node/external/sparqlquery-service.js May 05 13:15:31 vps-169bb237 node[3833]: - /root/ot-node/external/graphdb-service.js May 05 13:15:31 vps-169bb237 node[3833]: - /root/ot-node/modules/service/data-service.js May 05 13:15:31 vps-169bb237 node[3833]: - /root/ot-node/node_modules/awilix/lib/container.js May 05 13:15:31 vps-169bb237 node[3833]: - /root/ot-node/node_modules/awilix/lib/awilix.js May 05 13:15:31 vps-169bb237 node[3833]: - /root/ot-node/modules/service/dependency-injection.js May 05 13:15:31 vps-169bb237 node[3833]: - /root/ot-node/ot-node.js May 05 13:15:31 vps-169bb237 node[3833]: - /root/ot-node/index.js May 05 13:15:31 vps-169bb237 node[3833]: at Function.Module._resolveFilename (node:internal/modules/cjs/loader:933:15) May 05 13:15:31 vps-169bb237 node[3833]: at Function.Module._load (node:internal/modules/cjs/loader:778:27) May 05 13:15:31 vps-169bb237 node[3833]: at Module.require (node:internal/modules/cjs/loader:1005:19) May 05 13:15:31 vps-169bb237 node[3833]: at require (node:internal/modules/cjs/helpers:102:18) May 05 13:15:31 vps-169bb237 node[3833]: at Object. (/root/ot-node/external/sparqlquery-service.js:1:16)
May 05 13:15:31 vps-169bb237 node[3833]: at Module._compile (node:internal/modules/cjs/loader:1105:14)
May 05 13:15:31 vps-169bb237 node[3833]: at Object.Module._extensions..js (node:internal/modules/cjs/loader:1159:10)
May 05 13:15:31 vps-169bb237 node[3833]: at Module.load (node:internal/modules/cjs/loader:981:32)
May 05 13:15:31 vps-169bb237 node[3833]: at Function.Module._load (node:internal/modules/cjs/loader:822:12)
May 05 13:15:31 vps-169bb237 node[3833]: at Module.require (node:internal/modules/cjs/loader:1005:19)
May 05 13:15:31 vps-169bb237 node[3833]: at require (node:internal/modules/cjs/helpers:102:18)
May 05 13:15:31 vps-169bb237 node[3833]: at Object. (/root/ot-node/external/graphdb-service.js:6:28)
May 05 13:15:31 vps-169bb237 node[3833]: at Module._compile (node:internal/modules/cjs/loader:1105:14)
May 05 13:15:31 vps-169bb237 node[3833]: at Object.Module._extensions..js (node:internal/modules/cjs/loader:1159:10)
May 05 13:15:31 vps-169bb237 node[3833]: at Module.load (node:internal/modules/cjs/loader:981:32)
May 05 13:15:31 vps-169bb237 node[3833]: at Function.Module._load (node:internal/modules/cjs/loader:822:12)
May 05 13:15:31 vps-169bb237 node[3833]: Starting back old version of OT-Node.
May 05 13:15:31 vps-169bb237 node[3833]: Something went really wrong! OT-node shutting down... Error: Access denied for user 'root'@'localhost'
May 05 13:15:31 vps-169bb237 node[3833]: at Packet.asError (/root/ot-node/node_modules/mysql2/lib/packets/packet.js:728:17)
May 05 13:15:31 vps-169bb237 node[3833]: at ClientHandshake.execute (/root/ot-node/node_modules/mysql2/lib/commands/command.js:29:26)
May 05 13:15:31 vps-169bb237 node[3833]: at Connection.handlePacket (/root/ot-node/node_modules/mysql2/lib/connection.js:456:32)
May 05 13:15:31 vps-169bb237 node[3833]: at PacketParser.onPacket (/root/ot-node/node_modules/mysql2/lib/connection.js:85:12)
May 05 13:15:31 vps-169bb237 node[3833]: at PacketParser.executeStart (/root/ot-node/node_modules/mysql2/lib/packet_parser.js:75:16)
May 05 13:15:31 vps-169bb237 node[3833]: at Socket. (/root/ot-node/node_modules/mysql2/lib/connection.js:92:25)
May 05 13:15:31 vps-169bb237 node[3833]: at Socket.emit (node:events:527:28)
May 05 13:15:31 vps-169bb237 node[3833]: at addChunk (node:internal/streams/readable:315:12)
May 05 13:15:31 vps-169bb237 node[3833]: at readableAddChunk (node:internal/streams/readable:289:9)
May 05 13:15:31 vps-169bb237 node[3833]: at Socket.Readable.push (node:internal/streams/readable:228:10)
May 05 13:15:31 vps-169bb237 node[3833]: at TCP.onStreamRead (node:internal/stream_base_commons:190:23) {
May 05 13:15:31 vps-169bb237 node[3833]: code: 'ER_ACCESS_DENIED_NO_PASSWORD_ERROR',
May 05 13:15:31 vps-169bb237 node[3833]: errno: 1698,
May 05 13:15:31 vps-169bb237 node[3833]: sqlState: '28000',
May 05 13:15:31 vps-169bb237 node[3833]: sqlMessage: "Access denied for user 'root'@'localhost'",
May 05 13:15:31 vps-169bb237 node[3833]: sql: undefined
May 05 13:15:31 vps-169bb237 node[3833]: }
Disclaimer
Please be aware that the issue reported on a public repository allows everyone to see your node logs, node details, and contact details. If you have any sensitive information, feel free to share it by sending an email to tech@origin-trail.com.