CABI JasperSoft Spectrum Data Sources stopped working Client does not support authentication protocol requested by server caching_sha2_password

Products

• Network Observability
• Spectrum

Issue/Introduction

CABI JasperSoft Spectrum Data Sources stopped working.

Test connection:  !Could not connect to address=(host=<OneClick_hostname>)(port=3306)(type=master) : Client does not support authentication protocol requested by server.  plugin type was = 'caching_sha2_password'

 

You may also see in the catalina.out from the Jaspersoft server the following error message 

 

ERROR JSDataSourceConnectionFailedExceptionMapper,https-jsse-nio-####-exec-7:53 - The data source connection failed com.jaspersoft.jasperserver.api.metadata.common.service.JSDataSourceConnectionFailedException: jsexception.error.creating.connection
Arguments: 

....

Caused by: java.sql.SQLNonTransientConnectionException: Could not connect to address=(host=<Oneclick SRM Server>)(port=3306)(type=master) : Client does not support authentication protocol requested by server. plugin type was = 'caching_sha2_password'

Environment

Jaspersoft 7.9.2.4

Spectrum 24.3.x

 

Resolution

Uninstall and reinstall the Spectrum Content (Integration Components)

 

1. Disable the Jasper Integration in OneClick Administration page → Report Manager

 

2. Export the JAVA_HOME environment variable on the CABI/JasperReports host.

export JAVA_HOME=<CABI_HOME>/java

Example: export JAVA_HOME=/opt/CA/SharedComponents/CABI/java

 

3. Uninstall the Spectrum Content (Integration Components)

<CABI_HOME>/jre/bin/java -jar spectrumConfigInstaller.jar -uninstall

 

How to download the spectrumConfigInstaller.jar file on the CABI/JasperReports host.

wget --http-user=spectrum --ask-password --secure-protocol=TLSv1_2 --no-check-certificate --auth-no-challenge https://<OneClick_hostname>:8443/spectrum/repmgr/admin/spectrumConfigInstaller.jar -dv

wget --http-user=spectrum --ask-password --auth-no-challenge http://<OneClick_hostname>:8080/spectrum/repmgr/admin/spectrumConfigInstaller.jar

 

4. Install the Spectrum Content (Integration Components)

<CABI_HOME>/jre/bin/java -jar spectrumConfigInstaller.jar -install

 

Please restart the Jasper tomcat server to complete the configuration.

<CABI_HOME>/apache-tomcat/bin/shutdown.sh

<CABI_HOME>/apache-tomcat/bin/startup.sh

 

5. Enable the Jasper Integration in OneClick Administration page → Report Manager

Additional Information

Any customizations made to CABI/JasperReports will be removed during the uninstallation of Spectrum content.