Got it

10100103 Failed to check the database user and password

99 0 1 0 0

Hello, everyone!

I want to share a case about the ITA/HDC pre-upgrade check fails with the error message "10100103 Failed to check the database user and password."

Problem description


When FusionAccess 6.5.1 is upgraded to 8.0.2, the ITA pre-upgrade check fails and the error code 10100103 is displayed (the same error is displayed in the HDC pre-upgrade check).

Failed to check the database user and password


Problem analysis & Solution

1. Check the /var/FusionAccess/ITA/Upgrade_ITA_DB.log file. The error information "gaussDBadmin or password is error" and "GS-00303, Failed to establish tcp connection to [x.x.x.x]:[5432], errno 115" is displayed.


Failed to establish tcp connection to


2. Check the corresponding flow script DB_CHECK.sh. In this step, connect to the floating IP address (primary database), log in to the database using the account and password, and run the test statement select 1 from dual

The following two problems may occur: 

  • The network is disconnected. (Symtom: The node above the floating node is normal, but the other node fails.)

  • The account and password are incorrect. (The symptom is that both nodes fail. You can manually run the command to verify the fault.)


select 1 from dual


3. The test command zsql fauser@x.x.x.x:5432 -q -c'select 1 from dual' indicates that the connection fails to be established between the active database node and the live network node.

Abnormal:

fails to be established between the active databa


Normal:

fails to be established between the active databa


4. Run the ssh -v X.X.X.X -p 5432 command on the failed node. The port connection fails.


5. Check the firewall configuration of the active database node. 

iptables –nvL

5432 and 12211 ports are allowed only on the eth0 network adapter. However, the service network adapter in the customer environment is eth1, and the network is not allowed. Manually delete the two iptables entries of the original eth0 network adapter, create a policy without specifying a network adapter, and save the firewall policy.

Check the firewall configuration of the active dat

iptables -D INPUT -p tcp -m tcp --dport 5432 -i eth0 -j ACCEPT

iptables -I INPUT -p tcp -m tcp --dport 5432 -j ACCEPT

iptables -D INPUT -p tcp -m tcp --dport 12211 -i eth0 -j ACCEPT

iptables -I INPUT -p tcp -m tcp --dport 12211 -j ACCEPT

iptables-save > /etc/sysconfig/iptables.save

6. Execute the firewall policy on both the active and standby nodes.


Summary & Suggestion

This problem affects both the ITA and HDC upgrade check. The error message is that the user password is incorrect. The following two scenarios are involved:

1. Incorrect user passwords. 

2. The network connection is not connected.

This is my solution, how about yours? Go ahead and share it with us!


  • x
  • convention:

Comment

You need to log in to comment to the post Login | Register
Comment

Notice: To protect the legitimate rights and interests of you, the community, and third parties, do not release content that may bring legal risks to all parties, including but are not limited to the following:
  • Politically sensitive content
  • Content concerning pornography, gambling, and drug abuse
  • Content that may disclose or infringe upon others ' commercial secrets, intellectual properties, including trade marks, copyrights, and patents, and personal privacy
Do not share your account and password with others. All operations performed using your account will be regarded as your own actions and all consequences arising therefrom will be borne by you. For details, see " User Agreement."

My Followers

Login and enjoy all the member benefits

Login

Block
Are you sure to block this user?
Users on your blacklist cannot comment on your post,cannot mention you, cannot send you private messages.
Reminder
Please bind your phone number to obtain invitation bonus.
Information Protection Guide
Thanks for using Huawei Enterprise Support Community! We will help you learn how we collect, use, store and share your personal information and the rights you have in accordance with Privacy Policy and User Agreement.