Addition/Install.PostfixAdmin.For.MySQL.Backend - Revision history

ZhangHuangbin: /* Add missing SQL tables in database 'vmail' */

ZhangHuangbin — Sun, 15 Apr 2012 16:42:24 GMT

Add missing SQL tables in database 'vmail'

← Older revision		Revision as of 16:42, 15 April 2012
Line 15:		Line 15:
	= Add missing SQL tables in database 'vmail'=		= Add missing SQL tables in database 'vmail'=

-	Please add below SQL tables for PostfixAdmin:	+	Please add below SQL tables in database '''vmail''' for PostfixAdmin:
	{{cmd\|<pre>		{{cmd\|<pre>
	CREATE TABLE IF NOT EXISTS log (		CREATE TABLE IF NOT EXISTS log (

ZhangHuangbin: /* Summary */

ZhangHuangbin — Sun, 15 Apr 2012 16:41:31 GMT

Summary

← Older revision		Revision as of 16:41, 15 April 2012
Line 12:		Line 12:
	* There's no guarantee to keep iRedMail compatible with PostfixAdmin SQL structure in the future.		* There's no guarantee to keep iRedMail compatible with PostfixAdmin SQL structure in the future.
	* This tutorial is wrote for iRedMail-0.7.0, it probably need some adjustments for later versions.		* This tutorial is wrote for iRedMail-0.7.0, it probably need some adjustments for later versions.
		+
		+	= Add missing SQL tables in database 'vmail'=
		+
		+	Please add below SQL tables for PostfixAdmin:
		+	{{cmd\|<pre>
		+	CREATE TABLE IF NOT EXISTS log (
		+	TIMESTAMP DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
		+	username VARCHAR(255) NOT NULL DEFAULT '',
		+	domain VARCHAR(255) NOT NULL DEFAULT '',
		+	action VARCHAR(255) NOT NULL DEFAULT '',
		+	data VARCHAR(255) NOT NULL DEFAULT '',
		+	KEY TIMESTAMP (TIMESTAMP)
		+	) ENGINE=MyISAM;
		+
		+	CREATE TABLE IF NOT EXISTS vacation (
		+	email VARCHAR(255) NOT NULL DEFAULT '',
		+	subject VARCHAR(255) NOT NULL DEFAULT '',
		+	body TEXT NOT NULL,
		+	cache TEXT NOT NULL,
		+	domain VARCHAR(255) NOT NULL DEFAULT '',
		+	created DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
		+	modified DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
		+	active TINYINT(4) NOT NULL DEFAULT '1',
		+	PRIMARY KEY (email),
		+	KEY email (email)
		+	) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
		+
		+	CREATE TABLE IF NOT EXISTS vacation_notification (
		+	on_vacation VARCHAR(255) NOT NULL,
		+	notified VARCHAR(255) NOT NULL,
		+	notified_at TIMESTAMP NOT NULL DEFAULT now(),
		+	CONSTRAINT vacation_notification_pkey PRIMARY KEY(on_vacation, notified),
		+	FOREIGN KEY (on_vacation) REFERENCES vacation(email) ON DELETE CASCADE
		+	) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
		+	</pre>}}

	=Download and uncompress PostfixAdmin =		=Download and uncompress PostfixAdmin =

ZhangHuangbin: /* Important Notes */

ZhangHuangbin — Fri, 15 Jul 2011 02:37:22 GMT

Important Notes

← Older revision		Revision as of 02:37, 15 July 2011
Line 191:		Line 191:
	= Important Notes =		= Important Notes =

-	Default SQL structure in iRedMail-0.7.0 are slightly changed. In '''"vmail.mailbox"''', transport is set to '' (empty, not a SPACE character) by default, like below:	+	* Default SQL structure in iRedMail-0.7.0 are slightly changed. In '''"vmail.mailbox"''', transport is set to '' (empty, not a SPACE character) by default, like below:
	<pre>		<pre>
	CREATE TABLE IF NOT EXISTS mailbox (		CREATE TABLE IF NOT EXISTS mailbox (
Line 205:		Line 205:
	query = SELECT mailbox.transport FROM mailbox,domain WHERE mailbox.username='%s' AND mailbox.domain='%d' AND mailbox.domain=domain.domain AND mailbox.transport<>'' AND mailbox.active=1 AND mailbox.enabledeliver=1 AND domain.backupmx=0 AND domain.active=1		query = SELECT mailbox.transport FROM mailbox,domain WHERE mailbox.username='%s' AND mailbox.domain='%d' AND mailbox.domain=domain.domain AND mailbox.transport<>'' AND mailbox.active=1 AND mailbox.enabledeliver=1 AND domain.backupmx=0 AND domain.active=1
	</pre>}}		</pre>}}
		+
		+	* [http://code.google.com/p/iredmail/source/detail?r=a9393e05a12acfcc67d04a13eaacc3a5bc51a4ab iRedMail removed 3 tables: log, vacation, vacation_notification.]

ZhangHuangbin: /* Download and uncompress PostfixAdmin */

ZhangHuangbin — Thu, 05 May 2011 02:02:00 GMT

Download and uncompress PostfixAdmin

← Older revision		Revision as of 02:02, 5 May 2011
Line 70:		Line 70:
	# echo '' > motd-users.txt		# echo '' > motd-users.txt
	</pre>}}		</pre>}}
		+
		+	PostfixAdmin will send a welcome message to newly created mail users, but it will be failed since iRedMail requires sender login. Here's a patch to disable welcome message:
		+	* http://iredmail.googlecode.com/hg/tags/0.6.1/patches/postfixadmin/create_mailbox.patch

	= Configure PostfixAdmin =		= Configure PostfixAdmin =

ZhangHuangbin: /* Restart Apache web server to make it work */

ZhangHuangbin — Sun, 17 Apr 2011 01:03:17 GMT

Restart Apache web server to make it work

← Older revision		Revision as of 01:03, 17 April 2011
Line 185:		Line 185:

	Now you can access PostfixAdmin in web browser with URL: httpS://your_server_hostname_or_IP/postfixadmin/		Now you can access PostfixAdmin in web browser with URL: httpS://your_server_hostname_or_IP/postfixadmin/
		+
		+	= Important Notes =
		+
		+	Default SQL structure in iRedMail-0.7.0 are slightly changed. In '''"vmail.mailbox"''', transport is set to '' (empty, not a SPACE character) by default, like below:
		+	<pre>
		+	CREATE TABLE IF NOT EXISTS mailbox (
		+	[...]
		+	transport VARCHAR(255) NOT NULL DEFAULT '',
		+	[...]
		+	</pre>
		+
		+	You can simply change postfix lookup file '''"/etc/postfix/mysql/transport_maps_user.cf"''', append '''"AND transport<>''"''' in '''"query"''' setting.
		+
		+	In iRedMail-0.7.0, it's set to:
		+	{{cfg\|/etc/postfix/mysql/transport_maps_user.cf\|<pre>
		+	query = SELECT mailbox.transport FROM mailbox,domain WHERE mailbox.username='%s' AND mailbox.domain='%d' AND mailbox.domain=domain.domain AND mailbox.transport<>'' AND mailbox.active=1 AND mailbox.enabledeliver=1 AND domain.backupmx=0 AND domain.active=1
		+	</pre>}}

ZhangHuangbin: /* Restart Apache web server to make it work */

ZhangHuangbin — Mon, 04 Apr 2011 13:33:34 GMT

Restart Apache web server to make it work

← Older revision		Revision as of 13:33, 4 April 2011
Line 182:		Line 182:
	* On FreeBSD:		* On FreeBSD:
	{{cmd\|<pre># /usr/local/etc/rc.d/apache22 restart</pre>}}		{{cmd\|<pre># /usr/local/etc/rc.d/apache22 restart</pre>}}
-	~~</pre>~~	+

	Now you can access PostfixAdmin in web browser with URL: httpS://your_server_hostname_or_IP/postfixadmin/		Now you can access PostfixAdmin in web browser with URL: httpS://your_server_hostname_or_IP/postfixadmin/

ZhangHuangbin at 13:30, 4 April 2011

ZhangHuangbin — Mon, 04 Apr 2011 13:30:26 GMT

Show changes

Shake.chen: /* Make PostfixAdmin can be accessed via HTTPS only */

Shake.chen — Fri, 11 Mar 2011 05:59:31 GMT

Make PostfixAdmin can be accessed via HTTPS only

← Older revision		Revision as of 05:59, 11 March 2011
Line 79:		Line 79:

	<Directory "/usrshare/apache2/postfixadmin/">		<Directory "/usrshare/apache2/postfixadmin/">
		+	Options -Indexes
		+	</Directory>
		+
		+	# ---- On OpenSuSE ----
		+	#Create/etc/apache2/conf.d/postfixadmin.conf
		+
		+	<Directory "/srv/www/postfixadmin/">
	Options -Indexes		Options -Indexes
	</Directory>		</Directory>
Line 93:		Line 100:

	Alias /postfixadmin "/usr/share/apache2/postfixadmin/"		Alias /postfixadmin "/usr/share/apache2/postfixadmin/"
		+
		+	# ---- On OpenSuSE ---- /etc/apache2/vhosts.d/vhost-ssl.conf
		+
		+	Alias /postfixadmin "/srv/www/postfixadmin/"
	</pre>		</pre>

Shake.chen: /* Download and configure PostfixAdmin */

Shake.chen — Fri, 11 Mar 2011 05:50:54 GMT

Download and configure PostfixAdmin

← Older revision		Revision as of 05:50, 11 March 2011
Line 9:		Line 9:
	cd /usr/share/apache2		cd /usr/share/apache2

		+	# ---- On OpenSuSE ----
		+	cd /srv/www/

	wget http://www.iredmail.org/yum/misc/postfixadmin-2.3.2.tar.gz		wget http://www.iredmail.org/yum/misc/postfixadmin-2.3.2.tar.gz

Shake.chen: /* Make PostfixAdmin can be accessed via HTTPS only */

Shake.chen — Thu, 10 Mar 2011 08:41:40 GMT

Make PostfixAdmin can be accessed via HTTPS only

← Older revision		Revision as of 08:41, 10 March 2011
Line 67:		Line 67:
	<pre>		<pre>
	# ---- On RHEL/CentOS ----		# ---- On RHEL/CentOS ----
-	vi /etc/httpd/conf.d/postfixadmin.conf	+	# Create /etc/httpd/conf.d/postfixadmin.conf
		+
		+	<Directory "/var/www/postfixadmin/">
		+	Options -Indexes
		+	</Directory>

	# ---- On Debian/Ubuntu ----		# ---- On Debian/Ubuntu ----
-	vi /etc/apache2/conf.d/postfixadmin.conf	+	#Create /etc/apache2/conf.d/postfixadmin.conf

-		+	<Directory "/usrshare/apache2/postfixadmin/">
-		+
-	<Directory "/~~var~~/~~www~~/postfixadmin/">	+
	Options -Indexes		Options -Indexes
	</Directory>		</Directory>
		+
	</pre>		</pre>

Line 82:		Line 85:
	<pre>		<pre>
	# ---- On RHEL/CentOS ---- /etc/httpd/conf.d/ssl.conf		# ---- On RHEL/CentOS ---- /etc/httpd/conf.d/ssl.conf
		+
		+	Alias /postfixadmin "/var/www/postfixadmin/"

	# ---- On Debian/Ubuntu ---- /etc/apache2/sites-enabled/default-ssl		# ---- On Debian/Ubuntu ---- /etc/apache2/sites-enabled/default-ssl

-	Alias /postfixadmin "/~~var~~/~~www~~/postfixadmin/"	+	Alias /postfixadmin "/usr/share/apache2/postfixadmin/"
	</pre>		</pre>

Line 92:		Line 97:
	<pre>		<pre>
	/etc/init.d/httpd restart		/etc/init.d/httpd restart
		+	or
		+	/etc/init.d/apache restart
	</pre>		</pre>