Splunk Search

How to log SQL queries in DB Connect 1

paulski82
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.

https://docs.splunk.com/Documentation/DBX/1.2.2/DeployDBX/Troubleshoot

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:

---8<---
[logging]
level = DEBUG
file = dbx.log
console = false
logger.com.splunk.dbx = DEBUG
---8<---

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.

Thanks!

0 Karma
Get Updates on the Splunk Community!

Introduction to Splunk Observability Cloud - Building a Resilient Hybrid Cloud

Introduction to Splunk Observability Cloud - Building a Resilient Hybrid Cloud  In today’s fast-paced digital ...

Observability protocols to know about

Observability protocols define the specifications or formats for collecting, encoding, transporting, and ...

Take Your Breath Away with Splunk Risk-Based Alerting (RBA)

WATCH NOW!The Splunk Guide to Risk-Based Alerting is here to empower your SOC like never before. Join Haylee ...