Category Archives: Programming

Move Large cPanel Account to new Server

I had an account that was over 100GB in size, and it would not transfer to a new server via the GUI. Step 1(current server): Step 2(new server ):  

Find Image name from Excel Cell

The formula below will give you the image name from a cell string

Install Sphinxsearch 2.3.2-beta

Installing on a fresh DO instance.  

Install Sphinx Search on cPanel

Move into /tmp directory and get latest release.  You can get the latest release from Uncompress Create directory Enter the Uncompressed directory Configure to use the directory we created above and to use mysql and postgresql Build Create Configuration File Create Start-up Script Make Script Writable Start the Service Create chkservd file Add to /etc/chkserv.d/chkservd.conf Restart Tailwatch  

Free SSL from cPanel for WHM Server/Services

WHM » Service Configuration » Manage Service SSL Certificates

click “Browse Certificates” and use “Browse Account: root”.

You should see a certificate for your ‘’ and the Issuer column should say: cPanel, Inc.

If you do not see this, and they all say Issuer: “Self signed”, then go into SSH and run the following command:

You may have to run it a few times as the first time you run it, it usually says about putting the SSL into queue until it runs again, so running

a second time, will have it actually generate the SSL.

Then go back to Manage Service SSL Certificates in WHM and select the cPanel, Inc issued SSL, and check the 4 services boxes and then click install.