Export blacklist and whitelist from ESVA and import to EFA

Questions and answers about how to do stuff
Post Reply
User avatar
darky83
Site Admin
Posts: 529
Joined: 30 Sep 2012 11:03
Location: eFa
Contact:

Export blacklist and whitelist from ESVA and import to EFA

Post by darky83 » 31 Dec 2012 22:09

If you are migrating from ESVA to EFA you can export and import the black/whitelist with a simple script.

note: This script doesn’t check for double entry’s.

ssh to your ESVA server

Code: Select all

wget http://dl.efa-project.org/exportlists.sh
chmod +x exportlists.sh
./exportlists.sh
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: s

Code: Select all

cp output.sql efaadmin@<yourEFAhost>:
Now ssh to your EFA machine.
Execute the following command to import the black/whitelist:

Code: Select all

mysql -u root -p`cat /etc/mysql/EFA.cnf` < output.sql
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:
  • Login to the EFA webinterface
  • Go to settings -> accounts
  • Click on the icon of the desired user
  • The id can be found in the addressbar, for example http://<EFAhost>/accounts/user/2/. 2 is the userid.

Source: http://www.tuser.nl
E.F.A 3.0.2.6 update released

Post Reply