topic Re: Splunk DB Connect - MySQL Connection in Deployment Architecture

Splunk DB Connect - MySQL Connection

wagnerbianchi — Mon, 28 Sep 2020 13:10:44 GMT

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.

Re: Splunk DB Connect - MySQL Connection

jspears — Thu, 24 Jan 2013 16:08:14 GMT

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

Re: Splunk DB Connect - MySQL Connection

wagnerbianchi — Thu, 24 Jan 2013 16:28:47 GMT

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!

Re: Splunk DB Connect - MySQL Connection

wagnerbianchi — Thu, 24 Jan 2013 16:29:13 GMT

=> 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!