About uid-with-sql etc. WAS RE: spamassassin works, spamc / d doesn't? I have it working on other servers...

["Mitch (WebCob)" <mi...@webcob.com>]

Ok - figured it out - silly DB problem - I figured a non-demonized spamd
would report an error - found it later in the logs.

Do have  a couple other questions related to this way of working though:


Here is a typical message process (USER@DOMAIN has been substituted to
protect the innocent ;-)

Jan 19 23:38:18 slim1 spamd[65836]: got connection over
/var/run/spamassassin.sock
Jan 19 23:38:18 slim1 spamd[65836]: handle_user: unable to find user '
USER@DOMAIN'!
Jan 19 23:38:18 slim1 spamd[65836]: Still running as root: user not
specified with -u, not found, or set to root.  Fall back to nobody.
Jan 19 23:38:18 slim1 spamd[65836]: processing message
<20...@ulsmlbx02> for USER@DOMAIN:65534.
Jan 19 23:38:19 slim1 spamd[65836]: clean message (1.8/5.0) for
USER@DOMAIN:65534 in 1.0 seconds, 15461 bytes.
Jan 19 23:38:19 slim1 spamd[65836]: result: .  1 -
HTML_50_60,HTML_MESSAGE,HTML_TITLE_UNTITLED,MIME_HTML_ONLY,URI_OFFERS
scantime=1.0,size=15461,mid=<20...@ulsmlbx02>,autolearn
=no

USER@DOMAIN is the email address, and is reflected in my users table, and my
custom query works. so why can't it find my users?

Does uid-with-sql have something to do with it? Nothing on google.

Even specifying -username=nobody doesn't seem to force it to use a regular
user without these warnings - I don't see anything documenting a way to make
a query with extra fields - like UID. where is the information documented?

Thanks.

________________________________________
From: Mitch (WebCob) [mailto:mitch@webcob.com] 
Sent: January 19, 2005 11:53 AM
To: users@spamassassin.apache.org
Subject: spamassassin works, spamc / d doesn't? I have it working on other
servers...

Can't see what I'm doing wrong.

I ran spamd like:
spamd -x -d -r /var/run/spamassassin.pid
--socketpath=/var/run/spamassassin.sock --sql-config
OR
spamd -d -r /var/run/spamassassin.pid
--socketpath=/var/run/spamassassin.sock --sql-config

spamc -x -c -U /var/run/spamassassin.sock -u sysop
</root/.cpan/build/Mail-SpamAssassin-3.0.2/sample-spam.txt
give me :
0/0

Running spamassassin works normally!?!?!?

I've done this before on 3.01 and it worked. (different server) - can't see
any difference - what have I overlooked?

Thanks!

m/