Category Archives: System Engineering

How To Repair MySQL Database?

A MySQL database is a relational database management system (RDBMS) that utilizes structured query language (SQL) to store, retrieve, and manage structured data.

MySQL databases consist of tables organized into rows and columns, with each table representing a specific data entity and each row representing a single record or entry. MySQL is widely used for web applications and websites, offering features such as data integrity, transaction support, scalability, and robust security mechanisms.

It is an open-source database system, making it accessible and customizable for a wide range of applications and industries. MySQL is known for its reliability, performance, and ease of use, making it a popular choice for developers and businesses seeking a powerful and cost-effective solution for managing their data.

Repairing a MySQL database involves several steps to identify and fix any issues that may be causing corruption or damage to the database. But to fix a database you need to access it. To access a MySQL database on cPanel, you typically follow these steps:

  1. Log in to cPanel: Open your web browser and navigate to your cPanel login page. This is usually accessed by appending “/cpanel” to your domain name (e.g., yourdomain.com/cpanel). Enter your cPanel username and password to log in. If this doesn’t works, then alternatively you can access the cPanel from your hosting’s account page.
  2. Locate the MySQL Databases Icon: Once logged in, you’ll see a variety of icons representing different features and functions available in cPanel. Look for the “MySQL Databases” or “Databases” icon, which is usually located under the “Databases” section.
  3. Access MySQL Databases: Click on the “MySQL Databases” icon to access the MySQL Databases interface. This interface allows you to manage your MySQL databases, including creating new databases, adding users, and assigning privileges.
  4. Locate Your Database: In the MySQL Databases interface, you’ll see a list of existing databases under the “Current Databases” section. Each database will have a name preceded by your cPanel username and an underscore (e.g., username_database1). Locate the database you want to access.
  5. Access phpMyAdmin: To interact directly with your MySQL database, click on the “phpMyAdmin” icon, which is usually located next to the database name. phpMyAdmin is a web-based application that provides a graphical user interface for managing MySQL databases.
  6. Log in to phpMyAdmin: After clicking on the phpMyAdmin icon, you’ll be directed to the phpMyAdmin login page. Enter the username and password for the MySQL database user associated with the database you want to access. This may be different from your cPanel login credentials.
  7. Navigate Your Database: Once logged in to phpMyAdmin, you’ll see a list of databases on the left-hand side of the screen. Click on the name of the database you want to access to expand it and view its tables. You can then click on individual tables to view and manage their contents.
  8. Perform Database Operations: From the phpMyAdmin interface, you can perform various database operations, such as running SQL queries, creating or modifying tables, importing or exporting data, and managing users and permissions.
  9. Log Out and Close phpMyAdmin: After you’ve finished working with your database, be sure to log out of phpMyAdmin to secure your data. You can do this by clicking the “Log Out” button in the phpMyAdmin interface. Once logged out, you can close the phpMyAdmin window or tab.

By following these steps, you can easily access and manage your MySQL databases on cPanel using phpMyAdmin.

Here’s a general guide on how to repair a MySQL database:

Backup Your Database: Before making any changes to your database, it’s essential to create a backup to ensure that you can restore your data in case anything goes wrong during the repair process. You can use MySQL’s built-in tools or third-party backup solutions to create a backup of your database.

Identify Database Issues: Use MySQL’s diagnostic tools to identify any issues or errors in your database. You can check the MySQL error log, run diagnostic queries, or use tools like MySQL Workbench to analyze the database’s structure and integrity.

Use MySQL Check Table Command: MySQL provides a built-in command called CHECK TABLE that allows you to check the integrity of tables in your database and repair any corruption or damage. You can use this command to check individual tables or the entire database.

CHECK TABLE table_name;

Use MySQL Repair Table Command: If the CHECK TABLE command identifies any issues with your tables, you can use the REPAIR TABLE command to fix them. This command repairs corrupted tables by rebuilding the table’s indexes and data structure.

REPAIR TABLE table_name;

Use MySQL Repair Database Command: If you suspect that your entire database is corrupted, you can use the REPAIR DATABASE command to repair all tables in the database at once.

REPAIR DATABASE database_name;

Use MySQL Table Maintenance Operations: MySQL provides additional table maintenance operations, such as OPTIMIZE TABLE and ANALYZE TABLE, which can help improve the performance and integrity of your database. You can use these commands periodically to optimize and maintain your database.

OPTIMIZE TABLE table_name;

ANALYZE TABLE table_name;

Monitor Repair Progress and Errors: During the repair process, monitor the progress and check for any errors or warnings that may occur. This will help you ensure that the repair is successful and that no further issues arise.

Verify Database Integrity: After repairing your database, verify its integrity by running diagnostic queries and checking for any remaining issues. Ensure that your data is intact and that the database functions properly.

Regular Maintenance and Monitoring: To prevent future database issues, implement regular maintenance tasks such as backups, monitoring, and optimization. Regularly check for errors, monitor database performance, and address any issues promptly to keep your MySQL database healthy and reliable.

By following these steps and best practices, you can repair your MySQL database and ensure that it remains stable, reliable, and free from corruption or damage.

How cPanel Accounts Are Created On WHM Of VPS & Dedicated Server?

cPanel equips you with an easy interface to manage your domains and websites. The cPanel account at Sangkrit.net gives you access to several free applications to let you easily make different types of websites in a very short interval of time and that too without any technical skills.

But do you know you can also create separate cPanel hosting accounts on your Sangkrit.net VPS or Dedicated Server by using the WHM interface? Each cPanel account can have its primary domain and each can be given the privilege to host multiple domains. You can also set resource limits over new cPanel accounts. This includes disk space, bandwidth, email accounts, and more. You can either use the package defaults or customize these limits as per your requirements.

To create a new cPanel account you will need to set the following things:

  1. Domain: The domain name for the new cPanel account.
  2. Username: A username for the new account.
  3. Password: A strong password for the new account or you may also use the password generator.
  4. Email: An email address associated with the account.
  5. Package: The hosting package or resource allocation for the account. If needed, you can create custom packages in WHM.
  6. Settings: You may also configure any additional settings such as selecting a theme, enabling or disabling DNS clustering, and more.

