# Logstash jdbc\_static filter and MariaDB

**URL:** <https://discuss.elastic.co/t/logstash-jdbc-static-filter-and-mariadb/121734>\
**Category:** Logstash\
**Created:** [February 27, 2018, 8:51pm UTC](https://discuss.elastic.co/t/logstash-jdbc-static-filter-and-mariadb/121734 "2018-02-27T20:51:46Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![paulkeogh](https://avatars.discourse-cdn.com/v4/letter/p/8dc957/32.png) [@paulkeogh](https://discuss.elastic.co/u/paulkeogh)\
**Post date:** [February 27, 2018, 8:51pm UTC](https://discuss.elastic.co/t/logstash-jdbc-static-filter-and-mariadb/121734/1 "2018-02-27T20:51:46Z")

</div>

I can't get this to work; My filter config is;

```
    ..........
    jdbc_driver_class => "org.mariadb.jdbc.Driver"
    jdbc_driver_library => "C:\Users\paul\bitbucket\enrichment\drivers\mariadb-java-client-2.2.2.jar"
    jdbc_connection_string => "jdbc:mariadb://localhost:3306/disclosure"
    ...........

```

But I get an error on LS start-up of;

[2018-02-27T20:10:22,565][ERROR][logstash.pipeline] Pipeline aborted due to error {:pipeline\_id=\>"main", :exception=\>#\<LogStash::Filters::Jdbc::ConnectionJdbcException: Java::JavaSql::SQLException: No suitable driver found for jdbc:mariadb://localhost:3306/disclosure\>, :backtrace=\>["java.sql.DriverManager.getConnection(java/sql/DriverManager.java:689)", "java.sql.DriverManager.getConnection(java/sql/DriverManager.java:247)"

OS is Windows 10 - any suggestions ?

---

<div class="post-metadata">

**Author:** ![istvanszoboszlai](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/istvanszoboszlai/32/47750_2.png) [@istvanszoboszlai](https://discuss.elastic.co/u/istvanszoboszlai)\
**Post date:** [March 21, 2018, 3:57pm UTC](https://discuss.elastic.co/t/logstash-jdbc-static-filter-and-mariadb/121734/2 "2018-03-21T15:57:12Z")

</div>

Same problem with me for Logstash 6.2.3  
Worked before with 5.2.2

---

<div class="post-metadata">

**Author:** ![zino](https://avatars.discourse-cdn.com/v4/letter/z/d07c76/32.png) [@zino](https://discuss.elastic.co/u/zino)\
**Post date:** [March 22, 2018, 3:54pm UTC](https://discuss.elastic.co/t/logstash-jdbc-static-filter-and-mariadb/121734/3 "2018-03-22T15:54:54Z")

</div>

Same problem

---

<div class="post-metadata">

**Author:** ![guyboertje](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/guyboertje/32/31592_2.png) [@guyboertje](https://discuss.elastic.co/u/guyboertje)\
**Post date:** [March 27, 2018, 9:46pm UTC](https://discuss.elastic.co/t/logstash-jdbc-static-filter-and-mariadb/121734/4 "2018-03-27T21:46:58Z")

</div>

As I understand it, some changes to Logstash 6.X and the Java class loading causes this.

---

<div class="post-metadata">

**Author:** ![guyboertje](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/guyboertje/32/31592_2.png) [@guyboertje](https://discuss.elastic.co/u/guyboertje)\
**Post date:** [March 27, 2018, 9:47pm UTC](https://discuss.elastic.co/t/logstash-jdbc-static-filter-and-mariadb/121734/5 "2018-03-27T21:47:49Z")

</div>

We have a change in PR review that fixes this in LS 6.2+

---

<div class="post-metadata">

**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:** [March 28, 2018, 12:53am UTC](https://discuss.elastic.co/t/logstash-jdbc-static-filter-and-mariadb/121734/6 "2018-03-28T00:53:00Z")

</div>

Can we have a link please?

---

<div class="post-metadata">

**Author:** ![guyboertje](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/guyboertje/32/31592_2.png) [@guyboertje](https://discuss.elastic.co/u/guyboertje)\
**Post date:** [March 28, 2018, 4:26pm UTC](https://discuss.elastic.co/t/logstash-jdbc-static-filter-and-mariadb/121734/7 "2018-03-28T16:26:05Z")

</div>

> <https://github.com/logstash-plugins/logstash-filter-jdbc_static/pull/19>

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [April 25, 2018, 4:32pm UTC](https://discuss.elastic.co/t/logstash-jdbc-static-filter-and-mariadb/121734/8 "2018-04-25T16:32:06Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.