Deployment Architecture

Splunk DB Connect - MySQL Connection

wagnerbianchi
Splunk Employee
Splunk Employee

Hi friends,

I am trying to set up a connection between Splunk and MySQL, both running in the same machine (local machine) and I am getting this error after filling up all configuration fields and push "Fetch Database Names" button:

ERROR com.splunk.config.SplunkConfigurationException: JDBC driver (com.mysql.jdbc.Driver) for database type MySQL is not installed

Cheking the JRE I have installed:

wagnerbianchi:Home root# bin/java -version
java version "1.6.0_37"
Java(TM) SE Runtime Environment (build 1.6.0_37-b06-434-11M3909)
Java HotSpot(TM) 64-Bit Server VM (build 20.12-b01-434, mixed mode)

Is this error regarding MySQL J/Connector? Someone could help me to solve this problem?

Thank you.

Tags (1)
0 Karma

wagnerbianchi
Splunk Employee
Splunk Employee

just to document all steps I am taking toward this Splunk DB Connect installation, I found reasearching the internet this manual to install MySQL Connector J on Mac and evt is alright with the set up.

=> http://www.yaldex.com/mysql_tutorial_2/ch09lev1sec1.html

After to download and copy the connector .jar file to /System/Library/Frameworks/JavaVM.framework/Versions/1.6.0/Home/lib/ext , Splunk DB Connect is running well.

Thanks everyone!

0 Karma

jspears
Communicator

Yes, you need to install J/Connector. From the docs: http://docs.splunk.com/Documentation/DBX/latest/DeployDBX/Installdrivers

wagnerbianchi
Splunk Employee
Splunk Employee

just to document all steps I am taking toward this Splunk DB Connect installation, I found reasearching the internet this manual to install MySQL Connector J on Mac and evt is alright with the set up.

=> http://www.yaldex.com/mysql_tutorial_2/ch09lev1sec1.html

After to download and copy the connector .jar file to /System/Library/Frameworks/JavaVM.framework/Versions/1.6.0/Home/lib/ext , Splunk DB Connect is running well.

Thanks everyone!

0 Karma
Get Updates on the Splunk Community!

Leveraging Automated Threat Analysis Across the Splunk Ecosystem

Enhance Security Operations with Automated Threat Analysis in the Splunk EcosystemAre you leveraging ...

Splunk Developers: Go Beyond the Dashboard with These .Conf25 Sessions

  Whether you’re building custom apps, diving into SPL2, or integrating AI and machine learning into your ...

Index This | How do you write 23 only using the number 2?

July 2025 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with this month’s ...