Hmmm...
under "man 3 Mail::SpamAssassin::Conf" I see:
user_scores_sql_field_scope field_scope
The 'scope' field. In Horde this makes the preference a single-
module preference or a global preference. There's no real need to
change it in other systems. Default: spamassassin.
It's not mentioned in the sql/README or examples...
I added some dbg calls of my own in
/usr/local/lib/perl5/site_perl/5.005/Mail/SpamAssassin/ConfSourceSQL.pm
and can see from that that :
sub load_modules is called
sub load is not.
and so of course neither is sub load_with_dbi
So where to from here?
Thanks.
m/
-----Original Message-----
From: Mitch (WebCob) [mailto:[EMAIL PROTECTED]
Sent: Monday, December 15, 2003 5:17 PM
To: Stevens, John; Jeremy Zawodny; Justin Mason
Cc: [EMAIL PROTECTED];
[EMAIL PROTECTED]
Subject: RE: [SAtalk] MySQL not working? No indication of error when
running spamd -D
I'm using the latest 2.61 here...
Would be interested in seeing your patch if it's posted somewhere... I
imagine the sql_field entries are also useless on an unpatched SA.
Are there any silly field size limits? like 6 character passwords or 10
character table names?
If I had an error message I might be able to figure it out, but I'm a bit in
the dark right now.
Thanks
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of
Stevens, John
Sent: Monday, December 15, 2003 4:06 PM
To: Jeremy Zawodny; Justin Mason
Cc: Mitch (WebCob); [EMAIL PROTECTED];
[EMAIL PROTECTED]
Subject: RE: [SAtalk] MySQL not working? No indication of error when
running spamd -D
Hi All,
I am not exactly sure of what the problem is here. It looks like you are
using MySQL only for scores. I am using it for all user preferences, and
had submitted a change I made to allow SA to use a Query (ie multiple joined
tables). Scores and everything else have worked flawlessly since we put it
in. There is a couple of gotchas that I know about. The first is that only
the first e-mail address is checked for a score, so if there are multiple
users that the mail is addressed to and the first one has a higher score
level than the rest, the mail will only be assessed against that level. The
other gotcha is that if there are no user preferences it falls back to a
default level. I actually put in a "nobody" set of preferences and scores
in the database to make certain that it fell back to that.
Also, make sure that [EMAIL PROTECTED] has permission to connect to your MySQL
database. We use FQDN for ours as we run two mail gateways with SA, and
both need to see the same userprefs. Failing to do this will mean that it
can't connect.
Here is the bit (modified) from local.cf that we use:
user_scores_dsn DBI:mysql:spamassassin:machine.ourdomain
user_scores_sql_username user
user_scores_sql_password xxxxxxx
user_scores_sql_table userpref left join aliases on userpref.username =
aliases.realusername
user_scores_sql_field_username aliases.username
user_scores_sql_field_preference userpref.preference
user_scores_sql_field_value userpref.value
The user_scores_sql_table statement is useless in an unpatched SA, so don't
use it. It should only contain the name of the table you are using. The
username, preference, and value field settings have default values, so if
your table conforms to the default, you should have no problem.
I am willing to assist with the SQL coding if help is needed. Although not
on the Devel list (easy fixed), I would definitely like to assist with SA in
any way I can. BTW, great work by all the Devs.
BTW, which SA are you using? I have not yet upgraded to the latest. Still
using 2.54
Regards
============================================
TUSC Computer Systems - www.tusc.com.au
John Stevens - MIS Manager, Senior Project Engineer
Mobile: 0419840411
Direct: 03 9840 4428
-----Original Message-----
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 16 December 2003 10:34 AM
To: Justin Mason
Cc: Mitch (WebCob); [EMAIL PROTECTED];
[EMAIL PROTECTED]
Subject: Re: [SAtalk] MySQL not working? No indication of error when running
spamd -D
On Mon, Dec 15, 2003 at 03:00:19PM -0800, Justin Mason wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
>
> Mitch (WebCob) writes:
> > Not sure if I should be posting this here or sending to jengland... I
> > already did that though...
> >
> > Thanks in advance for looking at this...
>
> There's definitely a lot of odd stuff in the SQL code, and we need
> someone who would be willing to take it over and add the new things
> we need (like known-good ordering of user/GLOBAL/@GLOBAL blocks,
> and Bayes/AWL-in-SQL integration). Unfortunately none of the core
> team are using it.
>
> Any volunteers?
Are the issues logged anywhere curently, like Bugzilla?
I've been using the [My]SQL SA stuff since the early days for ~15,000
users. But I won't have much time to look for a few weeks. And, when
my damned book is finally done (soon), I'll have more time. This
could be interesting to play with.
Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]> | http://jeremy.zawodny.com/
-------------------------------------------------------
This SF.net email is sponsored by: IBM Linux Tutorials.
Become an expert in LINUX or just sharpen your skills. Sign up for IBM's
Free Linux Tutorials. Learn everything from the bash shell to sys admin.
Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click
_______________________________________________
Spamassassin-talk mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/spamassassin-talk
---
This message (and any associated files) is intended only for the
use of the individual or entity to which it is addressed and may
contain information that is confidential, subject to copyright or
constitutes a trade secret. If you are not the intended recipient
you are hereby notified that any dissemination, copying or
distribution of this message, or files associated with this message,
is strictly prohibited. If you have received this message in error,
please notify us immediately by replying to the message and deleting
it from your computer. Messages sent to and from us may be monitored.
Internet communications cannot be guaranteed to be secure or error-free
as information could be intercepted, corrupted, lost, destroyed, arrive
late or incomplete, or contain viruses. Therefore, we do not accept
responsibility for any errors or omissions that are present in this
message, or any attachment, that have arisen as a result of e-mail
transmission. If verification is required, please request a hard-copy
version. Any views or opinions presented are solely those of the author
and do not necessarily represent those of the company.
TUSC Computer Systems, ABN 44 005 815 752
NHY隊X'uS+l({^ا,T^lz|$YlJ('謀L
Zxj[
yzbkay^[h+vh
Xz0i &bt
Ɩtrjj~zqzj
-------------------------------------------------------
This SF.net email is sponsored by: IBM Linux Tutorials.
Become an expert in LINUX or just sharpen your skills. Sign up for IBM's
Free Linux Tutorials. Learn everything from the bash shell to sys admin.
Click now! http://ads.osdn.com/?ad_id78&alloc_id371&op=click
_______________________________________________
Spamassassin-talk mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/spamassassin-talk
