From Spry Wiki
What is the best way to determine if my IP address is licensed for CPanel/WHM?
To determine if your IP address is licensed for CPanel/WHM go to http://verify.cpanel.net/ and submit your IP address. The response will include when license was activated.
How do I fix the CPanel/WHM license on the server when I change my hostname?
When changing the hostname on the server run the following to update the license. /usr/local/cpanel/cpkeyclt from command line as the root user.
How do I install scripts in cPanel?
Fantastico is a program that allows you to install scripts in cPanel. You will need to contact your web host to install Fantastico.
Once you have Fantastico installed, select Fantastico from the cPanel main page. You will see a list of programs on the left side of the page. Select the program that you want to install. Click New Installation in the box on the right, like this:
Follow the instructions and click Install. Make sure that you bookmark the admin area during the installation, and keep your username and password in a secure location.
How do I create and manage databases with MySQL and phpMyAdmin?
You can access your MySQL databases by selecting MySQL Databases from the cPanel main page.
To add a new database, enter a name for the database and click Add Db.
To add a user to the database, enter a username and password and click Create MySQL User.
To grant the user access to the database, select the user and database from the drop down lists under "Grant Permissions ...", check the privileges you want to give this user, and click Grant permissions.
On the MySQL Account Maintenance screen, there are connection strings for Perl and php. Insert this code into any file that needs to connect to the database.
To create a database with phpMyAdmin, click on phpMyAdmin at the bottom of the MySQL Account Maintenance screen. On the following screen, select the database you want to manage:
Click on the SQL tab to run SQL queries on this database. To save the contents of the database, select Export.
How do I create add-on domains?
Select Addon Domains from the cPanel main page. Enter a name for the new domain, the subdirectory for the domain to point to, and a password, and click Add Domain!.
Note that you will need to register the domain and configure your DNS settings before the domain will become active.
How do I create subdomains?
Select Subdomains from the cPanel main page. Enter a name for the subdomain and click Add.
To redirect the subdomain, go back and select Setup Redirection. On the next page, enter the URL where the subdomain will be redirected and click Save.
Note that it will take a few hours for the new subdomain to become fully active.
How do I change my contact email address?
Your contact email address is listed in the upper left hand corner of the cPanel main page. Click the link "Please keep this information up to date." Enter your new contact email address and click Save Email.
How do I add mail users?
Select Add/Remove E-mail account(s) from the cPanel main page.
On the next screen, click Add Account. Enter a username, password, and quota for your new account, and click Create.
How do I check my webmail in cPanel?
Select Read Webmail from the cPanel main page. Then select a webmail program. If you don't know which one to choose, just pick one.
You may be asked to complete a form the first time you log in. Follow the on-screen instructions to continue.
You can also access your webmail by going to http://(yoursite).com/webmail
How do I view my account resources (e.g. disk space,bandwidth)?
There are some basic statistics on the left side of the cPanel main page, including total disk usage and bandwidth usage.
You can view your disk usage in detail by selecting Disk Usage Viewer from the cPanel main page. Select Show Top Level to view disk usage by directory. To get a more or less detailed view by directory, select Show More (Less) Directory Depth.
To view detailed bandwidth statistics, select Web/FTP stats from the cPanel main page. Then select either Analog or Webalizer stats. Note that these statistical reports are only updated every 24 hours.
How do I manage my ftp accounts?
Select FTP Manager from the cPanel main page. Then select FTP:// Accounts. From here, you can add or delete accounts, change passwords, or view account files.
When you create a new account, cPanel will automatically create a directory in public_html with this username and grant the user access to this directory. Be careful if you change this; the user will have access to the directory you assign, as well as any directories under it. So if you assign the user to public_html/ (instead of public_html/username) they will have access to any files inside this directory.
There are some ftp accounts that are created automatically by cPanel. These cannot be deleted.
How do I manage my account files using ftp?
If you do not have an ftp client, we recommend you download FileZilla. Search online for filezilla, and follow the instructions to download.
Open FileZilla and click on the Site Manager icon to create a new connection. Enter your host (ftp.yoursite.com), server type, logon type, username and password, and click Connect.
You will see your site files on the right, and your local files on the left. Go to the folder on your local drive where your web site files are located, and double click on a file name to upload. Make sure that you have the folder open on the right where you want these files to go.
To move multiple files at once, highlight the files, right click, and select Upload.
To download a file, open the folder where you want the file to download on the left, and double click the file name on the right.
To change file permissions, right click on the name of file and select File attributes.
How do I download my raw access logs?
Select Raw Access Logs from the cPanel main page. Then click on the name of the raw log to download. Logs are downloaded in .gz format, so you will need to unzip them first.
The unzipped file will be in Apache Common Log Format (CLF). You may need a log analysis program to interpret the results for you. If you open the file using a Windows text editor, such as Notepad, you will get results with no line breaks.
What is .htaccess?
.htaccess is an apache directives file inside one or more of your /home/(your username here)/public_html subdirectories. You can edit .htaccess to password protect a directory, among other things. You can also password protect directories within cPanel by selecting Web Protect from the cPanel main page.
If you are using FrontPage, do not change any .htaccess file within public_html.
Do not edit any .htaccess file unless you know what you are doing. You may render your site inoperable.
How do I install CGI scripts?
To use a preinstalled CGI script, select CGI Center from the cPanel main page. Select the name of the script to want to use, and follow the instructions on the next page to make the html code. Then cut and paste the code into your html file.
How do I recompile apache in WHM?
To recompile apache, select Software, then Update Apache from the WHM main page. Check the options that you want to include, and click Start Build. Note that you should not just check every box, or you will probably end up with a broken configuration. If you do not know which boxes to check, use the default configuration.
It will take a while for apache to rebuild. If you have any problems during this process, you can always return to Update Apache and restart the build. If your new configuration does not work, return to this screen and select Load Previous Config. If all else fails, you can select Reset Apache Config to Default (towards the bottom of the page) and click Start Build.