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

ZhangHuangbin: /* Download iRedAdmin and configure Apache web server */

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

Download iRedAdmin and configure Apache web server

← Older revision		Revision as of 00:41, 6 May 2012
Line 39:		Line 39:

	* Add apache configure file: /etc/apache2/conf.d/iredadmin.conf.		* Add apache configure file: /etc/apache2/conf.d/iredadmin.conf.
-	{{cfg\|/etc/apache2//conf.d/iredadmin.conf\|<pre>	+	{{cfg\|/etc/apache2/conf.d/iredadmin.conf\|<pre>
	WSGISocketPrefix /var/run/wsgi		WSGISocketPrefix /var/run/wsgi
	WSGIDaemonProcess iredadmin user=iredadmin threads=15		WSGIDaemonProcess iredadmin user=iredadmin threads=15

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

ZhangHuangbin — Mon, 21 Nov 2011 22:33:27 GMT

Update iRedMail

← Older revision		Revision as of 22:33, 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 — Sun, 06 Mar 2011 10:29:35 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 — Sun, 06 Mar 2011 10:26:02 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 — Sun, 30 Jan 2011 05:19:03 GMT

Configure iRedAdmin

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

ZhangHuangbin — Sat, 29 Jan 2011 17:24:33 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 — Sat, 29 Jan 2011 05:41:46 GMT

Summary

← Older revision		Revision as of 05:41, 29 January 2011
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 OpenSuSE 11.3.
	* 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 two editions:
	** '''iRedAdmin-Pro-LDAP''': works with OpenLDAP backend.		** '''iRedAdmin-Pro-LDAP''': works with OpenLDAP backend.

ZhangHuangbin — Sat, 29 Jan 2011 05:41:00 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 on Red Hat Enterprise Linux 5.x or CentOS 5.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 — Sat, 29 Jan 2011 05:38:01 GMT

Create necessary MySQL database and grant privileges

← Older revision		Revision as of 05:38, 29 January 2011
Line 112:		Line 112:

	= Create necessary MySQL database and grant privileges =		= Create necessary MySQL database and grant privileges =
		+	* Create MySQL database: iredadmin. Used to store sessions, admin operation logs, etc.
		+	{{cmd\|<pre>
		+	# mysql -uroot -p
		+	mysql> CREATE DATABASE iredadmin DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
		+	mysql> USE iredadmin;
		+	mysql> SOURCE /srv/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.