IRedMail/FAQ/Integrate.MySQL.in.Amavisd - Revision history

ZhangHuangbin: /* Steps */

ZhangHuangbin — Wed, 20 Apr 2011 08:34:02 GMT

Steps

← Older revision		Revision as of 08:34, 20 April 2011
Line 28:		Line 28:
	** '''WARNING''': Please replace 'secret_passwd' below with your own password.		** '''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>}}

ZhangHuangbin — Fri, 11 Mar 2011 07:12:28 GMT

Steps

← Older revision		Revision as of 07:12, 11 March 2011
Line 15:		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 25:		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 = (		@lookup_sql_dsn = (

ZhangHuangbin — Sun, 06 Feb 2011 02:20:18 GMT

Steps

← Older revision		Revision as of 02:20, 6 February 2011
Line 33:		Line 33:
	</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/OpenSuSE, 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.

ZhangHuangbin — Thu, 30 Dec 2010 14:40:04 GMT

Steps

← Older revision		Revision as of 14:40, 30 December 2010
Line 33:		Line 33:
	</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, line 19412) or /usr/sbin/amavisd-new (DEBIAN/UBUNTU) 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.

ZhangHuangbin — Wed, 25 Aug 2010 14:44:59 GMT

← Older revision		Revision as of 14:44, 25 August 2010
Line 1:		Line 1:
	__TOC__		__TOC__

-	Note: This ~~is achieved and enabled~~ in iRedMail-0.7.0 and later versions.	+	Note: This integration will be available in iRedMail-0.7.0 and later versions.

	= Summary =		= Summary =

ZhangHuangbin — Tue, 24 Aug 2010 04:26:39 GMT

← Older revision

Revision as of 04:26, 24 August 2010

ZhangHuangbin — Tue, 24 Aug 2010 04:26:00 GMT

ZhangHuangbin — Tue, 24 Aug 2010 04:22:37 GMT

← Older revision		Revision as of 04:22, 24 August 2010
Line 1:		Line 1:
	__TOC__		__TOC__

-	Note: This is achieved in iRedMail-0.7.0 and later versions.	+	Note: This is achieved and enabled in iRedMail-0.7.0 and later versions.

	= Summary =		= Summary =

ZhangHuangbin — Tue, 24 Aug 2010 04:22:19 GMT

← Older revision		Revision as of 04:22, 24 August 2010
Line 1:		Line 1:
		+	__TOC__
		+
	Note: This is achieved in iRedMail-0.7.0 and later versions.		Note: This is achieved 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>

ZhangHuangbin — Tue, 24 Aug 2010 04:21:40 GMT

← Older revision		Revision as of 04:21, 24 August 2010
Line 1:		Line 1:
		+	Note: This is achieved in iRedMail-0.7.0 and later versions.
		+
		+	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.
		+
	* 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>