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 http://sphinxsearch.com/downloads/ 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 ‘server.domain.com’ 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:

Code:
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

Code:
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.