Files
crm.twinpol.com/modules/UpgradeWizard/silentUpgrade_step2.php

490 lines
17 KiB
PHP
Raw Permalink Normal View History

2025-05-12 15:44:39 +00:00
<?php
/*********************************************************************************
* SugarCRM is a customer relationship management program developed by
* SugarCRM, Inc. Copyright (C) 2004-2010 SugarCRM Inc.
*
* This program is free software; you can redistribute it and/or modify it under
* the terms of the GNU Affero General Public License version 3 as published by the
* Free Software Foundation with the addition of the following permission added
* to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
* IN WHICH THE COPYRIGHT IS OWNED BY SUGARCRM, SUGARCRM DISCLAIMS THE WARRANTY
* OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
*
* This program is distributed in the hope that it will be useful, but WITHOUT
* ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
* FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License for more
* details.
*
* You should have received a copy of the GNU Affero General Public License along with
* this program; if not, see http://www.gnu.org/licenses or write to the Free
* Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
* 02110-1301 USA.
*
* You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
* SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
*
* The interactive user interfaces in modified source and object code versions
* of this program must display Appropriate Legal Notices, as required under
* Section 5 of the GNU Affero General Public License version 3.
*
* In accordance with Section 7(b) of the GNU Affero General Public License version 3,
* these Appropriate Legal Notices must retain the display of the "Powered by
* SugarCRM" logo. If the display of the logo is not reasonably feasible for
* technical reasons, the Appropriate Legal Notices must display the words
* "Powered by SugarCRM".
********************************************************************************/
//////////////////////////////////////////////////////////////////////////////////////////
//// This is a stand alone file that can be run from the command prompt for upgrading a
//// Sugar Instance. Three parameters are required to be defined in order to execute this file.
//// php.exe -f silentUpgrade.php [Path to Upgrade Package zip] [Path to Log file] [Path to Instance]
//// See below the Usage for more details.
/////////////////////////////////////////////////////////////////////////////////////////
ini_set('memory_limit',-1);
///////////////////////////////////////////////////////////////////////////////
//// UTILITIES THAT MUST BE LOCAL :(
//Bug 24890, 24892. default_permissions not written to config.php. Following function checks and if
//no found then adds default_permissions to the config file.
function checkConfigForPermissions(){
if(file_exists(getcwd().'/config.php')){
require(getcwd().'/config.php');
}
global $sugar_config;
if(!isset($sugar_config['default_permissions'])){
$sugar_config['default_permissions'] = array (
'dir_mode' => 02770,
'file_mode' => 0660,
'user' => '',
'group' => '',
);
ksort($sugar_config);
if(is_writable('config.php') && write_array_to_file("sugar_config", $sugar_config,'config.php')) {
//writing to the file
}
}
}
function checkLoggerSettings(){
if(file_exists(getcwd().'/config.php')){
require(getcwd().'/config.php');
}
global $sugar_config;
if(!isset($sugar_config['logger'])){
$sugar_config['logger'] =array (
'level'=>'fatal',
'file' =>
array (
'ext' => '.log',
'name' => 'sugarcrm',
'dateFormat' => '%c',
'maxSize' => '10MB',
'maxLogs' => 10,
'suffix' => '%m_%Y',
),
);
ksort($sugar_config);
if(is_writable('config.php') && write_array_to_file("sugar_config", $sugar_config,'config.php')) {
//writing to the file
}
}
}
function checkResourceSettings(){
if(file_exists(getcwd().'/config.php')){
require(getcwd().'/config.php');
}
global $sugar_config;
if(!isset($sugar_config['resource_management'])){
$sugar_config['resource_management'] =
array (
'special_query_limit' => 50000,
'special_query_modules' =>
array (
0 => 'Reports',
1 => 'Export',
2 => 'Import',
3 => 'Administration',
4 => 'Sync',
),
'default_limit' => 1000,
);
ksort($sugar_config);
if(is_writable('config.php') && write_array_to_file("sugar_config", $sugar_config,'config.php')) {
//writing to the file
}
}
}
function verifyArguments($argv,$usage_regular){
$upgradeType = '';
$cwd = getcwd(); // default to current, assumed to be in a valid SugarCRM root dir.
if(isset($argv[3])) {
if(is_dir($argv[3])) {
$cwd = $argv[3];
chdir($cwd);
} else {
echo "*******************************************************************************\n";
echo "*** ERROR: 3rd parameter must be a valid directory. Tried to cd to [ {$argv[3]} ].\n";
exit(1);
}
}
//check if this is an instance
if(is_file("{$cwd}/include/entryPoint.php")) {
//this should be a regular sugar install
$upgradeType = constant('SUGARCRM_INSTALL');
//check if this is a valid zip file
if(!is_file($argv[1])) { // valid zip?
echo "*******************************************************************************\n";
echo "*** ERROR: First argument must be a full path to the patch file. Got [ {$argv[1]} ].\n";
echo $usage_regular;
echo "FAILURE\n";
exit(1);
}
if(count($argv) < 5) {
echo "*******************************************************************************\n";
echo "*** ERROR: Missing required parameters. Received ".count($argv)." argument(s), require 5.\n";
echo $usage_regular;
echo "FAILURE\n";
exit(1);
}
}
else {
//this should be a regular sugar install
echo "*******************************************************************************\n";
echo "*** ERROR: Tried to execute in a non-SugarCRM root directory.\n";
exit(1);
}
if(isset($argv[7]) && file_exists($argv[7].'SugarTemplateUtilties.php')){
require_once($argv[7].'SugarTemplateUtilties.php');
}
return $upgradeType;
}
//// END UTILITIES THAT MUST BE LOCAL :(
///////////////////////////////////////////////////////////////////////////////
// only run from command line
if(isset($_SERVER['HTTP_USER_AGENT'])) {
fwrite(STDERR,'This utility may only be run from the command line or command prompt.');
exit(1);
}
//Clean_string cleans out any file passed in as a parameter
$_SERVER['PHP_SELF'] = 'silentUpgrade.php';
///////////////////////////////////////////////////////////////////////////////
//// USAGE
$usage_regular =<<<eoq2
Usage: php.exe -f silentUpgrade.php [upgradeZipFile] [logFile] [pathToSugarInstance] [admin-user]
On Command Prompt Change directory to where silentUpgrade.php resides. Then type path to
php.exe followed by -f silentUpgrade.php and the arguments.
Example:
[path-to-PHP/]php.exe -f silentUpgrade.php [path-to-upgrade-package/]SugarEnt-Upgrade-5.2.0-to-5.5.0.zip [path-to-log-file/]silentupgrade.log [path-to-sugar-instance/] admin
Arguments:
upgradeZipFile : Upgrade package file.
logFile : Silent Upgarde log file.
pathToSugarInstance : Sugar Instance instance being upgraded.
admin-user : admin user performing the upgrade
eoq2;
//// END USAGE
///////////////////////////////////////////////////////////////////////////////
///////////////////////////////////////////////////////////////////////////////
//// STANDARD REQUIRED SUGAR INCLUDES AND PRESETS
if(!defined('sugarEntry')) define('sugarEntry', true);
$_SESSION = array();
$_SESSION['schema_change'] = 'sugar'; // we force-run all SQL
$_SESSION['silent_upgrade'] = true;
$_SESSION['step'] = 'silent'; // flag to NOT try redirect to 4.5.x upgrade wizard
$_REQUEST = array();
$_REQUEST['addTaskReminder'] = 'remind';
define('SUGARCRM_INSTALL', 'SugarCRM_Install');
define('DCE_INSTANCE', 'DCE_Instance');
global $cwd;
$cwd = getcwd(); // default to current, assumed to be in a valid SugarCRM root dir.
$upgradeType = verifyArguments($argv,$usage_regular);
$path = $argv[2]; // custom log file, if blank will use ./upgradeWizard.log
$subdirs = array('full', 'langpack', 'module', 'patch', 'theme', 'temp');
require_once('include/entryPoint.php');
require_once('modules/UpgradeWizard/uw_utils.php');
require_once('include/utils/zip_utils.php');
require_once('include/utils/sugar_file_utils.php');
require_once('include/SugarObjects/SugarConfig.php');
global $sugar_config;
$isDCEInstance = false;
$errors = array();
require('config.php');
if(isset($argv[3])) {
if(is_dir($argv[3])) {
$cwd = $argv[3];
chdir($cwd);
}
}
require_once("{$cwd}/sugar_version.php"); // provides $sugar_version & $sugar_flavor
global $sugar_config;
$configOptions = $sugar_config['dbconfig'];
$GLOBALS['log'] = LoggerManager::getLogger('SugarCRM');
$patchName = basename($argv[1]);
$zip_from_dir = substr($patchName, 0, strlen($patchName) - 4); // patch folder name (minus ".zip")
$path = $argv[2]; // custom log file, if blank will use ./upgradeWizard.log
if($sugar_version < '5.1.0'){
$db = &DBManager :: getInstance();
} else{
$db = &DBManagerFactory::getInstance();
}
$UWstrings = return_module_language('en_us', 'UpgradeWizard');
$adminStrings = return_module_language('en_us', 'Administration');
$mod_strings = array_merge($adminStrings, $UWstrings);
$subdirs = array('full', 'langpack', 'module', 'patch', 'theme', 'temp');
global $unzip_dir;
$license_accepted = false;
if(isset($argv[5]) && (strtolower($argv[5])=='yes' || strtolower($argv[5])=='y')){
$license_accepted = true;
}
//////////////////////////////////////////////////////////////////////////////
//Adding admin user to the silent upgrade
$current_user = new User();
if(isset($argv[4])) {
//if being used for internal upgrades avoid admin user verification
$user_name = $argv[4];
$q = "select id from users where user_name = '" . $user_name . "' and is_admin=1";
$result = $GLOBALS['db']->query($q, false);
$logged_user = $GLOBALS['db']->fetchByAssoc($result);
if(isset($logged_user['id']) && $logged_user['id'] != null){
//do nothing
$current_user->retrieve($logged_user['id']);
}
else{
echo "Not an admin user in users table. Please provide an admin user\n";
exit(1);
}
}
else {
echo "*******************************************************************************\n";
echo "*** ERROR: 4th parameter must be a valid admin user.\n";
echo $usage;
echo "FAILURE\n";
exit(1);
}
/////retrieve admin user
$unzip_dir = clean_path("{$cwd}/{$sugar_config['upload_dir']}upgrades/temp");
$install_file = clean_path("{$cwd}/{$sugar_config['upload_dir']}upgrades/patch/".basename($argv[1]));
$_SESSION['unzip_dir'] = $unzip_dir;
$_SESSION['install_file'] = $install_file;
$_SESSION['zip_from_dir'] = $zip_from_dir;
mkdir_recursive($unzip_dir);
if(!is_dir($unzip_dir)) {
fwrite(STDERR,"\n{$unzip_dir} is not an available directory\nFAILURE\n");
exit(1);
}
unzip($argv[1], $unzip_dir);
// mimic standard UW by copy patch zip to appropriate dir
copy($argv[1], $install_file);
//// END UPGRADE PREP
///////////////////////////////////////////////////////////////////////////////
if(function_exists('set_upgrade_vars')){
set_upgrade_vars();
}
/*
if($configOptions['db_type'] == 'mysql'){
//Change the db wait_timeout for this session
$que ="select @@wait_timeout";
$result = $db->query($que);
$tb = $db->fetchByAssoc($result);
logThis('Wait Timeout before change ***** '.$tb['@@wait_timeout'] , $path);
$query ="set wait_timeout=28800";
$db->query($query);
$result = $db->query($que);
$ta = $db->fetchByAssoc($result);
logThis('Wait Timeout after change ***** '.$ta['@@wait_timeout'] , $path);
}
*/
///////////////////////////////////////////////////////////////////////////////
//// RUN SILENT UPGRADE
ob_start();
set_time_limit(0);
/// RELOAD NEW DEFINITIONS
global $ACLActions, $beanList, $beanFiles;
include('modules/ACLActions/actiondefs.php');
include('include/modules.php');
// clear out the theme cache
if(is_dir($GLOBALS['sugar_config']['cache_dir'].'themes')){
$allModFiles = array();
$allModFiles = findAllFiles($GLOBALS['sugar_config']['cache_dir'].'themes',$allModFiles);
foreach($allModFiles as $file){
//$file_md5_ref = str_replace(clean_path(getcwd()),'',$file);
if(file_exists($file)){
unlink($file);
}
}
}
// re-minify the JS source files
$_REQUEST['root_directory'] = getcwd();
$_REQUEST['js_rebuild_concat'] = 'rebuild';
require_once('jssource/minify.php');
//First repair the databse to ensure it is up to date with the new vardefs/tabledefs
logThis('About to repair the database.', $path);
//Use Repair and rebuild to update the database.
global $dictionary;
require_once("modules/Administration/QuickRepairAndRebuild.php");
$rac = new RepairAndClear();
$rac->clearVardefs();
$rac->rebuildExtensions();
$repairedTables = array();
foreach ($beanFiles as $bean => $file) {
if(file_exists($file)){
unset($GLOBALS['dictionary'][$bean]);
require_once($file);
$focus = new $bean ();
if(empty($focus->table_name) || isset($repairedTables[$focus->table_name])) {
continue;
}
if (($focus instanceOf SugarBean)) {
$sql = $db->repairTable($focus, true);
if(!empty($sql)) {
logThis($sql, $path);
$repairedTables[$focus->table_name] = true;
}
}
}
}
unset ($dictionary);
include ("{$argv[3]}/modules/TableDictionary.php");
foreach ($dictionary as $meta) {
$tablename = $meta['table'];
if(isset($repairedTables[$tablename])) {
continue;
}
$fielddefs = $meta['fields'];
$indices = $meta['indices'];
$sql = $GLOBALS['db']->repairTableParams($tablename, $fielddefs, $indices, true);
if(!empty($sql)) {
logThis($sql, $path);
$repairedTables[$tablename] = true;
}
}
logThis('database repaired', $path);
include("{$cwd}/{$sugar_config['upload_dir']}upgrades/temp/manifest.php");
$ce_to_pro_ent = isset($manifest['name']) && ($manifest['name'] == 'SugarCE to SugarPro' || $manifest['name'] == 'SugarCE to SugarEnt');
$origVersion = substr(preg_replace("/[^0-9]/", "", $sugar_version),0,3);
if($origVersion < '550' || $ce_to_pro_ent) {
//add the global team if it does not exist
$globalteam = new Team();
$globalteam->retrieve('1');
require_once('modules/Administration/language/en_us.lang.php');
if(isset($globalteam->name)){
echo 'Global '.$mod_strings['LBL_UPGRADE_TEAM_EXISTS'].'<br>';
logThis(" Finish Building Global Team", $path);
}else{
$globalteam->create_team("Global", $mod_strings['LBL_GLOBAL_TEAM_DESC'], $globalteam->global_team);
}
logThis(" Start Building private teams", $path);
upgradeModulesForTeam();
logThis(" Finish Building private teams", $path);
logThis(" Start Building the team_set and team_sets_teams", $path);
upgradeModulesForTeamsets();
logThis(" Finish Building the team_set and team_sets_teams", $path);
logThis(" Start modules/Administration/upgradeTeams.php", $path);
include('modules/Administration/upgradeTeams.php');
logThis(" Finish modules/Administration/upgradeTeams.php", $path);
if($sugar_config['dbconfig']['db_type'] == 'mssql') {
if(check_FTS()){
$GLOBALS['db']->wakeupFTS();
}
}
}
///////////////////////////////////////////////////////////////////////////////
//// TAKE OUT TRASH
if(empty($errors)) {
set_upgrade_progress('end','in_progress','unlinkingfiles','in_progress');
logThis('Taking out the trash, unlinking temp files.', $path);
unlinkTempFiles(true);
logThis('Taking out the trash, done.', $path);
}
///////////////////////////////////////////////////////////////////////////////
//// RECORD ERRORS
$phpErrors = ob_get_contents();
ob_end_clean();
logThis("**** Potential PHP generated error messages: {$phpErrors}", $path);
if(count($errors) > 0) {
foreach($errors as $error) {
logThis("****** SilentUpgrade ERROR: {$error}", $path);
}
echo "FAILED\n";
} else {
logThis("***** SilentUpgrade completed successfully.", $path);
echo "********************************************************************\n";
echo "*************************** SUCCESS*********************************\n";
echo "********************************************************************\n";
echo "******** If your pre-upgrade Leads data is not showing ************\n";
echo "******** Or you see errors in detailview subpanels ****************\n";
echo "************* In order to resolve them ****************************\n";
echo "******** Log into application as Administrator ********************\n";
echo "******** Go to Admin panel ****************************************\n";
echo "******** Run Repair -> Rebuild Relationships **********************\n";
echo "********************************************************************\n";
}
?>