Archive for the “Plesk” Category

ERROR: PleskFatalException : Unable to remove hosting: SiteAppManager: Provided Client object is invalid or Internal Plesk error occurred: Unable to remove hosting: SiteAppManager: MySQL query failed: Unknown column ‘app_release’ in ‘field list’

ERROR: PleskFatalException
Unable to remove hosting: SiteAppManager: Provided Client object is invalid or ERROR: Internal Plesk error occurred: Unable to remove hosting: SiteAppManager: MySQL query failed: Unknown column ‘app_release’ in ‘field list’

Solution: you have to login to psa’s database via MysqlQuery Browser or any other client you want and then the following steps

1) find the domain id, just go to the client of the domain, and in the domain select list,
put your mouse over the domain name, in the status bar of the browser you will see something like:

https://yourserver.tld:8443/domains/dom_ctrl.php3?dom_id=865&previous_page=domains

the domain id there is “dom_id=865″.

2)open the psa database in mysql
3)run: SELECT * FROM SiteApps where dom_id=’865′;
you will see the application in 1 line, then delete it
4)run: DELETE FROM SiteApps where dom_id=’865′;

try again to delete the domain from Plesk.

after that if you receive the error:

ERROR: PleskFatalException
Cannot delete database which is in use by a site application

do the above:
2)open the psa database in mysql
2)run: SELECT * FROM data_bases where dom_id=’865′;
you will see the lines with the databases the domain has,
3)run: DELETE FROM FROM data_bases where dom_id=’865′;

After the 3rd step you will be able to delete the domain from Plesk, just
dont forget to manualy delete the databases (given from step 2)

Tags:

Comments No Comments »

If I compose and send a message with webmail the following error appears:

There was an error sending your message: unable to add recipient
[[email protected]]: Invalid response code received from server.

Please add the following record to Server > Mail > White list in Plesk CP:

127.0.0.1 /8

If you are not able to add that record, you can also try 127.0.0.1/255.255.0.0 or 127.0.0.1/255.0.0.0

If the record is already there, you may want to remove it and then add it again. This normall is the case if you have reinstalled any of the courier/imap components on the server (This would affect the whitelist). Ultimately, if you nothing else works, you can also add the actual ip/ip’s of the server as well.

Tags: , , ,

Comments No Comments »

Ioncube installation on Linux Plesk server.

1) Download the tar.gz file which is compatible with your server from “http://downloads.ioncube.com/”
wget http://downloads2.ioncube.com/loader…lin_x86.tar.gz

2) Untar the downloaded file.
tar -zxf ioncube_loaders_lin_x86.tar.gz

3) Move the untared file to /usr/lib/php/modules
mv ioncube /usr/lib/php/modules

4) chown -R root:root /usr/lib/php/modules/ioncube

5) vi /etc/php.ini
Add the following line before any other zend_extension

Quote:

zend_extension=/usr/lib/php/modules/ioncube/ioncube_loader_lin_5.1.so

It would go between these two entries

Quote:

zend_optimizer.version=3.3.0
zend_extension=/usr/local/Zend/lib/ZendExtensionManager.so

Save changes, then:
6) /etc/init.d/httpd restart

Now Ioncube Installed on the server, verified output

Quote:

[root@VPS server ~]# php -v
PHP 5.1.6 (cli) (built: Sep 20 2007 10:16:10)
Copyright (c) 1997-2006 The PHP Group
Zend Engine v2.1.0, Copyright (c) 1998-2006 Zend Technologies
with the ionCube PHP Loader v3.1.32, Copyright (c) 2002-2007, by ionCube Ltd., and
with Zend Extension Manager v1.2.2, Copyright (c) 2003-2007, by Zend Technologies
with Zend Optimizer v3.3.0, Copyright (c) 1998-2007, by Zend Technologies
[root@VPS server ~]#

Note:- The ionCube Loader is a Zend-Engine extension and
not a module, you need to specify the Loader using ‘zend_extension’ in
php.ini

Tags: , ,

Comments No Comments »

Currently in Plesk, there is no way to simply disable or uninstall Spam Assassin. So in order to do so, you musht remove it manually via the shell command line.

To do so, you must first SSH into the server. Once there, you must tell the server to remove the component. You can do so by typing the following;

#rpm -e psa-spamassassin

This is assuming you install the spam assassin component via the plesk updater. If you do not, you will also need to type the following;

#rpm -e spamassassin

It will then go through and remove the spam assassin configurations for each email account on the server, stop the service and then remove spam assassin from your server.

Tags: , ,

Comments 1 Comment »

If your FTP connection through Plesk fails, there are a few things you can check first.

1. Log into the server via SSH (if you are using windows, you will need a SSH client. I use Putty

2. Make sure you access su (root access).

Now that you are logged in, type te following;

ftp localhost

If you get the message of;

Connected to localhost(127.0.0.1).
220 ProFTPD 1.3.0 Server(ProFTPD)[127.0.0.1]
Name(localhost:user):

Then the ftp server is working correctly. However if you do not get that, but instead get this;

ftp:connect:Connection refused

Then there is an issue on the server. So to look into this further we need to make sure that the ftp service is running. Since this is Plesk, it will be running Proftpd and it will be running out of the Xinetd service. To verif y this, type the following;

service xinetd status

You should get the following;

xinetd (pid 23532) is running…

Now type;

lsof -i tcp:21

You should get;

COMMAND PID USER FD TYPE DEVICE SIZE NODE NAME xinetd 23532 root 5u IPv4 55265282 TCP *:ftp (LISTEN)

If you do, please try to run the FTP localhost command again.

Ftp localhost

If you get a message that states that service is not available, likely the problem is with the hostname isn’t set correctly.

To check the hostname, you simply need to type hostname at the server command line. It will return the hostname.  To change this, you will want to log into plesk and goto Server>Server Preferences and change it here. You will also want to type hostname and the name at the command line. As an example, if I wanted to change it on my server, I would type;

Hostname myservername.com

The name will then take affect. Once you have done this, restart Xinetd.

Lastly, if all else fails, you can review the log files for the service by using the following commands;

less /var/log/messages | grep proftp
less /var/log/messages | grep xinetd

Tags: , ,

Comments No Comments »