ServerBuddies Support Blog

Plesk - how do I enable remote access to MySQL database server?

Sometimes you need to provide the remote access.

Open /etc/my.cnf and make sure that the following lines exists/commented in [mysqld] section:

Restart MySQL. Now you should grant access to remote IP address, login to Mysql:

For example if you want to allow access to database called ‘foo’ for user ‘bar’ and remote IP 192.168.0.1 then you need to type following commands at “mysql>” prompt:

Reference: http://kb.parallels.com/

Sending Logs to a Remote Loghost

Edit /etc/syslog.conf. Add or correct the line:

Where loghost.example.com is the name of your central log server.

It is particularly important that logs be stored on the local host in addition to being sent to the loghost, because syslogd uses the UDP protocol to send messages over a network. UDP does not guarantee reliable delivery, and moderately busy sites will lose log messages occasionally, especially in periods of high traffic which may be the result of an attack. In addition, remote syslogd messages are not authenticated, so it is easy for an attacker to introduce spurious messages to the central log server. Also, some problems cause loss of network connectivity, which will prevent the sending of messages to the central server. For all of these reasons, it is better to store log messages both centrally and on each host, so that they can be correlated if necessary.

ProFTPD Remote Code Execution Vulnerability and Exploit

A flaw in the popular ProFTPD FTP server potentially allows unauthenticated attackers to compromise a server. The problem is caused by a buffer overflow in the pr_netio_telnet_gets() function for evaluating TELNET IAC sequences.

ProFTPD bug report: http://bugs.proftpd.org/show_bug.cgi?id=3521

Fixes for the vulnerabilty and exploit.

Parallels has used its micro-update patch functionality in Plesk 9.5x, Plesk 10, and Small Business Panel 10.2 to fix this exploit. You can run the Parallels AutoInstaller to fix this or check the Updates section of your Plesk Panel 9.5x, Plesk 10, or Small Business Panel 10.2 to fix this. This is a file-replace, as opposed to a new install so it will be quick and reliable. To find this in the GUI:

Delivering mail to local mail server if your DNS is hosted on remote Cpanel VSP

Login to WHM and go to “DNS Functions” and select “Edit a DNS Zone”

Select the zone to edit and then select the “Edit” button.

Once the next screen appears scroll down to the “Record Type” MX and change the value to mail.serverbuddies.com.

Change the “Record Type” to “A” for mail and add the IP address of your local mailserver in the box to the right of the “CNAME” record type.

Now DNS server will instruct mail servers on the internet to deliver mail to your local mail server.

Edit the file /etc/localdomains and remove the domain name for which you want email delivered locally.

Edit the file /etc/remotedomains and add the domain name which we removed from /etc/localdomains

Now local (cpanel) mail server (Exim) will route all email originating from the local server to the remote mail server.

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.