Issue
DB Connect no longer stores results after query. It was working fine in the past, but now just doesn't work.
Troubleshooting Steps
Changed query in DB Input to something simpler
Deleted and recreated DB Input, using as many default values as possible
Created additional DB Inputs for same database
Created additional DB Inputs for different databases on different hosts
Ran tcpdump on all devices to ensure that DB Connect was able to successfully connect, query, and receive results
Tried using different indexes and sourcetype names for each query
Tried upgrading DB Connect app from 3.1.0 to 3.1.2.
Results
Splunk search-head successfully connects to port 3306 on target machine, performs query, receives results.
Try to query results in Search (timeframe "All Time"); no results.
Additional Info
Splunk Enterprise v7.0
Splunk DB Connect v3.1.2
... View more