Add special character domain names in cPanel

This article will guide you on how to add special character to #domain #names in #cPanel. A domain name can be up to 63 #characters (letters, numbers or combination) long plus the 4 characters used to identify the domain extension (.com, . net, . org). The only symbol character domain names can include is a hyphen (-) although the domain name cannot start or end with a hyphen nor have consecutive hyphens.

Domain names can only use letters, numbers, the fada character (acute accent) and hyphens (“-“). Spaces and other symbols are not permitted for use. Names cannot begin or end with a hyphen and are not case sensitive.

To customize my domain name:

1. Log in to your Domain.com, hosting account.

2. Go to the Domain Control Panel settings.

3. Click on the Website Builder Icon.

4. Right next to the Domain name you wish to change, click on Options.

5. A menu will drop down, click on Change Domain.

Read More




Plesk MSSQL remote connection

This article will guide you on how to enable and resolve #MSSQL related #errors. MSSQL remote connection is disabled in #Plesk servers by default.

To enable remote connections to MS SQL server:

1. Connect to the server via RDP.

2. Press the Start button, go to Microsoft SQL Server XXXX (where XXXX is the MSSQL version) and click the SQL Server XXX Configuration Manager.

3. Open the SQL Server Configuration Manager (Local) > #SQL Server Network Configuration menu and click the Protocols for MSSQLSERVERXXXX (where XXXX is the MSSQL version).

4. Make sure that the TCP/IP protocol has the Enabled status

5. Double-click the TCP/IP protocol, go to the IP Addresses tab and scroll down to the IPAll section.

6. Specify 1433 in the TCP Port field (or another port if 1433 is used by another MS SQL Server) and press the OK button:

Note: the specified port, e.g, 1433, must be opened in the firewall.

Read More




git fetch failed with exit code 1

This article will guide you on how to get rid of Git fetch error and also the causes of this error. To fix git fetch failed with exit code 1 error, simply add an explicit --force, checking for syntax error, and verifying the configuration file for its properness in case sensitivity. 

Read More




How to set rDNS in Windows Name Servers

This article will guide you on how to set #rDNS records in Windows Name servers. rDNS means mapping the address to a #hostname.

Nslookup is an MS-DOS utility that enables a user to look up the IP address of a domain or host on a network. The #nslookup command can also perform a reverse lookup using an IP address to find the domain or host associated with that IP address.

PTR record ( a pointer record ) is the certain type of DNS record that resolves an IP address to a host name. Getting reverse #DNS going is done by finding the PTR records in use by a DNS server. These PTR records will be managed by the company that is in control of the IP address which was assigned to you.

1. A pointer (PTR) record is a type of Domain Name System (DNS) record that resolves an IP address to a domain or host name, unlike an A record which points a domain name to an IP address. 

2. PTR records are used for the reverse DNS lookup. Using the IP address, you can get the associated domain or host name.

3. An A record should exist for every PTR record. 

4. The usage of a reverse DNS setup for a mail server is a good solution. 

5. While in the domain DNS zone the hostname is pointed to an IP address, using the reverse zone allows to point an IP address to a hostname.

Read More




psql to restore a text dump How to do it

This article will guide you on steps to perform  text dump restoration. Basically, psql restores a text dump in the same file format.

You can backup a single table, a #schema, or a complete database. Select the name of the backup source in the #pgAdmin tree control, right click to open the context menu, and select Backup… to open the #Backup dialog. 

The name of the object selected will appear in the dialog title bar.

In #PostgreSQL, you can restore a database in two ways:

i. Using psql to restore plain #SQL script file generated by pg_dump and pg_dumpall tools.

ii. Using pg_restore to restore tar file and directory format created by the pg_dump tool.


To Restore Postgres Database:

1. Restore a postgres database. $ psql -U erp -d erp_devel -f mydb.sql.

2. Backup a local postgres database and restore to remote server using single command: $ pg_dump dbname | psql -h hostname dbname.

3. Restore all the postgres databases.

4. Restore a single postgres table.

Read More




PowerShell Error clear

This article will guide you on how to tackle PowerShell $Error clear and method to clear errors with $Error. 

To clear error variable when you start #PowerShell, simply run $error. clear(). A downside of this method is that you lose all the errors that were generated before you clear the error variable.

To delete a variable, along with its value, use Remove-Variable or Remove-Item. This cmdlet does not delete the values of variables that are set as constants or owned by the #system, even if you use the Force parameter.

1. You can use this variable to represent an absent or undefined value in #commands and #scripts. 

2. #Windows PowerShell treats $null as an object with a value, that is, as an explicit placeholder, so you can use $null to represent an empty value in a series of values.

Read More





Focus on your business, not your servers.

Click Here to Learn More




Recent Post