Fusioncube 查看 数据库gaussdba 用户密码:
python -c "import kmc.kmc as K;import os;os.environ['KMC_DATA_USER']='gaussdba';print(K.API().decrypt(0,'$(cat /opt/huawei/fce/runtime/security/priv/gaussdb.conf |grep ^gaussdba= |awk -F '=' '{print $2}')'))"
修改Fusioncube 用户密码:
su - gaussdba -s /bin/bash -c 'zsql gaussdba/'xxxxxx'@127.0.0.1:1888'
schema切成framework
ALTER SESSION SET current_schema=framework;
查询IAM_ACCOUNT表的secadmin密码
SELECT * from IAM_ACCOUNT;
10000:5dc307caa97a504e25a3bbdef2886502:ff31dc78656de0b7d2cc3e7c47b9274856962bf96d3a7120c93a03ba491050abe7124cbc9479c0cecdbe82c5c68e9f0953ace9a0c37e3cb100d00516397cb3ce
将admin密码设置成和secadmin密码相同(xxx替换成secadmin密码)
update framework.IAM_ACCOUNT set PASSWORD='10000:5dc307caa97a504e25a3bbdef2886502:ff31dc78656de0b7d2cc3e7c47b9274856962bf96d3a7120c93a03ba491050abe7124cbc9479c0cecdbe82c5c68e9f0953ace9a0c37e3cb100d00516397cb3ce' where USER_NAME='secadmin';
update framework.IAM_ACCOUNT set PASSWORD='10000:5dc307caa97a504e25a3bbdef2886502:ff31dc78656de0b7d2cc3e7c47b9274856962bf96d3a7120c93a03ba491050abe7124cbc9479c0cecdbe82c5c68e9f0953ace9a0c37e3cb100d00516397cb3ce' where USER_NAME='secauditor';
commit;
Pacific 的admin密码重置方法 :
使用“PuTTY”通过FSM浮动管理IP登录FSM主节点。
执行“su - ommdba”命令,切换到“ommdba”用户。
执行“/opt/dfv/oam/oam-u/oam-gaussdb/app/bin/gsql -h 127.0.0.1 -p 21600 -d POSTGRES -U omm -W IaaS@DATABASE-PublicCLOUD9!”命令,进入到gaussdb操作命令行。
执行“update DB_AA_USER_INFO_S set sv_passwd='$7$RX7fVZ6FzJCrAa.a$W3h787fGRzU8QGvrZBhJi1E3kvE3HMtshadHOHzCAWQ=' where sv_username='admin';”命令重置admin用户的密码为默认密码Admin@storage。