1-4) 운영 DB 연결 테스트 에서 rds 연결에러
687
投稿した質問数 5
$ npm run start
> saju-backend-nodejs@1.0.0 start
> cross-env NODE_ENV=prod PORT=3000 node server.js
3000 번 포트에서 대기중
ConnectionRefusedError [SequelizeConnectionRefusedError]: connect ECONNREFUSED 127.0.0.1:3306
at ConnectionManager.connect (C:\Users\User\Desktop\saju\saju-backend-nodejs-master\saju-backend-nodejs-master\node_modules\sequelize\lib\dialects\mysql\connection-manager.js:92:17)
at processTicksAndRejections (node:internal/process/task_queues:96:5)
at async ConnectionManager._connect (C:\Users\User\Desktop\saju\saju-backend-nodejs-master\saju-backend-nodejs-master\node_modules\sequelize\lib\dialects\abstract\connection-manager.js:222:24)
at async C:\Users\User\Desktop\saju\saju-backend-nodejs-master\saju-backend-nodejs-master\node_modules\sequelize\lib\dialects\abstract\connection-manager.js:174:32
at async ConnectionManager.getConnection (C:\Users\User\Desktop\saju\saju-backend-nodejs-master\saju-backend-nodejs-master\node_modules\sequelize\lib\dialects\abstract\connection-manager.js:197:7)
at async C:\Users\User\Desktop\saju\saju-backend-nodejs-master\saju-backend-nodejs-master\node_modules\sequelize\lib\sequelize.js:305:26
at async MySQLQueryInterface.tableExists (C:\Users\User\Desktop\saju\saju-backend-nodejs-master\saju-backend-nodejs-master\node_modules\sequelize\lib\dialects\abstract\query-interface.js:102:17)
at async Function.sync (C:\Users\User\Desktop\saju\saju-backend-nodejs-master\saju-backend-nodejs-master\node_modules\sequelize\lib\model.js:939:21)
at async Sequelize.sync (C:\Users\User\Desktop\saju\saju-backend-nodejs-master\saju-backend-nodejs-master\node_modules\sequelize\lib\sequelize.js:377:9) {
parent: Error: connect ECONNREFUSED 127.0.0.1:3306
at TCPConnectWrap.afterConnect [as oncomplete] (node:net:1161: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:1161:16) {
errno: -4078,
code: 'ECONNREFUSED',
syscall: 'connect',
address: '127.0.0.1',
port: 3306,
fatal: true
}
}
C:\Users\User\Desktop\saju\saju-backend-nodejs-master\saju-backend-nodejs-master\server.js:29
throw new Error("Mysql 연결 에러!");
^
Error: Mysql 연결 에러!
at C:\Users\User\Desktop\saju\saju-backend-nodejs-master\saju-backend-nodejs-master\server.js:29:13
at processTicksAndRejections (node:internal/process/task_queues:96:5)
npm run start 하면 에러가 나요
컴퓨터를 껐다가 켜도 에러가 납니다..
코드는 아래와 같은데 틀린 부분이 있을까요?
JWT_SECRET= test2022
DEV_DB_HOST= saju-db-prod.c5d7ias6lj0q.ap-northeast-2.rds.amazonaws.com
DEV_DB_DATABASE= saju-db-prod
DEV_DB_USERNAME= admin
DEV_DB_PASSWORD= liUvR09EgxX5xgPU9ilE
DEV_DB_PORT= 3309
TEST_DB_HOST=
TEST_DB_DATABASE=
TEST_DB_USERNAME=
TEST_DB_PASSWORD=
PROD_DB_HOST=
PROD_DB_DATABASE=
PROD_DB_USERNAME=
PROD_DB_PASSWORD=
PROD_DB_WRITER_HOST=
PROD_DB_READER_HOST=
SLACK_KEY=
回答 1
aws build 할때
0
300
1
frontend 배포 보안
0
541
3
frontend code pipeline
0
275
1
Front CloudFront
0
271
2
s3 배포
0
378
2
대상 그룹 생성
0
197
1
front end 배포
0
240
1
Backend 로드밸런싱
0
439
2
Frontend 로드밸런싱
0
333
2
프론트엔드빌드
0
235
2
RDS 셋팅
0
244
2
rds 스케일업
0
310
1
스케일아웃, 스케일 인
0
354
3
운영 DB 연결 테스트 (npm run start) 에러
0
235
1
ecs 에서 아래와 같은 에러가 발생합니다.
0
390
1
Health Check 시간
1
415
1
Aurora 대신 DynamoDB를 사용해도 되는지요?
0
345
1
AWS riuter 53
0
276
1
(3) 백엔드 production 버전으로 실행 "npm run start" 실행 시 에러 메제시
0
560
3
npm install , npm run serve 실행시 에러메세지
0
3195
1
3-3) 대상 그룹 생성 관련 문의
0
405
1
3-6 ecs 클러스터 생성 시
0
404
1
서비스 생성시 시크릿메니저 접근 오류
0
847
2
서버리스 람다
0
267
1

