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

ZhangHuangbin: /* System requirements */

ZhangHuangbin — Sun, 06 May 2012 05:31:33 GMT

System requirements

← Older revision		Revision as of 05:31, 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.
	*** '''psycopg2'''. A interface to the popular PostgreSQL database server that provides the Python database API.		*** '''psycopg2'''. A interface to the popular PostgreSQL database server that provides the Python database API.

ZhangHuangbin: /* Configure iRedAdmin */

ZhangHuangbin — Sun, 06 May 2012 03:49:46 GMT

Configure iRedAdmin

← Older revision		Revision as of 03:49, 6 May 2012
Line 86:		Line 86:
	{{cmd\|<pre>		{{cmd\|<pre>
	# cd /var/www/iredadmin/		# cd /var/www/iredadmin/
-	# cp settings.ini.~~mysql~~.sample settings.ini	+	# cp settings.ini.pgsql.sample settings.ini
	# chown iredadmin:iredadmin settings.ini		# chown iredadmin:iredadmin settings.ini
	# chmod 0400 settings.ini		# chmod 0400 settings.ini

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

ZhangHuangbin — Sun, 06 May 2012 03:49:20 GMT

Create necessary PostgreSQL database and grant privileges

← Older revision		Revision as of 03:49, 6 May 2012
Line 65:		Line 65:
	= Create necessary PostgreSQL database and grant privileges =		= Create necessary PostgreSQL database and grant privileges =

-	* Create ~~MySQL~~ database: iredadmin. Used to store sessions, admin operation logs, etc.	+	# Create SQL database: iredadmin. Used to store sessions, admin operation logs, etc.
		+	# Create SQL user: iredadmin, with password 'plain_password' (without quotes).
		+	# Create required SQL tables and grant privileges.
	{{cmd\|<pre>		{{cmd\|<pre>
-	# ~~mysql~~ -~~uroot -p~~	+	# su - postgres
-	~~mysql~~> CREATE DATABASE iredadmin ~~DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci~~;	+	$ psql
-	~~mysql~~> ~~USE~~ iredadmin;	+	sql> CREATE DATABASE iredadmin WITH TEMPLATE template0 ENCODING 'UTF8';
-	~~mysql~~> ~~SOURCE~~ /var/www/iredadmin/docs/samples/iredadmin.pgsql;	+	sql> CREATE ROLE iredadmin WITH LOGIN ENCRYPTED PASSWORD 'plain_password' NOSUPERUSER NOCREATEDB NOCREATEROLE;
-	~~</pre~~>}}	+	sql> \c iredadmin;
-		+	sql> \i /var/www/iredadmin/docs/samples/iredadmin.pgsql;
-	* Grant privileges to iredadmin ~~user and set password for it.~~	+	sql> GRANT INSERT,UPDATE,DELETE,SELECT on sessions,log,updatelog to iredadmin;
-		+	sql> GRANT UPDATE,USAGE,SELECT ON log_id_seq TO iredadmin;
-	~~'''WARNING''': Here we use 'plain_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 'plain_passwd';~~	+
-	~~mysql> FLUSH PRIVILEGES~~;	+
	</pre>}}		</pre>}}

ZhangHuangbin: Created page with '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/iRedAdm…'

ZhangHuangbin — Sun, 06 May 2012 03:44:33 GMT

Created page with '__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/iRedAdm…'

New page

__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 =
* This installation guide is used to install iRedAdmin-Pro-PGSQL 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 three editions available:
** '''iRedAdmin-Pro-LDAP''': works with OpenLDAP backend.
** '''iRedAdmin-Pro-MySQL''': works with MySQL backend.
** '''iRedAdmin-Pro-PGSQL''': works with PostgreSQL backend.

= System requirements =
* iRedMail-0.8.0 or later releases.
* iRedAdmin-Pro-PGSQL-1.0 or later releases.

* Required Packages. They all are installed automatically during iRedMail installation.
** '''Apache''', 2.2+. Web server.
*** '''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.
** '''Web.py''', 0.32+. A python-powered web framework.
*** '''psycopg2'''. A interface to the popular PostgreSQL database server that provides the Python database API.

iRedAdmin will run with a low-privileged system user: iredadmin, which is created automatically during iRedMail installation, too.

= Download iRedAdmin and configure Apache web server =
* Get iRedAdmin:
** If you purchased iRedAdmin-Pro-PGSQL, 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-PGSQL, download iRedAdmin open source edition from [http://www.iredmail.org/download.html#iredadmin download page].

* Copy iRedAdmin to /var/www/, set correct file permissions, and create symbol link.
{{cmd|<pre>
# tar xjf iRedAdmin-x.y.z.tar.bz2 -C /var/www/
# cd /var/www/
# chown -R iredadmin:iredadmin iRedAdmin-x.y.z
# chmod -R 0755 iRedAdmin-x.y.z
# ln -s iRedAdmin-x.y.z iredadmin
</pre>}}

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

AddType text/html .py

<Directory /var/www/iredadmin/>
Order deny,allow
Allow from all
</Directory>
</pre>}}

* Edit /etc/httpd/conf.d/ssl.conf, make iredadmin accessable via HTTPS. Add below lines before </VirtualHost>:
{{cfg|/etc/httpd/conf.d/ssl.conf|<pre>
WSGIScriptAlias /iredadmin /var/www/iredadmin/iredadmin.py/
Alias /iredadmin/static /var/www/iredadmin/static/
</pre>}}

* Restart apache to enable mod_wsgi:
{{cmd|<pre>
# /etc/init.d/httpd restart
</pre>}}

= Create necessary PostgreSQL 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 /var/www/iredadmin/docs/samples/iredadmin.pgsql;
</pre>}}

* Grant privileges to iredadmin user and set password for it.

'''WARNING''': Here we use 'plain_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 'plain_passwd';
mysql> FLUSH PRIVILEGES;
</pre>}}

= Configure iRedAdmin =

The major config file of iRedAdmin is file '''/var/www/iredadmin/settings.ini'''.

* Copy example config file, and set correct file permission.
{{cmd|<pre>
# cd /var/www/iredadmin/
# cp settings.ini.mysql.sample settings.ini
# chown iredadmin:iredadmin settings.ini
# chmod 0400 settings.ini
</pre>}}

'''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>
[general]
# General settings ...

[iredadmin]
# Database "iredadmin". required by iRedAdmin.

[vmaildb]
# Database "vmail", stored all mail accounts.

[policyd]
# Database "policyd". Required for policyd integration.

[amavisd]
# Database "amavisd". Required for Amavisd-New integration. includes spam quarantining/releasing.
</pre>}}

* Restart apache web server.
{{cmd|<pre>
# /etc/init.d/httpd restart
</pre>}}

* Open your web browser to access iRedAdmin: https://your_server_ip_address/iredadmin/
** '''NOTE''': Make sure you use HTTPS:// instead of HTTP://.

= Troubleshooting =
If iRedAdmin doesn't work as expected, you can set '''debug = True''' in settings.ini to turn on debug mode, restart apache web server, use your favourite web browser to access it again, create a new forum topic and paste error message in forum topic.
{{cfg|settings.ini|<pre>
[general]
debug = True
</pre>}}

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

ZhangHuangbin: /* System requirements */

ZhangHuangbin: /* Configure iRedAdmin */

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

ZhangHuangbin: Created page with '__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/iRedAdm…'

ZhangHuangbin: Created page with '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/iRedAdm…'