# Mysql schema logs push to logstash **URL:** \ **Category:** Logstash\ **Created:** [February 11, 2021, 12:40pm UTC](https://discuss.elastic.co/t/mysql-schema-logs-push-to-logstash/264016 "2021-02-11T12:40:54Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![psganeshk](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/psganeshk/32/79059_2.png) [@psganeshk](https://discuss.elastic.co/u/psganeshk)\ **Post date:** [February 11, 2021, 12:40pm UTC](https://discuss.elastic.co/t/mysql-schema-logs-push-to-logstash/264016/1 "2021-02-11T12:40:54Z")
Logstash config file '' input { jdbc { clean\_run =\> true jdbc\_validate\_connection =\> true jdbc\_driver\_library =\> 'C:\Program Files (x86)\MySQL\Connector J 8 0\mysql-connector-java-8.0.22.jar' jdbc\_driver\_class =\> "com.mysql.jdbc.Driver" jdbc\_connection\_string =\> "jdbc:mysql://192.168.10.25:3306/jobschema" jdbc\_user =\> "root" jdbc\_password =\> "Password@123" #parameters =\> { "favorite\_artist" =\> "Beethoven" } schedule =\> "\* \* \* \* \*" statement =\> "SELECT jobid,jobname,executiontime,jobstatus from logstashplugin WHERE jobid \> :sql\_last\_value" use\_column\_value =\> true tracking\_column =\> "jobid" #sincedb\_path =\> "NULL" } } ---
**Author:** ![psganeshk](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/psganeshk/32/79059_2.png) [@psganeshk](https://discuss.elastic.co/u/psganeshk)\ **Post date:** [February 11, 2021, 12:46pm UTC](https://discuss.elastic.co/t/mysql-schema-logs-push-to-logstash/264016/2 "2021-02-11T12:46:33Z")
Please find error log Error: unable to load C:\Program Files (x86)\MySQL\Connector J 8 0\mysql-connector-java-8.0.22.jar from :jdbc\_driver\_library, file not readable (please check user and group permissions for the path) Exception: LogStash::PluginLoadingError Stack: /usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/logstash-integration-jdbc-5.0.6/lib/logstash/plugin\_mixins/jdbc/common.rb:47:in `block in load_driver_jars' org/jruby/RubyArray.java:1809:in `each' /usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/logstash-integration-jdbc-5.0.6/lib/logstash/plugin\_mixins/jdbc/common.rb:42:in `load_driver_jars' /usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/logstash-integration-jdbc-5.0.6/lib/logstash/plugin_mixins/jdbc/common.rb:25:in `load\_driver' /usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/logstash-integration-jdbc-5.0.6/lib/logstash/inputs/jdbc.rb:275:in `run' /usr/share/logstash/logstash-core/lib/logstash/java_pipeline.rb:405:in `inputworker' /usr/share/logstash/logstash-core/lib/logstash/java\_pipeline.rb:396:in `block in start_input' [ERROR] 2021-02-11 18:03:03.184 [[main]"root", use_column_value=>true, tracking_column=>"jobid", schedule=>"* * * * *", jdbc_validate_connection=>true, jdbc_password=>, statement=>"SELECT jobid,jobname,executiontime,jobstatus from logstashplugin WHERE jobid > :sql_last_value", clean_run=>true, jdbc_driver_library=>"C:\\Program Files (x86)\\MySQL\\Connector J 8 0\\mysql-connector-java-8.0.22.jar", jdbc_connection_string=>"jdbc:mysql://192.168.10.25:3306/jobschema", id=>"57f7c5b7c715e23fe1716eb61c597650bcc52b9f8d3af4248b0f8d4c36f6ac0a", jdbc_driver_class=>"com.mysql.jdbc.Driver", enable_metric=>true, codec=>"plain_a5f66d68-9552-4234-b844-8eca786ef4f2", enable_metric=>true, charset=>"UTF-8">, jdbc_paging_enabled=>false, jdbc_page_size=>100000, jdbc_validation_timeout=>3600, jdbc_pool_timeout=>5, sql_log_level=>"info", connection_retry_attempts=>1, connection_retry_attempts_wait_time=>0.5, plugin_timezone=>"utc", last_run_metadata_path=>"/root/.logstash_jdbc_last_run", tracking_column_type=>"numeric", record_last_run=>true, lowercase_column_names=>true, use_prepared_statements=>false> Error: unable to load C:\Program Files (x86)\MySQL\Connector J 8 0\mysql-connector-java-8.0.22.jar from :jdbc_driver_library, file not readable (please check user and group permissions for the path) Exception: LogStash::PluginLoadingError Stack: /usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/logstash-integration-jdbc-5.0.6/lib/logstash/plugin_mixins/jdbc/common.rb:47:in `block in load\_driver\_jars' org/jruby/RubyArray.java:1809:in `each' /usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/logstash-integration-jdbc-5.0.6/lib/logstash/plugin_mixins/jdbc/common.rb:42:in `load\_driver\_jars' /usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/logstash-integration-jdbc-5.0.6/lib/logstash/plugin\_mixins/jdbc/common.rb:25:in `load_driver' /usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/logstash-integration-jdbc-5.0.6/lib/logstash/inputs/jdbc.rb:275:in `run' /usr/share/logstash/logstash-core/lib/logstash/java\_pipeline.rb:405:in `inputworker' ---
**Author:** ![Badger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/badger/32/25190_2.png) [@Badger](https://discuss.elastic.co/u/Badger)\ **Post date:** [February 11, 2021, 7:59pm UTC](https://discuss.elastic.co/t/mysql-schema-logs-push-to-logstash/264016/3 "2021-02-11T19:59:19Z")
> [@psganeshk](#): > > Error: unable to load C:\Program Files (x86)\MySQL\Connector J 8 0\mysql-connector-java-8.0.22.jar from :jdbc\_driver\_library, file not readable (please check user and group permissions for the path) That seems clear enough. Check whether the user running logstash has permission on each component of that path. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [March 11, 2021, 7:59pm UTC](https://discuss.elastic.co/t/mysql-schema-logs-push-to-logstash/264016/4 "2021-03-11T19:59:20Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.