求解

林北

这边是ESM信创版的问题，中心是3.0.5.21，这个数据库备份完后生成的.rs文件怎么使用呢，卸载重装没有找到数据库备份文件导入的口，得亏数据量只有一点，话说这个rs包含的内容是啥，包含所有信息吗，账户密码、策略设置、查杀、下发日志啥的

麦青儿

备份还原可还原策略、审计日志、管理员账号、定制报告；不还原包（升级中心-终端基准包、升级中心-终端定制包、升级中心-第三方软件，授权相关数据、日志报告历史文件）

麦青儿

麦青儿 发表于 2025-5-20 16:04
备份还原可还原策略、审计日志、管理员账号、定制报告；不还原包（升级中心-终端基准包、升级中心-终端定制 ...

如何使用备份还原功能：

1.在【系统中心】-【系统设置】-【数据库备份】，单击【关键数据备份】，备份数据库生成.rs文件。如图 0.png

注：安全管理员账号（optAdmin）级联中心-级联管理-数据库备份也可进行备份，还原方式与中心还原方式一致，3.0.50.11将具备该功能。如图 1.png

2.在操作处单击 向下的箭头 图标，将备份文件下载到本地，上传到服务器。
3.在服务器重新安装同版本中心。
4.访问中心界面https://xxx.xxx.xxx.xxx:10443   导入中心原授权，单击下一步。
5.在服务器执行恢复命令 /opt/BDFZ/ESM/bin/restoredb.sh /存放备份文件路径/xxx.rs。如图 2.png
6.执行完访问中心，登录备份前账号即可。

林北

OKOK,感谢感谢，那这个意思就是说除了授权信息其他的数据都在这个rs里对吧

麦青儿

林北 发表于 2025-5-21 09:22
OKOK,感谢感谢，那这个意思就是说除了授权信息其他的数据都在这个rs里对吧

只备份数据库里的数据，详见2楼

林北

OKOK,看到了，感谢

林北

create connection SQLException, url: jdbc:mysql://127.0.0.1:0/RS_ESM_MANAGER?characterEncoding=UTF8&connectTimeout=60000&socketTimeout=60000&tinyInt1isBit=false, errorCode 0, state 08S01
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
        at sun.reflect.GeneratedConstructorAccessor11.newInstance(Unknown Source) ~[?:?]
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.8.0-internal]
        at java.lang.reflect.Constructor.newInstance(Constructor.java:422) ~[?:1.8.0-internal]
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) ~[backprogram-2.0.jar:?]
        at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074) ~[backprogram-2.0.jar:?]
        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2214) ~[backprogram-2.0.jar:?]
        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:781) ~[backprogram-2.0.jar:?]
        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46) ~[backprogram-2.0.jar:?]
        at sun.reflect.GeneratedConstructorAccessor12.newInstance(Unknown Source) ~[?:?]
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.8.0-internal]
        at java.lang.reflect.Constructor.newInstance(Constructor.java:422) ~[?:1.8.0-internal]
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) ~[backprogram-2.0.jar:?]
        at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:352) ~[backprogram-2.0.jar:?]
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:284) ~[backprogram-2.0.jar:?]
        at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:156) ~[backprogram-2.0.jar:?]
        at com.alibaba.druid.filter.FilterAdapter.connection_connect(FilterAdapter.java:787) ~[backprogram-2.0.jar:?]
        at com.alibaba.druid.filter.FilterEventAdapter.connection_connect(FilterEventAdapter.java:38) ~[backprogram-2.0.jar:?]
        at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:150) ~[backprogram-2.0.jar:?]
        at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1659) ~[backprogram-2.0.jar:?]
        at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1723) ~[backprogram-2.0.jar:?]
        at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2838) ~[backprogram-2.0.jar:?]
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
        at sun.reflect.GeneratedConstructorAccessor11.newInstance(Unknown Source) ~[?:?]
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.8.0-internal]
        at java.lang.reflect.Constructor.newInstance(Constructor.java:422) ~[?:1.8.0-internal]
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) ~[backprogram-2.0.jar:?]
        at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074) ~[backprogram-2.0.jar:?]
        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:343) ~[backprogram-2.0.jar:?]
        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2137) ~[backprogram-2.0.jar:?]
        ... 15 more
Caused by: java.net.ConnectException: 拒绝连接
        at java.net.PlainSocketImpl.socketConnect(Native Method) ~[?:1.8.0-internal]
        at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350) ~[?:1.8.0-internal]
        at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206) ~[?:1.8.0-internal]
        at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188) ~[?:1.8.0-internal]
        at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) ~[?:1.8.0-internal]
        at java.net.Socket.connect(Socket.java:589) ~[?:1.8.0-internal]
        at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source) ~[?:?]
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0-internal]
        at java.lang.reflect.Method.invoke(Method.java:497) ~[?:1.8.0-internal]
        at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:326) ~[backprogram-2.0.jar:?]
        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:292) ~[backprogram-2.0.jar:?]
        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2137) ~[backprogram-2.0.jar:?]
        ... 15 more
