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.