2014-08-26 12:00 PM
During the setup of the Seemless BMC Connector, Avnet provides plenty of information for their client. A little harder to find is how to setup access for the client to the DWH database.
Is the Database called DWH_inventory? If I create a user in the GUI User Management what level of access should I provide and does it even provide access to the MySQL database. If not how do I create that user?
2014-08-26 12:23 PM
I don't have any hands on time with the BMC connector, but I am going to guess that it is using the built in, read-only MySQL user the OCI DWH exposes. This mysql user is dwhuser / netapp123
dwh_inventory is one of the databases this user has read only access to. The inventory mart is a point in time (as of the last ETL) inventory view of the world, as your OCI servers merged together will see it
2014-08-27 07:46 AM
I suspect this ID/ password will work, but it is not possible to test it until we unblock the connection to the database.
The connection is blocked after 10 unsuccessfully connection attempts.
See the error below:
Further investigation on the internet and it seems that we need to unblock it in the mySQL server running the command “mysqladmin flush-hosts”.
Is there an automatic unblock after a period of time or is there actually a need to flush from the MySQL prompt?