On Mon, 18 Jul 2011 22:59:10 +0800 Peter Santiago <[email protected]> wrote:
> Hello Stevan, > Hello Peter, you know that this list is not my own list? So if you want to address me directly then write to me a mail and not the list. But don't bother me with DSPAM stuff (if you can) because the list is for that. Anyway.... > 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='[email protected]'' at line 1: SELECT FROM > dspam_virtual_uids WHERE username='[email protected]' > There is nothing after SELECT. Usually 'uid' should be there. > 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' > That is strange. We never query IgnoreHeader from the storage backend. NEVER! > [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='[email protected]'' at line 1: SELECT FROM > dspam_virtual_uids WHERE username='[email protected]' > Well... this one is not okay. There is nothing after SELECT and it should be something there. Looks to me like your compiler has issues with static functions. Can this be? > [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='[email protected]'' at line 1: SELECT FROM > dspam_virtual_uids WHERE username='[email protected]' > Same here as above. After SELECT there should be either '' > > 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' > This is wrong. Never do we query the storage backend for IgnoreHeader. NEVER! > 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??? > Yes: - Compiler - Compiler flags/options > > -- > Peter Santiago [email protected] > My website: www.psinergybbs.com > My spamtrap address: [email protected] > ------------------------------------------------------------------------------ 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 [email protected] https://lists.sourceforge.net/lists/listinfo/dspam-user
