Migration from cPanel to cPanel2


The cPanel module uses the API version 1 which is deprecated. To avoid using a deprecated version, use the cPanel2 module which uses the API version 2. Below you will find the instruction that will help you to migrate all servers from the cPanel module to cPanel2.

Migration


  1. Make sure that the Cpanel2 module is enabled.
  2. Connect to the database.
  3. You should run the query which is below.

Query

Migration from cPanel to cPanel2
SET @cpanel2 = (SELECT `id` FROM hb_modules_configuration WHERE `filename` = 'class.cpanel2.php'),
@cpanel = (SELECT `id` FROM hb_modules_configuration WHERE `filename` = 'class.cpanel.php');
UPDATE hb_server_groups g, hb_servers s, hb_products_modules p
SET g.`module` = IF(@cpanel2 IS NOT NULL, @cpanel2, @cpanel), 
s.`default_module` = IF(@cpanel2 IS NOT NULL, @cpanel2, @cpanel), 
p.`module` = IF(@cpanel2 IS NOT NULL, @cpanel2, @cpanel)
WHERE g.`module` = @cpanel AND s.`default_module` = @cpanel AND p.`module` = @cpanel;

If you do not have any program to connect to the database, you can execute this query using the command line.

  1. Log in to the server where you have the HostBill installation.
  2. Then use the commands:
mysql;
use {$database_name};

Where {$database_name} is the name of the database you want to connect to. You can find the name of your database in the file public_html/includes/config.php

Then execute the SQL query that is above.

Related modules