All Apps and Add-ons

Splunk DB Connect 3.5.1 and MariaDB 2.7.1: Catalog loads. Other queries fail.

SierraX
Communicator

Hi,

I own a OwnCloud Server with a MariaDB as Database:
My db_connection_types.conf based on the Post here from 2017, which has a few errors inside (missing Tokens, wrong supported Versions, serviceClass with MySQL...)

 

 

 

 

[mariadb]
displayName = MariaDB
serviceClass = com.splunk.dbx2.DefaultDBX2JDBC
jdbcUrlFormat = jdbc:mariadb://<host>:<port>/<database>
jdbcUrlSSLFormat = jdbc:mariadb://<host>:<port>/<database>?useSSL=true&requireSSL=true&verifyServerCertificate=false
jdbcDriverClass = org.mariadb.jdbc.Driver
supportedMajorVersion = 2
supportedMinorVersion = 7
port = 3306
testQuery = SELECT 1
ui_default_catalog = $database$

 

 

 

 

anyway.
I chose the driver mariadb-java-client-2.7.1.jar because DBeaver downloaded this Version automatically and there I can select my data.
With the db_connection_types.conf I can create a connection and receive the catalog. 
But in the SQL Explorer I receive every-time
a "Error in 'dbxquery' command: External search command exited unexpectedly with non-zero error code 1." 
also for very basic querys (like "select * form `d040ddbe`.`5zdza_share`). Tested with same result on jre1.8.0_291 and jdk-11.0.11.
Has someone a similar system running and could give me a few hints where I'm wrong?

Kind Regards
SierraX 

Labels (3)
0 Karma
Get Updates on the Splunk Community!

Registration for Splunk University is Now Open!

Are you ready for an adventure in learning?   Brace yourselves because Splunk University is back, and it's ...

Splunkbase | Splunk Dashboard Examples App for SimpleXML End of Life

The Splunk Dashboard Examples App for SimpleXML will reach end of support on Dec 19, 2024, after which no new ...

Understanding Generative AI Techniques and Their Application in Cybersecurity

Watch On-Demand Artificial intelligence is the talk of the town nowadays, with industries of all kinds ...