ServerBuddies Support Blog

Setting up a remote MySQL server for cPanel/WHM server.

You can change the MySQL server from the local server (”localhost”) to point to a remote server.

This allows MySQL functions to be performed by another computer.

To set up a remote MySQL server:

1.Click on the Setup Remote MySQL server link.
2.Enter the name of the remote server in the Remote Mysql Host field and its password in the Remote Mysql Host’s Root Password field.
Note: Do not enter the root password for the remote MySQL server in the Remote Mysql Host’s Root Password field.
3.Click on the Setup button.

How to access psa database in Plesk Server

We can access plesk psa database, from the Linux command line (via ssh) and from the Plesk control panel.

The /etc/psa/.psa.shadow file contains the Plesk admin password.

So to access the database run the following command.

Select the psa database.

To view all the tables

Localdomains and remotedomains in cPanel Server.

Problem : A user that pointed their MX records to another server but email from their website or users on the same server isn’t going out of the server.

This is because Exim on the server is configured to use files called localdomains and remotedomains, which tell Exim whether a domain’s email is hosted locally or remotely.

The files controlling these actions are:

* The remotedomains file takes precedence, so if a domain is located in both files, the mail server should use remotedomains.

Common Errors:

*Email from the user’s site is not being delivered to their outside mail server - add the domain to remotedomains
*lowest numbers MX record points to localhost - adding the domain to localdomains will resolve the issue.
*Email bouncing stating the user does not exist - add the domain to remotedomains

Apache Security: Hide Apache Web Server Version number

Apache Web Server Version number with ServerSignature and ServerTokens directives

Open your httpd.conf file using text editor such as vi:

There are two config directives that controls Apache version. The ServerSignature directive adds a line containing the Apache HTTP Server server version and the ServerName to any server-generated documents, such as error messages sent back to clients. ServerSignature is set to on by default. The ServerTokens directive controls whether Server response header field which is sent back to clients includes a description of the generic OS-type of the server as well as information about compiled-in modules.

Append/modify config directive as follows:

Save and close the file. Restart Apache web server:

TCP and UDP Ports for Cpanel Server Firewall

Incoming TCP ports

Outgoing TCP ports

Incoming UDP ports

Outgoing UDP ports