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: https://youtu.be/EG3RhQNl00o 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/Connector-J/mysql-connector-java-8.0.19-1.el7.noarch.rpm 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/DBX/3.3.0/DeployDBX/ConfigureDBConnectsettings Splunk Database drivers: https://docs.splunk.com/Documentation/DBX/3.3.0/DeployDBX/Installdatabasedrivers ================================================= Follow me @: https://www.instagram.com/thetips4you https://www.youtube.com/channel/UCoOq... https://www.facebook.com/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"