es7学习杂记

xpack.ml.enabled: false

The setting '#/' contains additional properties ["action"] outside of the schema when none are allowed

select a.id,a.name,a.tags,concat(a.latitude,',',a.longitude) as location,a.remark_score,a.price_per_man,a.category_id,b.nam

bin/app-search --reset-install-lock

action.auto_create_index: ".app-search-*-logs-*,-.app-search-*,+*"

ailed to execute on node [DviuKRa7TuGTsrXr57d-cA]
org.elasticsearch.transport.RemoteTransportException: [node-1][172.17.0.1:9300][cluster:admin/tasks/cancel[n]]

结果找了老半天没发现错误，于是用命令：logstash -f ../config/logstash-simple-dev.conf -t

去测试配置文件是否正常。结果显示无效配置文件，也就是说配置文件出错了

input {
    jdbc {
      # mysql 数据库链接,test为数据库名
      jdbc_connection_string => "jdbc:mysql://192.168.0.103:3306/dianpingdb?characterEncoding=UTF-8&useSSL=false&&serverTimezone=Hongkong"
      # 用户名和密码
      jdbc_user => "root"
      jdbc_password => "123456"
      # 驱动
      jdbc_driver_library => "/opt/es7/logstash-7.5.2/bin/mysql/mysql-connector-java-8.0.13.jar
      # 驱动类名
      jdbc_driver_class => "com.mysql.jdbc.Driver"
      jdbc_paging_enabled => "true"
      jdbc_page_size => "50000"
      # 执行的sql 文件路径+名称
      statement_filepath => "/opt/es7/logstash-7.5.2/bin/mysql/jdbc.sql"
      # 设置监听间隔 各字段含义（由左至右）分、时、天、月、年，全部为*默认含义为每分钟都更新
      schedule => "* * * * *"
    }
}
output {
    stdout { 
        codec => json_lines 
    }
    elasticsearch {
        hosts => ["192.168.0.11:9200"]
        index => "shop"
        document_type => "_doc"
        document_id => "%{id}"
  }
}

curl -XPUT -H "Content-Type: application/json" http://192.168.0.11:9200/_all/_settings -d '{"index.blocks.read_only_allow_delete": null}'