Shared database, to allow multiple EFA appliances sharing one truth for SQLGrey etc

Request and discuss new features you would like to have.
Post Reply
SupportOU
Posts: 47
Joined: 12 Sep 2016 18:47

Shared database, to allow multiple EFA appliances sharing one truth for SQLGrey etc

Post by SupportOU »

Hola,
I don't know if this is already in the wish list somewhere, but is it possible to have a shared MariaDB, which can serve multiple instances of the appliance? This, so we can have true HA with one truth for grey listing, black/whitelists, statistics, bayes, and so on.

Would be super!

Grtz,
Ronald
User avatar
shawniverson
Posts: 3644
Joined: 13 Jan 2014 23:30
Location: Indianapolis, Indiana USA
Contact:

Re: Shared database, to allow multiple EFA appliances sharing one truth for SQLGrey etc

Post by shawniverson »

Yes, on the radar :)
toddh
Posts: 69
Joined: 16 Feb 2015 18:52

Re: Shared database, to allow multiple EFA appliances sharing one truth for SQLGrey etc

Post by toddh »

This is already available. We have been doing it for years.

All you need is a shared MySQL server and adjust SQLGrey DB settings in /etc/swlgrey/sqlgrey.conf

## Database settings
db_type = mysql
db_name = sqlgrey
db_host = xxx.xxx.xxx.xxx MySQL Server IP
db_port = default
user = username
db_pass = userpass

Of course you have to create provision the sqlgrey DB on the server.

Hope this helps.
mph
Posts: 7
Joined: 09 Oct 2018 08:40

Re: Shared database, to allow multiple EFA appliances sharing one truth for SQLGrey etc

Post by mph »

Would be better to replicate the DBs (with something like Galera) on each EFA to have a shared-nothing solution, otherwise DB is SPOF.
Then we could load-balance incoming email to multiple EFAs.
jamerson
Posts: 164
Joined: 19 Aug 2017 18:57
Location: kaaskop

Re: Shared database, to allow multiple EFA appliances sharing one truth for SQLGrey etc

Post by jamerson »

i would love to have this set up, how can i get it configured? tried the above but broke the installation.
Version eFa 4.0.0 RC1 now available in testing repo. Come join us in advancing eFa!
User avatar
pdwalker
Posts: 1553
Joined: 18 Mar 2015 09:16

Re: Shared database, to allow multiple EFA appliances sharing one truth for SQLGrey etc

Post by pdwalker »

When you say "broke" can you be a bit more specific?

Can you tell us all the steps you did between when it "worked" and when it "broke"?

If we know what you did, then we may be able to figure out where it went wrong.
User avatar
pdwalker
Posts: 1553
Joined: 18 Mar 2015 09:16

Re: Shared database, to allow multiple EFA appliances sharing one truth for SQLGrey etc

Post by pdwalker »

If I were to guess...

when you change the db_host from localhost to an ipaddress or hostname, the mysql database wouldn't allow access from a non local request.

To fix that, you'll have to give access to the sqlgrey database from that user/host combination.
Post Reply