1 Topic by BHop

  • BHop
  • Member
  • Offline
  • From: Kiev, Ukraine
  • Registered: 2017-12-21
  • Posts: 3

Topic: Mail forwarding limitation

==== Required information ====
- iRedMail version (check /etc/iredmail-release):
- Linux/BSD distribution name and version:
- Store mail accounts in which backend (LDAP/MySQL/PGSQL):
- Web server (Apache or Nginx):
- Manage mail accounts with iRedAdmin-Pro?
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
======== Required information ====
- iRedMail version (check /etc/iredmail-release):  iRedMail    v0.9.7, iRedAdmin    v0.8 (MySQL)
- Linux/BSD distribution name and version: Linux Debian 9.2 x86_64
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx): Apache
- Manage mail accounts with iRedAdmin-Pro? - No
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

Hi to all.
I want to make mail redirection (forwarding) periodically from mail alias to list of emails of my colleagues.
In older version iRedAdmin v0.3 (MySQL) it works fine through the using table "alias", when the column "goto" has datatype "text" without limits of lenght of datatype varchar. Now, in fresh version of iRedMail, it works otherwise - through the table "forwarding" and column "forwarding", but it has limitation, due to the fact that datatype varchar (only 255 characters).
User vmailadmin has't rights for changing datatype of "forwarding" column to text.
How I can use forwarding for maillist, that contains more than 255 characters?
Thanks.

----

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: 30,793

Re: Mail forwarding limitation

Please read our tutorial:
https://docs.iredmail.org/sql.create.mail.alias.html

3 Reply by BHop

  • BHop
  • Member
  • Offline
  • From: Kiev, Ukraine
  • Registered: 2017-12-21
  • Posts: 3

Re: Mail forwarding limitation

ZhangHuangbin wrote:

Please read our tutorial:
https://docs.iredmail.org/sql.create.mail.alias.html

Thanks for your answer, but I read that manual and there are realized forwarding through modified the same column "forwardings", about which I wrote before, and it has a limitation of 255 characters.
Question remains the same: how can I send messages to alias through forwarding to mailist, that contains more, than 255 characters?

4 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,793

Re: Mail forwarding limitation

Answer remains the same: Please read our tutorial:
https://docs.iredmail.org/sql.create.mail.alias.html

PLEASE, read it, your question is answered in the example.

5 Reply by BHop

  • BHop
  • Member
  • Offline
  • From: Kiev, Ukraine
  • Registered: 2017-12-21
  • Posts: 3

Re: Mail forwarding limitation

ZhangHuangbin wrote:

Answer remains the same: Please read our tutorial:
https://docs.iredmail.org/sql.create.mail.alias.html

PLEASE, read it, your question is answered in the example.

Thanks a lot, Zhang.
Really, I had to take a closer read at the manual, your solution nontrivially for me, but works fine.

6 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 30,793

Re: Mail forwarding limitation

Our tutorial clearly shows that if you need to forward to multiple addresses, you need multiple SQL records.
It's not store all addresses in ONE column.