Collapse

Announcement

Collapse
No announcement yet.

This DNS record already exists : Plesk issue

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • This DNS record already exists : Plesk issue

    While creating a new domain/subdomain/alias for a domain on the Plesk panel getting following error:

    ```
    This DNS record already exists
    ```

    To fix this issue, follow the below steps:

    1) Connect to the Plesk Windows server via RDP.

    2) Take a database dump of the Plesk database using the following command under the command prompt(Start CMD as an Administrator).

    plesk db dump psa > C:\psa_24x7_backup.sql

    Click image for larger version

Name:	DNS_1.png
Views:	1
Size:	37.6 KB
ID:	868

    3) Access the Plesk database using the following command in CMD:

    plesk db

    Click image for larger version  Name:	DNS_2.png Views:	1 Size:	39.3 KB ID:	863


    4) Find dns_zone_id of the domain, which cannot be created, using the following command.

    select dns_zone_id,host from dns_recs where host like "%aicp.ir%";

    Click image for larger version  Name:	DNS_3.png Views:	1 Size:	18.3 KB ID:	864


    Replace aicp.ir with your actual domain name:

    5) Using dns_zone_id from the output above, make sure that the domain name is the same:

    select id,name from dns_zone where id=628;

    Click image for larger version  Name:	DNS_4.png Views:	1 Size:	6.2 KB ID:	865


    6) Delete records from corresponding tables using the ID from the steps above

    delete from dns_zone where id=628;
    delete from dns_recs where dns_zone_id=628;

    Click image for larger version  Name:	DNS_5.png Views:	1 Size:	8.2 KB ID:	866


    Now, you will able to create the domain/subdomain/alias in Plesk without any issue.
    Last edited by santosh; 10-03-2019, 01:19 PM.
Working...
X