Export blacklist and whitelist from ESVA and import to EFA

0

If you are migrating from ESVA to EFA you can export and import the black/whitelist with a simple script i wrote. note: This script doesn’t check for double entry’s.

  1. ssh to your ESVA server
  2. wget http://dl.efa-project.org/exportlists.sh
  3. chmod +x exportlists.sh
  4. ./exportlists.sh
  5. There should be a output.sql file in the directory where you executed the script. Copy this to your EFA server. You can use scp for example: scp output.sql efaadmin@<yourEFAhost>:
  6. Now ssh to your EFA machine.
  7. Execute the following command to import the black/whitelist: mysql -u root -p`cat /etc/mysql/EFA.cnf` < output.sql
  8. All done.

*Optional*
By default, the black and whitelist entry’s are added under the root (id=1) account of EFA. If you want them added under another account, just change the @userid variable in the first line of output.sql. To find out the userid:

  1. Login to the EFA webinterface
  2. Go to settings -> accounts
  3. Click on the icon of the desired user
  4. The id can be found in the addressbar, for example http://<EFAhost>/accounts/user/2/. 2 is the userid.

You can get EFA here: http://www.efa-project.org/

Leave a Reply