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

SierraX — Wed, 28 Apr 2021 10:17:45 GMT

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

topic Splunk DB Connect 3.5.1 and MariaDB 2.7.1: Catalog loads. Other queries fail. in All Apps and Add-ons

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