Hello Stevan, Using the latest GIT version, running dspam_stats...
Entries in sql.log[07/18/2011 21:44:22] 15975: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM dspam_virtual_uids WHERE username='peter.santi...@psinergybbs.com'' at line 1: SELECT FROM dspam_virtual_uids WHERE username='peter.santi...@psinergybbs.com'
I also have a retrain script which calls dspamc with the signature passed in via commandline argument --signature.
Entries in sql.log[07/18/2011 22:45:28] 478: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' FROM Ðè WHERE IgnoreHeader='dspam'' at line 1: SELECT 8 FROM Ðè WHERE IgnoreHeader='dspam' [07/18/2011 22:48:43] 547: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM dspam_virtual_uids WHERE username='peter.santi...@psinergybbs.com'' at line 1: SELECT FROM dspam_virtual_uids WHERE username='peter.santi...@psinergybbs.com' [07/18/2011 22:48:43] 547: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' FROM dspam_virtual_uids WHERE username='pet...@psinergybbs.com'' at line 1: SELECT FROM dspam_virtual_uids WHERE username='pet...@psinergybbs.com'
dspam debug output: 478: [07/18/2011 22:45:28] checking trusted user list for root(0)478: [07/18/2011 22:45:28] process mode: '--signature=2,4e2438a0159572027431529 --class=spam --source=error ' 478: [07/18/2011 22:45:28] No QuarantineAgent option found. Using standard quarantine.
478: [07/18/2011 22:45:28] using database handle id 4 478: [07/18/2011 22:45:28] handle locked 478: [07/18/2011 22:45:28] DSPAM Instance Startup478: [07/18/2011 22:45:28] input args: dspam --signature=2,4e2438a0159572027431529 --class=spam --source=error
478: [07/18/2011 22:45:28] pass-thru args: 478: [07/18/2011 22:45:28] processing user dspam 478: [07/18/2011 22:45:28] uid = 0, euid = 0, gid = 0, egid = 502 478: [07/18/2011 22:45:28] loading preferences for user dspam 478: [07/18/2011 22:45:28] Loading preference 'trainingMode' = 'TOE' 478: [07/18/2011 22:45:28] Loading preference 'trainingMode' = 'TEFT' 478: [07/18/2011 22:45:28] Loading preference 'spamAction' = 'tag' 478: [07/18/2011 22:45:28] Loading preference 'spamSubject' = '[SPAM]' 478: [07/18/2011 22:45:28] Loading preference 'enableBNR' = 'on' 478: [07/18/2011 22:45:28] Loading preference 'enableWhitelist' = 'on' 478: [07/18/2011 22:45:28] Loading preference 'statisticalSedation' = '5'478: [07/18/2011 22:45:28] Loading preference 'signatureLocation' = 'headers'
478: [07/18/2011 22:45:28] Loading preference 'whitelistThreshold' = '10' 478: [07/18/2011 22:45:28] Loading preference 'showFactors' = 'off' 478: [07/18/2011 22:45:28] loaded default preferences externally 478: [07/18/2011 22:45:28] using /var/dspam/opt-in/local/dspam.dspam as path478: [07/18/2011 22:45:28] using /var/dspam/opt-out/local/dspam.nodspam as path
478: [07/18/2011 22:45:28] sedation level set to: 5478: [07/18/2011 22:45:28] _mysql_drv_getpwnam: unable to run query: SELECT 8 FROM Ðè WHERE IgnoreHeader='dspam' 478: [07/18/2011 22:45:28] _mysql_drv_get_spamtotals: unable to _mysql_drv_getpwnam(dspam) 478: [07/18/2011 22:45:28] _ds_init_storage: unable to load totals. Using zero values. 478: [07/18/2011 22:45:28] _mysql_drv_getpwnam: unable to run query: SELECT 8 FROM Ðè WHERE IgnoreHeader='dspam' 478: [07/18/2011 22:45:28] _ds_get_signature: unable to _mysql_drv_getpwnam(dspam) 478: [07/18/2011 22:45:28] _mysql_drv_getpwnam: unable to run query: SELECT 8 FROM Ðè WHERE IgnoreHeader='dspam' 478: [07/18/2011 22:45:28] _mysql_drv_set_spamtotals: unable to _mysql_drv_getpwnam(dspam)
478: [07/18/2011 22:45:28] DSPAM Instance Shutdown. Exit Code: 0 Environment: Centos5.6 mysql Ver 14.12 Distrib 5.0.77 Any other info you need??? -- Peter Santiago pet...@psinergybbs.com My website: www.psinergybbs.com My spamtrap address: r349...@psinergybbs.com
smime.p7s
Description: S/MIME Cryptographic Signature
------------------------------------------------------------------------------ AppSumo Presents a FREE Video for the SourceForge Community by Eric Ries, the creator of the Lean Startup Methodology on "Lean Startup Secrets Revealed." This video shows you how to validate your ideas, optimize your ideas and identify your business strategy. http://p.sf.net/sfu/appsumosfdev2dev
_______________________________________________ Dspam-user mailing list Dspam-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspam-user
