search

remonalbear / CMMS

Computerized Maintenance Management System Project
52 stars 38 forks source link

Issue While Executing the Node Server #10

Open Naveed151214 opened 3 years ago

Naveed151214 commented 3 years ago

Hello,

This project seems good, but when i setup the environment on Ubuntu and tried to execute the node server js file it's prompting a lot of errors, please see below errors and advise how to resolve these issues.

Unable to connect to the database: { SequelizeAccessDeniedError: Access denied for user 'root'@'localhost' (using password: YES) at Promise.tap.then.catch.err (/var/www/CMMS/node_modules/sequelize/lib/dialects/mysql/connection-manager.js:125:19) at tryCatcher (/var/www/CMMS/node_modules/bluebird/js/release/util.js:16:23) at Promise._settlePromiseFromHandler (/var/www/CMMS/node_modules/bluebird/js/release/promise.js:547:31) at Promise._settlePromise (/var/www/CMMS/node_modules/bluebird/js/release/promise.js:604:18) at Promise._settlePromise0 (/var/www/CMMS/node_modules/bluebird/js/release/promise.js:649:10) at Promise._settlePromises (/var/www/CMMS/node_modules/bluebird/js/release/promise.js:725:18) at _drainQueueStep (/var/www/CMMS/node_modules/bluebird/js/release/async.js:93:12) at _drainQueue (/var/www/CMMS/node_modules/bluebird/js/release/async.js:86:9) at Async._drainQueues (/var/www/CMMS/node_modules/bluebird/js/release/async.js:102:5) at Immediate.Async.drainQueues [as _onImmediate] (/var/www/CMMS/node_modules/bluebird/js/release/async.js:15:14) at runCallback (timers.js:705:18) at tryOnImmediate (timers.js:676:5) at processImmediate (timers.js:658:5) name: 'SequelizeAccessDeniedError', parent: { Error: Access denied for user 'root'@'localhost' (using password: YES) at Packet.asError (/var/www/CMMS/node_modules/mysql2/lib/packets/packet.js:712:17) at ClientHandshake.execute (/var/www/CMMS/node_modules/mysql2/lib/commands/command.js:28:26) at Connection.handlePacket (/var/www/CMMS/node_modules/mysql2/lib/connection.js:425:32) at PacketParser.Connection.packetParser.p [as onPacket] (/var/www/CMMS/node_modules/mysql2/lib/connection.js:75:12) at PacketParser.executeStart (/var/www/CMMS/node_modules/mysql2/lib/packet_parser.js:75:16) at Socket.Connection.stream.on.data (/var/www/CMMS/node_modules/mysql2/lib/connection.js:82:25) at Socket.emit (events.js:198:13) at addChunk (_stream_readable.js:288:12) at readableAddChunk (_stream_readable.js:269:11) at Socket.Readable.push (_stream_readable.js:224:10) at TCP.onStreamRead [as onread] (internal/stream_base_commons.js:94:17) code: 'ER_ACCESS_DENIED_ERROR', errno: 1045, sqlState: '28000', sqlMessage: 'Access denied for user \'root\'@\'localhost\' (using password: YES)' }, original: { Error: Access denied for user 'root'@'localhost' (using password: YES) at Packet.asError (/var/www/CMMS/node_modules/mysql2/lib/packets/packet.js:712:17) at ClientHandshake.execute (/var/www/CMMS/node_modules/mysql2/lib/commands/command.js:28:26) at Connection.handlePacket (/var/www/CMMS/node_modules/mysql2/lib/connection.js:425:32) at PacketParser.Connection.packetParser.p [as onPacket] (/var/www/CMMS/node_modules/mysql2/lib/connection.js:75:12) at PacketParser.executeStart (/var/www/CMMS/node_modules/mysql2/lib/packet_parser.js:75:16) at Socket.Connection.stream.on.data (/var/www/CMMS/node_modules/mysql2/lib/connection.js:82:25) at Socket.emit (events.js:198:13) at addChunk (_stream_readable.js:288:12) at readableAddChunk (_stream_readable.js:269:11) at Socket.Readable.push (_stream_readable.js:224:10) at TCP.onStreamRead [as onread] (internal/stream_base_commons.js:94:17) code: 'ER_ACCESS_DENIED_ERROR', errno: 1045, sqlState: '28000', sqlMessage: 'Access denied for user \'root\'@\'localhost\' (using password: YES)' } } err: { SequelizeAccessDeniedError: Access denied for user 'root'@'localhost' (using password: YES) at Promise.tap.then.catch.err (/var/www/CMMS/node_modules/sequelize/lib/dialects/mysql/connection-manager.js:125:19) at tryCatcher (/var/www/CMMS/node_modules/bluebird/js/release/util.js:16:23) at Promise._settlePromiseFromHandler (/var/www/CMMS/node_modules/bluebird/js/release/promise.js:547:31) at Promise._settlePromise (/var/www/CMMS/node_modules/bluebird/js/release/promise.js:604:18) at Promise._settlePromise0 (/var/www/CMMS/node_modules/bluebird/js/release/promise.js:649:10) at Promise._settlePromises (/var/www/CMMS/node_modules/bluebird/js/release/promise.js:725:18) at _drainQueueStep (/var/www/CMMS/node_modules/bluebird/js/release/async.js:93:12) at _drainQueue (/var/www/CMMS/node_modules/bluebird/js/release/async.js:86:9) at Async._drainQueues (/var/www/CMMS/node_modules/bluebird/js/release/async.js:102:5) at Immediate.Async.drainQueues [as _onImmediate] (/var/www/CMMS/node_modules/bluebird/js/release/async.js:15:14) at runCallback (timers.js:705:18) at tryOnImmediate (timers.js:676:5) at processImmediate (timers.js:658:5) name: 'SequelizeAccessDeniedError', parent: { Error: Access denied for user 'root'@'localhost' (using password: YES) at Packet.asError (/var/www/CMMS/node_modules/mysql2/lib/packets/packet.js:712:17) at ClientHandshake.execute (/var/www/CMMS/node_modules/mysql2/lib/commands/command.js:28:26) at Connection.handlePacket (/var/www/CMMS/node_modules/mysql2/lib/connection.js:425:32) at PacketParser.Connection.packetParser.p [as onPacket] (/var/www/CMMS/node_modules/mysql2/lib/connection.js:75:12) at PacketParser.executeStart (/var/www/CMMS/node_modules/mysql2/lib/packet_parser.js:75:16) at Socket.Connection.stream.on.data (/var/www/CMMS/node_modules/mysql2/lib/connection.js:82:25) at Socket.emit (events.js:198:13) at addChunk (_stream_readable.js:288:12) at readableAddChunk (_stream_readable.js:269:11) at Socket.Readable.push (_stream_readable.js:224:10) at TCP.onStreamRead [as onread] (internal/stream_base_commons.js:94:17) code: 'ER_ACCESS_DENIED_ERROR', errno: 1045, sqlState: '28000', sqlMessage: 'Access denied for user \'root\'@\'localhost\' (using password: YES)' }, original: { Error: Access denied for user 'root'@'localhost' (using password: YES) at Packet.asError (/var/www/CMMS/node_modules/mysql2/lib/packets/packet.js:712:17) at ClientHandshake.execute (/var/www/CMMS/node_modules/mysql2/lib/commands/command.js:28:26) at Connection.handlePacket (/var/www/CMMS/node_modules/mysql2/lib/connection.js:425:32) at PacketParser.Connection.packetParser.p [as onPacket] (/var/www/CMMS/node_modules/mysql2/lib/connection.js:75:12) at PacketParser.executeStart (/var/www/CMMS/node_modules/mysql2/lib/packet_parser.js:75:16) at Socket.Connection.stream.on.data (/var/www/CMMS/node_modules/mysql2/lib/connection.js:82:25) at Socket.emit (events.js:198:13) at addChunk (_stream_readable.js:288:12) at readableAddChunk (_stream_readable.js:269:11) at Socket.Readable.push (_stream_readable.js:224:10) at TCP.onStreamRead [as onread] (internal/stream_base_commons.js:94:17) code: 'ER_ACCESS_DENIED_ERROR', errno: 1045, sqlState: '28000', sqlMessage: 'Access denied for user \'root\'@\'localhost\' (using password: YES)' } }

Thanks, Naveed.

elhamdioui2 commented 4 months ago

Hello , For people who have issue with the exphbs , you should modify the line 53 , here is the corrected line : app.engine('handlebars',exphbs.engine({ layoutsDir: 'views/layouts/', defaultLayout: 'main-layout', partialsDir: 'views/includes/' }));