首页 > 数据库技术 > 详细

logstsh | logstash-input-jdbc 启动错误收集

时间:2018-08-10 18:48:54      阅读:459      评论:0      收藏:0      [点我收藏+]

1:

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:/elasticsearch-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‘"]}

解决方案:

出现上面报错的原因是没有使用正确的配置文件,更改文件路径即可   需要做的是检查文件路径、格式   注意必须是conf格式文件

 

2:

Failed to execute action {
:action=>LogStash::PipelineAction::Create/pipeline_id:main, 
:exception=>"LogStash::ConfigurationError", 
:message=>"Expected one of \r, \n at line 52, column 113 (byte 1530) after #com.mysql.jdbc.Driver not loaded. Are you sure you‘ve included the correct jdbc driver in :jdbc_driver_library?", 
:message=>"Expected one of \r, \n at line 53, column 113 (byte 1631) after #com.mysql.jdbc.Driver not loaded. Are you 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

解决方案:

是配置文件格式错误
# the user we wish to excute our statement as
jdbc_user => "root"
jdbc_password => "root"
# the path to our downloaded jdbc driver
jdbc_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 mysql
jdbc_driver_class => "com.mysql.jdbc.Driver"
jdbc_paging_enabled => true
jdbc_page_size => "50000"
不能出现注释,注释的格式错误,改成
jdbc_user => "root"
jdbc_password => "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 => true
jdbc_page_size => "50000"

 

logstsh | logstash-input-jdbc 启动错误收集

原文:https://www.cnblogs.com/jj81/p/9456448.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!