Page 1 of 1

how to connect EFA02 to EFA01 mysql.

Posted: 27 Feb 2014 21:02
by curibe
Hello,

Just wondering, i want to have multiple EFA appliances but i would like to manage it using one mailwatch web gui. Is this possible? how would i be able to accomplish this??

EXAMPLE: i have 3 EFA hosts. i would like to be to see all the recent messages, quarantine, reports, etc from all 3 appliance when i log into 1 of the EFA's MailWatch Web Gui.

make sense?

Your help would be greatly appreciated it.

Re: how to connect EFA02 to EFA01 mysql.

Posted: 27 Feb 2014 23:44
by shawniverson
I do not think it is possible pull data from multiple E.F.A.'s at this time. It would probably require a major rewrite of the MailWatch GUI to implement.

:cry:

Re: how to connect EFA02 to EFA01 mysql.

Posted: 20 Mar 2014 00:50
by resads
This would be a fantastic addition to the software if it was possible to do (cluster multiple EFA hosts for failover)

Any chance we could review the possibilities of implementing? all EFA hosts could be connected via the same LAN (over vpn) for access to the sql db.

Re: how to connect EFA02 to EFA01 mysql.

Posted: 20 Mar 2014 22:24
by shawniverson
I agree. This would be a great addition. It will take quite a bit of work to accomplish. Maybe have a Primary EFA (where sql lives) and secondaries that communicates with the primary.

Re: how to connect EFA02 to EFA01 mysql.

Posted: 24 Mar 2014 16:12
by curibe
This seem to work for me.

http://osdir.com/ml/mail.virus.mailscan ... 00036.html

haven't really fully tested, but i see the recent messages showing for both efa boxes.

FYI, where it states this:

> Note: Perhaps Steve will review this and tell us all which server
> SHOULD have the DISTRIBUTED_SETUP set to "true" in conf.php. I've
> read the DOCs and it's not clear which server NEEDS this setting set
> to "true".

you need to set it to true on the server where Mysql will be the Master for all your EFA hosts.

Re: how to connect EFA02 to EFA01 mysql.

Posted: 24 Mar 2014 16:14
by curibe
My plan would be to have EFA01 to only work for the Mailwatch (no incoming/outgoing email will go to this box) and have efa02,03,04 etc will be the ones accepting all mail and will connect to efa01 for mysql.

Re: how to connect EFA02 to EFA01 mysql.

Posted: 26 May 2017 02:40
by curibe
Hello,

Wonder if clustering is now available for the new EFA version.

Thanks.

Re: how to connect EFA02 to EFA01 mysql.

Posted: 26 May 2017 09:15
by pdwalker
Not yet.