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

ZhangHuangbin: /* System requirements */

ZhangHuangbin — Sun, 06 May 2012 03:43:13 GMT

System requirements

← Older revision		Revision as of 03:43, 6 May 2012
Line 19:		Line 19:
	*** '''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.
	** '''Python''' 2.4+, core programming language. Warning: Python 3.x is not supported yet.		** '''Python''' 2.4+, core programming language. Warning: Python 3.x is not supported yet.
-	** '''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.

ZhangHuangbin at 00:27, 6 May 2012

ZhangHuangbin — Sun, 06 May 2012 00:27:33 GMT

← Older revision		Revision as of 00:27, 6 May 2012
Line 12:		Line 12:

	= System requirements =		= System requirements =
-	* 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/RHEL \|this tutorial]] instead.	+	* 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/RHEL/OLD \|this tutorial]] instead.
	* iRedAdmin-Pro-MySQL-1.3.0 or later releases.		* iRedAdmin-Pro-MySQL-1.3.0 or later releases.

ZhangHuangbin at 00:24, 6 May 2012

ZhangHuangbin — Sun, 06 May 2012 00:24:35 GMT

← Older revision		Revision as of 00:24, 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:		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]]		* [[Migrate/iRedAdmin-Pro/OSE-Pro \|Migrate from iRedAdmin open source edition to iRedAdmin-Pro]]

ZhangHuangbin: /* Summary */

ZhangHuangbin — Sun, 06 May 2012 00:23:41 GMT

Summary

← Older revision		Revision as of 00:23, 6 May 2012
Line 1:		Line 1:
		+	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 on Red Hat Enterprise Linux, CentOS, Scientific Linux. Both 5.x and 6.x are supported.		* This installation guide is used to install iRedAdmin-Pro-MySQL on Red Hat Enterprise Linux, CentOS, Scientific Linux. Both 5.x and 6.x are supported.

ZhangHuangbin at 00:20, 6 May 2012

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

← Older revision		Revision as of 00:20, 6 May 2012
Line 1:		Line 1:
	= Summary =		= Summary =
-	* This installation guide is used to install iRedAdmin-Pro-MySQL on Red Hat Enterprise Linux 5.x ~~or CentOS 5~~.x.	+	* This installation guide is used to install iRedAdmin-Pro-MySQL on Red Hat Enterprise Linux, CentOS, Scientific Linux. Both 5.x and 6.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/RHEL \|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 17:
	*** '''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>~~	+
-	~~# useradd -s /sbin/nologin -m -d /home/iredadmin iredadmin~~	+
-	~~</pre>}}~~	+
-		+
-	~~= Install necessary packages =~~	+
-		+
-	* Make sure you have iRedMail ~~yum repository configured: /etc/yum.repos.d/iRedMail.repo.~~	+
-	~~{{cfg\|/etc/yum.repos.d/iRedMail.repo\|<pre>~~	+
-	~~[iRedMail]~~	+
-	~~name=iRedMail~~	+
-	~~baseurl=http://iredmail.org/yum/rpms/5/~~	+
-	~~enabled=1~~	+
-	~~gpgcheck=0~~	+
-	~~priority=1~~	+
-	~~</pre>}}~~	+
-		+
-	* Install necessary packages.	+
-	~~{{cmd\|<pre>~~	+
-	~~# ---- For i386 ----~~	+
-	~~# yum install python-webpy python-jinja2 MySQL-python mod_wsgi~~	+
-		+
-	~~# ---- For x86_64 ----~~	+
-	~~# yum install MySQL-python.x86_64 python-webpy.noarch python-jinja2.x86_64 mod_wsgi~~.~~x86_64~~	+
-	~~</pre>}}~~	+

	= Download iRedAdmin and configure Apache web server =		= Download iRedAdmin and configure Apache web server =
Line 81:		Line 35:
	* Add apache configure file: /etc/httpd/conf.d/iredadmin.conf.		* Add apache configure file: /etc/httpd/conf.d/iredadmin.conf.
	{{cfg\|/etc/httpd/conf.d/iredadmin.conf\|<pre>		{{cfg\|/etc/httpd/conf.d/iredadmin.conf\|<pre>
-	#
-	~~# Note: Uncomment below two lines if you want to make iRedAdmin accessable via HTTP.~~
-	#
-	~~#WSGIScriptAlias /iredadmin /var/www/iredadmin/iredadmin.py/~~
-	~~#Alias /iredadmin/static /var/www/iredadmin/static/~~
-
	WSGISocketPrefix /var/run/wsgi		WSGISocketPrefix /var/run/wsgi
	WSGIDaemonProcess iredadmin user=iredadmin threads=15		WSGIDaemonProcess iredadmin user=iredadmin threads=15
Line 122:		Line 70:
	* 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 =
		+
		+	The major config file of iRedAdmin is file '''/var/www/iredadmin/settings.ini'''.

	* Copy example config file, and set correct file permission.		* Copy example config file, and set correct file permission.
	{{cmd\|<pre>		{{cmd\|<pre>
	# cd /var/www/iredadmin/		# cd /var/www/iredadmin/
-	# cp settings.ini.~~dbmail_mysql~~.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 0400 settings.ini
	</pre>}}		</pre>}}

-	* Edit settings.ini ~~and~~ set ~~several variables~~.	+
-	** '''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]

ZhangHuangbin: /* Update iRedMail */

ZhangHuangbin — Mon, 21 Nov 2011 22:34:46 GMT

Update iRedMail

← Older revision		Revision as of 22:34, 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: /* Configure iRedAdmin */

ZhangHuangbin — Sun, 04 Sep 2011 14:00:59 GMT

Configure iRedAdmin

← Older revision		Revision as of 14:00, 4 September 2011
Line 134:		Line 134:
	{{cmd\|<pre>		{{cmd\|<pre>
	# cd /var/www/iredadmin/		# cd /var/www/iredadmin/
-	# cp settings.ini.~~mysql~~.sample settings.ini	+	# cp settings.ini.dbmail_mysql.sample settings.ini
	# chown iredadmin:iredadmin settings.ini		# chown iredadmin:iredadmin settings.ini
	# chmod 0600 settings.ini		# chmod 0600 settings.ini

ZhangHuangbin: /* Update iRedMail */

ZhangHuangbin — Sun, 06 Mar 2011 10:29:15 GMT

Update iRedMail

← Older revision		Revision as of 10:29, 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:25:18 GMT

Update iRedMail

← Older revision		Revision as of 10:25, 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 04:59:41 GMT

Configure iRedAdmin

← Older revision		Revision as of 04:59, 30 January 2011
Line 133:		Line 133:
	{{cmd\|<pre>		{{cmd\|<pre>
	# cd /var/www/iredadmin/		# cd /var/www/iredadmin/
-	# cp settings.ini.~~ldap~~.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