Then simply follow these steps to create a new cPanel account:

  1. Login to your Sangkrit.net Account
  2. Click the Servers tab
  3. Click Manage button
  4. You will be directed to your server’s admin panel
  5. Click Account Functions or use the search box to find it
  6. Click Create a New Account
  7. Fill up the mandatory fields and click Create

Now the Web Host Manager will display you a results page outlining your new Account. Next, you will see Account Creation Complete!!! at the bottom of the screen. Simply repeat the steps to create more cPanel accounts.

The accounts you create are accessible from the Servers tab on your Sangkrit.net products page. Go back to step no. 1, and you will see all your cPanel accounts are listed there. The new account holders would be able to log in to cPanel with the provided username and password to manage their website, email, and other hosting-related services.

How To Allocate Resources To Your Websites On Dedicated Server & VPS?

Allocating and managing resources means creating hosting packages containing a set resource usage allowance for domains and websites you want to host on your dedicated server or VPS. You can set the maximum amount of resources that a domain can use so that other websites won’t get affected by it. 

  • If you are running only one website then you may simply allot all server resources to it
  • If you are running multiple websites then you may either set a resource quota for each website or let all your websites freely use server resources

This lesson will guide you in creating new hosting packages, allocating resources, and assigning them to your domains.

Log in to your Sangkrit.net Account then follow these steps:

  1. Visit Products page
  2. Click the Servers tab
  3. Next to the account, you want to use, click Launch
  4. From the management interface, next to the cPanel Site,
  5. Click Manage Server (WHM) 
  6. Click Proceed

On your server’s home, add a new package:

  1. Find the Packages section on the left sidebar,
  2. Click Add a Package

Define regulations such as:

  1. Disk space
  2. Max domains
  3. Max bandwidth usage
  4. Max database usage
  5. Max email, etc

As required by you, each or selective option can be left to unlimited. Now, click the blue color Add button at the bottom of the screen. That’s it, your package has been successfully created.

This way you can create as many packages as you want, and each package will work as a separate cPanel hosting account. You can edit or delete any packages by revisiting the packages page from the left sidebar of your dedicated server‘s home. The same steps also work for virtual private servers.

How To Make Your Website On A Dedicated Server?

A dedicated server is the most advanced form of web hosting where the client leases an entire server that is not shared with anyone else. It can handle a huge load of traffic and heavy page requests. Thus, it prevents your website from going down at the time when your traffic starts to rise.

Setting up a dedicated server is easy. Just subscribe to your choice of dedicated server here,

and then follow these steps:

  1. Login to your Sangkrit.net Account
  2. Click the Servers tab
  3. Click Launch (next to the account you want to use)
  4. Click Set Up (for the account you want to use )
  5. It will offer you a form as given below:
SERVER NAMEGive a name to your new server.
USER NAMEType in username to log in to your server.
Create a password for your username to log in to your server.Type in your username to log in to your server.
DATA CENTER REGIONSelect the location where you want to keep your server.
IMAGESelect the operating system you want to use.
CONTROL PANELSelect cPanel.
IMPORT YOUR SITESYou may select any old cPanel shared hosting accounts that you want to import to your new server.

Fill in the details, and then click the Create button. 

This will take a few seconds to set up, and then you can access your cPanel by following these steps:

  1. Log in to Account Manager 
  2. Click the Servers tab
  3. Next to the cPanel account, which you want to use, click Launch

To make, manage, or transfer a website –

Visit the cPanel of the domain name (which you have created in the above-given steps) and follow these steps:

  1. Log in to Account Manager 
  2. Click the Servers tab
  3. Click the cPanel site you want to use

That’s it, now you may install WordPress to startup your website or eCommerce store. The same steps work for all virtual private servers.

How To Create A cPanel Account To Host Domain On Your Dedicated Server?

For hosting your domain names, you are required to create at least one cPanel account on your dedicated server.

What is cPanel?

A cPanel offers you a user-friendly interface for hosting your domains, managing your website files, as well as installing web-building applications like WordPress, etc.

The cPanel at Sangkrit.net offers you more than a hundred website maker apps as well as free backup solutions.

First, complete the basic setup of your dedicated server, and then you will be able to create multiple cPanel hosting accounts and associate them with specific domain names of yours.

Creating a cPanel Hosting Account:

  1. Login to your Sangkrit.net Account
  2. Click the Servers tab
  3. Click Manage button

You will be directed to your server’s admin panel, here –

Use the left-side search box to find List Accounts

  1. Click List Accounts
  2. Click Create a New Account button

It will present you with a form where you can type in your domain name and select options for the cPanel account you are creating. Finally, click the ‘Create’ button to create a new cPanel account for your domain.

After you have created a cPanel account, you can access it by following these steps:

  1. Visit your Sangkrit.net Account
  2. Click the Servers tab

And, you will see that your cPanel account is listed in the Servers tab.

Note: Some operating systems don’t support cPanel. So, while filling the cPanel setup form (as shown in step five), make sure to check for any possible warnings in the operating system field.

Make sure that your domain name is pointed towards your dedicated server. Read these lessons:

  1. How to point a domain name to a dedicated server
  2. What is my dedicated server’s IP address?

To add more domains, you might need to enable the remote domains on your dedicated server:

The same steps also work on all virtual private servers.

How To Host Multiple Domains & Websites On VPS & Dedicated Server?

After you have subscribed to a dedicated server, the first thing you need to do is set it up for your main domain. Afterward, you can add multiple domains to your server or create other cPanel hosting accounts on your server to add domains.

For Hosting Multiple Domains From Server’s Admin Panel

This option lets you create different cPanel accounts for each of your domain names.

While creating any new cPanel account you can allow it to host multiple domains or simply keep it limited to only one domain. You can do this at your discretion by following these steps:

  1. Login to your Sangkrit.net Account
  2. Click the Servers tab
  3. Click Manage button
  4. You will be directed to your server’s admin panel
  5. Use the left-side search box to find the List Accounts page
  6. Click List Accounts
  7. Click Create a New Account button

It will present you with a form where you can type in your domain name and select options for the new cPanel account you are creating.

Finally, click the ‘Create’ button.

