Symptoms

  1. 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 db tables on remote shared MySQL database host.

  2. For example, following records could be found in /var/log/pa/core.log on 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.

  3. 172.16.2.42 IP is NOT registered in Odin Automation under PCP > Infrastructure > IP Manager > IP Addresses.

  4. If option Access from external hosts is enabled for Customers Database, 172.16.2.42 IP Address is not listed in Allowed Access Hosts list in CCP > Database Settings.

Cause

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.

Resolution

Contact Odin Technical Support to work around the issue.

Internal content

Link on internal Article