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!
