logstash-input-jdbc | Logstash Plugin for JDBC Inputs | Plugin library

This has been an issue with logstash-filter-jdbc_static for a while now. You need to move your .jar to /logstash-core/lib/jars/ directory. And specify the .jar location in your config as "".

See below for more details: https://github.com/logstash-plugins/logstash-filter-jdbc_static/issues/47

So I post this in case someone had the same problem as me. I found the solution: So the first thing is to use MariaDB instead of MySQL, it seems that there are a lot of bugs for MySQL and logstash. I also created a user instead of connecting as root (this will imply changes to the logstash.conf file) my docker-compose.yml target for my MariaDB is as the following

Same issue here.

I use the workaround from here with this and it works.

ie:

Copy the driver file to {logstash install dir}/logstash-core/lib/jars/ directory. These jars get added to the correct JDK classpath as logstash is started via java.

And

Change the jdbc_driver_library value in the logstash conf to "". i.e.: jdbc_driver_library => "" as well, otherwise the code still tries to load the jar separately

You have to download JDBC driver by yourself. Go to this website and download appropriate driver for your database and then put it somewhere in your EC2. Then you just have to specify path to the downloaded driver in this field jdbc_driver_library and you're good to go.

Rewriting the whole connection string worked after a few tweaks. At the time of the issue a few drivers references I found within x-pack were referencing the wrong driver if memory serves and needed changing.

logstash config file : (corrected)

I simply made a custom bit of .NET coding to do the job rather than hooking them together like the official documentation suggests (badly).

I highly recommend everyone else do the same to save yourself the time I lost.

I have got a answer for that question: make one file in root directory called event.sh and following code in that file

event.sh

First you must install the logstash input plugin by running

bin/logstash-plugin install logstash-input-jdbc

And also If it does not help, try

Java::com.mysql.jdbc.Driver

instead of the

com.mysql.jdbc.Driver

for the jdbc_driver_class. I had a same kind of problem with oracle when I did not use the

Java::

before the oracle.jdbc.OracleDriver as the jdbc_driver_class.