Posted by user_3730190 at 2020-05-14 08:50
Hi, friend!Thanks for your help!The version is V100R019C10
Hi, dear!
Please see the steps below:
Log in to CSP to view the C_GAUSS_API node.
After logging into the background of the host server with the MobaXterm tool.
Enter su- and enter the password cnp200@cspos@HW to switch to root.
View the gaussdb container ID: docker ps | grep gaussdb.
Enter the GaussAPI container: docker exec -it container ID bash
Execute reset command:
su-postgres -c "/ home / postgres / bin / psql -p 6000 -d smu -c\" update tbl_smu_user_info set login_password = '354120804238ac57a761e537388958e89e357701564370d91512a7c0de53f07f', first_login = '0', salt login_name = 'admin'; \ ""
An error message is displayed stating that it is not executed under the GaussAPI container of the host machine but should be executed under the GaussAPI container of the standby server.
Jump to the standby machine: ssh cspexpert@10.xx.xx.xx
Enter the GaussAPI container to execute the reset command, the system returns the
following information: UPDATE = 1, indicating that the reset was successful.
Posted by user_3730190 at 2020-05-14 08:50
Hi, friend!Thanks for your help!The version is V100R019C10
Hi, dear!
Please see the steps below:
Log in to CSP to view the C_GAUSS_API node.
After logging into the background of the host server with the MobaXterm tool.
Enter su- and enter the password cnp200@cspos@HW to switch to root.
View the gaussdb container ID: docker ps | grep gaussdb.
Enter the GaussAPI container: docker exec -it container ID bash
Execute reset command:
su-postgres -c "/ home / postgres / bin / psql -p 6000 -d smu -c\" update tbl_smu_user_info set login_password = '354120804238ac57a761e537388958e89e357701564370d91512a7c0de53f07f', first_login = '0', salt login_name = 'admin'; \ ""
An error message is displayed stating that it is not executed under the GaussAPI container of the host machine but should be executed under the GaussAPI container of the standby server.
Jump to the standby machine: ssh cspexpert@10.xx.xx.xx
Enter the GaussAPI container to execute the reset command, the system returns the
following information: UPDATE = 1, indicating that the reset was successful.
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."