splunk之DBX连接mariadb
1、下载DBX
前往splunkbase:
https://splunkbase.splunk.com/app/2686
2、安装DBX
参考官网:
https://docs.splunk.com/Documentation/DBX/3.4.2/DeployDBX/Checklist
3、将jar拷贝到驱动路径
参考官网:https://docs.splunk.com/Documentation/DBX/3.4.2/DeployDBX/Installdatabasedrivers
4、在DBX应用local目录下创建db_connection_types.conf
5、添加以下内容:
[mariadb]
displayName = MariaDB
serviceClass = com.splunk.dbx2.MySQLJDBC
jdbcUrlFormat = jdbc:mariadb://:/
jdbcUrlSSLFormat = jdbc:mariadb://:/?useSSL=true&requireSSL=true&verifyServerCertificate=false
jdbcDriverClass = org.mariadb.jdbc.Driver
supportedMajorVersion = 3
supportedMinorVersion = 1
port = 3306
testQuery = SELECT 1
ui_default_catalog = $database$
5、保存重启服务即可
赞 (0)