> grayhat <gray...@gmx.net> wrote: > > ensure to run ASSP from console,
Good idea. No really change in the information provided, though: > 29-Dec-2014 07:34:00 [init] Warning: Spamdb contains 257279 records > (allocating at least 46.7MB) - it is highly recommended to use a database for > 'spamdb' > 29-Dec-2014 07:34:00 [init] Starting maintenance worker thread [10000] - > ThreadCycleTime is set to 3000 microseconds > 29-Dec-2014 07:34:01 [Worker_10000] Delaydb database error: TIEHASH: Can't > open dbi:mysql:database=assp;host=127.0.0.1, Can't connect to MySQL server on > '127.0.0.1' (61) at assp.pl line 8259 thread 1. > 29-Dec-2014 07:34:01 [Worker_10000] Worker_10000 started > 29-Dec-2014 07:34:01 [Worker_10000] Info: watching the running script > '/usr/local/assp/assp.pl' for changes > 29-Dec-2014 07:34:01 [init] Starting rebuild SpamDB worker thread [10001] - > ThreadCycleTime is set to 30 microseconds > 29-Dec-2014 07:34:02 [Worker_10001] Worker_10001 started > 29-Dec-2014 07:34:02 [init] Starting SMTP-worker-threads with ThreadCycleTime > set to 3000 microseconds > 29-Dec-2014 07:34:02 [init] Starting communication worker threads [1 to 7] > 29-Dec-2014 07:34:02 [Worker_10001] Info: found module > /usr/local/assp/lib/rebuildspamdb.pm version 3.13 > 29-Dec-2014 07:34:03 [Worker_1] Delaydb database error: TIEHASH: Can't open > dbi:mysql:database=assp;host=127.0.0.1, Can't connect to MySQL server on > '127.0.0.1' (61) at assp.pl line 8259 thread 3. > 29-Dec-2014 07:34:03 [Worker_1] Worker_1 started > 29-Dec-2014 07:34:05 [Worker_2] Delaydb database error: TIEHASH: Can't open > dbi:mysql:database=assp;host=127.0.0.1, Can't connect to MySQL server on > '127.0.0.1' (61) at assp.pl line 8259 thread 4. > > next, did you try enabling the MySQL logging (and increasing its level) to > check MySQL logs and try seeing if there's some MySQL side error ? Yes, but it showed nothing, as in no lines of logs at the time of the assp error. > Did you check if the DB and tables needed by ASSP have been correctly created I was expecting the tables to be created, but nothing happened inside the MySQL schema. I DID ensure that the schema had a user with ALL privileges and that the user/pw in assp’s set up was correct. > http://wiki.linuxservertech.com/index.php?action=artikel&cat=16&id=20&artlang=en No surprises in there. :-) > when "migrating” ...disabling SMTP so that ASSP will have all the time to > import data into the DB tables As you can see from the above log snippet, it doesn’t even get that far. It reverts to files instead of databases. :-( T. ------------------------------------------------------------------------------ Dive into the World of Parallel Programming! The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net _______________________________________________ Assp-test mailing list Assp-test@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/assp-test
