Re: [SAtalk] SQL Integration

2004-01-10 Thread Carl R. Friend
On Sat, 10 Jan 2004, Andrew Cranson wrote: > See > http://www.mail-archive.com/[EMAIL PROTECTED]/msg03016.html > * http://nyx.ilk.com/qsspam/ > > There is a mention of a delete_mail_threshold. I have been trying to > implement that via mySQL but it doesn't appear to be doing anything. Is > the

Re: [SAtalk] SQL Integration

2004-01-10 Thread Andrew Cranson
Hi, See http://www.mail-archive.com/[EMAIL PROTECTED]/msg03016.html * http://nyx.ilk.com/qsspam/ There is a mention of a delete_mail_threshold. I have been trying to implement that via mySQL but it doesn't appear to be doing anything. Is there a component require that includes this function, or s

Re: [SAtalk] SQL Integration

2004-01-10 Thread Carl R. Friend
On Sat, 10 Jan 2004, Andrew Cranson wrote: > What per-user preferences are supported by the mysql integration? Just the > basics like required_hits and white/blacklisting, or is it possible to > support more? Thanks. The per-user configurability capabilities of the MySQL interface go well b

Re: [SAtalk] SQL Integration

2004-01-10 Thread Andrew Cranson
Hi, strange, it's ignoring pretty much anything else I ask it to do via mysql. Is there anything would override mysql preferences? Carl R. Friend said: >On Sat, 10 Jan 2004, Andrew Cranson wrote: > >> What per-user preferences are supported by the mysql integration? Just >> the >> basics like

Re: [SAtalk] SQL prefs, virtual users, and Bayes/AWL etc

2003-11-01 Thread Markus Feilner
Hello List, Hello Noah - first of all: sorry for the format of this mail, but i found it the following mail in the archive of this list, so I cut 'n pasted it here, for those who missed the first part. ;-) ---Noah wrote:--- >List: spamassass

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-09-01 Thread Carlo Wood
On Sun, Aug 31, 2003 at 11:11:18PM -0400, Ray Parish wrote: > Yes you are correct. sample-spam.txt is just a plain text file. > If i add the -u option for spamc, I still get the same display, no > indication of it quering SQL for preferences. You didn't answer his question. He asked: What happens

Re: [SAtalk] SQL

2003-09-01 Thread Ray Parish
ent: Sunday, August 31, 2003 4:25 PM Subject: Re: [SAtalk] SQL > 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, >

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] sql db not getting used

2003-06-10 Thread Kai Schaetzl
Rick Beebe wrote on Mon, 09 Jun 2003 15:54:44 -0400: > Are you running spamd with -q -x? > Ah, right to the point. It's in the init script, but commented out, because we weren't using a db until now. I read several documentation but forgot to reread the one for spamd, I thought putting those li

Re: [SAtalk] SQL and SA.

2002-11-22 Thread Dark Alchemist
Good I got this to work finally and the problem was username varchar(8) NOT NULL inside the file spamassassin.sql. Not many users only have 8 or less chars in their usernames so I set it to 30 and all works fine now (I think). Thanks all. --

Re: [SAtalk] SQL and SA.

2002-11-22 Thread Dark Alchemist
I was able to finally get this to work and thats a major victory over here. Now, I was also able to get the web interface to work but it never updates the sql db and its missing /users/spamfilter/index.php. The documentation on this interface is next to nil so I would love to know what you did to

Re: [SAtalk] SQL and SA.

2002-11-21 Thread Josh Trutwin
> What am I doing wrong as I have spent all day trying to get SA and MySQL > to work to no avail. > > local.cf > rewrite_subject 0 > defang_mime 0 > report_header 1 > use_terse_report 1 > user_scores_dsn DBI:mysql:spamassassin:localhost I had to also put these in: user_scores_sql

Re: [SAtalk] SQL Database of Scores

2002-11-07 Thread Michael Duff
MGI To: [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: [SAtalk] SQL Database of Scores Andrew Brooker wrote: >>>I am running a sitewide config of SpamAssassin with Sendmail + >> > MIMEDefang. > >>>I was wondering if it's possible to use a SQL database with

Re: [SAtalk] SQL Database of Scores

2002-11-06 Thread Dallas Engelken
Andrew Brooker wrote: I am running a sitewide config of SpamAssassin with Sendmail + MIMEDefang. I was wondering if it's possible to use a SQL database with this configuration? I was hoping to be able to pass the e-mail address to the SQL database, if the user's e-mail address is not in the d

Re: [SAtalk] SQL Database of Scores

2002-11-06 Thread Andrew Brooker
> > > > I am running a sitewide config of SpamAssassin with Sendmail + MIMEDefang. > > I was wondering if it's possible to use a SQL database with this > > configuration? > > I was hoping to be able to pass the e-mail address to the SQL database, > > if the user's e-mail address is not in the datab

Re: [SAtalk] SQL Database of Scores

2002-11-06 Thread Dallas Engelken
Andrew Brooker wrote: Hiya All, I am running a sitewide config of SpamAssassin with Sendmail + MIMEDefang. I was wondering if it's possible to use a SQL database with this configuration? I was hoping to be able to pass the e-mail address to the SQL database, if the user's e-mail address is not in

Re: [SAtalk] SQL and auto whitelists

2002-10-22 Thread Larry Rosenman
On Tue, 2002-10-22 at 16:53, Jeffrey Wheat wrote: > Is there any way to use auto whitelists with an sql database instead of dbm? there's a bug in Bugzilla about it (from 2.2 days), that Craig hasn't done yet. > > Thanks, > Jeff > > --- > Outgoing mail is certified Virus Free. > Checked by AVG a

Re: [SAtalk] SQL

2002-06-16 Thread Marc G. Fournier
are you running spamd with the -q -x options? On Sun, 16 Jun 2002, David B. Bitton wrote: > I followed the info in regards to setting up the SQL db lookup. I > uncommneted out the lines in /etc/spamassassin/10_misc.cf (i'm using debian) > that pertain to the db connection. When I send a test

Re: [SAtalk] SQL Options

2002-05-29 Thread Nathan Neulinger
Yep. Set the userid to "GLOBAL" in the db table. Works great for me. Only thing I'm loading from files is the db config info. -- Nathan On Tue, 2002-05-28 at 23:26, Andrew Stephen wrote: > Hi > > Is it possible to local system wide whitelist and blacklist enteries from an > SQL database rathe