配置信息

input{

jdbc{

# jdbc 驱动包的位置

jdbc_driver_library => "D:\\logstash\\logstash-6.3.2\\mysql-connector-java-5.1.21.jar"

jdbc_driver_class => "com.mysql.jdbc.Driver"

jdbc_connection_string => "jdbc:mysql://localhost:3306/es-boke?serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8&useSSL=true"

jdbc_user => "root"

jdbc_password => "12345678"

schedule => "*****"

clean_run => true

statement => "select * from t_blog where update_time > :sql_last_value and update_time< NOW() ORDER BY update_time desc" 

}

}

output{

elasticsearch{

hosts => ["127.0.0.1:9200"]

index => "blog"

document_id => "%{id}"

}

}

报错信息

D:\logstash\logstash-6.3.2\bin>logstash -f ../config/mysql.conf

Sending Logstash's logs to D:/logstash/logstash-6.3.2/logs which is now configured via log4j2.properties

[2023-12-04T17:20:24,108][WARN ][logstash.config.source.multilocal] Ignoring the 'pipelines.yml' file because modules or command line options are specified

[2023-12-04T17:20:24,714][INFO ][logstash.runner          ] Starting Logstash {"logstash.version"=>"6.3.2"}

[2023-12-04T17:20:25,091][ERROR][logstash.agent           ] Failed to execute action {:action=>LogStash::PipelineAction::Create/pipeline_id:main, :exception=>"LogStash::ConfigurationError", :message=>"Expected one of #, input, filter, output at line 1, column 1 (byte 1) after ", :backtrace=>["D:/logstash/logstash-6.3.2/logstash-core/lib/logstash/compiler.rb:42:in `compile_imperative'", "D:/logstash/logstash-6.3.2/logstash-core/lib/logstash/compiler.rb:50:in `compile_graph'", "D:/logstash/logstash-6.3.2/logstash-core/lib/logstash/compiler.rb:12:in `block in compile_sources'", "org/jruby/RubyArray.java:2486:in `map'", "D:/logstash/logstash-6.3.2/logstash-core/lib/logstash/compiler.rb:11:in `compile_sources'", "D:/logstash/logstash-6.3.2/logstash-core/lib/logstash/pipeline.rb:49:in `initialize'", "D:/logstash/logstash-6.3.2/logstash-core/lib/logstash/pipeline.rb:167:in `initialize'", "D:/logstash/logstash-6.3.2/logstash-core/lib/logstash/pipeline_action/create.rb:40:in `execute'", "D:/logstash/logstash-6.3.2/logstash-core/lib/logstash/agent.rb:305:in `block in converge_state'"]}

[2023-12-04T17:20:25,453][INFO ][logstash.agent           ] Successfully started Logstash API endpoint {:port=>9600}