[EMAIL PROTECTED] wrote: > The continuing saga of trying to get MySQLUIDInSignature to work. No go. > It's like Dspam just totally ignores the user id in the signature. 2 is > the correct user id. > [...] > Maillog (OpenBSD 4.1) > > Dec 10 09:39:42 mail1 dspam[1724]: query error: Column 'uid' cannot be null: > see sql.errors for more details
Have you tried to follow the advice to check sql.errors? > Dec 10 09:39:42 mail1 dspam[1724]: process_message returned error -2. > delivering. > Dec 10 09:39:47 mail1 postfix/smtpd[16540]: connect from localhost[127.0.0.1] > Dec 10 09:39:48 mail1 postfix/smtpd[16540]: 56DEE1FC6A4: > client=localhost[127.0.0.1] > Dec 10 09:39:48 mail1 postfix/cleanup[22357]: 56DEE1FC6A4: > message-id=<[EMAIL PROTECTED]> > Dec 10 09:39:48 mail1 postfix/qmgr[10091]: 56DEE1FC6A4: > from=<[EMAIL PROTECTED]>, size=805, nrcpt=1 (queue active) > Dec 10 09:39:48 mail1 postfix/smtpd[16540]: disconnect from > localhost[127.0.0.1] > Dec 10 09:39:48 mail1 postfix/lmtp[27911]: 98AD01FC6A3: > to=<[EMAIL PROTECTED]>, > relay=mail1.ameripeds.com[/tmp/dspam.sock], delay=6.9, > delays=0.64/0/0/6.3, dsn=2.6.0, status=sent (250 2.6.0 > <[EMAIL PROTECTED]> Message accepted for delivery) > Dec 10 09:39:48 mail1 postfix/qmgr[10091]: 98AD01FC6A3: removed > Dec 10 09:39:51 mail1 dspam[25864]: Unable to open file for writing: > /var/dspam/data/[EMAIL PROTECTED]/[EMAIL PROTECTED]: > Permission denied > Dec 10 09:39:51 mail1 postfix/local[30621]: 56DEE1FC6A4: > to=<[EMAIL PROTECTED]>, relay=local, delay=3.4, > delays=0.61/0.09/0/2.7, dsn=2.0.0, status=sent (delivered to command: > /usr/local/bin/dspam --user globaluser --class=innocent > --source=error) First of all, I've never used postfix, so I may be wrong, but these log messages suggest to me that postfix delivers the message twice, once using the train-ham transport and once again using the normal spamcheck transport. Just an idea. > > I'm pretty sure I read that dspam is being run as nobody when called > through a Postfix alias. nobody is a trusted user for dspam. Well, you had better make sure then. Actually, I'm not quite sure you really want to run this command as nobody even if this is a trusted user according to dspam.conf. After all, the user calling dspam has to have read access to dspam.conf and read/write access to /var/dspam/data. The log messages above suggest that you have trouble with your permissions. [...] > Global user is a merged group in /var/dspam/group: > > globaluser:merged:* I suppose you have made sure that globaluser has a separate uid in your mysql database. Hope that helps, Elias
