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
Did you miss .conf21 Virtual?

Good news! The event's keynotes and many of its breakout sessions are now available online, and still totally FREE!