1 Topic by depcadastre

  • depcadastre
  • Member
  • Offline
  • Registered: 2015-09-28
  • Posts: 54

Topic: Forwarding incoming mail to nonexistent addresses

==== Required information ====
- iRedMail version (check /etc/iredmail-release): 0.9.2
- Linux/BSD distribution name and version: debian 8
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): mysql
- Web server (Apache or Nginx):apache
- Manage mail accounts with iRedAdmin-Pro?iRedAdmin
- Related log if you're reporting an issue:
====
I welcome all the participants of the forum. Help to set up forwarding of incoming mail sent to nonexistent addresses to a particular address.

----

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,165

Re: Forwarding incoming mail to nonexistent addresses

We have a document for you:
http://www.iredmail.org/docs/sql.create.catch-all.html

3 Reply by depcadastre (edited by depcadastre 2015-09-29 15:11:57)

  • depcadastre
  • Member
  • Offline
  • Registered: 2015-09-28
  • Posts: 54

Re: Forwarding incoming mail to nonexistent addresses

ZhangHuangbin wrote:

We have a document for you:
http://www.iredmail.org/docs/sql.create.catch-all.html

Thanks for the help, but when you add in the values table alias throws an error
ERROR 1142 (42000): INSERT command denied to user 'vmail'@'localhost' for table 'alias'

The table alias already have the postmaster account.

4 Reply by ZhangHuangbin

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

Re: Forwarding incoming mail to nonexistent addresses

Please login to MySQL server address as root user, then execute the sql commands mentioned in our tutorial.

5 Reply by depcadastre (edited by depcadastre 2015-09-30 14:21:57)

  • depcadastre
  • Member
  • Offline
  • Registered: 2015-09-28
  • Posts: 54

Re: Forwarding incoming mail to nonexistent addresses

ZhangHuangbin wrote:

Please login to MySQL server address as root user, then execute the sql commands mentioned in our tutorial.

ERROR 1045 (28000): access denied for user root@localhost (using password:YES).

Only under the user vmail can connect to mysql.

6 Reply by ZhangHuangbin

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

Re: Forwarding incoming mail to nonexistent addresses

*) You can find SQL root password in file `iRedMail.tips` under iRedMail-0.9.2 directory.
*) If you don't have iRedMail-0.9.2 directory, find SQL username 'vmailadmin' and its password in iRedAdmin config file.
Reference: http://www.iredmail.org/ docs/file.locations.html#iredadmin

7 Reply by depcadastre

  • depcadastre
  • Member
  • Offline
  • Registered: 2015-09-28
  • Posts: 54

Re: Forwarding incoming mail to nonexistent addresses

ZhangHuangbin wrote:

*) You can find SQL root password in file `iRedMail.tips` under iRedMail-0.9.2 directory.
*) If you don't have iRedMail-0.9.2 directory, find SQL username 'vmailadmin' and its password in iRedAdmin config file.
Reference: http://www.iredmail.org/ docs/file.locations.html#iredadmin

Thank you so much. It worked. I had to add an entry from the mysql root user, not debian. If later you need to change your email, you need this entry to delete and add a new one?

8 Reply by ZhangHuangbin

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

Re: Forwarding incoming mail to nonexistent addresses

depcadastre wrote:

If later you need to change your email, you need this entry to delete and add a new one?

I suggest you manage mail accounts with iRedAdmin web interface.