Migrating from BerkeleyDB to MySQL

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Migrating from BerkeleyDB to MySQL

m.huijgen
Hi,

I'm trying to migrate from BerkeleyDB to MySQL. Using ASSP version
2.5.1(16177), Debian 8.4. I have verified that BerkeleyDB is working fine
on this ASSP installation by using db_dump, a Linux tool for watching
BerkeleyDB databases. Tie:RDBM is installed and according to CPAN is
up-to-date and working fine.

The following keys were set to the value 'DB:' (without the quote but
including the colon):
spamdb
whitelistdb
redlistdb
persblackdb
delaydb
ldaplistdb

** WHAT I TRIED ** (per the ASSP documentation)

1. Set up MySQL database + user (MySql on same server as ASSP, created a
db called assp and a user called assp, granted the user all rights on the
assp database).
2. set DisableSMTPNetworking to on
3. set all needed DB parameters:
myhost: 127.0.0.1 (also tried localhost)
DBdriver:
mysql,mysql_socket=/var/run/mysqld/mysqld.sock,AutoCommit=1,mysql_auto_reconnect=1
(copied the socket path so I'm positive it is correct)
mydb=assp
myuser=assp
mypassword=my_assp_password_here
DBCacheMaxAge=10
importDBDir=mysql/dbimport

Click [Apply Changes]

4. copy db files to mysql/import
cp /usr/share/assp/database/pb/pbdb.back.db
/usr/share/assp/mysql/dbimport/pbdb.back.db.add
cp /usr/share/assp/database/pb/pbdb.batv.db
/usr/share/assp/mysql/dbimport/pbdb.batv.db.add
cp /usr/share/assp/database/pb/pbdb.black.db
/usr/share/assp/mysql/dbimport/pbdb.black.db.add
cp /usr/share/assp/database/pb/pbdb.dkim.db
/usr/share/assp/mysql/dbimport/pbdb.dkim.db.add
cp /usr/share/assp/database/pb/pbdb.mxa.db
/usr/share/assp/mysql/dbimport/pbdb.mxa.db.add
cp /usr/share/assp/database/pb/pbdb.ptr.db
/usr/share/assp/mysql/dbimport/pbdb.ptr.db.add
cp /usr/share/assp/database/pb/pbdb.rbl.db
/usr/share/assp/mysql/dbimport/pbdb.rbl.db.add
cp /usr/share/assp/database/pb/pbdb.rwl.db
/usr/share/assp/mysql/dbimport/pbdb.rwl.db.add
cp /usr/share/assp/database/pb/pbdb.sb.db
/usr/share/assp/mysql/dbimport/pbdb.sb.db.add
cp /usr/share/assp/database/pb/pbdb.spf.db
/usr/share/assp/mysql/dbimport/pbdb.spf.db.add
cp /usr/share/assp/database/pb/pbdb.trap.db
/usr/share/assp/mysql/dbimport/pbdb.trap.db.add
cp /usr/share/assp/database/pb/pbdb.uribl.db
/usr/share/assp/mysql/dbimport/pbdb.uribl.db.add
cp /usr/share/assp/database/pb/pbdb.white.db
/usr/share/assp/mysql/dbimport/pbdb.white.db.add
cp /usr/share/assp/database/ldaplist.bdb
/usr/share/assp/mysql/dbimport/ldaplist.bdb.add
cp /usr/share/assp/database/redlist.bdb
/usr/share/assp/mysql/dbimport/redlist.bdb.add
cp /usr/share/assp/database/whitelist.bdb
/usr/share/assp/mysql/dbimport/whitelist.bdb.add
cp /usr/share/assp/database/spamdb.bdb
/usr/share/assp/mysql/dbimport/spamdb.bdb.add
cp /usr/share/assp/database/spamdb.helo.bdb
/usr/share/assp/mysql/dbimport/spamdb.helo.bdb.add
cp /usr/share/assp/database/delaydb.bdb
/usr/share/assp/mysql/dbimport/delaydb.bdb.add
cp /usr/share/assp/database/delaydb.white.bdb
/usr/share/assp/mysql/dbimport/delaydb.white.bdb.add

5. restart assp, wait until all imports are finished

Logfile (logs/maillog.txt) does not mention *anything* about importing
data. So I just waited five minutes. This being a test environment there
was just a couple hours mail traffic, the files are very small. No .ok
files appeared in the mysql/dbimport database.

6. restart assp

7. set DisableSMTPNetworking to off
Upon restarting ASSP DisableSMTPNetworking was already turned off.

I tried some varieties of the driver: just mysql; mysql and the socket;
and mysql, the socket and the other two options.

Here is the startup part of my logs/maillog.txt:
Jul-21-16 13:11:12 [startup] Info: lib/CorrectASSPcfg.pm loaded
Jul-21-16 13:11:12 [startup] Info: sub 'set' in module CorrectASSPcfg.pm
is called
Jul-21-16 13:11:12 [startup] Starting in console mode
Jul-21-16 13:11:13 [startup] ASSP version 2.5.1(16177) (Perl 5.020002) (on
linux) initializing
Jul-21-16 13:11:13 [startup] Info: registered encrypted POP3ConfigFile
file /usr/share/assp/files/pop3cfg.txt
Jul-21-16 13:11:13 [startup] AdminInfo: failed to open option list file
for reading '/usr/share/assp/files/MaxRealSize.txt' (MaxRealSizeAdr): No
such file or directory
Jul-21-16 13:11:13 [startup] AdminInfo: failed to open option list file
for reading '/usr/share/assp/files/MaxRealSizeExt.txt'
(MaxRealSizeExternalAdr): No such file or directory
Jul-21-16 13:11:13 [startup] AdminInfo: failed to open option list file
for reading '/usr/share/assp/files/MaxSize.txt' (MaxSizeAdr): No such file
or directory
Jul-21-16 13:11:13 [startup] AdminInfo: failed to open option list file
for reading '/usr/share/assp/files/MaxSizeExt.txt' (MaxSizeExternalAdr):
No such file or directory
Jul-21-16 13:11:13 [startup] Info: loading groups from groupsfile
/usr/share/assp/files/groups.txt
Jul-21-16 13:11:13 [startup] Info: enabled 5 recipient replacement rules -
0 invalid rules skipped
Jul-21-16 13:11:13 [startup] Info: Regex invalidFormatHeloRe: 4 weighted
regular expression defined
Jul-21-16 13:11:14 [startup] AdminInfo: failed to open option list file
for reading '/usr/share/assp/files/signedSenders.txt' (signedSenders): No
such file or directory
Jul-21-16 13:11:15 [startup] Info: Regex SuspiciousVirus: 16 weighted
regular expression defined
Jul-21-16 13:11:15 [startup] AdminInfo: failed to open option list file
for reading '/usr/share/assp/files/bombskipheadertagre.txt'
(bombSkipHeaderTagRe): No such file or directory
Jul-21-16 13:11:15 [startup] Warning: NO MSGIDsig-secrets activated -
MSGIDsig-check is now disabled  : 10 records ignored because of wrong
syntax or using default values :
0=key0|1=key1|2=key2|3=key3|4=key4|5=key5|6=key6|7=key7|8=key8|9=key9
Jul-21-16 13:11:15 [startup] Info: 10 BATV-secrets activated
Jul-21-16 13:11:15 [startup] Info: switched (DNS) nameserver order from to
192.168.1.1
Jul-21-16 13:11:15 [startup] Info: an ASSP restart will be done using the
AutoRestartCmd
Jul-21-16 13:11:15 [startup] ASSP version 2.5.1(16177) (Perl 5.020002) (on
linux)running on server: assp (127.0.1.1)
Jul-21-16 13:11:15 [startup] Info: unicode support is available on this
system
Jul-21-16 13:11:15 [startup] Info: this system uses little-endianess
Jul-21-16 13:11:15 [init] Threads module 1.93 installed
Jul-21-16 13:11:15 [init] Threads::shared module 1.46 installed
Jul-21-16 13:11:15 [init] Thread::Queue module 3.05 installed
Jul-21-16 13:11:15 [init] IO::Poll module 0.09 installed
Jul-21-16 13:11:15 [init] IO::Select module 1.22 installed
Jul-21-16 13:11:15 [init] ASSP is using IOEngine - Poll
Jul-21-16 13:11:15 [init] Thread::State module version 0.09 installed and
available
Jul-21-16 13:11:15 [init] IO::Socket::INET6 module is not detected (
enableINET6 is not set ).
Jul-21-16 13:11:15 [init] Net::LDAP module version 0.64 installed and
available
Jul-21-16 13:11:15 [init] Net::DNS module version 0.81 installed and
available
Jul-21-16 13:11:15 [init] Net::SMTP module version 3.09 installed and
available
Jul-21-16 13:11:15 [init] Net::SMTP::SSL module version 1.02 installed and
available
Jul-21-16 13:11:15 [init] NetSNMP::agent module is disabled in config.
Jul-21-16 13:11:15 [init] Mail::SPF::Query module is not installed.
Jul-21-16 13:11:15 [init] Mail::SPF module version 2.009 installed and
available
Jul-21-16 13:11:15 [init] Compress::Zlib module version 2.064 installed -
HTTP compression available
Jul-21-16 13:11:15 [init] Digest::MD5 module version 2.53 installed -
delaying can use MD5 keys for hashes
Jul-21-16 13:11:15 [init] Digest::SHA1 module version 2.13 installed -
BATV and FBMTV check available
Jul-21-16 13:11:15 [init] File::ReadBackwards module version 1.05
installed - searching of log files enabled
Jul-21-16 13:11:15 [init] Time::HiRes module version 1.9726 installed -
CPU usage statistics available
Jul-21-16 13:11:15 [init] Sys::Syslog module version 0.33 installed - Unix
centralized logging enabled
Jul-21-16 13:11:15 [init] Unicode::GCString module version 2013.10
installed - can detect east asian language strings as sequence of UAX #29
Grapheme Clusters to analyze Bayes and HMM
Jul-21-16 13:11:15 [init] Unicode::Normalize module is installed and
'unicodeNormalize' is enabled - NFKC unicode normalization is globaly
enabled
Jul-21-16 13:11:15 [init] Text::Unidecode module version 1.22 installed -
can transliterate unicode characters to ASCII
Jul-21-16 13:11:15 [init] Tie::RDBM module version 0.73 installed -
database usage available
Jul-21-16 13:11:15 [init] DB_File module is disabled in config - DB_File
(Berkeley V1) database usage not available
Jul-21-16 13:11:15 [init] BerkeleyDB module version 0.54 installed -
Berkeley database usage available
Jul-21-16 13:11:15 [init] BerkeleyDB DB-version 5.3 / Berkeley DB 5.3.28:
(September  9, 2013) is installed
Jul-21-16 13:11:15 [init] BerkeleyDB maximum cache size is set to 50MB
Jul-21-16 13:11:15 [init] Info: griplist is using basic 'orderedtie' in
file /usr/share/assp/database/griplist
Jul-21-16 13:11:15 [init] Net::CIDR::Lite module version 0.21 installed -
hyphenated IP address range available
Jul-21-16 13:11:15 [init] NetAddr::IP::Lite module version 1.54 installed
- hyphenated IP and CIDR address range calculation available
Jul-21-16 13:11:15 [init] Net::IP module version 1.26 installed -
hyphenated IP and CIDR address range calculation available
Jul-21-16 13:11:15 [init] LWP::Simple module version 6.15 installed -
procedural LWP interface available
Jul-21-16 13:11:15 [init] Email::MIME module version 1.926 installed -
MIME charset decoding and conversion interface and attachment detection
available
Jul-21-16 13:11:15 [init] MIME::Types module version 2.09 installed - TNEF
conversion may possible
Jul-21-16 13:11:15 [init] Email::Send module version 2.201 installed -
sending .eml files available
Jul-21-16 13:11:15 [init] Convert::TNEF module is disabled in config -
TNEF conversion not available
Jul-21-16 13:11:15 [init] Mail::DKIM::Verifier module version 0.4
installed - DKIM verification is available
Jul-21-16 13:11:15 [init] Schedule::Cron module version 1.01 installed -
RebuildSpamdb Scheduler is available
Jul-21-16 13:11:15 [init] Sys::MemInfo module version 0.91 installed -
memory calculation is available
Jul-21-16 13:11:15 [init] Sys::CpuAffinity module version 1.06 installed -
setting CPU Affinty is available - this system has 2 CPU's
Jul-21-16 13:11:15 [init] The Cpu Affinity of assp is currently '0 1'
Jul-21-16 13:11:15 [init] Warning: there are currently 2 CPU-cores
available for assp - but at least 4 CPU-cores are recommended!
Jul-21-16 13:11:15 [init] Authen::SASL module version 2.16 installed -
SMTP AUTH is available
Jul-21-16 13:11:15 [init] Regexp::Optimizer module version 0.23 installed
- default Regular Expression Optimization is available
Jul-21-16 13:11:15 [init] AsspSelfLoader module version 2.03 installed -
ASSP Code Load Optimization is available
Jul-21-16 13:11:15 [init] ASSP_WordStem module version 1.27 installed -
ASSP multi lingual word stemming engine for Bayesian and HMM checks is
available
Jul-21-16 13:11:15 [init] ASSP_FC module version 1.05 installed - ASSP
file commander is available
Jul-21-16 13:11:15 [init] ASSP_SVG module version 1.03 installed - ASSP
graphical STATS are available
Jul-21-16 13:11:15 [init] Info: openssl version 1.0.1t is installed
Jul-21-16 13:11:15 [init] IO::Socket::SSL module version 2.002 installed -
https and TLS/SSL is possible
Jul-21-16 13:11:15 [init] IO::Socket::SSL module version 2.002 installed -
but at least version 2.006 is recommended
Jul-21-16 13:11:15 [init] Found valid certificate and private key file -
https and TLS/SSL is available
Jul-21-16 13:11:15 [init] The underlying SSL library Net::SSLeay version
1.65 uses OpenSSL 1.0.1t  3 May 2016
Jul-21-16 13:11:15 [init] Info: assp has successfully loaded 339 Perl
modules in to its namespace
Jul-21-16 13:11:15 [init] Warning: There were module load errors detected
- look in to file /usr/share/assp/moduleLoadErrors.txt for more details.
To solve this issue install the failed modules or disable them in the
'Module Setup' section in the GUI.
Jul-21-16 13:11:15 [init] Warning: RelayOnlyLocalSender nor
RelayOnlyLocalDomains is enabled!
Jul-21-16 13:11:15 [init] Warning: DoLocalSenderAddress nor
DoLocalSenderDomain is enabled!
Jul-21-16 13:11:15 [init] Info: last DB-backup was scheduled before 1 hour
14 mins
Jul-21-16 13:11:15 [init] Info: next DB-backup is scheduled in 45 mins
Jul-21-16 13:11:15 [init] Error: internal public license is not valid
Jul-21-16 13:11:15 [init] Info: 0 licenses registered
Jul-21-16 13:11:15 [init] Error: unclean shutdown of ASSP detected
Jul-21-16 13:11:15 [init] Info: cleaned temporary BerkeleyDB directory
/usr/share/assp/tmpDB/Delay
Jul-21-16 13:11:15 [init] Info: cleaned temporary BerkeleyDB directory
/usr/share/assp/tmpDB/DelayWhite
Jul-21-16 13:11:15 [init] Info: cleaned temporary BerkeleyDB directory
/usr/share/assp/tmpDB/HeloBlack
Jul-21-16 13:11:15 [init] Info: cleaned temporary BerkeleyDB directory
/usr/share/assp/tmpDB/HMMdb
Jul-21-16 13:11:15 [init] Info: cleaned temporary BerkeleyDB directory
/usr/share/assp/tmpDB/LDAPlist
Jul-21-16 13:11:15 [init] Info: cleaned temporary BerkeleyDB directory
/usr/share/assp/tmpDB/PersBlack
Jul-21-16 13:11:15 [init] Info: cleaned temporary BerkeleyDB directory
/usr/share/assp/tmpDB/Redlist
Jul-21-16 13:11:15 [init] Info: cleaned temporary BerkeleyDB directory
/usr/share/assp/tmpDB/Spamdb
Jul-21-16 13:11:15 [init] Info: cleaned temporary BerkeleyDB directory
/usr/share/assp/tmpDB/Whitelist
Jul-21-16 13:11:15 [init] Saving config
Jul-21-16 13:11:15 [init] Info: no configuration changes detected -
nothing to save - file /usr/share/assp/assp.cfg is unchanged
Jul-21-16 13:11:15 [init] Info: start loading PBWhite from
/usr/share/assp/database/pb/pbdb.white.db with approx. 156
Jul-21-16 13:11:15 [init] Info: PBWhite loaded from
/usr/share/assp/database/pb/pbdb.white.db with 7 records
Jul-21-16 13:11:15 [init] Info: start loading PBBlack from
/usr/share/assp/database/pb/pbdb.black.db with approx. 424
Jul-21-16 13:11:15 [init] Info: PBBlack loaded from
/usr/share/assp/database/pb/pbdb.black.db with 184 records
Jul-21-16 13:11:15 [init] Info: start loading RBLCache from
/usr/share/assp/database/pb/pbdb.rbl.db with approx. 139
Jul-21-16 13:11:15 [init] Info: RBLCache loaded from
/usr/share/assp/database/pb/pbdb.rbl.db with 2 records
Jul-21-16 13:11:15 [init] Info: start loading URIBLCache from
/usr/share/assp/database/pb/pbdb.uribl.db with approx. 142
Jul-21-16 13:11:15 [init] Info: URIBLCache loaded from
/usr/share/assp/database/pb/pbdb.uribl.db with 6 records
Jul-21-16 13:11:15 [init] Info: start loading PTRCache from
/usr/share/assp/database/pb/pbdb.ptr.db with approx. 661
Jul-21-16 13:11:15 [init] Info: PTRCache loaded from
/usr/share/assp/database/pb/pbdb.ptr.db with 159 records
Jul-21-16 13:11:15 [init] Info: start loading MXACache from
/usr/share/assp/database/pb/pbdb.mxa.db with approx. 138
Jul-21-16 13:11:15 [init] Info: MXACache loaded from
/usr/share/assp/database/pb/pbdb.mxa.db with 2 records
Jul-21-16 13:11:15 [init] Info: start loading RWLCache from
/usr/share/assp/database/pb/pbdb.rwl.db with approx. 128
Jul-21-16 13:11:15 [init] Info: RWLCache loaded from
/usr/share/assp/database/pb/pbdb.rwl.db with 0 records
Jul-21-16 13:11:15 [init] Info: start loading SPFCache from
/usr/share/assp/database/pb/pbdb.spf.db with approx. 132
Jul-21-16 13:11:15 [init] Info: SPFCache loaded from
/usr/share/assp/database/pb/pbdb.spf.db with 1 records
Jul-21-16 13:11:15 [init] Info: start loading SBCache from
/usr/share/assp/database/pb/pbdb.sb.db with approx. 138
Jul-21-16 13:11:15 [init] Info: SBCache loaded from
/usr/share/assp/database/pb/pbdb.sb.db with 2 records
Jul-21-16 13:11:15 [init] Info: start loading PBTrap from
/usr/share/assp/database/pb/pbdb.trap.db with approx. 128
Jul-21-16 13:11:15 [init] Info: PBTrap loaded from
/usr/share/assp/database/pb/pbdb.trap.db with 0 records
Jul-21-16 13:11:15 [init] Info: start loading DKIMCache from
/usr/share/assp/database/pb/pbdb.dkim.db with approx. 129
Jul-21-16 13:11:15 [init] Info: DKIMCache loaded from
/usr/share/assp/database/pb/pbdb.dkim.db with 1 records
Jul-21-16 13:11:15 [init] Info: start loading BATVTag from
/usr/share/assp/database/pb/pbdb.batv.db with approx. 128
Jul-21-16 13:11:15 [init] Info: BATVTag loaded from
/usr/share/assp/database/pb/pbdb.batv.db with 0 records
Jul-21-16 13:11:15 [init] Info: start loading BackDNS from
/usr/share/assp/database/pb/pbdb.back.db with approx. 128
Jul-21-16 13:11:15 [init] Info: BackDNS loaded from
/usr/share/assp/database/pb/pbdb.back.db with 0 records
Jul-21-16 13:11:15 [init] Starting maintenance worker thread [10000] -
ThreadCycleTime is set to 3000 microseconds
Jul-21-16 13:11:16 [Worker_10000] Info: switched (DNS) nameserver order
from 192.168.1.1 to 192.168.1.1
Jul-21-16 13:11:16 [Worker_10000] Worker_10000 started
Jul-21-16 13:11:16 [Worker_10000] Info: last delta Griplist download was
at: Jul-21-16 12:53:10
Jul-21-16 13:11:16 [Worker_10000] Info: next Griplist upload is scheduled
for: Jul-22-16 13:42:19
Jul-21-16 13:11:16 [init] Starting SMTP-worker-threads with
ThreadCycleTime set to 3000 microseconds
Jul-21-16 13:11:16 [init] Starting communication worker threads [1 to 5]
Jul-21-16 13:11:17 [Worker_1] Worker_1 started
Jul-21-16 13:11:19 [Worker_2] Worker_2 started
Jul-21-16 13:11:20 [Worker_3] Worker_3 started
Jul-21-16 13:11:21 [Worker_4] Worker_4 started
Jul-21-16 13:11:22 [Worker_5] Worker_5 started
Jul-21-16 13:11:22 [init] Starting rebuild SpamDB worker thread [10001] -
ThreadCycleTime is set to 30 microseconds
Jul-21-16 13:11:23 [Worker_10001] Worker_10001 started
Jul-21-16 13:11:23 [Worker_10001] Info: found module
/usr/share/assp/lib/rebuildspamdb.pm version 7.33
Jul-21-16 13:11:24 [init] All Threads are started
Jul-21-16 13:11:24 [init] Try using BerkeleyDB database <> for selected
tables
Jul-21-16 13:11:25 [init] Info: list Whitelist is using 'BerkeleyDB'
version 5.3 - cachesize is 48.0kB
Jul-21-16 13:11:25 [init] Using BerkeleyDB Database
/usr/share/assp/database/whitelist.bdb instead of file
/usr/share/assp/database/whitelist
Jul-21-16 13:11:25 [init] Info: list PersBlack is using 'BerkeleyDB'
version 5.3 - cachesize is 48.0kB
Jul-21-16 13:11:25 [init] Using BerkeleyDB Database
/usr/share/assp/database/persblack.bdb instead of file
/usr/share/assp/database/persblack
Jul-21-16 13:11:25 [init] Info: list Redlist is using 'BerkeleyDB' version
5.3 - cachesize is 48.0kB
Jul-21-16 13:11:25 [init] Using BerkeleyDB Database
/usr/share/assp/database/redlist.bdb instead of file
/usr/share/assp/database/redlist
Jul-21-16 13:11:25 [init] Info: list Delay is using 'BerkeleyDB' version
5.3 - cachesize is 48.0kB
Jul-21-16 13:11:25 [init] Using BerkeleyDB Database
/usr/share/assp/database/delaydb.bdb instead of file
/usr/share/assp/database/delaydb
Jul-21-16 13:11:25 [init] Info: list DelayWhite is using 'BerkeleyDB'
version 5.3 - cachesize is 48.0kB
Jul-21-16 13:11:25 [init] Using BerkeleyDB Database
/usr/share/assp/database/delaydb.white.bdb instead of file
/usr/share/assp/database/delaydb.white
Jul-21-16 13:11:25 [init] Info: list Spamdb is using 'BerkeleyDB' version
5.3 - cachesize is 48.0kB
Jul-21-16 13:11:25 [init] Using BerkeleyDB Database
/usr/share/assp/database/spamdb.bdb instead of file
/usr/share/assp/database/spamdb
Jul-21-16 13:11:25 [init] Info: list HeloBlack is using 'BerkeleyDB'
version 5.3 - cachesize is 48.0kB
Jul-21-16 13:11:25 [init] Using BerkeleyDB Database
/usr/share/assp/database/spamdb.helo.bdb instead of file
/usr/share/assp/database/spamdb.helo
Jul-21-16 13:11:25 [init] Info: list HMMdb is using 'BerkeleyDB' version
5.3 - cachesize is 48.0kB
Jul-21-16 13:11:25 [init] Using BerkeleyDB Database
/usr/share/assp/database/HMMdb.bdb instead of file
/usr/share/assp/database/HMMdb
Jul-21-16 13:11:25 [init] Info: list LDAPlist is using 'BerkeleyDB'
version 5.3 - cachesize is 48.0kB
Jul-21-16 13:11:25 [init] Using BerkeleyDB Database
/usr/share/assp/database/ldaplist.bdb instead of file
/usr/share/assp/database/ldaplist
Jul-21-16 13:11:25 [init] Warning: Bayesian spam database has only 0
records
Jul-21-16 13:11:25 [init] Warning: whitelist has only 6 records: (ignore
if this is a new install)
Jul-21-16 13:11:25 [init] Info: saving Stats in file asspstats.sav
Jul-21-16 13:11:25 [init] Info: saving ScoreStats in file
asspscorestats.sav
Jul-21-16 13:11:25 [init] Listening for SMTP connections on 0.0.0.0:25
Jul-21-16 13:11:25 [init] Listening for admin HTTP connections on
0.0.0.0:55555
Jul-21-16 13:11:25 [init] Listening for stat HTTP connections on
0.0.0.0:55553
Jul-21-16 13:11:25 [init] Info: system TCP-socket receive buffer is 87380
byte
Jul-21-16 13:11:25 [init] Info: system TCP-socket send buffer is 16384
byte
Jul-21-16 13:11:25 [init] Info: SSL-layer receive buffer is 16384 byte
Jul-21-16 13:11:25 [init] Info: SSL-layer send buffer is 16384 byte
Jul-21-16 13:11:25 [init] Current PID: 5767
Jul-21-16 13:11:25 [init] Info: command queue released
Jul-21-16 13:11:25 [init] Switched effective gid to 999 (assp)
Jul-21-16 13:11:25 [init] Switched real gid to 999 (assp)
Jul-21-16 13:11:25 [init] Switched effective uid to 999 (assp)
Jul-21-16 13:11:25 [init] Switched real uid to 999 (assp)
Jul-21-16 13:11:25 [init] Info: central signalhandler - WINCH(28) -
RTMAX(64) - BUS(7) - ILL(4) - NUM39(39) - NUM61(61) - VTALRM(26) -
NUM48(48) - NUM62(62) - URG(23) - NUM56(56) - FPE(8) - TRAP(5) - TTIN(21)
- NUM57(57) - NUM53(53) - XFSZ(25) - STOP(19) - NUM51(51) - NUM50(50) -
NUM54(54) - TSTP(20) - NUM38(38) - NUM35(35) - POLL(67) - IOT(65) -
TTOU(22) - XCPU(24) - NUM43(43) - NUM42(42) - IO(29) - NUM52(52) -
NUM58(58) - SEGV(11) - RTMIN(34) - UNUSED(68) - NUM41(41) - KILL(9) -
QUIT(3) - NUM49(49) - NUM33(33) - NUM45(45) - NUM44(44) - STKFLT(16) -
NUM36(36) - NUM59(59) - PROF(27) - NUM32(32) - NUM46(46) - PWR(30) -
NUM63(63) - NUM55(55) - SYS(31) - NUM60(60) - NUM47(47) - CONT(18) -
NUM40(40) - NUM37(37) - ABRT(6) - PIPE(13) - USR1(10) - USR2(12) - INT(2)
- HUP(1) - TERM(15) - CHLD(17) - CLD(66) - ALRM(14) - installed
Jul-21-16 13:11:25 [Main_Thread] MainThread started

The module error is about Mail::SPF::Query and ClamScan. Those are not
relevant in this issue; this is a test setup to figure out how to migrate
from BerkeleyDB to MySQL; both issues do not exist in the production
machine. Same goes for the amount of CPU cores and DNS.


I hope someone can tell me what I'm doing wrong, I've been at this for the
better part of two days and I'm really stuck. I can't find any pointers in
the logfile.

Thanks!

Martin
------------------------------------------------------------------------------
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are
consuming the most bandwidth. Provides multi-vendor support for NetFlow,
J-Flow, sFlow and other flows. Make informed decisions using capacity planning
reports.http://sdm.link/zohodev2dev
_______________________________________________
Assp-user mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/assp-user