离线安装dataease 启动失败

  • 问问题请带上版本信息、安装部署方式信息、详细错误信息,减少不必要的来回沟通!
  • 不要重复发帖!
    版本信息:dataease:v2.7.1
    安装部署方式:离线安装
    初始化报错:当前时间 : 2024年 07月 04日 星期四 13:53:28 CST
  1. 检查安装环境并初始化环境变量
    停止 DataEase 服务
    升级安装
    [警告] DataEase 运行目录所在磁盘剩余空间不足 20G 可能无法正常启动!
  2. 设置运行目录
    运行目录 /data/var/lib/dataease/dataease2.0
    配置文件目录 /data/var/lib/dataease/dataease2.0/conf
  3. 初始化运行目录
    复制安装文件到运行目录
    调整配置文件参数
  4. 安装 dectl 命令行工具
    安装至 /usr/local/bin/dectl & /usr/bin/dectl
  5. 修改操作系统相关设置
    防火墙未开启,忽略端口开放
  6. 安装 docker
    检测到 Docker 已安装,跳过安装步骤
    启动 Docker
  7. 安装 docker-compose
    检测到 Docker Compose 已安装,跳过安装步骤
  8. 加载 DataEase 镜像
    已存在镜像 dataease:v2.7.1
    已存在镜像 mysql:8.3.0
  9. 配置 DataEase 服务
  10. 启动 DataEase 服务
    Job for dataease.service failed because the control process exited with error code. See “systemctl status dataease.service” and “journalctl -xe” for details.

======================= 安装完成 =======================

系统登录信息如下:
访问地址: http://服务器IP:8100
用户名: admin
初始密码: DataEase@123456

-----------------------------------------------------journalctl -xe 查看:

7月 04 13:54:32 node02 cm-server[53301]: at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:682)
7月 04 13:54:32 node02 cm-server[53301]: … 37 more
7月 04 13:54:32 node02 systemd[1]: cloudera-scm-server.service: main process exited, code=exited, status=1/FAILURE
7月 04 13:54:32 node02 systemd[1]: Unit cloudera-scm-server.service entered failed state.
7月 04 13:54:32 node02 systemd[1]: cloudera-scm-server.service failed.
7月 04 13:54:32 node02 systemd[1]: cloudera-scm-server.service holdoff time over, scheduling restart.
7月 04 13:54:32 node02 systemd[1]: Started Cloudera CM Server Service.
– Subject: Unit cloudera-scm-server.service has finished start-up
– Defined-By: systemd
– Support: systemd-devel Info Page

– Unit cloudera-scm-server.service has finished starting up.

– The start-up result is done.
7月 04 13:54:32 node02 systemd[1]: Starting Cloudera CM Server Service…
– Subject: Unit cloudera-scm-server.service has begun start-up
– Defined-By: systemd
– Support: systemd-devel Info Page

– Unit cloudera-scm-server.service has begun starting up.
7月 04 13:54:32 node02 cm-server[54052]: JAVA_HOME=/usr/java/jdk1.8.0_181-cloudera
7月 04 13:54:32 node02 cm-server[54052]: Java HotSpot™ 64-Bit Server VM warning: ignoring option MaxPermSize=256m; support was removed in 8.0
7月 04 13:54:34 node02 cm-server[54052]: ERROR StatusLogger No log4j2 configuration file found. Using default configuration: logging only errors to the console. Set system pr
lines 1204-1226/1226 (END)
7月 04 13:54:32 node02 cm-server[53301]: at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:682)
7月 04 13:54:32 node02 cm-server[53301]: … 37 more
7月 04 13:54:32 node02 systemd[1]: cloudera-scm-server.service: main process exited, code=exited, status=1/FAILURE
7月 04 13:54:32 node02 systemd[1]: Unit cloudera-scm-server.service entered failed state.
7月 04 13:54:32 node02 systemd[1]: cloudera-scm-server.service failed.
7月 04 13:54:32 node02 systemd[1]: cloudera-scm-server.service holdoff time over, scheduling restart.
7月 04 13:54:32 node02 systemd[1]: Started Cloudera CM Server Service.
– Subject: Unit cloudera-scm-server.service has finished start-up
– Defined-By: systemd
– Support: systemd-devel Info Page

– Unit cloudera-scm-server.service has finished starting up.

– The start-up result is done.
7月 04 13:54:32 node02 systemd[1]: Starting Cloudera CM Server Service…
– Subject: Unit cloudera-scm-server.service has begun start-up
– Defined-By: systemd
– Support: systemd-devel Info Page

– Unit cloudera-scm-server.service has begun starting up.
7月 04 13:54:32 node02 cm-server[54052]: JAVA_HOME=/usr/java/jdk1.8.0_181-cloudera
7月 04 13:54:32 node02 cm-server[54052]: Java HotSpot™ 64-Bit Server VM warning: ignoring option MaxPermSize=256m; support was removed in 8.0
7月 04 13:54:34 node02 cm-server[54052]: ERROR StatusLogger No log4j2 configuration file found. Using default configuration: logging only errors to the console. Set system property 'org.a

---------------------------------------------------------------------------error.log

SQL State : 08S01
Error Code : 0
Message : 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 org.flywaydb.core.internal.jdbc.JdbcUtils.openConnection(JdbcUtils.java:60)
    at org.flywaydb.core.internal.jdbc.JdbcConnectionFactory.<init>(JdbcConnectionFactory.java:72)
    at org.flywaydb.core.FlywayExecutor.execute(FlywayExecutor.java:134)
    at org.flywaydb.core.Flyway.migrate(Flyway.java:147)
    at org.springframework.boot.autoconfigure.flyway.FlywayMigrationInitializer.afterPropertiesSet(FlywayMigrationInitializer.java:66)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1835)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1784)
    ... 37 common frames omitted

Caused by: com.mysql.cj.jdbc.exceptions.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 com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64)
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:815)
at com.mysql.cj.jdbc.ConnectionImpl.(ConnectionImpl.java:438)
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:241)
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:189)
at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:137)
at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:360)
at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:202)
at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:461)
at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:550)
at com.zaxxer.hikari.pool.HikariPool.(HikariPool.java:98)
at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:111)
at org.flywaydb.core.internal.jdbc.JdbcUtils.openConnection(JdbcUtils.java:48)
… 43 common frames omitted
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: 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 java.base/jdk.internal.reflect.DirectConstructorHandleAccessor.newInstance(DirectConstructorHandleAccessor.java:62)
at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:502)
at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:486)
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:104)
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:149)
at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:165)
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:88)
at com.mysql.cj.NativeSession.connect(NativeSession.java:120)
at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:935)
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:805)
… 54 common frames omitted
Caused by: java.net.ConnectException: Connection refused
at java.base/sun.nio.ch.Net.pollConnect(Native Method)
at java.base/sun.nio.ch.Net.pollConnectNow(Net.java:682)
at java.base/sun.nio.ch.NioSocketImpl.timedFinishConnect(NioSocketImpl.java:542)
at java.base/sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:592)
at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:327)
at java.base/java.net.Socket.connect(Socket.java:751)
at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:153)
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:62)
… 57 common frames omitted

最后用自己创建的外部mysql8.0数据库可以正常启动了

看报错是连不上数据库,默认安装的时候,有改过 install.conf 里 MySQL 的相关设置吗?