{"id":118,"date":"2021-07-04T21:47:58","date_gmt":"2021-07-04T19:47:58","guid":{"rendered":"https:\/\/schoppe.it\/wiki\/?p=118"},"modified":"2024-09-03T08:51:16","modified_gmt":"2024-09-03T06:51:16","slug":"spam-filter-einstellungen-pruefen-via-sql","status":"publish","type":"post","link":"https:\/\/schoppe.it\/wiki\/spam-filter-einstellungen-pruefen-via-sql\/","title":{"rendered":"Spam-Filter Einstellungen pr\u00fcfen via SQL"},"content":{"rendered":"\n<p>Der folgende Befehl zeigt die SPAM-Filter Einstellungen aller Postf\u00e4cher auf dem Plesk-Webserver an.<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>\u00dcber die Shell (bspw. mit PUTTY) mit dem Webserver verbinden.<\/li><li>Nach der Anmeldung folgenden Befehl eingeben.<\/li><\/ol>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nplesk db\n<\/pre><\/div>\n\n\n<p>Jetzt kann der SQL-Befehl reinkopiert und mit Enter ausgef\u00fchrt werden.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nAlle E-Mail-Adressen mit Postfach und SPAM Filter Einstellungen\n\nSELECT\n\tDISTINCT CONCAT(mail.mail_name, &#039;@&#039;, domains.name) AS mailbox,\t\n\tmail.postbox,\n\tmail.spamfilter,\n\tACTION.preference AS &#039;ACTION&#039;,\n\tACTION.value AS &#039;ACTION-VALUE&#039;,\n\tREQUIRED_SCORE.preference AS &#039;REQUIRED_SCORE&#039;,\n\tREQUIRED_SCORE.value AS &#039;REQUIRED_SCORE-VALUE&#039;,\n\tREWRITE_HEADER.preference AS &#039;REWRITE_HEADER&#039;,\n\tREWRITE_HEADER.value AS &#039;REWRITE_HEADER-VALUE&#039;,\n\tdomains.name\nFROM mail\nLEFT JOIN mail_redir ON mail_redir.mn_id = mail.id\nLEFT JOIN domains ON domains.id = mail.dom_id\nLEFT JOIN spamfilter \n\tON spamfilter.username = CONCAT(mail.mail_name, &#039;@&#039;, domains.name)\nLEFT JOIN spamfilter_preferences AS ACTION\n\tON ACTION.spamfilter_id = spamfilter.id\n\tAND ACTION.preference = &#039;action&#039;\nLEFT JOIN spamfilter_preferences  AS REQUIRED_SCORE\n\tON REQUIRED_SCORE.spamfilter_id = spamfilter.id\n\tAND REQUIRED_SCORE.preference = &#039;required_score&#039;\nLEFT JOIN spamfilter_preferences  AS REWRITE_HEADER\n\tON REWRITE_HEADER.spamfilter_id = spamfilter.id\n\tAND REWRITE_HEADER.preference = &#039;rewrite_header&#039;\nWHERE mail.postbox = &#039;true&#039;\nORDER BY mail.postbox ASC, domains.name ASC;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-gallery columns-1 wp-block-gallery-1 is-layout-flex wp-block-gallery-is-layout-flex\"><ul class=\"blocks-gallery-grid\"><li class=\"blocks-gallery-item\"><figure><a href=\"https:\/\/schoppe.it\/wiki\/wp-content\/uploads\/sites\/2\/2021\/07\/Plesk_SQL_1.png\"><img loading=\"lazy\" decoding=\"async\" width=\"684\" height=\"840\" src=\"https:\/\/schoppe.it\/wiki\/wp-content\/uploads\/sites\/2\/2021\/07\/Plesk_SQL_1.png\" alt=\"\" data-id=\"119\" data-full-url=\"https:\/\/schoppe.it\/wiki\/wp-content\/uploads\/sites\/2\/2021\/07\/Plesk_SQL_1.png\" data-link=\"https:\/\/schoppe.it\/wiki\/?attachment_id=119\" class=\"wp-image-119\" srcset=\"https:\/\/schoppe.it\/wiki\/wp-content\/uploads\/sites\/2\/2021\/07\/Plesk_SQL_1.png 684w, https:\/\/schoppe.it\/wiki\/wp-content\/uploads\/sites\/2\/2021\/07\/Plesk_SQL_1-244x300.png 244w\" sizes=\"auto, (max-width: 684px) 100vw, 684px\" \/><\/a><figcaption class=\"blocks-gallery-item__caption\">plesk db<\/figcaption><\/figure><\/li><li class=\"blocks-gallery-item\"><figure><a href=\"https:\/\/schoppe.it\/wiki\/wp-content\/uploads\/sites\/2\/2021\/07\/Plesk_SQL_2.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1712\" height=\"400\" src=\"https:\/\/schoppe.it\/wiki\/wp-content\/uploads\/sites\/2\/2021\/07\/Plesk_SQL_2.png\" alt=\"\" data-id=\"120\" data-full-url=\"https:\/\/schoppe.it\/wiki\/wp-content\/uploads\/sites\/2\/2021\/07\/Plesk_SQL_2.png\" data-link=\"https:\/\/schoppe.it\/wiki\/?attachment_id=120\" class=\"wp-image-120\" srcset=\"https:\/\/schoppe.it\/wiki\/wp-content\/uploads\/sites\/2\/2021\/07\/Plesk_SQL_2.png 1712w, https:\/\/schoppe.it\/wiki\/wp-content\/uploads\/sites\/2\/2021\/07\/Plesk_SQL_2-300x70.png 300w, https:\/\/schoppe.it\/wiki\/wp-content\/uploads\/sites\/2\/2021\/07\/Plesk_SQL_2-1024x239.png 1024w, https:\/\/schoppe.it\/wiki\/wp-content\/uploads\/sites\/2\/2021\/07\/Plesk_SQL_2-768x179.png 768w, https:\/\/schoppe.it\/wiki\/wp-content\/uploads\/sites\/2\/2021\/07\/Plesk_SQL_2-1536x359.png 1536w, https:\/\/schoppe.it\/wiki\/wp-content\/uploads\/sites\/2\/2021\/07\/Plesk_SQL_2-1568x366.png 1568w\" sizes=\"auto, (max-width: 1712px) 100vw, 1712px\" \/><\/a><figcaption class=\"blocks-gallery-item__caption\">Anzeige des Ergebnisses als Tabelle<\/figcaption><\/figure><\/li><\/ul><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Der folgende Befehl zeigt die SPAM-Filter Einstellungen aller Postf\u00e4cher auf dem Plesk-Webserver an. \u00dcber die Shell (bspw. mit PUTTY) mit dem Webserver verbinden. Nach der Anmeldung folgenden Befehl eingeben. Jetzt kann der SQL-Befehl reinkopiert und mit Enter ausgef\u00fchrt werden.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[50],"tags":[89],"powershell":[],"wordpress":[],"exchange":[],"linux":[],"class_list":["post-118","post","type-post","status-publish","format-standard","hentry","category-plesk","tag-sql","entry"],"_links":{"self":[{"href":"https:\/\/schoppe.it\/wiki\/wp-json\/wp\/v2\/posts\/118","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/schoppe.it\/wiki\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/schoppe.it\/wiki\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/schoppe.it\/wiki\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/schoppe.it\/wiki\/wp-json\/wp\/v2\/comments?post=118"}],"version-history":[{"count":3,"href":"https:\/\/schoppe.it\/wiki\/wp-json\/wp\/v2\/posts\/118\/revisions"}],"predecessor-version":[{"id":123,"href":"https:\/\/schoppe.it\/wiki\/wp-json\/wp\/v2\/posts\/118\/revisions\/123"}],"wp:attachment":[{"href":"https:\/\/schoppe.it\/wiki\/wp-json\/wp\/v2\/media?parent=118"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/schoppe.it\/wiki\/wp-json\/wp\/v2\/categories?post=118"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/schoppe.it\/wiki\/wp-json\/wp\/v2\/tags?post=118"},{"taxonomy":"powershell","embeddable":true,"href":"https:\/\/schoppe.it\/wiki\/wp-json\/wp\/v2\/powershell?post=118"},{"taxonomy":"wordpress","embeddable":true,"href":"https:\/\/schoppe.it\/wiki\/wp-json\/wp\/v2\/wordpress?post=118"},{"taxonomy":"exchange","embeddable":true,"href":"https:\/\/schoppe.it\/wiki\/wp-json\/wp\/v2\/exchange?post=118"},{"taxonomy":"linux","embeddable":true,"href":"https:\/\/schoppe.it\/wiki\/wp-json\/wp\/v2\/linux?post=118"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}