Next, switch to the "Databases" tab instead of Settings, and then "Identities." These are the users you connect to the databases with.It should show that "MS-SQL Server Using MS Generic Driver", "MS-SQL Server Using MS Generic Driver With Kerberos Authentication", and "MS-SQL Server Using MS Generic Driver With Windows Authentication" are installed. Confirm that DBX has picked up the driver by visiting the Settings -> Driver page.In this example we will be using MS SQL Server 2016, with the Adventure Works 2016 Database. Extract the appropriate Jar file for your version of the JRE to /opt/splunk/etc/apps/splunk_app_db_connect/drivers and make sure it's owner group is the Splunk user.This is linked at the start of the guide for MS SQL. Download the latest supported MS SQL ODBC jar listed as compatible.When Splunk returns, browse to the DB Connect app and click "Setup." This will take you to the General setup page, where all you should have to do is click "Save" and DBX will setup the basics for you. Set the variable globally by adding JAVA_HOME="/usr/lib/jvm/jre-1.8.0-openjdk" ash /etc/environment.Set the variable globally by adding JAVA_HOME="/usr/lib/jvm/jre-1.8.0-openjdk" to /etc/environment.OpenJDK 8 is located at /usr/lib/jvm/jre-1.8.0-openjdk.OpenJDK 64-Bit Server VM (build 25.262-b10, mixed mode) OpenJDK Runtime Environment (build 1.8.0_262-b10) Run sudo yum install java-1.8.0-openjdk.Set the variable globally by adding JAVA_HOME="/usr/lib/jvm/java-11-openjdk-amd64" to /etc/environment.OpenJDK 11 is located at /usr/lib/jvm/java-11-openjdk-amd64.OpenJDK 64-Bit Server VM (build 11.0.7+10-post-Ubuntu-3ubuntu1, mixed mode, sharing) OpenJDK Runtime Environment (build 11.0.7+10-post-Ubuntu-3ubuntu1) Run sudo apt install openjdk-11-jre-headless.Set the variable globally by adding JAVA_HOME="/usr/lib/jvm/java-8-openjdk-amd64" to /etc/environment.OpenJDK 8 is located at /usr/lib/jvm/java-8-openjdk-amd64.OpenJDK 64-Bit Server VM (build 25.265-b01, mixed mode) Validate Java is installed and running in server mode with java -version.Run sudo apt install openjdk-8-jre-headless.System Preparation1 Splunk - Installing DBXĭBX installs like other plugin, it's the configuration and prerequisites on the server itself that can be troublesome. OpenJDK (Despite the name we're installing the Java Runtime Environment, not JDK) 8 or 11.This guide also assumes some familiarity with Splunk, and whichever OS you choose. This does not cover OS or Splunk initial installation and configuration, and only covers Microsoft SQL Server's JDBC driver v8.2.x. OpenJDK 8 on Ubuntu 16.04 and Centos 7, and OpenJDK 11 on Ubuntu 20.04 and Centos 8. This guide is meant to be a set of step by step instructions for installing Splunk Database Connect 3.3.1 (henceforth referred to as DBX) on a stock install of Splunk 7.3.x and 8.0.x. Splunk Database Connect (DBX) Installation Guide For Ubuntu and Centos Introduction & Scope
0 kommentar(er)
