WFA OCUM 数据源错误 " 不允许连接到此 MySQL 服务器 "
适用场景
OnCommand 工作流自动化( WFA ) 5.1
OnCommand 统一管理器( 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)