[MySQL] Section

In the [MySQL] section settings for interaction between Dr.Web MailD and MySQL database are specified:

User = {string}

MySQL database user name.

Default value:

User =

Password = {string}

MySQL database password.

Default value:

Password =

DB = {string}

Name of the MySQL database.

Default value:

DB =

Host = {hostname}

Name of the host used by MySQL database.

Default value:

Host = localhost

Port = {address}

Port used to connect to MySQL database.

It is also required to specify a prefix that indicates the socket type: TCP or UNIX.

Example:

When TCP-socket is used:

Port = tcp://1234

When UNIX socket is used:

Port = unix:///path/to/socket

Default value:

Port =

Connections = {numerical value}

Number of simultaneous connections to the MySQL database.

When the parameter value is set to 0, connections are created as a query to the database is performed (it usually takes additional time). Connections opened in advance can service database queries in turn without consuming time for reconnection.

Default value:

Connections = 4

SizeLimit = {numerical value}

Maximum number of strings received in response to a single database request.

When the parameter value is set to 0, maximum number of received strings is not limited.

The parameter value can also be locally overridden in a Lookup.

Default value:

SizeLimit = 10

Lib = {path to file}

Path to libmysqlclient.so library.

Library must be built with thread support.

Default value:

Lib = /usr/lib/libmysqlclient_r.so

SkipDomains = {LookupLite}

List of domains for which request to database is not required.

This parameter often allows to improve total performance and considerably reduce server load.

Please note that the parameter value is LookupLite.

The parameter value can also be locally overridden in a Lookup.

Default value:

SkipDomains =

OnError = {ignore | exception}

Sets the mode of error handling (errors that occur in Lookup when connecting to the specified data source).

Allowed modes:

•ignore – ignore the error and continue message processing (the error is only logged);

•exception – generate an exception which is handled as a message processing error. The handling method corresponds to the ProcessingError parameter value set for the module in operation of which this error occurred.

The parameter value can also be locally overridden in a Lookup.

Default value:

OnError = ignore

Note that when using libmysqlclient_r.so library in FreeBSD 6.4/amd64 the following error may occur:

Undefined symbol "gethostbyname_r"

If the specified host or MySQL database are not accessible, connection is attempted to be established during 2 seconds. After the timeout occurs, an error is logged and handled according to the OnError parameter value.