1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Cannot Remove DNS after Cancelling During Setup

Discussion in 'Plesk for Linux - 8.x and Older' started by ambaxter, Nov 20, 2007.

  1. ambaxter

    ambaxter Guest

    I canceled during a domain creation in plesk to start from the beginning with a different setup.

    when i went back to the beginning, the domain was not in the list, however it won't allow me to add it again because it says:

    Unable to create the domain {domain} because a DNS record pointing to the host {domain} already exists.

    Is there somewhere in Plesk or ssh that i can edit values so that i can bypass this error and add the domain again?

    I've tried several things and i cannot get around it.
  2. Bender

    Bender Guest


    You will have to remove all records related to old domain from Plesk database. They are stored in the dns_recs tables.

    You can get them all using the following sql query:
    mysql> select * from dns_recs where host like '%domain%';
  3. ambaxter

    ambaxter Guest

    I'm having two problems now:

    1. My database says permission denied for root using password

    2. What is the name of the database that contains the record I'm supposed to edit?

    thanks for your help
  4. koreshokk

    koreshokk Guest

    1. How do you access Plesk database. Do you use the following command:

    #mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa

    2. The database name is 'psa'.
  5. ambaxter

    ambaxter Guest

    Thanks for that help. I used the username admin and it worked.

    I created a mysldump and opened in text editor. I found that the domain in question is still in the PSA database in 38 locations.

    Now, I have no idea how I am going to remove all references safely!
  6. ambaxter

    ambaxter Guest

    What mysql command would I have to run in order to remove all instances of my domain from the dns_recs table?