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
Shared database, to allow multiple EFA appliances sharing one truth for SQLGrey etc
- shawniverson
- Posts: 3650
- Joined: 13 Jan 2014 23:30
- Location: Indianapolis, Indiana USA
- Contact:
-
- Posts: 15
- Joined: 19 Jun 2015 16:17
Re: Shared database, to allow multiple EFA appliances sharing one truth for SQLGrey etc
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.
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
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.
Then we could load-balance incoming email to multiple EFAs.
Re: Shared database, to allow multiple EFA appliances sharing one truth for SQLGrey etc
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!
Re: Shared database, to allow multiple EFA appliances sharing one truth for SQLGrey etc
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.
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
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.
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.