Articles in this section

See more

How to add SPF record for all domains on Plesk server?

Avatar
Alex Davydov
Updated
Follow
Plesk for Windows Plesk for Linux kb: how-to ABT: Group B

Applicable to:

  • Plesk for Linux
  • Plesk for Windows

Question

How to add SPF record for all domains on Plesk server?

Answer

SPF record for all domains can be added as follows:

For Windows

  1. Connect to the server via RDP and open command prompt as Administrator

  2. Get the list of domains:

    C:\> "%plesk_bin%\dbclient.exe" --direct-sql --sql="SELECT name FROM domains" > dns.txt

  3. Add TXT record for all domains as follows:

    C:\> for /f "skip=1" %i in (dns.txt); do ("%plesk_cli%\dns.exe" -a %i -txt "v=spf1 some_spf_text")

    Note: Change some_spf_text by the required record. For more information see: How to create SPF rule for the domain?

For Linux

  1. Connect to the server via SSH

  2. Find domains without spf TXT record:

    # plesk db -Ne "select name from domains where dns_zone_id not in (select dns_zone_id from dns_recs where type='TXT' and val like '%spf%');" > domains_without_spf.txt

  3. Add spf record

    # cat domains_without_spf.txt | while read i; do echo $i; plesk bin dns -a $i -txt "some_spf_text" ;done

    Note: Change some_spf_text by the required record. For more information see: How to create SPF rule for the domain?

Comments

3 comments

Sort by Date Votes
  • Avatar
    turgut kalfaoglu

    How about UPDATING all the SPF records of domains?  Since there may be multiple TXT entries for each domain, we can't just delete all the TXT and re-insert them :(

     

    0
    Comment actions Permalink
  • Avatar
    Yaroslav Tarasov

    Hello @Turgut Kalfaoglu,

    Thank you for your question. You are right, we can't just remove all the TXT type records, because they are not only for SPF. The utility "plesk bin dns" also doesn't have the "update" option. That's why we will need to update the existing records via the database. Below are two options - for Linux and for Windows.

    Linux:

    1. Connect to the server via SSH

    2. Create Plesk database backup

    3. Update the SPF entries in the database:

      # plesk db
      > UPDATE dns_recs SET val = REPLACE(val, 'v=spf1', 'v=spf1 include:example.com');
      > UPDATE dns_recs SET displayVal = REPLACE(displayVal, 'v=spf1', 'v=spf1 include:example.com');
      quit

    4. Use the Plesk repair tool kit to repair the DNS:

      # plesk repair dns -y

    Windows:

    1. Connect to the server via RDP

    2. Create Plesk database backup

    3. Open the Command line as an Administrator

    4. Update the SPF entries in the database:

      C:\> plesk db
      > UPDATE dns_recs SET val = REPLACE(val, 'v=spf1', 'v=spf1 include:example.com');
      > UPDATE dns_recs SET displayVal = REPLACE(displayVal, 'v=spf1', 'v=spf1 include:example.com');
      quit

    5. Use the Plesk repair tool kit to repair the DNS:

      C:\> plesk repair dns -y

     

    Just a note to the SQL queries above. These queries replace the old value 'v=spf1' with the new value 'v=spf1 include:example.com' on all domains. Please don't forget to change them to the ones you need.

    1
    Comment actions Permalink
  • Avatar
    turgut kalfaoglu (Edited )

    Thank you very much -- great help!

    I had various versions of SPFs already listed, so I got a list of them first:

    plesk db "select val from dns_recs where val like '%spf1%';" | sort|uniq > spfs

    I edited spfs file so only the bad versions remain,  Then I ran this ooRexx I wrote:

    /**/
    inf = 'spfs'
    do while lines(inf)>0
    r = strip(linein(inf))
    say "UPDATE dns_recs SET val = REPLACE(val, '"r"','v=spf1 mx a ip4:135.181.160.175 ip4:65.21.212.128/29 -all');"
    say "UPDATE dns_recs SET displayVal = REPLACE(displayVal, '"r"','v=spf1 mx a ip4:135.181.160.175 ip4:65.21.212.128/29 -all');"
    end

    I ran this, redirecting its output to a file, and then I fed it to plesk db with something like 
    plesk db < blah

    finally I ran the plesk repair dns -y

     

     

    1
    Comment actions Permalink

Please sign in to leave a comment.

Have more questions? Submit a request

Related articles