LogStash :: ConfigurationError:com.mysql.jdbc.Driver未加载 [英] LogStash::ConfigurationError: com.mysql.jdbc.Driver not loaded

问题描述

当我使用 logstash_input_jdbc 插件同步MySQL和本地弹性搜索时，

When I use the logstash_input_jdbc plugin sync MySQL and my local elastic search,

出现以下错误，但是我搜索了很长时间，但是到目前为止我还没有解决方法.

The below errors appear, But I search for a long time, but I have no resolve method until now.

./logstash -f ./logstash_jdbc_test/jdbc.conf由于错误{:exception =>#，管道中止了，:backtrace => ["/usr/local/logstash/vendor/bundle/jruby/1.9/gems/logstash-input-jdbc-3.0.2/lib/logstash/plugin_mixins/jdbc.rb:156:in prepare_jdbc_connection'，"/usr/local/logstash/vendor/bundle/jruby/1.9/gems/logstash-input-jdbc-3.0.2/lib/logstash/inputs/jdbc.rb:167:in注册'，"/usr/local/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.3.2-java/lib/logstash/pipeline.rb:330:in start_inputs'，" org/jruby/RubyArray.java:1613:in each'，"/usr/local/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.3.2-java/lib/logstash/pipeline.rb:329:in start_inputs'，"/usr/local/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.3.2-java/lib/logstash/pipeline.rb:180:in start_workers'"，"/usr/local/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.3.2-java/lib/logstash/pipeline.rb:136:in run'，"/usr/local/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.3.2-java/lib/logstash/agent.rb:465:in start_pipeline']，:level =>:error}

./logstash -f ./logstash_jdbc_test/jdbc.conf Pipeline aborted due to error {:exception=>#, :backtrace=>["/usr/local/logstash/vendor/bundle/jruby/1.9/gems/logstash-input-jdbc-3.0.2/lib/logstash/plugin_mixins/jdbc.rb:156:in prepare_jdbc_connection'", "/usr/local/logstash/vendor/bundle/jruby/1.9/gems/logstash-input-jdbc-3.0.2/lib/logstash/inputs/jdbc.rb:167:in register'", "/usr/local/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.3.2-java/lib/logstash/pipeline.rb:330:in start_inputs'", "org/jruby/RubyArray.java:1613:ineach'", "/usr/local/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.3.2-java/lib/logstash/pipeline.rb:329:in start_inputs'", "/usr/local/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.3.2-java/lib/logstash/pipeline.rb:180:in start_workers'", "/usr/local/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.3.2-java/lib/logstash/pipeline.rb:136:in run'", "/usr/local/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.3.2-java/lib/logstash/agent.rb:465:in start_pipeline'"], :level=>:error}

推荐答案

昨天，我找到了原因.原因是:在我的安装路径/elasticsearch-jdbc-2.3.2.0/lib中，mysql-connector-java-5.1.38.jar的大小为零.因此，我下载了新的mysql-connector-java-5.1.38.jar，并复制到/elasticsearch-jdbc-2.3.2.0/lib的路径.然后，我的问题解决了.

Yesterday, I find the reason. The reason is: In my install path /elasticsearch-jdbc-2.3.2.0/lib, the size of mysql-connector-java-5.1.38.jar is zero. So I download the new mysql-connector-java-5.1.38.jar, and copy to the path of /elasticsearch-jdbc-2.3.2.0/lib. And then, my problem resolved.

现在我可以在mysql和elaticsearch之间快速同步日期了.

Now I can sync date between mysql and elaticsearch quickly.

这篇关于LogStash :: ConfigurationError:com.mysql.jdbc.Driver未加载的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！