kettle 中REST client 获取API接口数据

转载

Python数据分析 2024-09-13 00:04:26

文章标签 elasticsearch elk 大数据 java .net 文章分类 云原生云计算

kettle 中REST client 获取API接口数据_elk

2.1.2、es安装启动问题解决

kettle 中REST client 获取API接口数据_java_02

（1）先退出elk用户，换成root用户

在/etc/security/limits.conf文件最后面添加如下信息

elk_test soft memlock unlimited

elk_test hard memlock unlimited

* soft nofile 65536
         * hard nofile 65536
（2）仍是root用户
         在/etc/sysctl.conf下添加如下信息：
         vm.max_map_count=655360
         执行如下命令
         sysctl -p
（3）执行完如上两步后切回elk用户，至elasticsearch的bin目录./elasticsearch &启动es即可

2.1.3、search-guard安装

（1）Search Guard版本必须要和elasticsearch版本对应 :https://docs.search-guard.com/latest/search-guard-versions ，此处下载search-guard-6-6.7.1-25.1.zip版本

（2）Search Guard需要证书才可以，生成证书有两种方式，一个是人工手动生成，这个复杂麻烦，另一种就是官网提供了在线生成，这里使用了后面一种在线生成，官网在线生成证书连接：https://search-guard.com/tls-certificate-generator/ ，Email用来接收密钥，Organization Name可以随便填写，Hostname填写ElasticSearch集群中每个节点的node name，这是一一对应的，这里我有三个节点es-node-1、es-node-2、es-node-3，生成search-guard-certificates- …… .tar.gz之后会发送到邮箱，下载下来。

kettle 中REST client 获取API接口数据_elasticsearch_03

（3）在es的目录下新建search-guard目录，在es的目录下的config目录下新建key目录

（4）将search-guard-6-6.7.1-25.1.zip和search-guard-certificates- …… .tar.gz上传到search-guard目录下

解压search-guard-certificates- …… .tar.gz至conf/key下tar -zxvf search-guard-certificates- …… .tar.gz -C …/config/key

（5）安装search-guard插件

到es的bin目录下执行 ./elasticsearch-plugin install -b file:///home/elk/elasticsearch/search-guard/search-guard-6-6.4.0-23.1.zip

# ./elasticsearch-plugin install -b file:///home/elk/elasticsearch/search-guard/search-guard-6-6.4.0-23.1.zip
-> Downloading com.floragunn:search-guard-6:6.4.0-23.0 from maven central
[=================================================] 100%
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
@     WARNING: plugin requires additional permissions     @
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
\* java.io.FilePermission /proc/sys/net/core/somaxconn read
\* java.lang.RuntimePermission accessClassInPackage.com.sun.jndi.ldap
\* java.lang.RuntimePermission accessClassInPackage.sun.misc
\* java.lang.RuntimePermission accessClassInPackage.sun.nio.ch
\* java.lang.RuntimePermission accessClassInPackage.sun.security.x509
\* java.lang.RuntimePermission accessDeclaredMembers
\* java.lang.RuntimePermission accessUserInformation
\* java.lang.RuntimePermission getClassLoader
\* java.lang.RuntimePermission setContextClassLoader
\* java.lang.RuntimePermission shutdownHooks
\* java.lang.reflect.ReflectPermission suppressAccessChecks
\* java.net.NetPermission getNetworkInformation
\* java.net.NetPermission getProxySelector
\* java.net.SocketPermission \* connect,accept,resolve
\* java.security.SecurityPermission getProperty.ssl.KeyManagerFactory.algorithm
\* java.security.SecurityPermission insertProvider.BC
\* java.security.SecurityPermission org.apache.xml.security.register
\* java.security.SecurityPermission putProviderProperty.BC
\* java.security.SecurityPermission setProperty.ocsp.enable
\* java.util.PropertyPermission \* read,write
\* java.util.PropertyPermission org.apache.xml.security.ignoreLineBreaks write
\* javax.security.auth.AuthPermission doAs
\* javax.security.auth.AuthPermission modifyPrivateCredentials
\* javax.security.auth.kerberos.ServicePermission \* accept
See http://docs.oracle.com/javase/8/docs/technotes/guides/security/permissions.html
for descriptions of what these permissions allow and the associated risks.
-> Installed search-guard-6