create connection SQLException, url: jdbc:mysql://127.0.0.1:0/RS_ESM_MANAGER?characterEncoding=UTF8&connectTimeout=60000&socketTimeout=60000&tinyInt1isBit=false, errorCode 0, state 08S01
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
        at sun.reflect.GeneratedConstructorAccessor11.newInstance(Unknown Source) ~[?:?]
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.8.0-internal]
        at java.lang.reflect.Constructor.newInstance(Constructor.java:422) ~[?:1.8.0-internal]
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) ~[backprogram-2.0.jar:?]
        at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074) ~[backprogram-2.0.jar:?]
        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2214) ~[backprogram-2.0.jar:?]
        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:781) ~[backprogram-2.0.jar:?]
        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46) ~[backprogram-2.0.jar:?]
        at sun.reflect.GeneratedConstructorAccessor12.newInstance(Unknown Source) ~[?:?]
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.8.0-internal]
        at java.lang.reflect.Constructor.newInstance(Constructor.java:422) ~[?:1.8.0-internal]
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) ~[backprogram-2.0.jar:?]
        at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:352) ~[backprogram-2.0.jar:?]
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:284) ~[backprogram-2.0.jar:?]
        at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:156) ~[backprogram-2.0.jar:?]
        at com.alibaba.druid.filter.FilterAdapter.connection_connect(FilterAdapter.java:787) ~[backprogram-2.0.jar:?]
        at com.alibaba.druid.filter.FilterEventAdapter.connection_connect(FilterEventAdapter.java:38) ~[backprogram-2.0.jar:?]
        at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:150) ~[backprogram-2.0.jar:?]
        at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1659) ~[backprogram-2.0.jar:?]
        at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1723) ~[backprogram-2.0.jar:?]
        at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2838) ~[backprogram-2.0.jar:?]
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
        at sun.reflect.GeneratedConstructorAccessor11.newInstance(Unknown Source) ~[?:?]
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.8.0-internal]
        at java.lang.reflect.Constructor.newInstance(Constructor.java:422) ~[?:1.8.0-internal]
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) ~[backprogram-2.0.jar:?]
        at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074) ~[backprogram-2.0.jar:?]
        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:343) ~[backprogram-2.0.jar:?]
        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2137) ~[backprogram-2.0.jar:?]
        ... 15 more
Caused by: java.net.ConnectException: 拒绝连接
        at java.net.PlainSocketImpl.socketConnect(Native Method) ~[?:1.8.0-internal]
        at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350) ~[?:1.8.0-internal]
        at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206) ~[?:1.8.0-internal]
        at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188) ~[?:1.8.0-internal]
        at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) ~[?:1.8.0-internal]
        at java.net.Socket.connect(Socket.java:589) ~[?:1.8.0-internal]
        at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source) ~[?:?]
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0-internal]
        at java.lang.reflect.Method.invoke(Method.java:497) ~[?:1.8.0-internal]
        at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:326) ~[backprogram-2.0.jar:?]
        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:292) ~[backprogram-2.0.jar:?]
        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2137) ~[backprogram-2.0.jar:?]
        ... 15 more
[RESTORE]java.lang.NullPointerException
        at cn.com.rising.dao.BaseDao.query(BaseDao.java:119)
        at cn.com.rising.dao.BaseDao.queryFirst(BaseDao.java:126)
        at cn.com.rising.dao.mysql.ManagerDataDao.getManagerData(ManagerDataDao.java:41)
        at cn.com.rising.service.DataService.getDbVersion(DataService.java:473)
        at cn.com.rising.service.DataService.restore(DataService.java:227)
        at cn.com.rising.app.Restore.main(Restore.java:37)

restore db fail

Sorlla

看起来是没生成数据库表结构没生成或者是MySQL没启动，
确保安装后正常执行并已经导入过和之前一样的授权
确保还原操作是root执行
确保重装前后的版本一致

以上都排除过没有问题，明天给您联系一下技术工程师排查一下

林北

这个在客户单位执行的一部分的执行代码的截图，用的root用户执行的，也是原来的管控中心版本没有变动，备份文件名字也没变动，也确认过了文件没问题，这个是什么原因呢

Sorlla

重新安装后确定导入授权之后再执行还原操作，否则数据库表可能还没生成，只有导入授权确定和之前授权一致的情况下才能进行下一步