• Article for your preferred language does not exist. Below is international version of the article.

Article ID: 2048, created on Jul 24, 2007, last review on Apr 27, 2014

  • Applies to:
  • Odin Business Automation Standard

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

400e18f6ede9f8be5575a475d2d6b0a6 caea8340e2d186a540518d08602aa065

Email subscription for changes to this article
Save as PDF