<aside> ⭐ 목차

</aside>

FRONTEND

• Naver Clova OCR

• Visual Studio Code

  $ cd frontend
  $ npm install pnpm
  $ pnpm install
  $ pnpm run dev
  

BACKEND

1. IntelliJ 설치

   JDK 17

2. HeidiSQL 설치

   

3. MariaDB 설치

   11.1.2 버전

   MariaDB / HeidiSQL / MariaDB에 연결하는 방법

4. Redis 설치

   https://github.com/microsoftarchive/redis/releases

   Redis-x64-3.0.504.msi

   Redis Server Test
   
   1. redis-server.exe 실행
   2. redis-cli.exe 실행
   

   

5. ⭐ 데이터베이스 신규 USER 생성

   (1) MariaDB CMD 접속

   (2) mysql -u root -p 입력 → root의 비밀번호 입력

   (3) use mysql 입력해 mysql db 접속

   (4) (예시) create user 'moic'@'%' identified by 'dlagPwl123!'; 입력해 USER 추가

   (5) (예시) grant all privileges on [DB명].* to 'moic'@'%'; 입력해 DB 접근 권한 권한 부여

   create user '[userid]'@'[host]' identified by '[password]';
   		userid : 사용하고자 하는 계정의 id
   		host : db에 접근하기 위해 이 계정을 사용할 수 있는 호스트 정보
   			=> 만약 내 로컬에서 사용하고 싶으면 @'localhost"
   			=> 모든 호스트에서 접근하려면 @'%'
   		password : 비밀번호
   
   create user 'moic'@'%' identified by 'dlagPwl123!';
   # sketchme 데이터베이스에 대한 모든 권한을 user에게 부여한다.
   grant all privileges on [DB명].* to 'moic'@'%';
   
   **현재 존재하는 계정 확인하기**
   show databases; //CMD에서 내 DB 스키마 확인하기
   use mysql; //해당 DB로 접속하기
   select host, user, password from user; //존재하는 USER 확인하기
   
   sudo docker exec -it moicDB /bin/bash //EC2의 DB 접근 시 명령어
   

   5장 ACCOUNT , 권한 관리 (4) 권한 종류

   mariaDB,MYsql 사용자 생성, 사용자 권한주기 및 확인

데이터베이스 USER, PASSWORD 정리

**(현재 - 개발환경)**
MariaDB1 (3306)
dbname : moicDB
username : moic
password : dlagPwl123!

MariaDB2 (4406)
dbname : moicSecurityDB
username : moic
password : rlatjdwo123!

Redis (6379)
dbname : moicMainRedis
user : 
password : rlaxogus123!

**서버에 맞는 application.properties 설정 후**
**목적 : 여태까지 gitlab에 push되어 보이는 application properties 정보 변경

(보안 처리 후 - 서버환경)**
MariaDB1 (3306)
dbname : moicDB
username : moic
password : rlatnghks456!

Redis (8421)
host : mainRedis
port : 8421
password : qogmlwls456!

Redis (1248)
host : securityRedis
port : 1248
password : dldmlcks456!

application.properties

⭐ git ignore 되었으므로 반드시 복사해서 사용하세요~!

EC2

server.port = 9999
server.servlet.context-path=/api/v1
#mainDBConfig
spring.datasource.driver-class-name=org.mariadb.jdbc.Driver
spring.datasource.url=jdbc:mariadb://13.125.18.157:3306/moicDB
spring.datasource.username=moic
spring.datasource.password=dlagPwl123!
spring.jpa.hibernate.ddl-auto=update
spring.hibernate.dialect=org.hibernate.dialect.MariaDBDialect
spring.jpa.properties.hibernate.show_sql=true

#RedisConfig
spring.redis1.host=13.125.18.157
spring.redis1.port=8421
spring.redis1.password=test1

spring.redis2.host=13.125.18.157
spring.redis2.port=8001
spring.redis2.password=test2