（6）修改elasticsearch.yml配置文件

# ======================== Elasticsearch Configuration =========================
# ---------------------------------- Cluster -----------------------------------
# 集群的名称
cluster.name: es-cluster
# ------------------------------------ Node ------------------------------------
# 节点的名称
node.name: es-node-1
# 是否能参加主节点选举
node.master: true 
# 是否是数据节点
node.data: true
# ----------------------------------- Paths ------------------------------------
# 数据的目录，此目录自行创建
path.data: /data/elk/es/data 
# 日志目录，此目录自行创建
path.logs: /data/elk/es/logs
# ----------------------------------- Memory -----------------------------------
# 设置为true锁住内存
bootstrap.memory_lock: true
# ---------------------------------- Network -----------------------------------
# 监听的主机（不限请求机器）
network.host: 0.0.0.0
# 监听的默认端口
http.port: 9200
# --------------------------------- Discovery ----------------------------------
# 这是一个集群中的主节点的初始列表,当节点(主节点或者数据节点)启动时使用这个列表进行探测
discovery.zen.ping.unicast.hosts: ["10.253.177.35", "10.253.177.36", "10.253.177.37"]
# 主节点最少的个数，建议为:节点数/2+1
discovery.zen.minimum_master_nodes: 2 
discovery.zen.ping_timeout: 30s

# 以下三个是前台跨域问题解决办法
http.cors.enabled: true
http.cors.allow-credentials: true
http.cors.allow-origin: "/.\*/"

# 必须设置xpack为false
xpack.security.enabled: false

# search-guard节点证书，不同的节点填写成对应的证书
searchguard.ssl.transport.pemcert_filepath: key/search-guard-certificates/node-certificates/CN=es-node-1.crtfull.pem
# search-guard节点key
searchguard.ssl.transport.pemkey_filepath: key/search-guard-certificates/node-certificates/CN=es-node-1.key.pem
# 该密钥可在解压的证书文件夹下的README.txt里可查到
searchguard.ssl.transport.pemkey_password: 7719b9f699c993abb4d0
searchguard.ssl.transport.pemtrustedcas_filepath: key/search-guard-certificates/chain-ca.pem
searchguard.ssl.transport.enforce_hostname_verification: false
searchguard.ssl.http.enabled: true
searchguard.ssl.http.pemcert_filepath: key/search-guard-certificates/node-certificates/CN=es-node-1.crtfull.pem
searchguard.ssl.http.pemkey_filepath: key/search-guard-certificates/node-certificates/CN=es-node-1.key.pem
searchguard.ssl.http.pemkey_password: 7719b9f699c993abb4d0
searchguard.ssl.http.pemtrustedcas_filepath: key/search-guard-certificates/chain-ca.pem
searchguard.authcz.admin_dn: 
- CN=sgadmin
searchguard.audit.type: internal_elasticsearch
searchguard.enable_snapshot_restore_privilege: true
searchguard.check_snapshot_restore_write_privileges: true
searchguard.restapi.roles_enabled: ["sg\_all\_access"]

上面的pemkey_password可在search-guard-certificates- …… .tar.gz下的README.txt中查到

# README.txt
## Passwords                                       

### Common passwords                                      

Root CA password: 495f7fc3b340008ff918413cdfca56d8d7e8a047                                       
Truststore password: 96808e3ec8fe2c14f74f                               
Admin keystore and private key password: 53b895fd2d74ef87d643                       
Demouser keystore and private key password: f2ad809cf899194ec804               

## Host/Node specific passwords                                       

