Retrieving the whitelist/blacklist/whitelist dedicated to Newsletters
Added almost 3 years 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';