Manual Update of Registrar Information: Update Company Name

In this entry, we will be focusing on manually updating a registrar’s company name. Be sure to take note 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:

Connecting to the db.

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

Connecting to the server.

 

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:

Example of inputting the command.

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:

Example of inputting the command.

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:

Example of inputting the commands.

 

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:

Example of the commit command.