Host: es-node-1                                                 
es-node-1 keystore and private key password: 7719b9f699c993abb4d0                           
es-node-1 keystore: node-certificates/CN=es-node-1-keystore.jks     
es-node-1 PEM certificate: node-certificates/CN=es-node-1.crtfull.pem     
es-node-1 PEM private key: node-certificates/CN=es-node-1.key.pem     

Host: es-node-2                                                 
es-node-2 keystore and private key password: 280c91c6ac87998eec2e                           
es-node-2 keystore: node-certificates/CN=es-node-2-keystore.jks     
es-node-2 PEM certificate: node-certificates/CN=es-node-2.crtfull.pem     
es-node-2 PEM private key: node-certificates/CN=es-node-2.key.pem     

Host: es-node-3                                                 
es-node-3 keystore and private key password: 48241eecae07f957b8da                           
es-node-3 keystore: node-certificates/CN=es-node-3-keystore.jks     
es-node-3 PEM certificate: node-certificates/CN=es-node-3.crtfull.pem     
es-node-3 PEM private key: node-certificates/CN=es-node-3.key.pem

（7）其余两台机器也是如上配置，修改对应的密码即可
（8）将三台机器上的es停止并重新启动（*****）
（9）设置权限因子，将sgadmin客户端证书密钥复制到插件目录下，步骤在README.txt中也有，三台机器的es依次设置，步骤一致

# README.txt
On the node where you want to execute sgadmin on:
\* Copy the file 'root-ca.pem' to the directory 'plugins/search-guard-<version>/tools'
\* Copy the file 'client-certificates/CN=sgadmin.crtfull.pem' to the directory 'plugins/search-guard-<version>/tools'
\* Copy the file 'client-certificates/CN=sgadmin.key.pem' to the directory 'plugins/search-guard-<version>/tools'

Change to the 'plugins/search-guard-<version>/tools' and execute:

chmod 755 ./sgadmin.sh
./sgadmin.sh -cacert root-ca.pem -cert CN=sgadmin.crtfull.pem -key CN=sgadmin.key.pem -keypass 53b895fd2d74ef87d643 -nhnv -icl -cd ../sgconfig/

操作步骤如下：

# cd /home/elk/elasticsearch/config/key/search-/local/elasticsearch/config/key/search-guard-certificates
# cp root-ca.pem chain-ca.pem  client-certificates/CN\=sgadmin.key.pem  client-certificates/CN\=sgadmin.crtfull.pem  ../../../plugins/search-guard-6/tools 
# cd ../../../plugins/search-guard-6/tools
# chmod 755 sgadmin.sh
# ./sgadmin.sh -cacert root-ca.pem -cert CN=sgadmin.crtfull.pem -key CN=sgadmin.key.pem -keypass 00fb1075cf84c333f1cc -nhnv -icl -cd ../sgconfig/
-nhnv -icl -cd ../sgconfig/
Search Guard Admin v6
Will connect to localhost:9300 ... done
Elasticsearch Version: 6.4.0
Search Guard Version: 6.4.0-23.1
Connected as CN=sgadmin
# 到下面这补可能会卡着，无需担心，只需要在其余两台机器执行设置权限因子操作，次步即可继续执行下去（\*\*\*\*\*）
Contacting elasticsearch cluster 'elasticsearch' and wait for YELLOW clusterstate ...
Clustername: GHS-ELK
Clusterstate: GREEN
Number of nodes: 3
Number of data nodes: 3
searchguard index already exists, so we do not need to create one.
Populate config from /usr/local/elasticsearch/plugins/search-guard-6/sgconfig
Will update 'sg/config' with ../sgconfig/sg_config.yml
SUCC: Configuration for 'config' created or updated
Will update 'sg/roles' with ../sgconfig/sg_roles.yml
SUCC: Configuration for 'roles' created or updated
Will update 'sg/rolesmapping' with ../sgconfig/sg_roles_mapping.yml
SUCC: Configuration for 'rolesmapping' created or updated
Will update 'sg/internalusers' with ../sgconfig/sg_internal_users.yml
SUCC: Configuration for 'internalusers' created or updated
Will update 'sg/actiongroups' with ../sgconfig/sg_action_groups.yml
SUCC: Configuration for 'actiongroups' created or updated
Done with success

