Loading ...
Sorry, an error occurred while loading the content.

postfix+mailman - User unknown in virtual mailbox table

Expand Messages
  • J. Bakshi
    Dear list, This is an operational mail server supporting multidomain and based on postfix+dovecot+mysql. The virtual domain related config at main.cf is as
    Message 1 of 12 , Sep 2, 2011
    • 0 Attachment
      Dear list,

      This is an operational mail server supporting multidomain and based
      on postfix+dovecot+mysql. The virtual domain related config at main.cf
      is as below

      [....]
      alias_maps = hash:/etc/aliases, hash:/var/lib/mailman/data/aliases

      #########################################
      ## virtual domain setting
      #########################################
      virtual_alias_domains = hash:/etc/postfix/virtual
      virtual_alias_maps = mysql:/etc/postfix/mysql-virtual-alias-maps.cf,mysql:/etc/postfix/mysql-email2email.cf
      virtual_gid_maps = static:5000
      virtual_mailbox_domains = mysql:/etc/postfix/mysql-virtual-mailbox-domains.cf
      virtual_mailbox_maps = mysql:/etc/postfix/mysql-virtual-mailbox-maps.cf
      virtual_transport = dovecot
      dovecot_destination_recipient_limit = 1
      virtual_uid_maps = static:5000
      [....]
      ``````````````

      I have installed mailman here and to support virtual domain also have
      the following at /usr/lib/mailman/Mailman/mm_cfg.py


      [....]
      DEFAULT_URL_PATTERN = 'http://%s/mailman/'

      DEFAULT_EMAIL_HOST = 'list.mydomain.com'
      DEFAULT_URL_HOST = 'list.mydomain.com'
      MTA = 'Postfix'
      POSTFIX_ALIAS_CMD = '/usr/sbin/postalias'
      POSTFIX_MAP_CMD = '/usr/sbin/postmap'
      DELIVERY_MODULE = 'SMTPDirect'
      SMTPPORT = '25'
      add_virtualhost(DEFAULT_URL_HOST, DEFAULT_EMAIL_HOST)
      POSTFIX_STYLE_VIRTUAL_DOMAINS = ['list.infoservices.in']
      IMAGE_LOGOS = '/mailmanicons/'
      [....]

      and the master.cf has following

      [....]
      mailman unix - n n - - pipe
      flags=FR user=list argv=/etc/mailman/postfix-to-mailman.py
      ${nexthop} ${user}
      [....]

      after reloading postfix and mailman I have created a list and also
      copy paste the suggested aliases at /etc/aliases and executed "newalias"
      command.

      If I send a request to listname-request@... I get an error from
      postfix as

      ` ` ` `
      Recipient address rejected: User unknown in virtual mailbox table
      ` ` ` `

      Do I need to create all such an account required by mailman?

      I am confused...... any clue is very much welcome.
      TIA
    • Wietse Venema
      ... You have the domain name in virtual_mailbox_domains. Postfix expects that you have the recipients in virtual_mailbox_maps. ... You have the addresses the
      Message 2 of 12 , Sep 2, 2011
      • 0 Attachment
        J. Bakshi:
        > Recipient address rejected: User unknown in virtual mailbox table

        You have the domain name in virtual_mailbox_domains. Postfix expects
        that you have the recipients in virtual_mailbox_maps.

        > [....]
        > alias_maps = hash:/etc/aliases, hash:/var/lib/mailman/data/aliases

        You have the addresses the local(8) aliases. Postfix uses those
        only for domains listed in mydestination.

        This is documented in http://www.postfix.org/ADDRESS_CLASS_README.html
        and http://www.postfix.org/VIRTUAL_README.html

        I suggest that you take someone's mailman instructions and follow
        those exactly, instead of trying to make up your own recipe.

        Wietse
      • J. Bakshi
        On Fri, 2 Sep 2011 07:58:52 -0400 (EDT) ... ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ You have given me a clue here !!! I have added the
        Message 3 of 12 , Sep 2, 2011
        • 0 Attachment
          On Fri, 2 Sep 2011 07:58:52 -0400 (EDT)
          Wietse Venema <wietse@...> wrote:

          > J. Bakshi:
          > > Recipient address rejected: User unknown in virtual mailbox table
          >
          > You have the domain name in virtual_mailbox_domains. Postfix expects
          > that you have the recipients in virtual_mailbox_maps.
          >
          > > [....]
          > > alias_maps = hash:/etc/aliases, hash:/var/lib/mailman/data/aliases
          >
          > You have the addresses the local(8) aliases. Postfix uses those
          > only for domains listed in mydestination.
          ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

          You have given me a clue here !!! I have added the list domain at
          mydestination and now no problem to send the mail. Though a new error
          now

          ```````````
          Command died with status 2:
          "/usr/lib/mailman/mail/mailman request typo3". Command output: Failure to
          exec script. WANTED gid 67, GOT gid 65533.
          ```````````

          gid 67 is mailman group where 65533 is nobody. Don't know why it is
          getting nobody...
        • Wietse Venema
          ... You failed to set the ownership of /var/lib/mailman/data/aliases and /var/lib/mailman/data/aliases.db. I suppose this would be mentioned in the mailman
          Message 4 of 12 , Sep 2, 2011
          • 0 Attachment
            J. Bakshi:
            > On Fri, 2 Sep 2011 07:58:52 -0400 (EDT)
            > Wietse Venema <wietse@...> wrote:
            >
            > > J. Bakshi:
            > > > Recipient address rejected: User unknown in virtual mailbox table
            > >
            > > You have the domain name in virtual_mailbox_domains. Postfix expects
            > > that you have the recipients in virtual_mailbox_maps.
            > >
            > > > [....]
            > > > alias_maps = hash:/etc/aliases, hash:/var/lib/mailman/data/aliases
            > >
            > > You have the addresses the local(8) aliases. Postfix uses those
            > > only for domains listed in mydestination.
            > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
            >
            > You have given me a clue here !!! I have added the list domain at
            > mydestination and now no problem to send the mail. Though a new error
            > now
            >
            > ```````````
            > Command died with status 2:
            > "/usr/lib/mailman/mail/mailman request typo3". Command output: Failure to
            > exec script. WANTED gid 67, GOT gid 65533.
            > ```````````
            >
            > gid 67 is mailman group where 65533 is nobody. Don't know why it is
            > getting nobody...

            You failed to set the ownership of /var/lib/mailman/data/aliases
            and /var/lib/mailman/data/aliases.db.

            I suppose this would be mentioned in the mailman instructions.

            Wietse
          • J. Bakshi
            On Fri, 2 Sep 2011 08:47:25 -0400 (EDT) ... I have not found any such instruction in suse mailman manual. Checked the ownership and found they are set to
            Message 5 of 12 , Sep 2, 2011
            • 0 Attachment
              On Fri, 2 Sep 2011 08:47:25 -0400 (EDT)
              Wietse Venema <wietse@...> wrote:

              > J. Bakshi:
              > > On Fri, 2 Sep 2011 07:58:52 -0400 (EDT)
              > > Wietse Venema <wietse@...> wrote:
              > >
              > > > J. Bakshi:
              > > > > Recipient address rejected: User unknown in virtual mailbox table
              > > >
              > > > You have the domain name in virtual_mailbox_domains. Postfix expects
              > > > that you have the recipients in virtual_mailbox_maps.
              > > >
              > > > > [....]
              > > > > alias_maps = hash:/etc/aliases, hash:/var/lib/mailman/data/aliases
              > > >
              > > > You have the addresses the local(8) aliases. Postfix uses those
              > > > only for domains listed in mydestination.
              > > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
              > >
              > > You have given me a clue here !!! I have added the list domain at
              > > mydestination and now no problem to send the mail. Though a new error
              > > now
              > >
              > > ```````````
              > > Command died with status 2:
              > > "/usr/lib/mailman/mail/mailman request typo3". Command output: Failure to
              > > exec script. WANTED gid 67, GOT gid 65533.
              > > ```````````
              > >
              > > gid 67 is mailman group where 65533 is nobody. Don't know why it is
              > > getting nobody...
              >
              > You failed to set the ownership of /var/lib/mailman/data/aliases
              > and /var/lib/mailman/data/aliases.db.
              >
              > I suppose this would be mentioned in the mailman instructions.
              >
              > Wietse

              I have not found any such instruction in suse mailman manual.
              Checked the ownership and found they are set to mailman group
              already

              -rw-rw-r-- 1 mailman mailman 12288 Sep 2 11:07 /var/lib/mailman/data/aliases.db

              -rw-rw---- 1 root mailman 1865 Sep 2 11:07 /var/lib/mailman/data/aliases
            • Wietse Venema
              ... You must set the OWNER to mailman, not the GROUP. Then, Postfix will is use the mailman group ID in the PASSWORD file. Postfix will not use the mailman
              Message 6 of 12 , Sep 2, 2011
              • 0 Attachment
                J. Bakshi:
                > > > Command died with status 2:
                > > > "/usr/lib/mailman/mail/mailman request typo3". Command output: Failure to
                > > > exec script. WANTED gid 67, GOT gid 65533.
                > > > ```````````
                > > >
                > > > gid 67 is mailman group where 65533 is nobody. Don't know why it is
                > > > getting nobody...
                > >
                > > You failed to set the ownership of /var/lib/mailman/data/aliases
                > > and /var/lib/mailman/data/aliases.db.
                > >
                > > I suppose this would be mentioned in the mailman instructions.
                > >
                > > Wietse
                >
                > I have not found any such instruction in suse mailman manual.
                > Checked the ownership and found they are set to mailman group
                > already
                >
                > -rw-rw-r-- 1 mailman mailman 12288 Sep 2 11:07 /var/lib/mailman/data/aliases.db
                >
                > -rw-rw---- 1 root mailman 1865 Sep 2 11:07 /var/lib/mailman/data/aliases

                You must set the OWNER to mailman, not the GROUP.

                Then, Postfix will is use the mailman group ID in the PASSWORD file.
                Postfix will not use the mailman group ID in the GROUP file.

                Wietse
              • J. Bakshi
                On Fri, 2 Sep 2011 09:22:44 -0400 (EDT) ... OK, now I have the following -rw-rw---- 1 mailman root 1865 Sep 2 11:07 /var/lib/mailman/data/aliases but still
                Message 7 of 12 , Sep 2, 2011
                • 0 Attachment
                  On Fri, 2 Sep 2011 09:22:44 -0400 (EDT)
                  Wietse Venema <wietse@...> wrote:

                  > J. Bakshi:
                  > > > > Command died with status 2:
                  > > > > "/usr/lib/mailman/mail/mailman request typo3". Command output: Failure to
                  > > > > exec script. WANTED gid 67, GOT gid 65533.
                  > > > > ```````````
                  > > > >
                  > > > > gid 67 is mailman group where 65533 is nobody. Don't know why it is
                  > > > > getting nobody...
                  > > >
                  > > > You failed to set the ownership of /var/lib/mailman/data/aliases
                  > > > and /var/lib/mailman/data/aliases.db.
                  > > >
                  > > > I suppose this would be mentioned in the mailman instructions.
                  > > >
                  > > > Wietse
                  > >
                  > > I have not found any such instruction in suse mailman manual.
                  > > Checked the ownership and found they are set to mailman group
                  > > already
                  > >
                  > > -rw-rw-r-- 1 mailman mailman 12288 Sep 2 11:07 /var/lib/mailman/data/aliases.db
                  > >
                  > > -rw-rw---- 1 root mailman 1865 Sep 2 11:07 /var/lib/mailman/data/aliases
                  >
                  > You must set the OWNER to mailman, not the GROUP.
                  >
                  > Then, Postfix will is use the mailman group ID in the PASSWORD file.
                  > Postfix will not use the mailman group ID in the GROUP file.
                  >
                  > Wietse

                  OK, now I have the following

                  -rw-rw---- 1 mailman root 1865 Sep 2 11:07 /var/lib/mailman/data/aliases

                  but still the same error :-( Also tried with mailman:mailman but no luck..

                  Restarted both postfix and mailman, obviously..
                • Wietse Venema
                  ... I told you to set the ownership of TWO FILES. Since you are following SUSE instructions, I suggest that you ask them for help instead. Wietse
                  Message 8 of 12 , Sep 2, 2011
                  • 0 Attachment
                    J. Bakshi:
                    > On Fri, 2 Sep 2011 09:22:44 -0400 (EDT)
                    > Wietse Venema <wietse@...> wrote:
                    >
                    > > J. Bakshi:
                    > > > > > Command died with status 2:
                    > > > > > "/usr/lib/mailman/mail/mailman request typo3". Command output: Failure to
                    > > > > > exec script. WANTED gid 67, GOT gid 65533.
                    > > > > > ```````````
                    > > > > >
                    > > > > > gid 67 is mailman group where 65533 is nobody. Don't know why it is
                    > > > > > getting nobody...
                    > > > >
                    > > > > You failed to set the ownership of /var/lib/mailman/data/aliases
                    > > > > and /var/lib/mailman/data/aliases.db.
                    > > > >
                    > > > > I suppose this would be mentioned in the mailman instructions.
                    > > > >
                    > > > > Wietse
                    > > >
                    > > > I have not found any such instruction in suse mailman manual.
                    > > > Checked the ownership and found they are set to mailman group
                    > > > already
                    > > >
                    > > > -rw-rw-r-- 1 mailman mailman 12288 Sep 2 11:07 /var/lib/mailman/data/aliases.db
                    > > >
                    > > > -rw-rw---- 1 root mailman 1865 Sep 2 11:07 /var/lib/mailman/data/aliases
                    > >
                    > > You must set the OWNER to mailman, not the GROUP.
                    > >
                    > > Then, Postfix will is use the mailman group ID in the PASSWORD file.
                    > > Postfix will not use the mailman group ID in the GROUP file.
                    > >
                    > > Wietse
                    >
                    > OK, now I have the following
                    >
                    > -rw-rw---- 1 mailman root 1865 Sep 2 11:07 /var/lib/mailman/data/aliases
                    >
                    > but still the same error :-( Also tried with mailman:mailman but no luck..

                    I told you to set the ownership of TWO FILES.

                    Since you are following SUSE instructions, I suggest that you ask
                    them for help instead.

                    Wietse
                  • Reindl Harald
                    ... you did not notice that /var/lib/mailman/data/aliases.db is the relevant file and has the owner mailman , /var/lib/mailman/data/aliases is the
                    Message 9 of 12 , Sep 2, 2011
                    • 0 Attachment
                      Am 02.09.2011 15:22, schrieb Wietse Venema:
                      >> I have not found any such instruction in suse mailman manual.
                      >> Checked the ownership and found they are set to mailman group
                      >> already
                      >>
                      >> -rw-rw-r-- 1 mailman mailman 12288 Sep 2 11:07 /var/lib/mailman/data/aliases.db
                      >>
                      >> -rw-rw---- 1 root mailman 1865 Sep 2 11:07 /var/lib/mailman/data/aliases
                      >
                      > You must set the OWNER to mailman, not the GROUP.
                      >
                      > Then, Postfix will is use the mailman group ID in the PASSWORD file.
                      > Postfix will not use the mailman group ID in the GROUP file

                      you did not notice that "/var/lib/mailman/data/aliases.db" is the relevant file
                      and has the owner "mailman", "/var/lib/mailman/data/aliases" is the unhashed
                    • J. Bakshi
                      On Fri, 2 Sep 2011 09:45:53 -0400 (EDT) ... The other one i.e. /var/lib/mailman/data/aliases.db already have mailman as owner...
                      Message 10 of 12 , Sep 2, 2011
                      • 0 Attachment
                        On Fri, 2 Sep 2011 09:45:53 -0400 (EDT)
                        Wietse Venema <wietse@...> wrote:

                        > J. Bakshi:
                        > > On Fri, 2 Sep 2011 09:22:44 -0400 (EDT)
                        > > Wietse Venema <wietse@...> wrote:
                        > >
                        > > > J. Bakshi:
                        > > > > > > Command died with status 2:
                        > > > > > > "/usr/lib/mailman/mail/mailman request typo3". Command output: Failure to
                        > > > > > > exec script. WANTED gid 67, GOT gid 65533.
                        > > > > > > ```````````
                        > > > > > >
                        > > > > > > gid 67 is mailman group where 65533 is nobody. Don't know why it is
                        > > > > > > getting nobody...
                        > > > > >
                        > > > > > You failed to set the ownership of /var/lib/mailman/data/aliases
                        > > > > > and /var/lib/mailman/data/aliases.db.
                        > > > > >
                        > > > > > I suppose this would be mentioned in the mailman instructions.
                        > > > > >
                        > > > > > Wietse
                        > > > >
                        > > > > I have not found any such instruction in suse mailman manual.
                        > > > > Checked the ownership and found they are set to mailman group
                        > > > > already
                        > > > >
                        > > > > -rw-rw-r-- 1 mailman mailman 12288 Sep 2 11:07 /var/lib/mailman/data/aliases.db
                        > > > >
                        > > > > -rw-rw---- 1 root mailman 1865 Sep 2 11:07 /var/lib/mailman/data/aliases
                        > > >
                        > > > You must set the OWNER to mailman, not the GROUP.
                        > > >
                        > > > Then, Postfix will is use the mailman group ID in the PASSWORD file.
                        > > > Postfix will not use the mailman group ID in the GROUP file.
                        > > >
                        > > > Wietse
                        > >
                        > > OK, now I have the following
                        > >
                        > > -rw-rw---- 1 mailman root 1865 Sep 2 11:07 /var/lib/mailman/data/aliases
                        > >
                        > > but still the same error :-( Also tried with mailman:mailman but no luck..
                        >
                        > I told you to set the ownership of TWO FILES.
                        >
                        > Since you are following SUSE instructions, I suggest that you ask
                        > them for help instead.
                        >
                        > Wietse

                        The other one i.e.

                        /var/lib/mailman/data/aliases.db

                        already have mailman as owner...
                      • J. Bakshi
                        On Fri, 02 Sep 2011 15:54:51 +0200 ... That file too have the owner as mailman -rw-rw-r-- 1 mailman mailman 12288 Sep 2 11:07 /var/lib/mailman/data/aliases.db
                        Message 11 of 12 , Sep 2, 2011
                        • 0 Attachment
                          On Fri, 02 Sep 2011 15:54:51 +0200
                          Reindl Harald <h.reindl@...> wrote:

                          >
                          >
                          > Am 02.09.2011 15:22, schrieb Wietse Venema:
                          > >> I have not found any such instruction in suse mailman manual.
                          > >> Checked the ownership and found they are set to mailman group
                          > >> already
                          > >>
                          > >> -rw-rw-r-- 1 mailman mailman 12288 Sep 2 11:07 /var/lib/mailman/data/aliases.db
                          > >>
                          > >> -rw-rw---- 1 root mailman 1865 Sep 2 11:07 /var/lib/mailman/data/aliases
                          > >
                          > > You must set the OWNER to mailman, not the GROUP.
                          > >
                          > > Then, Postfix will is use the mailman group ID in the PASSWORD file.
                          > > Postfix will not use the mailman group ID in the GROUP file
                          >
                          > you did not notice that "/var/lib/mailman/data/aliases.db" is the relevant file
                          > and has the owner "mailman", "/var/lib/mailman/data/aliases" is the unhashed
                          >
                          >
                          That file too have the owner as mailman

                          -rw-rw-r-- 1 mailman mailman 12288 Sep 2 11:07 /var/lib/mailman/data/aliases.db
                        • Reindl Harald
                          ... i know and that is why i answered Wietse and not to you
                          Message 12 of 12 , Sep 2, 2011
                          • 0 Attachment
                            Am 02.09.2011 16:00, schrieb J. Bakshi:
                            > On Fri, 02 Sep 2011 15:54:51 +0200
                            > Reindl Harald <h.reindl@...> wrote:
                            >
                            >>
                            >> Am 02.09.2011 15:22, schrieb Wietse Venema:
                            >>>> I have not found any such instruction in suse mailman manual.
                            >>>> Checked the ownership and found they are set to mailman group
                            >>>> already
                            >>>>
                            >>>> -rw-rw-r-- 1 mailman mailman 12288 Sep 2 11:07 /var/lib/mailman/data/aliases.db
                            >>>>
                            >>>> -rw-rw---- 1 root mailman 1865 Sep 2 11:07 /var/lib/mailman/data/aliases
                            >>>
                            >>> You must set the OWNER to mailman, not the GROUP.
                            >>>
                            >>> Then, Postfix will is use the mailman group ID in the PASSWORD file.
                            >>> Postfix will not use the mailman group ID in the GROUP file
                            >>
                            >> you did not notice that "/var/lib/mailman/data/aliases.db" is the relevant file
                            >> and has the owner "mailman", "/var/lib/mailman/data/aliases" is the unhashed
                            >>
                            >>
                            > That file too have the owner as mailman
                            >
                            > -rw-rw-r-- 1 mailman mailman 12288 Sep 2 11:07 /var/lib/mailman/data/aliases.db

                            i know and that is why i answered Wietse and not to you
                          Your message has been successfully submitted and would be delivered to recipients shortly.