Knowledgebase business article search

Migrate ESET Security Management Center from Windows Server to ESET Security Management Center Virtual Appliance

Issue

In order to migrate ESET Security Management Center (ESMC) Server from Windows Server to ESET Security Management Center Virtual Appliance (ESMC VA), you will need to back up the database from Windows Server and restore it into the ESMC Virtual Appliance.

Prerequisites:

  • ESMC Server version 7.0 or newer with database running at MySQL Server
  • ESMC Server database must use a default name “era_db” and username “root”.

Important!

The following guide is only applicable to ESET Security Management Center running a MySQL database.

 

Solution

  1. Click here to download the ESET Security Management Center Virtual Appliance (ESMC VA) for your particular hypervisor type. Deploy the ESMC VA into your virtual environment, for further information regarding this process, review the VA Deployment support page. Do not configure the ESMC VA yet. After a successful deployment, check the IP address of the new ESMC Virtual Appliance in the main screen.
     
  2. On your existing Windows ESMC Server, create a new policy to set a new ESMC Server IP address and assign the policy to all client computers. Click Admin > Policies > New Policy.

Figure 1-1
Click the image to view larger in new window

  1. Enter a name for your policy, the Description field is optional. Expand the Settings tab, in the drop-down menu, select ESET Management Agent and click Edit server list.

Figure 1-2
Click the image to view larger in new window

  1. In the Servers window, click Add. In the Host field, type the IP address of your new ESMC VA. If you are using a different port, other than the default ESMC Server port 2222, specify your custom port number. Click OK. Make sure your new ESMC Server address is listed first and click Save.

Figure 1-3
 

  1. Expand the Assign tab to specify the clients that are targeted by this policy. Click the Assign button to display a new popup window with all Static and Dynamic Groups.

Figure 1-4
Click the image to view larger in new window

 

  1. Select the Static Group All to assign a new policy and click OK.

Figure 1-5
Click the image to view larger in new window

  1. Review the settings for this policy and click Finish to apply. According to your ESMC Server settings, wait until the new policy is applied to agents.
     
  2. Stop the ESMC Server service.
     
  3. Create a full database backup of the source ESMC database. It is required that the ESMC database is named era_db. Name the backup file era-backup.sql. Open a Command prompt and navigate to the MySQL Server binaries folder (default location is C:\Program Files\MySQL\MySQL Server x.x\bin) and run the following commands:

a. Delete the contents of tbl_authentication_certificate table (otherwise, Agents may fail to connect to the new Server):

mysql.exe -u root -p -e "delete from era_db.tbl_authentication_certificate where certificate_id = 1;"

b. Create a database backup:

mysqldump --host localhost --disable-keys --extended-insert --routines -u root -p era_db > era-backup.sql

  1. Return to the ESMC VA main screen. Press Enter to enter management mode, log in using the default password “eraadmin”, and press Enter twice to confirm.

Figure 1-6
 

  1. Enable the Webmin interface. In the ESMC VA management mode menu, select Enable/Disable Webmin interface. Connect to the Webmin interface using a web browser with an IP address of ESMC VA and port 10000. The address to connect should look like: https://xxx.xxx.xxx.xxx:10000
     
  2. Log into the Webmin interface using the default ESMC VA credentials where root is the login and eraadmin is the password.

Figure 1-7

 

  1. From the main menu, expand the Others and select File Manager. Navigate to folder /root/.

Figure 1-8

 

  1. In the top right corner of File Manager, click File and select Upload to current folder.

Figure 1-9
Click the image to view larger in new window

 

  1. Click Upload Files and locate the era-backup.sql file you created in step 4. To upload the file, click Upload Files second time. When the upload is complete, log out of Webmin.

Figure 1-10

 

  1. In the ESMC VA main screen, login to management mode. Select Restore database from the menu and press Enter. When the restoral of database backup is finished, press Enter to return back to the main screen.

Figure 1-11

 

  1. Configure the ESMC VA. Connect to the appliance using a web browser with an IP address of the ESMC VA. In the drop-down menu, select ESET Security Management Center Server Appliance.

Figure 1-12

 

  1. Set a new password for the VM and click Submit to start ESMC VA configuration. Do not refresh this page in your web browser, close the tab and go to your ESMC VA console window.

Figure 1-13

 

  1. When configuration is finished, log into the ESMC Web Console using the new password and verify the agents have migrated successfully and are connecting to the new server. Do not uninstall your old Windows ESMC Server until you have verified migration was successful.


Was this information helpful?