Hi all, I have two machines running ASSP (1.3.3.8 and 1.3.5) on Debian Etch. Both have 4 IPs and I use the "SMTP Destination Routing Table" to direct incoming mail to the mailservers in charge. Thus no mailboxes on the ASSP machines. I want the ASSPs to share a Mysql database. Database setup worked fine, the tables were created. Now the whitelist table gets filled as it should be, but redlist and delaydb and delaywhitedb are never touched. The spamdb is also filled. Funny enough: even when I switch back to local files instead of Mysql the local files are not created. I tried ASSP 1.3.3.1 through 1.3.5 with the same result. It is probably not about permissions. (If one mysql table can be accessed, the other ones should work too. If spamdb in the ASSP directory can be written, then the same goes for the other files.) I earlier tried ASSP running on the same machine as the mailserver and delaying worked in that case.
I am obviously missing something very basic, but I have no more ideas where to look. Can someone give me a shopping list of all prerequisites I should check? Here is the info logged during a restart of ASSP: Nov 13 19:56:15 sirius assp[13420]: Sig TERM Nov 13 19:56:15 sirius assp[13420]: Saving penalty records Nov 13 19:56:15 sirius assp[13420]: Saving cache records Nov 13 19:56:24 sirius assp[13722]: Option list file '/opt/assp/noProcessing.list' reloaded (noProcessing) Nov 13 19:56:24 sirius assp[13722]: Option list file '/opt/assp/files/nodelay.txt' reloaded (noDelay) Nov 13 19:56:25 sirius assp[13722]: Option list file '/opt/assp/files/URIBLCCTLDS.txt' reloaded (URIBLCCTLDS) Nov 13 19:56:25 sirius assp[13724]: ASSP version 1.3.3.8() (Perl 5.008008) initializing Nov 13 19:56:25 sirius assp[13724]: ASSP running on server: sirius Nov 13 19:56:26 sirius assp[13724]: Net::LDAP module version 0.34 installed and available Nov 13 19:56:26 sirius assp[13724]: Net::DNS module version 0.61 installed and available Nov 13 19:56:26 sirius assp[13724]: Email::Valid module version 0.179 installed and available Nov 13 19:56:26 sirius assp[13724]: Mail::SPF::Query module version 1.999001 installed and available Nov 13 19:56:27 sirius assp[13724]: Mail::SRS module version 0.31 installed - Sender Rewriting Scheme available Nov 13 19:56:27 sirius assp[13724]: Compress::Zlib module version 2.007 installed - HTTP compression available Nov 13 19:56:27 sirius assp[13724]: Digest::MD5 module version 2.36 installed - delaying will use MD5 keys for hashes Nov 13 19:56:27 sirius assp[13724]: File::ReadBackwards module version 1.04 installed - searching of log files enabled Nov 13 19:56:28 sirius assp[13724]: Time::HiRes module version 1.9708 installed - CPU usage statistics available Nov 13 19:56:28 sirius assp[13724]: Sys::Syslog module version 0.21 installed - Unix centralized logging enabled Nov 13 19:56:28 sirius assp[13724]: Net::Syslog module not installed. Nov 13 19:56:28 sirius assp[13724]: Tie::RDBM module version 0.70 installed - mysql usage available Nov 13 19:56:29 sirius assp[13724]: LWP::Simple module version 1.41 installed - procedural LWP interface available Nov 13 19:56:29 sirius assp[13724]: Listening for mail connections at 25 and admin connections at 55555 Nov 13 19:56:29 sirius assp[13724]: Switched effective gid to 65534 (nogroup) Nov 13 19:56:29 sirius assp[13724]: Switched real gid to 65534 (nogroup) Nov 13 19:56:30 sirius assp[13724]: Switched effective uid to 65534 (nobody) Nov 13 19:56:30 sirius assp[13724]: Switched real uid to 65534 (nobody) Nov 13 19:56:30 sirius assp[13724]: Starting PID: 13724 And some settings from assp.cfg: CleanDelayDBInterval:=3600 DelayAddHeader:=1 DelayEmbargoTime:=5 DelayError:=451 4.7.1 Please try again later DelayExpireOnSpam:=1 DelayExpiryTime:=36 DelayLog:=1 DelayNormalizeVERPs:=1 DelaySL:= DelayUseNetblocks:=1 DelayWL:= DelayWaitTime:=28 EnableDelaying:=1 delaySpamLovers:= delaydb:=mysql A little sidenote: I found that when I install module Net::Syslog then Sys::Syslog does not work. Can anybody confirm that? Regards and TIA for your help Dirk ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Assp-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/assp-user
