> On 29 Jul 2019, at 6:48 pm, Thomas Eckardt <thomas.ecka...@thockar.com > <mailto:thomas.ecka...@thockar.com>> wrote: > > If you've changed 'spamdb' to 'DB:' you need to restart assp to activate the > setting. > > Under normal conditions it is impossible to get the warning > "please set the config parameter 'spamdb' to 'DB:' or 'HMMusesBDB' to 'On' - > unable to populate HMM" > if 'spamdb' is set to 'DB:' > > the related code looks like: > > if ($DoHMM) { > if ($main::spamdb eq 'DB:' or .... or....) { > run the code to populate HMM > } else { > > log( "please set the config parameter 'spamdb' to 'DB:' or > 'HMMusesBDB' to 'On' - unable to populate HMM"); > } > > > > Thomas > Thanks Thomas.
Restarted ASSP. Jul-29-19 20:10:18 [init] Using table <spamdb> in mysql Database <ASSP> instead of file /Applications/assp/spamdb Then ran RebuildSpamDB. Jul-29-19 21:16:42 [Worker_10001] 0 attachment/image entries processed Jul-29-19 21:16:42 [Worker_10001] Imported Files for HeloBlackList: 20,309 Jul-29-19 21:16:42 [Worker_10001] Imported Files for Bayes/HMM: 15,666 Jul-29-19 21:16:42 [Worker_10001] Finished in 1,232 seconds (16.48 files/s - 1.04 GByte) Jul-29-19 21:17:03 [Worker_10001] Start populating Spamdb with 1,300,662 records - Bayesian check is now disabled! Jul-29-19 21:17:03 [Worker_10001] Try to lock Spamdb database in 5 second(s) Jul-29-19 21:17:08 [Worker_10001] Database import started for table spamdb Jul-29-19 21:17:18 [Worker_10001] Trying Bulkimport for table spamdb Jul-29-19 21:17:18 [Worker_10001] Database: MySQL 5.7.26 Jul-29-19 21:17:18 [Worker_10001] Info: version 2.4.3(15119) of file /Applications/assp/assp_db_import.cfg is used for the import Jul-29-19 21:17:18 [Worker_10001] Error: Column count doesn't match value count at row 1 Jul-29-19 21:17:18 [Worker_10001] Error: Bulkimport for table spamdb canceled - doing normal import Jul-29-19 21:17:22 [Worker_10001] Added 1500 of 1300662 records (RBR) for table spamdb - finished in 866 sec Jul-29-19 21:17:22 [Worker_10001] Added 2000 of 1300662 records (RBR) for table spamdb - finished in 649 sec And then later I get: Jul-29-19 21:24:46 [Worker_10001] Successfully added 1300162 records in to table spamdb Jul-29-19 21:24:46 [Worker_10001] Finished populating Spamdb with 1,300,662 records - Bayesian check is now enabled! Jul-29-19 21:24:46 [Worker_10001] Bayesian Pairs: 1,300,662 now in list Jul-29-19 21:24:51 [Worker_10001] Generating consolidated Hidden-Markov-Model database from 10,063,612 record model Jul-29-19 21:26:23 [Worker_10001] HMM sequences: 4,826,293 now in list Jul-29-19 21:26:24 [Worker_10001] Generating Spamdb.helo records from 8,307 collected HELO's Jul-29-19 21:26:35 [Worker_10001] Cleaning old Spamdb.helo records Jul-29-19 21:26:35 [Worker_10001] Done - cleaning old Spamdb.helo records Jul-29-19 21:26:35 [Worker_10001] HELO Blacklist: 89 new, 1,892 now in list Jul-29-19 21:26:35 [Worker_10001] Try to lock HMM databases in 5 second(s) Jul-29-19 21:26:40 [Worker_10001] Start populating Hidden Markov Model. HMM-check is disabled for this time! Jul-29-19 21:26:40 [Worker_10001] Start populating Hidden Markov Model with 4,826,293 records! Jul-29-19 21:26:40 [Worker_10001] Database import started for table hmmdb Jul-29-19 21:26:40 [Worker_10001] Trying Bulkimport for table hmmdb Jul-29-19 21:26:40 [Worker_10001] Database: MySQL 5.7.26 Jul-29-19 21:26:40 [Worker_10001] Info: version 2.4.3(15119) of file /Applications/assp/assp_db_import.cfg is used for the import Jul-29-19 21:26:40 [Worker_10001] Error: Column count doesn't match value count at row 1 Jul-29-19 21:26:40 [Worker_10001] Error: Bulkimport for table hmmdb canceled - doing normal import Jul-29-19 21:26:41 [Worker_10001] Added 500 of 4826293 records (RBR) for table hmmdb - finished in 9651 sec Jul-29-19 21:26:41 [Worker_10001] Added 1000 of 4826293 records (RBR) for table hmmdb - finished in 4825 sec Is the column count something that needs to be fixed? Thanks, James.
_______________________________________________ Assp-test mailing list Assp-test@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/assp-test
