AccessLog 源码部署步骤

1.数据库初始化

根据 accesslog-scripts 下的clickhouse/sql.txt文件创建clickhouse实例schema和表
```
clickhouse-client --host localhost --user default --queries-file PATH_TO_SQL_FILE
```

在kafka中创建队列clklog

/usr/local/services/kafka_2.12-3.3.1/bin/kafka-topics.sh --create --bootstrap-server 127.0.0.1:9092 --replication-factor 1 --partitions 6 --topic accesslog

2.日志采集配置

使用vector采集工具采集nginx的access日志，写入kafka,topic为accesslog。

vector配置方法参考：

https://github.com/clklog/accesslog-scripts/tree/main/vector

https://gitee.com/clklog/accesslog-scripts/tree/main/vector

https://gitcode.com/clklog/accesslog-scripts/tree/main/vector

3.部署accesslog-processing 服务

提示

accesslog-processing 服务可选择是否使用flink。

不使用flink，则部署accesslog-processing-simple服务。

使用flink，则部署accesslog-processing服务。

3.1.accesslog-processing-sample 服务部署

编译应用程序
上传程序文件
在目录/usr/local/services/中创建accesslog-processing-simple目录并将文件包accesslog-processing-simple.jar、配置文件application.yml以及源码中的iplib文件夹拷贝进去，代码如下：
```
cd /usr/local/services/
mkdir accesslog-processing-simple
```
- 为防止出现权限问题导致脚本不能执行，建议上传完脚本以后执行以下代码
```
chmod 500 accesslog-processing-simple.jar
```

修改配置文件根据前面部署的组件配置，修改application.yml中redis、kafka、clickhouse相关配置，代码如下：

server:
port: 8004
logging:
file:
    path: log
spring:
redis:
    # 单机配置
    host: localhost
    port: 6379
    # password
    # 哨兵配置
    # sentinel
    # master: gct
    # nodes: 10.100.2.1:26379,10.100.2.2:26379,10.100.2.3:26379
application.name: accesslog-processing-simple
datasource:
    clickhouse:
    jdbc-url: jdbc:clickhouse://localhost:8123/accesslogdb
    username: default
    password:

accesslog-processing:
    # 处理线程数
    thread-count: 2

    # kafka配置
    kafka-bootstrap-servers: localhost:9092
    kafka-consumer-group-id: accesslog-group
    topic-name: accesslog
    nginx_access_table: gp_nginx_access

创建服务

 vim /etc/systemd/system/accesslog-processing-simple.service

 [Unit]
 Description=accesslog-processing-simple
 After=syslog.target

 [Service]
 ExecStart=/usr/local/services/accesslog-processing-simple/accesslog-processing-simple.jar
 SuccessExitStatus=143

 [Install]
 WantedBy=multi-user.target

更新服务配置
```
systemctl daemon-reload
```

启动应用程序

systemctl start accesslog-processing-simple

3.2部署accesslog-processing 服务

编译应用程序
上传程序文件在目录/usr/local/services/中创建accesslog-processing 目录并将文件包accesslog-processing-1.0-SNAPSHOT-jar-with-dependencies.jar、配置文件config.properties以及源码中的iplib文件夹拷贝拷进去，代码如下：
```
cd /usr/local/services/
mkdir /usr/local/services/accesslog-processing
```

修改配置项

#clickhouse 数据库
clickhouse.host=localhost:8123
clickhouse.database=default
clickhouse.username=default
clickhouse.password=123456

kafka.bootstrap.server=localhost:9092
kafka.accesslog-topic=accesslog
kafka.accesslog-group-id=accesslog-group
flink.accesslog-data-source-name=AccesslogKafkaSource

# flink conf
flink.checkpoint=file:///usr/local/services/accesslog-processing/checkpoints
flink.parallelism=1
processing-file-location=/usr/local/services/accesslog-processing

# redis
redis.host=localhost
redis.port=6379
redis.password=

启动应用程序

cd /usr/local/services/accesslog-processing /usr/local/services/flink-1.16.3/bin/flink run [-s file: /usr/local/services/accesslog-processing/checkpoints/41f3b324752da77ed7821033d45d1d2f/chk-2737882] -c com.zcunsoft.accesslog.processing.entry.JieXiJson /usr/local/services/accesslog-processing/accesslog-processing-1.0-SNAPSHOT-jar-with-dependencies.jar

其中 -s 参数为checkpoint位置。对于中断后再执行的任务，需要指定该参数，如不指定则从头开始消费kafka消息。

4.部署accesslog-api 服务

编译应用程序
上传程序文件在目录/usr/local/services/中创建accesslog-api目录并将文件包accesslog-api.jar、配置文件application.yml拷贝进去，代码如下：
```
cd /usr/local/services/
mkdir accesslog-api
```
- 为防止出现权限问题导致脚本不能执行，建议上传完脚本以后执行以下代码
```
chmod 500 accesslog-api.jar
```

修改配置文件根据前面部署的组件配置，修改application.yml中clickhouse相关配置，代码如下：

springdoc:
swagger-ui:
    enabled: true
    tagsSorter: alpha
api-docs:
    path: /accesslog-api/v3/api-docs
    enabled: true
group-configs:
    - group: 'default'
    paths-to-match: '/**'
    packages-to-scan: com.zcunsoft.accesslog.api.controllers
server:
port: 8087
spring:
application.name: accesslog-api
datasource:
# clickhouse 配置
    clickhouse:
    jdbc-url: jdbc:clickhouse://localhost:8123/accesslogdb
    username: default
    password: 
    driver-class-name: com.clickhouse.jdbc.ClickHouseDriver
    connection-timeout: 20000
    maximum-pool-size: 5
logging:
file:
    path: log
accesslogapi:
    access-control-allow-origin: "*"
    project-name: accesslog

创建服务

vim /etc/systemd/system/accesslog-api.service
[Unit]
Description= accesslog-api
After=syslog.target

[Service]
ExecStart=/usr/local/services/accesslog-api /accesslog-api.jar
SuccessExitStatus=143

[Install]
WantedBy=multi-user.target

启动应用程序
```
systemctl start accesslog-api
```

5.部署accesslog-ui 服务

在开发环境编译前端应用程序本地前端代码运行步骤参考：
1）部署依赖
```
npm install
```
2）修改相关配置
```
修改接口地址
```
打包
```
npm run build
```
部署将dist目录文件拷贝至web服务器（nginx或者apache或iis）。
登录验证此时您可访问http://YOUR_DOMAIN/ ，验证部署成果。预置账号密码为 admin/clklog。

6.nginx 路由配置参考

创建配置文件，设置路由

vim /etc/nginx/conf.d/accesslog.conf

内容如下，注意替换YOUR_DOMAIN为您为监控后台配置的域名：

upstream accesslog_api_server {
    server localhost:8087;
} 
server {
listen 80;
listen [::]:80;
server_name localhost YOUR_DOMAIN;

location / {
        root   /usr/share/nginx/html;
        index  index.html index.htm;
        proxy_set_header Host $host;
        proxy_set_header X-Real-IP $remote_addr;
        proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
}

location /api/ {
        proxy_pass http://accesslog_api_server/;
        proxy_set_header Host $host:$server_port;
}

location /api/v3/ {
        proxy_pass http://accesslog_api_server/api/v3/;
        proxy_set_header Host $host:$server_port;
        proxy_set_header X-Real-IP $remote_addr;
        proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
    }
}

重启nginx
```
systemctl restart nginx
```