Here are my notes from when I did this. A key factor for me was doing
it in a test environment first - no surprises like dying ASSP in prod.
HTH:
install mysql:
sudo apt-get install mysql-server
new password: (SEE KEEPASS)
sudo mysql -u root -p
mysql> CREATE DATABASE asspdb;
quit
run sudo ls (so that you have sudo available) then run:
cd /usr/share/assp/mysql/dbimport
sudo cp /usr/share/assp/spamdb ./spamdb.add
sudo cp /usr/share/assp/whitelist ./whitelist.add
sudo cp /usr/share/assp/redlist ./redlist.add
sudo cp /usr/share/assp/persblack ./persblackdb.add
sudo cp /usr/share/assp/delaydb ./delaydb.add
sudo cp /usr/share/assp/delaydb.white ./delaydb.white.add
sudo cp /usr/share/assp/ldaplist ./ldaplist.add
sudo cp /usr/share/assp/pb/pbdb.black.db ./pbdb.black.db.add
sudo cp /usr/share/assp/pb/pbdb.mxa.db ./pbdb.mxa.db.add
sudo cp /usr/share/assp/pb/pbdb.ptr.db ./pbdb.ptr.db.add
sudo cp /usr/share/assp/pb/pbdb.rbl.db ./pbdb.rbl.db.add
sudo cp /usr/share/assp/pb/pbdb.rwl.db ./pbdb.rwl.db.add
sudo cp /usr/share/assp/pb/pbdb.spf.db ./pbdb.spf.db.add
sudo cp /usr/share/assp/pb/pbdb.uribl.db ./pbdb.uribl.db.add
sudo cp /usr/share/assp/pb/pbdb.white.db ./pbdb.white.db.add
sudo cp /usr/share/assp/pb/pbdb.dkim.db ./pbdb.dkim.db.add
sudo cp /usr/share/assp/pb/pbdb.sb.db ./pbdb.sb.db.add
ls
In the ASSP GUI, under File Paths and Database, change these settings:
database hostname or IP (myhost) - 127.0.0.1
database name (mydb) - asspdb
database username (myuser) - root
database password (mypassword) - SEE KEEPASS
Change backup Database Interval (backupDBInterval) to 24.
In the ASSP GUI, change all these (under Files Paths and Database)
Change these to "DB:" (no quotes)
spamdb
whitelistdb
redlistdb
persblackdb
ldaplistdb
delaydb
(Under PenaltyBox/Message and IP) change to DB:
pbdb
Under Bayesian and Hidden Markov Model, uncheck Use BerkelyDB for the
Hidden Markov Model database(HMMusesBDB)
Apply changes, terminate ASSP.
Start ASSP
CHECK MAILLOG. Make sure all is well. Import should run. Wait until
it is fully started again.
Terminate/Start ASSP. Check logs again.
- Bob
On 6/1/2017 2:12 PM, James Moe wrote:
On 06/01/2017 06:49 AM, Alexandre de Arruda Paes wrote:
In assp base dir, do you have the file assp_db_import.cfg ?
Yes. Here are the first two lines:
# version='2.4.3';
# modversion='(15119)';
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Assp-user mailing list
Assp-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/assp-user
