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
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
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
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
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.
---
This SF.net email is sponsored by: Perforce Software.
Perforce is the Fas
The ISP I work for is currently using SA site-wide with flat config files
and no user config files. There are three boxes running SA that are
connected to by the SMTP host, and we scp the configs between the three
machines. The users have home directories on the SMTP box, but no shell
access. They
>List: spamassassin-talk
>Subject: [SAtalk] SQL prefs, virtual users, and Bayes/AWL etc
From: Noah Meyerhans
>Date: 2003-10-28 15:13:03
>[Download message RAW]
>
>Hi all. I posted this to -devel as well, but figure I'll reach a wider
>audience if I post it here, too. Apol
Hi all. I posted this to -devel as well, but figure I'll reach a wider
audience if I post it here, too. Apologies to those of you who might
recieve it twice.
I'm trying to determine if there's a way to use SQL user prefs (which
makes writing a web-based config tool easier) along with per *virtua
Hello,
Trying to use SA2.55 and MySQL3.x user prefs with Qmail,
qmail-scanner, vpopmail3.5.27 and squirrelmail 1.4.1.
I have edited the conf.cf file according to the SA documents. Ran spamd in
debug and I cannot get SA to look in or use the SQL database. I have been
hunting on google to n
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
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
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,
>
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
I am trying to get my spamassassin install to use the SQL database for user prefs.
I have in /etc/mail/spamassassin/local.cf
user_scores_dsnDBI:mysql:spamassassin:localhost
user_scores_sql_username spam
user_scores_sql_password spam
user_scores_sql_table userpref
I then have spamd starting w
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
Finally, I wanted to try user_prefs via MySQL db. I followed the README in
the sql subdir, I assured that the db/table is there and accessable by the
user, I added user_scores_dsn etc. to the local.cf, I reloaded spamd.
There's no indication that it's getting used. I reread everything,
includin
I've been looking at a bunch of files to determine
where and why SA either uses or does not use
a particular user pref from the database.
my intention is to purposely increase the score
of an existing rule, for example, if the username
of the email address USERNAME_IN_ADDRESS
rule is triggered I w
Hi,
First of all I would like to know which user preferences can be configured
in the database ?
Are these the local scores, whitelist_from required_hits and
auto_report_threshhold ? And what about the auto_whitelist for example and
blacklists ?
I'm trying to use spamassassin's sql features for r
when using the -q flag, are there any options besides the ones listed
below that you can use? or is there plans to added additional support?
* whitelist_from
* blacklist_from
* required_hits
* rewrite_subject
* report_header
* defang_mime
* terse_report
like ?
whitelist_from_rcvd
unwhitelist_fro
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.
--
Dark Alchemist" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, November 22, 2002 2:56 PM
> Subject: Re: [SAtalk] SQL and SA.
>
>
> > I was able to finally get this to work and thats a major victory over
> > here.
> >
> > Now, I w
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
> 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
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
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
> >
> > 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
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
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 the database then a gl
Title: Sql question
When using an SQL database to store user preferences, once SA queries a particular user, does it cache their preferences or is a query done for every message? I'm looking at doing this sitewide and I'm wondering how well this performs.
Thanks,
Eric
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
Is there any way to use auto whitelists with an sql database instead of dbm?
Thanks,
Jeff
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.404 / Virus Database: 228 - Release Date: 10/15/2002
---
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
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 msg to it, I see
nothing in the spamd debug output about contacting the db.
the db, and tables are
I'm trying to set individual scores for rules via SQL and spamc, but they
don't take effect. Is it possible to do this?
For example:
in my SQL DB I have:
myusernamerequired_hits6
and that takes effect. But adding
myusernameWEB_BUGS2
doesn't override the web-bugs
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
Hi
Is it possible to local system wide whitelist and blacklist enteries from an
SQL database rather then from the config files in the spamassassin
directory.
This would make it easier for remote updates as I would not have to edit the
file.
Cheers
Andrew
36 matches
Mail list logo
