topic Re: DB Connect Error in All Apps and Add-ons

DB Connect Error

balcv — Wed, 30 Sep 2020 00:34:52 GMT

I am attempting to setup DB Connect to talk to a MySQL database on my Redhat Linux server.
I have installed the MySQL jar file on the Splunk server, MySQL driver is showing as available, firewall rules are taken care of so connectivity is fine, however when I save the New Connection information, I get:

Database Connection [name] is invalid.
CLIENT_PLUGIN_AUTH is required

Running MySQL 5.1.73
Splunk MySQL driver is ver 8.0
mysql-connector-java-8.0.12.jar

Can anyone help me out with the resolution to this one?

Many thanks

Re: DB Connect Error

rpille_splunk — Wed, 15 May 2019 23:48:10 GMT

Try using an older .jar file. Go to https://dev.mysql.com/downloads/connector/j/ and click "Looking for previous GA versions?"

According to the DB Connect documentation, the tested version was 5.1. https://docs.splunk.com/Documentation/DBX/3.1.4/DeployDBX/Installdatabasedrivers#Supported_databases

Re: DB Connect Error

balcv — Thu, 16 May 2019 00:05:12 GMT

Tried an older version but same result. I suspect the issue may be on my database server side so not sure if there is something I need installed on that side.

Re: DB Connect Error

balcv — Wed, 30 Sep 2020 00:34:55 GMT

I have put an older version of the connector (mysql-connector-java-5.1.47.jar) in the /opt/splunk/etc/apps/splunk_app_db_connect/drivers folder but Splunk is still reporting MySQL v 8.0 in the drivers screen of DB Connect even after a Reload.
Do I need to restart splunk to pick up the different driver?

Re: DB Connect Error

balcv — Thu, 16 May 2019 01:16:32 GMT

Thank you, yes it was version related. Once I did a Splunk restart, the "old" jar file was picked up and it all worked as required. Thanks