With logstash I am trying to Extract some tables, Transform them locally on the logstash mashine, and then Load the result to Elasticsearch. The reason for this solution is due to very limited computing power on the source server, a MariaDB. I have tested the input{} separately, it works, so the c…

I got to change the setting on our own mariaDB database to sql_mode = 'ANSI_QUOTES' and then the jdbc_static script works on our own setup

Discuss the Elastic Stack

Jdbc_static: Getting a sql syntax error I did'nt write

Elastic Stack Logstash

Badger July 3, 2019, 1:18pm 3

Does this help?

Topic		Replies	Views
Issue with jdbc for mariadb Logstash	7	2830	February 21, 2018
Logstash jdbc_static filter and MariaDB Logstash	7	976	April 25, 2018
Jdbc mariadb works in logstash 6.8, but not in logstash 7.5 Logstash	3	1546	January 10, 2020
Include session variables in the connection string for jdbc_static fails Logstash jdbc	2	437	December 21, 2022
Logstash - MariaDB to ElasticSearch - No Error, but doesnt load Logstash	3	2062	August 28, 2017

Elasticsearch is a trademark of Elasticsearch BV, registered in the U.S. and in other countries
Trademarks
Terms
Privacy
Brand
Code of Conduct

Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant logo are trademarks of the Apache Software Foundation in the United States and/or other countries.

Jdbc_static: Getting a sql syntax error I did'nt write

Related topics