Re: [SAtalk] SQL

2003-09-01 Thread Jonas Pasche
Hi Ray, > Yes you are correct. sample-spam.txt is just a plain text file. Please use a real mail message for your tests, e.g. the sample-spam.txt from your SpamAssassin source tarball. > If i add the -u option for spamc, I still get the same display, no > indication of it quering SQL for prefere

Re: [SAtalk] SQL

2003-08-31 Thread Jonas Pasche
Hi Ray, > Here is what happens when i send data to spamc: > > [EMAIL PROTECTED] root]# cat sample-spam.txt | spamc This isn't the sample-spam.txt from the SpamAssassin source tarball, isn't it..? It would be nice if you can post it. These lines... > X-Mail-Format-Warning: Bad RFC2822 header fo

Re: [SAtalk] question about mysql sa with qs

2003-08-28 Thread Jonas Pasche
Hi Patrick, > I cannot get spamc to pass the proper owner to spamd so it can pull out the > proper userprefs out of the mysql db. This seems to be a simple bug in the newly introduced code in qmail-scanner. Edit sub-spamassassin.pl, and change: $cmdline_recip=~/^([EMAIL PROTECTED])$/; into:

Re: [SAtalk] SA+SQL called by Qmail-Scanner problems..

2003-08-28 Thread Jonas Pasche
Hi Steve, > I configured SA to use SQL for the whitelist/blacklist etc. It is called > via Qmail-Scanner, which runs as a user called "qmailq". The SQL lookups > are occuring, but SA keeps searching for the user "qmailq", not the user > that is having the e-mail delivered. Yes, that's right,

[SAtalk] Advanced usage of SQL prefs

2003-08-26 Thread Jonas Pasche
Hi folks, for the needs of one of my customers I have written a small patch for ConfSourceSQL.pm which basically adds two functionalities: 1) Alias address support (if $username is listed as an alias for "xyz" in a separate alias table, $username is set to "xyz"). This basically allows the