On Wed, 11 May 2011 10:21:19 -0700 (PDT) Colin Brace <[email protected]> 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 > [email protected] --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 [email protected] > 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 [email protected] > 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/[email protected] as > path > 49593: [05/11/2011 18:39:46] using /var/db/dspam/opt-out/[email protected] > 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: [email protected] > 49593: [05/11/2011 18:39:46] _mysql_drv_getpwnam returning cached name > [email protected]. > 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 > [email protected]. > 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 [email protected] 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 [email protected] https://lists.sourceforge.net/lists/listinfo/dspam-user
