It is possible to store quarantined messages not only in the file system, but also in a DBI storage. To use this feature, DBI storage must be pre-configured. For detailed description of DBI modules setup and adjustment for operation with databases, refer to documentation on DBI. To enable successful transfer of messages to the database, the database must be created with the use of SQL-ASCII symbol set.
|
Interaction with DBI is performed only via an external utility, path to which is specified in the PathToDrwebQp parameter ([Quarantine] section). By default, drweb-qp is used. The utility is supplied with Dr.Web MailD and resides in %bin_dir directory. To use drweb-qp, Perl (not older than 5.0) and installed Perl DBI and File::Temp modules are required. |
To use DBI, set Yes value for the MoveToDBI parameter and configure DBISettings, DBIUsername and DBIPassword correspondingly to enable access to DBI storage.
Moreover, you need to configure the following SQL commands to perform required actions:
oSQLInsertCommand - this command adds a mail message to the DBI storage.
oSQLRemoveCommand - this command removes a mail message from the DBI storage. It is used when limitation on time to a message in Quarantine is set.
oSQLSelectCommand - this command provides access to the message stored in the DBI storage. It is used when a message is requested (for example, via the control message) from Quarantine.
Possible problems:
If you encounter an error of the following type:
maild ERROR Error in system call for [/opt/drweb/drweb-qp --Level debug --SyslogFacility Daemon --BaseDir /var/drweb/ --ProcessMail 1 --MoveToDBI 0 --StoredTime 86400 --SQLInsertCommand "" --MDClient "def" >/dev/null 2>&1 &]
try to increase the maximum available amount of memory for drweb-maild process (for example, using ulimit -m command).