Splunk DB Connect App | MySQL Splunk DB Connect Configuration

#Splunk,#SplunkDB,#SplunkTutorial Hello Friends, Welcome back to my channel. We are here with another tutorial on splunk. Today we are going to see how to setup splunk D B connect App. We will install the app from Splunk base, my sql driver, and we will also setup an my sql database instance in docker and import some data in to my sql using workbench. This data will be indexed in to splunk using D B connect app. If you haven't subscribed to my channel, kindly do so and provide your comments. Lets get started.

To install splunk db connect app, we go to manage apps and we have 2 options. We can install using browse apps and also install using a file. Lets use browse apps and install the splunk db connect from splunk base. You need to login using splunk account for installing the app. Great!, The splunk DB connect app is installed now. Lets do the initial configuration. Java is a pre-requisite for the app to work. So lets install Java and set up the configurations.

How To Run MySQL In Docker Container:    • MySQL Docker Tutorial | MySQL Docker Setup...  

yum install java-openjdk

alternatives --config java

export JAVA_HOME=/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.242.b08-0.el7_7.x86_64/jre
export PATH=$JAVA_HOME/bin:$PATH

source /etc/profile

wget https://dev.mysql.com/get/Downloads/C...

rpm2cpio bash-3.1-16.1.x86_64.rpm | cpio -t

To list the content of RPM

yum localinstall mysql-connector-java-8.0.19-1.el7.noarch.rpm

To install the rpm package

cd /usr/share/java

cp mysql-connector-java.jar /opt/splunk/etc/apps/splunk_app_db_connect/drivers/

docker container run -d --name mysqldb -p 3306:3306 -e MYSQL_ROOT_PASSWORD=password -v db_data:/var/lib/mysql mysql:latest

docker exec -it mysqldb /bin/bash

mysql -u root -ppassword

show databases;

create database company;

Reference: https://docs.splunk.com/Documentation...

Splunk Database drivers: https://docs.splunk.com/Documentation...

=================================================
Follow me @:
  / thetips4you  
https://www.youtube.com/channel/UCoOq...
  / thetipsforyou  
http://www.thetips4you.com
======================================================

Note: Each word by Word or sentences used in this video is self written and converted to Audio to give explanation on the steps in each tutorial . These are not automated or third party content or scrapped from any website.

Music credit: "Royalty Free Music from Bensound"