[MultuServer] Primary and BackupMX

Discussion in 'ISPConfig 3 Priority Support' started by SpeedyB, Mar 21, 2015.

  1. SpeedyB

    SpeedyB Member HowtoForge Supporter

    Hello,

    I am trying to configure a BackupMX in a multiserver setup
    What I have
    I have 2 servers Master and Slave
    All mailboxes are installed on Master
    MX records are pointing to Master

    What I want to achieve
    When Master is offline have mail received and stored on Slave
    When Master is back online, forward all mail from Slave to Master

    When I try to deliver mail for domain.tld on Slave it is bounced as not allowed to relay


    How can I configure this?

    I tried to download the new Manual, but the ispconfig.org website is down.

    Regards,

    Bas Steelooper
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Personally I would setup a ispconfig mirror instead of a backup mx. the mirror has the benefit that you can access all mailboxes from both servers and both servers are able to receive mails, so when one server is down, you can access the mailboxes on the other system.

    For a mail mirror you just set the 2 servers to be mirrrs in ISPConfig and then you use unsison or a cluster filesystem for /var/vmail. An alternative to a shared filesystem is to use the dovecot internal sync function.
     
  3. SpeedyB

    SpeedyB Member HowtoForge Supporter

    The thing is that both servers are in production and I find it scary to change such a thing since I have no experience with it..
    When I mirror the server what will happen exactly?

    Do you know of instructions to do this? Either mirroring (if safe) or have the slave server forward the known mail domains / addresses to the master server?

    On the master server I use courier and the slave server is dovecot, so I think the internal sync will not work. Also I don't know what the impact will be if I change the mail system from courier to dovecot or vice versa.
    Do you have any experience with this?
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    Ok, if they are in production then you cant use mirroring as this has to be setup at the beginning. The remaining option is to setup transports on the second server for the domains tha he shall be a backup mx for, the target of thebtransports is the first server. Additionally you will have to setup the mail adresses or at least the domains under relay recipients on the second server.
     
  5. SpeedyB

    SpeedyB Member HowtoForge Supporter

    Is this something that can be scripted? I have 90 accepted domains which I have to add.

    So I need to add for server2 the Relay Recipients for all these domains. And than create the transports for these domains.

    Can I use simple SQL to achieve this?
    Relay Recipient:
    Code:
    INSERT INTO `mail_relay_recipient` (`sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`, `server_id`, `source`, `access`, `active`) VALUES
    (1, 1, 'riud', 'riud', '', 3, '@<$domain>', 'OK', 'y');
    Where I insert the domain for the <$domain> placeholder?
    Server 1 is the master, Server 3 is the slave

    Transport:
    Code:
     INSERT INTO `mail_transport` (`sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`, `server_id`, `domain`, `transport`, `sort_order`, `active`) VALUES
    (1, 1, 'riud', 'riud', '', 3, '<$domain>', 'smtp:[<$masterserver>]', 5, 'y');
    Or will I break something when I do it like this?
    Are there other values which need to be set?
     
  6. till

    till Super Moderator Staff Member ISPConfig Developer

    In this special case it should be enough to run the mysql queries as this part of the configuration exists in mysql only.
     
    SpeedyB likes this.
  7. SpeedyB

    SpeedyB Member HowtoForge Supporter

    I added the routing and transport entries from SQL. But I receive the error message:
    554 5.7.1 <[email protected]>: Relay access denied
    I have the relay setup as @domain.tld (As described in the manual)
    Do I have to trigger something?

    When I look in the database on the slave server I don't see the records there.
     
  8. till

    till Super Moderator Staff Member ISPConfig Developer

    Did you receive this message on the master or on the backup mx?
     
  9. SpeedyB

    SpeedyB Member HowtoForge Supporter

    I received this on the backup (slave) server.

    I went to see what was in the dbispconfig database and saw that the records were missing in this database.
    I manualy imported them to this server (with the same primary key) and now is it working.
     

Share This Page