RE: [SAtalk] User_prefs without local users?

Izquierdo, Raul Fri, 30 May 2003 23:24:03 -0700

Title: RE: [SAtalk] User_prefs without local users?

Hi, I had the same problem. To see wich enviroment variables are configured I have executed an script into defaultdelivery that execute the system command "env".

        I have discover that this variable is called $USER
        The only thing you must do is adding the following statement to your defaultdelivery file:
        |spamc -u $USER | maildir ./Maildir

It works me fine.

Regards,
Raul.

-----Mensaje original-----
De:     Upwood, James [SMTP:[EMAIL PROTECTED]
Enviado el:     jueves 29 de mayo de 2003 17:55
Para:   Upwood, James; Shayne Lebrun; SpamAssassin
Asunto: RE: [SAtalk] User_prefs without local users?

I did more research, it appears I need to call spamc as [EMAIL PROTECTED],
problem is that I am using sendmail with spamass-milt and it calls
spamd. IS there any way to call the milter or spamc using a variable or
something that would be derived from the To: in the header?

-Jim

-----Original Message-----
From: Upwood, James
Sent: Thursday, May 29, 2003 10:50 AM
To: Shayne Lebrun; SpamAssassin
Subject: RE: [SAtalk] User_prefs without local users?

Great, that worked... Only problem is, it is only seeing the user
"root" in the DB. This makes me assume that I still have to have a
local user accounts? For example, I put my work account in the table
under the username field as [EMAIL PROTECTED] and tried to whitelist
[EMAIL PROTECTED] and it only works if I specify root as the
username but not [EMAIL PROTECTED] :(

-Jim

-----Original Message-----
From: Shayne Lebrun [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 29, 2003 10:13 AM
To: SpamAssassin
Subject: RE: [SAtalk] User_prefs without local users?

You need to run spamd with a flag to use sql prefs; -q as I recall.

> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of
> Upwood, James
> Sent: Thursday, May 29, 2003 10:04 AM
> To: Andreas Haase; SpamAssassin
> Subject: RE: [SAtalk] User_prefs without local users?
>
>
> I did exactly what your URL suggests in the sql/README, but it assumes

> that you still have local users or at least local user accounts. I
> ran the test and looked at the output of spamd and it isn't even
> querying the DB :(
>
> Here is my config:
>
> /etc/mail/spamassassin/local.cf
>
> # This is the right place to customize your installation of
> SpamAssassin. # See 'perldoc Mail::SpamAssassin::Conf' for details of
> what can be # tweaked.
> #
>
########################################################################
> ###
> #
> #rewrite_subject 0
> #report_safe 1
>     auto_whitelist_path        /var/spool/spamassassin/auto-whitelist
>     auto_whitelist_file_mode   0666
>
> #Bayes Config
>
>
> #Read Individual User Prefs from MySQL Database user-scores-dsn
> DBI:mysql:spamassassin:localhost user_scores_sql_username sa
> user_scores_sql_password wegmans
> user_scores_sql_table userprefs
>
> # SpamAssassin config file for version 2.5x
> # generated by http://www.yrex.com/spam/spamconfig.php (version 1.01)
>
> # How many hits before a message is considered spam.
> required_hits           5.0
>
> # Whether to change the subject of suspected spam
> rewrite_subject         1
>
> # Text to prepend to subject if rewrite_subject is used
> subject_tag             *****Possible Spam***** -->
>
> # Encapsulate spam in an attachment
> report_safe             1
>
> # Use terse version of the spam report
> use_terse_report        0
>
> # Enable the Bayes system
> use_bayes               1
>
> # Enable Bayes auto-learning
> auto_learn              1
>
> # Enable or disable network checks
> skip_rbl_checks         0
> use_razor2              1
> use_dcc                 1
> use_pyzor               1
>
> # Mail using languages used in these country codes will not be marked
> # as being possibly spam in a foreign language. # - english
> ok_languages            en
>
> # Mail using locales used in these country codes will not be marked #
> as being possibly spam in a foreign language.
> ok_locales              en
>
> # Default template. Try to keep it under 76 columns (inside the the
> dots below). # Bear in mind that EVERY line will be prefixed with
> "SPAM: " in order to make
> # it clear what's been added, and allow other filters to *remove*
> spamfilter
> # modifications, so you lose 6 columns right there.
> #
> #
> ......................................................................
> clear_report_template
> report Welcome to the BS&K AntiSpam Initiative
> report
> report This mail is probably spam. The original message has been
> attached
> report along with this report, so you can recognize or block similar
> unwanted
> report mail in future. If you are tired of seeing these messages, you
> can create
> report an Outlook rule to either permanently delete them, or move them
> to a
> report different folder for later viewing. Call x8651 if you need
> assistance in
> report doing this.
> report
> report Content preview:
> report
> report _PREVIEW_
> report
> report Content analysis details:   (_HITS_ points, _REQD_ required)
> report
> report _SUMMARY_
> #
> ......................................................................
>
> #Terse report template.
> #
> #
> ......................................................................
> clear_terse_report_template
> terse_report ---- Start SpamAssassin results
> terse_report _HITS_ points, _REQD_ required;
> terse_report _SUMMARY_
> terse_report ---- End of SpamAssassin results
> #
> ......................................................................
>
>
>
> MYSQL Config:
>
> DB Name is spamassassin
> Table is userpref
> Fields are setup as per readme
>
>
> Thanks,
>
> -Jim
>
> -----Original Message-----
> From: Andreas Haase [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, May 28, 2003 11:08 AM
> To: SpamAssassin
> Subject: Re: [SAtalk] User_prefs without local users?
>
>
> On Wed, 28 May 2003, Upwood, James wrote:
>
> > All I am interested in is maintaining whitelists/blacklists - per
> > user. Is this possible? It would be neat to be able to put a
command
> > in like this into the /etc/mail/spamassassin/local.cf file:
>
> that's possible if you use mysql as a backend for spamassassin. The
> options for local.cf are
>
>       user-scores-dsn DBI:mysql:spamassassin:localhost
>       user_scores_sql_username uname
>       user_scores_sql_password passwd
>       user_scores_sql_table tablename
>
> You can find more information about this under
> http://www.spamassassin.org/dist/sql/README
>
> Bye,
>
> Andreas Haase
> EastLink GmbH
> --
> -------------- professional INTERNET services -------------
>
> EastLink GmbH - Leipziger Strasse 46 - D-09113 Chemnitz
> voice: +49-180-5432060 fax: +49-371-4320626 www.eastlink.de
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: ObjectStore.
> If flattening out C++ or Java code to make your application fit in a
> relational database is painful, don't do it! Check out ObjectStore.
> Now part of Progress Software. http://www.objectstore.net/sourceforge
> _______________________________________________
> Spamassassin-talk mailing list [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/spamassassin-talk
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: eBay
> Get office equipment for less on eBay!
> http://adfarm.mediaplex.com/ad/ck/711-11697-6916-5
> _______________________________________________
> Spamassassin-talk mailing list [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/spamassassin-talk
>

-------------------------------------------------------
This SF.net email is sponsored by: eBay
Get office equipment for less on eBay!
http://adfarm.mediaplex.com/ad/ck/711-11697-6916-5
_______________________________________________
Spamassassin-talk mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/spamassassin-talk

______________________________________________________
Si desitja m�s informaci� sobre Al-Pi telecomunicacions (Catalana de Telecomunicacions, S.O.X. S.A.) i els nostres serveis, si us plau visiti'ns ara a www.al-pi.com

La informaci� d'aquest missatge electr�nic �s confidencial, personal i intransferible i nom�s est� dirigida a la/les adre�a/ces indicades a dalt. Si vost� llegeix aquest missatge per equivocaci�, l'informem que queda prohibida la seva divulgaci�, �s o distribuci�, completa o en part, i li preguem que ho notifiqui immediatament a la persona que ho ha enviat i esborri el missatge original juntament amb els seus fitxers annexos sense llegir-lo ni gravar-lo.

Gr�cies.

Si desea m�s informaci�n sobre Al-Pi telecomunicacions (Catalana de Telecomunicacions, S.O.X. S.A.) y nuestros servicios, por favor vis�tenos ahora en www.al-pi.com

La informaci�n de este mensaje electr�nico es confidencial, personal e intransferible y s�lo est� dirigida a la(s) direcci�n(es) indicadas arriba. Si usted lee este mensaje por equivocaci�n, le informamos de que est� prohibida su divulgaci�n, uso o distribuci�n, completo o en parte, y le rogamos que lo notifique inmediatamente a la persona que lo ha enviado y borre el mensaje orginal junto con sus ficheros anexos sin leerlo ni grabarlo.

Gracias.

RE: [SAtalk] User_prefs without local users?

Reply via email to