Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

In this entry, we will be focusing on manually updating a registrar’s company name. Be sure to take of all the steps and follow them accordingly.

Step 1: Connect to db14.dns.net.za

Access the terminal (or Command Prompt) and the run the command ssh db14.dns.net.za and enter your password as per example below:

You will then need to input the following: eppsql-coza
As per the screenshot below.

Once your password is entered, you will be connected and ready to run the command of updating the Registrar’s company name.

Step 2: Run the Select command

Once you’re connected, you’ll be able to run the following command to view the information needed to update the a registrar’s company name:

select * from registrar where erp_ref = <registrar’s ID>;

In the screenshot below you’ll see how the command will look like:

This will display the following information:

  1. wid

  2. cdate

  3. iana

  4. url

  5. whois

  6. erp_ref

  7. status

  8. contact

  9. whois_password

  10. admin_contact

  11. tech_contact

  12. abuse_contact

From this, you will take the information under the tab contact then you’ll be able to run the following command:

*Note: End this and the queries to follow in this guide by pressing “Q”.

Step 3: Run the Select contact address command

select * from contact_address where contact = <input info from the contact tab>;

As per the screenshot below, you’ll see an example:

Once you run this command, it will display the following information:

  1. wid

  2. cdate

  3. contact

  4. real_name

  5. org

  6. street

  7. city

  8. province

  9. code

  10. country

  11. street2

  12. street3

Step 4: Run the Update command

After reviewing the information in contact address, you will then run the following commands to update the registrar’s company name:

  1. begin;
    (ensures a safe environment for the update in case a rollback is needed)

  2. update contact_address set real_name = <input requested update> where contact (select contact from registrar where erp_ref = <registrar’s ID>);

As per the screenshot below, you’ll see an example of how it will look:

Step 5: Confirm the update

Run the command to confirm the update: select * from contact_address where contact = <input info from the contact tab>;

After confirming, you’ll run the next command in step 6.

Step 6: Commit

Finally, once the update has been processed, you may now commit (or finalize) the update. Simply input the following:

commit;

As per the screenshot below, you’ll see an example of how it will look:

  • No labels