App DB Connect - Setting Up My Testing Env - 2. Installing DB Connect

Applicability

DB Connect

Description

Troubleshooting guide for Splunk DBConnect errors 

Investigation

1. Pre-requisites:
            a. Splunk Enterprise 6.4.0 or later, running on a supported operating system.
            b. Java Platform, Java Runtime Environment (JRE) 8 from Java Platform, Standard Edition.

$sudo yum install java-1.8.0-openjdk

            if Java is already installed make sure the user that is running Splunk has permission to that folder
            c. A supported database running locally or elsewhere on your network.
                 (Which we have created on the previous article)
In case of ERROR:

"{'message': 'Unsupported JRE detected', 'jre_using': 'Using Red Hat, Inc. JRE version 1.8, OpenJDK 64-Bit Server VM', 'jre_need': 'Need Oracle Corporation JRE version 11+ or OpenJDK 11+'} validate java command: /bin/java."

a. Issue with JRE_VENDOR_KEY value.

$nano /opt/splunk/etc/apps/splunk_app_db_connect/bin/dbx2/C.py
old: JRE_VENDOR_KEY='java.vendor'
new: JRE_VENDOR_KEY='java.specification.vendor'

b. Install a supported version of JRE. 

$java -version                                             <----- Verify version. 
$sudo yum install java-11-openjdk
$sudo update-alternatives --config java
&java -version                                             <----- Verify version was successfully changed. 

2. Download and install the DB Connect add-on. Remember to point to the JRE installation path in Configuration, Settings, General if needed.
 
3. Install a JDBC driver for your database:
    a. choose your db
   DeployDBX Install data basedrivers

•    In our case we choose MySQL Connector/
•    Choose Platform Independent
•    Un-tar or open the document.
•    pick the jar file mysql-connector-java-8.0.13.jar"
•    place that driver in $SPLUNK_HOME/etc/apps/splunk_app_db_connect/drivers/ you can use FileZilla

 
4. Confirm DB connect detects the driver:
Splunk DB Connect > Configuration > Settings > Drivers
5. Create an identity

Splunk DB Connect > Configuration > Identities > New Identity
-Identity Name: the name of this identity
-Username: Naty              -----> your MySQL user
-password: Mypass!23     ---->your MySQL password
 

6. Set up a database connection:
Splunk DB Connect > Configuration > Connection > New Connectoin

Connection Name    ---> you give a name to this connection
Identity: Naty
Connection Type: MySQL
Host:   ----> put here the URL for your instance (no need to use http or https)
Port: 3306    ----> populated by default, MySQL uses 3306
Default Database: logs

If there is something wrong with the connection Splunk will give an error.

Related Links

Splunk Documentation:

Installation and setup overview
DeployDBX Checklist
App DB Connect - Setting Up My Testing Env - 1. How To Install MySQL

Revision History

Revision	Publish Date	Comments
1.0	29-Sep-2026	Initial Release