Splunk DB Connect: What is wrong with my SQL syntax to MySQL database that db monitor fails validation?

benjaminlin1019 — Wed, 08 Oct 2014 21:56:44 GMT

Is there anyone can tell me what's wrong with my SQL syntax to MySQL database is wrong that db monitor can't be saved.

SELECT * FROM database_name.mytext_table_name WHERE MATCH(mytext) AGAINST('some key words' IN BOOLEAN MODE) {{AND $rising_column$ > ? }}

Although I dump MySQL datetime column with these setting:
Timestamp column: textdate
format: yyyy-MM-dd HH:mm:ss

cron interval

0,5,10,15,20,25,30,35,40,45,50,55 * * * *

also why */5 * * * * doesn't work either?

Re: Splunk DB Connect: What is wrong with my SQL syntax to MySQL database that db monitor fails validation?

benjaminlin1019 — Wed, 08 Oct 2014 22:28:24 GMT

Ok answer myself I know the problem is that we are using MariaDB 10 which is compatible with MySQL 5.6 and in the new version, they removed "SET OPTION" command in MySQL...gosh https://mariadb.atlassian.net/browse/MDEV-6201

but it can be resolved by using latest Java Connector however, we have trouble to use latest Java Connector

topic Re: Splunk DB Connect: What is wrong with my SQL syntax to MySQL database that db monitor fails validation? in Splunk Search

Splunk DB Connect: What is wrong with my SQL syntax to MySQL database that db monitor fails validation?

Re: Splunk DB Connect: What is wrong with my SQL syntax to MySQL database that db monitor fails validation?