Search Engine: Elastic

Article ID: 132213, created on Feb 8, 2018, last review on Feb 8, 2018

  • Applies to:
  • Operations Automation 7.2

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.

5356b422f65bdad1c3e9edca5d74a1ae caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07 31987597efff5a3a9ce779cc203bbe5e 1941880841f714e458ae4dc3d9f3062d

Email subscription for changes to this article
Save as PDF