]> CyberLeo.Net >> Repos - Github/sugarcrm.git/blob - modules/UpgradeWizard/silentUpgrade_step1.php
Release 6.5.1
[Github/sugarcrm.git] / modules / UpgradeWizard / silentUpgrade_step1.php
1 <?php
2
3 /*********************************************************************************
4  * SugarCRM Community Edition is a customer relationship management program developed by
5  * SugarCRM, Inc. Copyright (C) 2004-2012 SugarCRM Inc.
6  * 
7  * This program is free software; you can redistribute it and/or modify it under
8  * the terms of the GNU Affero General Public License version 3 as published by the
9  * Free Software Foundation with the addition of the following permission added
10  * to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
11  * IN WHICH THE COPYRIGHT IS OWNED BY SUGARCRM, SUGARCRM DISCLAIMS THE WARRANTY
12  * OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
13  * 
14  * This program is distributed in the hope that it will be useful, but WITHOUT
15  * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
16  * FOR A PARTICULAR PURPOSE.  See the GNU Affero General Public License for more
17  * details.
18  * 
19  * You should have received a copy of the GNU Affero General Public License along with
20  * this program; if not, see http://www.gnu.org/licenses or write to the Free
21  * Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
22  * 02110-1301 USA.
23  * 
24  * You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
25  * SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
26  * 
27  * The interactive user interfaces in modified source and object code versions
28  * of this program must display Appropriate Legal Notices, as required under
29  * Section 5 of the GNU Affero General Public License version 3.
30  * 
31  * In accordance with Section 7(b) of the GNU Affero General Public License version 3,
32  * these Appropriate Legal Notices must retain the display of the "Powered by
33  * SugarCRM" logo. If the display of the logo is not reasonably feasible for
34  * technical reasons, the Appropriate Legal Notices must display the words
35  * "Powered by SugarCRM".
36  ********************************************************************************/
37
38
39 //////////////////////////////////////////////////////////////////////////////////////////
40 //// This is a stand alone file that can be run from the command prompt for upgrading a
41 //// Sugar Instance. Three parameters are required to be defined in order to execute this file.
42 //// php.exe -f silentUpgrade.php [Path to Upgrade Package zip] [Path to Log file] [Path to Instance]
43 //// See below the Usage for more details.
44 /////////////////////////////////////////////////////////////////////////////////////////
45 ini_set('memory_limit',-1);
46 ///////////////////////////////////////////////////////////////////////////////
47 ////    UTILITIES THAT MUST BE LOCAL :(
48 function prepSystemForUpgradeSilent() {
49         global $subdirs;
50         global $cwd;
51         global $sugar_config;
52
53         // make sure dirs exist
54         foreach($subdirs as $subdir) {
55                 if(!is_dir($sugar_config['upload_dir']."/upgrades/{$subdir}")) {
56                 mkdir_recursive($sugar_config['upload_dir']."/upgrades/{$subdir}");
57                 }
58         }
59 }
60
61 //local function for clearing cache
62 function clearCacheSU($thedir, $extension) {
63         if ($current = @opendir($thedir)) {
64                 while (false !== ($children = readdir($current))) {
65                         if ($children != "." && $children != "..") {
66                                 if (is_dir($thedir . "/" . $children)) {
67                                         clearCacheSU($thedir . "/" . $children, $extension);
68                                 }
69                                 elseif (is_file($thedir . "/" . $children) && substr_count($children, $extension)) {
70                                         unlink($thedir . "/" . $children);
71                                 }
72                         }
73                 }
74         }
75  }
76  //Bug 24890, 24892. default_permissions not written to config.php. Following function checks and if
77  //no found then adds default_permissions to the config file.
78  function checkConfigForPermissions(){
79      if(file_exists(getcwd().'/config.php')){
80          require(getcwd().'/config.php');
81      }
82      global $sugar_config;
83      if(!isset($sugar_config['default_permissions'])){
84              $sugar_config['default_permissions'] = array (
85                      'dir_mode' => 02770,
86                      'file_mode' => 0660,
87                      'user' => '',
88                      'group' => '',
89              );
90          ksort($sugar_config);
91          if(is_writable('config.php') && write_array_to_file("sugar_config", $sugar_config,'config.php')) {
92                 //writing to the file
93                 }
94      }
95 }
96 function checkLoggerSettings(){
97         if(file_exists(getcwd().'/config.php')){
98          require(getcwd().'/config.php');
99      }
100     global $sugar_config;
101         if(!isset($sugar_config['logger'])){
102             $sugar_config['logger'] =array (
103                         'level'=>'fatal',
104                     'file' =>
105                      array (
106                       'ext' => '.log',
107                       'name' => 'sugarcrm',
108                       'dateFormat' => '%c',
109                       'maxSize' => '10MB',
110                       'maxLogs' => 10,
111                       'suffix' => '', // bug51583, change default suffix to blank for backwards comptability
112                     ),
113                   );
114                  ksort($sugar_config);
115          if(is_writable('config.php') && write_array_to_file("sugar_config", $sugar_config,'config.php')) {
116                 //writing to the file
117                 }
118          }
119 }
120
121 function checkLeadConversionSettings() {
122     if (file_exists(getcwd().'/config.php')) {
123          require(getcwd().'/config.php');
124     }
125     global $sugar_config;
126     if (!isset($sugar_config['lead_conv_activity_opt'])) {
127         $sugar_config['lead_conv_activity_opt'] = 'copy';
128         ksort($sugar_config);
129         if (is_writable('config.php') && write_array_to_file("sugar_config", $sugar_config,'config.php')) {
130             //writing to the file
131         }
132     }
133 }
134
135 function checkResourceSettings(){
136         if(file_exists(getcwd().'/config.php')){
137          require(getcwd().'/config.php');
138      }
139     global $sugar_config;
140         if(!isset($sugar_config['resource_management'])){
141           $sugar_config['resource_management'] =
142                   array (
143                     'special_query_limit' => 50000,
144                     'special_query_modules' =>
145                     array (
146                       0 => 'Reports',
147                       1 => 'Export',
148                       2 => 'Import',
149                       3 => 'Administration',
150                       4 => 'Sync',
151                     ),
152                     'default_limit' => 1000,
153                   );
154                  ksort($sugar_config);
155          if(is_writable('config.php') && write_array_to_file("sugar_config", $sugar_config,'config.php')) {
156                 //writing to the file
157                 }
158         }
159 }
160
161
162 function createMissingRels(){
163         $relForObjects = array('leads'=>'Leads','campaigns'=>'Campaigns','prospects'=>'Prospects');
164         foreach($relForObjects as $relObjName=>$relModName){
165                 //assigned_user
166                 $guid = create_guid();
167                 $query = "SELECT id FROM relationships WHERE relationship_name = '{$relObjName}_assigned_user'";
168                 $result= $GLOBALS['db']->query($query, true);
169                 $a = null;
170                 $a = $GLOBALS['db']->fetchByAssoc($result);
171                 if(!isset($a['id']) && empty($a['id']) ){
172                         $qRel = "INSERT INTO relationships (id,relationship_name, lhs_module, lhs_table, lhs_key, rhs_module, rhs_table, rhs_key, join_table, join_key_lhs, join_key_rhs, relationship_type, relationship_role_column, relationship_role_column_value, reverse, deleted)
173                                                 VALUES ('{$guid}', '{$relObjName}_assigned_user','Users','users','id','{$relModName}','{$relObjName}','assigned_user_id',NULL,NULL,NULL,'one-to-many',NULL,NULL,'0','0')";
174                         $GLOBALS['db']->query($qRel);
175                 }
176                 //modified_user
177                 $guid = create_guid();
178                 $query = "SELECT id FROM relationships WHERE relationship_name = '{$relObjName}_modified_user'";
179                 $result= $GLOBALS['db']->query($query, true);
180                 $a = null;
181                 $a = $GLOBALS['db']->fetchByAssoc($result);
182                 if(!isset($a['id']) && empty($a['id']) ){
183                         $qRel = "INSERT INTO relationships (id,relationship_name, lhs_module, lhs_table, lhs_key, rhs_module, rhs_table, rhs_key, join_table, join_key_lhs, join_key_rhs, relationship_type, relationship_role_column, relationship_role_column_value, reverse, deleted)
184                                                 VALUES ('{$guid}', '{$relObjName}_modified_user','Users','users','id','{$relModName}','{$relObjName}','modified_user_id',NULL,NULL,NULL,'one-to-many',NULL,NULL,'0','0')";
185                         $GLOBALS['db']->query($qRel);
186                 }
187                 //created_by
188                 $guid = create_guid();
189                 $query = "SELECT id FROM relationships WHERE relationship_name = '{$relObjName}_created_by'";
190                 $result= $GLOBALS['db']->query($query, true);
191                 $a = null;
192                 $a = $GLOBALS['db']->fetchByAssoc($result);
193         if(!isset($a['id']) && empty($a['id']) ){
194                         $qRel = "INSERT INTO relationships (id,relationship_name, lhs_module, lhs_table, lhs_key, rhs_module, rhs_table, rhs_key, join_table, join_key_lhs, join_key_rhs, relationship_type, relationship_role_column, relationship_role_column_value, reverse, deleted)
195                                                 VALUES ('{$guid}', '{$relObjName}_created_by','Users','users','id','{$relModName}','{$relObjName}','created_by',NULL,NULL,NULL,'one-to-many',NULL,NULL,'0','0')";
196                         $GLOBALS['db']->query($qRel);
197         }
198                 $guid = create_guid();
199                 $query = "SELECT id FROM relationships WHERE relationship_name = '{$relObjName}_team'";
200                 $result= $GLOBALS['db']->query($query, true);
201                 $a = null;
202                 $a = $GLOBALS['db']->fetchByAssoc($result);
203                 if(!isset($a['id']) && empty($a['id']) ){
204                         $qRel = "INSERT INTO relationships (id,relationship_name, lhs_module, lhs_table, lhs_key, rhs_module, rhs_table, rhs_key, join_table, join_key_lhs, join_key_rhs, relationship_type, relationship_role_column, relationship_role_column_value, reverse, deleted)
205                                                         VALUES ('{$guid}', '{$relObjName}_team','Teams','teams','id','{$relModName}','{$relObjName}','team_id',NULL,NULL,NULL,'one-to-many',NULL,NULL,'0','0')";
206                         $GLOBALS['db']->query($qRel);
207                 }
208         }
209         //Also add tracker perf relationship
210         $guid = create_guid();
211         $query = "SELECT id FROM relationships WHERE relationship_name = 'tracker_monitor_id'";
212         $result= $GLOBALS['db']->query($query, true);
213         $a = null;
214         $a = $GLOBALS['db']->fetchByAssoc($result);
215         if(!isset($a['id']) && empty($a['id']) ){
216                 $qRel = "INSERT INTO relationships (id,relationship_name, lhs_module, lhs_table, lhs_key, rhs_module, rhs_table, rhs_key, join_table, join_key_lhs, join_key_rhs, relationship_type, relationship_role_column, relationship_role_column_value, reverse, deleted)
217                                         VALUES ('{$guid}', 'tracker_monitor_id','TrackerPerfs','tracker_perf','monitor_id','Trackers','tracker','monitor_id',NULL,NULL,NULL,'one-to-many',NULL,NULL,'0','0')";
218                 $GLOBALS['db']->query($qRel);
219         }
220 }
221
222
223 /**
224  * This function will merge password default settings into config file
225  * @param   $sugar_config
226  * @param   $sugar_version
227  * @return  bool true if successful
228  */
229 function merge_passwordsetting($sugar_config, $sugar_version) {
230
231      $passwordsetting_defaults = array (
232         'passwordsetting' => array (
233             'minpwdlength' => '',
234             'maxpwdlength' => '',
235             'oneupper' => '',
236             'onelower' => '',
237             'onenumber' => '',
238             'onespecial' => '',
239             'SystemGeneratedPasswordON' => '',
240             'generatepasswordtmpl' => '',
241             'lostpasswordtmpl' => '',
242             'customregex' => '',
243             'regexcomment' => '',
244             'forgotpasswordON' => false,
245             'linkexpiration' => '1',
246             'linkexpirationtime' => '30',
247             'linkexpirationtype' => '1',
248             'userexpiration' => '0',
249             'userexpirationtime' => '',
250             'userexpirationtype' => '1',
251             'userexpirationlogin' => '',
252             'systexpiration' => '0',
253             'systexpirationtime' => '',
254             'systexpirationtype' => '0',
255             'systexpirationlogin' => '',
256             'lockoutexpiration' => '0',
257             'lockoutexpirationtime' => '',
258             'lockoutexpirationtype' => '1',
259             'lockoutexpirationlogin' => '',
260         ),
261     );
262
263     $sugar_config = sugarArrayMerge($passwordsetting_defaults, $sugar_config );
264
265     // need to override version with default no matter what
266     $sugar_config['sugar_version'] = $sugar_version;
267
268     ksort( $sugar_config );
269
270     if( write_array_to_file( "sugar_config", $sugar_config, "config.php" ) ){
271         return true;
272     }
273     else {
274         return false;
275     }
276 }
277
278 function addDefaultModuleRoles($defaultRoles = array()) {
279         foreach($defaultRoles as $roleName=>$role){
280         foreach($role as $category=>$actions){
281             foreach($actions as $name=>$access_override){
282                     $query = "SELECT * FROM acl_actions WHERE name='$name' AND category = '$category' AND acltype='$roleName' AND deleted=0 ";
283                                         $result = $GLOBALS['db']->query($query);
284                                         //only add if an action with that name and category don't exist
285                                         $row=$GLOBALS['db']->fetchByAssoc($result);
286                                         if ($row == null) {
287                                 $guid = create_guid();
288                                 $currdate = gmdate('Y-m-d H:i:s');
289                                 $query= "INSERT INTO acl_actions (id,date_entered,date_modified,modified_user_id,name,category,acltype,aclaccess,deleted ) VALUES ('$guid','$currdate','$currdate','1','$name','$category','$roleName','$access_override','0')";
290                                                 $GLOBALS['db']->query($query);
291                         }
292             }
293         }
294         }
295 }
296
297 function verifyArguments($argv,$usage_regular){
298     $upgradeType = '';
299     $cwd = getcwd(); // default to current, assumed to be in a valid SugarCRM root dir.
300     if(isset($argv[3])) {
301         if(is_dir($argv[3])) {
302             $cwd = $argv[3];
303             chdir($cwd);
304         } else {
305             echo "*******************************************************************************\n";
306             echo "*** ERROR: 3rd parameter must be a valid directory.  Tried to cd to [ {$argv[3]} ].\n";
307             exit(1);
308         }
309     }
310
311     if(is_file("{$cwd}/include/entryPoint.php")) {
312         //this should be a regular sugar install
313         $upgradeType = constant('SUGARCRM_INSTALL');
314         //check if this is a valid zip file
315         if(!is_file($argv[1])) { // valid zip?
316             echo "*******************************************************************************\n";
317             echo "*** ERROR: First argument must be a full path to the patch file. Got [ {$argv[1]} ].\n";
318             echo $usage_regular;
319             echo "FAILURE\n";
320             exit(1);
321         }
322         if(count($argv) < 5) {
323             echo "*******************************************************************************\n";
324             echo "*** ERROR: Missing required parameters.  Received ".count($argv)." argument(s), require 5.\n";
325             echo $usage_regular;
326             echo "FAILURE\n";
327             exit(1);
328         }
329     } else {
330         //this should be a regular sugar install
331         echo "*******************************************************************************\n";
332         echo "*** ERROR: Tried to execute in a non-SugarCRM root directory.\n";
333         exit(1);
334     }
335
336     if(isset($argv[7]) && file_exists($argv[7].'SugarTemplateUtilties.php')){
337         require_once($argv[7].'SugarTemplateUtilties.php');
338     }
339
340     return $upgradeType;
341 }
342
343
344
345 function threeWayMerge(){
346         //using threeway merge apis
347 }
348
349 ////    END UTILITIES THAT MUST BE LOCAL :(
350 ///////////////////////////////////////////////////////////////////////////////
351
352 //Bug 52872. Dies if the request does not come from CLI.
353 $sapi_type = php_sapi_name();
354 if (substr($sapi_type, 0, 3) != 'cli') {
355     die("This is command-line only script");
356 }
357 //End of #52872
358
359 // only run from command line
360 if(isset($_SERVER['HTTP_USER_AGENT'])) {
361         fwrite(STDERR,'This utility may only be run from the command line or command prompt.');
362         exit(1);
363 }
364 //Clean_string cleans out any file  passed in as a parameter
365 $_SERVER['PHP_SELF'] = 'silentUpgrade.php';
366
367 $usage_regular =<<<eoq2
368 Usage: php.exe -f silentUpgrade.php [upgradeZipFile] [logFile] [pathToSugarInstance] [admin-user]
369
370 On Command Prompt Change directory to where silentUpgrade.php resides. Then type path to
371 php.exe followed by -f silentUpgrade.php and the arguments.
372
373 Example:
374     [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
375
376 Arguments:
377     upgradeZipFile                       : Upgrade package file.
378     logFile                              : Silent Upgarde log file.
379     pathToSugarInstance                  : Sugar Instance instance being upgraded.
380     admin-user                           : admin user performing the upgrade
381 eoq2;
382 ////    END USAGE
383 ///////////////////////////////////////////////////////////////////////////////
384
385
386
387 ///////////////////////////////////////////////////////////////////////////////
388 ////    STANDARD REQUIRED SUGAR INCLUDES AND PRESETS
389 if(!defined('sugarEntry')) define('sugarEntry', true);
390
391 $_SESSION = array();
392 $_SESSION['schema_change'] = 'sugar'; // we force-run all SQL
393 $_SESSION['silent_upgrade'] = true;
394 $_SESSION['step'] = 'silent'; // flag to NOT try redirect to 4.5.x upgrade wizard
395
396 $_REQUEST = array();
397 $_REQUEST['addTaskReminder'] = 'remind';
398
399
400 define('SUGARCRM_INSTALL', 'SugarCRM_Install');
401 define('DCE_INSTANCE', 'DCE_Instance');
402
403 global $cwd;
404 $cwd = getcwd(); // default to current, assumed to be in a valid SugarCRM root dir.
405
406 $upgradeType = verifyArguments($argv,$usage_regular);
407
408 ///////////////////////////////////////////////////////////////////////////////
409 //////  Verify that all the arguments are appropriately placed////////////////
410
411 $path                   = $argv[2]; // custom log file, if blank will use ./upgradeWizard.log
412 $subdirs                = array('full', 'langpack', 'module', 'patch', 'theme', 'temp');
413
414 //$_REQUEST['zip_from_dir'] = $zip_from_dir;
415
416 define('SUGARCRM_PRE_INSTALL_FILE', 'scripts/pre_install.php');
417 define('SUGARCRM_POST_INSTALL_FILE', 'scripts/post_install.php');
418 define('SUGARCRM_PRE_UNINSTALL_FILE', 'scripts/pre_uninstall.php');
419 define('SUGARCRM_POST_UNINSTALL_FILE', 'scripts/post_uninstall.php');
420
421
422
423 echo "\n";
424 echo "********************************************************************\n";
425 echo "***************This Upgrade process may take sometime***************\n";
426 echo "********************************************************************\n";
427 echo "\n";
428
429 global $sugar_config;
430 $isDCEInstance = false;
431 $errors = array();
432
433
434 if($upgradeType != constant('DCE_INSTANCE')) {
435
436         ini_set('error_reporting',1);
437         require_once('include/entryPoint.php');
438         require_once('include/SugarLogger/SugarLogger.php');
439         require_once('include/utils/zip_utils.php');
440
441
442 if(!function_exists('sugar_cached'))
443 {
444     /**
445      * sugar_cached
446      *
447      * @param $file The path to retrieve cache lookup information for
448      * @return string The cached path according to $GLOBALS['sugar_config']['cache_dir'] or just appended with cache if not defined
449      */
450     function sugar_cached($file)
451     {
452         static $cdir = null;
453         if(empty($cdir) && !empty($GLOBALS['sugar_config']['cache_dir'])) {
454             $cdir = rtrim($GLOBALS['sugar_config']['cache_dir'], '/\\');
455         }
456         if(empty($cdir)) {
457             $cdir = "cache";
458         }
459         return "$cdir/$file";
460     }
461 }
462
463         require('config.php');
464         //require_once('modules/UpgradeWizard/uw_utils.php'); // must upgrade UW first
465         if(isset($argv[3])) {
466                 if(is_dir($argv[3])) {
467                         $cwd = $argv[3];
468                         chdir($cwd);
469                 }
470         }
471
472         require_once("{$cwd}/sugar_version.php"); // provides $sugar_version & $sugar_flavor
473
474     $GLOBALS['log']     = LoggerManager::getLogger('SugarCRM');
475         $patchName              = basename($argv[1]);
476         $zip_from_dir   = substr($patchName, 0, strlen($patchName) - 4); // patch folder name (minus ".zip")
477         $path                   = $argv[2]; // custom log file, if blank will use ./upgradeWizard.log
478
479     $db                         = &DBManagerFactory::getInstance();
480         $UWstrings              = return_module_language('en_us', 'UpgradeWizard');
481         $adminStrings   = return_module_language('en_us', 'Administration');
482     $app_list_strings = return_app_list_strings_language('en_us');
483         $mod_strings    = array_merge($adminStrings, $UWstrings);
484         $subdirs                = array('full', 'langpack', 'module', 'patch', 'theme', 'temp');
485         global $unzip_dir;
486     $license_accepted = false;
487     if(isset($argv[5]) && (strtolower($argv[5])=='yes' || strtolower($argv[5])=='y')){
488         $license_accepted = true;
489          }
490         //////////////////////////////////////////////////////////////////////////////
491         //Adding admin user to the silent upgrade
492
493         $current_user = new User();
494         if(isset($argv[4])) {
495            //if being used for internal upgrades avoid admin user verification
496            $user_name = $argv[4];
497            $q = "select id from users where user_name = '" . $user_name . "' and is_admin=1";
498            $result = $GLOBALS['db']->query($q, false);
499            $logged_user = $GLOBALS['db']->fetchByAssoc($result);
500            if(isset($logged_user['id']) && $logged_user['id'] != null){
501                 //do nothing
502             $current_user->retrieve($logged_user['id']);
503            }
504            else{
505                 echo "FAILURE: Not an admin user in users table. Please provide an admin user\n";
506                 exit(1);
507            }
508         }
509         else {
510                 echo "*******************************************************************************\n";
511                 echo "*** ERROR: 4th parameter must be a valid admin user.\n";
512                 echo $usage;
513                 echo "FAILURE\n";
514                 exit(1);
515         }
516
517
518                 /////retrieve admin user
519         global $sugar_config;
520         $configOptions = $sugar_config['dbconfig'];
521
522
523 ///////////////////////////////////////////////////////////////////////////////
524 ////    UPGRADE PREP
525 prepSystemForUpgradeSilent();
526
527 //repair tabledictionary.ext.php file if needed
528 repairTableDictionaryExtFile();
529
530 $unzip_dir = sugar_cached("upgrades/temp");
531 $install_file = $sugar_config['upload_dir']."/upgrades/patch/".basename($argv[1]);
532
533 $_SESSION['unzip_dir'] = $unzip_dir;
534 $_SESSION['install_file'] = $install_file;
535 $_SESSION['zip_from_dir'] = $zip_from_dir;
536 if(is_dir($unzip_dir.'/scripts'))
537 {
538         rmdir_recursive($unzip_dir.'/scripts');
539 }
540 if(is_file($unzip_dir.'/manifest.php'))
541 {
542         rmdir_recursive($unzip_dir.'/manifest.php');
543 }
544 mkdir_recursive($unzip_dir);
545 if(!is_dir($unzip_dir)) {
546         echo "\n{$unzip_dir} is not an available directory\nFAILURE\n";
547         fwrite(STDERR,"\n{$unzip_dir} is not an available directory\nFAILURE\n");
548         exit(1);
549 }
550
551 unzip($argv[1], $unzip_dir);
552 // mimic standard UW by copy patch zip to appropriate dir
553 copy($argv[1], $install_file);
554 ////    END UPGRADE PREP
555 ///////////////////////////////////////////////////////////////////////////////
556
557 ///////////////////////////////////////////////////////////////////////////////
558 ////    UPGRADE UPGRADEWIZARD
559
560 $zipBasePath = "$unzip_dir/{$zip_from_dir}";
561 $uwFiles = findAllFiles("{$zipBasePath}/modules/UpgradeWizard", array());
562 $destFiles = array();
563
564 foreach($uwFiles as $uwFile) {
565         $destFile = str_replace($zipBasePath."/", '', $uwFile);
566         copy($uwFile, $destFile);
567 }
568 require_once('modules/UpgradeWizard/uw_utils.php'); // must upgrade UW first
569 removeSilentUpgradeVarsCache(); // Clear the silent upgrade vars - Note: Any calls to these functions within this file are removed here
570 logThis("*** SILENT UPGRADE INITIATED.", $path);
571 logThis("*** UpgradeWizard Upgraded  ", $path);
572
573 if(function_exists('set_upgrade_vars')){
574         set_upgrade_vars();
575 }
576
577 if($configOptions['db_type'] == 'mysql'){
578         //Change the db wait_timeout for this session
579         $now_timeout = $db->getOne("select @@wait_timeout");
580         logThis('Wait Timeout before change ***** '.$now_timeout , $path);
581         $db->query("set wait_timeout=28800");   
582         $now_timeout = $db->getOne("select @@wait_timeout");    
583         logThis('Wait Timeout after change ***** '.$now_timeout , $path);
584 }
585
586 ////    END UPGRADE UPGRADEWIZARD
587 ///////////////////////////////////////////////////////////////////////////////
588
589 ///////////////////////////////////////////////////////////////////////////////
590 ////    MAKE SURE PATCH IS COMPATIBLE
591 if(is_file("$unzip_dir/manifest.php")) {
592         // provides $manifest array
593         include("$unzip_dir/manifest.php");
594         if(!isset($manifest)) {
595                 fwrite(STDERR,"\nThe patch did not contain a proper manifest.php file.  Cannot continue.\n\n");
596             exit(1);
597         } else {
598                 copy("$unzip_dir/manifest.php", $sugar_config['upload_dir']."/upgrades/patch/{$zip_from_dir}-manifest.php");
599
600                 $error = validate_manifest($manifest);
601                 if(!empty($error)) {
602                         $error = strip_tags(br2nl($error));
603                         fwrite(STDERR,"\n{$error}\n\nFAILURE\n");
604                         exit(1);
605                 }
606         }
607 } else {
608         fwrite(STDERR,"\nThe patch did not contain a proper manifest.php file.  Cannot continue.\n\n");
609         exit(1);
610 }
611
612 $ce_to_pro_ent = isset($manifest['name']) && ($manifest['name'] == 'SugarCE to SugarPro' || $manifest['name'] == 'SugarCE to SugarEnt' || $manifest['name'] == 'SugarCE to SugarCorp' || $manifest['name'] == 'SugarCE to SugarUlt');
613 $_SESSION['upgrade_from_flavor'] = $manifest['name'];
614
615 global $sugar_config;
616 global $sugar_version;
617 global $sugar_flavor;
618
619 ////    END MAKE SURE PATCH IS COMPATIBLE
620 ///////////////////////////////////////////////////////////////////////////////
621
622 ///////////////////////////////////////////////////////////////////////////////
623 ////    RUN SILENT UPGRADE
624 ob_start();
625 set_time_limit(0);
626 if(file_exists('ModuleInstall/PackageManager/PackageManagerDisplay.php')) {
627         require_once('ModuleInstall/PackageManager/PackageManagerDisplay.php');
628 }
629
630
631         //copy minimum required files including sugar_file_utils.php
632         if(file_exists("{$zipBasePath}/include/utils/sugar_file_utils.php")){
633                 $destFile = clean_path(str_replace($zipBasePath, $cwd, "{$zipBasePath}/include/utils/sugar_file_utils.php"));
634                 copy("{$zipBasePath}/include/utils/sugar_file_utils.php", $destFile);
635         }
636         if(file_exists('include/utils/sugar_file_utils.php')){
637         require_once('include/utils/sugar_file_utils.php');
638     }
639
640 /*
641 $errors = preflightCheck();
642 if((count($errors) == 1)) { // only diffs
643         logThis('file preflight check passed successfully.', $path);
644 }
645 else{
646         fwrite(STDERR,"\nThe user doesn't have sufficient permissions to write to database'.\n\n");
647         exit(1);
648 }
649 */
650 //If version less than 500 then look for modules to be upgraded
651 if(function_exists('set_upgrade_vars')){
652         set_upgrade_vars();
653 }
654 //Initialize the session variables. If upgrade_progress.php is already created
655 //look for session vars there and restore them
656 if(function_exists('initialize_session_vars')){
657         initialize_session_vars();
658 }
659
660 if(!didThisStepRunBefore('preflight')){
661         set_upgrade_progress('preflight','in_progress');
662         //Quickcreatedefs on the basis of editviewdefs
663     if(substr($sugar_version,0,1) >= 5){
664         updateQuickCreateDefs();
665         }
666         set_upgrade_progress('preflight','done');
667 }
668 ////////////////COMMIT PROCESS BEGINS///////////////////////////////////////////////////////////////
669 ////    MAKE BACKUPS OF TARGET FILES
670
671 if(!didThisStepRunBefore('commit')){
672         set_upgrade_progress('commit','in_progress','commit','in_progress');
673         if(!didThisStepRunBefore('commit','commitMakeBackupFiles')){
674                 set_upgrade_progress('commit','in_progress','commitMakeBackupFiles','in_progress');
675                 $errors = commitMakeBackupFiles($rest_dir, $install_file, $unzip_dir, $zip_from_dir, array());
676                 set_upgrade_progress('commit','in_progress','commitMakeBackupFiles','done');
677         }
678
679         //Need to make sure we have the matching copy of SetValueAction for static/instance method matching
680     if(file_exists("include/Expressions/Actions/SetValueAction.php")){
681         require_once("include/Expressions/Actions/SetValueAction.php");
682     }
683
684         ///////////////////////////////////////////////////////////////////////////////
685         ////    HANDLE PREINSTALL SCRIPTS
686         if(empty($errors)) {
687                 $file = "{$unzip_dir}/".constant('SUGARCRM_PRE_INSTALL_FILE');
688
689                 if(is_file($file)) {
690                         include($file);
691                         if(!didThisStepRunBefore('commit','pre_install')){
692                                 set_upgrade_progress('commit','in_progress','pre_install','in_progress');
693                                 pre_install();
694                                 set_upgrade_progress('commit','in_progress','pre_install','done');
695                         }
696                 }
697         }
698
699         //Clean smarty from cache
700         $cachedir = sugar_cached('smarty');
701         if(is_dir($cachedir)){
702                 $allModFiles = array();
703                 $allModFiles = findAllFiles($cachedir,$allModFiles);
704            foreach($allModFiles as $file){
705                 //$file_md5_ref = str_replace(clean_path(getcwd()),'',$file);
706                 if(file_exists($file)){
707                                 unlink($file);
708                 }
709            }
710         }
711
712                 //Also add the three-way merge here. The idea is after the 451 html files have
713                 //been converted run the 3-way merge. If 500 then just run the 3-way merge
714                 if(file_exists('modules/UpgradeWizard/SugarMerge/SugarMerge.php')){
715                     set_upgrade_progress('end','in_progress','threewaymerge','in_progress');
716                     require_once('modules/UpgradeWizard/SugarMerge/SugarMerge.php');
717                     $merger = new SugarMerge($zipBasePath);
718                     $merger->mergeAll();
719                     set_upgrade_progress('end','in_progress','threewaymerge','done');
720                 }
721         ///////////////////////////////////////////////////////////////////////////////
722         ////    COPY NEW FILES INTO TARGET INSTANCE
723
724      if(!didThisStepRunBefore('commit','commitCopyNewFiles')){
725                         set_upgrade_progress('commit','in_progress','commitCopyNewFiles','in_progress');
726                         $split = commitCopyNewFiles($unzip_dir, $zip_from_dir);
727                         $copiedFiles = $split['copiedFiles'];
728                         $skippedFiles = $split['skippedFiles'];
729                         set_upgrade_progress('commit','in_progress','commitCopyNewFiles','done');
730          }
731         require_once(clean_path($unzip_dir.'/scripts/upgrade_utils.php'));
732         $new_sugar_version = getUpgradeVersion();
733     $origVersion = substr(preg_replace("/[^0-9]/", "", $sugar_version),0,3);
734     $destVersion = substr(preg_replace("/[^0-9]/", "", $new_sugar_version),0,3);
735     $siv_varset_1 = setSilentUpgradeVar('origVersion', $origVersion);
736     $siv_varset_2 = setSilentUpgradeVar('destVersion', $destVersion);
737     $siv_write    = writeSilentUpgradeVars();
738     if(!$siv_varset_1 || !$siv_varset_2 || !$siv_write){
739         logThis("Error with silent upgrade variables: origVersion write success is ({$siv_varset_1}) ".
740                         "-- destVersion write success is ({$siv_varset_2}) -- ".
741                         "writeSilentUpgradeVars success is ({$siv_write}) -- ".
742                         "path to cache dir is ({$GLOBALS['sugar_config']['cache_dir']})", $path);
743     }
744      require_once('modules/DynamicFields/templates/Fields/TemplateText.php');
745         ///////////////////////////////////////////////////////////////////////////////
746     ///    RELOAD NEW DEFINITIONS
747     global $ACLActions, $beanList, $beanFiles;
748     include('modules/ACLActions/actiondefs.php');
749     include('include/modules.php');
750         /////////////////////////////////////////////
751
752     if (!function_exists("inDeveloperMode")) {
753         //this function was introduced from tokyo in the file include/utils.php, so when upgrading from 5.1x and 5.2x we should declare the this function
754         function inDeveloperMode()
755         {
756             return isset($GLOBALS['sugar_config']['developerMode']) && $GLOBALS['sugar_config']['developerMode'];
757         }
758     }
759         ///////////////////////////////////////////////////////////////////////////////
760         ////    HANDLE POSTINSTALL SCRIPTS
761         if(empty($errors)) {
762                 logThis('Starting post_install()...', $path);
763
764                 $trackerManager = TrackerManager::getInstance();
765         $trackerManager->pause();
766         $trackerManager->unsetMonitors();
767
768                 if(!didThisStepRunBefore('commit','post_install')){
769                         $file = "$unzip_dir/" . constant('SUGARCRM_POST_INSTALL_FILE');
770                         if(is_file($file)) {
771                                 //set_upgrade_progress('commit','in_progress','post_install','in_progress');
772                                 $progArray['post_install']='in_progress';
773                                 post_install_progress($progArray,'set');
774                                     global $moduleList;
775                                         include($file);
776                                         post_install();
777                                 // cn: only run conversion if admin selects "Sugar runs SQL"
778                                 if(!empty($_SESSION['allTables']) && $_SESSION['schema_change'] == 'sugar')
779                                         executeConvertTablesSql($_SESSION['allTables']);
780                                 //set process to done
781                                 $progArray['post_install']='done';
782                                 //set_upgrade_progress('commit','in_progress','post_install','done');
783                                 post_install_progress($progArray,'set');
784                         }
785                 }
786             //clean vardefs
787                 logThis('Performing UWrebuild()...', $path);
788                 ob_start();
789                         @UWrebuild();
790                 ob_end_clean();
791                 logThis('UWrebuild() done.', $path);
792
793                 logThis('begin check default permissions .', $path);
794                 checkConfigForPermissions();
795             logThis('end check default permissions .', $path);
796
797             logThis('begin check logger settings .', $path);
798                 checkLoggerSettings();
799             logThis('begin check logger settings .', $path);
800
801             logThis('begin check lead conversion settings .', $path);
802             checkLeadConversionSettings();
803             logThis('end check lead conversion settings .', $path);
804
805             logThis('begin check resource settings .', $path);
806                         checkResourceSettings();
807                 logThis('begin check resource settings .', $path);
808
809
810                 require("sugar_version.php");
811                 require('config.php');
812                 global $sugar_config;
813
814                 if($ce_to_pro_ent){
815                         if(isset($sugar_config['sugarbeet']))
816                         {
817                             //$sugar_config['sugarbeet'] is only set in COMM
818                             unset($sugar_config['sugarbeet']);
819                         }
820                     if(isset($sugar_config['disable_team_access_check']))
821                         {
822                             //$sugar_config['disable_team_access_check'] is a runtime configration,
823                             //no need to write to config.php
824                             unset($sugar_config['disable_team_access_check']);
825                         }
826                         if(!merge_passwordsetting($sugar_config, $sugar_version)) {
827                                 logThis('*** ERROR: could not write config.php! - upgrade will fail!', $path);
828                                 $errors[] = 'Could not write config.php!';
829                         }
830
831                 }
832
833                 logThis('Set default_theme to Sugar', $path);
834                 $sugar_config['default_theme'] = 'Sugar';
835
836                 if( !write_array_to_file( "sugar_config", $sugar_config, "config.php" ) ) {
837             logThis('*** ERROR: could not write config.php! - upgrade will fail!', $path);
838             $errors[] = 'Could not write config.php!';
839         }
840
841         logThis('Set default_max_tabs to 7', $path);
842                 $sugar_config['default_max_tabs'] = '7';
843
844                 if( !write_array_to_file( "sugar_config", $sugar_config, "config.php" ) ) {
845             logThis('*** ERROR: could not write config.php! - upgrade will fail!', $path);
846             $errors[] = 'Could not write config.php!';
847         }
848
849                 logThis('Upgrade the sugar_version', $path);
850                 $sugar_config['sugar_version'] = $sugar_version;
851                 if($destVersion == $origVersion)
852                         require('config.php');
853         if( !write_array_to_file( "sugar_config", $sugar_config, "config.php" ) ) {
854             logThis('*** ERROR: could not write config.php! - upgrade will fail!', $path);
855             $errors[] = 'Could not write config.php!';
856         }
857
858                 logThis('post_install() done.', $path);
859         }
860
861         ///////////////////////////////////////////////////////////////////////////////
862         ////    REGISTER UPGRADE
863         if(empty($errors)) {
864                 logThis('Registering upgrade with UpgradeHistory', $path);
865                 if(!didThisStepRunBefore('commit','upgradeHistory')){
866                         set_upgrade_progress('commit','in_progress','upgradeHistory','in_progress');
867                         $file_action = "copied";
868                         // if error was encountered, script should have died before now
869                         $new_upgrade = new UpgradeHistory();
870                         $new_upgrade->filename = $install_file;
871                         $new_upgrade->md5sum = md5_file($install_file);
872                         $new_upgrade->name = $zip_from_dir;
873                         $new_upgrade->description = $manifest['description'];
874                         $new_upgrade->type = 'patch';
875                         $new_upgrade->version = $sugar_version;
876                         $new_upgrade->status = "installed";
877                         $new_upgrade->manifest = (!empty($_SESSION['install_manifest']) ? $_SESSION['install_manifest'] : '');
878
879                         if($new_upgrade->description == null){
880                                 $new_upgrade->description = "Silent Upgrade was used to upgrade the instance";
881                         }
882                         else{
883                                 $new_upgrade->description = $new_upgrade->description." Silent Upgrade was used to upgrade the instance.";
884                         }
885                    $new_upgrade->save();
886                    set_upgrade_progress('commit','in_progress','upgradeHistory','done');
887                    set_upgrade_progress('commit','done','commit','done');
888                 }
889           }
890
891         //Clean modules from cache
892             $cachedir = sugar_cached('smarty');
893                 if(is_dir($cachedir)){
894                         $allModFiles = array();
895                         $allModFiles = findAllFiles($cachedir,$allModFiles);
896                    foreach($allModFiles as $file){
897                         //$file_md5_ref = str_replace(clean_path(getcwd()),'',$file);
898                         if(file_exists($file)){
899                                         unlink($file);
900                         }
901                    }
902                 }
903    //delete cache/modules before rebuilding the relations
904         //Clean modules from cache
905             $cachedir = sugar_cached('modules');
906                 if(is_dir($cachedir)){
907                         $allModFiles = array();
908                         $allModFiles = findAllFiles($cachedir,$allModFiles);
909                    foreach($allModFiles as $file){
910                         //$file_md5_ref = str_replace(clean_path(getcwd()),'',$file);
911                         if(file_exists($file)){
912                                         unlink($file);
913                         }
914                    }
915                 }
916
917                 //delete cache/themes
918                 $cachedir = sugar_cached('themes');
919                 if(is_dir($cachedir)){
920                         $allModFiles = array();
921                         $allModFiles = findAllFiles($cachedir,$allModFiles);
922                    foreach($allModFiles as $file){
923                         //$file_md5_ref = str_replace(clean_path(getcwd()),'',$file);
924                         if(file_exists($file)){
925                                         unlink($file);
926                         }
927                    }
928                 }
929         ob_start();
930         if(!isset($_REQUEST['silent'])){
931                 $_REQUEST['silent'] = true;
932         }
933         else if(isset($_REQUEST['silent']) && $_REQUEST['silent'] != true){
934                 $_REQUEST['silent'] = true;
935         }
936
937          //logThis('Checking for leads_assigned_user relationship and if not found then create.', $path);
938         @createMissingRels();
939          //logThis('Checked for leads_assigned_user relationship.', $path);
940         ob_end_clean();
941         //// run fix on dropdown lists that may have been incorrectly named
942     //fix_dropdown_list();
943 }
944
945 set_upgrade_progress('end','in_progress','end','in_progress');
946 /////////////////////////Old Logger settings///////////////////////////////////////
947 ///////////////////////////////////////////////////////////////////////////////
948
949 if(function_exists('deleteCache')){
950         set_upgrade_progress('end','in_progress','deleteCache','in_progress');
951         @deleteCache();
952         set_upgrade_progress('end','in_progress','deleteCache','done');
953 }
954
955 ///////////////////////////////////////////////////////////////////////////////
956 ////    HANDLE REMINDERS
957 if(empty($errors)) {
958         commitHandleReminders($skippedFiles, $path);
959 }
960
961 if(file_exists(clean_path(getcwd()).'/original451files')){
962         rmdir_recursive(clean_path(getcwd()).'/original451files');
963 }
964
965 require_once('modules/Administration/Administration.php');
966 $admin = new Administration();
967 $admin->saveSetting('system','adminwizard',1);
968
969
970 if($ce_to_pro_ent)
971 {
972         //check to see if there are any new files that need to be added to systems tab
973         //retrieve old modules list
974         logThis('check to see if new modules exist',$path);
975         $oldModuleList = array();
976         $newModuleList = array();
977         include($argv[3].'/include/modules.php');
978         $oldModuleList = $moduleList;
979         include('include/modules.php');
980         $newModuleList = $moduleList;
981
982         //include tab controller
983         require_once('modules/MySettings/TabController.php');
984         $newTB = new TabController();
985
986         //make sure new modules list has a key we can reference directly
987         $newModuleList = $newTB->get_key_array($newModuleList);
988         $oldModuleList = $newTB->get_key_array($oldModuleList);
989
990         //iterate through list and remove commonalities to get new modules
991         foreach ($newModuleList as $remove_mod){
992             if(in_array($remove_mod, $oldModuleList)){
993                 unset($newModuleList[$remove_mod]);
994             }
995         }
996
997         $must_have_modules= array(
998                           'Activities'=>'Activities',
999                   'Calendar'=>'Calendar',
1000                   'Reports' => 'Reports',
1001                           'Quotes' => 'Quotes',
1002                           'Products' => 'Products',
1003                           'Forecasts' => 'Forecasts',
1004                           'Contracts' => 'Contracts',
1005                           'KBDocuments' => 'KBDocuments'
1006         );
1007         $newModuleList = array_merge($newModuleList,$must_have_modules);
1008
1009         //new modules list now has left over modules which are new to this install, so lets add them to the system tabs
1010         logThis('new modules to add are '.var_export($newModuleList,true),$path);
1011
1012         //grab the existing system tabs
1013         $tabs = $newTB->get_system_tabs();
1014
1015         //add the new tabs to the array
1016         foreach($newModuleList as $nm ){
1017           $tabs[$nm] = $nm;
1018         }
1019
1020         //now assign the modules to system tabs
1021         $newTB->set_system_tabs($tabs);
1022         logThis('module tabs updated',$path);
1023 }
1024
1025 //Also set the tracker settings if  flavor conversion ce->pro or ce->ent
1026 if(isset($_SESSION['current_db_version']) && isset($_SESSION['target_db_version'])){
1027         if($_SESSION['current_db_version'] == $_SESSION['target_db_version']){
1028             $_REQUEST['upgradeWizard'] = true;
1029             ob_start();
1030                         include('include/Smarty/internals/core.write_file.php');
1031                 ob_end_clean();
1032                 $db =& DBManagerFactory::getInstance();
1033                 if($ce_to_pro_ent){
1034                 //Also set license information
1035                 $admin = new Administration();
1036                         $category = 'license';
1037                         $value = 0;
1038                         $admin->saveSetting($category, 'users', $value);
1039                         $key = array('num_lic_oc','key','expire_date');
1040                         $value = '';
1041                         foreach($key as $k){
1042                                 $admin->saveSetting($category, $k, $value);
1043                         }
1044                 }
1045         }
1046 }
1047
1048         $phpErrors = ob_get_contents();
1049         ob_end_clean();
1050         logThis("**** Potential PHP generated error messages: {$phpErrors}", $path);
1051
1052         if(count($errors) > 0) {
1053                 foreach($errors as $error) {
1054                         logThis("****** SilentUpgrade ERROR: {$error}", $path);
1055                 }
1056                 echo "FAILED\n";
1057         }
1058
1059
1060 }
1061
1062
1063 /**
1064  * repairTableDictionaryExtFile
1065  *
1066  * There were some scenarios in 6.0.x whereby the files loaded in the extension tabledictionary.ext.php file
1067  * did not exist.  This would cause warnings to appear during the upgrade.  As a result, this
1068  * function scans the contents of tabledictionary.ext.php and then remove entries where the file does exist.
1069  */
1070 function repairTableDictionaryExtFile()
1071 {
1072         $tableDictionaryExtDirs = array('custom/Extension/application/Ext/TableDictionary', 'custom/application/Ext/TableDictionary');
1073
1074         foreach($tableDictionaryExtDirs as $tableDictionaryExt)
1075         {
1076
1077                 if(is_dir($tableDictionaryExt) && is_writable($tableDictionaryExt)){
1078                         $dir = dir($tableDictionaryExt);
1079                         while(($entry = $dir->read()) !== false)
1080                         {
1081                                 $entry = $tableDictionaryExt . '/' . $entry;
1082                                 if(is_file($entry) && preg_match('/\.php$/i', $entry) && is_writeable($entry))
1083                                 {
1084
1085                                                 if(function_exists('sugar_fopen'))
1086                                                 {
1087                                                         $fp = @sugar_fopen($entry, 'r');
1088                                                 } else {
1089                                                         $fp = fopen($entry, 'r');
1090                                                 }
1091
1092
1093                                             if($fp)
1094                                         {
1095                                              $altered = false;
1096                                              $contents = '';
1097
1098                                              while($line = fgets($fp))
1099                                                      {
1100                                                         if(preg_match('/\s*include\s*\(\s*[\'|\"](.*?)[\"|\']\s*\)\s*;/', $line, $match))
1101                                                         {
1102                                                            if(!file_exists($match[1]))
1103                                                            {
1104                                                               $altered = true;
1105                                                            } else {
1106                                                                   $contents .= $line;
1107                                                            }
1108                                                         } else {
1109                                                            $contents .= $line;
1110                                                         }
1111                                                      }
1112
1113                                                      fclose($fp);
1114                                         }
1115
1116
1117                                             if($altered)
1118                                             {
1119                                                         if(function_exists('sugar_fopen'))
1120                                                         {
1121                                                                 $fp = @sugar_fopen($entry, 'w');
1122                                                         } else {
1123                                                                 $fp = fopen($entry, 'w');
1124                                                         }
1125
1126                                                         if($fp && fwrite($fp, $contents))
1127                                                         {
1128                                                                 fclose($fp);
1129                                                         }
1130                                             }
1131                                 } //if
1132                         } //while
1133                 } //if
1134         }
1135 }
1136
1137
1138 ?>