Perhaps it's some other problem. I've ditched the Ubuntu package and built my own binary from source.
dspam --version shows:
Configuration parameters: --prefix=/usr --includedir=/usr/include
--mandir=/usr/share/man --infodir=/usr/share/info
--with-logdir=/var/log/dspam/ --localstatedir=/var
--libexecdir=/usr/lib/dspam --with-dspam-home=/var/spool/dspam
--sysconfdir=/etc/dspam --with-delivery-agent=/usr/bin/procmail
--enable-daemon --with-mysql-includes=/usr/include/mysql
--with-storage-driver=mysql_drv --enable-debug --enable-clamav
When I receive an email, the dspam.debug log file shows
15968: [05/06/2008 14:18:57] checking trusted user list for root(0)
15968: [05/06/2008 14:18:57] No QuarantineAgent option found. Using standard
quarantine.
15968: [05/06/2008 14:18:57] No such feature 'chained'
15968: [05/06/2008 14:18:57] using database handle id 1
15968: [05/06/2008 14:18:57] handle locked
15968: [05/06/2008 14:18:57] DSPAM Instance Startup
15968: [05/06/2008 14:18:57] input args: dspam --deliver=innocent
15968: [05/06/2008 14:18:57] pass-thru args:
15968: [05/06/2008 14:18:57] processing user [EMAIL PROTECTED]
15968: [05/06/2008 14:18:57] uid = 0, euid = 0, gid = 0, egid = 8
15968: [05/06/2008 14:18:57] loading preferences for user
[EMAIL PROTECTED]
15968: [05/06/2008 14:18:57] default preferences empty. reverting to
dspam.conf preferences.
15968: [05/06/2008 14:18:57] Loading preferences from dspam.conf
15968: [05/06/2008 14:18:57] using
/var/spool/dspam/opt-in/[EMAIL PROTECTED] as path
15968: [05/06/2008 14:18:57] using
/var/spool/dspam/opt-out/[EMAIL PROTECTED] as path
15968: [05/06/2008 14:18:57] adding user to merged group dspam_merged_group
15968: [05/06/2008 14:18:57] sedation level set to: 0
15968: [05/06/2008 14:18:57] _mysql_drv_get_spamtotals: unable to
_mysql_drv_getpwnam([EMAIL PROTECTED])
15968: [05/06/2008 14:18:57] Connecting to 127.0.0.1:3310 for virus check
15968: [05/06/2008 14:18:57] Connection to 127.0.0.1:3310 failed: Connection
refused
15968: [05/06/2008 14:18:57] _ds_getall_spamrecords: unable to
_mysql_drv_getpwnam([EMAIL PROTECTED])
15968: [05/06/2008 14:18:57] _ds_getall_spamrecords() failed
15968: [05/06/2008 14:18:57] bailing on error -2
15968: [05/06/2008 14:18:57] total processing time: 0.00032s
15968: [05/06/2008 14:18:57] received invalid result (! DSR_ISSPAM ||
DSR_INNOCENT) : -2
15968: [05/06/2008 14:18:57] _mysql_drv_get_spamtotals: unable to
_mysql_drv_getpwnam([EMAIL PROTECTED])
15968: [05/06/2008 14:18:57] process_message returned error -2. delivering.
15968: [05/06/2008 14:18:57] delivering message
15968: [05/06/2008 14:18:57] Establishing connection to 127.0.0.1:10026
15968: [05/06/2008 14:18:57] Connection established
15968: [05/06/2008 14:18:57] DSPAM Instance Shutdown. Exit Code: 0
15968: [05/06/2008 14:18:57] checking trusted user list for root(0)
I've attached my dspam.conf - can anyone tell me where I'm going wrong? I
just want system users, not the full @domain.tld username.
Thanks,
Michael Blinn
On Tue, May 6, 2008 at 11:02 AM, Hugo Monteiro <[EMAIL PROTECTED]>
wrote:
Michael Blinn wrote:
I'm using the dspam 3.6.8 package from Ubuntu Hardy Heron, trying to
migrate from an FC6 box that ran 3.6.8 also. I've copied my dspam.conf over,
however the new Ubuntu server (using the mysql driver) is seeing the full
username, as in the case of virtual users or domain-scale. This is a box
where all accounts are system accounts. - How do I tell the server to only
use the username before the @ sign?
On my old server I was using StripRcptDomain on but that's not doing
the trick. In my mail.log I see "Table 'dspam.dspam_virtual_uids' doesn't
exist", and in the debug log I'm getting "unable to
_mysql_drv_getpwnam([EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>)"
Thanks,
Michael Blinn
--
Only morality in our actions can give beauty and dignity to our lives.
- Albert Einstein
!DSPAM:4820a263143426476314020!
dspam.conf
Description: Binary data
