Javaを勉強し始めて1年ちょっとの初心者です。
Spring Tool Suite 4を使ってWebアプリを作成し、Mavenビルドでjarファイルにして
VPS上にデプロイしたのですが、Webアプリを起動すると下記エラーが発生しました。
Java
1//一部省略してます 2 3com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure 4 5The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. 6 at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174) ~[mysql-connector-java-8.0.22.jar!/:8.0.22] 7 at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64) ~[mysql-connector-java-8.0.22.jar!/:8.0.22] 8 at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:836) ~[mysql-connector-java-8.0.22.jar!/:8.0.22] 9 at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:456) ~[mysql-connector-java-8.0.22.jar!/:8.0.22] 10 at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246) ~[mysql-connector-java-8.0.22.jar!/:8.0.22] 11 at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198) ~[mysql-connector-java-8.0.22.jar!/:8.0.22] 12 at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138) ~[HikariCP-3.4.5.jar!/:na] 13 at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:358) ~[HikariCP-3.4.5.jar!/:na] 14 at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:206) ~[HikariCP-3.4.5.jar!/:na] 15 at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:477) [HikariCP-3.4.5.jar!/:na] 16 at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:560) [HikariCP-3.4.5.jar!/:na] 17 at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115) [HikariCP-3.4.5.jar!/:na] 18 at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112) [HikariCP-3.4.5.jar!/:na] 19 at org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:122) [hibernate-core-5.4.25.Final.jar!/:5.4.25.Final] 20 at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator$ConnectionProviderJdbcConnectionAccess.obtainConnection(JdbcEnvironmentInitiator.java:180) [hibernate-core-5.4.25.Final.jar!/:5.4.25.Final] 21 at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:68) [hibernate-core-5.4.25.Final.jar!/:5.4.25.Final] 22 at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:35) [hibernate-core-5.4.25.Final.jar!/:5.4.25.Final] 23 at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.initiateService(StandardServiceRegistryImpl.java:101) [hibernate-core-5.4.25.Final.jar!/:5.4.25.Final] 24 at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:263) [hibernate-core-5.4.25.Final.jar!/:5.4.25.Final] 25 at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:237) [hibernate-core-5.4.25.Final.jar!/:5.4.25.Final] 26 at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:214) [hibernate-core-5.4.25.Final.jar!/:5.4.25.Final] 27 at org.hibernate.id.factory.internal.DefaultIdentifierGeneratorFactory.injectServices(DefaultIdentifierGeneratorFactory.java:152) [hibernate-core-5.4.25.Final.jar!/:5.4.25.Final] 28 at org.hibernate.service.internal.AbstractServiceRegistryImpl.injectDependencies(AbstractServiceRegistryImpl.java:286) [hibernate-core-5.4.25.Final.jar!/:5.4.25.Final] 29 at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:243) [hibernate-core-5.4.25.Final.jar!/:5.4.25.Final] 30 at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:214) [hibernate-core-5.4.25.Final.jar!/:5.4.25.Final] 31 at org.hibernate.boot.internal.InFlightMetadataCollectorImpl.<init>(InFlightMetadataCollectorImpl.java:176) [hibernate-core-5.4.25.Final.jar!/:5.4.25.Final] 32 at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete(MetadataBuildingProcess.java:127) [hibernate-core-5.4.25.Final.jar!/:5.4.25.Final] 33 at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.metadata(EntityManagerFactoryBuilderImpl.java:1224) [hibernate-core-5.4.25.Final.jar!/:5.4.25.Final] 34 at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:1255) [hibernate-core-5.4.25.Final.jar!/:5.4.25.Final] 35 at org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.java:58) [spring-orm-5.2.12.RELEASE.jar!/:5.2.12.RELEASE] 36 at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:551) ~[spring-context-5.2.12.RELEASE.jar!/:5.2.12.RELEASE] 37 at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:141) ~[spring-boot-2.2.12.RELEASE.jar!/:2.2.12.RELEASE] 38 at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:747) ~[spring-boot-2.2.12.RELEASE.jar!/:2.2.12.RELEASE] 39 at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:405) ~[spring-boot-2.2.12.RELEASE.jar!/:2.2.12.RELEASE] 40 at org.springframework.boot.SpringApplication.run(SpringApplication.java:315) ~[spring-boot-2.2.12.RELEASE.jar!/:2.2.12.RELEASE] 41 at org.springframework.boot.SpringApplication.run(SpringApplication.java:1226) ~[spring-boot-2.2.12.RELEASE.jar!/:2.2.12.RELEASE] 42 at org.springframework.boot.SpringApplication.run(SpringApplication.java:1215) ~[spring-boot-2.2.12.RELEASE.jar!/:2.2.12.RELEASE] 43 at jp.kuroda.sampleBlog.SampleBlogApplication.main(SampleBlogApplication.java:17) ~[classes!/:0.0.1-SNAPSHOT] 44 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_312] 45 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_312] 46 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_312] 47 at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_312] 48 at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:48) ~[sampleBlog-0.0.1-SNAPSHOT.jar:0.0.1-SNAPSHOT] 49 at org.springframework.boot.loader.Launcher.launch(Launcher.java:87) ~[sampleBlog-0.0.1-SNAPSHOT.jar:0.0.1-SNAPSHOT] 50 at org.springframework.boot.loader.Launcher.launch(Launcher.java:51) ~[sampleBlog-0.0.1-SNAPSHOT.jar:0.0.1-SNAPSHOT] 51 at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:52) ~[sampleBlog-0.0.1-SNAPSHOT.jar:0.0.1-SNAPSHOT] 52Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure 53 54The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
自分のノートパソコン上で起動した時は問題なく動いたので、VPSからノートパソコン上のDBにアクセスするためにVPSに何かしら設定する、もしくはapplication.propertiesのコードを改善する必要があると思って調べたのですが、解決に至りませんでしたorz
VPS上のWebアプリからローカルPCのDBにアクセスするにはどうすれば良いでしょうか?
ご教授お願い致します。
参考にした記事
JDBC経由でMySQLに突然接続できなくなった
さくらVPSでSpringBootを動かす
開発環境
Java 8
spring boot 2.2.12
10.4.22-MariaDB - mariadb.org binary distribution
開発ツール
Spring Tool Suites4
xampp 8.1.1
phpMyAdmin 5.1.1
さくらのVPS
CentOS Linux release 7.9.2009 (Core)
openjdk version "1.8.0_312"
OpenJDK Runtime Environment (build 1.8.0_312-b07)
OpenJDK 64-Bit Server VM (build 25.312-b07, mixed mode)
Linux7
1#firewall-cmd --list-ports 28080/tcp 3306/tcp 3#firewall-cmd --list-services 4dhcpv6-client http https ssh tomcat
Java
1spring.jpa.hibernate.ddl-auto=update 2spring.datasource.url=jdbc:mysql://localhost:3306/postarticle?enabledTLSProtocols=TLSv1.2 3spring.datasource.username=***** 4spring.datasource.password=*****
回答2件
下記のような回答は推奨されていません。
このような回答には修正を依頼しましょう。
2022/01/14 07:22
2022/01/15 13:53
2022/01/30 06:37
2022/02/03 15:01