1

Topic: Suggestion for Newsletter

==== Required information ====
- iRedMail version: 0.8.6
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Linux/BSD distribution name and version: Debian Wheezy
- Related log if you're reporting an issue:
====

I need a suggest for enhance the newsletter.
Actually I use Alias as a fake newsletter.
I want a newsletter more professional connected to IRedMAil, manageable via WebPage.

Thank you

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2

Re: Suggestion for Newsletter

You can try either Mailman or mlmmj. Personally, i suggest mlmmj.
http://mlmmj.org

3

Re: Suggestion for Newsletter

Do you have some Wiki or can you guide me to integrate MLMMJ in IredMail installation?

Thank you

4

Re: Suggestion for Newsletter

You can try mlmmj official document.
I have a doc for a almost working iRedMail + mlmmj setup, but need some more tests, not yet ready for production use.

5

Re: Suggestion for Newsletter

ZhangHuangbin wrote:

You can try mlmmj official document.
I have a doc for a almost working iRedMail + mlmmj setup, but need some more tests, not yet ready for production use.

Is there a status update for this project?

6

Re: Suggestion for Newsletter

A short tutorial:

## Setup

/etc/postfix/master.cf:

```
# ${nexthop} is '%d/%u' in transport ('mlmmj:%d/%u')
mlmmj   unix  -       n       n       -       -       pipe
  flags=ORhu user=mlmmj argv=/usr/bin/mlmmj-receive -F -L /var/spool/mlmmj/${nexthop}
#  flags=ORhu user=mlmmj argv=/usr/bin/mlmmj-receive -F -L /var/spool/mlmmj/${domain}/${user}
```

/etc/postfix/main.cf:

```
mlmmj_destination_recipient_limit = 1

virtual_alias_maps = proxy:mysql:/etc/postfix/mysql/mlmmj.cf, ...
transport_maps =
    proxy:mysql:/etc/postfix/mysql/transport_maps_user.cf,
    proxy:mysql:/etc/postfix/mysql/transport_maps_mlmmj.cf,
    proxy:mysql:/etc/postfix/mysql/transport_maps_domain.cf
```

/etc/postfix/mysql/mlmmj.cf:

```
user        = vmail
password    = qsescZvV03f6YUtTMN2bQTejmjatzz
hosts       = 127.0.0.1
port        = 3306
dbname      = vmail
query       = SELECT '%s' FROM alias WHERE address='%s' AND islist=1 AND active=1
```

/etc/postfix/mysql/transport_maps_mlmmj.cf:

```
user        = vmail
password    = qsescZvV03f6YUtTMN2bQTejmjatzz
hosts       = 127.0.0.1
port        = 3306
dbname      = vmail
query       = SELECT 'mlmmj:%d/%u' FROM alias WHERE address='%s' AND islist=1 AND active=1
```

## create new mailing list with mlmmj-agent program

Create a new mailing list with domain.com/listname style:

```
mlmmj-make-ml -L 'alist' -s /var/spool/mlmmj/a.cn -c mlmmj
```

In /var/spool/mlmmj/b.cn/alist/control/customheaders:

```
X-Mailinglist: alist@b.cn
Reply-To: alist@b.cn
```

## References

* http://mlmmj.org/docs/readme-postfix/

7

Re: Suggestion for Newsletter

Thank you. :-)

8

Re: Suggestion for Newsletter

Needless to say, you should try it with testing machine first.