Follow the same steps for creating separate accounts for your domains.

For Hosting Multiple Domains On A cPanel Account

You can allow any cPanel account on your dedicated server to host multiple domains. This thing is done while creating new cPanel accounts (as we have done above) or you can edit any old account.

To edit any old cPanel account simply visit the ‘List Accounts’ page (as shown in step no. 6 above).

To host multiple domains on cPanel:

  1. Log in to Account Manager 
  2. Click the Servers tab
  3. Next to the cPanel account, which you want to use, click Launch

Next, on the cPanel home page:

  1. Scroll down to the Domains section
  2. Click ‘Addon Domains
  3. Type in the domain name
  4. Click the ‘Add Domain‘ button

Each domain added by you will have its directory where you can upload your website or install WordPress. The web directory of your domains can be accessed from your cPanel’s home page -> File Manager option, present in the Files section.

Make sure you update your domain name servers to make it point to your dedicated server.

How To Get Helped?

In case you need any kind of assistance in hosting your domain names on your dedicated server, simply comment below or use the Helpline number.

The Difference Between cPanel & WHM Hostings & Servers

Linux VPS or Dedicated Server provides you with WHM to manage your website hosting accounts. WHM allows you to host multiple websites on different domains but that’s what cPanel may also do. So what is the difference?

The difference is that WHM allows you to set up separate cPanel accounts for websites and not only this but you can assign a package to limit the resource usage of websites hosted on your server.

Now if you only have one single website to host on your server and you want to use all your resources on that specific website then you simply set cPanel without assigning any package to it.

WHM

WHM stands for Web Host Manager. It is the main control panel for setting up a server and not the websites on the server, but the server itself. Setting up a website is the second step which you do after creating new cPanel accounts from the WHM of your server.

The Differences Between WHM & cPanel

WebHost Manager, or WHM, provides administrative control of your dedicated or Virtual Private Server (VPS). You use WebHost Manager to create individual accounts, add domains to your server, manage hosting features, and perform basic system and control panel maintenance

The main features of WHM are:

  1. Server-Level Control Panel: WHM is designed for hosting providers and server administrators. It’s used to manage the server as a whole and to create and manage cPanel accounts for individual hosting clients.
  2. Server Management: WHM focuses on server-level tasks, such as server configuration, software installation, security settings, and resource allocation to individual cPanel accounts.
  3. Reseller Hosting: WHM allows for the creation of reseller hosting accounts. Resellers can use cPanel to create and manage their own hosting clients and accounts.
  4. Security: WHM offers server-level security settings and access controls for managing cPanel accounts, including the ability to enforce security policies for all hosted accounts.
  5. Resource Allocation: WHM lets administrators allocate resources like disk space, bandwidth, and other server resources to cPanel accounts.
  6. User Authentication: WHM is accessed by administrators using their own login credentials. It’s used to create and manage cPanel accounts, each with its own set of credentials.
  7. Typical Users: WHM is used by hosting providers, data center operators, and server administrators who manage multiple hosting clients or accounts.
cPanel

The cPanel is designed for managing particular domains or hosting accounts on your server. End users can control everything from adding/removing email accounts to administering MySQL databases etc.

The main features of cPanel are:

  1. End-User Control Panel: cPanel is designed for end-users, typically website owners, and administrators who manage their hosting accounts. It provides an easy-to-use graphical interface for various website and account management tasks.
  2. Website Management: cPanel is primarily used to manage individual websites and their associated settings, such as creating and managing email accounts, databases, file management, and domain settings.
  3. User-Level Features: cPanel offers features like website backups, email management, website statistics, domain management, and one-click application installations (e.g., WordPress).
  4. Security: While cPanel provides security features, it focuses on the security of individual hosting accounts and websites.
  5. Resource Usage: cPanel allows users to monitor and manage their resource usage, including bandwidth and storage.
  6. User Authentication: Users log in to cPanel with their credentials.
  7. Typical Users: cPanel is used by website owners, bloggers, small business owners, and anyone with a web hosting account.

cPanel is the end-user control panel used by individuals and businesses to manage their website and hosting account, while WHM is the server-level control panel used by hosting providers and server administrators to manage server resources, create and manage hosting accounts, and enforce security and resource allocation policies for multiple cPanel users. The two often work in tandem, with WHM allowing administrators to create and manage cPanel accounts for their clients.

How To Resell Hostings After Subscribing A Dedicated Server?

If you are a web developer looking forward to setting up your own reseller hosting then this lesson will guide you step-by-step in creating your own reseller account on a Dedicated Server or VPS of Sangkrit.net.

What is a Reseller Account?

A reseller account is a special account created from WHM of a Dedicated Server or VPS. It is a cPanel account with more privileges.

The system allows reseller accounts access to a limited version of the WHM interface, which allows them to manage the cPanel accounts that they sell.

A reseller can allocate system resources on individual cPanel hosting accounts and then sell them to his clients.

To start up with a reseller account, you must own a Dedicated Server or VPS. Read our lesson on configuring a server at Sangkrit.net to start with WHM and cPanel.

How To Manage Reseller Accounts?

You can manage reseller accounts using one of the following WHM user interfaces:

  • The Resellers section (Home -> Resellers) provides you access to all of the reseller features.
  • The Reseller Center interface (Home -> Resellers -> Reseller Center) allows you to add or remove reseller privileges and provides links to all of the other reseller features.

By default, the system grants a set of limited privileges to reseller accounts. But you can add more privileges to any reseller account using the Edit Reseller Nameservers and Privileges interface present in Home -> Resellers -> Edit Reseller Nameservers and Privileges section.

How Nameservers Are Configured On Dedicated Server & VPS?

Nameservers are used for masking IP addresses to domain names.

However, you can directly mask an IP address to different records of your domain name to make it functional. But doing a nameserver setup lets you enlist all domain records in your nameservers to use them on your domain (website & email, etc).

Configuring Nameservers On Dedicated Server (Via WHM):

  1. Log in to your Sangkrit.net account
  2. Open the Products page and click the Servers tab
  3. Click Launch (Next to the account, you want to use)
  4. Click Manage Server (WHM) 
  5. Click Proceed

