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

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: 2592
Joined: 13 Jan 2014 23:30
Location: Rushville, Indiana, USA
Contact:

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

Post by shawniverson » 21 Oct 2017 11:53

Yes, on the radar :)
Version 3.0.2.6 released! Update now to keep your eFa secure!



toddh
Posts: 33
Joined: 16 Feb 2015 18:52

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

Post by toddh » 14 Aug 2018 17:11

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.

Post Reply