1

Topic: Multiple: mysql max forwards avail for alias; mailman integration

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

1. This probably belongs in a mysql forum but how many forwards can a single alias hold in its database?

Since iredmail mysql doesn't come with mailing list support out of the gate we've started utilizing very large alias's. while this is a work around I know there has to be a limit to how many entries a single alias can hold.

2. Mailman integration for centos 6 does not seem to be cooperating.
Obviously the first link is the most pertinent, however I'm getting "transport unavailable" dispite following the tutorial for Integrating mailman with postfix and mysql.
howtoforge.com/installing-iredmail-and-mailman-on-debian-squeeze
howtoforge.com/perfect-server-centos-6.1-x86_64-with-apache2-ispconfig-3-p6
minhtech.com/featuredlinux/install-and-configure-mailman/

Is there any insite Into why the transport is unavailable warning is occurring despite following the instructions?

If not is there an alternative mailing list engine y'all would suggest?

----

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

2

Re: Multiple: mysql max forwards avail for alias; mailman integration

ad 1) as the list of aliases is put into comma separated text and stored in alias.goto, the limit seems to be the storage size of the database attribute.

3

Re: Multiple: mysql max forwards avail for alias; mailman integration

camel1cz wrote:

ad 1) as the list of aliases is put into comma separated text and stored in alias.goto, the limit seems to be the storage size of the database attribute.

Exactly.
Column "alias.goto" is defined to 'TEXT' type, so it's just limit of MySQL "TEXT" type:

