|
In the [Oracle] section, settings for interaction between Dr.Web MailD and Oracle database are specified:
Lib = {path to file}
|
Path to library that supports Oracle OTL version 8 or later.
Library must be built with thread support. The library is searched according to the standard rules used by dlopen system call (please refer to the corresponding documentation).
In the current version this parameter cannot be changed with SIGHUP signal, restart of Dr.Web MailD is required.
|
Default value:
Lib =
|
ConnectData = {string}
|
Oracle connection parameters.
The following two formats are supported:
•"USER/PASSWORD@СONNECTION" - Oracle syntax; •"DSN=value;UID=value;PWD=value" - ODBC syntax. To start working with Oracle, specify DSN that references to the required database.
To see the rules of setting ConnectData value with the use of Oracle syntax, refer to the notes under the table.
In addition, it is recommended to use the connect_timeout parameter in the ConnectData string (this parameter specifies connection timeout).
The parameter value can also be locally overridden in a Lookup.
|
Default value:
ConnectData =
|
SizeLimit = {numerical value}
|
Maximum number of strings received in response to a single database query.
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 = 0
|
SkipDomains = {LookupLite}
|
List of domains for which query 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 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 Lookup.
|
Default value:
OnError = ignore
|
Notes:
1.Dr.Web MailD uses the libclntsh library to connect to Oracle databases (it is distributed with Oracle client and supports OTL v8 or later). 2.To connect to Oracle database, specify username, password and connection name for the ConnectData parameter in the following format user/password@CONNECTION. You can specify the connection name in one of the following ways:
•if Oracle DBMS is installed on the same computer as Dr.Web MailD, define environment variable ORACLE_HOME for Dr.Web MailD (as per the Oracle DBMS documentation). After that, specify one of the TNS names in file $ORACLE_HOME/network/admin/tnsnames.ora as the connection name; •copy the connection description (without line breaks) from the $ORACLE_HOME/network/admin/tnsnames.ora file located on the server. Example:
Let us assume that there is an tnsnames.ora file:
CONNECTIONNAME =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = CONNECTIONNAME)
)
)
As the connection string (the ConnectData parameter value), it is possible to specify either:
user/password@CONNECTIONNAME
or:
user/pasword@(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))(CONNECT_DATA = SERVER = DEDICATED)(SERVICE_NAME = CONNECTIONNAME)))
3.If the specified host or database are not accessible, connection is attempted to be established until timeout occurs (the timeout value is specified for the connect_timeout parameter in the connection string). After that, an error is fixed and handled according to the action set for the OnError parameter.
|