Install/iRedAdmin-Pro/MySQL/FreeBSD - Revision history

ZhangHuangbin at 00:45, 6 May 2012

ZhangHuangbin — Sun, 06 May 2012 00:45:22 GMT

← Older revision		Revision as of 00:45, 6 May 2012
Line 1:		Line 1:
		+	__TOC__
		+
		+	If you already have iRedAdmin open source edition installed, you can migrate from iRedAdmin open source edition to iRedAdmin-Pro with just few steps:
		+	* [[Migrate/iRedAdmin-Pro/OSE-Pro \|Migrate from iRedAdmin open source edition to iRedAdmin-Pro]]
		+
	= Summary =		= Summary =
-	* This installation guide is used to install iRedAdmin-Pro-MySQL~~-1.0~~ on FreeBSD 7.x, 8.x.	+	* This installation guide is used to install iRedAdmin-Pro-MySQL on FreeBSD. Release 7.x, 8.x and 9.x are supported.
-	* iRedAdmin-Pro is official web-based admin panel for iRedMail. There're ~~two~~ editions:	+	* iRedAdmin-Pro is official web-based admin panel for iRedMail. There're three editions available:
	** '''iRedAdmin-Pro-LDAP''': works with OpenLDAP backend.		** '''iRedAdmin-Pro-LDAP''': works with OpenLDAP backend.
	** '''iRedAdmin-Pro-MySQL''': works with MySQL backend.		** '''iRedAdmin-Pro-MySQL''': works with MySQL backend.
-	* ~~[[Release.Notes/~~iRedAdmin-Pro~~/MySQL/1.0 \|Release Notes of iRedAdmin-Pro-MySQL~~-1.~~0]]~~	+	** '''iRedAdmin-Pro-PGSQL''': works with PostgreSQL backend.

	= System requirements =		= System requirements =
-	* iRedMail-0.6.0 ~~and newer versions~~. '~~''Note''': addition update is required~~. ~~We will cover it below~~.	+	* iRedMail-0.8.0 or later releases. If you're looking for installation guide for iRedMail-0.7.4 or eailier releases, please go to [[Install/iRedAdmin-Pro/MySQL/FreeBSD/OLD \|this tutorial]] instead.
-	* Packages:	+	* iRedAdmin-Pro-MySQL-1.3.0 or later releases.
		+
		+	* Required Packages. They all are installed automatically during iRedMail installation.
	** '''Apache''', 2.2+. Web server.		** '''Apache''', 2.2+. Web server.
	*** '''mod_wsgi''' 2.1+. Apache module used to host Python application which supports the Python WSGI interface.		*** '''mod_wsgi''' 2.1+. Apache module used to host Python application which supports the Python WSGI interface.
Line 15:		Line 22:
	*** '''MySQLdb'''. A thread-compatible interface to the popular MySQL database server that provides the Python database API.		*** '''MySQLdb'''. A thread-compatible interface to the popular MySQL database server that provides the Python database API.

