dataease-v1.18.14安装及java的jdbc插件安装

1、文件下载

（1）dataaease-1.18.14下载

（2）java jdbc插件安装

       mysql-connector-java.jar

2、解压安装及配置文件修改

tar -zxvf dataease-v1.18.14-offline.tar.gz

cd dataease-v1.18.14-offline/

vim install.conf

#需要修改为外部mysql，并且mysql需要修改一些配置

#使用本地模式安装，安装kettle和doris
DE_ENGINE_MODE=local
# 数据库配置
## 是否使用外部数据库
DE_EXTERNAL_MYSQL=true
## 数据库地址
DE_MYSQL_HOST=192.168.1.1
## 数据库端口
DE_MYSQL_PORT=3306
## DataEase 数据库库名
DE_MYSQL_DB=dataease
## 数据库用户名
DE_MYSQL_USER=root
## 数据库密码
DE_MYSQL_PASSWORD=dataease1234
## 数据库参数
DE_MYSQL_PARAMS="autoReconnect=false&useUnicode=true&characterEncoding=UTF-8&characterSetResults=UTF-8&zeroDateTimeBehav
ior=convertToNull&useSSL=false&allowPublicKeyRetrieval=true"

#my.cnf

character_set_server=utf8mb4
lower_case_table_names=1
group_concat_max_len=1024000
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

3、在外部数据库创建dataease数据库（如果启动出现啥问题用root账户，（数据库删了重新执行bash install.sh））；

CREATE DATABASE `dataease` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

create user 'dataease'@'%' identified by 'DataEase123';
grant all privileges on dataease.* to 'dataease'@'%' with grant option;

4、执行安装命令

bash install.sh

#等待安装成功

地址: http://目标服务器IP地址:服务运行端口

用户名: admin 密码: dataease

5、安装JDBC插件

vim /opt/dataease/docker-compose-doris.yml

version: '2.1'
services:

doris-fe:
    image: registry.cn-qingdao.aliyuncs.com/dataease/doris:v1.2.4.1-0606
    container_name: doris-fe
    privileged: true
    #新增端口透出
    ports:
        - 9030:9030
        - 8030:8030
    ........
    dataease-network :
    volumes:
        - ${DE_BASE}/dataease/data/fe:/opt/apache-doris/fe/doris-meta
        - ${DE_BASE}/dataease/logs/fe:/opt/apache-doris/fe/log
        - ${DE_BASE}/dataease/conf/fe.conf:/opt/apache-doris/fe/conf/fe.conf
        #新增文件挂载
        - ${DE_BASE}/dataease/jdbc_drivers/fe:/opt/apache-doris/fe/jdbc_drivers
    ........
doris-be:
    image: registry.cn-qingdao.aliyuncs.com/dataease/doris:v1.2.4.1-0606
    container_name: doris-be
    privileged: true
    .......
    volumes:
        - ${DE_BASE}/dataease/data/be:/opt/apache-doris/be/storage
        - ${DE_BASE}/dataease/logs/be:/opt/apache-doris/be/log
        - ${DE_BASE}/dataease/conf/be.conf:/opt/apache-doris/be/conf/be.conf
        - ${DE_BASE}/dataease/bin/doris:/docker-entrypoint-initdb.d/
        #新增文件挂载
        - ${DE_BASE}/dataease/jdbc_drivers/be:/opt/apache-doris/be/jdbc_drivers

6、重新加载配置

执行命令：dectl reload    #等待完成

7、遇到的问题

Caused by: org.flywaydb.core.api.FlywayException: Schema `dataease` contains a failed migration to version 5 !
at org.flywaydb.core.internal.command.DbMigrate.migrateGroup(DbMigrate.java:217)
at org.flywaydb.core.internal.command.DbMigrate.lambda$migrateAll$0(DbMigrate.java:141)
at org.flywaydb.core.internal.database.mysql.MySQLNamedLockTemplate.execute(MySQLNamedLockTemplate.java:60)
at org.flywaydb.core.internal.database.mysql.MySQLConnection.lock(MySQLConnection.java:154)
at org.flywaydb.core.internal.schemahistory.JdbcTableSchemaHistory.lock(JdbcTableSchemaHistory.java:141)
at org.flywaydb.core.internal.command.DbMigrate.migrateAll(DbMigrate.java:141)
at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:101)
at org.flywaydb.core.Flyway$1.execute(Flyway.java:219)
at org.flywaydb.core.Flyway$1.execute(Flyway.java:170)
at org.flywaydb.core.Flyway.execute(Flyway.java:586)
at org.flywaydb.core.Flyway.migrate(Flyway.java:170)
at org.springframework.boot.autoconfigure.flyway.FlywayMigrationInitializer.afterPropertiesSet(FlywayMigrationInitializer.java:66)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1863)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1800)
... 34 common frames omitted

解决方法：删除dataease数据库，然后重建数据库，执行命令：dectl reload，即可解决。

CREATE DATABASE `dataease` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

密码修改
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'XXXXXX';