Splunk Enterprise

Getting error "Driver version is invalid" for a MySQL connection even if driver is installed?

asabari1994
New Member

Hi All,

 

I am trying our Splunk Enterprise server for MySQL database monitoring. I am using a trial version of Splunk.

I have installed the Splunk DB Connect application and have installed the MySQL driver mysql-connector-j-8.0.31.jar. I am able to see that the driver is installed. And I have configured a MySQL DB connection.

asabari1994_0-1675762729478.png

But when I execute Health Check from the monitoring console for the Splunk DB Connect app, I am getting the error " One or more defined connections require the corresponding JDBC driver."

"Driver version is invalid, connection: MySQLDB, connection_type: mysql."

asabari1994_1-1675763034133.png

MySQL DB version is 8.0.23 and it's an AWS Aurora RDS instance. I did try "Splunk DBX Add-on for MySQL JDBC" to install the driver before and I had the same issue. I saw that the driver that came with this app was of a lower version than what we use in our application to connect to the database, so installed the new driver directly.

Also while trying to execute a query I am getting the error "Error in 'dbxquery' command: External search command exited unexpectedly with non-zero error code 1."

Please help to resolve this error.

Thanks

Arun

 

 

0 Karma

keithwdesantis
Engager

Did you ever get this resolved? Seeing a similar issue.

0 Karma
Get Updates on the Splunk Community!

Enterprise Security Content Update (ESCU) | New Releases

In January, the Splunk Threat Research Team had one release of new security content via the Splunk ES Content ...

Expert Tips from Splunk Professional Services, Ensuring Compliance, and More New ...

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

Observability Release Update: AI Assistant, AppD + Observability Cloud Integrations & ...

This month’s releases across the Splunk Observability portfolio deliver earlier detection and faster ...