Install/iRedAPD/MySQL - Revision history

ZhangHuangbin at 16:58, 2 March 2013

ZhangHuangbin — Sat, 02 Mar 2013 16:58:02 GMT

← Older revision		Revision as of 16:58, 2 March 2013
Line 1:		Line 1:
	__TOC__		__TOC__
		+
		+	NOTE: This installation guide is for '''iRedAPD-1.3.8''' and earlier versions, please check the latest installation guide here: [https://bitbucket.org/zhb/iredapd/src/default/README.md?at=default Install the latest iRedAPD].

	= Summary & Feature List =		= Summary & Feature List =

ZhangHuangbin: /* Available access policies */

ZhangHuangbin — Sat, 02 Mar 2013 14:47:30 GMT

Available access policies

← Older revision		Revision as of 14:47, 2 March 2013
Line 196:		Line 196:
	<td>Moderators Only</td>		<td>Moderators Only</td>
	<td>Only moderators can send mail to this address</td>		<td>Only moderators can send mail to this address</td>
-	<td>~~moderatorsOnly~~</td>	+	<td>allowedOnly</td>
	</tr>		</tr>

ZhangHuangbin: /* Configure postfix */

ZhangHuangbin — Sat, 02 Mar 2013 14:46:33 GMT

Configure postfix

← Older revision		Revision as of 14:46, 2 March 2013
Line 122:		Line 122:
	smtpd_recipient_restrictions =		smtpd_recipient_restrictions =
	...		...
-	check_policy_service inet:127.0.0.1:7777, # <-- Insert this line	+	check_policy_service inet:127.0.0.1:7777, # <-- Insert this line before "permit_mynetworks"
	permit_mynetworks,		permit_mynetworks,
	permit_sasl_authenticated,		permit_sasl_authenticated,

ZhangHuangbin: /* Download and configure iRedAPD */

ZhangHuangbin — Sat, 02 Mar 2013 14:45:28 GMT

Download and configure iRedAPD

← Older revision		Revision as of 14:45, 2 March 2013
Line 100:		Line 100:

	# For MySQL and PostgreSQL backends.		# For MySQL and PostgreSQL backends.
-	~~server~~ = "127.0.0.1"	+	sql_server = "127.0.0.1"
-	db = "vmail"	+	sql_db = "vmail"
-	~~user~~ = "vmail"	+	sql_user = "vmail"
-	~~password~~ = "Psaf68wsuVctYSbj4PJzRqmFsE0rlQ"	+	sql_password = "Psaf68wsuVctYSbj4PJzRqmFsE0rlQ"
	</pre>}}		</pre>}}

ZhangHuangbin: /* Download and configure iRedAPD */

ZhangHuangbin — Sat, 02 Mar 2013 14:43:06 GMT

Download and configure iRedAPD

← Older revision		Revision as of 14:43, 2 March 2013
Line 115:		Line 115:
	** on Debian/Ubuntu:{{cmd\|<pre>$ update-rc.d iredapd defaults</pre>}}		** on Debian/Ubuntu:{{cmd\|<pre>$ update-rc.d iredapd defaults</pre>}}
	** on FreeBSD, you should append below line to '''/etc/rc.conf''':{{cfg\|/etc/rc.conf\|<pre>iredapd_enable='YES'</pre>}}		** on FreeBSD, you should append below line to '''/etc/rc.conf''':{{cfg\|/etc/rc.conf\|<pre>iredapd_enable='YES'</pre>}}
-	** on OpenBSD, you should append ~~below line to~~ '''/etc/rc.conf.local''': {{cfg\|/etc/rc.conf.local\|<pre>~~iredapd_flags~~=~~'YES'~~</pre>}}	+	** on OpenBSD, you should append "iredapd" in parameter "pkg_scripts" in '''/etc/rc.conf.local''': {{cfg\|/etc/rc.conf.local\|<pre>pkg_scripts=" ... iredapd"</pre>}}

	= Configure postfix =		= Configure postfix =

ZhangHuangbin: /* Download and configure iRedAPD */

ZhangHuangbin — Sat, 02 Mar 2013 14:38:30 GMT

Download and configure iRedAPD

