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!

Break the Build: Inside the KubeDoom Lounge at .conf26

    You step up to the machine. The pixelated corridors of a certain 1993 FPS load in front of you, EMP Pulse ...

Splunk Auto Ingestion Parallel Pipeline Scaling

Why this feature matters Many Splunk environments experience ingestion pressure long before the host is fully ...

Best Practices: Splunk auto adjust pipeline queue

When you enable autoAdjustQueue in Splunk, maxSize should be understood as the queue size Splunk starts with ...