All Apps and Add-ons

issue with using mysql-connector-java-5.0.8-bin.jar for dbconnect 2.30

cdo_splunk
Splunk Employee
Splunk Employee

issue with using mysql-connector-java-5.0.8-bin.jar for dbconnect 2.30
restarted the splunk daemon but it still says "com.mysql.jdbc.Driver is not installed" for the MySQL drivers as shown in db connect - settings - drivers section

Tags (1)
0 Karma

cdo_splunk
Splunk Employee
Splunk Employee

1) download file mysql-connector-java-5.1.39.tar.gz from the official MySQL
downloads
2) unpack the file using tar xzf mysql-connector-java-5.1.39.tar.gz
3) change into unpacked directory - cd mysql-connector-java-5.1.39
4) locate the jar file mysql-connector-java-5.1.39-bin.jar
5) copy this jar file into directory /opt/splunk/etc/apps/splunk_app_db_connect/bin/lib on the index server
6) make sure to set ownership and permissions - chown splunk:splunk /opt/splunk/etc/apps/splunk_app_db_connect/bin/lib/mysql-connector-java-5.1.39-bin.jar - chmod 755 /opt/splunk/etc/apps/splunk_app_db_connect/bin/lib/mysql-connector-java-5.1.39-bin.jar
7) add in CLASSPATH into splunk user .bash_profile which is located in /opt/splunk/.bash_profile
CLASSPATH="/opt/splunk/etc/apps/splunk_app_db_connect/bin/lib/mysql-connector-java-5.1.39-bin.jar"
export CLASSPATH
8) restart the splunk daemon

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, ...