Hi Guillaume, No problem, Unfortunately I'm a LDAP user, but I can describe my setup.
ExtLookupQuery "(|(mail=%u)(gosaMailAlternateAddress=%u))" # Can either be an LDAP search filter or an SQL query (TODO) ExtLookupLDAPAttribute "mail" # Attribute to be used when ExtLookupDriver is 'ldap' So the query is doing a lookup for the recipient address in the attributes mail and gosaMailAlternativeAddress and will return the contents of the mail attribute. An example from my system for myself. My account contains the following information: mail: martin.whel...@greenhills-it.co.uk gosaMailAlternateAddress: mar...@greenhills-it.co.uk So a message addressed to mar...@greenhills-it.co.uk will mean that dspam will lookup mar...@greenhills-it.co.uk in the mail attribute and the gosaMailAlternateAdddress and return the contents of the mail attribute martin.whel...@greenhills-it.co.uk And a message addressed to martin.whel...@greenhills-it.co.uk will mean that dspam will lookup martin.whel...@greenhills-it.co.uk in the mail attribute and the gosaMailAlternateAdddress and return the contents of the mail attribute martin.whel...@greenhills-it.co.uk So I would guess that your program script will need to accept a recipient address on the command line and return a recipient address to dspam. I've never had cause to try it but you could test it easily by creating a script that just returned your email address regardless of what it is passed given that you are the only user. Hope that helps. Best Regards Martin On 2015-01-08 10:29, Guillaume wrote: > Hi Martin, > > That would work indeed, but could you please describe your > configuration ? > I'm using MySQL (no LDAP) but I can't find a lot of documentation > about > this configuration for DSPAM. > > Since there's no direct MySQL support and that i would use only one > uid, > i suppose a simple script would be enough, but i don't know how the > "program" mode works. > > Could i do it simplier and having a mysql update script running to > update every uid in dspam_token_data and dspam_signature_data to the > uid > i'm using ? > > Thanks, > > Guillaume Hilt > > Le 08/01/2015 10:52, Martin Wheldon a écrit : >> Hi Guillaume, >> >> The way I deal with this is to use a dspam external lookup which >> maps >> all my aliases to my real id. >> >> In your configuration I suspect you will find uids for each of your >> aliases in the database meaning that filtering will >> differ between aliases, and you suffer the training issue you are >> describing. >> >> Hope that helps. >> >> Best Regards >> >> Martin >> >> On 2015-01-08 09:41, Guillaume wrote: >>> Basically i'm using aliases only to receive (and send on a few >>> exceptions, like the dspam@ i'm using right now). >>> It helps me to know which website sold my email address (i've got >>> one >>> alias per website). >>> >>> So, it would need for DSPAM to only reference one uid and put all >>> the >>> data under it. >>> Or it could use "Delivered-To" header instead of "To" field. >>> >>> I don't know if it's possible. >>> >>> Guillaume Hilt >>> >>> Le 08/01/2015 10:31, Guillaume a écrit : >>>> Ok, it's because i'm having aliases. >>>> So the spam was sent to anal...@domain.tld but my mailbox address >>>> is >>>> m...@domain.tld. >>>> >>>> Since I'm the only user of my mail server, how can i do to make it >>>> work >>>> with the aliases ? >>>> >>>> Guillaume Hilt >>>> >>>> Le 08/01/2015 09:57, Tom Hendrikx a écrit : >>>>> Hi Guillaume, >>>>> >>>>> On 07-01-15 23:21, Guillaume wrote:> Mmmh, spoke too fast. >>>>> > It's better but not fixed. >>>>> <snip> >>>>> > 6329: [01/07/2015 23:14:38] _mysql_drv_getpwnam: successful >>>>> returning >>>>> > struct for name: XXXXXX >>>>> > 6329: [01/07/2015 23:14:38] Loading preferences for uid 16 >>>>> <snip> >>>>> > SELECT * >>>>> > FROM `dspam_signature_data` >>>>> > WHERE `signature` = '54ac0490181051388914240' >>>>> > >>>>> > uid signature data length created_on >>>>> > 143 54ac0490181051388914240 [BLOB - 3,9 Kio] >>>>> 3968 >>>>> 2015-01-06 >>>>> > >>>>> >>>>> The uid in the dspam debug log (16), and the one in the database >>>>> (143) >>>>> are not the same. You are using different accounts for filtering >>>>> and >>>>> retraining. >>>>> >>>>> -- >>>>> Tom >>>>> >>>>> >>>>> >>>>> >>>>> ------------------------------------------------------------------------------ >>>>> Dive into the World of Parallel Programming! The Go Parallel >>>>> Website, >>>>> sponsored by Intel and developed in partnership with Slashdot >>>>> Media, is your >>>>> hub for all things parallel software development, from weekly >>>>> thought >>>>> leadership blogs to news, videos, case studies, tutorials and >>>>> more. >>>>> Take a >>>>> look and join the conversation now. >>>>> http://goparallel.sourceforge.net >>>>> _______________________________________________ >>>>> Dspam-user mailing list >>>>> Dspam-user@lists.sourceforge.net >>>>> https://lists.sourceforge.net/lists/listinfo/dspam-user >>>>> >>>> >>>> >>>> ------------------------------------------------------------------------------ >>>> Dive into the World of Parallel Programming! The Go Parallel >>>> Website, >>>> sponsored by Intel and developed in partnership with Slashdot >>>> Media, >>>> is your >>>> hub for all things parallel software development, from weekly >>>> thought >>>> leadership blogs to news, videos, case studies, tutorials and >>>> more. >>>> Take a >>>> look and join the conversation now. >>>> http://goparallel.sourceforge.net >>>> _______________________________________________ >>>> Dspam-user mailing list >>>> Dspam-user@lists.sourceforge.net >>>> https://lists.sourceforge.net/lists/listinfo/dspam-user >>>> >>> >>> >>> >>> ------------------------------------------------------------------------------ >>> Dive into the World of Parallel Programming! The Go Parallel >>> Website, >>> sponsored by Intel and developed in partnership with Slashdot >>> Media, >>> is your >>> hub for all things parallel software development, from weekly >>> thought >>> leadership blogs to news, videos, case studies, tutorials and more. >>> Take a >>> look and join the conversation now. >>> http://goparallel.sourceforge.net >>> _______________________________________________ >>> Dspam-user mailing list >>> Dspam-user@lists.sourceforge.net >>> https://lists.sourceforge.net/lists/listinfo/dspam-user >>> >>> >> >> >> ------------------------------------------------------------------------------ >> Dive into the World of Parallel Programming! The Go Parallel >> Website, >> sponsored by Intel and developed in partnership with Slashdot Media, >> is your >> hub for all things parallel software development, from weekly >> thought >> leadership blogs to news, videos, case studies, tutorials and more. >> Take a >> look and join the conversation now. >> http://goparallel.sourceforge.net >> _______________________________________________ >> Dspam-user mailing list >> Dspam-user@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/dspam-user > > > > ------------------------------------------------------------------------------ > Dive into the World of Parallel Programming! The Go Parallel Website, > sponsored by Intel and developed in partnership with Slashdot Media, > is your > hub for all things parallel software development, from weekly thought > leadership blogs to news, videos, case studies, tutorials and more. > Take a > look and join the conversation now. http://goparallel.sourceforge.net > _______________________________________________ > Dspam-user mailing list > Dspam-user@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/dspam-user > > !DSPAM:31,54ae5c3e78347103081423! ------------------------------------------------------------------------------ Dive into the World of Parallel Programming! The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net _______________________________________________ Dspam-user mailing list Dspam-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspam-user