← Older revision		Revision as of 14:38, 2 March 2013
Line 76:		Line 76:
	* Open /opt/iredapd/settings.py and set correct values:		* Open /opt/iredapd/settings.py and set correct values:
	{{cfg\|/opt/iredapd/settings.py\|<pre>		{{cfg\|/opt/iredapd/settings.py\|<pre>
-	~~[general]~~
	# Listen address and port.		# Listen address and port.
	listen_address = "127.0.0.1"		listen_address = "127.0.0.1"
Line 96:		Line 95:
	# Backend: ldap, mysql, pgsql.		# Backend: ldap, mysql, pgsql.
	backend = "ldap"		backend = "ldap"
-
-	~~[mysql]~~
-	~~# For MySQL backend only.~~
-	~~server = 127.0.0.1~~
-	~~db = vmail~~
-	~~user = vmail~~
-	~~password = Psaf68wsuVctYSbj4PJzRqmFsE0rlQ~~
-	~~alias_table = alias~~

	# Enabled plugins.		# Enabled plugins.
-	plugins = sql_alias_access_policy	+	plugins = ["sql_alias_access_policy"]
		+
		+	# For MySQL and PostgreSQL backends.
		+	server = "127.0.0.1"
		+	db = "vmail"
		+	user = "vmail"
		+	password = "Psaf68wsuVctYSbj4PJzRqmFsE0rlQ"
	</pre>}}		</pre>}}

Line 118:		Line 115:
	** on Debian/Ubuntu:{{cmd\|<pre>$ update-rc.d iredapd defaults</pre>}}		** on Debian/Ubuntu:{{cmd\|<pre>$ update-rc.d iredapd defaults</pre>}}
	** on FreeBSD, you should append below line to '''/etc/rc.conf''':{{cfg\|/etc/rc.conf\|<pre>iredapd_enable='YES'</pre>}}		** on FreeBSD, you should append below line to '''/etc/rc.conf''':{{cfg\|/etc/rc.conf\|<pre>iredapd_enable='YES'</pre>}}
		+	** on OpenBSD, you should append below line to '''/etc/rc.conf.local''': {{cfg\|/etc/rc.conf.local\|<pre>iredapd_flags='YES'</pre>}}

	= Configure postfix =		= Configure postfix =

ZhangHuangbin: /* Download and configure iRedAPD */

ZhangHuangbin — Sat, 02 Mar 2013 11:46:29 GMT

Download and configure iRedAPD

← Older revision		Revision as of 11:46, 2 March 2013
Line 60:		Line 60:
	</pre>}}		</pre>}}

-	* Copy RC script to /etc/init.d/ (Linux) or /usr/local/etc/rc.d/ (FreeBSD).	+	* Copy RC script to /etc/init.d/ (Linux) or /usr/local/etc/rc.d/ (FreeBSD). Note: We have RC script for different Linux/BSD distributions, please copy the one matches your distribution.
	{{cmd\|<pre>		{{cmd\|<pre>
	# cp /opt/iredapd/rc_scripts/iredapd.rhel /etc/init.d/iredapd		# cp /opt/iredapd/rc_scripts/iredapd.rhel /etc/init.d/iredapd
Line 66:		Line 66:
	</pre>}}		</pre>}}

-	* Copy sample setting file:	+	* Copy sample setting file and set correct file permission:
	{{cmd\|<pre>		{{cmd\|<pre>
-	# cp /opt/iredapd/~~etc/iredapd~~.~~ini~~.sample /opt/iredapd/~~etc~~/iredapd.~~ini~~	+	# cp /opt/iredapd/settings.py.sample /opt/iredapd/settings.py
		+	# chown iredapd:iredapd /opt/iredapd/settings.py
		+	# chmod 0500 /opt/iredapd/settings.py
	</pre>}}		</pre>}}
		+	Warning: settings.py contains LDAP/SQL username and password, please don't make it world readable.

