Database

On the Database tab, you can configure a DBMS required for Dr.Web Server operation.

info

You can get the structure of Dr.Web Server DB via the init.sql script, located in the etc subfolder of Dr.Web Server installation folder.

To specify parameters of operating with the Database

1.In the Number of connections field, specify the maximal number of connections of the Server with database. It is recommended to change default value only after consultation with the technical support.

2.Set the Automatically purge the database after maintenance procedures flag to automatically perform the delayed purging of the database after its initialization, upgrade and import. If the flag is cleared, automatic purge is not performed. In this case, it is recommended to configure the Purge database task in the Server schedule or purge database manually in the Database Management section.

To perform the automatic purging, the hidden task is created in the Server schedule. The task is launched at nearest night after the named maintenance procedures, at 01:17 by local time of the Server. The task is executed only if the Server schedule does not contain another Purge database task within the next 24 hours relative to the named maintenance procedures.

3.On the Database tab of the Dr.Web Server configuration section, select the type of DB in the Database drop-down list:

MySQL—external DB,

ODBC—to use external DB via the ODBC connection,

warning

If warnings or errors occur in Dr.Web Server interaction with Microsoft SQL Server DBMS via the ODBC, please make sure that you are using the latest available DBMS version for this edition.

How to determine updates level, you can find on the following page of Microsoft corporation: https://support.microsoft.com/en-us/kb/321185.

Oracle—external DB for all platforms except FreeBSD,

warning

If an Oracle external DBMS is used via the ODBC connection, it is necessary to install the latest version of the ODBC driver delivered with this DBMS. It is strongly recommended not to use the Oracle ODBC driver supplied by Microsoft.

PostgreSQL—external DB,

SQLite3—embedded DB (a component of Dr.Web Server).

4.Specify requirement settings for DB operation:

For an embedded DB, if necessary, specify the full path to the database file into the Path field and specify the cache size and the data log mode.

The parameters of an external DB are described in detail in the Appendices document in Appendix B. The Description of the DBMS Settings. The Parameters of the DBMS Driver.

5.Click Save to apply specified settings.

info

Dr.Web Server distribution kit contains embedded clients for supported DBMS, so note:

If you plan to use embedded DBMS clients which are supported within Dr.Web Server, then during installation (upgrade) of the Server, in the installer settings, select the Custom option of the installation and in the next window make sure that installation of corresponding embedded DBMS client is enabled in the Database support section.

If you are going to use the Oracle DB as an external database via the ODBC connection, then during installation (upgrading) of the Server, in the installer settings, disable the installation of embedded client for Oracle DBMS (in the Database support → Oracle database driver section).
Otherwise, interaction with the Oracle DB via ODBC will fail because of the libraries conflict.

 

Server installer supports change mode of the product. To add or remove separate components e.g. databases management drivers, it is enough to run Server installer and select the Change option.

Using an embedded DBMS is selected by default. This mode considerably increases the load on the Server. It is recommended to use an external DBMS in large anti-virus networks. Changing the type of the DBMS  is described in the Appendices, document, in the Changing the Type of the DBMS for Dr.Web Enterprise Security Suite section.

warning

An embedded DB can be used, if at most 200-300 stations are connected to the Server. If the hardware configuration of the computer with Dr.Web Server and the load level of other executing tasks are permissible, up to 1000 stations can be connected.

Otherwise, you must use an external DB.

If you use an external DB and more than 10 000 stations are connected to the Server, it is recommended to perform the following minimal requirements:

3 GHz processor CPU,

RAM at least 4 GB for Dr.Web Server and at least 8 GB for the DB server,

UNIX system-based OS.

info

It is possible to perform transactions connected with clearing the database used by Dr.Web Server, in particular to delete records of events and data about the workstations which have not visited the Server for a certain period of time. To clear the database, open the Server schedule and add a corresponding task.