1 Topic by rgould (edited by rgould 2017-07-21 15:27:36)

  • rgould
  • Member
  • Offline
  • Registered: 2017-07-21
  • Posts: 4

Topic: Creating email groups/aliases

============ Required information ====
- iRedMail version: 0.9.7 MYSQL edition.
- Linux/BSD distribution name and version: Ubuntu Server 16.04.2 LTS
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx): Apache
- Manage mail accounts with iRedAdmin-Pro? Not yet.
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

I'm a little confused about the difference between the vocabulary "alias", "forwarder", "group", etc. I need to set up a distribution group named "testgroup@mydomain.com" that dispatches the same message to "user1@mydomain.com", "user2@mydomain.com", and "user3@mydomain.com". This is all inside my domain; I don't yet need to create a local group that sends to an outside domain, which I believe is a mail contact in Exchange parlance.

I referenced the recent post http://www.iredmail.org/forum/topic1304 … arder.html and that sounded like the same problem I'm having. I noticed Zhang's responses:

  • "I'm pretty sure that you created mail accounts manually, but you didn't have correct SQL records in "vmail.alias" table for mail users..."

  • "All mail user accounts stored in "vmail.mailbox" table must have a sql record in "vmail.alias" table."

  • "You should sync "vmail.mailbox" to "vmail.alias" with correct data, then run the migrate script mentioned in iRedMail-0.9.7 upgrade tutorial to switch to new SQL structure.".

1) I created two additional users through the iredadmin page, and I have the existing postmaster account. I didn't create them via command line.
2) All three exist in vmail.mailbox, but vmail.alias is an empty table.
3) vmail.mailbox and vmail.alias don't have matching columns. I installed 0.9.7 from scratch, so there was no upgrade track I had to follow.

So I guess my questions are, how do I create an internal distribution group and am I doing something wrong or is there a bug in the 0.9.7 release which doesn't create users in vmail.mailbox and vmail.alias?

ADDENDUM:
I installed 0.9.6 on a different server on 2017/06/16. The alias and mailbox tables do have matching address and username entries.

----

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

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,094

Re: Creating email groups/aliases

You can follow our tutorials to create mail alias account:
http://www.iredmail.org/docs/sql.create.mail.alias.html

Also, create a new mail user:
http://www.iredmail.org/docs/sql.create.mail.user.html

3 Reply by rgould

  • rgould
  • Member
  • Offline
  • Registered: 2017-07-21
  • Posts: 4

Re: Creating email groups/aliases

ZhangHuangbin wrote:

You can follow our tutorials to create mail alias account:
http://www.iredmail.org/docs/sql.create.mail.alias.html

Also, create a new mail user:
http://www.iredmail.org/docs/sql.create.mail.user.html

Great, thank you. Is there a problem with 0.9.7 where users from vmail.mailbox aren't added to vmail.alias?

4 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,094

Re: Creating email groups/aliases

rgould wrote:

Is there a problem with 0.9.7 where users from vmail.mailbox aren't added to vmail.alias?

iRedMail-0.9.7 stores user in "vmail.mailbox" and "vmail.forwardings".

5 Reply by vickyjey

  • vickyjey
  • Member
  • Offline
  • Registered: 2017-11-26
  • Posts: 1

Re: Creating email groups/aliases

Would this documentation work for group mail?

https://docs.iredmail.org/sql.create.mail.alias.html

As I would need to set up a group named "group@yourdomain.com" and all the messages that is on "group" mail box should be to go to "user1@yourdomain.com", "user2@yourdomain.com", and "user3@yourdomain.com".

6 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,094

Re: Creating email groups/aliases

vickyjey wrote:

Would this documentation work for group mail?

https://docs.iredmail.org/sql.create.mail.alias.html

YES.

7 Reply by ncplibraries (edited by ncplibraries 2018-04-26 02:25:39)

  • ncplibraries
  • Member
  • Offline
  • Registered: 2018-03-28
  • Posts: 2

Re: Creating email groups/aliases

ZhangHuangbin wrote:
vickyjey wrote:

Would this documentation work for group mail?

https://docs.iredmail.org/sql.create.mail.alias.html

YES.

I'm not sure I'm understanding the tutorial correctly. If I have 10 members of a mailing list, do I have to run the "INSERT INTO forwardings" query one time for each member or can I put several members in the "VALUES ('alias@mydomain.com', 'someone@test.com'," section?

Will this example query work?

INSERT INTO forwardings (address, forwarding,
                              domain, dest_domain,
                              is_list, active)
VALUES ('alias@mydomain.com', 'someone1@test.com,someone2@test.com,someone3@test.com',
                              'mydomain.com', 'test.com',
                              1, 1);

8 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,094

Re: Creating email groups/aliases

ncplibraries wrote:

do I have to run the "INSERT INTO forwardings" query one time for each member or can I put several members in the "VALUES

One "INSERT" per member.

Column "forwarding" should contain ONLY ONE email address.

9 Reply by ncplibraries

  • ncplibraries
  • Member
  • Offline
  • Registered: 2018-03-28
  • Posts: 2

Re: Creating email groups/aliases

ZhangHuangbin wrote:
ncplibraries wrote:

do I have to run the "INSERT INTO forwardings" query one time for each member or can I put several members in the "VALUES

One "INSERT" per member.

Column "forwarding" should contain ONLY ONE email address.

Thank you. smile