Upgrade Mysql on Plesk CentOS Linux

We had successfully upgraded from Mysql 5.0 to Mysql 5.1.47 along with PHP on one of our plesk server. Please use this solution if you notice any package conflicts, or other concerns with using 5.1 in your environment. Like PHP, this will be a full change to the newer packages and the 5.0 series will be retired. The procedure is quite simple

1.) wget -q -O – http://www.atomicorp.com/installers/atomic.sh | sh

2.)  To upgrade:

yum –enablerepo=atomic-testing upgrade mysql

Thats it,  And if you simply want to upgrade php run “yum upgrade php”

With the above methods mysql will be upgraded to latest release without any problems.

Domain unable to unsuspend in Plesk 9.5

After upgrading plesk to latest release one of our domain on plesk server was unable to unsuspend thus giving the following error.

“Warning: The domain is still suspended for the following reason: Domain is temporarily suspended for backing up or restoring”

Though it appear to be backup issue but backups were not running for the domain making it quite confusing, So we had the following method to unsuspend the domain.

Login into shell and ran the following command.

/usr/local/psa/bin/domain -u domain.com -status enabled

Segmentation fault

Voila !! So here is the problem plesk binaries is showing segmentation fault so it appears that the plesk upgrade didn’t go properly.  Plesk itself work on these binaries which here appears to be a problem.  Now Login into plesk and under “Updates ” select the plesk base package option and re-install the Plesk Base packages to make the plesk binaries working again.  You should receive a email when the updates are completed.

Follow the steps to reconfigure the domain in plesk database.

Reconfigure Domain:

/usr/local/psa/admin/sbin/websrvmng –reconfigure-vhost –vhost-name=domain.com

Change the status for domain

/usr/local/psa/bin/domain -u domain.com -status enabled

You should get a message the Object successfully enabled, Thats it the domain should be unsuspended in Plesk.

Hardening /tmp in Plesk

Hardening /tmp location is very important as you may risk running rootkits, ircbots and trojans from that location. Today we had a similar problem with one of our plesk server where these bots were getting uploaded in /tmp location. However there is NO perfect solution to find how these are getting uploaded under /tmp but its better take preventive mesaures for not letting them execute.

Hardening /tmp

Since /tmp was not seperately mounted there is no need to take the backup of /etc/fstab file. However its good to take in case anything goes wrong.

Create a separate partition for /tmp. For that we need to create a separate device with a certain space. The space allocation is actually depending on the apps running on your machine. Here I’m creating a separate device of size 100M and formatting it with ext3 filesystem.

dd if=/dev/zero of=/dev/tmpFS bs=1024 count=100000

mke2fs –j /dev/tmpFS

Copying existing data which is in the /tmp directory to a sperate temporary directory.

cp –pRf  /tmp /tmp_bkp

Mounting the new partition that we’ve created in the /tmp directory and setting the necessary permissions.

mount -o loop,noexec,nosuid,rw /dev/tmpFS /tmp

chmod 1777 /tmp

Copy the old data which is int /tmp_bkp directory to the new /tmp directory.

cp –pRf  /tmp_bkp/* /tmp

Finally add the following entry to the fstab to make the changes permanent.

/dev/tmpFS /tmp ext3 loop,nosuid,noexec,rw 0 0

That’s it. Your /tmp location is secured now.

Install imagemagick with PHP imagick extension on Plesk CentOS VPS

Here are the steps and procedures you need to follow for install Imagemagick on Plesk VPS. login into the server and give the following commands, This requires yum to be installed on the server.

yum install ImageMagick

pecl install imagick

if you are getting the following error then you do not have compiler installed. You can do that using yum install gcc

configure: error: no acceptable C compiler found in $PATH See `config.log’ for more details.”

Restart the pecl install imagick command at the end you should something like this which means the build was successfully done and the extension was installed successfully.

Build process completed successfully
Installing ‘/usr/lib64/php/modules/imagick.so’
install ok: channel://pecl.php.net/imagick-2.3.0
configuration option “php_ini” is not set to php.ini location
You should add “extension=imagick.so” to php.ini

Then you need to include the extenion in php.ini. Here is how it needs to be done.

echo “extension=imagick.so” > /etc/php.d/imagick.ini

Restart apache

/etc/init.d/httpd restart  OR service httpd restart

Verify it using the following command

php -m | grep imagick

Thats it.. With these steps we were able to install imagemagik successfully on one of our server. Hope this helps you as well.

Update to PHP5 on CentOS 4.5 ( plesk )

One nice thing about CentOS is the long support life and stability of the system. One not so nice thing is that because it is based on Red Hat Enterprise, the package selection is pretty conservative. That’s not too bad though, Apache is 2.0.52, MySQL is a 4.0.x version, so things are reasonably current. One thing that’s really dated though is PHP (4.3.x)… We have been using PHP 5 for a while and quite like it, so a PHP 5 package for CentOS would be nice. Good news though is that one already exists, its in the CentOSPlus repository.

To enable CentOSPlus edit /etc/yum.repos.d/CentOS-Base.repo. After [centosplus] heading, you’ll see a line that currently says “enabled=0. Change that to “enabled=1″ to enable CentOSPlus. Once the CentOSPlus repo is enabled, “yum update php” will search the repository and offer to upgrade any packages to newer versions from CentOSPlus. If you had PHP installed previously, this will upgrade you to PHP 5.1.x.

Once you’ve got php 5 and the php-pgsql package installed, check the “extension_dir” setting in php.ini, make sure the directory exists and the pgsql.so file is in that directory. Mine is set to “/usr/lib/php/modules”, so that’s where the .so files will be installed by default. If yours isn’t set to that directory then it might be easier to change the extension_dir rather than move the .so’s.

Make sure the line “extension=pgsql.so” appears somewhere either in php.ini or one of the /etc/php.d/*.ini files. This will force PHP to load the pgsql extension.

For ex. If update missed GD here is what you need to do

Installing the GD library is easy on CentOS thanks to yum.  Simply type:

yum install gd gd-devel php-gd

make sure /etc/php.d/gd.ini the extension is enabled

Thats all. If you have trouble updating php on Centos with Plesk please contact our support department support@24×7servermanagement.com for help.

How to install Ioncube On Plesk VPS

Kindly refer the following steps for more details :

Read the rest of this entry »

import.php: Missing parameter: import_type

Mysql DB Webadmin returns an error on SQL query.

Plesk is installed on Virtuozzo virtual environment. VZPP – Plesk integration is enabled.
Read the rest of this entry »

LogFilesList->init() failed: filemng failed: filemng: stat failed: Permission denied

Hi,

Quote:

This seems to be a bug in SwSoft, but can be fixed in the following manner:

cd /var/www/vhosts/domain.com/
chmod 755 statistics -R

*where domain.com is your domain name

Disk usage for domain shows 0mb in plesk linux

Disk usage for domain shows 0mb in plesk linux
Just run the statistics manually:
cd /usr/local/psa/admin/sbin/
./statistics