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
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
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
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
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?
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.