-	~~= Update iRedMail =~~	+	iRedAdmin will run with a low-privileged system user: iredadmin, which is created automatically during iRedMail installation, too.
-	~~Addition update is required to use~~ iRedAdmin~~-Pro-MySQL, please follow links to apply them.~~	+
-		+
-	* '''[This step is required for iRedMail-0.6.1 and earlier versions]''' Update MySQL database '''vmail'''. Required by iRedAdmin-Pro.	+
-	~~{{cmd\|<pre>~~	+
-	~~$ mysql -u root -p~~	+
-	~~mysql> USE vmail;~~	+
-		+
-	~~mysql> ALTER TABLE mailbox ADD COLUMN enablesmtpsecured TINYINT(1) NOT NULL DEFAULT '1';~~	+
-	~~mysql> ALTER TABLE admin ADD COLUMN name VARCHAR(255) DEFAULT '' COLLATE utf8_general_ci;~~	+
-	~~mysql> ALTER TABLE alias ADD COLUMN name VARCHAR(255) DEFAULT '' COLLATE utf8_general_ci;~~	+
-	~~mysql> ALTER TABLE domain ADD COLUMN defaultuseraliases TEXT NOT NULL DEFAULT '';~~	+
-	~~mysql> ALTER TABLE domain ADD COLUMN defaultpasswordscheme VARCHAR(10) NOT NULL DEFAULT '';~~	+
-	~~</pre>}}~~	+
-		+
-	* Upgrade Dovecot from 1.1.x to 1.2, so that iRedAdmin-Pro can show real-time quota usage.	+
-	** '''[This step is required for iRedMail-0.6.1 and earlier versions]''' [[iRedMail/FAQ/Upgrade.Dovecot.1.1.to.1.2 \|Upgrade Dovecot 1.1.x to 1.2.x]]	+
-	** [[iRedMail/FAQ/Store.Realtime.Quota.In.MySQL \|Store Real-time Quota in MySQL with Dovecot 1.2]]	+
-		+
-	* If you want to quarnatine SPAM into MySQL, then manage (delete, release) them in iRedAdmin-Pro, below update is required.	+
-	** [[iRedMail/FAQ/Quarantining.Messages \|Quarantining SPAM into MySQL with Amavisd]]	+
-		+
-	~~= Add new system account: iredadmin =~~	+
-		+
-	We will ~~make iRedAdmin~~ run with ~~Apache web server, but as non~~-~~apache, low privilege~~ user: ~~'''~~iredadmin~~'''.~~	+
-	~~{{cmd\|<pre>~~	+
-	~~# pw useradd -s /sbin/nologin -d /home/iredadmin -n iredadmin~~	+
-	~~</pre>}}~~	+
-		+
-	~~= Install necessary packages =~~	+
-		+
-	~~Install several devel binary packages~~, ~~used for building python modules~~.	+
-	~~{{cmd\|<pre>~~	+
-	~~# bash~~	+
-	~~# for p in www/mod_wsgi www/webpy databases/py-dbutils devel/py-Jinja2 databases/py-MySQLdb net/py-netifaces; do cd /usr/ports/${p} && make install clean; done~~	+
-	~~</pre>}}~~	+

	= Download iRedAdmin and configure Apache web server =		= Download iRedAdmin and configure Apache web server =
