When customer tries to see statistics from watchdog, an error message appears
Internal error: failed to adjust system time in accordance with daylight savings time change.
Also Watchdog’s cron job reports the error
ERROR: WDExc
Error occurred while processing database query: ‘MySQL query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘group by service_id, type, round(unix_timestamp(time) / 7200, 0) having count(va’ at line 3′
To resolve this issue.
Unzip Parallels Plesk Panel version pack-sysstats and replace the file located in /usr/local/psa/libexec/modules/watchdog/cp/
http://kb.parallels.com/Attachments/14807/Attachments/pack-sysstats-for-9.5-10.zip
Unzip Parallels Plesk Panel version stats-graph and replace the file located in /usr/local/psa/admin/htdocs/modules/watchdog/
http://kb.parallels.com/Attachments/14807/Attachments/stats-graph-for-9.zip
Reference: http://parallels.com/
Micro-Updates in Parallels Plesk Panel 9.x, 10.x
There are two ways to install micro-updates for Parallels Plesk Panel.
Using the Command Line Interface:
#$PRODUCT_ROOT_D/admin/sbin/autoinstaller
Note: The “$PRODUCT_ROOT_D” variable in the command should be replaced with its value according to Plesk variables.
The exact value of path variables can be known from /etc/psa/psa.conf file on Parallels Plesk Panel server.
Or use the following parameters:
#$PRODUCT_ROOT_D/admin/sbin/autoinstaller –select-product-id plesk –select-release-current –reinstall-patch –install-component base
Note: The “$PRODUCT_ROOT_D” variable in the command should be replaced with its value.
The exact value of path variables can be known from /etc/psa/psa.conf file on Parallels Plesk Panel server.
Reference: http://parallels.com
Limits in Parallels Plesk Panel for usernames/passwords
User names and passwords in Parallels Plesk Panel are case sensitive. The following limits for user and password length exist:
For Unix/Linux Systems.
Parallels Plesk Panel user name length 1…20
Parallels Plesk Panel user password length 5…14
System user name length 1…16
System user password length 5…255
Latest update of openssl breaks Parallels Panel
Latest update of the openssl package from CentOS breaks Parallels Panel 9.x. Errors are displayed in the /var/log/sw-cp-server/error_log file when Panel is trying to start.
The problem has been fixed since version 9.5.0.
Download the appropriate package using the wget utility. Example for CentOS 5 x86:
#wget -c http://kb.parallels.com/Attachments/12669/Attachments/sw-cp-server-1.0-6.201004011105.centos5.i386.rpm
Install the downloaded package. Example for CentOS 5 x86:
#rpm -Uhv sw-cp-server-1.0-6.201004011105.centos5.i386.rpm
Reference : http://kb.parallels.com/
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:
Parallels Plesk Panel 10.x: “Server Management” -> “Tools & Utilities” -> “Updates” -> “Update Components” -> click “Continue”
