On Thu, 05 May 2011 18:56:34 -0400 Jason Boxman <jas...@edseek.com> wrote:
Hello Jason, > Using the current latest git (29261fb31ec3aca0...), I get the following > when using the libsqlite3_drv: (It works fine with the libpgsql driver.) > > dspam: tpp.c:63: __pthread_tpp_change_priority: Assertion `new_prio == > -1 || (new_prio >= __sched_fifo_min_prio && new_prio <= > __sched_fifo_max_prio)' failed. > let me quess: You use DSPAM in daemon mode with SQLite3. Can this be? If this is the case then allow me to point you to the excellent README that is included in DSPAM. Especially section "0. PREREQUISITES". There you see that SQLite2/3 is NOT thread safe. If thread safety is important for you and you want to use the SQLite v2/v3 driver then you need to modify the DSPAM storage driver for SQLite v2/v3 and add thread safety to it. If you do that then don't forget to submit a patch to our SourceForge bug tracker. > Configuration is essentially stock: > > ClientHost /var/spool/dspam/dspam.sock > ClientIdent blah@blah > > HashRecMax 98317 > > HashAutoExtend on > > HashMaxExtents 0 > > HashExtentSize 49157 > > HashPctIncrease 10 > > HashMaxSeek 10 > > HashConnectionCache 10 > > MySQLServer /var/run/mysqld/mysqld.sock > #MySQLPort 3306 > MySQLUser _DBC_DBUSER_ > MySQLPass _DBC_DBPASS_ > MySQLDb _DBC_DBNAME_ > MySQLCompress true > MySQLReconnect true > > PgSQLServer 127.0.0.1 > PgSQLPort 5432 > PgSQLUser _DBC_DBUSER_ > PgSQLPass _DBC_DBPASS_ > PgSQLDb _DBC_DBNAME_ > > Home /var/spool/dspam > > StorageDriver /usr/local/lib/dspam/libsqlite3_drv.so > > TrustedDeliveryAgent "/usr/sbin/exim4 -oi -oMr despammed" > > #QuarantineAgent "/usr/bin/procmail -d spam" > > OnFail error > > Trust root > Trust dspam > Trust mail > Trust mailnull > Trust smmsp > Trust daemon > Trust Debian-exim > > TrainingMode teft > TestConditionalTraining on > #Feature chained > Feature whitelist > > Algorithm graham burton > PValue graham > > #SupressWebStats on > #ImprobabilityDrive on > > Preference "spamAction=tag" > Preference "signatureLocation=message" > Preference "showFactors=on" > > AllowOverride trainingMode > AllowOverride spamAction spamSubject > AllowOverride statisticalSedation > AllowOverride enableBNR > AllowOverride enableWhitelist > AllowOverride signatureLocation > AllowOverride showFactors > AllowOverride optIn optOut > AllowOverride whitelistThreshold > > #SQLitePragma "synchronous = OFF" > > #IgnoreHeader X-Spam-Status > #IgnoreHeader X-Spam-Scanned > #IgnoreHeader X-Virus-Scanner-Result > > PurgeSignatures 14 # Stale signatures > PurgeNeutral 90 # Tokens with neutralish probabilities > PurgeUnused 90 # Unused tokens > PurgeHapaxes 30 # Tokens with less than 5 hits (hapaxes) > PurgeHits1S 15 # Tokens with only 1 spam hit > PurgeHits1I 15 # Tokens with only 1 innocent hit > > # > # Purge configuration for SQL-based installations using purge.sql > # > #PurgeSignature off # Specified in purge.sql > #PurgeNeutral 90 > #PurgeUnused off # Specified in purge.sql > #PurgeHapaxes off # Specified in purge.sql > #PurgeHits1S off # Specified in purge.sql > #PurgeHits1I off # Specified in purge.sql > > LocalMX 127.0.0.1 > > SystemLog on > UserLog on > > Opt in > > ServerMode dspam > > ServerPass.blah "blah" > > ServerDomainSocketPath "/var/spool/dspam/dspam.sock" > > ProcessorBias on > > #SQLitePragma "synchronous = OFF" > > -- > > Thursday next week is indeed time for a thorough insight > into the swirling red debian vortex. — leeta > > -- Kind Regards from Switzerland, Stevan Bajić ------------------------------------------------------------------------------ WhatsUp Gold - Download Free Network Management Software The most intuitive, comprehensive, and cost-effective network management toolset available today. Delivers lowest initial acquisition cost and overall TCO of any competing solution. http://p.sf.net/sfu/whatsupgold-sd _______________________________________________ Dspam-user mailing list Dspam-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspam-user
