Skip to main content
NetApp Knowledge Base

WFA OCUM datasource error"not allowed to connect to this MySQL server"

Views:
17
Visibility:
Public
Votes:
0
Category:
oncommand-workflow-automation-wfa
Specialty:
om
Last Updated:

Applies to

Oncommand Workflow Automation (WFA) 5.1

Oncommand Unified Manager (OCUM) 9.5P1

Issue

WFA OCUM datasource status fails with error.

The error in WFA log is as follows,

2021-05-27 06:53:40,282 ERROR [com.netapp.wfa.job.backend.JobsExecutionInterceptor] (Thread-9892 (ActiveMQ-client-global-threads)) Job CacheJob{, dataSourceId=DataSourceInfo{id=44, name='UM 9.5 : FQDN.com', connectionDetails=ConnectionDetails{id=70, ip='FQDN', port=3306, userName='wfauser', password='******', databaseName='null', timeoutInMinutes=10, lastUpdateTime=0}, dataProviderType=DataProviderType{id=16, productType='OnCommand Unified Manager', productVersion='9.5', scheme='cm_storage'}}, schemeId=Scheme{id=4, name='cm_storage'}, dataSourceName='UM 9.5 : FQDN.com', schemeName='cm_storage'} failed: javax.ejb.EJBException: com.netapp.wfa.util.SqlShellException: Failed to get connection from data-source
(…)
Caused by: com.netapp.wfa.util.SqlShellException: Failed to get connection from data-source
(…)
Caused by: java.sql.SQLException: Host 'FQDN.com' is not allowed to connect to this MySQL server
at org.mariadb.jdbc//org.mariadb.jdbc.internal.com.read.ReadInitialHandShakePacket.(ReadInitialHandShakePacket.java:91)
 

 

CUSTOMER EXCLUSIVE CONTENT

Registered NetApp customers get unlimited access to our dynamic Knowledge Base.

New authoritative content is published and updated each day by our team of experts.

Current Customer or Partner?

Sign In for unlimited access

New to NetApp?

Learn more about our award-winning Support