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