Once, you are logged in to your server, follow these steps:

  1. Navigate to WHM’s Nameserver Selection interface via WHM -> Home -> Service Configuration -> Nameserver Selection
  2. Select the desired nameserver software
  3. Click Save

To configure your default nameservers:

  1. Navigate to WHM’s Basic WebHost Manager Setup interface via WHM -> Home -> Server Configuration -> Basic WebHost Manager Setup
  2. Enter the desired nameserver names in the text boxes
  3. Click Save

Remember, the name must prefix, a dot (.), and your domain. For instance: ns1.example.com and ns2.example.com.

Next, you will need to add the IP address to your nameservers:

  1. Navigate to WHM’s Add a New IP Address interface via WHM -> Home -> IP Functions -> Add a New IP Address
  2. Here you may either enter the main IP address or the IP address range (if you have one) in the New IP or IP range to add a text box
  3. Enter the subnet mask in the Select a subnet mask for the IP or IPs above to use the text box
  4. Enter any IP addresses that you wish to exclude in the IPs and IP ranges to exclude from the range of new IPs text box
  5. Click Submit

Creating A or AAAA entries on your nameservers:

  1. Access WHM’s Basic WebHost Manager Setup interface via WHM -> Home -> Server Configuration -> Basic WebHost Manager Setup
  2. In the Nameservers text box, click Configure Address Records
  3. Update the IP addresses in the appropriate text boxes
  4. Click Configure Address Records
  5. Click Close

Repeat the same steps for each of your nameservers.

For creating entries of your hostname:

  1. Again, move to WHM’s Add an A Entry for Your Hostname interface via WHM -> Home -> DNS Functions -> Add an A Entry for Your Hostname
  2. Enter your server’s IP address in the text box
  3. Click Add Entry

Next, you will need to register the same nameservers on your Sangkrit.net account from your domain management section. You will need to change the nameservers of your domain to use these new domain nameservers.

Simply log in to your Sangkrit.net account and follow these steps:

  1. Visit your products page, in the Domains heading, click Manage
  2. Locate the domain for which you wish to set up your nameservers
  3. Click the settings icon and select Manage DNS.
  4. Click the Settings tab and click Manage under the Host Names setting
  5. Click Add Hostname and enter the primary nameserver’s name (for example, ns1)
  6. Enter the primary nameserver’s IP address in the IP Address text box and click Add.
  7. Now, repeat the same steps for your secondary nameserver, this time use another nameserver such as ns2
  8. Click Save. Then, click Edit Nameservers and select Custom option
  9. Enter the full names of your two nameservers. (For instance: ns1.example.com and ns2.example.com)
  10. Click OK and then Save your changes

That’s it. The DNS propagation takes some time to spread the domain’s new DNS records across the internet. So, allow it twenty-four hours and your settings will start to work.

How To Configure Reverse DNS On Your WHM Server?

DNS i.e., the Domain Name Server also known as Domain Name System is the hierarchical and decentralized system of identifying systems reachable through the Internet Protocol networks.

It works by looking up your website by finding its domain name and then locating its associated IP address. Whereas, the reverse DNS first looks up for an IP address and then locates the associated domain name.

The reverse DNS is actually a process that involves the conversion of an IP address back into a domain name. While the traditional DNS translates domain names (like – example.com) into IP addresses (like 132.0.3.1), reverse DNS does the opposite – it translates IP addresses into domain names.

The Reverse DNS is mainly used for:

  1. Email Servers: Reverse DNS is commonly used by email servers to verify the legitimacy of incoming emails. Many email servers check if the reverse DNS entry of the IP address sending the email matches the domain from which the email claims to be sent. This helps in preventing spam and identifying potential sources of malicious or fraudulent emails.
  2. Network Troubleshooting: Network administrators use reverse DNS to understand the domain names associated with specific IP addresses. This can aid in troubleshooting network issues, identifying the source of network problems, or verifying the ownership of particular IP addresses.
  3. Security: Reverse DNS can provide additional information about the server sending traffic to your network. It’s used in security measures to analyze and filter incoming traffic based on the domain names associated with the IP addresses. This can be helpful in identifying and blocking potentially harmful or unauthorized access attempts.
  4. Logging and Analytics: Some systems and applications use reverse DNS to log the domain names of incoming connections, providing more meaningful information in logs and analytics.
  5. Online Reputation: Some online services use reverse DNS as a factor in determining the reputation of an IP address. A well-configured reverse DNS entry can contribute positively to an IP address’s reputation, while a lack of reverse DNS or misconfigured entries might affect it negatively.

Setting up reverse DNS involves creating a PTR (Pointer) record in the DNS zone files, and linking an IP address to a domain name. This PTR record helps establish a connection between the IP address and the domain name it represents.

It’s important to note that the accuracy and presence of reverse DNS entries can vary. Some organizations maintain proper reverse DNS entries for their IP addresses, while others might not. Additionally, the process of setting up and managing reverse DNS might involve coordination with the hosting provider or internet service provider.

But at Sangkrit.net you don’t have to worry about that, you can easily setup the reverse DNS by following a few easy steps, and the round-the-clock online support is also available to help you in case you feel stuck anywhere.

How To Setup Reverse DNS?

At Sangkrit.net, you can easily set up a reverse DNS (RDNS) lookup for your Dedicated Server. To start, simply login to your Sangkrit.net account and follow these steps:

  1. Visit your My Products page
  2. Click Servers
  3. Next to your server, click Manage
  4. Enter the domain name you want to be associated with the server IP address, in the DNS record field
  5. Now click Update

The system will start an automated process of completing the reverse DNS setup. This can take up to 48 hours for the changes to propagate to your server.

If you have multiple IP addresses on your server, repeat the process for each IP address you want to set up Reverse DNS for.

