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 > 3.9.0 is latest stable release. > I have been able to get dspam.debug output partly working again. > Okay. > At the moment, dspam appears to be properly scanning incoming mails (the > header with signature is there). > Good. > 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 > The signature can not be found. > 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. > Then this must be something MySQL 5.5 related. You should have a sql.errors file in the DSPAM log directory or at least some errors on MySQL log. Can you please verify. btw: You know that DSPAM does not work properly with MySQL 5.5? > My config file is here: http://pastebin.ca/2056913 > > 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
