The transition to NetApp MS Azure AD B2C is complete. If you missed the pre-registration, you will be invited to reigister at next log in.
Please note that access to your NetApp data may take up to 1 hour.
To learn more, read the FAQ and watch the video.
Need assistance? Complete this form and select “Registration Issue” as the Feedback Category.

Data Backup and Recovery

SnapCenter 4.4 Configuring MySQL HA not working

StefanG

Good Evening

 

Following the process described in "How to Configure NLB and ARR with SnapCenter" (https://kb.netapp.com/Advice_and_Troubleshooting/Data_Protection_and_Security/SnapCenter/How_to_configure_NLB_and_ARR_with_SnapCenter) and it work fine with version 4.3.

 

With version 4.4 the command Enable-smrepositoryhaconfig returns the error message "failed to execute the sql command to set the master configuration the user or password is incorrect"

Running the command Enable-smrepositoryhaconfig  subsiquently returns "MySQL  High Avaliability is already configured"

 

Running the next command in the process "set-smrepositoryconfigurationsettings.." return message "username or password not supplied.

 

The 2 nodes are Windows 2016 in workgroup and on the same subnet.

 

Thanks in advance for any contributions

 

1 ACCEPTED SOLUTION

NTAp-AVS

Thank you for your response. At this moment we recommend opening a support case as the issue may need more troubleshooting and log analysis

 

View solution in original post

3 REPLIES 3

NTAp-AVS

Please verify if the user that you entered  for the cmdlet open-smconnection,  is part of local administrators on both the NLB nodes

 

Also did you reset the Mysql root password on both the nodes?

Reset MySQL password of both the nodes to the same password by running Set-SmRepositoryPassword cmdlet on both the nodes
We recommend running this command again on both the nodes and perform 

StefanG

Thanks for your reply.

 

Yes I did run both commands open-smconnection and Set-SmRepositoryPassword on both nodes.

 

NTAp-AVS

Thank you for your response. At this moment we recommend opening a support case as the issue may need more troubleshooting and log analysis

 

View solution in original post

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