Now the traditional process of setting up reverse DNS is a little bit different, you may follow that also:

  1. Log in to WHM: Access your WHM control panel using your administrator credentials.
  2. Navigate to “DNS Functions”: In WHM, search for or locate the “DNS Functions” section. This is where you’ll manage DNS-related settings.
  3. Edit DNS Zone: Under “DNS Functions,” click on “Edit DNS Zone.” This will allow you to modify the DNS zone files for the domain.
  4. Select IP Address: Choose the IP address for which you want to set up Reverse DNS (PTR record). Click “Edit.”
  5. Add PTR Record: In the DNS zone editor, you’ll see the existing DNS records. To add a PTR record, scroll down to the “Add New Entries Below this Line” section.
  6. Enter PTR Record Details: Fill in the following information to create the PTR record: Name: Enter the last segment of the IP address in reverse, followed by “in-addr.arpa.” For example, if the IP is 192.0.2.1, the name would be “1.2.0.192.in-addr.arpa.” TTL: Set the Time to Live for the record.
  7. Save Changes: Once you’ve entered the PTR record details, click the “Save” or “Save Zone File” button to save the changes.
  8. Update DNS Zone: After saving the changes, WHM will update the DNS zone file with the new PTR record.
  9. Verify PTR Record: You can verify the PTR record by using the “dig” command in the terminal or through online DNS lookup tools. It might take some time for the DNS changes to propagate across the internet.

You should also know that, when you run your own email server, and configure DNS to point to your domain name, there are some servers that are going to reject emails from IP addresses when not having an rDNS. The reverse DNS also helps when you need to troubleshoot your network while running a traceroute etc.

Reverse DNS is a useful mechanism that adds an extra layer of information and security to online communication and networking processes.

How To Backup And Restore Your Website On cPanel Hosting Or Server?

cPanel provides you with powerful website backup and restore options with which you can back up your complete website, get backup notifications, and then easily restore your website whenever needed. There are two backup options in cPanel: Full Backup and Partial Backup.

Full backup creates an archive of all website files and configurations set on your website. This can be used for moving your account from hosting to a dedicated server or VPS or to keep a local copy of your website files.

Full backups cannot be restored through your cPanel interface. Hence, to restore full backups you have to manually upload files and import the MySQL database.

cPanel of Sangkrit.net provides you with all video tutorials and you can easily view them right from the home screen of your cPanel.

Partial backup is another feature that allows you to back up your website but here you can select what you want to backup. You can separately backup and download your Home Directory, MySQL Databases, Email Forwarders, and filters.

Backups can be downloaded or restored from the ‘Backups’ page, you can access it from the Files section of your cPanel.  It allows you to download backups to your computer as a zipped copy of either your entire site including your home directory, databases, email forwarders configuration, and email filters configuration, or one of the previously mentioned parts of your site.

How To Backup Your Website?

Login to your Sangkrit.net account and launch your web hosting cPanel.

My Account

Enter the username & password and log in to your cPanel.

cPanel Login

Click ‘Backup Wizard’ from the ‘Files’ section.

Backup Wizard

It presents you with backup and restore options. (The restore option allows you to restore your website files or database from earlier generated backup files.).

Restore & Backup Page

Again it presents you with two options: Full Backup and partial site backups.

Full backups create an archive file containing files and configurations of your website. Whereas partial backup allows you to separately create and download backups of website files, databases email forwarder filters, etc. The good thing about partial backups is that cPanel provides a quick direct feature for restoring partial backups.

cPanel Full & Partial Backup Options

Select a backup option, wait for some time and it will provide you download links for your backup files.

cPanel Partial Backup

If you have selected full backup then you may also enable email notification (on the full backup screen) and the system will send you an email upon completion of your website backup.

cPanel Full Backup

It’s not necessary to download backup files at the same time. All backups are saved in your server and can be accessed from the backups page of your cPanel’s ‘Files’ section.

You can manage/download backups anytime by visiting cPanel and clicking the ‘Backups’ icon. It provides you with options for downloading saved backups. Also, you can generate or restore backups from there itself.

How To Restore a Backup?

As we have already said cPanel provides you the built-in option for restoring backup files (generated manually or via cPanel’s Partial Backup option) for the home directory, MySQL databases, and Email Forwarders and filters.

From your cPanel home, Click ‘Backup Wizard’ under the ‘Files’ section

Backup Wizard

Select the restore option, it allows you to restore your website files or database from earlier generated partial backup files.

Restore & Backup Page

You can select what to restore like your Home Directory, MySQL Databases, Email Forwarders, and filters.

cPanel Restore Wizard

For Example: Suppose you want to restore your MySQL database from its downloaded backup file on your computer’s hard disk.

cPanel Backup Browse & Upload

Simply click ‘MySQL Databases’ and use the ‘Browse’ and ‘Upload’ buttons to restore the backup back to your server.

Transferring Your Websites Between Hostings On Your Server

The manual transfer requires you to download files as well as the database and then upload them to your new server. But there is another method on dedicated servers that allows you to copy your account directly from your previous cPanel host.

What You Will Need?

To start you will need your server address (IP or FQDN) which you can either find yourself or get from your service provider. Second, you are going to need the username and password of your cPanel account.

How To Start?

Log in to your SANGKRIT.net account and follow these steps:

  1. Open the Products page and click the Servers tab
  2. Click Launch (Next to the account, you want to use)
  3. Click Manage Server (WHM) (visible next to cPanel Site)
  4. Click Proceed

On your WHM panel use the left side navigation search box to find the page ‘Copy an Account From Another Server With an Account Password’. On this page, you will see fields for the Server to copy from, username, and password.

On the ‘Server to Copy’ field enter the IP address of your remote server. Next, fill in the username and password then press the ‘Copy Account’ button.

In case you have an additional IP address assigned to your server. You can also select the ‘Give new account an IP address’ option to get the available IP address automatically assigned to your new account.

How Does It Work?

The server will try to connect to the remote cPanel server and copy the specified account.

It is going to check the remote server every minute till the backup is completed. So at the time the copy process goes do not close your web-browser tab.

How Much Time Does It Take?

The time it takes depends on the size of your account on the remote server and once the account is successfully copied you will see the account restored message.

How To See Your Newly Transferred & Restored Account?

Once you see the account restored message at the bottom of the page. Use the top-left search box to type ‘list’, then click on the ‘List Accounts’ option. You should now see the copied account on your server.

How To Make It Work?

Once you have made sure that your old account has been copied to your new server at SANGKRIT.net. You will need to update your domain’s name servers to make your domain point to this new location.