（10）验证，在浏览器输入其中一台es的ip:9200会提示输入账号密码，默认账号密码为admin/admin

2.2、kibana 安装

（1）将kibana的压缩包上传并解压
（2）进入kibana的目录下的config目录，修改kibana.yml

# 启动端口
server.port: 5601
# 监听地址
server.host: "10.253.177.31"
server.name: "log-kibana"

# 从elasticsearch中找日志，因为es中使用了search-guard，所以此处是https
elasticsearch.hosts: ["https://10.253.177.35:9200"]
# es的账号（必须）
elasticsearch.username: "admin"
# es的密码（必须）
elasticsearch.password: "admin"
# ssl验证（必须none）
elasticsearch.ssl.verificationMode: none
# xpark安全（必须false）
xpack.security.enabled: false

# kibana的索引
kibana.index: ".kibana"
# 语言
i18n.locale: "zh-CN"

（3）进入kibana的bin目录 ./kibana &启动kibana，然后再浏览器输入192.168.1.114:5601即可查看

2.3、metricbeat 安装

（1）将metricbeat的压缩包上传并解压
（2）进入metricbeat的目录下，修改metricbeat.yml

metricbeat.config.modules:
  path: ${path.config}/modules.d/\\*.yml
  reload.enabled: false
#==================== Elasticsearch template setting ==========================
setup.template.settings:
  index.number_of_shards: 3
  index.codec: best_compression
  #_source.enabled: false
#============================== Kibana =====================================
setup.kibana:
#================================ Outputs =====================================
#-------------------------- Elasticsearch output ------------------------------
output.elasticsearch:
  hosts: ["10.253.177.35", "10.253.177.36", "10.253.177.37"]
  # 下面4个必须，因为es使用了search-guard
  protocol: "https"
  username: "admin"
  password: "admin"
  ssl.verification_mode: "none"
#================================ Processors =====================================
processors:
  - add_host_metadata: ~
  - add_cloud_metadata: ~

（3）在metricbeat的目录下执行./metricbeat -e -c metricbeat.yml &启动metricbeat
（4）在每台需要安装metricbeat的机器上执行如上步骤

2.4、filebeat 安装

（1）将filebeat的压缩包上传并解压
（2）进入filebeat的目录下，修改filebeat.yml

#=========================== Filebeat inputs =============================
filebeat.inputs:
- type: log
  enabled: true
  # 此处可以写多个路劲
  paths:
    - /opt/kettle/log/\\*/\\*.log
  # tags是内容是自定义的  
  tags: ["kettle-log"]
  # fields为自定义字段


![img]()
![img]()
![img]()

**既有适合小白学习的零基础资料，也有适合3年以上经验的小伙伴深入学习提升的进阶课程，涵盖了95%以上软件测试知识点，真正体系化！**

**由于文件比较多，这里只是将部分目录截图出来，全套包含大厂面经、学习笔记、源码讲义、实战项目、大纲路线、讲解视频，并且后续会持续更新**

**[需要这份系统化的资料的朋友，可以戳这里获取]()**

]
  # fields为自定义字段


[外链图片转存中...(img-QTSqJunk-1715058858184)]
[外链图片转存中...(img-zZZvfjdh-1715058858184)]
[外链图片转存中...(img-tzhZzgZe-1715058858185)]

**既有适合小白学习的零基础资料，也有适合3年以上经验的小伙伴深入学习提升的进阶课程，涵盖了95%以上软件测试知识点，真正体系化！**

**由于文件比较多，这里只是将部分目录截图出来，全套包含大厂面经、学习笔记、源码讲义、实战项目、大纲路线、讲解视频，并且后续会持续更新**

**[需要这份系统化的资料的朋友，可以戳这里获取]()**

本文章为转载内容，我们尊重原作者对文章享有的著作权。如有内容错误或侵权问题，欢迎原作者联系我们进行内容更正或删除文章。