Page 1 of 1

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

Posted: 19 Oct 2017 13:19
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

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

Posted: 21 Oct 2017 11:53
by shawniverson
Yes, on the radar :)

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

Posted: 06 Nov 2017 21:24
by efa-user
+1 :)

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

Posted: 08 Mar 2018 11:58
by ZimboKraut
+1 (me toooooooo) :D

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

Posted: 14 Aug 2018 17:11
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.

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

Posted: 18 May 2020 13:37
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.

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

Posted: 07 Oct 2020 00:58
by jamerson
i would love to have this set up, how can i get it configured? tried the above but broke the installation.

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

Posted: 20 Oct 2020 10:29
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.

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

Posted: 20 Oct 2020 10:31
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.