In case you need any kind of assistance in transferring your website, simply contact the support of SANGKRIT.net via the Support Page or Helpline numbers.

Fixing The Disabled Admin Root Access On Your Server

When a user has root access, they have the highest level of privileges on the system. This means they can perform tasks that can affect the entire system, such as modifying system configuration files, installing or uninstalling software, and managing user accounts.

On your VPS or Dedicated Server, for security reasons, your dedicated server is provisioned with disabled admin/root access. But you can enable it by following these steps:

  1. Login to your Sangkrit.net account
  2. ​​Navigate to your My Products page
  3. Click Servers
  4. Next to the Generation 4 server, click Manage
  5. Select Settings from the top of the page in your account dashboard
  6. In the access section, next to the admin access, click Manage
  7. Select Enable Admin Access (this is actually root account sudo access) 
  8. Now click Save
  9. Admin access is now enabled

Next, Establish a connection:

Launch your SSH client, enter the host i.e. your domain name or IP address, and your SSH port number (which by default is 22) to establish the SSH connection.

Now you will be asked to enter the FTP details. As prompted for that, enter your primary FTP username and password and click GO or whatever action button is there in your client. That’s it. Your client will now make a connection.

The Instant Dynamic Caching System Of Sangkrit.net Hosting & Servers

Now every server owner at Sangkrit.net can easily accelerate his websites by caching both static and dynamic content and reducing the load on his servers.

How Dynamic Caching Works?

Dynamic caching works by temporarily storing the dynamically generated content in a cache. When a user requests a particular piece of content, the web server first checks if a cached version of that content is available. If it is, the server serves the cached content, which is faster than generating it from scratch. If not, the server dynamically generates the content, serves it to the user, and caches it for future requests.

How To Enable Dynamic Caching On Your Server?

After you buy any Linux-based VPS or Dedicated Server, you can enable caching for yourself and also your clients by providing a caching button on every hosting account you make on your server. You and your users may use this button to turn on catching, simply follow these steps:

  1. Login to your Sangkrit.net account
  2. Visit your ‘My Products’ page
  3. Click the ‘Servers’ option
  4. Next to ‘Server Actions’ click ‘Launch WHM’
  5. Open ‘Nginx Manager’ from the software section menu on the left
  6. Enable the caching

The page allows you to enable the caching on any or all hosting accounts running on your server You can also enable cache by default for all hosting accounts or click the ‘User Settings’ tab to enable NGINX caching selectively on accounts. It also provides you the option to selectively or collectively delete your server’s cache.

Nginx Cache i.e. “HTTP Caching” Or “Proxy Caching

Nginx cache, often referred to as “HTTP caching” or “proxy caching,” is a powerful feature that allows you to temporarily store and serve web content more efficiently. It is designed to reduce the load on web servers, decrease page load times, and improve the overall performance and user experience.

Every cPanel user account created by you on your VPS or Dedicated Server also gives an option to enable caching over the websites running on the same server but have different hosting accounts.

You can turn on, turn off, or delete the cache on any website simply from the server’s main page on your Sangkrit.net account.

How To Use The Resources Of Multiple Servers Together?

The Configuration Cluster is a server interface that enables you to link the master server to other additional servers. In the context of cPanel and WHM hosting, a “Configuration Cluster” or “Server Configuration Cluster” typically works as a feature that allows multiple cPanel & WHM servers to work together as part of a cluster.

It provides redundancy, which helps ensure that if one server in the cluster fails, another can take over, minimizing service disruption. Clustering can be used for load-balancing web traffic. It distributes incoming web requests across multiple servers, preventing any single server from becoming overwhelmed with traffic.

This clustering is often used to distribute the load, improve redundancy, and enhance the scalability of a hosting infrastructure. cPanel provides a feature known as “Server Clusters” to facilitate this.

On your VPS or Dedicated Server, you can easily add more servers to the configuration cluster by following these steps:

  1. Visit WHM’s DNS Cluster interface via WHM -> Home -> Clusters -> DNS Cluster
  2. Click to Enable DNS Clustering
  3. Click the Change button
  4. Click Return to Cluster Status
  5. Select the server to add to the DNS cluster
  6. Add a new server to the cluster menu
  7. Click Configure
  8. In the Remote cPanel & WHM DNS host text box of the cPanel DNS Remote Configuration interface
  9. Enter the hostname or IP address of the nameserver to add to the cluster
  10. Enter the WHM username for the nameserver
  11. Enter the nameserver’s API token hash or remote access key in the Remote server access hash text box
  12. To automatically configure the DNS cluster on the remote server – Select Setup Reverse Trust Relationship
  13. To synchronize the new server with other nameservers simply select Synchronize Zones Immediately option
  14. To specify the server’s DNS role, select a setting from the DNS Role menu
  15. Click the Submit button

For deleting a server from the DNS cluster:

  1. Visit the DNS Cluster interface via WHM -> Home -> Clusters -> DNS Cluster
  2. In the Modify Cluster Status text box, select Disable DNS Clustering
  3. Click Change, then Click Return to Cluster Status
  4. Log in to the servers that remain in the cluster
  5. Navigate to the DNS Cluster interface via WHM -> Home -> Clusters -> DNS Cluster
  6. Locate the server that you wish to delete
  7. Click the x icon under the Actions heading

To make changes in your server in the DNS cluster:

  1. Locate the server that you wish to edit
  2. For DNS changes – In the DNS Role menu, select a new role for the server
  3. Click the save icon to save your changes
  4. Next, to edit a server’s configuration settings
  5. Click the edit icon under the Actions heading
  6. The cPanel DNS Remote Configuration interface will appear
  7. Make your changes to the server’s settings
  8. Click the Submit button

Remember that the API tokens can be generated in the WHM’s Manage API Tokens interface. Simply navigate to WHM -> Home -> Development -> Manage API Tokens page.

If you own a Linux-based server at Sangkrit.net, you can simply copy the changes made to the master server to all other servers by navigating to WHM -> Home -> Server Configuration -> Update Preferences settings on the master server. This simply outs all changes to all servers on the cluster.

