IRedMail/FAQ/Integrate.MySQL.in.Amavisd

From iRedMail

(Difference between revisions)
Jump to: navigation, search
(→Steps)
 
(8 intermediate revisions not shown)
Line 1: Line 1:
-
Note: This is achieved in iRedMail-0.7.0 and later versions.
+
__TOC__
 +
 
 +
Note: This integration will be available in iRedMail-0.7.0 and later versions.
 +
 
 +
= Summary =
With MySQL integration, Amavisd can lookup per-user whitelist/blacklist and other policies from MySQL, and store incoming & outgoing email information in MySQL For example, mail size, sender/recipient, subject.
With MySQL integration, Amavisd can lookup per-user whitelist/blacklist and other policies from MySQL, and store incoming & outgoing email information in MySQL For example, mail size, sender/recipient, subject.
 +
= Steps =
* Download SQL structure template file. This template file is extracted from Amavisd doc file: docs/README.sql-mysql.
* Download SQL structure template file. This template file is extracted from Amavisd doc file: docs/README.sql-mysql.
{{cmd|<pre>
{{cmd|<pre>
Line 10: Line 15:
* Create necessary database and import SQL structure template file:
* Create necessary database and import SQL structure template file:
 +
** '''WARNING''': Please replace 'secret_passwd' below with your own password.
{{cmd|<pre>
{{cmd|<pre>
$ mysql -uroot -p
$ mysql -uroot -p
Line 20: Line 26:
* Configure Amavisd in /etc/amavisd.conf (RHEL/CentOS) or /etc/amavis/conf.d/50-user (Debian/Ubuntu) or /usr/local/etc/amavisd.conf (FreeBSD):
* Configure Amavisd in /etc/amavisd.conf (RHEL/CentOS) or /etc/amavis/conf.d/50-user (Debian/Ubuntu) or /usr/local/etc/amavisd.conf (FreeBSD):
 +
** '''WARNING''': Please replace 'secret_passwd' below with your own password.
{{cmd|<pre>
{{cmd|<pre>
-
@lookup_sql_dsn = (
+
@storage_sql_dsn = (
     ['DBI:mysql:database=amavisd;host=localhost;port=3306', 'amavisd', 'secret_passwd'],
     ['DBI:mysql:database=amavisd;host=localhost;port=3306', 'amavisd', 'secret_passwd'],
);
);
-
@storage_sql_dsn = @lookup_sql_dsn;
 
$sql_allow_8bit_address = 1;
$sql_allow_8bit_address = 1;
</pre>}}
</pre>}}
-
* In Amavisd-new-2.6.4 and older versions, it can't store mail subject as "UTF-8" characters, you can fix it by edit /usr/sbin/amavisd (RHEL/CENTOS, line 19412) or /usr/sbin/amavisd-new (DEBIAN/UBUNTU) or /usr/local/sbin/amavisd (FreeBSD):
+
* In Amavisd-new-2.6.4 and older versions, it can't store mail subject as "UTF-8" characters, you can fix it by edit /usr/sbin/amavisd (RHEL/CenTOS/OpenSuSE, near line 19412) or /usr/sbin/amavisd-new (DEBIAN/UBUNTU, near line 18126) or /usr/local/sbin/amavisd (FreeBSD):
{{cfg|/usr/sbin/amavisd|<pre>
{{cfg|/usr/sbin/amavisd|<pre>
   $dbh->do("SET NAMES utf8");          # <-- Add this line.
   $dbh->do("SET NAMES utf8");          # <-- Add this line.
Line 35: Line 41:
* Restart amavisd service.
* Restart amavisd service.
 +
 +
[[Category: iRedMail/FAQ]]
 +
[[Category: iRedMail]]
 +
[[Category: FAQ]]

Current revision as of 08:34, 20 April 2011

Contents


Note: This integration will be available in iRedMail-0.7.0 and later versions.

Summary

With MySQL integration, Amavisd can lookup per-user whitelist/blacklist and other policies from MySQL, and store incoming & outgoing email information in MySQL For example, mail size, sender/recipient, subject.

Steps

  • Download SQL structure template file. This template file is extracted from Amavisd doc file: docs/README.sql-mysql.
Terminal: 
$ cd /tmp/
$ wget http://iredmail.googlecode.com/hg/iRedMail/samples/amavisd.mysql
  • Create necessary database and import SQL structure template file:
    • WARNING: Please replace 'secret_passwd' below with your own password.
Terminal: 
$ mysql -uroot -p
mysql> CREATE DATABASE amavisd DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
mysql> GRANT SELECT,INSERT,UPDATE,DELETE ON amavisd.* TO "amavisd"@localhost IDENTIFIED BY 'secret_passwd';
mysql> USE amavisd;
mysql> SOURCE /tmp/amavisd.mysql;
mysql> FLUSH PRIVILEGES;
  • Configure Amavisd in /etc/amavisd.conf (RHEL/CentOS) or /etc/amavis/conf.d/50-user (Debian/Ubuntu) or /usr/local/etc/amavisd.conf (FreeBSD):
    • WARNING: Please replace 'secret_passwd' below with your own password.
Terminal: 
@storage_sql_dsn = (
    ['DBI:mysql:database=amavisd;host=localhost;port=3306', 'amavisd', 'secret_passwd'],
);
$sql_allow_8bit_address = 1;
  • In Amavisd-new-2.6.4 and older versions, it can't store mail subject as "UTF-8" characters, you can fix it by edit /usr/sbin/amavisd (RHEL/CenTOS/OpenSuSE, near line 19412) or /usr/sbin/amavisd-new (DEBIAN/UBUNTU, near line 18126) or /usr/local/sbin/amavisd (FreeBSD):
File: /usr/sbin/amavisd 
  $dbh->do("SET NAMES utf8");          # <-- Add this line.
  section_time('sql-connect');
  • Restart amavisd service.
Retrieved from "http://iredmail.org/wiki/index.php?title=IRedMail/FAQ/Integrate.MySQL.in.Amavisd"
Personal tools