====== Changing ispcp IP address ======

This howto describes howto change the ip address of the ispcp control panel.
Some parts are in the database and some are in the configuration files.

Please report any bugs/hints/whatever in the following board thread: http://www.isp-control.net/forum/thread-6448.html

Thanks to kurgans for the information, the original thread was at http://www.isp-control.net/forum/thread-6234.html

====== Modifications to the database ======

Stop daemon ispcp

  /etc/init.d/ispcp_daemon stop

Changes in mysql

  mysql -u root -p
  mysql> USE ispcp;
  mysql> UPDATE server_ips SET ip_number = "server2-ip" WHERE ip_id = 1;
  mysql> UPDATE `domain` SET `domain_status` = 'change' WHERE `domain_status` = 'ok';
  mysql> UPDATE `subdomain` SET `subdomain_status` = 'change' WHERE `subdomain_status` = 'ok';
  mysql> UPDATE `domain_aliasses` SET `alias_status` = 'change' WHERE `alias_status` = 'ok';
  mysql> UPDATE mail_users SET status="toadd" where status="ok";
  mysql> quit

Run script

  /var/www/ispcp/engine/ispcp-rqst-mngr

Start ispcp daemon

  /etc/init.d/ispcp_daemon start
  
====== Change IP in /etc/ispcp/ispcp.conf ======  

  BASE_SERVER_IP = yyy.yyy.yyy.yyy

====== Change Bind and Apache IP ======
Hint: xxx.xxx.xxx.xxx = old IP, yyy.yyy.yyy.yyy = new IP

Replace the old ip in the affected files
  sed -i "s/xxx.xxx.xxx.xxx/yyy.yyy.yyy.yyy/g" /etc/apache2/sites-available/* /etc/bind/* /var/cache/bind/* /etc/ispcp/*/working/*

Restart services

  /etc/init.d/apache2 restart
  /etc/init.d/bind9 restart