All Apps and Add-ons

Splunk DB connect and Maria DB Connector

piotrgalas
Explorer

I am trying to define maria DB as "Other DB" per "Deploy and Use Splunk DB Connect" / "Install database drivers" docs guide.

Splunk DB Connect version is 3.10.
Here is the content of my db_connection_types.conf in the local folder

[mariadb] 
displayName = MariaDB
serviceClass = com.splunk.dbx2.DefaultDBX2JDBC
jdbcUrlFormat = jdbc:mariadb://<host>:<port>/<database>
jdbcUrlSSLFormat = jdbc:mariadb://<host>:<port>/<database>?useSSL=true
jdbcDriverClass = org.mariadb.jdbc.Driver
supportedVersions = 5.1 
port = 3306
ui_default_catalog = $database$
connection_properties = {"verifyServerCertificate":"false"}

Whenever I restart Splunk the DBX is not able to start correctly.
I believe that issue might be related to serviceClass. What should be the correct value?

0 Karma
1 Solution

Spranta
Communicator

Hi, had the same Problem but i was able to solve this by using the mysql.conf as template and simply changed the jdbcDriverClass.

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

View solution in original post

Spranta
Communicator

Hi, had the same Problem but i was able to solve this by using the mysql.conf as template and simply changed the jdbcDriverClass.

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

Get Updates on the Splunk Community!

New Cloud Intrusion Detection System Add-on for Splunk

In July 2022 Splunk released the Cloud IDS add-on which expanded Splunk capabilities in security and data ...

Happy CX Day to our Community Superheroes!

Happy 10th Birthday CX Day!What is CX Day? It’s a global celebration recognizing innovation and success in the ...

Check out This Month’s Brand new Splunk Lantern Articles

Splunk Lantern is a customer success center providing advice from Splunk experts on valuable data insights, ...