Shop

Your Notifications (0)

There are currently no notifications. You're all set!

Demos Trials
Knowledge Base
ChemDraw and ChemOffice+ Products Signals Notebook E-Notebook and ChemBioOffice Enterprise Spotfire and Signals Spotfire Products Columbus Signals Image Artist
Downloads
Downloads
Community
Support Forums Ideas Portal Product Basics
About Support
Legal Resources Support and Maintenance Plans Product Life Cycle Support News
Contact Support

MYSQL JDBC Data Source connection fails with the error: “CLIENT_PLUGIN_AUTH is required” in TIBCO Spotfire Analyst

Rich Talbot
  • Updated
Date Posted:
Product: TIBCO Spotfire®

Problem:

MYSQL JDBC Data Source connection fails with the error: “CLIENT_PLUGIN_AUTH is required” in TIBCO Spotfire Analyst


Solution:

Fail to create or edit MYSQL JDBC Data Source connection, using the Spotfire analyst client Information services with the error: “CLIENT_PLUGIN_AUTH is required” Check if the version of JDBC driver is compatible with the MYSQL DB version e.g. check if you are using a new version of the MYSQL JDBC driver which may not be compatible with the old version of MYSQL database.
For version 10.3 and above the JDBC driver is copied to the <Spotfire Server Install>\tomcat\custom-ext folder

For 10.2 and below the JDBC driver is copied to  the <Spotfire Server Install>\tomcat\lib folder

  https://stackoverflow.com/questions/37348572/new-mysql-driver-causes-java-sql-sqlnontransientconnectionexception-client-plug

Related articles