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
Path Finder

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
Path Finder

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