Database

Top  Previous  Next

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

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.On the Database tab of the Dr.Web Server configuration section, select the type of DB in the Database drop-down list:

IntDB—embedded SQLite2 DB (a component of Dr.Web Server),

ODBC—to use external DB via the ODBC connection,

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,

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). The recommended option when using an embedded database.

2.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.

3.Click Save to apply specified settings.

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 plan to connect external databases via ODBC, then during installation (upgrade) of the Server, in the installer settings, select the Custom option of the installation and in the next window disable the installation of corresponding embedded client in the Database support section.
Otherwise, interaction with DB via ODBC will be impossible because of 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.

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.

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.