Hello,
I have an odd problem with db_connect :
My connection is ok
I can see the database and the tables but when i try to query (basic select) i have an error
Error in 'dbxquery' command: External search command exited unexpectedly with non-zero error code 255
My query is simple | dbxquery query="SELECT * FROM sys.sys_config" connection="da"
even select 1 from dual
doesn't work
Database : MySQL 5.7
User : root privileges
Splunk 6.6.0
DB connect 3.1.1
Java 8
In my case, JVM options was empty in the settings.
I click reset and save. it work.
OR write follow.
-Ddw.server.applicationConnectors[0].port=9998
May I know where to write the below line
-Ddw.server.applicationConnectors[0].port=9998
I have downgraded DB connect (from 3.1.1 to 2.4.1) and now it works