spring.redis3.host=13.125.18.157
spring.redis3.port=8888
spring.redis3.password=Forauto208

# JPA SQL Logging
logging.level.org.hibernate.SQL=DEBUG
logging.level.org.hibernate.type.descriptor.sql.BasicBinder=TRACE

# JWT
secret-key= 6rmA7ISx7J6s6rmA7IiY7ZmY6rmA7YOc7ZiE67Cw7Z2s7KeE7J207J2Y7LCs7J6E7Zic7KeA
issuer= moic

autocomplete-key=autocomplete

#multipart max size
spring.servlet.multipart.max-file-size=20MB
spring.servlet.multipart.max-request-size=20MB

#S3
cloud.aws.credentials.access-key=AKIATGDCYERYFXGIMUJZ
cloud.aws.credentials.secret-key=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
cloud.aws.stack.auto=false

cloud.aws.region.static=ap-northeast-2
cloud.aws.s3.bucket=moicbucket

# OCR
OCR_APIURL=https://vpuht6ua4u.apigw.ntruss.com/custom/v1/24739/8f4f47dae107cdc50e77e207d0d05946b52ab6d80c1881e94dd49d599b68f201/general
OCR_SECRET=bHFuWVdnSnRhc09UU3lVblRXS3pJSHlEWFNHT1hBTGM=

#Google
spring.security.oauth2.client.registration.google.client-name=google
spring.security.oauth2.client.registration.google.client-id=443214369870-5ms8v2q2piaj2ohkbldqs0fm7kb4mvs2.apps.googleusercontent.com
spring.security.oauth2.client.registration.google.client-secret=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
spring.security.oauth2.client.registration.google.scope=profile,email
spring.security.oauth2.client.registration.google.redirect_uri=http://moic.site/api/v1/login/oauth2/code/google

#Kakao
spring.security.oauth2.client.registration.kakao.client-name=kakao
spring.security.oauth2.client.registration.kakao.client-id=bd3d41c87a3a4961dad8fa2d1a8d628c
spring.security.oauth2.client.registration.kakao.client-secret=SOZjcVCMT54HEfYGjvLC09Y93mnsIrQu
spring.security.oauth2.client.registration.kakao.scope=profile_nickname, account_email
spring.security.oauth2.client.registration.kakao.redirect-uri=http://moic.site/api/v1/login/oauth2/code/kakao
spring.security.oauth2.client.registration.kakao.authorization-grant-type=authorization_code
spring.security.oauth2.client.registration.kakao.client-authentication-method=client_secret_post
spring.security.oauth2.client.provider.kakao.authorization-uri=https://kauth.kakao.com/oauth/authorize
spring.security.oauth2.client.provider.kakao.token-uri=https://kauth.kakao.com/oauth/token
spring.security.oauth2.client.provider.kakao.user-info-uri=https://kapi.kakao.com/v2/user/me
spring.security.oauth2.client.provider.kakao.user-name-attribute=id

#Mail
spring.mail.host=smtp.gmail.com
spring.mail.port=587
spring.mail.username=moicssafy
spring.mail.password=rbbimumllfvnffzq
spring.mail.properties.mail.smtp.auth=true
spring.mail.properties.mail.smtp.timeout=5000
spring.mail.properties.mail.smtp.starttls.enable=true

#ChatGpt
CHAT_APIKEY=Bearer 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
CHAT_APIURL=https://api.openai.com/v1/chat/completions
CHAT_MODEL=gpt-4

Local환경에서

server.port = 9999
server.servlet.context-path=/api/v1
#mainDBConfig
spring.datasource.driver-class-name=org.mariadb.jdbc.Driver
spring.datasource.url=jdbc:mariadb://13.125.18.157:3306/moicDB
spring.datasource.username=moic
spring.datasource.password=dlagPwl123!
spring.jpa.hibernate.ddl-auto=update
spring.hibernate.dialect=org.hibernate.dialect.MariaDBDialect
spring.jpa.properties.hibernate.show_sql=true

