Trying to stand up a new heavy forwarder to remove splunk db connect from our primary search head and when I grabbed the most recent versions of the application, it does not seem to have dbxquery.py in the tarball at all. It does not appear to have been deprecated because the SQL explorer still relies on it. Please let me know what I need to do to get this back. It's core to our environment.
dbxquery command has been rewritten in Java in Splunk DB Connect 3.x and has been included in $SPLUNK_HOME/etc/apps/splunk_app_db_connect/jars/command.jar file.
You can find the relevant information in commands.conf
DBX 2.4.x : $SPLUNK_HOME/etc/apps/splunk_app_db_connect/default/command.conf
[dbxquery]
filename = dbxquery.py
supports_getinfo = true
supports_rawargs = true
passauth = true
run_in_preview = false
local = true
generating = true
streaming = false
DBX 3.x.x : $SPLUNK_HOME/etc/apps/splunk_app_db_connect/default/command.conf
[dbxquery]
filename = java.path
chunked = true
#command.arg.1 = -Xdebug
#command.arg.2 = -Xrunjdwp:transport=dt_socket,address=192.168.33.1:9999,suspend=y
command.arg.1 = -Dlogback.configurationFile=../config/command_logback.xml
command.arg.2 = -DDBX_COMMAND_LOG_LEVEL=INFO
command.arg.3 = -cp
command.arg.4 = ../jars/command.jar
command.arg.5 = com.splunk.dbx.command.DbxQueryCommand
# Keystore password
#command.arg.6 = changeme