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)

相关推荐