Caused by: java.net.NoRouteToHostException: No route to host (Host unreachable)

【myApps/OBPM版本号】：v5.0- sp 71325
【浏览器类型】：Chrome/其他
【联系方式-QQ】：260217944
【联系电话】:    请留下您的联系电话，以便技术同事更好解决您的问题
【问题描述】：利用批处理sudo docker-compose up -d 所有容器启动成功，但tomcat容器登入应该是有问题，运行./bin/catalina.run 时有如下错误
之前启动有好几个WARN，我手动先指定


1、问题描述最好图文并茂，如有视频/脚本可直接放出，这样技术同事在处理该问题时效率更加高效哦~
2、如果该问题已得到解决，请在该帖子下回复\\\"已解决可结帖\\\"

是否改了数据库配置？

/usr/myapps/mysql/my.cnf 如下
[client]
default-character-set=utf8mb4

[mysqld]
port=3307
user=mysql
default-storage-engine=INNODB
default_authentication_plugin=mysql_native_password
lower_case_table_names=1
sql_mode='NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
character-set-server=utf8mb4
collation-server = utf8mb4_unicode_ci
init_connect='SET NAMES utf8mb4'
max_allowed_packet = 256M
max_connections=1000

[mysql]
default-character-set=utf8mb4

[euler@localhost myapps]$ sudo systemctl status firewalld
● firewalld.service - firewalld - dynamic firewall daemon
     Loaded: loaded (/usr/lib/systemd/system/firewalld.service; enabled; vendor preset: enabled)
     Active: active (running) since Thu 2023-11-02 16:21:18 CST; 1min 14s ago
       Docs: man:firewalld(1)
   Main PID: 11943 (firewalld)
      Tasks: 2 (limit: 47378)
     Memory: 21.6M
     CGroup: /system.slice/firewalld.service
             └─ 11943 /usr/bin/python3 -s /usr/sbin/firewalld --nofork --nopid

11月 02 16:21:18 localhost.localdomain systemd[1]: Starting firewalld - dynamic firewall daemon...
11月 02 16:21:18 localhost.localdomain systemd[1]: Started firewalld - dynamic firewall daemon.
11月 02 16:21:18 localhost.localdomain firewalld[11943]: WARNING: COMMAND_FAILED: '/usr/sbin/iptables -w10 -D FORWARD -i docker0 -o docker0 -j DROP' failed: iptables: Bad rule (does a matching rule exist in that chain?).
11月 02 16:21:18 localhost.localdomain firewalld[11943]: WARNING: COMMAND_FAILED: '/usr/sbin/iptables -w10 -D FORWARD -i br-218e0f172d95 -o br-218e0f172d95 -j DROP' failed: iptables: Bad rule (does a matching rule exist in that chai>
11月 02 16:21:18 localhost.localdomain firewalld[11943]: WARNING: COMMAND_FAILED: '/usr/sbin/iptables -w10 -D FORWARD -i br-8f563202dbf6 -o br-8f563202dbf6 -j DROP' failed: iptables: Bad rule (does a matching rule exist in that chai>
11月 02 16:21:23 localhost.localdomain firewalld[11943]: WARNING: COMMAND_FAILED: '/usr/sbin/iptables -w10 -D FORWARD -i br-f392d390c307 -o br-f392d390c307 -j DROP' failed: iptables: Bad rule (does a matching rule exist in that chai>

已经通过Q群把.env放好，WARN解决了，配置加载到相关参数，但tomcat容器始终是报这个错


2023-11-02 16:58:53.889 ERROR 246 --- [reate-967356884] com.alibaba.druid.pool.DruidDataSource   : create connection SQLException, url: jdbc:mysql://mysql-srv:3307/obpm5?characterEncoding=UTF-8&serverTimezone=GMT, errorCode 0, state 08S01

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

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
        at jdk.internal.reflect.GeneratedConstructorAccessor168.newInstance(Unknown Source) ~[na:na]
        at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:na]
        at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490) ~[na:na]
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) ~[mysql-connector-java-5.1.47.jar:5.1.47]
        at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:990) ~[mysql-connector-java-5.1.47.jar:5.1.47]
        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:342) ~[mysql-connector-java-5.1.47.jar:5.1.47]
        at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2197) ~[mysql-connector-java-5.1.47.jar:5.1.47]
        at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2230) ~[mysql-connector-java-5.1.47.jar:5.1.47]
        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2025) ~[mysql-connector-java-5.1.47.jar:5.1.47]
        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:778) ~[mysql-connector-java-5.1.47.jar:5.1.47]
        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) ~[mysql-connector-java-5.1.47.jar:5.1.47]
        at jdk.internal.reflect.GeneratedConstructorAccessor165.newInstance(Unknown Source) ~[na:na]
        at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:na]
        at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:490) ~[na:na]
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) ~[mysql-connector-java-5.1.47.jar:5.1.47]
        at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:386) ~[mysql-connector-java-5.1.47.jar:5.1.47]
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330) ~[mysql-connector-java-5.1.47.jar:5.1.47]
        at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1570) ~[druid-1.1.12.jar:1.1.12]
        at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1636) ~[druid-1.1.12.jar:1.1.12]
        at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2505) ~[druid-1.1.12.jar:1.1.12]
