Resolved How to backup the spam filter black list

[Blairvoyach]

Server operating system version

Windows server 2012 r2

Plesk version and microupdate number

Obsidian 18.0.44 update #3

Can anyone tell me either where the email black list is stored in Plesk for windows or a method of exporting it? I have hundreds of blocked addresses and domains but can't find any way to back them up as an independent backup in case I want to re-install or start a new server.

 

[IgorG]

The server-wide Black List is located in the badmailfrom table of the Plesk database:

C:\>plesk db "select * from badmailfrom"
+----+--------------+---------------+
| id | domain       | serviceNodeId |
+----+--------------+---------------+
|  1 | *@domain.com |             1 |
+----+--------------+---------------+

This corresponds to the information in the Plesk GUI in Tools and Settings > Mail Server Settings > Black List

 

[Blairvoyach]

Thank you Igor.

I've been looking for some time for this.

 

[QWeb Ric]

The server-wide Black List is located in the badmailfrom table of the Plesk database:

C:\>plesk db "select * from badmailfrom"
+----+--------------+---------------+
| id | domain       | serviceNodeId |
+----+--------------+---------------+
|  1 | *@domain.com |             1 |
+----+--------------+---------------+

This corresponds to the information in the Plesk GUI in Tools and Settings > Mail Server Settings > Black List

Stumbled onto this while trying to find a way to migrate the block list from one server to another, but after importing to the new servers database, Plesk still shows an empty list. Do we need to trigger a config file regeneration somehow? (Linux here)

 

[Kaspar@Plesk]

I'd recommend using the CLI utility for this.

You can view all blacklist entries using this command:

plesk bin mailserver --info black-list

And add any domains to the blacklist with this command:

plesk bin mailserver --add-to-black-list example.com

 

[QWeb Ric]

I'd recommend using the CLI utility for this.

You can view all blacklist entries using this command:

plesk bin mailserver --info black-list

And add any domains to the blacklist with this command:

plesk bin mailserver --add-to-black-list example.com

Thanks. Turns out the page just took a while to update and does now show the imported entries, and I can see them with this command too so presumably all is good now =).