Splunk Search

How to log SQL queries in DB Connect 1

New Member

We have some old DB Connect 1.2.2 inputs defined that need to migrated to DB Connect 3.1.4. In order to debug some weird issues between the two versions, I need to be able to see the exact SQL query that the DB Connect 1.2.2 is running.

I can see SQL queries running in DB Connect 3 in the log file $SPLUNK_HOME/var/log/splunk/splunk_app_db_connect_audit_server.log. I'm looking for similar logs in DB Connect 1.

I've read through the troubleshooting documentation for DB Connect 1.2.2.


I've increased the verbosity of the logging for SPLUNK_HOME/var/log/splunk/dbx.log in $SPLUNK_HOME/etc/apps/dbx/local/java.conf as follows:

level = DEBUG
file = dbx.log
console = false
logger.com.splunk.dbx = DEBUG

I can see where the input is getting kicked off periodically, but I can't see the actual SQL queries being run. Does anyone know how to configure this logging for DB Connect 1.2.2? I'd do a packet dump on the database session, but I don't have root access on this server to run tcpdump.


0 Karma
Get Updates on the Splunk Community!

Splunk Training for All: Meet Aspiring Cybersecurity Analyst, Marc Alicea

Splunk Education believes in the value of training and certification in today’s rapidly-changing data-driven ...

Investigate Security and Threat Detection with VirusTotal and Splunk Integration

As security threats and their complexities surge, security analysts deal with increased challenges and ...

Observability Highlights | January 2023 Newsletter

 January 2023New Product Releases Splunk Network Explorer for Infrastructure MonitoringSplunk unveils Network ...