Caused by: java.net.NoRouteToHostException: No route to host (Host unreachable)
        at java.base/java.net.PlainSocketImpl.socketConnect(Native Method) ~[na:na]
        at java.base/java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:412) ~[na:na]
        at java.base/java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:255) ~[na:na]
        at java.base/java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:237) ~[na:na]
        at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) ~[na:na]
        at java.base/java.net.Socket.connect(Socket.java:609) ~[na:na]
        at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:211) ~[mysql-connector-java-5.1.47.jar:5.1.47]
        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:301) ~[mysql-connector-java-5.1.47.jar:5.1.47]
        ... 14 common frames omitted

2023-11-02 15:40:47 WARNING: COMMAND_FAILED: '/usr/sbin/iptables -w10 -D FORWARD -i br-16da675b8f45 -o br-16da675b8f45 -j DROP' failed: iptables: Bad rule (does a matching rule exist in that chain?).

2023-11-02 15:48:32 WARNING: COMMAND_FAILED: '/usr/sbin/iptables -w10 -t nat -D PREROUTING -m addrtype --dst-type LOCAL -j DOCKER' failed: iptables v1.8.7 (legacy): Couldn't load target `DOCKER':No such file or directory

Try `iptables -h' or 'iptables --help' for more information.

2023-11-02 15:48:32 WARNING: COMMAND_FAILED: '/usr/sbin/iptables -w10 -t nat -D OUTPUT -m addrtype --dst-type LOCAL ! --dst 127.0.0.0/8 -j DOCKER' failed: iptables v1.8.7 (legacy): Couldn't load target `DOCKER':No such file or directory

Try `iptables -h' or 'iptables --help' for more information.

2023-11-02 15:48:32 WARNING: COMMAND_FAILED: '/usr/sbin/iptables -w10 -t nat -D OUTPUT -m addrtype --dst-type LOCAL -j DOCKER' failed: iptables v1.8.7 (legacy): Couldn't load target `DOCKER':No such file or directory

