WFA OCUM データソースエラー「 Not Allowed to connect to this MySQL server 」
環境
OnCommand Workflow Automation ( WFA ) 5.1
OnCommand Unified Manager ( OCUM ) 9.5P1
問題
WFA OCUM データソースのステータスがエラーで失敗します。
WFA ログのエラーは次のとおりです。
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)