# Facing issue while starting logstash which connects with Maria Database **URL:** \ **Category:** Logstash\ **Tags:** docker\ **Created:** [September 27, 2022, 6:17am UTC](https://discuss.elastic.co/t/facing-issue-while-starting-logstash-which-connects-with-maria-database/315233 "2022-09-27T06:17:54Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![nawaz462](https://avatars.discourse-cdn.com/v4/letter/n/b5ac83/32.png) [@nawaz462](https://discuss.elastic.co/u/nawaz462)\ **Post date:** [September 27, 2022, 6:17am UTC](https://discuss.elastic.co/t/facing-issue-while-starting-logstash-which-connects-with-maria-database/315233/1 "2022-09-27T06:17:54Z")
## On linux server, i wanted to have ELK setup with MariaDB through Docker. I want to setup the Elastic search data with indexes for the maria DB tables from scratch and as well as for incremental changes sync. These are docker processes running on my server CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES 7a915c230e6f mariadb:10.4 "docker-entrypoint.s…" 11 days ago Up 11 days 3306/tcp, 0.0.0.0:3309-\>3309/tcp, :::3309-\>3309/tcp sem\_mariadb 205acbe6e117 [docker.elastic.co/kibana/kibana:7.9.3](http://docker.elastic.co/kibana/kibana:7.9.3) "/usr/local/bin/dumb…" 11 days ago Up 11 days 0.0.0.0:5601-\>5601/tcp, :::5601-\>5601/tcp sem\_kibana 5f582d9756cc [docker.elastic.co/elasticsearch/elasticsearch:7.9.3](http://docker.elastic.co/elasticsearch/elasticsearch:7.9.3) "/tini -- /usr/local…" 11 days ago Up 11 days 9200/tcp, 9300/tcp sem\_elasticsearch * * * When i start the logstash, i was getting this error sem\_logstash | Pipeline\_id:from-scratch-pipeline sem\_logstash | Plugin: \"root", jdbc\_password=\>, statement\_filepath=\>"/usr/share/logstash/config/queries/mariadb-scratch.sql", clean\_run=\>true, jdbc\_driver\_library=\>"/usr/share/logstash/pipeline/mariadb-java-client-2.4.2.jar", jdbc\_connection\_string=\>"jdbc:mariadb://localhost:3309/test\_database", sql\_log\_level=\>"debug", id=\>"4ce7641f8234f6b2c0618ef2d020b4774d759ce77be017c475514b12f77b020e", jdbc\_driver\_class=\>"Java::org.mariadb.jdbc.Driver", record\_last\_run=\>false, enable\_metric=\>true, codec=\>\"plain\_13495cfd-1407-4aa5-be35-49f82908a0fe", enable\_metric=\>true, charset=\>"UTF-8"\>, jdbc\_paging\_enabled=\>false, jdbc\_page\_size=\>100000, jdbc\_validate\_connection=\>false, jdbc\_validation\_timeout=\>3600, jdbc\_pool\_timeout=\>5, connection\_retry\_attempts=\>1, connection\_retry\_attempts\_wait\_time=\>0.5, plugin\_timezone=\>"utc", last\_run\_metadata\_path=\>"/usr/share/logstash/.logstash\_jdbc\_last\_run", use\_column\_value=\>false, tracking\_column\_type=\>"numeric", lowercase\_column\_names=\>true, use\_prepared\_statements=\>false\> sem\_logstash | Error: unable to load /usr/share/logstash/pipeline/mariadb-java-client-2.4.2.jar from :jdbc\_driver\_library, file not readable (please check user and group permissions for the path) sem\_logstash | Exception: LogStash::PluginLoadingError sem\_logstash | 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' sem_logstash | org/jruby/RubyArray.java:1809:in `each' sem\_logstash | /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' sem_logstash | /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' sem\_logstash | /usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/logstash-integration-jdbc-5.0.6/lib/logstash/inputs/jdbc.rb:275:in `run' sem_logstash | /usr/share/logstash/logstash-core/lib/logstash/java_pipeline.rb:405:in `inputworker' sem\_logstash | /usr/share/logstash/logstash-core/lib/logstash/java\_pipeline.rb:396:in `block in start\_input' sem\_logstash | [2022-09-27T06:11:12,967][ERROR][logstash.javapipeline][from-scratch-pipeline][4ce7641f8234f6b2c0618ef2d020b4774d759ce77be017c475514b12f77b020e] A plugin had an unrecoverable error. Will restart this plugin. * * * File : mariadb-scratch.conf input { jdbc { jdbc\_driver\_library =\> "/usr/share/logstash/pipeline/mariadb-java-client-2.4.2.jar" jdbc\_driver\_class =\> "Java::org.mariadb.jdbc.Driver" jdbc\_connection\_string =\> "jdbc:mariadb://localhost:3309/test\_database" jdbc\_user =\> "root" jdbc\_password =\> "root" sql\_log\_level =\> "debug" # Set Logstash logging level as this clean\_run =\> true # Set to true for indexing from scratch record\_last\_run =\> false statement\_filepath =\> "/usr/share/logstash/config/queries/mariadb-scratch.sql" } } output { # stdout { codec =\> rubydebug { metadata =\> true } } elasticsearch { hosts =\> ["[http://elasticsearch:9200](http://elasticsearch:9200)"] index =\> "mariadb-%{+YYYY.MM}" } } * * * Even i have tried to change this path and placed the file in a folder and pointed to it with owner logstash. jdbc\_driver\_library =\> "/usr/share/logstash/pipeline/mariadb-java-client-2.4.2.jar" But no luck. Can someone help me on resolving this issue ---
**Author:** ![Rios](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rios/32/95745_2.png) [@Rios](https://discuss.elastic.co/u/Rios)\ **Post date:** [September 27, 2022, 11:11am UTC](https://discuss.elastic.co/t/facing-issue-while-starting-logstash-which-connects-with-maria-database/315233/2 "2022-09-27T11:11:32Z")
> [@nawaz462](#): > > Error: unable to load /usr/share/logstash/pipeline/mariadb-java-client-2.4.2.jar from :jdbc\_driver\_library, file not readable (please check user and group permissions for the path) > sem\_logstash | Exception: LogStash::PluginLoadingError Check [this](https://stackoverflow.com/questions/59250301/jdbc-driver-not-loaded-while-using-logstash-in-docker) and [this](https://github.com/elastic/logstash/issues/10983). ---
**Author:** ![nawaz462](https://avatars.discourse-cdn.com/v4/letter/n/b5ac83/32.png) [@nawaz462](https://discuss.elastic.co/u/nawaz462)\ **Post date:** [October 6, 2022, 8:25am UTC](https://discuss.elastic.co/t/facing-issue-while-starting-logstash-which-connects-with-maria-database/315233/3 "2022-10-06T08:25:23Z")
This solution didn't work. Tried to do the same.. but now i was facing issue with library decleration sem\_logstash | /usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/logstash-integration-jdbc-5.0.6/lib/logstash/inputs/jdbc.rb:275:in `run' sem_logstash | /usr/share/logstash/logstash-core/lib/logstash/java_pipeline.rb:405:in `inputworker' sem\_logstash | /usr/share/logstash/logstash-core/lib/logstash/java\_pipeline.rb:396:in `block in start_input' sem_logstash | [2022-10-06T07:57:48,427][ERROR][logstash.javapipeline][from-scratch-pipeline][bdc69c89eb98abb7ecf1b992d5fdb3731585749ae6deb75d72f12a96a2c6261c] A plugin had an unrecoverable error. Will restart this plugin. sem_logstash | Pipeline_id:from-scratch-pipeline sem_logstash | Plugin: "root", jdbc_password=>, statement_filepath=>"/usr/share/logstash/config/queries/mariadb-scratch.sql", clean_run=>true, jdbc_connection_string=>"jdbc:mariadb://localhost:3309/test_database", sql_log_level=>"debug", id=>"bdc69c89eb98abb7ecf1b992d5fdb3731585749ae6deb75d72f12a96a2c6261c", jdbc_driver_class=>"Java::org.mariadb.jdbc.Driver", record_last_run=>false, enable_metric=>true, codec=>"plain_2c4a60cb-f54d-4476-8173-7ccaca064adb", enable_metric=>true, charset=>"UTF-8">, jdbc_paging_enabled=>false, jdbc_page_size=>100000, jdbc_validate_connection=>false, jdbc_validation_timeout=>3600, jdbc_pool_timeout=>5, connection_retry_attempts=>1, connection_retry_attempts_wait_time=>0.5, plugin_timezone=>"utc", last_run_metadata_path=>"/usr/share/logstash/.logstash_jdbc_last_run", use_column_value=>false, tracking_column_type=>"numeric", lowercase_column_names=>true, use_prepared_statements=>false> sem_logstash | Error: Java::org.mariadb.jdbc.Driver not loaded. :jdbc_driver_library is not set, are you sure you included the proper driver client libraries in your classpath? sem_logstash | Exception: LogStash::PluginLoadingError sem_logstash | Stack: /usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/logstash-integration-jdbc-5.0.6/lib/logstash/plugin_mixins/jdbc/common.rb:36:in `load\_driver' sem\_logstash | /usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/logstash-integration-jdbc-5.0.6/lib/logstash/inputs/jdbc.rb:275:in `run' sem_logstash | /usr/share/logstash/logstash-core/lib/logstash/java_pipeline.rb:405:in `inputworker' sem\_logstash | /usr/share/logstash/logstash-core/lib/logstash/java\_pipeline.rb:396:in `block in start\_input' ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [November 3, 2022, 8:25am UTC](https://discuss.elastic.co/t/facing-issue-while-starting-logstash-which-connects-with-maria-database/315233/4 "2022-11-03T08:25:45Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.