psa database to remove DNS

I need to delete a domains DNS records from the PSA database on PLESK 9, I can remove the domain by command line, but the restoring the domain, I still get the same problem that it wil not  resolve.

cd %plesk_bin%
websrvmng --remove-vhost --vhost-name=yourdomain.com

How and where do I access the  PLESK PSA database on a windows 2003 server
stubblefield83Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Steve BinkCommented:
Before messing around with the psa database, you should be sure that the resolution issue resides with Plesk.  What steps did you take to isolate Plesk as the problem?  How is your resolution failing?  Are the nameserver records on your registration pointing to the correct server?  What DNS service are you using with Plesk (BIND/MS-DNS)?  Do you use a secondary MS-DNS server based on Plesk's master zone?

If you have ever been inside the psa database, you'll know it is a place to tread very lightly.  I would be hesitant to recommend anyone play around in there.  Have you attempted to contact Parallels for support?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
stubblefield83Author Commented:
The domain was pointing correctly, then we has the problem with the domain being suspended due to backup, so I deleted the domain and tried to reset it, at the time I thought it was the quick easy way.
Now I know if that happens to use:
cd %plesk_bin%
domain.exe --on example.com

I have tried to remove the domain by the command line, to get it to be reinstalled correctly:

cd %plesk_bin%
websrvmng --remove-vhost --vhost-name=yourdomain.com

I assume that its the Plesk DNS is the problem, since all the the settings are the same as they were befoer deleting the domain and trying to reinstall, I checked the IIS and those settings are correct.
Using the BIND/MS-DNS, the name servers are pointed correctly I have 50 domains on this server and all the setting are the same.

Here is the domain the fails http://leonardasmith.com/
Don't use secondary MS-DNS.

I have also ran the Plesk Reconfigurator to see if that would fix it.

I was hoping to solve the problem without contacting Parallels and save the $75.00



0
Steve BinkCommented:
See below for my resolution attempts.  Your nameserver records for the domain are pointed to ns1. and ns2.stunhosting.com.  Is this the same server holding your Plesk installation?  If not, then you are using a secondary DNS server.  Plesk/MS-DNS have a known issue when trying to push/pull zone updates - they don't.  You can update a zone in Plesk and that update will never transfer to MS-DNS.  You would need to go into MS-DNS and manually reload/transfer from the master, or delete and recreate the zone.  

That may or may not be your issue, though.  The present issue is that querying *.stunhosting.com shows no records for leonardasmith.com, including SOA, NS, or A.  That means you have nameservers set on your registration, but no accompanying zone on the servers you are pointing to.  Rather, the zone is there, but there are no records - the lookup did not fail, it just returned no answers.

FYI, the masked server in the query info is an internal recurse-only server at my office.  It is is known to work properly.
0
Steve BinkCommented:
Dammit, I *know* I attached that code...

Let's try again.
C:\Users\me>dig leonardasmith.com -tns

; <<>> DiG 9.7.0-P1 <<>> leonardasmith.com -tns
;; global options: +cmd
;; Got answer:
;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 47537
;; flags: qr rd ra; QUERY: 1, ANSWER: 2, AUTHORITY: 0, ADDITIONAL: 2

;; QUESTION SECTION:
;leonardasmith.com.             IN      NS

;; ANSWER SECTION:
leonardasmith.com.      86075   IN      NS      ns2.stunhosting.com.
leonardasmith.com.      86075   IN      NS      ns1.stunhosting.com.

;; ADDITIONAL SECTION:
ns2.stunhosting.com.    86075   IN      A       71.86.21.20
ns1.stunhosting.com.    86075   IN      A       71.86.21.19

;; Query time: 18 msec
;; SERVER: w.x.y.z#53(w.x.y.z)
;; WHEN: Sat Apr 03 00:01:02 2010
;; MSG SIZE  rcvd: 115


C:\Users\me>dig @ns1.stunhosting.com leonardasmith.com -tany

; <<>> DiG 9.7.0-P1 <<>> @ns1.stunhosting.com leonardasmith.com -tany
; (1 server found)
;; global options: +cmd
;; Got answer:
;; ->>HEADER<<- opcode: QUERY, status: REFUSED, id: 27248
;; flags: qr rd; QUERY: 1, ANSWER: 0, AUTHORITY: 0, ADDITIONAL: 0
;; WARNING: recursion requested but not available

;; QUESTION SECTION:
;leonardasmith.com.             IN      ANY

;; Query time: 67 msec
;; SERVER: 71.86.21.19#53(71.86.21.19)
;; WHEN: Sat Apr 03 00:01:17 2010
;; MSG SIZE  rcvd: 35


C:\Users\me>dig @ns1.stunhosting.com www.leonardasmith.com

; <<>> DiG 9.7.0-P1 <<>> @ns1.stunhosting.com www.leonardasmith.com
; (1 server found)
;; global options: +cmd
;; Got answer:
;; ->>HEADER<<- opcode: QUERY, status: REFUSED, id: 30812
;; flags: qr rd; QUERY: 1, ANSWER: 0, AUTHORITY: 0, ADDITIONAL: 0
;; WARNING: recursion requested but not available

;; QUESTION SECTION:
;www.leonardasmith.com.         IN      A

;; Query time: 67 msec
;; SERVER: 71.86.21.19#53(71.86.21.19)
;; WHEN: Sat Apr 03 00:01:28 2010
;; MSG SIZE  rcvd: 39

Open in new window

0
stubblefield83Author Commented:
Having Parallels do the fix
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Linux

From novice to tech pro — start learning today.