Page 1 of 1

database components backup/export/import to new EFA?

Posted: 18 Jan 2018 12:51
by SharazJek
i am considering building a new EFA in place of one that will no longer authenticate to AD. if that does end up resolving the problem, what do i do about all the spam database data i have built up on the original one that has been in operation for a year? is there a procedure somewhere to recover this data into a new EFA box?

Re: database components backup/export/import to new EFA?

Posted: 18 Jan 2018 14:16
by shawniverson
Yes, sure can. Let me know if you decide to do this, and I'll post a few pointers.

Re: database components backup/export/import to new EFA?

Posted: 18 Jan 2018 16:53
by SharazJek
yes, i am interested.

Re: database components backup/export/import to new EFA?

Posted: 29 Jan 2018 08:29
by doerfi
Hallo, I´m new in here and I have to do the same. Can I please get the procedure to recover and import the needed data into a new eFa.
We have some bugs in the eFa after Update to Version 3.0.2.5 and so we want to build up a new vitual appliance with the Data from the old eFa-System?

Thx

Re: database components backup/export/import to new EFA?

Posted: 29 Jan 2018 20:08
by shawniverson
Two steps...

1) Use EFA-Backup to create a backup file, copy to new system at /var/EFA/backup, and restore using EFA-Configure
2) copy /var/spool/mailscanner/quarantine to the new system

Re: database components backup/export/import to new EFA?

Posted: 29 Jan 2018 20:46
by shawniverson
More comprehensive howto here...you shouldn't need to patch func_systemrestore as described here any more.

viewtopic.php?f=5&t=2703

Re: database components backup/export/import to new EFA?

Posted: 06 May 2020 19:05
by SharazJek
looking at this again after a couple years, im running on v4 now. its looking like EFA-Backup is not available in v4? (is that correct?)

Re: database components backup/export/import to new EFA?

Posted: 07 May 2020 11:48
by shawniverson
It is here:

eFa-Backup-cron

Re: database components backup/export/import to new EFA?

Posted: 07 May 2020 12:25
by SharazJek
sorry man, i know i asked this 2 years ago and you answered it immediately, and i apologize it took me this long to find time to mess with it.

so i see the backup is pretty comprehensive.

i have 2 new totally unique installs, already attached to my spacewalk server and ready for production operation. EFA4 already installed and no issues to report. i was hoping there was a way to import just the greylist and white/black lists (and whatever is related or associated with that). i can live without the mail quarantine or all the of the rest of the config files, as i am trying to discard "the identity" of the old server and start fresh with 2 new servers, but being able to pre-load the white/black/grey lists would cover most of "creating maturity" of a functional mail gateway.

because honestly, the biggest chore of a brand-spiggity-new EFA is baby sitting the grey list for weeks while all the previously-known senders are re-verified.

Re: database components backup/export/import to new EFA?

Posted: 07 May 2020 14:15
by smyers119
The GUI whitelist/blacklist is part of mailwatch.
It's located In the database mailwatch
Greylisting can be duplicated by just replicating the database sqlgrey

Re: database components backup/export/import to new EFA?

Posted: 09 May 2020 14:44
by SharazJek
so this morning i scp'd the most recent backup from the EFA4 server i want to decom, over to 2 new hosts i want to replace it with. one host has the same hostname as the old server, and one is new. using the EFA retore function from the menus seems to have yielded the desired result, on both servers.

now, i wonder if i can somehow import EFA3 "maturity" into an EFA4? would this process work on an EFA4 if the source backup file came from EFA3?

Re: database components backup/export/import to new EFA?

Posted: 09 May 2020 14:55
by smyers119

Re: database components backup/export/import to new EFA?

Posted: 10 May 2020 07:11
by henk
If you build a new efa and just want a partial migration, just the black / whitelist and bayes

V3

Code: Select all

MYSQLPWD=$(grep MYSQLROOTPWD /etc/EFA-Config | sed -e 's/^.*://')
mysqldump --user=root --password=$MYSQLPWD mailscanner blacklist > list.sql
mysqldump --user=root --password=$MYSQLPWD mailscanner whitelist >> list.sql
MYSQLPWD= 
sa-learn –backup > /root/backup.txt 
V4

Code: Select all

MYSQLPWD=$(grep MYSQLROOTPWD /etc/eFa/MySQL-Config | sed -e 's/^.*://')
mysql --user=root --password=$MYSQLPWD mailscanner < list.sql
MYSQLPWD= 
sa-learn –clear
sa-learn –restore /root/backup.txt