Zitat von Benny Pedersen :
i came after using it this way for long time now that it could be
more optimized with bayes user id vars, currently it creates new ids
each time there is a new user, but it does not reuse old ids that is
not used anymore after sa-learn --username f...@example.org,
On Sat, 18 Jan 2020 13:31:10 +0100
Benny Pedersen wrote:
> i came after using it this way for long time now that it could be
> more optimized with bayes user id vars, currently it creates new ids
> each time there is a new user, but it does not reuse old ids that is
> not used anymore after sa-lea
i came after using it this way for long time now that it could be more
optimized with bayes user id vars, currently it creates new ids each
time there is a new user, but it does not reuse old ids that is not used
anymore after sa-learn --username f...@example.org, then that id is not
used an
Julian Kippels wrote:
Hi,
I am in the process of setting up a bayes-sql-database but I am unsure
of wether I want to set the bayes_sql_override_username option.
I would like to have per-user-bayes scores, so that scores from user A
will not interfere with messages sent to user B.
If I
Hi,
I am in the process of setting up a bayes-sql-database but I am unsure
of wether I want to set the bayes_sql_override_username option.
I would like to have per-user-bayes scores, so that scores from user A
will not interfere with messages sent to user B.
If I understand it correctly, no
It should, yes; the (simple) fix looks correct, though I haven't
actually cut/pasted the example GRANT statement from the readme to test.
On Wed, 2017-08-09 at 16:48 -0400, Kevin A. McGrail wrote:
> Jesse, did bz https://bz.apache.org/SpamAssassin/show_bug.cgi?id=7442
> completely resolve this i
Jesse, did bz https://bz.apache.org/SpamAssassin/show_bug.cgi?id=7442
completely resolve this issue?
On 6/22/2017 2:49 PM, Jesse Norell wrote:
Hello,
I'm working on converting a spam training script/setup which works with
bayes dbm files to support sql bayes, and came across an error in the
gr
Jesse,
Thanks for the report. For sure get this into Bugzilla once you get the
account setup.
Please make sure you include which version of MySQL you are running as well.
The Bayes SQL stuff hasn’t been updated in many many years, it might be that
MySQL changed the permissions for INSERT on
Hello,
I'm working on converting a spam training script/setup which works with
bayes dbm files to support sql bayes, and came across an error in the
grants in the README.bayes file at:
GRANT SELECT, DELETE, INSERT ON TABLE bayes_seen TO ;
I'm using the MySQL driver (maybe it matters), and UPDA
> -Original Message-
> From: Dave Warren [mailto:da...@hireahit.com]
> Sent: 23. oktober 2013 09:51
> To: users@spamassassin.apache.org
> Subject: Re: Shared bayes SQL between machines
>
> On 2013-10-22 07:52, Jonas Akrouh Larsen wrote:
> > Mmm well I'd l
On 2013-10-22 07:52, Jonas Akrouh Larsen wrote:
Mmm well I'd like to use it, but it's also the manual learning.
We use a web frontend which lists quarantined messages and both users and
myself do manual training from there (it just calls sa-learn)
How do you distribute load among your SpamAss
On 10/22/2013 05:21 PM, Jonas Akrouh Larsen wrote:
Interesting, my problem is timeouts as well, when the master sql
server is down, the other nodes slow down because they are waiting
for bayes to timeout, meaning they build of a mail queue because they
can't keep up (or well they become a lot slo
> sa-learn --dump magic
> 0.000 0 3 0 non-token data: bayes db version
> 0.000 0 12456296 0 non-token data: nspam
> 0.000 0 3362288 0 non-token data: nham
> 0.000 0 0 0 non-token data: ntoken
get on the master database. It's the
distributed autolearn that's problematic.
-Original Message-
From: John Hardin [mailto:jhar...@impsec.org]
Sent: 22. oktober 2013 16:50
To: SpamAssassin Users List
Subject: RE: Shared bayes SQL between machines
On Tue, 22 Oct 2013, Jonas
4, 2. sal
2300 København S
Office: 7020 0979
Direct: 3336 9974
Mobile: 5120 1096
Web: www.techbiz.dk
> -Original Message-
> From: John Hardin [mailto:jhar...@impsec.org]
> Sent: 22. oktober 2013 16:50
> To: SpamAssassin Users List
> Subject: RE: Shared bayes SQL between mac
On Tue, 22 Oct 2013, Jonas Akrouh Larsen wrote:
Use standard master-slave replication. Learn and expire only the master
database.
I *think* we support separate credentials for learning to a different database
than you scan from, but I don't follow the Bayes SQL interface too closely so
I&
rning to a different
database than you scan from, but I don't follow the Bayes SQL interface
too closely so I'm not sure.
--
John Hardin KA7OHZhttp://www.impsec.org/~jhardin/
jhar...@impsec.orgFALaholic #11174 pgpk -a jhar...@impsec.org
key: 0xB8732E79 -- 2D8C
On 10/22/2013 04:07 PM, Jonas Akrouh Larsen wrote:
Hi List
I tried a couple of years ago to have my bayes DB stored in SQL replicate as
MASTER-MASTER between 2 servers.
It worked fine for starters, but it often broke down because of irregularities,
something about duplicate data/keys if I rec
Hi List
I tried a couple of years ago to have my bayes DB stored in SQL replicate as
MASTER-MASTER between 2 servers.
It worked fine for starters, but it often broke down because of irregularities,
something about duplicate data/keys if I recall correctly.
As I would like 1 single shared bayes
so you're basically sharding the bayes_token tables... could you open
a bug on the SpamAssassin bugzilla with this patch? thanks!
--j.
Thorsten Meinl writes:
>--nextPart9059977.pG6Pp7397c
>Content-Type: multipart/mixed;
> boundary="Boundary-01=_oj8UJ9IS8rBJw6M"
>Content-Transfer-Encoding: 7bit
Hi all,
We have an installation of Spamassassin that serves about 2000 users. Their
Bayes-data is stored inside a Postgres database which is of fairly large
size, the bayes_token table holds about 100 million rows. This often leads to
high loads on the machine, especially if bayes_expire is run
On Nov 2, 2008, at 12:55 PM, Micah Anderson wrote:
I have spamd setup to use bayes in a mysql database, works fine. I've
turned off auto-expiry and instead run a cronjob to expire in the
middle
of the night (removes about 40k tokens on a run). I've made the DB
innoDB so it can handle lockin
I have spamd setup to use bayes in a mysql database, works fine. I've
turned off auto-expiry and instead run a cronjob to expire in the middle
of the night (removes about 40k tokens on a run). I've made the DB
innoDB so it can handle locking better. I've got mysql-based user prefs
coming from the
On Thu, Jan 25, 2007 at 05:20:27AM -0500, Tom Allison wrote:
> Bob McClure Jr wrote:
> >On Wed, Jan 24, 2007 at 09:01:58PM -0500, Tom Allison wrote:
> >>Am I correct in understanding that I have to run sa-learn for every user
> >>who is going to have a bayes token store?
> >
> >If you are running
Bob McClure Jr wrote:
On Wed, Jan 24, 2007 at 09:01:58PM -0500, Tom Allison wrote:
Am I correct in understanding that I have to run sa-learn for every user
who is going to have a bayes token store?
If you are running per-user Bayes (nothing else makes much sense,
IMHO), yes, but only if they w
On Wed, Jan 24, 2007 at 09:01:58PM -0500, Tom Allison wrote:
> Am I correct in understanding that I have to run sa-learn for every user
> who is going to have a bayes token store?
If you are running per-user Bayes (nothing else makes much sense,
IMHO), yes, but only if they want to train their Ba
Am I correct in understanding that I have to run sa-learn for every user who is
going to have a bayes token store?
On Wed, 2006-10-18 at 14:24 +0200, Henrik Hellerstedt wrote:
> I run spamassassin 3.1.5 from MailScanner on multiple machines
> and I plan to convert to the sql storage for bayes. I have
> already one machine running the sql storage, and i works very
> well.
>
> Before i convert the rest there is
I run spamassassin 3.1.5 from MailScanner on multiple machines
and I plan to convert to the sql storage for bayes. I have
already one machine running the sql storage, and i works very
well.
Before i convert the rest there is one question i fail to find
any answer to: Do every machine need its own
On Tue, August 29, 2006 19:05, John D. Hardin wrote:
> ...your fingers seem to be stuck in .ie
it was me that typed at a lowres fb device with scrampled chars
now i have highres radeonfb at 1600x1200 :-)
--
"This message was sent using 100% recycled spam mails."
On Tue, 29 Aug 2006, Benny Pedersen wrote:
> sa-laern --dump magic -u root
> sa-laern --dump magic -u vscan
> sa-laern --claen
...your fingers seem to be stuck in .ie
--
John Hardin KA7OHZICQ#15735746http://www.impsec.org/~jhardin/
[EMAIL PROTECTED]FALaholic #11174pgpk -a [EMA
On Tue, August 29, 2006 10:04, Anders Norrbring wrote:
> So, maybe I need to tell SA that "vscan" is authorized to use it, the
> question is how... Would I need to install and configure the AuthzUser
> plugin? Or some other?
no it bounded to the unix login name
su vscan
sa-learn --dump magic
exit
On Tue, August 29, 2006 09:45, Anders Norrbring wrote:
> Benny Pedersen skrev:
>> On Tue, August 29, 2006 08:16, Anders Norrbring wrote:
>>
>>> [6204] dbg: bayes: unable to initialize database for vscan user, aborting!
>>
>> from a new sql database this is default error, means that there is no data
Anders Norrbring skrev:
Anders Norrbring skrev:
Benny Pedersen skrev:
[..snip..]
After some more error-message-surfing on Google, it looks like it's SA
itself that doesn't allow any other username than root to use the Bayes
SQL plugin.
So, maybe I need to tell SA that
abase for vscan user, aborting!
[7997] dbg: bayes: not scoring message, returning undef
[7997] dbg: bayes: opportunistic call attempt failed, DB not readable
After some more error-message-surfing on Google, it looks like it's SA
itself that doesn't allow any other username than root to
Benny Pedersen skrev:
On Tue, August 29, 2006 08:16, Anders Norrbring wrote:
[6204] dbg: bayes: unable to initialize database for vscan user, aborting!
from a new sql database this is default error, means that there is no data to
work with so far
Well, there actually IS one post in the DB..
On Tue, August 29, 2006 08:16, Anders Norrbring wrote:
> [6204] dbg: bayes: unable to initialize database for vscan user, aborting!
from a new sql database this is default error, means that there is no data to
work with so far
> Shouldn't SA try to contact MySQL as "username" and not as "vscan"?
I run SA 3.1.4, amavis-new 2.4.2.
I have a small problem with SQL based Bayes, in my "amavisd debug-sa" I
see this all the time:
[6204] dbg: bayes: database connection established
[6204] dbg: bayes: found bayes db version 3
[6204] dbg: bayes: unable to initialize database for vscan user, abort
Michael,
Thanks for the help, but it didn't seem to make a difference. Though I have
noticed some strange things.. See steps taken and responses inline.
I have dropped the database completely, commented out the local.cf bayes_sql
and bayes_store settings, and performed an sa-learn --sync.
Ryan,
I just did this myself the first time in the last week;
Be sure that all your operations on the DB are done as the user who is going
to be accessing it; ie: Spamassassin spamuser etc.
Not knowing the history of your install;
In your Spamassassin local.cf file you should have these line
Interesting.. if I try to import my old Berkely DB it fails right out. If I
process a message auto learn complains about the duplicate key again, but it
actually learns the tokens and I can see them with sa-learn --dump magic.
What key is duplicate? I'm still unclear on how to resolve this?
I am having a few problems converting from Berkely DB to MySQL w/ InnoDB. I
have created the DB, Tables, and updated the local.cf. Everything appears ok,
but when I attempt to restore my Berkely DB backup with sa-learn --restore
filename. I get the following errors.
[21508] dbg: bayes: usi
Is there a LANG=UTF-8 or some such setting that you could maybe use?
Loren
8:58 PM
> To: users@spamassassin.apache.org
> Subject: bayes sql error.
>
> We've developed a problem recently with our mail server setup. I one
> post that talked about mysql needing to have utf-8 character support.
We
> tried converting our db, and eventually just cleared out
We've developed a problem recently with our mail server setup. I one
post that talked about mysql needing to have utf-8 character support. We
tried converting our db, and eventually just cleared out the db as a
test. When we cleared it out, it seemed to start returning more typical
responses.
On Mon, Jan 30, 2006 at 06:59:11AM -0800, Bret Miller wrote:
> > How much diskspace do you need for your database and how many
> > users do you have?
>
> I expect that depends on the SQL Database you're running and how you
> have SA configured.
True...
> Using Microsoft MSDE 2000 database, ~300
> How much diskspace do you need for your database and how many
> users do you have?
I expect that depends on the SQL Database you're running and how you
have SA configured.
Using Microsoft MSDE 2000 database, ~300 users, global awl+bayes, daily
spam and virus stats.
~53MB currently.
Bret
How much diskspace do you need for your database and how many users do
you have?
Bye,
Aiko
--
Aiko Barz <[EMAIL PROTECTED]>
Web: http://www.haeckser.de
signature.asc
Description: OpenPGP digital signature
> Do not use 3.0 with PostgreSQL. It's known to have problems. Actually,
> the problem you're seeing might be DBD::Pg related. Did you possibly
> just install a new version? Make sure you are using the version listed
> in sql/README.bayes.
I haven't noticed anything out of the ordinary after I mad
Andre Nicholson wrote:
>This happens when scanning incoming messages and trying to sa-learn them
>manually. The
>errors cause no tokens to be available and thus bayes is ignored. Other than
>reverting
>to a backup of the database, is there something I can do or look at to fix
>this? I've
>never
For the last several days, all messages scanned have not been using bayes
because of an
error:
debug: bayes: tok_get: SQL Error: ERROR: unterminated quoted string at or near
"'" at
character 145
debug: bayes: _put_token: SQL Error: ERROR: unterminated quoted string at or
near "'"
at character
Michael Parker wrote:
On Tue, May 10, 2005 at 05:36:53PM +0100, Tim Bishop wrote:
I've been running with bayes in a MySQL database for a while now, and I
need to start dealing with cleaning up users who are no longer here. I
also have AWL and configuration in the database.
So, I think I'm looki
On Tue, May 10, 2005 at 05:36:53PM +0100, Tim Bishop wrote:
> I've been running with bayes in a MySQL database for a while now, and I
> need to start dealing with cleaning up users who are no longer here. I
> also have AWL and configuration in the database.
>
> So, I think I'm looking at something
I've been running with bayes in a MySQL database for a while now, and I
need to start dealing with cleaning up users who are no longer here. I
also have AWL and configuration in the database.
So, I think I'm looking at something like the following to delete
someone's data from the database:
1. De
On Sat, Jan 22, 2005 at 10:00:04PM +0100, Alexander Newald wrote:
> I have setup sa to use mysql db for bayes. I hope I understound that bayes
> db in mysql is seperated for each email (username) I use. Now I like to
> remove all data from the bayes mysql db that was created while using this
> s
I have setup sa to use mysql db for bayes. I hope I understound that bayes
db in mysql is seperated for each email (username) I use. Now I like to
remove all data from the bayes mysql db that was created while using this
special email I like to remove.
Alexander Newald
On Sat, Jan 22, 2005 at 06:34:11PM +0100, Alexander Newald wrote:
> Hello,
>
> I have the fullowing sql db sheme and like to del an email. What do I need to
> del from each db?
>
I'm not totally clear on what you are trying to do.
If you want to completely clear out your bayes database, then j
Hello,
I have the fullowing sql db sheme and like to del
an email. What do I need to del from each db?
Thanks,
Alex
mysql> describe
bayes_expire;+-+-+--+-+-+---+|
Field | Type | Null | Key | Default | Extra
|+-+-+--+-+
On Mon, Dec 13, 2004 at 09:38:07PM +0100, Thomas Arend wrote:
> >
> > That said, a compromise was put into the code that could help you in
> > your situation. A few plugin hooks where added at various points in
> > the bayes code so you could extract the raw token values and map them
> > to their
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Am Montag, 13. Dezember 2004 16:04 schrieb Michael Parker:
> On Sun, Dec 12, 2004 at 11:21:19PM -0800, Gary W. Smith wrote:
[..]
> As of 3.0 the bayes tokens are stored as a part of an SHA1 hash on the
> original token string. So, there is no way to e
That makes complete sense. I can't say that I will be able to
successfully write a plug-in as time is the permitting factor. Storing
the keys would also be useful for us, but I will sacrifice reporting for
performance right now.
Management (i.e. myself) will just have to wait...
Gary
> functio
On Sun, Dec 12, 2004 at 11:21:19PM -0800, Gary W. Smith wrote:
> We used to do some bayes analisys on the 2.6x version using some scripts that
> would pickup what keywords had what scores. But the newer 3.0x SQL version
> seens to be storing tokens in some binary or BCD format.
>
> Is there any
Title: Bayes SQL token Q?
We used to do some bayes analisys on the 2.6x version using some scripts that would pickup what keywords had what scores. But the newer 3.0x SQL version seens to be storing tokens in some binary or BCD format.
Is there any way to derive the original keys from the
Just have a question regarding storing Bayes in SQL with Spamassassin
3.0. I already converted the old dbm files and such, everything is
working good, question I have is performance and token count. Previously
I had set the max db size to 25 tokens via the
bayes_expiry_max_db_size config op
64 matches
Mail list logo