Parallels Virtualization and Automation Software

SYMPTOMS

SiteBuilder node is in Unavailable status in HSPcomplete system after SiteBuilder node upgrade.

CAUSE

SiteBuilder-related data in HSPcomplete database should be updated after SiteBuilder node upgrade

RESOLUTION

To update SiteBuilder-related data in HSPcomplete database it should be possible to use /usr/sbin/hspc-sb-upgrade.pl script included in HSPcomplete distribution and the following instructions:

Please do not synchronize SiteBuilder node while HSPcomplete database update is not finished.

1. Preparations:
   
   • SiteBuilder should be upgraded at least till 3.0.2 version
   • backup SiteBuilder node
   • HSPcomplete system should be upgraded to latest available version
   • backup HSPcomplete database:
     
# mysqldump aspc|gzip>aspc.dump.`date +%s`.sql.gz
# mysqldump aspc --extended-insert=false -raspc_sb_backup.`date +%Y%m%d_%H%M`.sql \
sb_node sb_site sb_plan_alias sb_account sb_license sb_site_family_license sb_pageset_license

   • disable Update SiteBuilder nodes info task setting Scheduled field to some date far in future (one year in advance) on Top > Action Log > Task queue > Update SiteBuilder nodes info screen, otherwise the task execution will delete existing sites in HSPcomplete system
     
   • set log-level to DEBUG in HSPcomplete on Top > Configuration Director > Logging and Errors > Log Settings screen
2. Database update:
   • execute /usr/sbin/hspc-sb-upgrade.pl script from HSPcomplete distribution first time:
     • answer "yes" on 'Do you wish to proceed to plans and sites manipulations?' request,
     • answer "no" to all requests to update sites
     • answer "yes" on 'Release lock now?' request
     
     
   • synchronize modules/templates/plans using Synchronize button on Top > Service Director > SiteBuilder Manager > Setup > Modules/Templates screen:
     • synchronize modules on Top > Service Director > SiteBuilder Manager > Setup > Modules screen
     • synchronize templates on Top > Service Director > SiteBuilder Manager > Setup > Modules screen
     • synchronize plans on Top > Service Director > SiteBuilder Manager > Plans > Plan name > Nodes screen:
       • in case plan is not compatible - click on 'Details' link and unselect missing modules/templates in the plan properties
   • execute the script /usr/sbin/hspc-sb-upgrade.pl once again answering "yes" to requests to upgrade sites (if there are any)
   • check if all sites upgraded, none deleted and enable task Update SiteBuilder nodes info setting Scheduled field to current date on Top > Action Log > Task queue > Update SiteBuilder nodes info screen