Knowledgebase: Windows Server & VPS
Plesk Windows domain not working DNS zone disappears
Posted by Premium Reseller on 12 August 2013 09:35 PM

You have a domain added in Plesk. Domain suddenly stops working and cannot be resolved.

Domain dns is missing when checking on MS DNS server.

Restore default dns records in Plesk does not have any effect.

The issue is caused by incorrect dns details in Plesk database.

Steps to recreate dns records

1. Search invalid dns records in Plesk database

cd C:\Program Files (x86)\Parallels\Plesk\admin\bin>

"%plesk_bin%\dbclient" --direct-sql --sql="select id,name from dns_zone where id not in (select dns_zone_id from domains) and id not in (select dns_zone_id from domain_aliases) and id <> (select val from misc where param = 'default_dns_zone_id')"

2. Remove invalid dns records

cd %plesk_dir%\Mysql\bin

Login plesk mysql: mysql -uadmin -p -P 8306 psa

Delete records: delete from dns_zone where id not in (select dns_zone_id from domains) and id not in (select dns_zone_id from domain_aliases) and id <> (select val from misc where param = 'default_dns_zone_id');

Exit mysql

3. Update dns recods

cd C:\Program Files (x86)\Parallels\Plesk\admin\bin>

Plesk\admin\bin>DNSMng.exe Update *

Login Plesk panel, use Restore Defaults to restore default dns records

Open DNS manager on server to check if correct dns records are created.

(2 vote(s))
This article was helpful
This article was not helpful

Comments (0)