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('謀LZxj[ yzbkay^[h+vh Xz0i &bw]eȝ~%Ƭ)jY&j)b bԩjf,{ZIb,y+m+-.ǟ +-bا~쥩Ƭ)jY
