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
Code: Select all
cp output.sql efaadmin@<yourEFAhost>:
Execute the following command to import the black/whitelist:
Code: Select all
mysql -u root -p`cat /etc/mysql/EFA.cnf` < output.sql
*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