eSight ICT统一管理系统-V300R010C00-eSight网管页面密码忘记，需要覆盖原密码

1、问题描述：经客户通知eSight网管页面无法登录，经现场分析核实确认为密码丢失且无法找回，需要进去服务器数据库重新覆盖原密码。

2、版本信息：当前eSight版本为 ’‘eSight V300R010C00 安装盘(X86)’‘

硬件无故障告警信息

经与客户沟通后准备实施方案，提前从官网下载好Xshell 工具，具体操作步骤如下。

（1）登录eSight后台，使用ossuser用户执行以下命令登录数据库（双机场景请登录主节点）

（2）进去数据库后执行以下命令：

Xshell 7 (Build 0122)
Copyright (c) 2020 NetSarang Computer, Inc. All rights reserved.

Type `help' to learn how to use Xshell prompt.
[C:/~]$

Connecting to 113.19.8.58:22...
Connection established.
To escape to local shell, press 'Ctrl+Alt+]'.

Authorized users only. All activities may be monitored and reported.

WARNING! The remote SSH server rejected X11 forwarding request.
Last login: Mon Apr  3 14:46:39 2023

Authorized users only. All activities may be monitored and reported.
[root@eSightServer ~]#
[root@eSightServer ~]#
[root@eSightServer ~]#
[root@eSightServer ~]# cd /opt/eSightZenith/app/bin
[root@eSightServer /opt/eSightZenith/app/bin]# ll
total 7432
-r-x------. 1 ossuser ossgroup    4430 Feb 17  2021 Common.py
-r--------. 1 ossuser ossgroup    4288 Feb 17  2021 Common.pyc
-r-x------. 1 ossuser ossgroup   13145 Feb 17  2021 GaussLog.py
-r--------. 1 ossuser ossgroup   10828 Feb 17  2021 GaussLog.pyc
-r-x------. 1 ossuser ossgroup    5997 Feb 17  2021 shutdowndb.sh
-r-x------. 1 ossuser ossgroup   52631 Feb 17  2021 sql_process.py
-r-x------. 1 ossuser ossgroup   30101 Feb 17  2021 uninstall.py
-r-x------. 1 ossuser ossgroup   42875 Feb 17  2021 zctl.py
-r-x------. 1 ossuser ossgroup   27768 Feb 17  2021 zencrypt
-r-x------. 1 ossuser ossgroup 5663632 Feb 17  2021 zengine
-r-x------. 1 ossuser ossgroup 1730864 Feb 17  2021 zsql
[root@eSightServer /opt/eSightZenith/app/bin]# su ossuser
[ossuser@eSightServer /opt/eSight/bin]$ cd /opt/eSightZenith/app/bin
[ossuser@eSightServer /opt/eSightZenith/app/bin]$ zsql sys/Changeme123@127.0.0.1:31611

Warning: SSL connection to server without CA certificate is insecure. Continue anyway? (y/n):y
connected.

SQL> update omssm.omsuser set password = (select substring_index(historypassword, '&rcode=',1) from "OMSSM"."HISTORYPASSWORD" where sequence = 0 and userid  = 'admin') where userid  = 'admin';

1 rows affected.

SQL> update omssm.omsuser set USERPROPERTIES = (select concat('isPBDKF2=1,isDefaultAdmin=true,rcode=', substring_index(historypassword, '&rcode=',-1)) from "OMSSM"."HISTORYPASSWORD" where sequence = 0 and userid  = 'admin') where userid  = 'admin';

1 rows affected.

SQL> update omssm.omsuser set ISINITIALPASSWORD = 1 where userid  = 'admin';

1 rows affected.

SQL> commit;

Succeed.

SQL> SQL> ^H^H^H^H^[[3~
2
3
4
5
6 ^[
7 exit
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23 ^Z
[1]+  Stopped                 zsql sys/Changeme123@127.0.0.1:31611
[ossuser@eSightServer /opt/eSightZenith/app/bin]$
[ossuser@eSightServer /opt/eSightZenith/app/bin]$
[ossuser@eSightServer /opt/eSightZenith/app/bin]$
[ossuser@eSightServer /opt/eSightZenith/app/bin]$ cd /opt/eSight/bin
[ossuser@eSightServer /opt/eSight/bin]$ ./shutdown.sh
Are you sure you want to stop the system? (Please enter y or n):y
Runtime Environment Checking...
stopping eSight system
stopping sysmonitor
stopping sysmonitor done.
stopping watchdog
stopping watchdog done.
stopping svc agents
---------------------------
2 services will be executed
---------------------------
unibi    ............    STOPPED
eSightAgent    ............    STOPPED
stopping svc agents done.
stopping daemons
---------------------------
4 services will be executed
---------------------------
nginx    ............    STOPPED
smsmodemAgent    ............    STOPPED
iempssoAgent    ............    STOPPED
nodejs    ............    STOPPED
stopping daemons done.
stopping eSight system succeeded.
[ossuser@eSightServer /opt/eSight/bin]$
[ossuser@eSightServer /opt/eSight/bin]$ ./startup.sh
Runtime Environment Checking...
Runtime Environment is OK.
starting eSight system
starting watchdog
starting watchdog done.
starting sysmonitor
starting sysmonitor done.
starting eSight daemons
---------------------------
4 services will be executed
---------------------------
smsmodemAgent    ............    RUNNING
iempssoAgent    ............    RUNNING
nginx    ............    RUNNING
nodejs    ............    RUNNING
starting eSight daemons done.
starting eSight svc agents
waiting for eSightAgent starting ......
---------------------------
2 services will be executed
---------------------------
unibi    ............    RUNNING
eSightAgent    ............    RUNNING
starting eSight system succeeded.
[ossuser@eSightServer /opt/eSight/bin]$
[ossuser@eSightServer /opt/eSight/bin]$
[ossuser@eSightServer /opt/eSight/bin]$
[ossuser@eSightServer /opt/eSight/bin]$
Socket error Event: 32 Error: 10053.
Connection closing...Socket close.

Connection closed by foreign host.

Disconnected from remote host(新建会话) at 02:37:36.

Type `help' to learn how to use Xshell prompt.
[C:/~]$

（3）网管重启后，eSight登录密码为初始默认密码

主要定位原因为由于客户修改密码后未进行工作交接，导致原密码忘记无法登陆eSight网管页面。

解决或规避问题的措施和步骤：因eSight网管每隔一段时间需要重新修改密码方可进入，为了规避此类事件再次发生，则需要在修改密码后进行工作交接或者更新运维文档以保存修改后的密码。