1

Topic: SQL to activate "Save a copy in mailbox" on "Forwarding" tab

============ Required information ====
- iRedMail version (check /etc/iredmail-release): 0.8.5
- Linux/BSD distribution name and version: CentOS 6.5
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx): Apache
- Manage mail accounts with iRedAdmin-Pro? Yes
- Related log if you're reporting an issue:
====

Hi there,

I am importing a number of users and I'm running into an issue I don't remember seeing before.

When creating a new email account (either through iRedAdmin-Pro or via MySQL statements), the "Save a copy in mailbox" check box is checked by default on the "Forwarding" tab.

However, when I execute the following SQL statement directly, it turns off the "Save a copy in mailbox" check box:

UPDATE alias SET goto='OTHER-EMAIL@ADDRESS' WHERE address='IREDMAIL-EMAIL@ADDRESS';

What SQL do I need to execute to turn it back on? Where is this bit stored? I can't see it in either the "mailbox" or "alias" tables.

Thanks in advance.


Craig

----

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

2

Re: SQL to activate "Save a copy in mailbox" on "Forwarding" tab

Try this:

UPDATE alias SET goto='IREDMAIL-EMAIL@ADDRESS,OTHER-EMAIL@ADDRESS' WHERE address='IREDMAIL-EMAIL@ADDRESS';

3

Re: SQL to activate "Save a copy in mailbox" on "Forwarding" tab

Hi Zhang,

Thanks very much. That worked.


Craig