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:
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:
wid
cdate
iana
url
whois
erp_ref
status
contact
whois_password
admin_contact
tech_contact
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:
wid
cdate
contact
real_name
org
street
city
province
code
country
street2
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:
begin;
(ensures a safe environment for the update in case a rollback is needed)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: