1

Topic: Remove Forwarder

I accidentally added a forwarder for an email address that I had not yet added in the admin panel Now trying to add that email fails with "user already exists". Just want to confirm the correct way to remove the forwarder in Mysql.

It was added like:

INSERT INTO forwardings (address,
                         forwarding,
                         domain,
                         dest_domain,
                         is_forwarding,
                         active)
                 VALUES ('me@mydomain.com',
                         'me@gmail.com',
                         'mydomain.com',
                         'gmail.com',
                         1,
                         1);

So to remove it would be:

DELETE FROM forwardings
  WHERE address = 'me@mydomain.com'
        AND forwarding = 'me@gmail.com'
        AND is_list = 1;

Is that correct?

----

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

2

Re: Remove Forwarder

Beejango wrote:

DELETE FROM forwardings
  WHERE address = 'me@mydomain.com'
        AND forwarding = 'me@gmail.com'
        AND is_list = 1;

Remove the "AND is_list=1", then it's ok.
BTW, you created it with "is_forwarding=1".

3

Re: Remove Forwarder

ZhangHuangbin wrote:
Beejango wrote:

DELETE FROM forwardings
  WHERE address = 'me@mydomain.com'
        AND forwarding = 'me@gmail.com'
        AND is_list = 1;

Remove the "AND is_list=1", then it's ok.
BTW, you created it with "is_forwarding=1".

Thank you.