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
Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.
Get Updates on the Splunk Community!

Tech Talk Recap | Mastering Threat Hunting

Mastering Threat HuntingDive into the world of threat hunting, exploring the key differences between ...

Observability for AI Applications: Troubleshooting Latency

If you’re working with proprietary company data, you’re probably going to have a locally hosted LLM or many ...

Splunk AI Assistant for SPL vs. ChatGPT: Which One is Better?

In the age of AI, every tool promises to make our lives easier. From summarizing content to writing code, ...