Gentoo Blog

I came across this error yesterday for the first time in Plesk 8.2.1. Following solution corrected the error

1. Log in to the Mysql shell as root or open phpmyadmin as admin/root user.

2. Issue the following command in the Mysql shell

UPDATE psa.hosting SET webstat = 'none' WHERE webstat = '';

If you use phpmyadmin invoke the command without the “;” symbol at the end.

Changing you IP in Plesk is a lot easier than in confixx. Swsoft provides a script for doing this.

The utility is available in the $PRODUCT_ROOT/bin directory. Normally something like /usr/local/psa/bin

The script is called reconfigurator.pl

The new IP addresse must NOT exist in Server > IP Addresses list in Plesk control panel before replacement, they may be added on system level only. If IP addresses do not exist in the system, the utility will add new IPs to the system as well. I recommend not to add the IP address prior to running the script because the reconfigurator.pl script takes care of this for you.

First, you have to run the command to create a template file. Then, edit the file to set an appropriate IP mapping and run the command once again.

The map file will contain the list of your current IP addresses.

You’ll need to edit the file with the new IP address (please, note that the new IP comes on the right hand side of the arrow):

eth0:your_old_ip 255.255.255.0 -> eth0:your_new_ip_address 255.255.255.0

For example:

1. $PRODUCT_ROOT/bin/reconfigurator.pl ip_map.txt
2. Modify ip_map.txt file
3. $PRODUCT_ROOT/bin/reconfigurator.pl ip_map.txt

First configure your network device with you new IP. If you want to keep everything working consider using eth0:1 or iproute2 to configure additional IP’s. Then login to the confixx webinterface click on settings standard domain and change your IP address to the new one. Confixx will start working in the background and change your apache and postfix settings to reflect the new IP. However confixx forgets a few essential things.

1. The IP address for the confixx webinterface

2. The confixx_mhost.conf

Make sure you have you Mysql root login handy. Log in to Mysql with your root password.

mysql -u root -p

use confixx;

UPDATE `admin` SET `confixx_ip` = '83.110.x.new' WHERE `confixx_ip` = '84.110.x.old' ;

That’s it please make sure to backup your confixx database before you preform these steps.

Then the confixx_mhost.conf normally under

/etc/apache/confixx_mhost.conf

or /etc/httpd/conf/confixx_mhost.conf

open the file with vi confixx_mhost.conf

and use the search and replace function in vi

:%s/your_old_ip/your_new_ip/g

That’s it you should have a running confixx with your new IP. Important before you preform these steps don’t forget to send DNS updates for all you Domains. Otherwise you will be left disconnected domains.