Effective December 3, NetApp adopts Microsoft’s Business-to-Customer (B2C) identity management to simplify and provide secure access to NetApp resources.
For accounts that did not pre-register (prior to Dec 3), access to your NetApp data may take up to 1 hour as your legacy NSS ID is synchronized to the new B2C identity.
To learn more, read the FAQ and watch the video.
Need assistance? Complete this form and select “Registration Issue” as the Feedback Category.

Active IQ Unified Manager Discussions

Seemless BMC Connector setup

XOMBAC2012

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?

3 REPLIES 3

ostiguy

Hey Bret,

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

Matt

XOMBAC2012

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?

moechnig

this is a total guess, but I'd use dwhuser, password netapp123

Announcements
NetApp on Discord Image

We're on Discord, are you?

Live Chat, Watch Parties, and More!

Explore Banner

Meet Explore, NetApp’s digital sales platform

Engage digitally throughout the sales process, from product discovery to configuration, and handle all your post-purchase needs.

NetApp Insights to Action
I2A Banner
Public