Retrieving the whitelist/blacklist/whitelist dedicated to Newsletters

MailCleaner Support
Added about 1 year ago

You can get this information by connecting to your master server using SSH. Then connect to the master database with

mc_mysql -m mc_config

These data are stored in table wwlist.

The type white is for whitelist, black for blacklist, and wnews for the whitelist dedicated to newsletters.
If the recipient field is empty the entry applies for all the domains declared in MailCleaner.
If the recipient field is a domain name the entry applies for all users of the domain.
Otherwise the entry applies to the user in the recipient field.

You know need a minimal knowledge of SQL. For example, to get all entries in whitelist applying for all domains, please use :

select * from wwlists where recipient ='' and type ='white';