Mysql.Personal mail whitelist/blacklist problem

Discussion in 'Installation/Configuration' started by atomlab, Jul 28, 2011.

  1. atomlab

    atomlab New Member

    Hi.
    1. I crated domain "mail.com"
    2. Create the users into the domain "mail.com"
    3. Add blacklist rules in spamfilter for each user.
    Example blacklist for users:

    Code:
    User  (recipient): user1@mail.com
    Email (sender): sale@spamdomain.com
    
    User (recipient): user2@mail.com
    Email (sender): sseexx@yahoo.com
    
    User (recipient): user3@mail.com
    Email (sender): shop@shopdomain.com
    
    ISPConfig insert rules into table "spamfilter_wblist".
    Code:
    wblist_id     sys_userid     sys_groupid     wb     email
         1                       2                   2                         B      sale@spamdomain.com 
         2                       2                   2                         B      sseexx@yahoo.com
         3                       2                   2                         B      shop@shopdomain.com    
    
    These rules work only for domain because the sys_userid is the ID of the user that is currently logged into the ispconfig interface.

    How to identify recipient <-> sender ?

    It is necessary for me for Exim mysql query.

    Excuse for bad English.

    Thank you!
     
    Last edited: Jul 28, 2011
  2. atomlab

    atomlab New Member

    Has found itself where personal spamfilter.

    Email Mailbox -> accaunt -> Mail Filter

    ISPConfig used table mail_user_filter in database.
    Column mailuser_id = id the mail user.
    Column searchterm = sender
     

Share This Page