Logstsh | LOGSTASH-INPUT-JDBC Start Error Collection

1:

Failed to execute action{:Action=>logstash::P ipelineaction::create/pipeline_id:main,:exception=> "Logstash::configurationerror",: Message=> "Expected one of #, input, filter, output at line 1, column 1 (byte 1) after",: backtrace=>["D:/elasticsea Rch-6.3.1/logstash-6.3.2/logstash-core/lib/logstash/compiler.rb:42:in ' compile_imperative ' "," D:/ Elasticsearch-6.3.1/logstash-6.3.2/logstash-core/lib/logstash/compiler.rb:50:in ' Compile_graph ' "," D:/ Elasticsearch-6.3.1/logstash-6.3.2/logstash-core/lib/logstash/compiler.rb:12:in ' block in Compile_sources ' "," org/ Jruby/rubyarray.java:2486:in ' map ' "," d:/elasticsearch-6.3.1/logstash-6.3.2/logstash-core/lib/logstash/ Compiler.rb:11:in ' compile_sources ' "," d:/elasticsearch-6.3.1/logstash-6.3.2/logstash-core/lib/logstash/ Pipeline.rb:49:in ' Initialize ' "," d:/elasticsearch-6.3.1/logstash-6.3.2/logstash-core/lib/logstash/pipeline.rb : 167:in ' Initialize ' "," d:/elasticsearch-6.3.1/logstash-6.3.2/logstash-core/lib/logstash/pipeline_action/ Create.rb:40:in ' Execute ' "," d:/eLasticsearch-6.3.1/logstash-6.3.2/logstash-core/lib/logstash/agent.rb:305:in ' block in Converge_state ' "] }

Solution:

The cause of the above error is not using the correct configuration file, change the file path can   need to do is to check the file path, format   attention must be conf format file

2:

Failed to execute action{:action=>logstash::P ipelineaction::create/pipeline_id:main,:exception=> " Logstash::configurationerror ",:message=>" expected one of \ R, \ n at line, column 113 (byte 1530) after #com. Mysql.jd Bc. Driver not loaded. Is you sure you ' ve included the correct JDBC driver in:jdbc_driver_library? ",:message=>" expected one of \ R, \ n at Li NE, column 113 (byte 1631) after #com. Mysql.jdbc.Driver not loaded. Is sure you ' ve included the correct JDBC driver in:jdbc_driver_library:backtrace=>["f:/search/logstash-6.3.2/ Logstash-core/lib/logstash/compiler.rb:42:in ' compile_imperative ' "," f:/search/logstash-6.3.2/logstash-core/lib/ Logstash/compiler.rb:50:in ' Compile_graph ' "," f:/search/logstash-6.3.2/logstash-core/lib/logstash/compiler.rb:12 : In ' block in Compile_sources ' "," org/jruby/rubyarray.java:2486:in ' map ' "," f:/search/logstash-6.3.2/logstash-core/ Lib/logstash/compiler.rb:11:in ' compile_sources ' "," f:/search/logstash-6.3.2/logst 

Solution:

is the configuration file format error # The user we wish to excute our statement asjdbc_user = "root" Jdbc_password + "root" # The path to our do wnloaded jdbc Driverjdbc_driver_library = "d:\\elasticsearch-6.3.1\\mysql-connector-java-5.1.46\\ Mysql-connector-java-5.1.46-bin.jar "# The name of the driver class for mysqljdbc_driver_class =" Com.mysql.jdbc.Driver "jdbc_paging_enabled" = truejdbc_page_size "50000" cannot appear comment, the format of the comment is wrong, change to Jdbc_user = " Root "Jdbc_password" and "root" jdbc_driver_library = "d:\\elasticsearch-6.3.1\\mysql-connector-java-5.1.46\\" Mysql-connector-java-5.1.46-bin.jar "Jdbc_driver_class =" Com.mysql.jdbc.Driver "jdbc_paging_enabled Truejdbc_page_size = "50000"

Logstsh | LOGSTASH-INPUT-JDBC Start Error Collection