On 18/07/11 16:59, Peter Santiago wrote: > 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' >
This looks like you set MySQLVirtualUIDField to an empty string in dspam.conf, or something like that... > 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 Startup > 478: [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 > path > 478: [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: 5 > 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_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??? > > > > > ------------------------------------------------------------------------------ > 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 ------------------------------------------------------------------------------ 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