Try `iptables -h' or 'iptables --help' for more information.

2023-11-02 15:48:32 WARNING: COMMAND_FAILED: '/usr/sbin/iptables -w10 -t nat -D PREROUTING' failed: iptables: Bad rule (does a matching rule exist in that chain?).

2023-11-02 15:48:32 WARNING: COMMAND_FAILED: '/usr/sbin/iptables -w10 -t nat -D OUTPUT' failed: iptables: Bad rule (does a matching rule exist in that chain?).

2023-11-02 15:48:32 WARNING: COMMAND_FAILED: '/usr/sbin/iptables -w10 -t nat -F DOCKER' failed: iptables: No chain/target/match by that name.

2023-11-02 15:48:32 WARNING: COMMAND_FAILED: '/usr/sbin/iptables -w10 -t nat -X DOCKER' failed: iptables: No chain/target/match by that name.

2023-11-02 15:48:32 WARNING: COMMAND_FAILED: '/usr/sbin/iptables -w10 -t filter -F DOCKER' failed: iptables: No chain/target/match by that name.

2023-11-02 15:48:32 WARNING: COMMAND_FAILED: '/usr/sbin/iptables -w10 -t filter -X DOCKER' failed: iptables: No chain/target/match by that name.

2023-11-02 15:48:32 WARNING: COMMAND_FAILED: '/usr/sbin/iptables -w10 -t filter -F DOCKER-ISOLATION-STAGE-1' failed: iptables: No chain/target/match by that name.

2023-11-02 15:48:32 WARNING: COMMAND_FAILED: '/usr/sbin/iptables -w10 -t filter -X DOCKER-ISOLATION-STAGE-1' failed: iptables: No chain/target/match by that name.

2023-11-02 15:48:32 WARNING: COMMAND_FAILED: '/usr/sbin/iptables -w10 -t filter -F DOCKER-ISOLATION-STAGE-2' failed: iptables: No chain/target/match by that name.

2023-11-02 15:48:32 WARNING: COMMAND_FAILED: '/usr/sbin/iptables -w10 -t filter -X DOCKER-ISOLATION-STAGE-2' failed: iptables: No chain/target/match by that name.

2023-11-02 15:48:32 WARNING: COMMAND_FAILED: '/usr/sbin/iptables -w10 -t filter -F DOCKER-ISOLATION' failed: iptables: No chain/target/match by that name.

2023-11-02 15:48:32 WARNING: COMMAND_FAILED: '/usr/sbin/iptables -w10 -t filter -X DOCKER-ISOLATION' failed: iptables: No chain/target/match by that name.

2023-11-02 15:48:32 WARNING: COMMAND_FAILED: '/usr/sbin/iptables -w10 -D FORWARD -i docker0 -o docker0 -j DROP' failed: iptables: Bad rule (does a matching rule exist in that chain?).

2023-11-02 15:55:09 WARNING: COMMAND_FAILED: '/usr/sbin/iptables -w10 -D FORWARD -i br-218e0f172d95 -o br-218e0f172d95 -j DROP' failed: iptables: Bad rule (does a matching rule exist in that chain?).

2023-11-02 15:56:19 WARNING: COMMAND_FAILED: '/usr/sbin/iptables -w10 -D FORWARD -i br-8f563202dbf6 -o br-8f563202dbf6 -j DROP' failed: iptables: Bad rule (does a matching rule exist in that chain?).

2023-11-02 16:21:18 WARNING: COMMAND_FAILED: '/usr/sbin/iptables -w10 -D FORWARD -i docker0 -o docker0 -j DROP' failed: iptables: Bad rule (does a matching rule exist in that chain?).

2023-11-02 16:21:18 WARNING: COMMAND_FAILED: '/usr/sbin/iptables -w10 -D FORWARD -i br-218e0f172d95 -o br-218e0f172d95 -j DROP' failed: iptables: Bad rule (does a matching rule exist in that chain?).

2023-11-02 16:21:18 WARNING: COMMAND_FAILED: '/usr/sbin/iptables -w10 -D FORWARD -i br-8f563202dbf6 -o br-8f563202dbf6 -j DROP' failed: iptables: Bad rule (does a matching rule exist in that chain?).

2023-11-02 16:21:23 WARNING: COMMAND_FAILED: '/usr/sbin/iptables -w10 -D FORWARD -i br-f392d390c307 -o br-f392d390c307 -j DROP' failed: iptables: Bad rule (does a matching rule exist in that chain?).

网络菜菜 发表于 2023-11-6 16:31
2023-11-02 15:40:47 WARNING: COMMAND_FAILED: '/usr/sbin/iptables -w10 -D FORWARD -i br-16da675b8f45  ...

.env放上去后，系统可以使用吗？

不能，故障依旧

网络菜菜 发表于 2023-11-6 19:14
不能，故障依旧

单独启动mysql，然后用navicat连下可不可以连接成功。看报错就是连不上数据库

装上客户端HeidiSQL是可以正常连接mysql的