I'll be using dspam for lots of domains. I'm just getting this setup and trying to send a simple test message through. I can't figure out why dspam is trying to write a UID with a NULL value when the .sql setup file says it is not to be NULL. What can I do to get this working? Have I missed something?
(I did have to change the .sql file to read 'engine=' instead of 'type=' but otherwise I've left it alone. # $Id: virtual_user_aliases.sql,v 1.2 2009/05/25 11:52:02 sbajic Exp $ create table dspam_virtual_uids ( uid int unsigned not null, username varchar(128) not null ) engine=MyISAM; create unique index id_virtual_uids_01 on dspam_virtual_uids(username); dspam-devel-3.10.1_1,1 Bayesian spam filter - development version mysql-client-5.5.22 Multithreaded SQL database (client) FreeBSD mta01 9.0-RELEASE FreeBSD 9.0-RELEASE #0: Tue Jan 3 07:46:30 UTC 2012 r...@farrell.cse.buffalo.edu:/usr/obj/usr/src/sys/GENERIC amd64 23387: [04/25/2012 19:49:38] checking trusted user list for root(0) 23387: [04/25/2012 19:49:39] No QuarantineAgent option found. Using standard quarantine. 23387: [04/25/2012 19:49:39] using database handle id 1 23387: [04/25/2012 19:49:39] handle locked 23387: [04/25/2012 19:49:39] DSPAM Instance Startup 23387: [04/25/2012 19:49:39] input args: dspam --deliver=innocent,spam 23387: [04/25/2012 19:49:39] pass-thru args: /usr/bin/procmail 23387: [04/25/2012 19:49:39] processing user spam-d...@balius.com 23387: [04/25/2012 19:49:39] uid = 0, euid = 0, gid = 0, egid = 0 23387: [04/25/2012 19:49:39] loading preferences for user spam-d...@balius.com 23387: [04/25/2012 19:49:39] _mysql_drv_getpwnam: returning NULL for query on name: spam-d...@balius.com 23387: [04/25/2012 19:49:39] _ds_pref_load: unable to _mysql_drv_getpwnam(spam-d...@balius.com) 23387: [04/25/2012 19:49:39] _mysql_drv_getpwnam: returning NULL for query on name: @balius.com 23387: [04/25/2012 19:49:39] _ds_pref_load: unable to _mysql_drv_getpwnam(@balius.com) 23387: [04/25/2012 19:49:39] Loading preferences for uid 0 23387: [04/25/2012 19:49:39] Loading preferences for uid 0 23387: [04/25/2012 19:49:39] default preferences empty. reverting to dspam.conf preferences. 23387: [04/25/2012 19:49:39] Loading preferences from dspam.conf 23387: [04/25/2012 19:49:39] using /var/db/dspam/opt-in/balius.com/spam-drop.dspam as path 23387: [04/25/2012 19:49:39] using /var/db/dspam/opt-out/balius.com/spam-drop.nodspam as path 23387: [04/25/2012 19:49:39] sedation level set to: 5 23387: [04/25/2012 19:49:39] _mysql_drv_getpwnam: setting, then returning passed name: spam-d...@balius.com 23387: [04/25/2012 19:49:39] _mysql_drv_setpwnam: verified_user is 1 23387: [04/25/2012 19:49:39] _mysql_drv_setpwnam: unable to run query: INSERT INTO dspam_virtual_uids (uid,username) VALUES (NULL,'spam-d...@balius.com') 23387: [04/25/2012 19:49:39] _mysql_drv_get_spamtotals: unable to _mysql_drv_getpwnam(spam-d...@balius.com) 23387: [04/25/2012 19:49:39] _ds_init_storage: unable to load totals. Using zero values. 23387: [04/25/2012 19:49:39] message is signed. retaining original text for reassembly 23387: [04/25/2012 19:49:39] _mysql_drv_getpwnam: setting, then returning passed name: spam-d...@balius.com 23387: [04/25/2012 19:49:39] _mysql_drv_setpwnam: verified_user is 1 23387: [04/25/2012 19:49:39] _mysql_drv_setpwnam: unable to run query: INSERT INTO dspam_virtual_uids (uid,username) VALUES (NULL,'spam-d...@balius.com') 23387: [04/25/2012 19:49:39] _ds_getall_spamrecords: unable to _mysql_drv_getpwnam(spam-d...@balius.com) 23387: [04/25/2012 19:49:39] _ds_getall_spamrecords() failed 23387: [04/25/2012 19:49:39] total processing time: 0.00256s 23387: [04/25/2012 19:49:39] _mysql_drv_getpwnam: setting, then returning passed name: spam-d...@balius.com 23387: [04/25/2012 19:49:39] _mysql_drv_setpwnam: verified_user is 1 23387: [04/25/2012 19:49:39] _mysql_drv_setpwnam: unable to run query: INSERT INTO dspam_virtual_uids (uid,username) VALUES (NULL,'spam-d...@balius.com') 23387: [04/25/2012 19:49:39] _mysql_drv_set_spamtotals: unable to _mysql_drv_getpwnam(spam-d...@balius.com) 23387: [04/25/2012 19:49:39] delivering message 23387: [04/25/2012 19:49:39] Establishing connection to 127.0.0.1:10025 23387: [04/25/2012 19:49:39] Connection established 23387: [04/25/2012 19:49:39] DSPAM Instance Shutdown. Exit Code: 0 23387: [04/25/2012 19:49:39] checking trusted user list for root(0) Thank you, Chad ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ Dspam-user mailing list Dspam-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspam-user
