logstash-input-jdbc: “Unknown setting 'jdbc_driver_libary' for jdbc {:level=>:error}”
<p>I try to access to MySQL service with logstash. I installed logstash-input-jdbc (<strong>/opt/logstash/bin/logstash-plugin install logstash-input-jdbc</strong>) and created <strong>/etc/logstash/conf.d/sample.conf</strong>:</p>

<pre><code>input{
 lumberjack{
 ...
 }
 jdbc{
        type =&gt; "jdbc_hfc"
        jdbc_connection_string =&gt; "jdbc:mysql://127.0.0.1:3306/test"
        jdbc_user =&gt; "root"
        jdbc_password =&gt; ""
        jdbc_validate_connection =&gt; true
        jdbc_driver_libary =&gt; "mysql-connector-java-5.1.40-bin.jar"
        jdbc_driver_class =&gt; "com.mysql.jdbc.Driver"
        statement =&gt; "SELECT * FROM hfc"
        schedule =&gt; "00 07 * * *"
 }
 file{
 ...
 }
}
output{
  if [type] == "jdbc_hfc"
  {
    elasticsearch{
        protocl =&gt; http
        hosts =&gt; ["localhost:9200"]
        index =&gt; "logstash-jdbc-hfc-%{+YYYY.MM.dd}"
    }
  }
}
</code></pre>

<p>When I excute the configtest (<strong>/opt/logstash/bin/logstash --configtest -f /etc/logstash/conf.d/sample.conf</strong>), I get the next error:</p>

<pre><code>Unknown setting 'jdbc_driver_libary' for jdbc {:level=&gt;:error}
The given configuration is invalid. Reason: Something is wrong with your configuration. {:level=&gt;:fatal}
</code></pre>

<p>When I comment the jdbc_connection_string line, the configtest returns:</p>

<pre><code>Configuration OK
</code></pre>

<p>But when I executed the sample.conf file, logstash retruns me the next error:</p>

<pre><code>Pipeline aborted due to error {:exception=&gt;"LogStash::ConfigurationError", :backtrace=&gt;["/opt/logstash/vendor/bundle/jruby/1.9/gems/logstash-input-jdbc-4.1.1/lib/logstash/plugin_mixins/jdbc.rb:159:in `prepare_jdbc_connection'", "/opt/logstash/vendor/bundle/jruby/1.9/gems/logstash-input-jdbc-4.1.1/lib/logstash/inputs/jdbc.rb:187:in `register'", "/opt/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.4.0-java/lib/logstash/pipeline.rb:330:in `start_inputs'", "org/jruby/RubyArray.java:1613:in `each'", "/opt/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.4.0-java/lib/logstash/pipeline.rb:329:in `start_inputs'", "/opt/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.4.0-java/lib/logstash/pipeline.rb:180:in `start_workers'", "/opt/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.4.0-java/lib/logstash/pipeline.rb:136:in `run'", "/opt/logstash/vendor/bundle/jruby/1.9/gems/logstash-core-2.4.0-java/lib/logstash/agent.rb:491:in `start_pipeline'"], :level=&gt;:error}
</code></pre>

<p>Where is my mistake? What can I do to resolve this problem?</p>

<p>Thanks a lot and best regards.</p>

<p>PD: If you need more information please, ask me.</p>