When creating a database on MySQL 5.7(or MySQL 5.6) host OA adds a bunch of IPs as allowed to access that database to
dbtables on remote shared MySQL database host.
For example, following records could be found in
/var/log/pa/core.logon Odin Automation Core node:
Jan 24 17:57:22.943 : DBG [task:117124105:346778 1:43895:7f094effd700 MySQL ]: [ db::mysql::connection::exec] 172.16.6.1:mysql INSERT INTO db(Host,Db,User,Select_priv,Insert_priv,Update_priv,Delete_priv,Create_priv,Drop_priv,Grant_priv,References_priv,Index_priv,Alter_priv,Create_tmp_table_priv,Lock_tables_priv,Create_view_priv,Show_view_priv,Create_routine_priv,Alter_routine_priv,Execute_priv,Event_priv,Trigger_priv) VALUES('172.16.2.42', 'db1111111_newdb', 'u1190277_newdb','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y')
172.16.6.1- IP Address of remote Shared Database Host.
172.16.2.42- not registered in OA IP address.
172.16.2.42IP is NOT registered in Odin Automation under
PCP > Infrastructure > IP Manager > IP Addresses.
- If option
Access from external hostsis enabled for Customers Database,
172.16.2.42IP Address is not listed in
Allowed Access Hostslist in CCP > Database Settings.
Database inconsistency. This IP address previously was used on some Service node. Later node was removed from OA, but not all tasks for removing host from the infrastructure were processed properly.
Contact Odin Technical Support to work around the issue.