OnCommand Workflow Automation error "Client does not support authentication protocol requested by server."

Last updated
Save as PDF
Share
1. Share
2. Tweet
3. Share

Views:: 401

Visibility:: Public

Votes:: 0

Category:: oncommand-workflow-automation-wfa

Specialty:: legacy

Last Updated:

Applies to

OnCommand Workflow Automation 5.1.1 (WFA)
Active IQ Unified Manager 9.7+ (AIQUM)

Issue

Unable add Active IQ Unified Manager 9.7 or above as a data source in Oncommand Workflow Automation 5.1.1
The following log lines can be found in the \Program Files\NetApp\WFA\jboss\standalone\log\wfa.log log file.

021-01-19 05:34:33,321 ERROR [com.netapp.wfa.job.backend.JobsExecutionInterceptor] (Thread-965 (ActiveMQ-client-global-threads)) Job CacheJob{, dataSourceId=DataSourceInfo{id=1, name='OCUM Data Source', connectionDetails=ConnectionDetails{id=10, ip='ocum.com', port=3306, userName='wfa', password='******', databaseName='', timeoutInMinutes=10, lastUpdateTime=0}, dataProviderType=DataProviderType{id=9, productType='Active IQ Unified Manager', productVersion='9.7', scheme='cm_storage'}}, schemeId=Scheme{id=5, name='cm_storage'}, dataSourceName='Initial Data Source', schemeName='cm_storage'} failed: javax.ejb.EJBException: com.netapp.wfa.util.SqlShellException: Failed to get connection from data-source

at org.jboss.as.ejb3@17.0.1.Final//org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInNoTx(CMTTxInterceptor.java:223)

at org.jboss.as.ejb3@17.0.1.Final//org.jboss.as.ejb3.tx.CMTTxInterceptor.never(CMTTxInterceptor.java:327

Caused by: java.sql.SQLNonTransientConnectionException: Client does not support authentication protocol requested by server. Consider upgrading MariaDB client. plugin was = caching_sha2_password