From iRedMail

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 from iRedAdmin open source edition to iRedAdmin-Pro

Summary

• This installation guide is used to install iRedAdmin-Pro-PGSQL on OpenBSD.
• 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.
  • 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 download page.

• Copy iRedAdmin to /var/www/, set correct file permissions, and create symbol link.

# 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

• Add apache configure file: /var/www/conf/modules/iredadmin.conf.

AddType text/html .py
AddHandler cgi-script .py

<Directory "/var/www/iredadmin">
    Options +ExecCGI
    Order allow,deny
    Allow from all
</Directory>

• Edit /var/www/conf/httpd.conf, make iredadmin accessable via HTTPS. Add below lines before </VirtualHost>:

WSGIScriptAlias /iredadmin /var/www/iredadmin/iredadmin.py
Alias /iredadmin/static /var/www/iredadmin/static

• Restart apache:

# /etc/rc.d/httpd restart

Create necessary PostgreSQL database and grant privileges

1. Create SQL database: iredadmin. Used to store sessions, admin operation logs, etc.
2. Create SQL user: iredadmin, with password 'plain_password' (without quotes).
3. Create required SQL tables and grant privileges.

# su - postgres
$ psql
sql> CREATE DATABASE iredadmin WITH TEMPLATE template0 ENCODING 'UTF8';
sql> CREATE ROLE iredadmin WITH LOGIN ENCRYPTED PASSWORD 'plain_password' NOSUPERUSER NOCREATEDB NOCREATEROLE;
sql> \c iredadmin;
sql> \i /var/www/iredadmin/docs/samples/iredadmin.pgsql;
sql> GRANT INSERT,UPDATE,DELETE,SELECT on sessions,log,updatelog to iredadmin;
sql> GRANT UPDATE,USAGE,SELECT ON log_id_seq TO 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.

# cd /var/www/iredadmin/
# cp settings.ini.pgsql.sample settings.ini
# chown www:iredadmin settings.ini
# chmod 0400 settings.ini

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.

[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.

• Restart apache web server.

# /etc/rc.d/httpd restart

• 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.

[general]
debug = True