Upgrade iRedMail from 1.1 to 1.2

Attention

Check out the lightweight on-premises email archiving software developed by iRedMail team: Spider Email Archiver.

Paid Remote Upgrade Support

We offer remote upgrade support if you don't want to get your hands dirty, check the details and contact us.

ChangeLog

General (All backends should apply these changes)

Update /etc/iredmail-release with new iRedMail version number

iRedMail stores the release version in /etc/iredmail-release after installation, it's recommended to update this file after you upgraded iRedMail, so that you can know which version of iRedMail you're running. For example:

1.2

Upgrade iRedAPD (Postfix policy server) to the latest stable release

Please follow below tutorial to upgrade iRedAPD to the latest stable release: Upgrade iRedAPD to the latest stable release

Upgrade Roundcube webmail to the latest stable release (1.4.3)

Roundcube 1.4

Since Roundcube 1.3, at least PHP 5.4 is required. If your server is running PHP 5.3 and cannot upgrade to 5.4, please upgrade Roundcube the latest 1.2 branch instead.

Upgrade netdata to the latest stable release (1.21.1)

If you have netdata installed, you can upgrade it by following this tutorial: Upgrade netdata.

Fixed: mail delivery abort if program 'altermime' is not available

The script mlmmj-amime-receive has a bug which may abort mail delivery if program altermime is not available on the system, this update fixes it.

Run commands below to update file /usr/bin/mlmmj-amime-receive (Linux) or /usr/local/bin/mlmmj-amime-receive (FreeBSD/OpenBSD):

On Linux:

cd /usr/bin/
wget -O mlmmj-amime-receive https://github.com/iredmail/iRedMail/raw/1.2/samples/mlmmj/mlmmj-amime-receive
chown mlmmj:mlmmj mlmmj-amime-receive
chmod 0550 mlmmj-amime-receive

On FreeBSD or OpenBSD:

cd /usr/local/bin/
wget -O mlmmj-amime-receive https://github.com/iredmail/iRedMail/raw/1.2/samples/mlmmj/mlmmj-amime-receive
chown mlmmj:mlmmj mlmmj-amime-receive
chmod 0550 mlmmj-amime-receive

For OpenLDAP backend

Improved last login track

Attention

User last login track is optional if you didn't implement it while upgrading iRedMail to 1.0. Here's the full tutorial to implement last login track: Track user last login time.

In iRedMail-1.0, Dovecot is configured to store the time of user last login via IMAP/POP3 in SQL database iredadmin, but it only tracks either POP3 or IMAP login. In iRedMail-1.2, it tracks both. Please follow steps below to implement this improvement.

    last_login_key = last-login/%s/%u/%d
map {
    pattern = shared/last-login/imap/$user/$domain
    table = last_login
    value_field = imap
    value_type = uint

    fields {
        username = $user
        domain = $domain
    }
}

map {
    pattern = shared/last-login/pop3/$user/$domain
    table = last_login
    value_field = pop3
    value_type = uint

    fields {
        username = $user
        domain = $domain
    }
}
wget -O /root/last_login.mysql https://github.com/iredmail/iRedMail/raw/1.2/update/1.2/last_login.mysql
mysql iredadmin < /root/last_login.mysql
rm -f /root/last_login.mysql

Fixed: can not store mail subject with emoji characters in amavisd database

In amavisd database, column msgs.subject is defined as VARCHAR(255), it doesn't support emoji characters. Please login to MySQL/MariaDB server as root user or amavisd user, then run SQL commands below to fix it:

USE amavisd;
ALTER TABLE msgs MODIFY COLUMN subject VARBINARY(255) NOT NULL DEFAULT '';

[OPTIONAL] Fail2ban: Store banned IP addresses in SQL database

If you're running iRedAdmin-Pro, it's very useful to store banned IP addresses in SQL database, then you can view and manage them with iRedAdmin-Pro directly.

For MySQL/MariaDB backends

Improved last login track

Attention

User last login track is optional if you didn't implement it while upgrading iRedMail to 1.0. Here's the full tutorial to implement last login track: Track user last login time.

In iRedMail-1.0, Dovecot is configured to store user last login time in SQL database iredadmin, but it only tracks either POP3 or IMAP login. In iRedMail-1.2, it tracks both. Please follow steps below to implement this improvement.

    last_login_key = last-login/%s/%u/%d
map {
    pattern = shared/last-login/imap/$user/$domain
    table = last_login
    value_field = imap
    value_type = uint

    fields {
        username = $user
        domain = $domain
    }
}

map {
    pattern = shared/last-login/pop3/$user/$domain
    table = last_login
    value_field = pop3
    value_type = uint

    fields {
        username = $user
        domain = $domain
    }
}
wget -O /root/last_login.mysql https://github.com/iredmail/iRedMail/raw/1.2/update/1.2/last_login.mysql
mysql vmail < /root/last_login.mysql
rm -f /root/last_login.mysql

Fixed: can not store mail subject with emoji characters in amavisd database

In amavisd database, column msgs.subject is defined as VARCHAR(255), it doesn't support emoji characters. Please login to MySQL/MariaDB server as root user or amavisd user, then run SQL commands below to fix it:

USE amavisd;
ALTER TABLE msgs MODIFY COLUMN subject VARBINARY(255) NOT NULL DEFAULT '';

[OPTIONAL] Fail2ban: Store banned IP addresses in SQL database

If you're running iRedAdmin-Pro, it's very useful to store banned IP addresses in SQL database, then you can view and manage them with iRedAdmin-Pro directly.

For PostgreSQL backend

[OPTIONAL] Fail2ban: Store banned IP addresses in SQL database

If you're running iRedAdmin-Pro, it's very useful to store banned IP addresses in SQL database, then you can view and manage them with iRedAdmin-Pro directly.