On Wed, 11 May 2011 10:21:19 -0700 (PDT) Colin Brace <c...@lim.nl> wrote:
> Hi Stevan, > Hello Colin, > Sorry for the FreeBSD-specific stuff. I am running dspam v3.9.0 > > I have been able to get dspam.debug output partly working again. > > At the moment, dspam appears to be properly scanning incoming mails (the > header with signature is there). > > However, if I run dspam from the command line to reclassify a mail, I see > the following in dspam.debug: > > 49593: [05/11/2011 18:39:46] DSPAM Instance Startup > 49593: [05/11/2011 18:39:46] input args: /usr/local/bin/dspam --user > c...@lim.nl --class=spam --source=error --signature=4dcaba64494849251411990 > 49593: [05/11/2011 18:39:46] pass-thru args: > 49593: [05/11/2011 18:39:46] processing user c...@lim.nl > 49593: [05/11/2011 18:39:46] uid = 80, euid = 0, gid = 80, egid = 80 > 49593: [05/11/2011 18:39:46] loading preferences for user c...@lim.nl > 49593: [05/11/2011 18:39:46] default preferences empty. reverting to > dspam.conf preferences. > 49593: [05/11/2011 18:39:46] Loading preferences from dspam.conf > 49593: [05/11/2011 18:39:46] using /var/db/dspam/opt-in/c...@lim.nl.dspam as > path > 49593: [05/11/2011 18:39:46] using /var/db/dspam/opt-out/c...@lim.nl.nodspam > as path > 49593: [05/11/2011 18:39:46] sedation level set to: 0 > 49593: [05/11/2011 18:39:46] _mysql_drv_getpwnam: successful returning > struct for name: c...@lim.nl > 49593: [05/11/2011 18:39:46] _mysql_drv_getpwnam returning cached name > c...@lim.nl. > 49593: [05/11/2011 18:39:46] _ds_get_signature: mysql_fetch_row() failed > 49593: [05/11/2011 18:39:46] _mysql_drv_getpwnam returning cached name > c...@lim.nl. > 49593: [05/11/2011 18:39:46] DSPAM Instance Shutdown. Exit Code: 0 > > And indeed, as I mentioned above, there are no records in the signature > table, as I can see using phpMyAdmin. AFAICT, dspam is not writing > signatures to the db. > I just installed yesterday MySQL 5.5.12 on a test system and installed DSPAM GIT version to test if it is working correctly. I had no error at all. DSPAM is writing tokens and writing the signature data without issues. Are you able to use DSPAM GIT and retest? What version of MySQL are you using? Can you post what command you have used when you did your tests? Can you enable general_log in MySQL and set general_log_file and then rerun your test and post back the log file? > My config file is here: http://pastebin.ca/2056913 > Quickly looking at the config I don't see anything that explains why the signature data is not written. It could be a preference? Can you post the preference settings for the user c...@lim.nl and your default preference? > Thanks. > -- Kind Regards from Switzerland, Stevan Bajić ------------------------------------------------------------------------------ Achieve unprecedented app performance and reliability What every C/C++ and Fortran developer should know. Learn how Intel has extended the reach of its next-generation tools to help boost performance applications - inlcuding clusters. http://p.sf.net/sfu/intel-dev2devmay _______________________________________________ Dspam-user mailing list Dspam-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspam-user
