irbis36

Good afternoon! Please tell me, a copy of the ESET PROTECT 8.0.2225.0 server database was made using mysql , after installing a new server, I'm trying to restore with a regular tool through the console, there is an error: Database backup is from version "yes it's empty here" which is not compatible with installed "8.0.2225.0". You need to perform upgrade to restore to this backup. Please deploy new appliance and restore the backup there before continuing with appliance configuration. If you restore a copy of the database using mysql : "mysql -u root -p era_db < /root/era-backup.sql" then the server does not start after that, when you try to log in to the console, an error appears: Login failed: Connection has failed with state "Not connected" after checking the services, it is clear that the eraserver service does not it starts: # service eraserver status Redirecting to /bin/systemctl status eraserver.service ● eraserver.service - ESET PROTECT Server Loaded: loaded (/etc/systemd/system/eraserver.service; enabled; vendor preset: disabled) Active: failed (Result: exit-code) since Fri 2022-09-16 09:14:57 CEST; 1s ago Process: 9246 ExecStart=/opt/eset/RemoteAdministrator/Server/ERAServer --daemon --pidfile /var/run/eraserver.pid (code=exited, status=0/SUCCESS) Main PID: 9247 (code=exited, status=70) Sep 16 09:14:56 eset-esmc-test2 systemd[1]: Starting ESET PROTECT Server... Sep 16 09:14:56 eset-esmc-test2 systemd[1]: Started ESET PROTECT Server. Sep 16 09:14:57 eset-esmc-test2 systemd[1]: eraserver.service: main process exited, code=exited, status=70/n/a Sep 16 09:14:57 eset-esmc-test2 systemd[1]: Unit eraserver.service entered failed state. Sep 16 09:14:57 eset-esmc-test2 systemd[1]: eraserver.service failed. If you look at the server log along the way: /var/log/eset/RemoteAdministrator/Server/trace.log then there is an error: 2022-09-16 07:14:57 Error: Service [Thread 7f68ad515740]: [MySQL][ODBC 8.0(w) Driver][mysqld-5.6.50]PROCEDURE era_db.usp_stored_installers_load_all_valid does not exist (1305) I tried how to roll back the driver version to 5.3 in the knowledge base does not help.

Добрый день! Подскажите пожалуйста была сделана копия базы сервера ESET PROTECT 8.0.2225.0 посредством mysql , после установки нового сервера пытаюсь восстановить штатным средством через консоль, идет ошибка: Database backup is from version "да тут пусто" which is not compatible with installed "8.0.2225.0". You need to perform upgrade to restore to this backup. Please deploy new appliance and restore the backup there before continuing with appliance configuration. Если восстановить копию базы посредством mysql : "mysql -u root -p era_db < /root/era-backup.sql" то после этого сервер не запускается, при попытке зайти в консоль выходит ошибка: Login failed: Connection has failed with state "Not connected" после проверки служб видно что служба eraserver не запускается: # service eraserver status Redirecting to /bin/systemctl status eraserver.service ● eraserver.service - ESET PROTECT Server Loaded: loaded (/etc/systemd/system/eraserver.service; enabled; vendor preset: disabled) Active: failed (Result: exit-code) since Fri 2022-09-16 09:14:57 CEST; 1s ago Process: 9246 ExecStart=/opt/eset/RemoteAdministrator/Server/ERAServer --daemon --pidfile /var/run/eraserver.pid (code=exited, status=0/SUCCESS) Main PID: 9247 (code=exited, status=70) Sep 16 09:14:56 eset-esmc-test2 systemd[1]: Starting ESET PROTECT Server... Sep 16 09:14:56 eset-esmc-test2 systemd[1]: Started ESET PROTECT Server. Sep 16 09:14:57 eset-esmc-test2 systemd[1]: eraserver.service: main process exited, code=exited, status=70/n/a Sep 16 09:14:57 eset-esmc-test2 systemd[1]: Unit eraserver.service entered failed state. Sep 16 09:14:57 eset-esmc-test2 systemd[1]: eraserver.service failed. Если посмотреть лог сервера по пути: /var/log/eset/RemoteAdministrator/Server/trace.log то там ошибка: 2022-09-16 07:14:57 Error: Service [Thread 7f68ad515740]: [MySQL][ODBC 8.0(w) Driver][mysqld-5.6.50]PROCEDURE era_db.usp_stored_installers_load_all_valid does not exist (1305) Пробовал как в базе знаний откатить версию драйвера до 5.3 не помогает.