[Spring] Docker run 오류 관련 질문

[yknxh]

Docker run을 하면 아래와 같이 com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure 에러가 뜨는데
어떻게 해결해야 할 지 모르겠습니다...ㅠㅠ
인터넷에 나와있는 모든 방법은 진짜 다 해봤는데도 차도가 없었습니다....
윈도우 문제인 줄 알고 우분투에서도 시도해봤으나 동일한 에러가 뜹니다..ㅠ

. ____ _ __ _ _
/\ / ' __ _ () __ __ _ \ \ \
( ( )__ | '_ | '| | ' / ` | \ \ \
\/ )| |)| | | | | || (| | ) ) ) )
' || .__|| ||| |_, | / / / /
=========||==============|/=////
:: Spring Boot :: (v3.1.2)

2023-11-30T04:49:02.359Z INFO 1 --- [ main] c.w.s.spring2023.SeminarAppli
cationKt : Starting SeminarApplicationKt v1.1.0-SNAPSHOT using Java 17.0.2 with P
ID 1 (/app.jar started by root in /)
2023-11-30T04:49:02.371Z INFO 1 --- [ main] c.w.s.spring2023.SeminarAppli
cationKt : The following 1 profile is active: "prod"
2023-11-30T04:49:05.175Z INFO 1 --- [ main] .s.d.r.c.RepositoryConfigurat
ionDelegate : Bootstrapping Spring Data JPA repositories in DEFAULT mode.
2023-11-30T04:49:05.429Z INFO 1 --- [ main] .s.d.r.c.RepositoryConfigurat
ionDelegate : Finished Spring Data repository scanning in 230 ms. Found 10 JPA repos
itory interfaces.
2023-11-30T04:49:07.281Z INFO 1 --- [ main] o.s.b.w.embedded.tomcat.Tomca
tWebServer : Tomcat initialized with port(s): 8080 (http)
2023-11-30T04:49:07.310Z INFO 1 --- [ main] o.apache.catalina.core.Standa
rdService : Starting service [Tomcat]
2023-11-30T04:49:07.311Z INFO 1 --- [ main] o.apache.catalina.core.Standa
rdEngine : Starting Servlet engine: [Apache Tomcat/10.1.11]
2023-11-30T04:49:07.631Z INFO 1 --- [ main] o.a.c.c.C.[Tomcat].[localhost
].[/] : Initializing Spring embedded WebApplicationContext
2023-11-30T04:49:07.656Z INFO 1 --- [ main] w.s.c.ServletWebServerApplica
tionContext : Root WebApplicationContext: initialization completed in 5019 ms
2023-11-30T04:49:08.016Z INFO 1 --- [ main] com.zaxxer.hikari.HikariDataS
ource : HikariPool-1 - Starting...
2023-11-30T04:49:09.258Z ERROR 1 --- [ main] com.zaxxer.hikari.pool.Hikari
Pool : HikariPool-1 - Exception during pool initialization.

com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver h
as not received any packets from the server.
at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLEr
ror.java:175) ~[mysql-connector-j-8.0.33.jar!/:8.0.33]
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLE
xceptionsMapping.java:64) ~[mysql-connector-j-8.0.33.jar!/:8.0.33]
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:825) ~[m
ysql-connector-j-8.0.33.jar!/:8.0.33]
at com.mysql.cj.jdbc.ConnectionImpl.(ConnectionImpl.java:446) ~[mysql-
connector-j-8.0.33.jar!/:8.0.33]
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:239) ~[m
ysql-connector-j-8.0.33.jar!/:8.0.33]
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:
188) ~[mysql-connector-j-8.0.33.jar!/:8.0.33]
at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.ja
va:138) ~[HikariCP-5.0.1.jar!/:na]
at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:359) ~[Hikari
CP-5.0.1.jar!/:na]
at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201) ~[HikariC
P-5.0.1.jar!/:na]
at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:470) ~[
HikariCP-5.0.1.jar!/:na]
at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561) ~[Hi
kariCP-5.0.1.jar!/:na]
at com.zaxxer.hikari.pool.HikariPool.(HikariPool.java:100) ~[HikariCP-
5.0.1.jar!/:na]
at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:11
2) ~[HikariCP-5.0.1.jar!/:na]
at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataS
ourceUtils.java:160) ~[spring-jdbc-6.0.11.jar!/:6.0.11]
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataS
ourceUtils.java:118) ~[spring-jdbc-6.0.11.jar!/:6.0.11]
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSou
rceUtils.java:81) ~[spring-jdbc-6.0.11.jar!/:6.0.11]
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:332)
~[spring-jdbc-6.0.11.jar!/:6.0.11]
at org.springframework.boot.jdbc.EmbeddedDatabaseConnection.isEmbedded(Embed
dedDatabaseConnection.java:168) ~[spring-boot-3.1.2.jar!/:3.1.2]
at org.springframework.boot.jdbc.init.DataSourceScriptDatabaseInitializer.is
EmbeddedDatabase(DataSourceScriptDatabaseInitializer.java:67) ~[spring-boot-3.1.2.ja
r!/:3.1.2]
at org.springframework.boot.sql.init.AbstractScriptDatabaseInitializer.isEna
bled(AbstractScriptDatabaseInitializer.java:84) ~[spring-boot-3.1.2.jar!/:3.1.2]
at org.springframework.boot.sql.init.AbstractScriptDatabaseInitializer.apply
Scripts(AbstractScriptDatabaseInitializer.java:107) ~[spring-boot-3.1.2.jar!/:3.1.2]
at org.springframework.boot.sql.init.AbstractScriptDatabaseInitializer.apply
SchemaScripts(AbstractScriptDatabaseInitializer.java:98) ~[spring-boot-3.1.2.jar!/:3
.1.2]
at org.springframework.boot.sql.init.AbstractScriptDatabaseInitializer.initi
alizeDatabase(AbstractScriptDatabaseInitializer.java:76) ~[spring-boot-3.1.2.jar!/:3
.1.2]
at org.springframework.boot.sql.init.AbstractScriptDatabaseInitializer.after
PropertiesSet(AbstractScriptDatabaseInitializer.java:66) ~[spring-boot-3.1.2.jar!/:3
.1.2]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFact
ory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1817) ~[spring-beans-6
.0.11.jar!/:6.0.11]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFact
ory.initializeBean(AbstractAutowireCapableBeanFactory.java:1766) ~[spring-beans-6.0.
11.jar!/:6.0.11]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFact
ory.doCreateBean(AbstractAutowireCapableBeanFactory.java:598) ~[spring-beans-6.0.11.
jar!/:6.0.11]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFact
ory.createBean(AbstractAutowireCapableBeanFactory.java:520) ~[spring-beans-6.0.11.ja
r!/:6.0.11]
at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGe
tBean$0(AbstractBeanFactory.java:326) ~[spring-beans-6.0.11.jar!/:6.0.11]
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.ge
tSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-6.0.11.jar!/:6.0.11
]
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(A
bstractBeanFactory.java:324) ~[spring-beans-6.0.11.jar!/:6.0.11]
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(Abs
tractBeanFactory.java:200) ~[spring-beans-6.0.11.jar!/:6.0.11]
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(A
bstractBeanFactory.java:313) ~[spring-beans-6.0.11.jar!/:6.0.11]
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(Abs
tractBeanFactory.java:200) ~[spring-beans-6.0.11.jar!/:6.0.11]
at org.springframework.context.support.AbstractApplicationContext.getBean(Ab
stractApplicationContext.java:1155) ~[spring-context-6.0.11.jar!/:6.0.11]
at org.springframework.context.support.AbstractApplicationContext.finishBean
FactoryInitialization(AbstractApplicationContext.java:932) ~[spring-context-6.0.11.j
ar!/:6.0.11]
at org.springframework.context.support.AbstractApplicationContext.refresh(Ab
stractApplicationContext.java:608) ~[spring-context-6.0.11.jar!/:6.0.11]
at org.springframework.boot.web.servlet.context.ServletWebServerApplicationC
ontext.refresh(ServletWebServerApplicationContext.java:146) ~[spring-boot-3.1.2.jar!
/:3.1.2]
at org.springframework.boot.SpringApplication.refresh(SpringApplication.java
:734) ~[spring-boot-3.1.2.jar!/:3.1.2]
at org.springframework.boot.SpringApplication.refreshContext(SpringApplicati
on.java:436) ~[spring-boot-3.1.2.jar!/:3.1.2]
at org.springframework.boot.SpringApplication.run(SpringApplication.java:312
) ~[spring-boot-3.1.2.jar!/:3.1.2]
at org.springframework.boot.SpringApplication.run(SpringApplication.java:130
6) ~[spring-boot-3.1.2.jar!/:3.1.2]
at org.springframework.boot.SpringApplication.run(SpringApplication.java:129
5) ~[spring-boot-3.1.2.jar!/:3.1.2]
at com.wafflestudio.seminar.spring2023.SeminarApplicationKt.main(SeminarAppl
ication.kt:13) ~[classes!/:1.1.0-SNAPSHOT]
at com.wafflestudio.seminar.spring2023.SeminarApplicationKt.main(SeminarAppl
ication.kt) ~[classes!/:1.1.0-SNAPSHOT]
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Me
thod) ~[na:na]
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMeth
odAccessorImpl.java:77) ~[na:na]
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Delega
tingMethodAccessorImpl.java:43) ~[na:na]
at java.base/java.lang.reflect.Method.invoke(Method.java:568) ~[na:na]
at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.jav
a:49) ~[app.jar:1.1.0-SNAPSHOT]
at org.springframework.boot.loader.Launcher.launch(Launcher.java:95) ~[app.j
ar:1.1.0-SNAPSHOT]
at org.springframework.boot.loader.Launcher.launch(Launcher.java:58) ~[app.j
ar:1.1.0-SNAPSHOT]
at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:65) ~[a
pp.jar:1.1.0-SNAPSHOT]
(이하 생략)

[PFCJeong]

안녕하세요~ 2가지 방법이 있을 것 같습니다.

1. 프로필이 prod로 도커 이미지를 빌드하신 것 같습니다. jdbc:mysql://localhost:3306 요 주소로 db연결을 시도했을텐데, 도커에서 호스트의 localhost로 접속하기 위해서는 localhost를 사용하면 안됩니다. host.docker.internal를 검색해보세요.

2. 그냥 local 프로필로 도커 이미지를 빌드하는 방법도 있겠네요.

[PFCJeong]

음.. 되야 정상일텐데요. 뭔가 다른 문제가 있을 것 같습니다.

1번 과제는 prod 프로필로 로컬 MySQL에 연결해야 하지만, 2번 과제는 따로 프로필 제한을 두지 않았습니다.

[davin111]

@yknxh 로컬 mysql 설치하신 건 아마 8 이겠죠? user 는 root 에 password 는 없이 사용 중이신 건가요?

[davin111]

mysql 8 에서 default auth plugin 이 바뀌었는데, mysql_native_password을 쓰도록 user 를 생성하고 그걸 쓰면 어떨까 싶기도 하거든요. 또는 root 유저가 모든 ip 에서 접속 가능하도록 세팅이 안 되었나 싶기도 한데, 그냥 깔끔하게 이렇게 해보시죠. username 이나 password 는 적절히 바꿔서...

CREATE USER 'yknxh'@'%' IDENTIFIED WITH mysql_native_password BY 'Password!1234';
GRANT ALL PRIVILEGES ON *.* TO 'yknxh'@'%';

사실 이 유저에게 권한을 과하게 주고 있는데 과제에서 쓰는 database 이름으로 넣어서 ... ON database.* TO ... 로 하시면 됩니다.

[yknxh]

root 계정 비밀번호를 대문자, 특수문자 포함 8자리로 바꾸니 허무하게도 잘 돌아가네요..ㅎㅎㅠㅠ

다들 도와주셔서 정말 감사합니다!!!!!~~

[davin111]

아하 mysql 설치 시, password 보안 정도를 설정할 수 있는데 그거 관련 문제였나 보네요.