Blacklist

Discussion in 'HOWTO-Related Questions' started by mrbronz, Jun 25, 2025.

  1. mrbronz

    mrbronz Member HowtoForge Supporter

    In the standard ISPC3 setup, is there a specific file or database table that stores the email black lists? If so, where is it stored? I want to copy it.
     
  2. mrbronz

    mrbronz Member HowtoForge Supporter

    Bump anything any one !
     
  3. till

    till Super Moderator Staff Member ISPConfig Developer

    I think this is stored in the mail_access table.
     
  4. mrbronz

    mrbronz Member HowtoForge Supporter

    Hi Till

    Many thanks for getting back to me.
    I had already checked this option, and that table is empty.
    I have also tried searching for files with similar names, but cannot find anything.
    Do you or anyone have any suggestions where the list of blacklisted emails and domains may be stored?

    Kind Regards
     
  5. till

    till Super Moderator Staff Member ISPConfig Developer

    Maybe you do not refer to the mail blacklist but the spamfilter blacklist? The spamfilter blacklist is in the spamfilter_blacklist table.
     
  6. mrbronz

    mrbronz Member HowtoForge Supporter

    OK I got it,

    Like an idiot, I relied on phpMyAdmin to show me all the tables in one go, but for some reason, it didn't show all the tables. The smoking gun was in the file list/list/spamfilter_blacklist.list.php.

    The actual SQL to get the list
    Code:
    mysqldump -u ispconfig -p dbispconfig spamfilter_wblist --where="wb='B'" > /tmp/ispconfig_spamfilter_blacklist.sql
    Not very smart, am I?

    but I managed to get there in the end.
     
    ahrasis likes this.
  7. pyte

    pyte Well-Known Member HowtoForge Supporter

    Well you figured it out with a bit of help! That isn't too bad I would say :) We all are the deer in the headlights sometimes.
     

Share This Page