how to connect EFA02 to EFA01 mysql.

Questions and answers about how to do stuff
Post Reply
curibe
Posts: 74
Joined: 26 Feb 2014 22:38

how to connect EFA02 to EFA01 mysql.

Post 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.
User avatar
shawniverson
Posts: 3783
Joined: 13 Jan 2014 23:30
Location: Indianapolis, Indiana USA
Contact:

Re: how to connect EFA02 to EFA01 mysql.

Post 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:
resads
Posts: 3
Joined: 19 Mar 2014 03:09

Re: how to connect EFA02 to EFA01 mysql.

Post 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.
User avatar
shawniverson
Posts: 3783
Joined: 13 Jan 2014 23:30
Location: Indianapolis, Indiana USA
Contact:

Re: how to connect EFA02 to EFA01 mysql.

Post 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.
curibe
Posts: 74
Joined: 26 Feb 2014 22:38

Re: how to connect EFA02 to EFA01 mysql.

Post 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.
curibe
Posts: 74
Joined: 26 Feb 2014 22:38

Re: how to connect EFA02 to EFA01 mysql.

Post 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.
curibe
Posts: 74
Joined: 26 Feb 2014 22:38

Re: how to connect EFA02 to EFA01 mysql.

Post by curibe »

Hello,

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

Thanks.
User avatar
pdwalker
Posts: 1583
Joined: 18 Mar 2015 09:16

Re: how to connect EFA02 to EFA01 mysql.

Post by pdwalker »

Not yet.
Post Reply