-
	* Get iRedAdmin:		* Get iRedAdmin:
	** If you purchased iRedAdmin-Pro-MySQL, you should already have it. If not, please mail to '''support@ iredmail.org''' to get a download link.		** If you purchased iRedAdmin-Pro-MySQL, you should already have it. If not, please mail to '''support@ iredmail.org''' to get a download link.
	** If you didn't purchase iRedAdmin-Pro-MySQL, download iRedAdmin open source edition from [http://www.iredmail.org/download.html#iredadmin download page].		** If you didn't purchase iRedAdmin-Pro-MySQL, download iRedAdmin open source edition from [http://www.iredmail.org/download.html#iredadmin download page].
-
	* Copy iRedAdmin to /usr/local/www/, set correct file permissions, and create symbol link.		* Copy iRedAdmin to /usr/local/www/, set correct file permissions, and create symbol link.
	{{cmd\|<pre>		{{cmd\|<pre>
Line 69:		Line 39:
	* Add apache configure file: /usr/local/etc/apache22/Includes/iredadmin.conf.		* Add apache configure file: /usr/local/etc/apache22/Includes/iredadmin.conf.
	{{cfg\|/usr/local/etc/apache22/Includes/iredadmin.conf\|<pre>		{{cfg\|/usr/local/etc/apache22/Includes/iredadmin.conf\|<pre>
-	#
-	~~# Note: Uncomment below two lines if you want to make iRedAdmin accessable via HTTP.~~
-	#
-	~~#WSGIScriptAlias /iredadmin /usr/local/www/iredadmin/iredadmin.py/~~
-	~~#Alias /iredadmin/static /usr/local/www/iredadmin/static/~~
-
	WSGISocketPrefix /var/run/wsgi		WSGISocketPrefix /var/run/wsgi
	WSGIDaemonProcess iredadmin user=iredadmin threads=15		WSGIDaemonProcess iredadmin user=iredadmin threads=15
Line 108:		Line 72:

	* Grant privileges to iredadmin user and set password for it.		* Grant privileges to iredadmin user and set password for it.
-	** '''WARNING''': Here we use '~~secret_passwd~~' as password of iredadmin user, please replace it with your own password.	+
		+	'''WARNING''': Here we use 'plain_passwd' as password of iredadmin user, please replace it with your own password.
	{{cmd\|<pre>		{{cmd\|<pre>
	# mysql -uroot -p		# mysql -uroot -p
-	mysql> GRANT SELECT,INSERT,UPDATE,DELETE ON iredadmin.* TO iredadmin@localhost IDENTIFIED BY '~~secret_passwd~~';	+	mysql> GRANT SELECT,INSERT,UPDATE,DELETE ON iredadmin.* TO iredadmin@localhost IDENTIFIED BY 'plain_passwd';
	mysql> FLUSH PRIVILEGES;		mysql> FLUSH PRIVILEGES;
	</pre>}}		</pre>}}

	= Configure iRedAdmin =		= Configure iRedAdmin =
-	* Copy example config file, and ~~make it not world-writeable~~.	+
		+	The major config file of iRedAdmin is file '''/var/www/iredadmin/settings.ini'''.
		+
		+	* Copy example config file, and set correct file permission.
	{{cmd\|<pre>		{{cmd\|<pre>
	# cd /usr/local/www/iredadmin/		# cd /usr/local/www/iredadmin/
Line 124:		Line 92:
	</pre>}}		</pre>}}

-	* Edit settings.ini ~~and~~ set correct ~~values~~.	+
-	** '''NOTE''': For more inforamtion, please open '''settings.ini''', it's self-documented.	+	'''NOTE''': If you are installing iRedAdmin-Pro, and have iRedAdmin open source edition installed, you can simply copy '''settings.ini''' from open source edition. Don't forget to set correct file owner and permission after copied.
		+
		+
		+	* Edit '''settings.ini'''.
		+
		+	'''NOTE''':
		+	** All required usernames/passwords are stored in '''iRedMail.tips''' which generated during iRedMail installation, placed under iRedMail directory. e.g. /root/iRedMail-0.8.0/iRedMail.tips.
		+	** For more inforamtion, please open '''settings.ini''', it's self-documented.
	{{cfg\|settings.ini\|<pre>		{{cfg\|settings.ini\|<pre>
	[general]		[general]
Line 145:		Line 120:
	* Restart apache web server.		* Restart apache web server.
	{{cmd\|<pre>		{{cmd\|<pre>
-	# ~~/usr/local~~/etc/rc.d/~~apache22~~ restart	+	# /etc/init.d/httpd restart
	</pre>}}		</pre>}}

ZhangHuangbin: /* Update iRedMail */

ZhangHuangbin — Mon, 21 Nov 2011 22:32:09 GMT

Update iRedMail

← Older revision		Revision as of 22:32, 21 November 2011
Line 30:		Line 30:
	</pre>}}		</pre>}}

-	* Upgrade Dovecot from 1.1.x to 1.2, so that iRedAdmin-Pro can show real-time quota usage~~. If you don't need this feature, just skip it. No addition configure is required in iRedAdmin-Pro~~.	+	* Upgrade Dovecot from 1.1.x to 1.2, so that iRedAdmin-Pro can show real-time quota usage.
	** '''[This step is required for iRedMail-0.6.1 and earlier versions]''' [[iRedMail/FAQ/Upgrade.Dovecot.1.1.to.1.2 \|Upgrade Dovecot 1.1.x to 1.2.x]]		** '''[This step is required for iRedMail-0.6.1 and earlier versions]''' [[iRedMail/FAQ/Upgrade.Dovecot.1.1.to.1.2 \|Upgrade Dovecot 1.1.x to 1.2.x]]
	** [[iRedMail/FAQ/Store.Realtime.Quota.In.MySQL \|Store Real-time Quota in MySQL with Dovecot 1.2]]		** [[iRedMail/FAQ/Store.Realtime.Quota.In.MySQL \|Store Real-time Quota in MySQL with Dovecot 1.2]]

ZhangHuangbin: /* Update iRedMail */

ZhangHuangbin — Sun, 06 Mar 2011 10:27:52 GMT

Update iRedMail

← Older revision		Revision as of 10:27, 6 March 2011
Line 18:		Line 18:
	Addition update is required to use iRedAdmin-Pro-MySQL, please follow links to apply them.		Addition update is required to use iRedAdmin-Pro-MySQL, please follow links to apply them.

-	* Update MySQL database '''vmail'''. Required by iRedAdmin-Pro.	+	* '''[This step is required for iRedMail-0.6.1 and earlier versions]''' Update MySQL database '''vmail'''. Required by iRedAdmin-Pro.
	{{cmd\|<pre>		{{cmd\|<pre>
	$ mysql -u root -p		$ mysql -u root -p
Line 31:		Line 31:

	* Upgrade Dovecot from 1.1.x to 1.2, so that iRedAdmin-Pro can show real-time quota usage. If you don't need this feature, just skip it. No addition configure is required in iRedAdmin-Pro.		* Upgrade Dovecot from 1.1.x to 1.2, so that iRedAdmin-Pro can show real-time quota usage. If you don't need this feature, just skip it. No addition configure is required in iRedAdmin-Pro.
-	** [[iRedMail/FAQ/Upgrade.Dovecot.1.1.to.1.2 \|Upgrade Dovecot 1.1.x to 1.2.x]]	+	** '''[This step is required for iRedMail-0.6.1 and earlier versions]''' [[iRedMail/FAQ/Upgrade.Dovecot.1.1.to.1.2 \|Upgrade Dovecot 1.1.x to 1.2.x]]
	** [[iRedMail/FAQ/Store.Realtime.Quota.In.MySQL \|Store Real-time Quota in MySQL with Dovecot 1.2]]		** [[iRedMail/FAQ/Store.Realtime.Quota.In.MySQL \|Store Real-time Quota in MySQL with Dovecot 1.2]]

ZhangHuangbin: /* Update iRedMail */

ZhangHuangbin — Sun, 06 Mar 2011 10:26:13 GMT

Update iRedMail

← Older revision		Revision as of 10:26, 6 March 2011
Line 27:		Line 27:
	mysql> ALTER TABLE alias ADD COLUMN name VARCHAR(255) DEFAULT '' COLLATE utf8_general_ci;		mysql> ALTER TABLE alias ADD COLUMN name VARCHAR(255) DEFAULT '' COLLATE utf8_general_ci;
	mysql> ALTER TABLE domain ADD COLUMN defaultuseraliases TEXT NOT NULL DEFAULT '';		mysql> ALTER TABLE domain ADD COLUMN defaultuseraliases TEXT NOT NULL DEFAULT '';
		+	mysql> ALTER TABLE domain ADD COLUMN defaultpasswordscheme VARCHAR(10) NOT NULL DEFAULT '';
	</pre>}}		</pre>}}

Shake.chen: /* Configure iRedAdmin */

Shake.chen — Sun, 30 Jan 2011 05:21:19 GMT

Configure iRedAdmin

← Older revision		Revision as of 05:21, 30 January 2011
Line 118:		Line 118:
	{{cmd\|<pre>		{{cmd\|<pre>
	# cd /usr/local/www/iredadmin/		# cd /usr/local/www/iredadmin/
-	# cp settings.ini.sample settings.ini	+	# cp settings.ini.mysql.sample settings.ini
	# chown iredadmin:iredadmin settings.ini		# chown iredadmin:iredadmin settings.ini
	# chmod 0600 settings.ini		# chmod 0600 settings.ini

ZhangHuangbin: /* Summary */

ZhangHuangbin — Sat, 29 Jan 2011 17:24:36 GMT

Summary

← Older revision		Revision as of 17:24, 29 January 2011
Line 4:		Line 4:
	** '''iRedAdmin-Pro-LDAP''': works with OpenLDAP backend.		** '''iRedAdmin-Pro-LDAP''': works with OpenLDAP backend.
	** '''iRedAdmin-Pro-MySQL''': works with MySQL backend.		** '''iRedAdmin-Pro-MySQL''': works with MySQL backend.
		+	* [[Release.Notes/iRedAdmin-Pro/MySQL/1.0 \|Release Notes of iRedAdmin-Pro-MySQL-1.0]]

	= System requirements =		= System requirements =

ZhangHuangbin: /* System requirements */

ZhangHuangbin — Sat, 29 Jan 2011 05:41:25 GMT

System requirements

← Older revision		Revision as of 05:41, 29 January 2011
Line 1:		Line 1:
		+	= Summary =
		+	* This installation guide is used to install iRedAdmin-Pro-MySQL-1.0 on FreeBSD 7.x, 8.x.
		+	* iRedAdmin-Pro is official web-based admin panel for iRedMail. There're two editions:
		+	** '''iRedAdmin-Pro-LDAP''': works with OpenLDAP backend.
		+	** '''iRedAdmin-Pro-MySQL''': works with MySQL backend.
		+
	= System requirements =		= System requirements =
	* iRedMail-0.6.0 and newer versions. '''Note''': addition update is required. We will cover it below.		* iRedMail-0.6.0 and newer versions. '''Note''': addition update is required. We will cover it below.

ZhangHuangbin: /* Create necessary MySQL database and grant privileges */

ZhangHuangbin — Sat, 29 Jan 2011 05:33:09 GMT

Create necessary MySQL database and grant privileges

← Older revision		Revision as of 05:33, 29 January 2011
Line 91:		Line 91:

	= Create necessary MySQL database and grant privileges =		= Create necessary MySQL database and grant privileges =
		+	Create MySQL database: iredadmin. Used to store sessions, admin operation log, etc.
		+	{{cmd\|<pre>
		+	# mysql -uroot -p
		+	mysql> CREATE DATABASE iredadmin DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
		+	mysql> USE iredadmin;
		+	mysql> SOURCE /usr/local/www/iredadmin/docs/samples/iredadmin.sql;
		+	</pre>}}
		+
		+	* Grant privileges to iredadmin user and set password for it.
		+	** '''WARNING''': Here we use 'secret_passwd' as password of iredadmin user, please replace it with your own password.
		+	{{cmd\|<pre>
		+	# mysql -uroot -p
		+	mysql> GRANT SELECT,INSERT,UPDATE,DELETE ON iredadmin.* TO iredadmin@localhost IDENTIFIED BY 'secret_passwd';
		+	mysql> FLUSH PRIVILEGES;
		+	</pre>}}
		+
	= Configure iRedAdmin =		= Configure iRedAdmin =
	* Copy example config file, and make it not world-writeable.		* Copy example config file, and make it not world-writeable.

ZhangHuangbin: /* System requirements */

ZhangHuangbin — Sat, 29 Jan 2011 05:06:58 GMT

System requirements

← Older revision		Revision as of 05:06, 29 January 2011
Line 7:		Line 7:
	** '''Web.py''', 0.32+. A python-powered web framework.		** '''Web.py''', 0.32+. A python-powered web framework.
	*** '''MySQLdb'''. A thread-compatible interface to the popular MySQL database server that provides the Python database API.		*** '''MySQLdb'''. A thread-compatible interface to the popular MySQL database server that provides the Python database API.
		+
		+	= Update iRedMail =
		+	Addition update is required to use iRedAdmin-Pro-MySQL, please follow links to apply them.
		+
		+	* Update MySQL database '''vmail'''. Required by iRedAdmin-Pro.
		+	{{cmd\|<pre>
		+	$ mysql -u root -p
		+	mysql> USE vmail;
		+
		+	mysql> ALTER TABLE mailbox ADD COLUMN enablesmtpsecured TINYINT(1) NOT NULL DEFAULT '1';
		+	mysql> ALTER TABLE admin ADD COLUMN name VARCHAR(255) DEFAULT '' COLLATE utf8_general_ci;
		+	mysql> ALTER TABLE alias ADD COLUMN name VARCHAR(255) DEFAULT '' COLLATE utf8_general_ci;
		+	mysql> ALTER TABLE domain ADD COLUMN defaultuseraliases TEXT NOT NULL DEFAULT '';
		+	</pre>}}
		+
		+	* Upgrade Dovecot from 1.1.x to 1.2, so that iRedAdmin-Pro can show real-time quota usage. If you don't need this feature, just skip it. No addition configure is required in iRedAdmin-Pro.
		+	** [[iRedMail/FAQ/Upgrade.Dovecot.1.1.to.1.2 \|Upgrade Dovecot 1.1.x to 1.2.x]]
		+	** [[iRedMail/FAQ/Store.Realtime.Quota.In.MySQL \|Store Real-time Quota in MySQL with Dovecot 1.2]]
		+
		+	* If you want to quarnatine SPAM into MySQL, then manage (delete, release) them in iRedAdmin-Pro, below update is required.
		+	** [[iRedMail/FAQ/Quarantining.Messages \|Quarantining SPAM into MySQL with Amavisd]]

	= Add new system account: iredadmin =		= Add new system account: iredadmin =

ZhangHuangbin: /* Install necessary packages */

ZhangHuangbin — Sat, 29 Jan 2011 05:03:26 GMT

Install necessary packages

← Older revision		Revision as of 05:03, 29 January 2011
Line 20:		Line 20:
	{{cmd\|<pre>		{{cmd\|<pre>
	# bash		# bash
-	# for p in www/mod_wsgi www/webpy databases/py-dbutils devel/py-Jinja2 databases/py-MySQLdb net/py-netifaces; do cd /usr/ports/${i} && make install clean; done	+	# for p in www/mod_wsgi www/webpy databases/py-dbutils devel/py-Jinja2 databases/py-MySQLdb net/py-netifaces; do cd /usr/ports/${p} && make install clean; done
	</pre>}}		</pre>}}