-	* Open /opt/iredapd/~~etc/iredapd~~.~~ini~~ and set correct values:	+	* Open /opt/iredapd/settings.py and set correct values:
-	{{cfg\|/opt/iredapd/~~etc/iredapd~~.~~ini~~\|<pre>	+	{{cfg\|/opt/iredapd/settings.py\|<pre>
	[general]		[general]
	# Listen address and port.		# Listen address and port.
-	~~listen_addr~~ = 127.0.0.1	+	listen_address = "127.0.0.1"
-	listen_port = 7777	+	listen_port = "7777"

-	~~run_as_user = iredapd~~	+	# Daemon user.
-		+	run_as_user = "iredapd"
-	# ~~Background/daemon mode: yes, no~~.	+
-	~~run_as_daemon~~ = ~~yes~~	+

	# Path to pid file.		# Path to pid file.
-	pid_file = /var/run/iredapd.pid	+	pid_file = "/var/run/iredapd.pid"

	# Log type: file.		# Log type: file.
-	~~log_type = file~~	+	log_file = "/var/log/iredapd.log"
-	log_file = /var/log/iredapd.log	+

	# Log level: info, warning, error, debug.		# Log level: info, warning, error, debug.
	# 'info' is recommended for product use.		# 'info' is recommended for product use.
-	log_level = info	+	log_level = "info"

-	# Backend: ldap, mysql.	+	# Backend: ldap, mysql, pgsql.
-	backend = ~~mysql~~	+	backend = "ldap"

	[mysql]		[mysql]

ZhangHuangbin at 11:42, 2 March 2013

ZhangHuangbin — Sat, 02 Mar 2013 11:42:32 GMT

← Older revision		Revision as of 11:42, 2 March 2013
Line 1:		Line 1:
	__TOC__		__TOC__
-
-	~~{{Install/iRedAPD/MySQL/Languages}}~~

	= Summary & Feature List =		= Summary & Feature List =
		+
	* iRedAPD is designed to work in conjunction with Postfix as an Access Policy Delegation daemon, with plugin support.		* iRedAPD is designed to work in conjunction with Postfix as an Access Policy Delegation daemon, with plugin support.
-	* Currently, it works with ~~both~~ OpenLDAP ~~and~~ MySQL ~~backend~~.	+	* Currently, it works with OpenLDAP, MySQL and PostgreSQL backends.
	{{iRedAPD/Plugins}}		{{iRedAPD/Plugins}}

	= Requirements =		= Requirements =
		+	* iRedMail: All iRedMail versions should work as expected.
	* Python >= 2.4, core programming language.		* Python >= 2.4, core programming language.
	* Python-MySQLdb, is the Python DB API-2.0 interface.		* Python-MySQLdb, is the Python DB API-2.0 interface.
-	* web.py >= 0.3.0, a web framework for python that is as simple as it is powerful.	+	* web.py >= 0.3.5, a web framework for python that is as simple as it is powerful.
-	* DBUtils, is a suite of tools providing solid, persistent and pooled connections to a database.	+
-	* iRedMail: All iRedMail versions should work as expected.	+
-		+
-	~~= Alter MySQL Table =~~	+
-	~~Plugin '''sql_alias_access_policy''' requires two more columns in '''vmail.alias''' table, used to store access policy and addresses of moderators.~~	+
-	~~{{cmd\|<pre>~~	+
-	~~mysql> USE vmail;~~	+
-	~~mysql> ALTER TABLE alias ADD COLUMN accesspolicy VARCHAR(30) NOT NULL DEFAULT '';~~	+
-	~~mysql> ALTER TABLE alias ADD COLUMN moderators TEXT NOT NULL DEFAULT '';~~	+
-	~~</pre>}}~~	+

	= Create new user =		= Create new user =
Line 28:		Line 18:
	{{cmd\|<pre>		{{cmd\|<pre>
	#		#
-	# ---- On RHEL/CentOS/Debian/Ubuntu ----	+	# ---- On RHEL/CentOS/Debian/Ubuntu/OpenBSD ----
	#		#
	# useradd -s /sbin/nologin -M -d /home/iredapd -c "iRedAPD daemon user" iredapd		# useradd -s /sbin/nologin -M -d /home/iredapd -c "iRedAPD daemon user" iredapd
Line 43:		Line 33:
	{{cmd\|<pre>		{{cmd\|<pre>
	# yum install MySQL-python python-setuptools		# yum install MySQL-python python-setuptools
-	# easy_install web.py ~~DBUtils~~	+	# easy_install web.py
	</pre>}}		</pre>}}

Line 49:		Line 39:
	{{cmd\|<pre>		{{cmd\|<pre>
	$ sudo apt-get install python-setuptools python-mysqldb		$ sudo apt-get install python-setuptools python-mysqldb
-	$ sudo easy_install web.py ~~DButils~~	+	$ sudo easy_install web.py
	</pre>}}		</pre>}}

Line 58:		Line 48:

	# cd /usr/ports/www/webpy/		# cd /usr/ports/www/webpy/
-	~~# make install clean~~
-
-	~~# cd /usr/ports/databases/py-dbutils/~~
	# make install clean		# make install clean
	</pre>}}		</pre>}}

	= Download and configure iRedAPD =		= Download and configure iRedAPD =
-	* Download iRedAPD from [~~http~~://~~www.iredmail~~.org/~~download.html#~~iredapd ~~download~~ page].	+
		+	* Download iRedAPD from [https://bitbucket.org/zhb/iredapd/downloads Download page].
	* Copy iRedAPD to /opt/, set correct file permissions, and create symbol link.		* Copy iRedAPD to /opt/, set correct file permissions, and create symbol link.
	{{cmd\|<pre>		{{cmd\|<pre>
	# tar xjf iRedAPD-x.y.z.tar.bz2 -C /opt/		# tar xjf iRedAPD-x.y.z.tar.bz2 -C /opt/
	# ln -s /opt/iRedAPD-x.y.z /opt/iredapd		# ln -s /opt/iRedAPD-x.y.z /opt/iredapd
-	~~# chmod +x /opt/iredapd/src/iredapd.py~~
	</pre>}}		</pre>}}

-	* Copy ~~necessary~~ RC script to /etc/init.d/ (Linux) or /usr/local/etc/rc.d/ (FreeBSD):	+	* Copy RC script to /etc/init.d/ (Linux) or /usr/local/etc/rc.d/ (FreeBSD).
	{{cmd\|<pre>		{{cmd\|<pre>
-	# cp /opt/iredapd/rc_scripts/iredapd /etc/init.d/iredapd	+	# cp /opt/iredapd/rc_scripts/iredapd.rhel /etc/init.d/iredapd
	# chmod +x /etc/init.d/iredapd		# chmod +x /etc/init.d/iredapd
	</pre>}}		</pre>}}

ZhangHuangbin: /* Add moderators for mail alias */

ZhangHuangbin — Sat, 16 Jun 2012 00:40:37 GMT

Add moderators for mail alias

← Older revision		Revision as of 00:40, 16 June 2012
Line 224:		Line 224:
	To add moderators for certain mail alias, just list all email addresses of moderators in SQL column '''moderators''', multiple addresses must be separated by comma. For example:		To add moderators for certain mail alias, just list all email addresses of moderators in SQL column '''moderators''', multiple addresses must be separated by comma. For example:
	{{cmd\|<pre>		{{cmd\|<pre>
-	sql> UPDATE alias SET moderators='user1@domain.ltd,user2@domain.ltd,user3@domain.ltd' WHERE address='~~myalias~~@domain.ltd';	+	sql> UPDATE alias SET moderators='user1@domain.ltd' WHERE address='myalias01@domain.ltd';
		+	sql> UPDATE alias SET moderators='user1@domain.ltd,user2@domain.ltd,user3@domain.ltd' WHERE address='myalias02@domain.ltd';
	</pre>}}		</pre>}}

	= Troubleshooting & Debug =		= Troubleshooting & Debug =
	If iRedAPD doesn't work as expected, you can simplily set '''log_level = debug''' in '''/opt/iredapd/etc/iredapd.ini''', restart iredapd and monitor its log file '''/var/log/iredapd.log''', create a new forum topic in [http://www.iredmail.org/forum/ iRedMail forum] and paste log message in forum topic.		If iRedAPD doesn't work as expected, you can simplily set '''log_level = debug''' in '''/opt/iredapd/etc/iredapd.ini''', restart iredapd and monitor its log file '''/var/log/iredapd.log''', create a new forum topic in [http://www.iredmail.org/forum/ iRedMail forum] and paste log message in forum topic.

ZhangHuangbin: /* Available access policies */

ZhangHuangbin — Sat, 16 Jun 2012 00:40:00 GMT

Available access policies

← Older revision		Revision as of 00:40, 16 June 2012
Line 220:		Line 220:
	</tr>		</tr>
	</table>		</table>
		+
		+	= Add moderators for mail alias =
		+	To add moderators for certain mail alias, just list all email addresses of moderators in SQL column '''moderators''', multiple addresses must be separated by comma. For example:
		+	{{cmd\|<pre>
		+	sql> UPDATE alias SET moderators='user1@domain.ltd,user2@domain.ltd,user3@domain.ltd' WHERE address='myalias@domain.ltd';
		+	</pre>}}

	= Troubleshooting & Debug =		= Troubleshooting & Debug =
	If iRedAPD doesn't work as expected, you can simplily set '''log_level = debug''' in '''/opt/iredapd/etc/iredapd.ini''', restart iredapd and monitor its log file '''/var/log/iredapd.log''', create a new forum topic in [http://www.iredmail.org/forum/ iRedMail forum] and paste log message in forum topic.		If iRedAPD doesn't work as expected, you can simplily set '''log_level = debug''' in '''/opt/iredapd/etc/iredapd.ini''', restart iredapd and monitor its log file '''/var/log/iredapd.log''', create a new forum topic in [http://www.iredmail.org/forum/ iRedMail forum] and paste log message in forum topic.