ABOUT ME

-

Today
-
Yesterday
-
Total
-
  • ConnectionRefusedError [SequelizeConnectionRefusedError]: connect ECONNREFUSED 127.0.0.1:3306 parent: Error: connect ECONNREFUSED 127.0.0.1:3306
    Error Handling/에러핸들링 2023. 7. 6. 15:54

     

    node app.js로 서버를 키려다가 다음과 같은 오류가 발생했다.

    원인은 config에 알맞은 정보를 입력해야 한다.

     

        "username": "",
        "password": "",
        "database": "",
        "host": "express-database.cglnarldwxvs.ap-northeast-2.rds.amazonaws.com",
        "dialect": "mysql"    

     

     

    ConnectionRefusedError [SequelizeConnectionRefusedError]: connect ECONNREFUSED 127.0.0.1:3306
        at ConnectionManager.connect (C:\Users\admin\Desktop\코딩\NODE\4th Week\Sequelize-Relations (Lv.4)\node_modules\sequelize\lib\dialects\mysql\connection-manager.js:92:17)
        at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
        at async ConnectionManager._connect (C:\Users\admin\Desktop\코딩\NODE\4th Week\Sequelize-Relations (Lv.4)\node_modules\sequelize\lib\dialects\abstract\connection-manager.js:222:24)
        at async C:\Users\admin\Desktop\코딩\NODE\4th Week\Sequelize-Relations (Lv.4)\node_modules\sequelize\lib\dialects\abstract\connection-manager.js:174:32
        at async ConnectionManager.getConnection (C:\Users\admin\Desktop\코딩\NODE\4th Week\Sequelize-Relations (Lv.4)\node_modules\sequelize\lib\dialects\abstract\connection-manager.js:197:7)
        at async C:\Users\admin\Desktop\코딩\NODE\4th Week\Sequelize-Relations (Lv.4)\node_modules\sequelize\lib\sequelize.js:305:26
        at async MySQLQueryInterface.select (C:\Users\admin\Desktop\코딩\NODE\4th Week\Sequelize-Relations (Lv.4)\node_modules\sequelize\lib\dialects\abstract\query-interface.js:407:12)
        at async Posts.findAll (C:\Users\admin\Desktop\코딩\NODE\4th Week\Sequelize-Relations (Lv.4)\node_modules\sequelize\lib\model.js:1140:21)
        at async Posts.findOne (C:\Users\admin\Desktop\코딩\NODE\4th Week\Sequelize-Relations (Lv.4)\node_modules\sequelize\lib\model.js:1240:12)
        at async C:\Users\admin\Desktop\코딩\NODE\4th Week\Sequelize-Relations (Lv.4)\routes\posts.js:53:18 {
      parent: Error: connect ECONNREFUSED 127.0.0.1:3306
          at TCPConnectWrap.afterConnect [as oncomplete] (node:net:1494:16) {
        errno: -4078,
        code: 'ECONNREFUSED',
        syscall: 'connect',
        address: '127.0.0.1',
        port: 3306,
        fatal: true
      },
      original: Error: connect ECONNREFUSED 127.0.0.1:3306
          at TCPConnectWrap.afterConnect [as oncomplete] (node:net:1494:16) {
        errno: -4078,
        code: 'ECONNREFUSED',
        syscall: 'connect',
        address: '127.0.0.1',
        port: 3306,
        fatal: true
      }
    }
    ConnectionRefusedError [SequelizeConnectionRefusedError]: connect ECONNREFUSED 127.0.0.1:3306
        at ConnectionManager.connect (C:\Users\admin\Desktop\코딩\NODE\4th Week\Sequelize-Relations (Lv.4)\node_modules\sequelize\lib\dialects\mysql\connection-manager.js:92:17)
        at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
        at async ConnectionManager._connect (C:\Users\admin\Desktop\코딩\NODE\4th Week\Sequelize-Relations (Lv.4)\node_modules\sequelize\lib\dialects\abstract\connection-manager.js:222:24)
        at async C:\Users\admin\Desktop\코딩\NODE\4th Week\Sequelize-Relations (Lv.4)\node_modules\sequelize\lib\dialects\abstract\connection-manager.js:174:32
        at async ConnectionManager.getConnection (C:\Users\admin\Desktop\코딩\NODE\4th Week\Sequelize-Relations (Lv.4)\node_modules\sequelize\lib\dialects\abstract\connection-manager.js:197:7)
        at async C:\Users\admin\Desktop\코딩\NODE\4th Week\Sequelize-Relations (Lv.4)\node_modules\sequelize\lib\sequelize.js:305:26
        at async MySQLQueryInterface.select (C:\Users\admin\Desktop\코딩\NODE\4th Week\Sequelize-Relations (Lv.4)\node_modules\sequelize\lib\dialects\abstract\query-interface.js:407:12)
        at async Users.findAll (C:\Users\admin\Desktop\코딩\NODE\4th Week\Sequelize-Relations (Lv.4)\node_modules\sequelize\lib\model.js:1140:21)
        at async Users.findOne (C:\Users\admin\Desktop\코딩\NODE\4th Week\Sequelize-Relations (Lv.4)\node_modules\sequelize\lib\model.js:1240:12)
        at async module.exports (C:\Users\admin\Desktop\코딩\NODE\4th Week\Sequelize-Relations (Lv.4)\middlewares\auth-middleware.js:15:18) {
      parent: Error: connect ECONNREFUSED 127.0.0.1:3306
          at TCPConnectWrap.afterConnect [as oncomplete] (node:net:1494:16) {
        errno: -4078,
        code: 'ECONNREFUSED',
        syscall: 'connect',
        address: '127.0.0.1',
        port: 3306,
        fatal: true
      },
      original: Error: connect ECONNREFUSED 127.0.0.1:3306
          at TCPConnectWrap.afterConnect [as oncomplete] (node:net:1494:16) {
        errno: -4078,
        code: 'ECONNREFUSED',
        syscall: 'connect',
        address: '127.0.0.1',
        code: 'ECONNREFUSED',
        syscall: 'connect',
        address: '127.0.0.1',
        port: 3306,
        fatal: true
      }
    }

     

     

    댓글

Designed by Tistory.