WFA OCUM datasource error"not allowed to connect to this MySQL server"
- Views:
- 279
- Visibility:
- Public
- Votes:
- 0
- Category:
- oncommand-workflow-automation-wfa
- Specialty:
- legacy
- 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)