ServerBuddies Support Blog

Repairing MySQL database form WHM.

You can attempt to repair MySQL databases using WebHost Manager.

Then function checks each table for errors and tempts to fix them.

To repair a database:

Click on the Repair a Database link in the MySQL menu.
Click on the database that you want to repair in the displayed list and click on the Repair Database button.

A status list is displayed, stating which tables have been checked and the result.

How to Setup Reseller Private Nameservers in WHM

First we need to register the name servers before we set them up on the server.
Resellers can also have their own private name servers for their own clients making the server provider more anonymous.

Login to your WHM account as root.
Click on Reseller Center on the left hand side.
Under Edit Reseller Privileges/Nameservers, select the reseller account you want to provide with private name servers.
Scroll down to the very bottom of the page until you see: Primary Nameserver.

In the Primary Nameserver field enter the primary nameserver.
Click “Assign IP Address”
Click “Add an A Entry for this nameserver”
In the Secondary Nameserver field enter the secondary.
Click Save

Specifying the nameserver’s DNS role in WHM

We need to specify which server is to function as a standalone server — that is, a server that only receives DNS data from the other servers in the cluster.

You do not need to link dedicated nameservers to each other.

Under Dns Role, select Standalone next to each web server’s hostname and IP. This will allow the nameserver to receive information from the web server, but not send data to it.

Setting a nameserver to synchronize data to a web server is not recommended, as it will create extraneous zones on the web server.

In most cases, a DNS-only server should never be set to synchronize to a Web server. The Web server should always be set to synchronize to the DNS ONLY server(s), and the DNS ONLY server(s) should always be set as standalone.

How to install Softaculous in WHM

1) In order to install Softaculous ensure ionCube Loaders are enabled.

If it is not enabled you can go to WHM >> Tweak Settings >>PHP >> Select ioncube from Loader to use for internal cPanel PHP

2) Now Login to the server as root.

3)Go to the directory /usr/local/cpanel/whostmgr/docroot/cgi

4) Download Softaculous

5) Change the permissions to 755

That’s for the command line.

Now login to WHM

6) Go to WHM > Plugins> Softaculous – Instant Installs

Configuring Reverse DNS in WHM

Reverse DNS uses pointer records (PTR) to convert IP addresses into domain names. This is the opposite of forward DNS, which uses A records to convert domain names into IP addresses.

First, add a new DNS zone file. You can accomplish this using the Add a DNS Zone feature in the DNS Functions section of your WHM interface (Main >> DNS Functions >> Add a DNS Zone).

To continue, enter the IP address and proper reverse DNS zone name in the appropriate fields.

To properly format the Domain field in the interface.

Take the first 3 octets of the IP address, Reverse them, and Affix in-addr.arpa to the end. So, for example, the reverse DNS entry for 192.168.0.1 is 0.168.192.in-addr.arpa. After you have filled out these 2 fields, click the Add Zone button.

One you have created your zone file, you can edit it. You can do this using the WHM Edit DNS Zone screen (Main >> DNS Functions >> Edit DNS Zone). Your zone file should already contain an NS entry for every authoritative nameserver associated with your server. To finish this process, we need to add a PTR record for each IP address we wish to name in the last octet of 192.168.0.

After the reverse DNS zone has propagated, run a test to ensure that you have properly configured reverse DNS. To do so, you can use the following command:

If you have properly configured your reverse DNS zone file, the output should resemble the following: