All Apps and Add-ons

Configure DB Connect App Programatically

rfitch
Path Finder

I'd like to add and remove DB Connect configurations programatically. Has anyone tried this? I'm guessing I can just add / remove entries to the db_connections.conf, inputs.conf, and identities.conf.

For the identities.conf, if I put the password in there plain text, will Splunk hash it for me, or is there a way I can do that ahead of time?

0 Karma

jcoates_splunk
Splunk Employee
Splunk Employee

I'd advise using DB Connect 3 if you're going to use automatic configuration. The different types of inputs are separated into different files, rising column checkpoints are separated into a different location, and SQL parsing is strictly WYSIWYG. One gotcha in 3.0.0 is that you've got to "seed" the rising column file in your script.

0 Karma

rfitch
Path Finder

Found the answer, credentials can be added using curl.

https://docs.splunk.com/Documentation/DBX/2.4.0/DeployDBX/javaspec

0 Karma

sloshburch
Ultra Champion

Alternatively, I wonder if there's a REST api that you can use for generating the new connection. That's because typically conf file updates require a restart of splunkd while REST calls often do not.

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Persistent Queue at TcpOut — One of Splunk's Most Practical Features

Splunk introduced persistent queueing at the tcpout layer as one of the most practical resilience features in ...

Skip the Awkward Silence: Have a .conf-ersation at .conf26

Picture this. You arrive at .conf26 already having your socializing and networking plans mapped out. No ...

Rethinking Zero Trust: From Product Purchases to Logical Control Evidence

Implementing Zero Trust (ZT) across complex environments often falters at the very beginning due to a ...