search

ShankyTiwari / Realtime-Private-Chat-using-AngularJs-Nodejs-and-Mysql

:clipboard: A real time Private Chat application using AngularJs, Nodejs and Mysql
http://www.codershood.info/2015/12/10/real-time-chatting-app-using-nodejs-mysql-angularjs-and-socket-io-part-1/
19 stars 19 forks source link

Unable to register or log in into the chat system #1

Closed Iffah07 closed 6 years ago

Iffah07 commented 6 years ago

Shows unsuccessful to log in

ShankyTiwari commented 6 years ago

Hi there, Can you share some more information? Like if you are getting any error in Browser console or in Nodejs CMD console?

Iffah07 commented 6 years ago

Hi this is what i got.

i tried to register with "example" as username and password and this is what the console showed

(node:13912) UnhandledPromiseRejectionWarning: Error: connect ECONNREFUSED 127.0.0.1:3306 at Object._errnoException (util.js:1022:11) at _exceptionWithHostPort (util.js:1044:20) at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1198:14)

at Protocol._enqueue (C:\Users\User\Desktop\Realtime-Private-Chat-using-AngularJs-Nodejs-and-Mysql-master\node_modules\mysql\lib\protocol\Protocol.js:145:48)
at Protocol.handshake (C:\Users\User\Desktop\Realtime-Private-Chat-using-AngularJs-Nodejs-and-Mysql-master\node_modules\mysql\lib\protocol\Protocol.js:52:23)
at PoolConnection.connect (C:\Users\User\Desktop\Realtime-Private-Chat-using-AngularJs-Nodejs-and-Mysql-master\node_modules\mysql\lib\Connection.js:130:18)
at Pool.getConnection (C:\Users\User\Desktop\Realtime-Private-Chat-using-AngularJs-Nodejs-and-Mysql-master\node_modules\mysql\lib\Pool.js:48:16)
at Pool.query (C:\Users\User\Desktop\Realtime-Private-Chat-using-AngularJs-Nodejs-and-Mysql-master\node_modules\mysql\lib\Pool.js:202:8)
at Promise (C:\Users\User\Desktop\Realtime-Private-Chat-using-AngularJs-Nodejs-and-Mysql-master\utils\db.js:26:20)
at new Promise (<anonymous>)
at Db.query (C:\Users\User\Desktop\Realtime-Private-Chat-using-AngularJs-Nodejs-and-Mysql-master\utils\db.js:25:10)
at Helper.userNameCheck (C:\Users\User\Desktop\Realtime-Private-Chat-using-AngularJs-Nodejs-and-Mysql-master\utils\helper.js:16:24)
at app.post (C:\Users\User\Desktop\Realtime-Private-Chat-using-AngularJs-Nodejs-and-Mysql-master\utils\routes.js:26:31)

(node:13912) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). (rejection id: 1) (node:13912) [DEP0018] DeprecationWarning: Unhandled promise rejections are deprecated. In the future, promise rejections that are not handled will terminate the Node.js process with a non-zero exit code.{ Error: connect ECONNREFUSED 127.0.0.1:3306 at Object._errnoException (util.js:1022:11) at _exceptionWithHostPort (util.js:1044:20) at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1198:14)

at Protocol._enqueue (C:\Users\User\Desktop\Realtime-Private-Chat-using-AngularJs-Nodejs-and-Mysql-master\node_modules\mysql\lib\protocol\Protocol.js:145:48)
at Protocol.handshake (C:\Users\User\Desktop\Realtime-Private-Chat-using-AngularJs-Nodejs-and-Mysql-master\node_modules\mysql\lib\protocol\Protocol.js:52:23)
at PoolConnection.connect (C:\Users\User\Desktop\Realtime-Private-Chat-using-AngularJs-Nodejs-and-Mysql-master\node_modules\mysql\lib\Connection.js:130:18)
at Pool.getConnection (C:\Users\User\Desktop\Realtime-Private-Chat-using-AngularJs-Nodejs-and-Mysql-master\node_modules\mysql\lib\Pool.js:48:16)
at Pool.query (C:\Users\User\Desktop\Realtime-Private-Chat-using-AngularJs-Nodejs-and-Mysql-master\node_modules\mysql\lib\Pool.js:202:8)
at Promise (C:\Users\User\Desktop\Realtime-Private-Chat-using-AngularJs-Nodejs-and-Mysql-master\utils\db.js:26:20)
at new Promise (<anonymous>)
at Db.query (C:\Users\User\Desktop\Realtime-Private-Chat-using-AngularJs-Nodejs-and-Mysql-master\utils\db.js:25:10)
at Helper.registerUser (C:\Users\User\Desktop\Realtime-Private-Chat-using-AngularJs-Nodejs-and-Mysql-master\utils\helper.js:21:25)
at app.post (C:\Users\User\Desktop\Realtime-Private-Chat-using-AngularJs-Nodejs-and-Mysql-master\utils\routes.js:56:33)

code: 'ECONNREFUSED', errno: 'ECONNREFUSED', syscall: 'connect', address: '127.0.0.1', port: 3306, fatal: true }

From: Shashank Tiwari notifications@github.com Sent: Monday, 9 July 2018 6:15:20 PM To: ShankyTiwari/Realtime-Private-Chat-using-AngularJs-Nodejs-and-Mysql Cc: IFFAH HAZIQAH BINTE AMRAN; Author Subject: Re: [ShankyTiwari/Realtime-Private-Chat-using-AngularJs-Nodejs-and-Mysql] Unable to register or log in into the chat system (#1)

Hi there, Can you share some more information? Like if you are getting any error in Browser console or in Nodejs CMD console?

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/ShankyTiwari/Realtime-Private-Chat-using-AngularJs-Nodejs-and-Mysql/issues/1#issuecomment-403430688, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AfVciDvpzr0YXtJvpDKIJLOC6YByaAosks5uEy04gaJpZM4VHG0T.

ShankyTiwari commented 6 years ago

Hey there, Please make sure your MySql server is running on 127.0.0.1:3306.