All Apps and Add-ons

Splunk DB Connect: Error in 'dbxquery' command: External search command exited unexpectedly with non-zero error code 255

Explorer

Hello,

I have an odd problem with db_connect :

My connection is ok

alt text

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

1 Solution

Explorer

I have downgraded DB connect (from 3.1.1 to 2.4.1) and now it works

View solution in original post

0 Karma

Explorer

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

Explorer

I have downgraded DB connect (from 3.1.1 to 2.4.1) and now it works

View solution in original post

0 Karma