{"id":354,"date":"2009-11-28T07:47:14","date_gmt":"2009-11-28T11:47:14","guid":{"rendered":"http:\/\/linuxhostingsupport.net\/blog\/?p=354"},"modified":"2013-03-30T06:49:44","modified_gmt":"2013-03-30T10:49:44","slug":"error-unable-to-create-the-domain-because-a-dns-record-exists","status":"publish","type":"post","link":"https:\/\/linuxhostingsupport.net\/blog\/error-unable-to-create-the-domain-because-a-dns-record-exists","title":{"rendered":"Error: Unable to create the domain because a DNS record exists"},"content":{"rendered":"

Error:<\/strong><\/p>\n

Error message “Error: Unable to create the domain example.com because a DNS record pointing to the host example.com already exists.”<\/strong><\/span><\/p><\/blockquote>\n

The error message is displayed when you add a domain from Plesk control panel and it fails. The reason it fails is because the DNS records of the domain already exist in the psa database.<\/strong> The tables dns_recs and dns_zone holds the DNS records<\/strong><\/span> for a domain.<\/p>\n

In order to add the domain example.com, you will have to remove the DNS entries from the tables dns_recs and dns_zone.<\/p>\n

1) Goto Mysql prompt:<\/strong><\/p>\n

root@host [~]# mysql -uadmin -p `cat \/etc\/psa\/.psa.shadow`<\/strong><\/span><\/p><\/blockquote>\n

2) Use the psa database<\/strong><\/p>\n

mysql>\u00a0 use psa;<\/strong><\/span><\/p><\/blockquote>\n

3) Remove the DNS entries from the dns_recs and dns_zone tables:<\/strong><\/p>\n

mysql> delete from dns_recs where dns_zone_id=10;
\nmysql> delete from dns_zone where id=10;<\/strong><\/span><\/p><\/blockquote>\n

where, 10 is the dns_zone_id of the domain example.com.<\/p>\n

4) Restart the mysql service:<\/strong><\/p>\n

root@host [~]# service mysqld restart<\/strong><\/span><\/p><\/blockquote>\n

You should now be able to add the domain from Plesk control panel successfully.<\/p>\n","protected":false},"excerpt":{"rendered":"

Error:
\nError message “Error: Unable to create the domain example.com because a DNS record pointing to the host example.com already exists.”
\nThe error message is displayed when you add a domain from Plesk control panel and it fails. The reason it fails is because the DNS records of the domain already exist in the psa database. The tables dns_recs and dns_zone holds the DNS records for a domain.
\nIn order to add the domain example.com, you will have to remove the DNS entries from the tables dns_recs and dns_zone.
\n1) Goto Mysql […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[464,459,460,461,465,462,458,463],"_links":{"self":[{"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/posts\/354"}],"collection":[{"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/comments?post=354"}],"version-history":[{"count":3,"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/posts\/354\/revisions"}],"predecessor-version":[{"id":356,"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/posts\/354\/revisions\/356"}],"wp:attachment":[{"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/media?parent=354"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/categories?post=354"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/tags?post=354"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}