CREATE TABLE IF NOT EXISTS alias (                                                 
    ...
    goto TEXT NOT NULL DEFAULT '',
    ...

According to documents[1], it can store 65,535 bytes, ~= 64KB.

- http://stackoverflow.com/questions/6766 … -type-text
- http://dev.mysql.com/doc/refman/5.0/en/ … ments.html

About question #2, please show us related log/error message, configurations you added/updated.

4

Re: Multiple: mysql max forwards avail for alias; mailman integration

LOG:
====
Jul  5 10:03:22 SWH-iRed-1 amavis[1853]: (01853-01) Passed CLEAN, <websupport@atlantic.net> -> <mailman-subscribe@lists.sensusplenoir.com>, Message-ID: <51d6e01b.TLq2r6xMGZdBrWGe%websupport@atlantic.net>, mail_id: ox3SqxCSbfs5, Hits: 0.011, size: 316845, queued_as: C974940D08, 30507 ms
Jul  5 10:03:23 SWH-iRed-1 postfix/smtp[2082]: 356C040CF8: to=<mailman-subscribe@lists.sensusplenoir.com>, relay=127.0.0.1[127.0.0.1]:10024, delay=31, delays=0.38/0.05/0.02/31, dsn=2.0.0, status=sent (250 2.0.0 from MTA([127.0.0.1]:10025): 250 2.0.0 Ok: queued as C974940D08)
Jul  5 10:03:23 SWH-iRed-1 postfix/qmgr[1689]: 356C040CF8: removed
Jul  5 10:03:23 SWH-iRed-1 postfix/error[2104]: C974940D08: to=<mailman-subscribe@lists.sensusplenoir.com>, relay=none, delay=0.47, delays=0.14/0.08/0/0.25, dsn=4.3.0, status=deferred (mail transport unavailable)
Jul  5 10:03:23 SWH-iRed-1 postfix/qmgr[1689]: C974940D08: from=<websupport@atlantic.net>, size=317397, nrcpt=1 (queue active)
Jul  5 10:03:23 SWH-iRed-1 postfix/error[2104]: C974940D08: to=<mailman-subscribe@lists.sensusplenoir.com>, relay=none, delay=0.59, delays=0.51/0/0/0.08, dsn=4.3.0, status=deferred (mail transport unavailable)

Additions to /etc/postfix/main.cf(test domain is sensusplenoir.com)
===========================================================
relay_domains = lists.sensusplenoir.com, $mydestination, proxy:mysql:/etc/postfix/mysql/relay_domains.cf
mailman_destination_recipient_limit = 1

And created the database entries as needed:

INSERT INTO `vmail`.`domain` (`domain`, `description`, `disclaimer`, `aliases`, `mailboxes`, `maxquota`, `quota`, `transport`, `backupmx`, `defaultuserquota`, `defaultuseraliases`, `defaultpasswordscheme`, `minpasswordlength`, `maxpasswordlength`, `created`, `modified`, `expired`, `active`) VALUES ('lists.sensusplenoir.com', '', '', '0', '0', '0', '0', 'mailman:', '0', '1024', '', '', '0', '0', NOW(), '0000-00-00 00:00:00', '9999-12-31 00:00:00', '1');
INSERT INTO `alias` (`address`, `goto`, `name`, `moderators`, `accesspolicy`, `domain`, `created`, `modified`, `expired`, `active`) VALUES
('listname@sensusplenoir.com', 'listname@lists.sensusplenoir.com', '', '', 'public', 'sensusplenoir.com', NOW(), NOW(), '9999-12-31 00:00:00', 1),
('listname-admin@sensusplenoir.com', 'listname-admin@lists.sensusplenoir.com', '', '', 'public', 'sensusplenoir.com', NOW(), NOW(), '9999-12-31 00:00:00', 1),
('listname-bounces@sensusplenoir.com', 'listname-bounces@lists.sensusplenoir.com', '', '', 'public', 'sensusplenoir.com', NOW(), NOW(), '9999-12-31 00:00:00', 1),
('listname-confirm@sensusplenoir.com', 'listname-confirm@lists.sensusplenoir.com', '', '', 'public', 'sensusplenoir.com', NOW(), NOW(), '9999-12-31 00:00:00', 1),
('listname-join@sensusplenoir.com', 'listname-join@lists.sensusplenoir.com', '', '', 'public', 'sensusplenoir.com', NOW(), NOW(), '9999-12-31 00:00:00', 1),
('listname-leave@sensusplenoir.com', 'listname-leave@lists.sensusplenoir.com', '', '', 'public', 'sensusplenoir.com', NOW(), NOW(), '9999-12-31 00:00:00', 1),
('listname-owner@sensusplenoir.com', 'listname-owner@lists.sensusplenoir.com', '', '', 'public', 'sensusplenoir.com', NOW(), NOW(), '9999-12-31 00:00:00', 1),
('listname-requests@sensusplenoir.com', 'listname-requests@lists.sensusplenoir.com', '', '', 'public', 'sensusplenoir.com', NOW(), NOW(), '9999-12-31 00:00:00', 1),
('listname-subscribe@sensusplenoir.com', 'listname-subscribe@lists.sensusplenoir.com', '', '', 'public', 'sensusplenoir.com', NOW(), NOW(), '9999-12-31 00:00:00', 1),
('listname-unsubscribe@sensusplenoir.com', 'listname-unsubscribe@lists.sensusplenoir.com', '', '', 'public', 'sensusplenoir.com', NOW(), NOW(), '9999-12-31 00:00:00', 1);
from socket import *
try:
    fqdn = getfqdn()
except:
    fqdn = 'mm_cfg_has_unknown_host_domains'

DEFAULT_URL_HOST   = fqdn
DEFAULT_EMAIL_HOST = fqdn

# Because we've overriden the virtual hosts above add_virtualhost
# MUST be called after they have been defined.

add_virtualhost(DEFAULT_URL_HOST, DEFAULT_EMAIL_HOST)


##############################################################
# Put YOUR site-specific configuration below, in mm_cfg.py . #

# See Defaults.py for explanations of the values.            #

# ksmemekddNote - if you're looking for something that is imported from mm_cfg, but you
# didn't find it above, it's probably in Defaults.py.
MTA = 'Postfix'

I'm a bit unsure of the mailmain config above, as we have several different domains that well be using these mailing lists so i left it at fqdn.

I skipped the html setup for now. I figure I'd leave that for  when I get the mailing lists up first.

The domain is a demo domain only for development only...just an fyi in case someone is wondering why i used a real domain.

5

Re: Multiple: mysql max forwards avail for alias; mailman integration

amora wrote:

Jul  5 10:03:23 SWH-iRed-1 postfix/error[2104]: C974940D08: to=<mailman-subscribe@lists.sensusplenoir.com>, relay=none, delay=0.59, delays=0.51/0/0/0.08, dsn=4.3.0, status=deferred (mail transport unavailable)

It says "relay=none", what's the transport/relay setting of "mailman-subscribe@lists.sensusplenoir.com"?

6

Re: Multiple: mysql max forwards avail for alias; mailman integration

ZhangHuangbin wrote:
amora wrote:

Jul  5 10:03:23 SWH-iRed-1 postfix/error[2104]: C974940D08: to=<mailman-subscribe@lists.sensusplenoir.com>, relay=none, delay=0.59, delays=0.51/0/0/0.08, dsn=4.3.0, status=deferred (mail transport unavailable)

It says "relay=none", what's the transport/relay setting of "mailman-subscribe@lists.sensusplenoir.com"?


I just checked and it looks like the below mysql snippet is what set it, the transport is set to "mailman:"

Relay without verifying local recipients is unchecked.



INSERT INTO `vmail`.`domain` (`domain`, `description`, `disclaimer`, `aliases`, `mailboxes`, `maxquota`, `quota`, `transport`, `backupmx`, `defaultuserquota`, `defaultuseraliases`, `defaultpasswordscheme`, `minpasswordlength`, `maxpasswordlength`, `created`, `modified`, `expired`, `active`) VALUES ('lists.sensusplenoir.com', '', '', '0', '0', '0', '0', 'mailman:', '0', '1024', '', '', '0', '0', NOW(), '0000-00-00 00:00:00', '9999-12-31 00:00:00', '1');

It

7

Re: Multiple: mysql max forwards avail for alias; mailman integration

Where do you define "mailman:" transport?

8

Re: Multiple: mysql max forwards avail for alias; mailman integration

Sorry for the delays, back to mailman:

I followed these instructions exactly as they are:
http://www.howtoforge.com/installing-ir … an-squeeze

At first I was getting a mail transport unavailable, I believe the reason for this is because within the master.cf file
I left this section commented out only to find out that if you yum install mailman the file "/usr/lib/mailman/bin/postfix-to-mailman.py" doesn't come with it, you have to rip if off the net here: https://www.gurulabs.com/downloads/post … man-2.1.py

Judging by an official mailman posting, this isn't directly supported and is more unique to Debian/ubuntu and not Centos:
http://wiki.list.org/pages/viewpage.act … d=15564817

However, for now It's the best i have to go off of.

#mailman   unix  -       n       n       -       -       pipe
#  flags=FR user=mailman argv=/usr/lib/mailman/bin/postfix-to-mailman.py
#  ${nexthop} ${user}

Below are the new warnings i get: fatal: get_service_attr: unknown username: list

specifically:

Jul 12 10:15:58 SWH-iRed-1 postfix/pickup[12593]: 1279F40CEA: uid=0 from=<test@sensusplenoir.com>
Jul 12 10:15:58 SWH-iRed-1 postfix/cleanup[12776]: 1279F40CEA: message-id=<51e01dad.7VGGI3hfdrQlryQw%test@sensusplenoir.com>
Jul 12 10:15:58 SWH-iRed-1 postfix/qmgr[12592]: 1279F40CEA: from=<test@sensusplenoir.com>, size=1620, nrcpt=1 (queue active)
Jul 12 10:15:58 SWH-iRed-1 postfix/error[12727]: 1279F40CEA: to=<mailman-subscribe@lists.sensusplenoir.com>, relay=none, delay=0.28, delays=0.21/0/0/0.07, dsn=4.3.0, status=deferred (unknown mail transport error)
Jul 12 10:16:21 SWH-iRed-1 postfix/pickup[12593]: 764A940CEB: uid=0 from=<test@sensusplenoir.com>
Jul 12 10:16:21 SWH-iRed-1 postfix/cleanup[12776]: 764A940CEB: message-id=<51e01dc5.5k8Gp4Xsqz7oURb0%test@sensusplenoir.com>
Jul 12 10:16:21 SWH-iRed-1 postfix/qmgr[12592]: 764A940CEB: from=<test@sensusplenoir.com>, size=1620, nrcpt=1 (queue active)
Jul 12 10:16:21 SWH-iRed-1 postfix/pipe[12796]: fatal: get_service_attr: unknown username: list
Jul 12 10:16:22 SWH-iRed-1 postfix/qmgr[12592]: warning: private/mailman socket: malformed response
Jul 12 10:16:22 SWH-iRed-1 postfix/qmgr[12592]: warning: transport mailman failure -- see a previous warning/fatal/panic logfile record for the problem description
Jul 12 10:16:22 SWH-iRed-1 postfix/master[56908]: warning: process /usr/libexec/postfix/pipe pid 12796 exit status 1
Jul 12 10:16:22 SWH-iRed-1 postfix/master[56908]: warning: /usr/libexec/postfix/pipe: bad command startup -- throttling
Jul 12 10:16:22 SWH-iRed-1 postfix/error[12734]: 764A940CEB: to=<mailman-subscribe@lists.sensusplenoir.com>, relay=none, delay=1.3, delays=0.16/1.1/0/0.07, dsn=4.3.0, status=deferred (unknown mail transport error)

Where do you define "mailman:" transport?

It's done from script but, to view it in iRedAdmin -> domains -> lists.sensusplenoir.com->relay

I'm probably going about this the wrong way trying to follow the debian version.

I believe mailman used to be integrated into iRedmail...is there an old howto(for Centos/postfix/mysql) I can follow to get this sorted?

9

Re: Multiple: mysql max forwards avail for alias; mailman integration

amora wrote:

It's done from script but, to view it in iRedAdmin -> domains -> lists.sensusplenoir.com->relay

The relay/transport set in iRedAdmin must exist in /etc/postfix/master.cf. Do you have it in master.cf?

10

Re: Multiple: mysql max forwards avail for alias; mailman integration

I should start from the beginning here is what I did to get to where I'm at right now
The info I followed for the above is here: http://www.djhsolutions.net/wiki/doku.p … figuration

# yum install -y mailman
# /etc/mailman/
# wget https://www.gurulabs.com/downloads/post … man-2.1.py
# mv postfix-to-mailman-2.1.py postfix-to-mailman.py
# chown root:mailman postfix-to-mailman.py
# chmod 750 postfix-to-mailman.py
# ln -s /etc/mailman/postfix-to-mailman.py /usr/lib/mailman/bin/postfix-to-mailman.py.
# nano /etc/mailman/postfix-to-mailman.py
--> MailmanHome = ”/var/lib/mailman”
--> MailmanOwner = “postmaster@domain.tld”
# cd /var/lib/mailman
# ln -s /usr/lib/mailman/mail
# /usr/lib/mailman/bin/check_perms -f

main.cf
---------
added:
-- > mailman_destination_recipient_limit = 1

master.cf
-----------

mailman   unix  -       n       n       -       -       pipe
  flags=FR user=list argv=/usr/lib/mailman/bin/postfix-to-mailman.py
  ${nexthop} ${user}

/etc/mailman/mm_cfg.py
--------------------------------

I'm confused at how to set up this file for virtual domains, but this is how it's setup now:

DEFAULT_URL_HOST = 'sensusplenoir.com'
DEFAULT_EMAIL_HOST = 'sensusplenoir.com'
add_virtualhost(DEFAULT_URL_HOST, DEFAULT_EMAIL_HOST)

MTA = 'Postfix' 

I had to combine the above with the following link to make an attempt at integrating it with mysql:
http://www.howtoforge.com/installing-ir … an-squeeze

Mainly the create of the virtual domain 'lists.sensusplenoir.com' with a transport setting of mailman:

and creating alias's under sensusplenoir.com so that anything arriving to:
mailman@sensusplenoir.com', goes to 'mailman@lists.sensusplenoir.com'
mailman-admin@sensusplenoir.com',goes to 'mailman-admin@lists.sensusplenoir.com
mailman-bounces@sensusplenoir.com',goes to 'mailman-bounces@lists.sensusplenoir.com
mailman-confirm@sensusplenoir.com',goes to 'mailman-confirm@lists.sensusplenoir.com
mailman-join@sensusplenoir.com',goes to 'mailman-join@lists.sensusplenoir.com
mailman-leave@sensusplenoir.com',goes to 'mailman-leave@lists.sensusplenoir.com
mailman-owner@sensusplenoir.com',goes to 'mailman-owner@lists.sensusplenoir.com
mailman-requests@sensusplenoir.com',goes to 'mailman-requests@lists.sensusplenoir.com
mailman-subscribe@sensusplenoir.com',goes to 'mailman-subscribe@lists.sensusplenoir.com
mailman-unsubscribe@sensusplenoir.com',goes to 'mailman-unsubscribe@lists.sensusplenoir.com

The error I'm getting when trying to subscribe the list is:

Jul 15 12:02:25 SWH-iRed-1 postfix/qmgr[3367]: EF61C40CD2: from=<test@sensusplenoir.com>, size=1617, nrcpt=1 (queue active)
Jul 15 12:02:25 SWH-iRed-1 amavis[1722]: (01722-06) Passed CLEAN, MYNETS/MYUSERS LOCAL [127.0.0.1] [127.0.0.1] <test@sensusplenoir.com> -> <mailman-join@lists.sensusplenoir.com>, Message-ID: <99bb86958925352d51247359b166d3b8@sensusplenoir.com>, mail_id: uwsi6esbsFww, Hits: -8.461, size: 592, queued_as: EF61C40CD2, 911 ms
Jul 15 12:02:25 SWH-iRed-1 postfix/pipe[4065]: fatal: get_service_attr: unknown username: list
Jul 15 12:02:25 SWH-iRed-1 postfix/smtp[4058]: 045B340CD1: to=<mailman-join@lists.sensusplenoir.com>, relay=127.0.0.1[127.0.0.1]:10024, delay=1.3, delays=0.23/0.03/0.01/1, dsn=2.0.0, status=sent (250 2.0.0 from MTA([127.0.0.1]:10025): 250 2.0.0 Ok: queued as EF61C40CD2)
Jul 15 12:02:25 SWH-iRed-1 postfix/qmgr[3367]: 045B340CD1: removed
Jul 15 12:02:26 SWH-iRed-1 postfix/qmgr[3367]: warning: private/mailman socket: malformed response
Jul 15 12:02:26 SWH-iRed-1 postfix/qmgr[3367]: warning: transport mailman failure -- see a previous warning/fatal/panic logfile record for the problem description
Jul 15 12:02:26 SWH-iRed-1 postfix/master[3263]: warning: process /usr/libexec/postfix/pipe pid 4065 exit status 1
Jul 15 12:02:26 SWH-iRed-1 postfix/master[3263]: warning: /usr/libexec/postfix/pipe: bad command startup -- throttling
Jul 15 12:02:26 SWH-iRed-1 postfix/error[4073]: EF61C40CD2: to=<mailman-join@lists.sensusplenoir.com>, relay=none, delay=1.3, delays=0.11/1.1/0/0.13, dsn=4.3.0, status=deferred (unknown mail transport error)

This is just trying to get mailman to work with mysql in the first place, this doesn't even take into account how this will work with the virtual domains yet.

Any in sight here would be appreciated.

11

Re: Multiple: mysql max forwards avail for alias; mailman integration

Ok I changed the user mailman in master.cf...

now i'm greeted with another error:


Jul 15 15:36:37 SWH-iRed-1 postfix/qmgr[10540]: 34DB340CCA: from=<test@sensusplenoir.com>, size=592, nrcpt=1 (queue active)
Jul 15 15:36:37 SWH-iRed-1 roundcube: User test@sensusplenoir.com [209.208.0.193]; Message for mailman-join@sensusplenoir.com; 250: 2.0.0 Ok: queued as 34DB340CCA
Jul 15 15:36:37 SWH-iRed-1 postfix/pipe[10650]: 34DB340CCA: to=<mailman-join@lists.sensusplenoir.com>, relay=mailman, delay=0.46, delays=0.29/0.01/0/0.16, dsn=5.3.0, status=bounced (Command died with status 1: "/usr/lib/mailman/bin/postfix-to-mailman.py". Command output: TO ACCESS THE MAILING LIST SYSTEM: Start your web browser on http://lists.sensusplenoir.com/ That web page will help you subscribe or unsubscribe, and will give you directions on how to post to each mailing list. )
Jul 15 15:36:37 SWH-iRed-1 postfix/cleanup[10643]: 9C44A40CD0: message-id=<20130715203637.9C44A40CD0@SWH-iRed-1.sensusplenoir.com>
Jul 15 15:36:37 SWH-iRed-1 postfix/bounce[10654]: 34DB340CCA: sender non-delivery notification: 9C44A40CD0
Jul 15 15:36:37 SWH-iRed-1 postfix/qmgr[10540]: 9C44A40CD0: from=<>, size=3045, nrcpt=1 (queue active)
Jul 15 15:36:37 SWH-iRed-1 postfix/qmgr[10540]: 34DB340CCA: removed
Jul 15 15:36:38 SWH-iRed-1 postfix/smtpd[10554]: disconnect from SWH-iRed-1.sensusplenoir.com[127.0.0.1]
Jul 15 15:36:38 SWH-iRed-1 postfix/pipe[10657]: 9C44A40CD0: to=<test@sensusplenoir.com>, relay=dovecot, delay=0.81, delays=0.18/0/0/0.63, dsn=2.0.0, status=sent (delivered via dovecot service)

12

Re: Multiple: mysql max forwards avail for alias; mailman integration

amora wrote:

Jul 15 15:36:37 SWH-iRed-1 postfix/pipe[10650]: 34DB340CCA: to=<mailman-join@lists.sensusplenoir.com>, relay=mailman, delay=0.46, delays=0.29/0.01/0/0.16, dsn=5.3.0, status=bounced (Command died with status 1: "/usr/lib/mailman/bin/postfix-to-mailman.py". Command output: TO ACCESS THE MAILING LIST SYSTEM: Start your web browser on http://lists.sensusplenoir.com/ That web page will help you subscribe or unsubscribe, and will give you directions on how to post to each mailing list. )

It shows correct relay info 'relay=mailman'. looks good.
Looks like you're not a member of this mailing list? so it prompt you to subscribe to it first.