Another feature called DNS clustering allows multiple cPanel & WHM servers to synchronize their DNS zone data. When a change is made to a DNS record on one server, it is automatically replicated to the other servers in the cluster. This provides redundancy and load balancing for DNS requests.

cPanel & WHM allows you to set up specialized DNS-only servers that manage DNS records for your websites. These servers work in conjunction with your primary cPanel & WHM servers to handle DNS queries, improving performance and reliability.

Starting Your Own Customer Relationship Management System (CRM) On Your Domain At Sangkrit.net

CRM, also known as a customer relationship management system is a type of software that can be installed on your domain to keep track of all records, sales, statistics, and tasks assigned to your people.

It also provides you with a planner, and event manager to keep a record of important dates, and delivery deadlines for projects you are working on and upload/share documents etc.

Apart from this, it can also have a built-in mailing system to let you and your people interact with the team or potential customers. It uses data analysis about customers’ history to improve business relationships, specifically focusing on customer retention and ultimately driving sales growth.

The initial cost for CRM development may cost thousands of dollars whereas subscribing to some online CRM services is generally priced on per per-user, per-month basis.

But you can also do it on your own in a few minutes if you register your domain at Sangkrit.net and subscribe to a hosting option such as cPanel WebhostingPlesk Windows HostingWebhosting PlusVPS, or Dedicated Server.

Sangkrit.net provides you one-click web application installer which can also be used for installing CRM software on your domain or subdirectory.

There are many types of CRM applications that can be installed on your domain at SANGKRIT.net, for instance:

  1. SugarCRM is a free customer relationship management (CRM) application. Initially released in 2004, today it powers operations for over one million businesses and organizations worldwide. It has received the Best Free CRM Software award by the InfoWorld Bossie Awards program for the past five consecutive years.
  2. SuiteCRM which is another CRM application is a free software forked from SugarCRM Community in 2013. It provides enterprise-grade CRM to a global community of users and software developers.
  3. There are more CRM options such as – Vtiger, Feng Shui, Group Office, Zurmo, etc, you can find more information and a manual about them on your application installer page at Sangkrit.net.

How To Install CRM On Your Domain Name?

On your web hosting’s cPanel, simply launch Installatron, the one-click application installer. Now switch to the Application Browser tab, scroll down to Applications for eCommerce and Business, and click a CRM software to install.

(The page also provides you the important links for support and documentation of the CRM you are installing, you can revisit the page anytime in the future for any support)

It will take you to a form, fill in the important fields such as the domain and directory where you want to install this application, the username, and password you like to use for future logins, etc. Then simply click the INSTALL button and wait.

Once installed successfully, it will provide you the admin page URL from where you can log in to your CRM dashboard using the login credentials you added at the beginning of the installation.

Customer Relationship Management (CRM) is crucial for businesses across various industries. Its importance lies in its ability to help organizations build and maintain strong relationships with customers, which, in turn, can lead to increased customer satisfaction, loyalty, and business growth.

Restoring Database Grants On WHM Server & cPanel

When a database user loses his access to configured databases, you may need to restore that user’s grants to the database using the restoregrants utility on WHM.

The first step you need to make is to access your command line and then use restore grants to restore the user’s database access:

/usr/local/cpanel/bin/restoregrants –cpuser=$cpuser –db={mysql, pg} –dbuser=$dbuser

/usr/local/cpanel/bin/restoregrants –cpuser=$cpuser –db={mysql, pg} –all

Where:

  • $cpuser – is the cPanel username that has lost access to databases.
  • {mysql, pg} –  is the type of database: mysql for MySQL or pg for PostgreSQL.
  • $dbuser – is a database user whose privileges you wish to restore. If you use –dbuser, the $dbuser variable will consist of the database user’s name. If you use –all, the script will restore grants for all of the database users that belong to the cPanel account.

How to update the user’s password to restore database access on cPanel?

In certain circumstances, the restoregrants script may fail to restore access to the database.

In such a case, either the cPanel or the WHM  account owner can reset the cPanel account’s password in order to restore grants by following the given steps.

For restoring grants from cPanel:

  1. Navigate to cPanel > Change Password.
  2. Select Allow MySQL password change.
  3. Change the password and click Change your password now.

Steps for server administrator i.e. the owner of the WHM account:

  1. Navigate to WHM > List Accounts.
  2. Click + next to the appropriate account.
  3. Select Sync MySQL password with the account password.
  4. Enter a new password into the Change Password box and click Change.

How To Recover A VPS Or Dedicated Server With Rescue Mode?

Rescue mode is a valuable tool for server administrators and system administrators because it provides a means to troubleshoot and recover a server in various scenarios.

Accessing your server by using the recovery console especially when you lose access to your Linux VPS or Dedicated Server is one thing. But, sometimes logging in through the recovery console doesn’t help or it doesn’t work for you then, in that case, you need to boot your server in ‘Rescue Mode‘.

In rescue mode, you are given temporary login credentials that you use to get into your server via SSH to resolve your server-related issues.

Login to your Sangkrit.net account and follow these steps:

  1. Visit your ‘Products‘ page
  2. On your ‘My Products‘ page, click ‘Manage
  3. Select ‘Rescue Mode‘ from the ‘Server Actions‘ option
  4. Click ‘Confirm

A progress message will appear, and in a few minutes, your server will reboot to rescue mode. Your server dashboard will now show that your server is running in ‘Rescue Mode‘. This message appears next to your server name.

Now you can use those temporary login credentials to access your server via SSH and you will be able to access all files available on your server.

Complete your work and when you are done, click ‘Exit Rescue Mode‘ present in your server’s Dashboard. Your server will now reboot to the active mode i.e. normal mode.

Additionally, exercise caution when making changes in rescue mode, as improper actions can potentially cause data loss or system instability.

How To Login To SSH Server Without Password?

SSH key authentication is a secure method of logging into an SSH server without needing to enter a password. It relies on the use of a pair of cryptographic keys: a private key (kept secret) and a public key (shared with the server). This lesson guides you on how to set up SSH key authentication and login to the server without password.

Generate SSH Key Pair

First, you need to generate an SSH key pair if you don’t already have one. Open your terminal and run the following command to generate a new SSH key pair:bashCopy codessh-keygen -t rsa -b 2048 -f ~/.ssh/id_rsa

