Restoring a User’s Database Access For WHM version 11.36
If a database user loses access to databases, you may be able to restore the user’s grants to the database using the restoregrants utility.
Using Restoregrants to Restore the User’s Database Access
Execute one of the following commands from the command line:
/usr/local/cpanel/bin/restoregrants –cpuser=$cpuser –db={mysql, pg} –dbuser=$dbuser
or
/usr/local/cpanel/bin/restoregrants –cpuser=$cpuser –db={mysql, pg} –all
$cpuser The cPanel username which has lost access to databases.
{mysql, pg} The type of database: mysql for MySQL or pg for PostgreSQL.
$dbuser The database user whose privileges you wish to restore.
How can I get yum to keep package at a certain version.
There are several ways you can do this.
One is to exclude it from your updates list. See man yum.conf for more details.
Another way to pin package to a certain version is to use the versionlock plugin.
If you are using the latest Fedora then the plugin can be installed using:
yum install yum-plugin-versionlock
To add files that you want version locked, use the following yum command:
yum versionlock [package-name]
cPanel Version 11.25 XML API Functions
Version 11.25 adds 16 new XML API functions to better integrate cPanel/WHM with custom software.
New API functions:
View information about a domain
Add a DNS zone record
Edit a DNS zone record
View all DNS zone records for a domain
Remove a DNS zone record
Reset a DNS zone record to the settings found in httpd.conf
Assign a reseller IP addresses
Set reseller limits
Set a reseller’s main IP address
Define reseller packages
Suspend a reseller’s account
Unsuspend a reseller’s account
View information about a reseller’s accounts
Define a reseller’s nameservers
Configure a service
Change the IP address of a domain
cPanel & WHM Version Number
The version number:
The first and second segments still represent the parent and major values. (These are unchanged.)
The third segment no longer consists of an auto-incremented build ID number. It now represents a milestone—a group of changes to cPanel & WHM that will include new features and bug fixes.
The fourth segment is the auto-incrementing build ID. This value is relative to the milestone. When the milestone is achieved, the third segment will be incremented and the build ID will reset to 0.
For example, in version 11.29.1.4:
“11” is the parent number.
“29” is the major version number.
“1” is the cPanel & WHM milestone.
“4” is the build ID leading up to the completion of the milestone.
This version number would be reported in the cPanel & WHM user interfaces as “11.29.1 (build 4).”
Apache Handlers For cPanel version 11.30
Apache handlers control how your site’s Apache web server software manages certain file types and file extensions.
Apache comes configured to handle CGI scripts and server-parsed files. Their file extensions include: .cgi, .pl, .plx, .ppl, .perl, and .shtml.
You can configure Apache to handle a new file type with an existing handler by manually adding the handler and extension to cPanel.
For example, to have the server treat files with the extension .example as CGI files, you would type ”cgi-script” under Handler and “.example” under Extension(s).