#RedisConfig
spring.redis1.host=13.125.18.157
spring.redis1.port=8421
spring.redis1.password=test1

spring.redis2.host=13.125.18.157
spring.redis2.port=8001
spring.redis2.password=test2

spring.redis3.host=13.125.18.157
spring.redis3.port=8888
spring.redis3.password=Forauto208

# JPA SQL Logging
logging.level.org.hibernate.SQL=DEBUG
logging.level.org.hibernate.type.descriptor.sql.BasicBinder=TRACE

# JWT
secret-key= 6rmA7ISx7J6s6rmA7IiY7ZmY6rmA7YOc7ZiE67Cw7Z2s7KeE7J207J2Y7LCs7J6E7Zic7KeA
issuer= moic

autocomplete-key=autocomplete

#multipart max size
spring.servlet.multipart.max-file-size=20MB
spring.servlet.multipart.max-request-size=20MB

#S3
cloud.aws.credentials.access-key=AKIATGDCYERYFXGIMUJZ
cloud.aws.credentials.secret-key=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
cloud.aws.stack.auto=false

cloud.aws.region.static=ap-northeast-2
cloud.aws.s3.bucket=moicbucket

# OCR
OCR_APIURL=https://vpuht6ua4u.apigw.ntruss.com/custom/v1/24739/8f4f47dae107cdc50e77e207d0d05946b52ab6d80c1881e94dd49d599b68f201/general
OCR_SECRET=bHFuWVdnSnRhc09UU3lVblRXS3pJSHlEWFNHT1hBTGM=

#Google
spring.security.oauth2.client.registration.google.client-name=google
spring.security.oauth2.client.registration.google.client-id=443214369870-5ms8v2q2piaj2ohkbldqs0fm7kb4mvs2.apps.googleusercontent.com
spring.security.oauth2.client.registration.google.client-secret=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
spring.security.oauth2.client.registration.google.scope=profile,email
spring.security.oauth2.client.registration.google.redirect_uri=http://localhost:9999/api/v1/login/oauth2/code/google

#Kakao
spring.security.oauth2.client.registration.kakao.client-name=kakao
spring.security.oauth2.client.registration.kakao.client-id=bd3d41c87a3a4961dad8fa2d1a8d628c
spring.security.oauth2.client.registration.kakao.client-secret=SOZjcVCMT54HEfYGjvLC09Y93mnsIrQu
spring.security.oauth2.client.registration.kakao.scope=profile_nickname, account_email
spring.security.oauth2.client.registration.kakao.redirect-uri=http://localhost:9999/api/v1/login/oauth2/code/kakao
spring.security.oauth2.client.registration.kakao.authorization-grant-type=authorization_code
spring.security.oauth2.client.registration.kakao.client-authentication-method=client_secret_post
spring.security.oauth2.client.provider.kakao.authorization-uri=https://kauth.kakao.com/oauth/authorize
spring.security.oauth2.client.provider.kakao.token-uri=https://kauth.kakao.com/oauth/token
spring.security.oauth2.client.provider.kakao.user-info-uri=https://kapi.kakao.com/v2/user/me
spring.security.oauth2.client.provider.kakao.user-name-attribute=id

#Mail
spring.mail.host=smtp.gmail.com
spring.mail.port=587
spring.mail.username=moicssafy
spring.mail.password=rbbimumllfvnffzq
spring.mail.properties.mail.smtp.auth=true
spring.mail.properties.mail.smtp.timeout=5000
spring.mail.properties.mail.smtp.starttls.enable=true

#ChatGpt
CHAT_APIKEY=Bearer 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
CHAT_APIURL=https://api.openai.com/v1/chat/completions
CHAT_MODEL=gpt-4

• Moic Gmail 계정
  • moicssafy
  • 모익123!