-t rsa: Specifies the type of key to create (RSA).-b 2048: Sets the key length to 2048 bits (you can use higher values for stronger security).

-f ~/.ssh/id_rsa: Specifies the file name for the generated key pair (the default location is ~/.ssh/id_rsa).

During key generation, you can choose to set a passphrase for added security, but it’s optional. A passphrase adds an extra layer of protection to your private key.

Copy the Public Key to the Server

Next, you need to copy your public key to the server you want to access via SSH. You can do this manually or by using the ssh-copy-id command.

Replace <username> and <hostname> with your server’s username and hostname:bashCopy codessh-copy-id <username>@<hostname>

If you prefer to do it manually, you can append the contents of your public key (~/.ssh/id_rsa.pub) to the ~/.ssh/authorized_keys file on the remote server:bashCopy codecat ~/.ssh/id_rsa.pub | ssh <username>@<hostname> 'mkdir -p ~/.ssh && cat >> ~/.ssh/authorized_keys'

Make sure the ~/.ssh directory on the remote server has proper permissions (usually 700), and the ~/.ssh/authorized_keys file should have permissions set to 600.

Test SSH Key Authentication

You can now test SSH key authentication by attempting to SSH into the remote server:bashCopy codessh <username>@<hostname> If you set a passphrase for your private key, you’ll be prompted to enter it. Otherwise, you should be logged in without being asked for a password.

Disabling Password Authentication

For enhanced security, it’s a good practice to disable password-based authentication once you’ve confirmed that SSH key authentication is working. You can do this by modifying the SSH server’s configuration (typically located in /etc/ssh/sshd_config).

Set PasswordAuthentication to no.Reload the SSH server: sudo service ssh reload or sudo systemctl reload ssh.This ensures that SSH access can only be obtained using the authorized SSH key.

SSH key authentication is a secure and convenient way to access remote servers, and it’s widely used for server administration and secure file transfers. Just remember to protect your private key and use passphrases for added security.

The lesson guides you on the Linux server environment. If you’re using Windows, you can use an SSH client like PuTTY or Windows Subsystem for Linux (WSL) to follow similar steps.

How To Use Secure Shell SSH On Your VPS Or Dedicated Server?

Secure Shell (SSH) is a more secure and popular network protocol that delivers secure communication over an unsecured network, such as the Internet. SSH is primarily used for remote login and command-line execution on remote machines but it can also be used for securely transferring files from one system to another just like FTP. So in this case you can say that SSH is a more secure version of FTP.

After you subscribe to a VPS or Dedicated Server, you can transfer files and backup using SSH and for that, you will need to follow a few general steps to connect your server via SSH Secure Shell using a local client. This is needed to transfer, backup, or upload your web/app files, etc.

SSH is a cryptographic network protocol for operating network services securely. Since it is a method for doing a secure remote login from one device to another, here, the two devices are your local machine i.e. your computer, and your server i.e. your VPS or Dedicated Server.

Now following are the exact steps to make a connection via SSH but a few things may depend on the SSH client you use. If you don’t use Linux Terminal then you may use PuTTy for Windows, or Terminal on a MacOS machine.

​​Before you start with the SSH login you will need to obtain this info:

  • Your domain name or IP address
  • Your primary FTP username
  • Your primary FTP password

In case you don’t know where to find these things, you may search their tutorials or simply email or call the online support team to get help.

For security reasons, your dedicated server is provisioned with disabled admin/root access. But you can enable it by following these steps:

  1. Login to your Sangkrit.net account
  2. ​​Navigate to your My Products page
  3. Click Servers
  4. Next to the Generation 4 server, click Manage
  5. Select Settings from the top of the page in your account dashboard
  6. In the access section, next to the admin access, click Manage
  7. Select Enable Admin Access (this is actually root account sudo access) 
  8. Now click Save
  9. Admin access is now enabled

Next, Establish a connection:

Launch your SSH client, enter the host i.e. your domain name or IP address, and your SSH port number (which by default is 22) to establish the SSH connection.

Now you will be asked to enter the FTP details. As prompted for that, enter your primary FTP username and password and click GO or whatever action button is there in your client. That’s it. Your client will now make a connection.

How To Map Domain Names When Name Servers Don’t Work?

Domain mapping is a process that allows you to use a domain name on your website or web service on any hosting option such as cPanel WebhostingPlesk Windows HostingWebhosting PlusVPS, or Dedicated Server. It is generally done by updating the name servers on domain names to point to the server where you are hosting or planning to host your website.

Sometimes on self-managed servers and advanced hostings, the nameserver needs complex configurations to work, these settings might not be easy for general users. If adding custom name servers doesn’t work for you, you can set your domain name to work simply by editing its DNS zone.

In this case, you don’t need to edit or use custom name servers but make some changes in the DNS zone file and it will start working with default nameservers provided during the time of registration.

The first thing you need to do is log in to your VPS or Dedicated Server and copy its IP address which you will find on the My Products -> Servers -> Manage page. If you have a hosting, the IP address would be visible on the cPanel’s information page.

Once you have the IP address the next step is to log in to your domain account and click the ‘Manage‘ button to open up domain details.

DNS 1

Select the DNS Zone File tab to edit your domain’s zone information. Click the ‘Add Record‘ button present in the zone file section and add records as shown in the following screenshot.

DNS 2

The examples:

  • Hostname – www, record type – A address, ***.***.***.*** (IP)
  • Hostname – @, record type – A Address, ***.***.***.*** (IP)
  • Hostname – *, record type – A Address, ***.***.***.*** (IP)

Don’t forget to replace the ***.***.***.*** with your server’s IP address. You can add records one by one by clicking the ‘Add Another’ button. Once DNS records are added, save changes, log out, and wait for the DNS propagation.

DNS propagation refers to the process by which changes made to Domain Name System (DNS) records are distributed and adopted across the internet. When you make changes to your DNS records, such as updating the IP address associated with a domain or adding new records, these changes need to be propagated to DNS servers worldwide to ensure that internet users can reach your website or services using the updated information.

This might take up to 24 hours to complete but generally at Sangkrit.net, it starts working for you in a few minutes.